INNER CODE UNIT · Python
limit
TechXueXi/TechXueXi · SourcePackages/challengeAnswerBank.py:72
limit = (page - 1) * rows
db = DbTool()
total = db.query(
'select count(*) from ' + tableName + ' where question like ' + '"%' + keyword + '%"' + 'or answer like ' + '"%' + keyword + '%"')
result = db.query(
'select question,answer,datetime from ' + tableName + ' where question like ' + '"%' + keyword + '%"' + 'or answer like ' + '"%' + keyword + '%" LIMIT ' +
str(limit) + ',' + str(rows))
data = {'total': total[0][0], 'rows': []}
for r in result:
# data['rows'].append({'id': r[0], 'question': r[1], 'answer': r[2], 'datetime': 0})
data['rows'].append({'id': 0, 'question': r[0], 'answer': r[1], 'datetime': r[2]})
###################################将tikuNet表中的题库，插入到tiku表中###############
# question = r[1]
# answer = r[2]
# db = DbTool()
# q = db.query('select * from ' + 'tiku' + ' where question = "' + question + '" and answer = "' + answer + '"')
# if not len(q):
# result = db.execute('insert into ' + 'tiku' + '(question,answer) values (?,?)', (question, answer))