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)
