def searchForMultipleWords(keyword_list, frontFileName): endFileName = "_output.txt" full_output_path = "".join((frontFileName, endFileName)) titleList = [] descList = [] catList = [] seen_titles = OrderedSet() seen_desc = OrderedSet() seen_cat = [] for keyword in keyword_list: titleList_temp, descList_temp, catList_temp = checkIfStringExistsInCSV( keyword) titleList += titleList_temp descList += descList_temp catList += catList_temp unique_categories_list = OrderedSet(catList) for title1, description1, category1 in zip(titleList, descList, catList): if title1 not in seen_titles and description1 not in seen_desc: seen_titles.add(title1) seen_desc.add(description1) seen_cat.append(category1) with open(full_output_path, "at", encoding="utf-8") as text_file: for unique_category in unique_categories_list: text_file.write("\n%s:\n\n" % unique_category) for title, desc, cat in zip(seen_titles, seen_desc, seen_cat): if cat == unique_category: text_file.write("\n\nTitle: %s\n\nDescription: %s\n\n" % (title, desc)) else: pass
dlux/excitedigitalmedia/g/ if 'date' in key: value = str(value).replace('.000Z','').replace('T',' ') dlux/excitedigitalmedia/g/ try: if value.encode('utf-8')=="None": value == '' new_row.append(value.encode('utf-8')) except AttributeError: if str(value)=="None": dlux/excitedigitalmedia/g/ value == '' new_row.append(str(value)) dlux/excitedigitalmedia/g/ keys.add(key) dlux/excitedigitalmedia/g/ #data_row = new_row.split(',') dlux/excitedigitalmedia/g/ data.append(new_row) #Upload data to DB upload(data,keys,stage) dlux/excitedigitalmedia/g/ def upload(data,keys,stage): dlux/excitedigitalmedia/g/ #build query based off of keys/stage dlux/excitedigitalmedia/g/ columns = []