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, '/')
