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
