def setUpClass(cls): app.config['DATABASE'] = config.connstr app.config['TESTING'] = True DB.init_pool(app.config['DATABASE']) with DB(False) as (conn, cursor): # this pretty much cascades to everything, except animals cursor.execute("TRUNCATE users CASCADE") # create a single user/distribution/version cursor.execute("INSERT INTO users (user_name, full_name) VALUES ('test_user', 'test user full name')") cursor.execute("INSERT INTO distributions (user_id, dist_name) VALUES (currval('users_id_seq'), 'testdistr')") cursor.execute("INSERT INTO distribution_versions (dist_id, dist_version, dist_date, dist_status) VALUES (currval('distributions_id_seq'), '1.2.3', '2014-01-02 03:04:05', 'stable')") cursor.execute("INSERT INTO users (user_name, full_name) VALUES ('test_user2', 'test user full name')") cursor.execute("INSERT INTO distributions (user_id, dist_name) VALUES (currval('users_id_seq'), 'testdistr2')") cursor.execute("INSERT INTO distribution_versions (dist_id, dist_version, dist_date, dist_status) VALUES (currval('distributions_id_seq'), '1.2.4', '2014-01-02 03:04:05', 'stable')") cursor.execute("INSERT INTO users (user_name, full_name) VALUES ('test_user3', 'test user full name')") cursor.execute("INSERT INTO distributions (user_id, dist_name) VALUES (currval('users_id_seq'), 'testdistr3')") cursor.execute("INSERT INTO distribution_versions (dist_id, dist_version, dist_date, dist_status) VALUES (currval('distributions_id_seq'), '1.2.5', '2014-01-02 03:04:05', 'stable')") conn.commit()
def setUpClass(cls): app.config['DATABASE'] = config.connstr app.config['TESTING'] = True DB.init_pool(app.config['DATABASE']) with DB(False) as (conn, cursor): # this pretty much cascades to everything, except animals cursor.execute("TRUNCATE animals CASCADE") conn.commit()
def setUpClass(cls): app.config['DATABASE'] = config.connstr app.config['TESTING'] = True DB.init_pool(app.config['DATABASE']) with DB(False) as (conn, cursor): # this pretty much cascades to everything, except animals cursor.execute("TRUNCATE animals CASCADE") # create a single user with a distribution and two versions cursor.execute("INSERT INTO animals (animal_name, animal_secret, animal_email) VALUES ('test_animal', 'animal secret', 'animal email')") conn.commit()
from flask.ext.restful import Api # this is where the implementation is placed sys.path.append('src') from db import DB import cors, jsonp # create flask application app = Flask(__name__) # load config from the config.api dictionary app.config.from_object('config.api') # initialize the database pool DB.init_pool(app.config['DATABASE']) # create the REST api api = Api(app) # CORS / allow calls from all origins (well, especially pgxn-tester.org, but not only) api.decorators=[cors.crossdomain(origin='*'), jsonp.support_jsonp] import index import distributions import users import machines import results import stats api.add_resource(index.Index, '/')