def getBal(acc) : dbi = mydb("/tmp/details.db") dbi.connect() res = dbi.getBal(acc) logging.debug("Bal : " + str(res)) dbi.close() return res
def OpenWordForm(self, id): mdb = mydb() dt = mdb.getData( "SELECT Chucvu, tennhanvien FROM login, NhanVien where login.id = NhanVien.IDnhanvien and id = " + str(id)) if dt[0][0] == 'Quản Lý': messagebox.showinfo("Login", "Đăng nhập quản lý thành công") frmQuanLy = FormQuanLy() self.LoginForm.destroy() frmQuanLy.setupForm() elif dt[0][0] == 'Nhân Viên': self.setupFormNhanVien(dt[0][1])
def registerCommand(self): mdb = mydb() if self.passWord_TextBox.get() != self.conFirm_TextBox.get(): messagebox.showerror("Register", "Lỗi: Mật khẩu xác nhận không trùng khớp") elif not self.verif(): messagebox.showerror( "Register", "Lỗi: Username, Password, Confirm không được bỏ trống") else: mdb.insert(self.userName_TextBox.get(), self.passWord_TextBox.get())
def loginCommand(self): mdb = mydb() if self.userName_TextBox.get() == "" or self.passWord_TextBox.get( ) == "": messagebox.showerror( "Login", "Lỗi: Username, Password không được bỏ trống") else: username = self.userName_TextBox.get() password = self.passWord_TextBox.get() dt = mdb.getData("Select * from login where username = '******' and password = '******'") if len(dt) != 0: self.OpenWordForm(dt[0][0]) else: messagebox.showerror("Login", "Lỗi: Username, Password không đúng")
def __init__(self, name): db = mydb(name) self.db = db
pass def update_record(db, code): last_update = record_last_update(db, code) if (last_update != 'up-to-date'): print("%s pulling ..." % code) data = pull_net_data(code, last_update, 7) print('%s update ma5 lowest ...' % code) record_update_lowest(db, data, code, 'ma5', last_update) record_update_last_update(db, code) else: print("%s up-to-date" % code) db = mydb('my.db') dbcolumns = [] dbcolumns.append(['code', 'varchar(32)']) dbcolumns.append(['ma5_lowest', 'float']) dbcolumns.append(['close', 'float']) dbcolumns.append(['last_update', 'varchar(32)']) db.check_db('stocks', dbcolumns) allstocks = ts.get_stock_basics() for code in allstocks.index: print("%s:" % code) update_record(db, code) db.commit() print("\n")
#!/usr/bin/env python from mydb import * from fetch_data import * md = mydb('my.db') print(md.column_index('stocks', 'last_update')) # print(md.get_onecell('stocks', 'code', '601398', 'lowest')) fd = fetch_data('hist_data.db') fd.sync()
def getLastNTrans(acc, n) : dbi = mydb("/tmp/details.db") dbi.connect() res = dbi.getLastTransN(acc,n) dbi.close() return res
def updateEmail(acc, newemail) : dbi = mydb("/tmp/details.db") dbi.connect() res = dbi.updateEmail(acc, newemail) dbi.close() return res
def updateMob(acc, newmob) : dbi = mydb("/tmp/details.db") dbi.connect() res = dbi.updateMob(acc, newmob) dbi.close() return res
def updateAddr(acc, newaddr) : dbi = mydb("/tmp/details.db") dbi.connect() res = dbi.updateAddr(acc, newaddr) dbi.close() return res