for i in range(100):
test_list.append(data_list[i])
print "處理資料..."
size = len(data_list)
count = 0
for data in data_list:
result = ResultModel()
result.nid = data.nid
result.title = data.title
result.field_data_field_body = data.field_body_value
result.link = data.link
result.field_revision_field_resource_description_g = data.field_resource_description_g_value
result.field_data_field_resource_url_g = data.field_resource_url_g_url
result.taxonomy_term_data = data.name
try:
res = Downloader.download(data.field_resource_url_g_url)
result.status = res.status_code
#result.type = data.name
if res.status_code == 200:
try:
result.type = Downloader.getFileNameNExtension(res)
#result.type = Checker.checkExtension(file_name, data)
except NotFileException, e:
print e
try:
result.type = Downloader.getFileExtension(res)
except NoExceptionFound, e:
print e
size = len(data_list)
count = 0
results = []
count = 0
for v in data_list:
result = ResultModel()
result.nid = v.nid
result.title = v.title
result.field_data_field_body = v.field_body_value
result.link = v.link
result.field_revision_field_resource_description_g = v.field_resource_description_g_value
result.field_data_field_resource_url_g = v.field_resource_url_g_url
result.taxonomy_term_data = v.name
try:
res = Downloader.download(v.field_resource_url_g_url)
result.status = res.status_code
if res.status_code == 200:
try:
result.type = Downloader.getFileNameNExtension(res)
except NotFileException, e:
print e
try:
result.type = Downloader.getFileExtension(res)
except NoExceptionFound, e:
print e
result.type = Downloader.guessExtension(res)
# save file
url = v.field_resource_url_g_url
for col in range(number_of_columns):
value = (sheet.cell(row,col).value)
if col == 0:
model.nid = value
elif col == 1:
model.title = value
elif col == 2:
model.field_data_field_body = value
elif col == 3:
model.link = value
elif col == 4:
model.field_revision_field_resource_description_g = value
elif col == 5:
model.field_data_field_resource_url_g = value
elif col == 6:
model.taxonomy_term_data = value
elif col == 7:
model.status = value
elif col == 8:
model.type = value
#print model.title
values.append(model)
size = 0
for v in values:
if v.status == u'-1':
size+=1
result = []
count = 0
