def remove_song(name: str, username: str):
if get_song_creator(name) == username:
c.execute("DELETE from Songs WHERE name=%s", (str(name), ))
db.commit()
users.remove_uploaded_number(username)
print(f"[Songs Table] Deleted entry {name} by {username}")
else:
main.abort(403)
def add_song_and_detect_service(url: str, username: str):
if users.get_uploaded_number(username) == 5:
main.abort(429)
else:
result = urlparse(url)
if (result.netloc == "www.youtube.com" or result.netloc == "youtu.be"):
add_song_info_from_yt_id(get_id_from_url(url), username)
users.add_uploaded_number(username)
elif (result.netloc == "open.spotify.com"):
add_song_info_from_spotify_url(url, username)
users.add_uploaded_number(username)
else:
main.abort(400)
def callback():
# get X-Line-Signature header value
signature = request.headers['X-Line-Signature']
# get request body as text
body = request.get_data(as_text=True)
app.logger.info("Request body: " + body)
# handle webhook body
try:
handler.handle(body, signature)
except InvalidSignatureError:
abort(400)
return 'OK'
def project_view():
idx = request.args.get("idx")
if idx is not None:
col = mongo.db.version_list_customer
data = col.find_one({"_id": ObjectId(idx)})
result = {
"id": data.get("_id"),
"project_name1": data.get("project_name1"),
"project_name2": data.get("project_name2"),
"name": data.get("name"),
"startdate": data.get("startdate"),
"enddate": data.get("enddate"),
"author": data.get("author"),
"pubdate": data.get("pubdate")
}
#return(result['project_name'])
return render_template("project_view.html", result=result)
return abort(400)
def board_view():
idx = request.args.get("idx")
page = request.args.get("page", 1, type=int)
search = request.args.get("search", -1, type=int)
keyword = request.args.get("keyword", "", type=str)
if idx is not None:
board = mongo.db.board
#data = board.find_one({"_id": ObjectId(idx)})
data = board.find_one_and_update({"_id": ObjectId(idx)}, {"$inc": {"view": 1}}, return_document=True)
if data is not None:
result = {
"id": data.get("_id"),
"name": data.get("name"),
"title": data.get("title"),
"contents": data.get("contents"),
"pubdate": data.get("pubdate"),
"writer_id": data.get("writer_id", "")
}
return render_template("view.html", result=result, page=page, search=search, keyword=keyword, title="글 상세보기")
return abort(400)
def check_login():
if 'logged_in' in main.session:
return True
else:
return main.abort(401)