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