def export():
try:
word = request.args.get('word')
jobs = db.get(word)
save_to_file(jobs)
return send_file("jobs.csv")
except:
return redirect("/")
def get_jobs(word):
URL = f"https://kr.indeed.com/취업?q={word}&limit={LIMIT}"
last_page = get_last_pages(URL)
if last_page == None:
return []
else:
jobs = extract_jobs(last_page, URL)
save_to_file(jobs)
return jobs
def export():
try:
word = request.args.get("word")
if not word:
raise Exception() #word가 존재하지 않으면 except를 수행시킨다.
jobs = db.get(word)
if not jobs:
raise Exception() #word가 있긴하나 db는 없다면
save_to_file(jobs)
return send_file("jobs.csv")
except:
return redirect("/")
def export():
try:
word = request.args.get('word').lower()
if not word:
raise Exception()
jobs = db.get(word)
if not jobs:
raise Exception()
save_to_file(jobs)
return send_file("jobs.csv")
except:
return redirect("/")
def export():
try:
word = request.args.get("word")
if not word:
raise Exception()
jobs = db.get(word)
if not jobs:
raise Exception()
save_to_file(jobs)
# Use send_file library to file export
return send_file("jobs.csv")
except:
return redirect("/")
def export():
try:
keyword = request.args.get("search")
if not keyword:
raise Exception()
keyword = keyword.lower()
jobs = db.get(keyword)
if not jobs:
raise Exception()
save_to_file(jobs)
return send_file("jobs.csv")
except:
return redirect("/")
def export():
try:
term = request.args.get("term")
if not term:
raise Exception()
term = term.lower()
all_jobs = db.get(term)
if not all_jobs:
raise Exception()
save_to_file(all_jobs)
return send_file("jobs.csv")
except:
return redirect("/")
def export():
try:
word = request.args.get('word') #export로 간다면 첫번째로 해당 word가 url에 있는지 체크.
if not word:
raise Exception()
word = word.lower() #검색어를 소문자로 만들어준다.
jobs = db.get(word) #fake DB에 저장.
if not jobs: #word에 해당하는 jobs값이 없으면 홈으로 redirect
raise Exception()
save_to_file(jobs) #jobs가 fake DB에 있으면 save_to_file 함수를 실행
return send_file("jobs.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)
return send_file("jobs.csv",mimetype='text/csv',attachment_filename=f"{word}.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)
return f"lalala"
except:
return redirect("/")
def export():
try:
searchword = request.args.get('searchword')
if not searchword: #검색어없으면 예외로
raise Exception()
searchword = searchword.lower()
fromDB = db.get(searchword)
if not fromDB: #데이터베이스에 없으면 예외로
raise Exception()
save_to_file(fromDB)
return send_file("downloadjobs.csv")
except: #예외로 오면 밑에 코드 처리
return redirect("/")
def export():
try:
job = request.args.get('search')
if not job:
raise Exception()
job = job.lower()
jobs = db[job]
if not jobs:
raise Exception()
save_to_file(jobs)
return send_file("jobs.csv")
except:
return redirect("/")
def export():
try:
searching_job = request.args.get('word')
searching_job = searching_job.lower()
if not searching_job:
raise Exception()
jobs = db.get(searching_job)
if not jobs:
raise Exception()
save_to_file(jobs)
return send_file("jobs.csv")
except:
return redirect("/")
def export2():
try:
word = request.args.get('word')
posted_date = request.args.get("posted_date")
if not word:
raise Exception()
jobs = get_jobs_glassdoor(word, posted_date)
if not jobs:
raise Exception()
save_to_file(jobs)
return send_file("jobs.csv")
except:
return redirect("/")
def export():
try:
word = request.args.get('word')
if not word: # 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:
term = request.args.get("term")
if not term:
raise Exception()
term = term.lower()
jobs = db.get(term)
if not jobs:
raise Exception()
save_to_file(jobs, term)
return send_file(f"./{term}.csv", as_attachment=True)
except:
return redirect("/")
def export():
try: # 실행 후 에러 발생시 except 실행
word = request.args.get('word')
if not word: # 만약 word가 존재하지 않는다면 아래 코드 실행.
raise Exception() # raise로 에러 발생시 바로 except 실행
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:
word = request.args.get("word")
if not word:
raise Exception()
word = word.lower()
jobs = existJob.get(word)
if not jobs:
raise Exception()
save_to_file(jobs)
return send_file('jobs.csv', mimetype='application/x-csv', attachment_filename='report.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 f"Generate CSV for {word}"
except:
return redirect("/")
def export():
try:
word = request.args.get('word')
if not word:
raise Exception()
word = word.capitalize()
jobs = fakeDB.get(word)
if not jobs:
raise Exception()
save_to_file(jobs,word)
return send_file("jobs.csv", mimetype = 'text/csv; charset=x-EBCDIC-KoreanAndKoreanExtended')
except:
return redirect("/")
def export():
try: # try의 코드를 실행하다가 에러가 나면 except의 코드가 실행됨
word = request.args.get("word")
if not word:
raise Exception() # 만약 word가 존재하지 않으면 exception을 발생시킴
word = word.lower()
news = db.get(word)
if not news:
raise Exception()
save_to_file(news)
return send_file("news.csv")
except:
return redirect("/")
def export():
try:
query = request.args.get('query')
if not query:
raise Exception()
query = query.lower()
jobs = db.get(query)
if not jobs:
raise Exception()
save_to_file(query, jobs)
return send_file(f"{query}_jobs.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)
return send_file("jobs.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)
file_name = word + ".csv"
return send_file(attachment_filename=file_name, as_attachment=True)
except:
return redirect("/")
def export():
try:
job_name = request.args.get("job")
if not job_name:
raise Exception()
job_name = job_name.lower()
jobs = db.get(job_name)
if not jobs:
raise Exception()
save_to_file(jobs, job_name)
return send_file(f"{job_name}.csv")
except Exception as e:
print(str(e))
return redirect("/")
def export():
try:
term = request.args.get('term')
term = term.lower()
jobs = db.get(term)
if not jobs:
raise Exception()
file_name = f"{term}.csv"
save_to_file(term, jobs)
return send_file(file_name,
as_attachment=True,
attachment_filename=file_name)
except:
return redirect("/")
def search():
term = request.args.get('term')
term = term.lower()
existingJobs = db.get(term)
if existingJobs:
jobs = existingJobs
else:
jobs = so_get_jobs(term) + we_get_jobs(term) + re_get_jobs(term)
db[term] = jobs
save_to_file(term, jobs)
return render_template("search.html",
jobs=jobs,
jobs_cnt=len(jobs),
term=term)
def export():
try:
search_language = request.args.get('term',None)
if not search_language:
raise Exception()
search_language = search_language.lower()
jobs = fakeDB.get(search_language)
if not jobs:
raise Exception()
save_to_file(jobs, search_language)
file_name = f"{search_language}.csv"
return send_file(file_name,mimetype='text/csv', attachment_filename=f'{search_language}.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()
filename = f"{word}.csv"
save_to_file(jobs, filename)
return send_file(filename)
except:
return redirect("/")
def export():
try:
word = request.args.get('word')
if not word:
raise Exception() # Exception()이 실행되면 아래의 except 구분 실행
print(word)
word = word.lower()
jobs = db.get(word)
print(jobs)
if not jobs:
raise Exception()
save_to_file(jobs)
return send_file("jobs.csv")
except:
return redirect("/")
