def option_saveOrder(Form, local): menu_list = [] for key in Form.keys(): if key.startswith('menu_'): menu_list.append([key[5:], Form.get(key)]) print("menu_list:", menu_list) if Form.get("payAcc"): print("account") payment = "account" elif Form.get("payCar"): print("card") payment = "card" sqlQuery( """INSERT INTO orders(sid, cid, status, did, payment, timestmp) SELECT M.sid, C.cid, 'waiting', NULL, %s, %s FROM menues M, customers C WHERE C.local=%s AND M.menuid=%s;""", (payment, datetime.datetime.now(), local, menu_list[0][0])) conn = pg.connect(conn_str) cur = conn.cursor() for menu in menu_list: cur.execute( """INSERT INTO basket (order_id, menuid, cnt) SELECT MAX(O.order_id),%s,%s FROM orders O""", (menu[0], menu[1])) cur.close() conn.commit()
def option_decline(Form, local): # did = Form.get("did") order_id = Form.get("order_id") sqlQuery( """BEGIN TRANSACTION; DELETE FROM orders WHERE order_id = %s; DELETE FROM basket WHERE order_id = %s; END TRANSACTION;""", (order_id, order_id))
def delRequest2(info, sid, head): if sid.startswith("admin"): contacts_name = "contacts" elif sid.startswith("2009003125"): contacts_name = "grass_corp" elif sid.startswith("2013004394"): contacts_name = "fire_corp" elif sid.startswith("2014005004"): contacts_name = "water_corp" else: contacts_name = None sql = f"DELETE FROM {contacts_name} WHERE sid=\'{info[0]}\';" sqlQuery(sql) print("delete!")
def option_tag(Form, local): type = search(local) if Form.get("delete_tag"): sqlQuery("DELETE FROM store_tags WHERE sid=%s AND name=%s", (Form.get("sid"), Form.get("tag"))) print("{} 를 삭제하고 싶음".format(Form.get("tag"))) # sqlQuery(sql) elif Form.get("add_tag"): sql = "INSERT INTO store_tags (sid, name) VALUES ({}, \'{}\')".format( Form.get("sid"), Form.get("added_tag")) sqlQuery(sql) print(sql)
def option_person(Form, local): # name/pwd change type = search(local) sql = "SELECT name, passwd FROM {} WHERE local=\'{}\'".format(type, local) personInfo = sqlQuery_(sql) # print("origin:",list(personInfo[0])) # print("after:",Form.get("name"),Form.get("password")) if Form.get("save"): sql = "UPDATE {} SET name=\'{}\', passwd=\'{}\' WHERE local=\'{}\'".format( type, Form.get("name"), Form.get("password"), local) sqlQuery(sql) print("edit") else: print("cancel")
def addRequest2(info, sid, head): if sid.startswith("admin"): contacts_name = "contacts" elif sid.startswith("2009003125"): contacts_name = "grass_corp" elif sid.startswith("2013004394"): contacts_name = "fire_corp" elif sid.startswith("2014005004"): contacts_name = "water_corp" else: contacts_name = None print("contacts_name:", contacts_name) if sid.startswith("admin"): sql = f"INSERT INTO {contacts_name} VALUES (\'{info[0]}\', \'{info[1]}\', \'{info[2]}\');" sqlQuery(sql) print("add!") else: sql = f"INSERT INTO {contacts_name} VALUES (\'{info[0]}\', \'{info[1]}\', \'{info[2]}\', \'{info[3]}\');" sqlQuery(sql) print("add!")
def saveRequest2(info, sid, head): if sid.startswith("admin"): contacts_name = "contacts" elif sid.startswith("2009003125"): contacts_name = "grass_corp" elif sid.startswith("2013004394"): contacts_name = "fire_corp" elif sid.startswith("2014005004"): contacts_name = "water_corp" else: contacts_name = None print("contacts_name:", contacts_name) if contacts_name == "contacts": sql = f"UPDATE {contacts_name} SET {head[0]}=\'{info[0]}\',{head[1]}=\'{info[1]}\',{head[2]}=\'{info[2]}\' WHERE phone=\'{info[1]}\';" sqlQuery(sql) print("save!") elif contacts_name != None: sql = f"UPDATE {contacts_name} SET {head[0]}=\'{info[0]}\',{head[1]}=\'{info[1]}\',{head[2]}=\'{info[2]}\',{head[3]}=\'{info[3]}\' WHERE phone=\'{info[1]}\';" sqlQuery(sql) print("save!")
def option_menu(Form, local): # about store # TOFIX option_menu으로 함수 이름 바꾸기 type = search(local) if Form.get("changeName"): sql = "UPDATE menues SET menu=\'{}\' WHERE menu=\'{}\' AND sid={}".format( Form.get("after_menu"), Form.get("before_menu"), Form.get("sid")) sqlQuery(sql) print(sql) elif Form.get("delete"): sql = "DELETE FROM menues WHERE menu=\'{}\' AND sid={}".format( Form.get("before_menu"), Form.get("sid")) sqlQuery(sql) elif Form.get("add"): sql = "INSERT INTO menues (menu, sid) VALUES (\'{}\', {})".format( Form.get("added_menu"), Form.get("sid")) sqlQuery(sql)
def addRequest1(info, sid, head): # info[0] = info[0]+'\t' sql = f"INSERT INTO students VALUES (\'{info[0]}\', \'{info[1]}\', \'{info[2]}\', \'{info[3]}\', \'{info[4]}\', \'{info[5]}\', \'{info[6]}\');" sqlQuery(sql) print("add!")
def delRequest1(info, sid, head): sql = f"DELETE FROM students WHERE sid=\'{info[0]}\';" sqlQuery(sql) print("delete!")
def saveRequest1(info, sid, head): sql = f"UPDATE students SET {head[0]}=\'{info[0]}\', {head[1]}=\'{info[1]}\',{head[2]}=\'{info[2]}\',{head[3]}=\'{info[3]}\',{head[4]}={info[4]},{head[5]}=\'{info[5]}\',{head[6]}={info[6]} WHERE sid=\'{info[0]}\';" print("saverequest1 sid:", info[0]) sqlQuery(sql) print("save!")
from sql import sqlQuery import logging import os,sys,re curr_path = os.path.dirname(os.path.abspath(__file__)) comm_path = os.path.dirname(curr_path) if comm_path not in sys.path: sys.path.append(comm_path) logger = logging.getLogger(__name__) logger.setLevel(level = logging.INFO) handler = logging.FileHandler("{}/log.txt".format(curr_path)) handler.setLevel(logging.INFO) formatter = logging.Formatter('%(asctime)s - %(name)s - %(levelname)s - %(message)s') handler.setFormatter(formatter) logger.addHandler(handler) sql = sqlQuery('book') class searchBook(object): """docstring for findbook""" def __init__(self, baseURL, totalPage, savePath, endPage): self.baseURL = baseURL self.totalPage = totalPage self.path = savePath self.endPage = endPage def findbook(self): # find book 按分页查找book session = HTMLSession() for i in range(self.totalPage, self.endPage, -1): url = self.baseURL + str(i) # print (url) try: res = session.get(url, timeout = 10) book = res.html.find('div.book-img-box > a')
def option_updatePayment(Form, local): q = sqlQuery_("""SELECT payment FROM customers WHERE local=%s""", (local, )) payment_list = json.loads(q[0][0]) # account editing if Form.get("edit_acc"): origin_accNum = int(Form.get("origin_accNum")) get_acc_num = int(Form.get("get_acc_num")) get_acc_bid = int(Form.get("get_acc_bid")) for payment in payment_list: if payment['type'] == 'account' and payment['data'][ 'acc_num'] == origin_accNum: payment['data']['acc_num'] = get_acc_num payment['data']['bid'] = get_acc_bid tmp = json.dumps(payment_list) sqlQuery("""UPDATE customers SET payment=%s WHERE local=%s""", (tmp, local)) print("require / account edit ::: ", origin_accNum, get_acc_num, get_acc_bid) # card editing elif Form.get("edit_card"): origin_card = int(Form.get("origin_card")) get_card_num = int(Form.get("get_card_num")) for payment in payment_list: if payment['type'] == 'card' and payment['data'][ 'card_num'] == origin_card: payment['data']['card_num'] = get_card_num tmp = json.dumps(payment_list) sqlQuery("""UPDATE customers SET payment=%s WHERE local=%s""", (tmp, local)) print("require / card edit ::: ", origin_card, get_card_num) # account added elif Form.get("add_acc"): add_acc_num = int(Form.get("add_acc_num")) add_acc_bid = int(Form.get("add_acc_bid")) res = { 'type': 'account', 'data': { 'bid': add_acc_bid, 'acc_num': add_acc_num } } payment_list.append(res) tmp = json.dumps(payment_list) sqlQuery("""UPDATE customers SET payment=%s WHERE local=%s""", (tmp, local)) print("require / account add ::: ", add_acc_num, add_acc_bid) # card added elif Form.get("add_card"): add_card_num = int(Form.get("add_card_num")) res = {'type': 'card', 'data': {'card_num': add_card_num}} payment_list.append(res) tmp = json.dumps(payment_list) sqlQuery("""UPDATE customers SET payment=%s WHERE local=%s""", (tmp, local)) elif Form.get("del_acc"): origin_accNum = int(Form.get("origin_accNum")) print("::", payment_list) idx = None for i, payment in enumerate(payment_list): if payment['type'] == 'account' and payment['data'][ 'acc_num'] == origin_accNum: idx = i if idx is not None: del (payment_list[idx]) else: raise ValueError('삭제할 계좌 번호가 없음') tmp = json.dumps(payment_list) sqlQuery("""UPDATE customers SET payment=%s WHERE local=%s""", (tmp, local)) elif Form.get("del_card"): origin_card = int(Form.get("origin_card")) print("origin:", origin_card) print("payment1:", payment_list) idx = None for i, payment in enumerate(payment_list): if payment['type'] == 'card' and payment['data'][ 'card_num'] == origin_card: idx = i print("idx:", idx) if idx is not None: del (payment_list[idx]) else: raise ValueError('삭제할 카드 번호가 없음') print("payment2:", payment_list) tmp = json.dumps(payment_list) sqlQuery("""UPDATE customers SET payment=%s WHERE local=%s""", (tmp, local))
def option_deliveryFin(Form, local): order_id = Form.get("order_id") print("order~~id~~~:", order_id) sqlQuery("""UPDATE orders SET status='completed' WHERE order_id=%s""", (order_id, ))
def option_accept(Form, local): did = Form.get("did") order_id = Form.get("order_id") sqlQuery( """UPDATE orders SET did=%s, status='delivering' WHERE order_id = %s;""", (did, order_id))