def test_phase(self): c = getDB() one = 'test 1' two = 'test 1' c.execute("""INSERT INTO columns(proj,coll) VALUES(?,?)""",(two,one)) name = str(c.execute("""SELECT proj,coll FROM columns WHERE proj = 'test 1' AND coll = 'test 1' """).fetchall()) self.assertEqual(name,"[('test 1', 'test 1')]")
def test_project(self): c = getDB() one = 'test 1' two = 'test 1' three = 'test 1' c.execute("""INSERT INTO project(manager,title,description) VALUES(?,?,?)""",(three,one,two)) name = str(c.execute("""SELECT manager,title,description FROM project WHERE description = 'test 1' AND title = 'test 1' AND manager = 'test 1' """).fetchall()) self.assertEqual(name,"[('test 1', 'test 1', 'test 1')]")
def test_bug(self): c = getDB() one = 1 two = 'test 1' three = 'test 1' four = 'test 1' c.execute("""INSERT INTO bug(task_id,line,fname,description) VALUES(?,?,?,?)""",(one,two,three,four)) name = str(c.execute("""SELECT task_id,line,fname,description FROM bug WHERE task_id = 1 AND description = 'test 1' AND line = 'test 1' AND fname = 'test 1' """).fetchall()) self.assertEqual(name,"[(1, 'test 1', 'test 1', 'test 1')]")
def test_task(self): c = getDB() language = 'test 1' two = 'test 1' three = 'test 1' c.execute("""INSERT INTO task(title,description,phase) VALUES(?,?,?)""",(language,two,three,)) name = str(c.execute("""SELECT title,description,phase FROM task WHERE title = 'test 1' AND description = 'test 1' AND phase = 'test 1'""").fetchall()) self.assertEqual(name,"[('test 1', 'test 1', 'test 1')]")
from flask import Flask, Blueprint, jsonify, request from flask_restful import reqparse, abort, Api, Resource from config import DB_CONNECT from app import getDB bp = Blueprint('test', __name__, url_prefix='/test') api = Api(bp) db = getDB() cursor = db.cursor() question_parser = reqparse.RequestParser() question_parser.add_argument('question_id') user_parser = reqparse.RequestParser() user_parser.add_argument('id') user_parser.add_argument('user_name') user_parser.add_argument('user_age') user_parser.add_argument('user_gender') user_parser.add_argument('user_region') # score_parser = reqparse.RequestParser() # score_parser.add_argument('user_id') code_parser = reqparse.RequestParser() code_parser.add_argument('code_id') class Question(Resource): def get(self): result = [] args = question_parser.parse_args()
def test_user(self): c = getDB() one = 'test 1' c.execute("""INSERT INTO user(uname) VALUES (?)""",(one,)) name = str(c.execute("""SELECT uname FROM user WHERE uname = 'test 1' """).fetchall()) self.assertEqual(name,"[('test 1',)]")