class TestDBAccess(unittest.TestCase):
def setUp(self):
self.web = Web()
self.UID = '09 4d 06 02'
def test_register(self):
req = self.web.infoQuery(self.UID)
self.assertEqual("60", req['result']['reg_no'])
self.assertEqual("Bruce Tsai", req['result']['nickname'])
req = self.web.registerUpdate(req['result']['reg_no'], self.UID)
self.assertEqual("ok", req['status'])
def test_query(self):
req = self.web.infoQuery(self.UID)
self.assertEqual("60", req['result']['reg_no'])
self.assertEqual("Bruce Tsai", req['result']['nickname'])
def test_tshirt_query(self):
req = self.web.tshirtQuery(self.UID)
self.assertEqual("M /160~170cm", req['result']['tshirt'])
def test_tshirt_update(self):
req = self.web.tshirtUpdate(self.UID)
self.assertEqual("ok", req['status'])
class Tab1(Tab):
def __init__(self, master):
Tab.__init__(self, master, u"報到".encode('utf-8'))
self.web = Web()
self.db = DBController("/home/pi/pyconapac-rpi/db/pycon2015.db.nofacebook")
self.reg_no = StringVar()
self.nickname = StringVar()
self.uid = StringVar()
self.tshirt_wtime = StringVar()
self.tab1_lbl_reg_no = Label(self, bg="red", fg="white", font=('Arial', 16), textvariable=sv_reg_no).pack(fill=X)
self.tab1_lbl_nickname = Label(self, bg="green", fg="black", font=('Arial', 22), textvariable=sv_nickname).pack(fill=X)
self.tab1_lbl_uid = Label(self, bg="blue", fg="white", font=('Arial', 20), textvariable=sv_uid).pack(fill=X)
self.tab1_lbl_status = Label(self, bg="yellow", fg="black", font=('Arial', 22), textvariable=sv_regist_status).pack(side=LEFT, fill=BOTH, expand=YES)
def load_profile(self, uid):
print type(self).__name__ + "/" + inspect.stack()[0][3]
try:
result = self.web.infoQuery(uid)
status = result['result']['regist_wtime'] if result['result']['regist_wtime'] != '0' else 'First Check-in'
reg_no = result['result']['reg_no']
nickname = result['result']['nickname']
user_info = self.db.getInfoByReg(reg_no)
sv_reg_no.set(reg_no + "/" + user_info.ticket_type.split(' ')[-1])
sv_nickname.set(nickname)
sv_uid.set(uid)
sv_regist_status.set(status)
result = self.web.registerUpdate(reg_no, uid)
# user_info = self.web.infoQuery(uid)
# sv_reg_no.set(str(user_info['result']['reg_no']))
# sv_nickname.set(str(user_info['result']['nickname']))
# sv_uid.set(str(user_info['result']['uid']))
# result = self.web.registerUpdate(user_info['result']['reg_no'], uid)
print result
# if user_info.regist_wtime == None:
# self.db.checkIn(uid)
except ValueError:
sv_reg_no.set(VALUE_ERROR)
sv_nickname.set(VALUE_ERROR)
sv_uid.set(uid)
def main(uid):
web = Web()
r = web.infoQuery(uid)
