def export():
term = request.args.get("term")
if term:
term = term.lower()
jobs = db.get(term)
if jobs:
save_to_file(jobs, term)
return send_file(f"./csv/{term}.csv", as_attachment=True)
else:
return redirect("/")
def export():
try:
word = request.args.get('word')
if not word:
raise Exception()
word = word.lower()
jobs = db.get(word)
if not jobs:
raise Exception()
save_to_file(jobs)
return send_file('jobs.csv')
except: return redirect("/")
def export():
try:
key = request.args.get("key")
if not key:
raise Exception()
key = key.lower()
jobs = db.get(key)
if not jobs:
raise Exception()
save_to_file(jobs, key)
return send_file("jobs.csv")
except:
return redirect("/")
def export():
try:
word = request.args.get('gogo')
if not word:
raise Exception()
word = word.lower()
jobs = db.get(word)
if not jobs:
raise Exception()
#return f"Generate CSV for {word}"
save_to_file(jobs)
return send_file("jobs.csv")
except:
return redirect("/") #에러나면 첫페이지로 보내
def export():
try:
keyword = request.args.get('keyword')
if not keyword:
# keyword가 존재하지 않으면 Exception을 발생시킴
raise Exception()
keyword = keyword.lower()
jobs = db.get(keyword)
if not jobs:
# 해당하는 jobs가 존재하지 않으면 Exception을 발생시킴
raise Exception()
save_to_file(jobs)
return send_file("jobs.csv")
except:
return redirect("/")
def export():
strarea = request.args.get('area')
# print(strarea)
if strarea:
sql = f"SELECT * FROM Alba where binary(place) like '%{strarea}%';"
curs.execute(sql)
result = curs.fetchall()
if result:
jobs = result
job = make_list(jobs)
save_to_file(job)
return send_file("alba.csv")
else:
return redirect("/")
def export():
try:
word = request.args.get('word')
if not word:
raise Exception()
word = word.lower()
jobs = db.get(word)
if not jobs:
raise Exception()
save_to_file(jobs)
return send_file('jobs.csv',
mimetype='application/x-csv',
attachment_filename='summary_report.csv',
as_attachment=True)
except:
return redirect("/")
def export():
try :
keyword = request.args.get("keyword")
if not keyword:
raise Exception()
jobs = db.get(keyword)
if not keyword:
raise Exception()
save_to_file(jobs)
return send_file("jobs.csv",
attachment_filename=f"{keyword}.csv",
as_attachment=True)
except :
return redirect("/")
def export():
try:
word = request.args.get("word")
if not word:
raise Exception()
word = word.lower()
jobs = db.get(word)
if not jobs:
raise Exception()
save_to_file(jobs, word)
return send_file(f"{word}.csv")
except:
return redirect("/")
if word:
word = word.lower()
def export():
try:
word = request.args.get("word")
if not word:
raise Exception()
word = word.lower()
existingJobs = db.get(word)
if existingJobs:
total_jobs = existingJobs
else:
so_jobs = get_so_jobs(word)
we_jobs = get_we_jobs(word)
ok_jobs = get_ok_jobs(word)
total_jobs = {"so": so_jobs, "we": we_jobs, "ok": ok_jobs}
db[word] = total_jobs
print(total_jobs)
save_to_file(total_jobs)
return send_file("jobs.csv")
except:
return redirect("/")
