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
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
