print "DB取得資料..."
db = Dao()
data_list = db.getRows()
# 下載連結
result_list = []
test_list = []
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_list = []
test_list = []
for i in range(100):
test_list.append(data_list[i])
print "處理資料..."
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:
__author__ = 'johnnytsai'
wb = open_workbook('Result2.xlsx')
values = []
for sheet in wb.sheets():
number_of_rows = sheet.nrows
number_of_columns = sheet.ncols
print number_of_rows
items = []
rows = []
for row in range(1, number_of_rows):
model = ResultModel()
if row != 1:
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
