def findAllFromDB(cls):
db = dbHelper.openDB()
cur = db.cursor()
result = cur.execute("select * from card_templates")
tplList = []
for row in result:
tplList.append(CardTpl(row))
return tplList
def checkUserInDb(self):
db = openDB()
cur = db.cursor()
u = self.reqObj.username
p = self.reqObj.password
cur.execute("SELECT p_id FROM users WHERE username = ? and password = ?",(u,p))
results = cur.fetchall()
userExists = len(results) > 0
if userExists:
userID = results[0][0]
self.prot.userID = userID
GameCenter().addPlayer(self.prot, userID)
resp = LoginResponse()
resp.success = userExists
data = resp.toJson()
self.postResp(data)
cur.close()
