def upgrade(): ### commands auto generated by Alembic - please adjust! ### from application.app import db, app from restore import restore with app.app_context(): db.create_all() restore()
def setUp(self): self.app = self.create_app().test_client() db.create_all() # create user res = self.app.post("/api/create_user", data=json.dumps(self.default_user), content_type='application/json') self.token = json.loads(res.data.decode("utf-8"))["token"] with self.app.session_transaction() as sess: sess['user_id'] = 1 sess[ '_fresh'] = True # https://flask-login.readthedocs.org/en/latest/#fresh-logins # create account self.app.post("/api/accounts/create", data=json.dumps(self.default_account), content_type='application/json', headers={'Authorization': self.token}) # create transaction self.app.post("/api/transactions/create", data=json.dumps(self.default_transaction), content_type='application/json', headers={'Authorization': self.token}) # create recurring group self.app.post("/api/recurring/create", data=json.dumps(self.default_recurring_group), content_type='application/json', headers={'Authorization': self.token})
def create_db(): """Creates the db tables.""" db.create_all() db.session.add(ToDoListModel('To Do')) db.session.add(ToDoListModel('Pending')) db.session.add(ToDoListModel('Done')) db.session.commit()
def setUp(self): self.app = self.create_app().test_client() db.create_all() res = self.app.post("/api/create_user", data=json.dumps(self.default_user), content_type='application/json') self.token = json.loads(res.data)["token"]
def setUp(self): self.app = self.create_app().test_client() db.create_all() res = self.app.post( "/api/create_user", data=json.dumps(self.default_user), content_type='application/json' ) self.token = json.loads(res.data)["token"]
def setUp(self): self.app = self.create_app().test_client() db.create_all() res = self.app.post("/api/create_user", data=json.dumps(self.default_user), content_type='application/json') self.token = json.loads(res.data.decode("utf-8"))["token"] res2 = self.app.post("/api/get_token", data=json.dumps(self.default_user), content_type='application/json') res3 = self.app.post("/api/create_group", data=json.dumps(self.default_group), content_type='application/json')
def client(): test_db, app.config['DATABASE'] = tempfile.mkstemp() app.config['TESTING'] = True client = app.test_client() with app.app_context(): db.init_app(app) db.create_all() yield client with app.app_context(): db.drop_all() os.close(test_db) os.unlink(app.config['DATABASE'])
def setUp(self): self.app = self.create_app().test_client() db.drop_all() db.create_all() res = self.app.post("/api/create_user", data=json.dumps(self.default_user), content_type='application/json') self.token = json.loads(res.data.decode("utf-8"))["token"] test_program = ProgramTemplate(name="test_program", program=json.dumps({ "weights": { "pre": "0.9*X", "session": ["X+0"], "set": [["0.65*X", "0.75*X", "0.85*X"], ["0.7*X", "0.8*X", "0.9*X"], ["0.75*X", "0.85*X", "0.95*X"], ["0.4*X", "0.5*X", "0.6*X"]], "rep": [["X+0"]] }, "times": { "session": [], "set": [[180, 150]], "rep": [[[10, 6, 2], [5, 3, 1]], [[6, 2], [3, 1]], [[2], [1]]] }, "freqs": { "session": [2, 2, 2, 1], "set": [3], "rep": [3, 2, 2] } })) db.session.add(test_program)
def create_db(): """Creates the db tables.""" db.create_all()
'customer_email': self.customer_email, 'date_placed': str(self.date_placed), 'status': self.status } class OrderProduct(db.Model): __tablename__ = 'Order_Product' order_id = db.Column(db.Integer, db.ForeignKey('Order.order_id'), primary_key=True) item_id = db.Column(db.Integer, db.ForeignKey('InventoryItem.item_id'), primary_key=True) item_qty = db.Column(db.Integer) def __init__(self, order_id, item_id, qty): self.order_id = order_id self.item_id = item_id self.item_qty = qty def serialize(self): return { 'order_id': self.order_id, 'item_id': self.item_id, 'item_qty': self.item_qty } db.create_all()
# -*- coding: utf-8 -*- from application.app import db, app with app.app_context(): db.create_all()
def setUp(self): app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///:memory:' self.c = app.test_client() db.create_all(app=app)
def create_db(): # Initializes the database db.create_all() print('Init the db')
def create_tables(): "Create relational database tables." db.create_all() db.session.commit() print("Create database tables successfully.")
def setUp(self): self.app = self.create_app().test_client() self.connect = db.get_engine().connect() db.create_all()
def create_db(): """Creates the db tables.""" db.create_all()
def create_db(): """Creates the db tables.""" db.create_all(bind="wehomeproperty")
def create_db(): """Creates the db tables.""" db.create_all() db_populate(app, db)