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 = []
