def add_score(username, score): query1 = 'select score from user where username =\'%s\'' % username cur = sqlite3_db.connect_db().execute(query1) rv = cur.fetchall() cur.close() nowScore = rv[0][0] query = 'update user set score = ' + \ '%d' % (nowScore + score) + ' where username = \'' + username + '\'' query = 'update user set score = %d where username = \'%s\'' % ( nowScore + score, username) db = sqlite3_db.connect_db() db.execute(query) db.commit()
def get_question(kind, titleOnly=True, num='0'): if titleOnly: query = 'select title,score from question where kind = %s order by score desc' % kind cur = sqlite3_db.connect_db().execute(query) rv = cur.fetchall() cur.close() return rv else: query = 'select title,content,answer,kind,score from question where num = %d order by score desc' % string.atoi( num) cur = sqlite3_db.connect_db().execute(query) rv = cur.fetchall() cur.close() rv = rv[0] return rv
def getInfoView(): studentid = request.form['studentid'] name = request.form['name'] if (name == '' and studentid == ''): return 'ERROR' if (studentid != ''): query = 'select * from student where studentid=\'%s\'' % studentid else: query = 'select * from student where name=\'%s\'' % name cur = sqlite3_db.connect_db().execute(query) rv = cur.fetchall() cur.close() if rv is None: return 'ERROR FIND' rv = rv[0] sname = rv[1] sstudentid = rv[2] ssex = rv[3] ssocialid = rv[4] sspecial = rv[5] scollege = rv[6] return jsonify( name=sname, studentid=sstudentid, sex=ssex, socialid=ssocialid, special=sspecial, college=scollege)
def register(username, password): query = 'select password from user where username = \'%s\'' % username cur = sqlite3_db.connect_db().execute(query) rv = cur.fetchall() cur.close() if not rv: encrypt = hashlib.md5() encrypt.update(password) password = encrypt.hexdigest() query = 'insert into user values(\'%s\' , \'%s\' , 0,0)' % ( username, password) db = sqlite3_db.connect_db() db.execute(query) db.commit() return True else: return False
def addqtk(title, score, answer): query = "insert into fill(title, score, answer)values ('{title}', {score}, '{answer}')".format(title=title, score=score, answer=answer) print query t = sqlite3_db.connect_db() cur = t.execute(query) rv = cur.fetchall() t.commit() cur.close() return rv
def addqt(title, score, true_or_false): query = "insert into true_or_false_question(title, score, true_or_false)values ('{title}', {score}, '{true_or_false}')".format(title=title, score=score, true_or_false=true_or_false) print query t = sqlite3_db.connect_db() cur = t.execute(query) rv = cur.fetchall() t.commit() cur.close() return rv
def addqc(title, score, A, B, C, D, answer): query = "insert into choice_question(title, score, A, B, C, D, answer)values ('{title}', {score}, '{A}', '{B}', '{C}', '{D}', '{answer}')".format(title=title, score=score, A=A, B=B, C=C, D=D, answer=answer) print query t = sqlite3_db.connect_db() cur = t.execute(query) rv = cur.fetchall() t.commit() cur.close() return rv
def addqtk(title, score, answer): query = "insert into fill(title, score, answer)values ('{title}', {score}, '{answer}')".format( title=title, score=score, answer=answer) print query t = sqlite3_db.connect_db() cur = t.execute(query) rv = cur.fetchall() t.commit() cur.close() return rv
def addqt(title, score, true_or_false): query = "insert into true_or_false_question(title, score, true_or_false)values ('{title}', {score}, '{true_or_false}')".format( title=title, score=score, true_or_false=true_or_false) print query t = sqlite3_db.connect_db() cur = t.execute(query) rv = cur.fetchall() t.commit() cur.close() return rv
def addqc(title, score, A, B, C, D, answer): query = "insert into choice_question(title, score, A, B, C, D, answer)values ('{title}', {score}, '{A}', '{B}', '{C}', '{D}', '{answer}')".format( title=title, score=score, A=A, B=B, C=C, D=D, answer=answer) print query t = sqlite3_db.connect_db() cur = t.execute(query) rv = cur.fetchall() t.commit() cur.close() return rv
def login(username, password): encrypt = hashlib.md5() encrypt.update(password) password = encrypt.hexdigest() query = 'select password from user where username = \'%s\'' % username cur = sqlite3_db.connect_db().execute(query) rv = cur.fetchall() cur.close() if rv is None: return False else: if rv[0][0] == unicode(password): return True else: return False
def rank(): query = 'select username,score from user order by score desc limit 0,20' cur = sqlite3_db.connect_db().execute(query) rv = cur.fetchall() cur.close() return rv
def get_question(kind): query = 'select title,score from choice_question order by score desc' cur = sqlite3_db.connect_db().execute(query) rv = cur.fetchall() cur.close() return rv