def updated_category(): id_dm = request.args.get("id_dm", type=int) ten_dm = request.form.get("ten_dm") sql = f"update db_danhmuc set ten_dm = N'{ten_dm}'where id_dm = {id_dm}" cursor.execute(sql) connection.commit() return redirect("/admin/category")
def product(): id_sach = request.args.get("id_sach", type=int) sql = f"SELECT * from search_categories where id_sach = {id_sach};" cursor.execute(sql) rs = cursor.fetchall() sql_lq = f"select * from search_minmax_tacgia WHERE id_dm IN (SELECT id_dm FROM db_sach WHERE id_sach = {id_sach}) or id_tacgia IN (SELECT id_tacgia FROM db_sach WHERE id_sach = {id_sach}) limit 4;" cursor.execute(sql_lq) lq = cursor.fetchall() connection.commit() return render_template("product.html", rs=rs, lq=lq)
def inserted_product(): ten_sach = request.form.get("ten_sach") id_tacgia = request.form.get("id_tacgia") gia_sach = request.form.get("gia_sach") soluong = request.form.get("soluong") so_sao = request.form.get("so_sao") mota = request.form.get("mota") trang_thai = request.form.get("trang_thai") id_dm = request.form.get("id_dm") sql = f"insert into db_sach(ten_sach,id_tacgia,gia_sach,soluong,so_sao,mota,trang_thai,id_dm) values(N'{ten_sach}', {id_tacgia}, {gia_sach},{soluong},{so_sao},'{mota}',{trang_thai},{id_dm})" cursor.execute(sql) connection.commit() return redirect("/admin/product")
def inserted_img(): img = "" id_sach = request.form.get("id_sach") for uploaded_file in request.files.getlist("link_img"): if uploaded_file.filename != "": img = uploaded_file.filename print(uploaded_file.filename) uploaded_file.save( os.path.join("static/imgs", uploaded_file.filename)) sql = f"insert into img_sach(link_img, id_sach) values('../static/imgs/{img}', '{id_sach}')" cursor.execute(sql) connection.commit() return redirect("/admin/img")
def updated_product(): id_sach = request.args.get("id_sach", type=int) ten_sach = request.form.get("ten_sach") id_tacgia = request.form.get("id_tacgia") gia_sach = request.form.get("gia_sach") soluong = request.form.get("soluong") so_sao = request.form.get("so_sao") mota = request.form.get("mota") trang_thai = request.form.get("trang_thai") id_dm = request.form.get("id_dm") sql = f"update db_sach set ten_sach = N'{ten_sach}',id_tacgia={id_tacgia}, gia_sach={gia_sach}, soluong={soluong}, so_sao={so_sao}, mota=N'{mota}', trang_thai={trang_thai},id_dm={id_dm} where id_sach = {id_sach}" cursor.execute(sql) connection.commit() return redirect("/admin/product")
def updated_img(): id_img = request.args.get("id_img", type=int) id_sach = request.form.get("id_sach") img = "" for uploaded_file in request.files.getlist("link_img"): if uploaded_file.filename != "": img = uploaded_file.filename print(uploaded_file.filename) uploaded_file.save( os.path.join("static/imgs", uploaded_file.filename)) sql = f"update img_sach set link_img = '../static/imgs/{img}', id_sach = '{id_sach}' where id_img = {id_img}" cursor.execute(sql) connection.commit() return redirect("/admin/img")
def updated(): id_tacgia = request.args.get("id_tacgia", type=int) ten_tacgia = request.form.get("ten_tacgia") gioithieu = request.form.get("gioithieu") avt_tacgia = "" for uploaded_file in request.files.getlist("avt_tacgia"): if uploaded_file.filename != "": avt_tacgia = uploaded_file.filename print(uploaded_file.filename) uploaded_file.save( os.path.join("static/imgs", uploaded_file.filename)) sql = f"update db_tacgia set ten_tacgia = N'{ten_tacgia}', avt_tacgia = '../static/imgs/{avt_tacgia}', gioi_thieu = N'{gioithieu}' where id_tacgia = {id_tacgia}" cursor.execute(sql) connection.commit() return redirect("/admin/author")
def inserted_actor(): avt = "" for uploaded_file in request.files.getlist("avt_tacgia"): if uploaded_file.filename != "": avt = uploaded_file.filename print(uploaded_file.filename) uploaded_file.save( os.path.join("static/imgs", uploaded_file.filename)) ten_tacgia = request.form.get("ten_tacgia") gioi_thieu = request.form.get("gioithieu") sql = f"insert into db_tacgia(ten_tacgia, avt_tacgia, gioi_thieu) values(N'{ten_tacgia}', '../static/imgs/{avt}', N'{gioi_thieu}')" cursor.execute(sql) connection.commit() return redirect("/admin/author")
def sendData(taskId,userId,output): # write output to a new json file with open('../output/' + taskId + '.json', 'w') as outfile: json.dump(output, outfile) # tell the database that we've finished processing try: cursor = connection.cursor() sql = "UPDATE Task SET taskState = 2 WHERE taskId = " + taskId cursor.execute(sql) connection.commit() except Exception as e: print(e) finally: cursor.close() connection.close()
def signup_dk(): us = request.form.get("user_name") pa = request.form.get("pass_word") rpa = request.form.get("rpass_word") email = request.form.get("email") sdt = request.form.get("sdt") if len(pa) < 6: err = 'Mật khẩu phải lớn hơn 6 kí tự' elif pa != rpa: err = 'Mật khẩu không trùng nhau' else: sql = f"select * from db_user where us like '{us}'" cursor.execute(sql) connection.commit() record = cursor.fetchall() if len(record) == 0: sql_signup = f"insert into db_user(us, email, sdt, pa) values('{us}', '{email}', '{sdt}', '{pa}')" cursor.execute(sql_signup) connection.commit() return redirect("/login") else: err = 'Tài khoản đã tồn tại' return render_template("signup.html", err=err)
def shop(): keyword = request.args.get("search", type=str) max_s = request.args.get("max", type=int) min_s = request.args.get("min", type=int) dm = request.args.get("dm", type=int) tg = request.args.get("tg", type=int) sql = f"SELECT * FROM shop;" if keyword != None: sql = f"select * from search_keyword WHERE ten_sach LIKE N'%{keyword}%' OR ten_dm LIKE N'%{keyword}%' OR ten_tacgia LIKE N'%{keyword}%';" elif max_s != None and min_s != None: sql = f"select * from search_minmax_tacgia WHERE gia_sach BETWEEN '{min_s}' AND '{max_s}';" elif dm != None: sql = f"select * from search_categories where id_dm = {dm};" elif tg != None: sql = f"select * from search_minmax_tacgia where id_tacgia = {tg};" cursor.execute(sql) record = cursor.fetchall() sql_tacgia = f"select * from db_tacgia;" cursor.execute(sql_tacgia) record_tacgia = cursor.fetchall() sql_count_tacgia = f"select * from count_author" cursor.execute(sql_count_tacgia) record_count_tacgia = cursor.fetchall() sql_danhmuc = f"select * from db_danhmuc;" cursor.execute(sql_danhmuc) record_danhmuc = cursor.fetchall() sql_count_danhmuc = f"select * from count_category" cursor.execute(sql_count_danhmuc) record_count_danhmuc = cursor.fetchall() connection.commit() return render_template("shop.html", record_tacgia=record_tacgia, record_count_tacgia=record_count_tacgia, record_danhmuc=record_danhmuc, record_count_danhmuc=record_count_danhmuc, record=record)
with open(os.path.join(input_subdir, json_name), 'r') as json_file: incomingData = json.load(json_file) for key, value in incomingData.items(): if key == 'taskId': taskId = value elif key == 'userId': userId = value else: boxes.append(value) # tell the database that we've started processing try: cursor = connection.cursor() sql = "UPDATE Task SET taskState = 0 WHERE taskId = " + taskId cursor.execute(sql) connection.commit() cursor.close() except Exception as e: print(e) quit() width, height = img.shape[:2] gauges=[] for box in boxes: gaugeType=str(box.get('gaugeType')) cx1=int(float(box.get('coordinates').get('start_x'))*height) cy1=int(float(box.get('coordinates').get('start_y'))*width) cx2=int(float(box.get('coordinates').get('end_x'))*height) cy2=int(float(box.get('coordinates').get('end_y'))*width) print(cy1)
def delete_product(): id_sach = request.args.get("id_sach", type=int) sql = f"delete from db_sach where id_sach = {id_sach}" cursor.execute(sql) connection.commit() return redirect("/admin/product")
def delete(): id_tacgia = request.args.get("id_tacgia", type=int) sql = f"delete from db_tacgia where id_tacgia = {id_tacgia}" cursor.execute(sql) connection.commit() return redirect("/admin/author")
def delete_category(): id_dm = request.args.get("id_dm", type=int) sql = f"delete from db_danhmuc where id_dm = {id_dm}" cursor.execute(sql) connection.commit() return redirect("/admin/category")
def inserted_category(): ten_dm = request.form.get("ten_dm") sql = f"insert into db_danhmuc(ten_dm, trang_thai) values(N'{ten_dm}', '1')" cursor.execute(sql) connection.commit() return redirect("/admin/category")
def delete_img(): id_img = request.args.get("id_img", type=int) sql = f"delete from img_sach where id_img = {id_img}" cursor.execute(sql) connection.commit() return redirect("/admin/img")