def setUpClass(cls):
cls.app = app
cls.client = cls.app.test_client()
cls.app.app_context().push()
db.create_all()
db.engine.dialect.supports_sane_multi_rowcount = False
def create_db_entries():
print "Creating new DB"
# recreate database structure
db.drop_all()
db.create_all()
def setUpClass(cls):
cls.app = app
cls.app.app_context().push()
db.session.remove()
db.drop_all()
db.create_all()
db.engine.dialect.supports_sane_multi_rowcount = False
def setUpClass(cls):
cls.app = new_app
cls.app.app_context().push()
db.create_all()
shop = models.Shop(domain=cls.SHOP_DOMAIN)
db.session.add(shop)
db.session.commit()
cls.SHOP_ID = shop.id
def refresh_db(cls):
db.session.remove()
db.drop_all()
db.create_all()
db.engine.dialect.supports_sane_multi_rowcount = False
db_dir = os.path.join(basedir, 'install', 'db', cls.app.config.get('MODE'))
import_tables(db, db_dir)
def setUp(self):
app.config['SQLALCHEMY_DATABASE_URI'] = "sqlite://"
db.create_all()
# add an initial timestamp, address, and update count
db.session.add_all([
UpdateCheck(),
Address(address="@test-address.com"),
Counter(count=0)
])
db.session.commit()
def setUpClass(cls):
cls.app = app
cls.master_client = cls.app.test_client()
cls.desktop_client = cls.app.test_client()
cls.mobile_client = cls.app.test_client()
def override_method(method, ua):
def om_wrapper(*args, **kwargs):
kwargs = common.inject_ua(ua, kwargs)
return getattr(cls.master_client, method)(*args, **kwargs)
return om_wrapper
cls.desktop_client.get = override_method('get', Constants.DESKTOP_USER_AGENT)
cls.desktop_client.post = override_method('post', Constants.DESKTOP_USER_AGENT)
cls.desktop_client.put = override_method('put', Constants.DESKTOP_USER_AGENT)
cls.desktop_client.patch = override_method('patch', Constants.DESKTOP_USER_AGENT)
cls.desktop_client.delete = override_method('delete', Constants.DESKTOP_USER_AGENT)
cls.mobile_client.get = override_method('get', Constants.MOBILE_USER_AGENT)
cls.mobile_client.post = override_method('post', Constants.MOBILE_USER_AGENT)
cls.mobile_client.put = override_method('put', Constants.MOBILE_USER_AGENT)
cls.mobile_client.patch = override_method('patch', Constants.MOBILE_USER_AGENT)
cls.mobile_client.delete = override_method('delete', Constants.MOBILE_USER_AGENT)
cls.app.app_context().push()
db.session.remove()
db.drop_all()
db.create_all()
db.engine.dialect.supports_sane_multi_rowcount = False
db_dir = os.path.join(basedir, 'install', 'db', cls.app.config.get('MODE'))
import_tables(db, db_dir)
admin_role = Role.query.filter_by(name=Constants.ADMIN_ROLE).first()
cls.admin_user = User.query.filter_by(id=1).first()
assert admin_role in cls.admin_user.roles
cls.admin_password = sensitive.ADMIN_PASSWORD
reviewer_role = Role.query.filter_by(name=Constants.REVIEWER_ROLE).first()
cls.reviewer_user = User.query.filter_by(id=2).first()
assert cls.reviewer_user.has_role(reviewer_role)
cls.reviewer_password = sensitive.TEST_REVIEWER_PASSWORD
shop_owner_role = Role.query.filter_by(name=Constants.SHOP_OWNER_ROLE).first()
cls.shop_owner_user = User.query.filter_by(id=3).first()
assert cls.shop_owner_user.has_role(shop_owner_role)
cls.shop_owner_password = sensitive.TEST_SHOP_OWNER_PASSWORD
cls.vserver = VirtualServerManager()
cls.vserver.start()
common.verify_initialization()
def setUpClass(cls):
cls.app = new_app
cls.app.app_context().push()
db.create_all()
cls.SHOP_OWNER_USER = models.User()
shop = models.Shop(owner=cls.SHOP_OWNER_USER)
shop_not_owned = models.Shop()
db.session.add(shop)
db.session.add(shop_not_owned)
db.session.commit()
cls.SHOP_ID = shop.id
cls.SHOP_NOT_OWNED_ID = shop_not_owned.id
def setUp(self):
self.app = app.test_client()
self.app_context = app.app_context()
self.app_context.__enter__()
db.drop_all()
db.create_all()
self.user1 = User('user1', '123456')
self.user2 = User('user2', '123456')
db.session.add(self.user1)
db.session.add(self.user2)
db.session.commit()
def create_user(email, password, admin=False):
""" Create a test user """
db.create_all()
user = user_datastore.create_user(email=email, password=password)
db.session.commit()
print "User created."
if admin:
admin_role = Role.query.filter_by(name='admin').first()
if admin_role is None:
admin_role = Role(name='admin', description='Administrators')
db.session.add(admin_role)
admin_role.users.append(user)
db.session.commit()
def action(ip=('i', default_ip)):
"""
Installs a new database configuration for the appliance.
"""
# create all tables
db.create_all()
if not Appliance.get():
# initialize the appliance object
appliance = Appliance()
appliance.initialize(ip)
# sync flavors from pool (openstack sync comes later when we have a user)
flavors = Flavors().sync()
# configure output
configure_blurb()
def setUpClass(cls):
cls.app = new_app
cls.client = cls.app.test_client()
cls.app.app_context().push()
db.create_all()
# create db fixtures
r = cls.register(cls.REVIEW_USER_EMAIL, cls.REVIEW_USER_PWD)
cls.REVIEW_USER = models.User.query.first()
db.session.add(cls.REVIEW_USER)
review = models.Review.create_from_import(user=cls.REVIEW_USER)
not_your_review = models.Review()
db.session.add(review)
db.session.add(not_your_review)
db.session.commit()
cls.REVIEW_ID = review.id
cls.NOT_YOUR_REVIEW_ID = not_your_review.id
def refresh_db(cls):
db.session.remove()
db.drop_all()
db.create_all()
db.engine.dialect.supports_sane_multi_rowcount = False
cls.basedir = os.path.abspath(os.path.dirname(__file__))
shop_owner_role = Role(name=Constants.SHOP_OWNER_ROLE, description="Shop owner")
cls.shop_owner = User(email=testing_constants.NEW_USER_EMAIL,
name=testing_constants.NEW_USER_NAME,
password=testing_constants.NEW_USER_PWD,
roles=[shop_owner_role], is_shop_owner=True,
confirmed_at = datetime.datetime.utcnow()
)
cls.shopify_shop = Shop(name=testing_constants.SHOPIFY_SHOP_NAME, owner=cls.shop_owner)
cls.yotpo_shop = Shop(name=testing_constants.YOTPO_SHOP_NAME, owner=cls.shop_owner)
db.session.add(cls.shop_owner)
db.session.add(cls.shopify_shop)
db.session.add(cls.yotpo_shop)
db.session.commit()
cls.shopify_importer = import_shopify.ShopifyImpoter(shop_id=cls.shopify_shop.id)
cls.yotpo_importer = import_yotpo.YotpoImpoter(shop_id=cls.yotpo_shop.id)
def action(ip=('i', default_ip)):
"""
Restores the appliance to factory default settings.
"""
try:
if ip == default_ip:
print "Please enter the appliance's IP address."
print "Usage: ./manage.py reset -i x.x.x.x"
return action
# double check they want to do this
if query_yes_no("Are you sure you want to reset the appliance?"):
# initialize database
path = os.path.dirname(os.path.abspath(__file__))
os.system('cp "%s/utterio.db" "%s/utterio_backup.db"' % (path, path))
# delete, then create all tables
db.drop_all()
db.create_all()
# initialize the appliance object
appliance = Appliance()
appliance.initialize(ip)
# sync with pool database
flavors = Flavors().sync()
if flavors['response'] != "success":
print flavors['result']
else:
print "The database has been cleared and a new API token has been generated."
configure_blurb()
except ValueError as ex:
print ex
def setUp(self):
self.in_string = "Salut GrandPy ! Est-ce que tu connais l'adresse d'Openclassrooms à Paris ?"
db.create_all()
for key in app.config["DATA_LOAD_CONFIG"].keys():
FiletoDbHandler(db, key)()
def create_db():
db.drop_all()
db.create_all()
db.session.commit()
def refresh_db(self):
db.session.remove()
db.drop_all()
db.create_all()
db.engine.dialect.supports_sane_multi_rowcount = False
def init_db(): db.create_all()
def setUp(self):
self.app = create_app(TestingConfig)
db.create_all()
def createdb():
""" Creates a database with all of the tables defined in
your Alchemy models
"""
db.create_all()
def init():
db.create_all()
from webapp import db, create_app db.drop_all(app=create_app()) db.create_all(app=create_app())
cancer = db.Column(db.String(100)) # db.ForeignKey('cancer.id')
intervention = db.Column(db.String(100)) #db.ForeignKey('intervention.id')
association_id = db.Column(db.Integer, db.ForeignKey('association.id'))
def __repr__(self):
return f"Article('{self.pmid}', '{self.title}')"
#
# class Article_Has_Association(db.Model):
# id = db.Column(db.Integer, primary_key=True)
# article_id = db.Column(db.Integer, db.ForeignKey('article.id'))
# cancer_id = db.Column(db.Integer, db.ForeignKey('cancer.id'))
# intervention_id = db.Column(db.Integer, db.ForeignKey('intervention.id'))
# therapeutic_association_id = db.Column(db.Integer, db.ForeignKey('therapeutic_association.id')
db.create_all()
c_df = pd.read_csv("webapp/cancers.csv", header=None)
#import pdb; pdb.set_trace()
cancers = c_df[0].values
for c in cancers:
not_exists = db.session.query(
Cancer.cancer_type
).filter_by(cancer_type=c).scalar() is None
if not_exists:
new_c = Cancer(cancer_type=c)
db.session.add(new_c)
d_df = pd.read_csv("webapp/drugs.csv", header=None)
#import pdb; pdb.set_trace()
drugs = d_df[0].values
def refresh_db(self):
db.session.remove()
db.drop_all()
db.create_all()
db.engine.dialect.supports_sane_multi_rowcount = False
def init_db():
try:
db.create_all()
return json.dumps({'success': 'Init success'})
except Exception as e:
return json.dumps({'error': str(e), 'repr': repr(e)})
def setUpClass(cls):
cls.app = app
cls.master_client = cls.app.test_client()
cls.desktop_client = cls.app.test_client()
cls.mobile_client = cls.app.test_client()
def override_method(method, ua):
def om_wrapper(*args, **kwargs):
kwargs = common.inject_ua(ua, kwargs)
return getattr(cls.master_client, method)(*args, **kwargs)
return om_wrapper
cls.desktop_client.get = override_method('get',
Constants.DESKTOP_USER_AGENT)
cls.desktop_client.post = override_method('post',
Constants.DESKTOP_USER_AGENT)
cls.desktop_client.put = override_method('put',
Constants.DESKTOP_USER_AGENT)
cls.desktop_client.patch = override_method(
'patch', Constants.DESKTOP_USER_AGENT)
cls.desktop_client.delete = override_method(
'delete', Constants.DESKTOP_USER_AGENT)
cls.mobile_client.get = override_method('get',
Constants.MOBILE_USER_AGENT)
cls.mobile_client.post = override_method('post',
Constants.MOBILE_USER_AGENT)
cls.mobile_client.put = override_method('put',
Constants.MOBILE_USER_AGENT)
cls.mobile_client.patch = override_method('patch',
Constants.MOBILE_USER_AGENT)
cls.mobile_client.delete = override_method('delete',
Constants.MOBILE_USER_AGENT)
cls.app.app_context().push()
db.session.remove()
db.drop_all()
db.create_all()
db.engine.dialect.supports_sane_multi_rowcount = False
db_dir = os.path.join(basedir, 'install', 'db',
cls.app.config.get('MODE'))
import_tables(db, db_dir)
admin_role = Role.query.filter_by(name=Constants.ADMIN_ROLE).first()
cls.admin_user = User.query.filter_by(id=1).first()
assert admin_role in cls.admin_user.roles
cls.admin_password = sensitive.ADMIN_PASSWORD
reviewer_role = Role.query.filter_by(
name=Constants.REVIEWER_ROLE).first()
cls.reviewer_user = User.query.filter_by(id=2).first()
assert cls.reviewer_user.has_role(reviewer_role)
cls.reviewer_password = sensitive.TEST_REVIEWER_PASSWORD
shop_owner_role = Role.query.filter_by(
name=Constants.SHOP_OWNER_ROLE).first()
cls.shop_owner_user = User.query.filter_by(id=3).first()
assert cls.shop_owner_user.has_role(shop_owner_role)
cls.shop_owner_password = sensitive.TEST_SHOP_OWNER_PASSWORD
cls.vserver = VirtualServerManager()
cls.vserver.start()
common.verify_initialization()
def setUp(self):
self.app = app.test_client()
db.create_all()
def initdb(clean=False):
""" Creates db schema """
if clean:
clean_index()
db.create_all()
print "DB inited."
from webapp import db, create_app db.create_all(app=create_app()) # прошу db создать ВСЕ модели для этого приложения
def create_all():
db.create_all()
def calculate_contrib_area():
db.create_all()
ContribState.fill()
ContribDistrict.fill()
def setup_module():
app.config['SQLALCHEMY_DATABASE_URI'] = HEROKU_POSTGRESQL_CHARCOAL_URL
app.config['WTF_CSRF_ENABLED'] = False
db.create_all()
def setUp(self):
self.app = app.test_client()
db.create_all()
from webapp import db, create_app db.create_all(app=create_app()) # создаем базу данных
""" Create the Team Accolade database. """ from webapp import db # Create the database based on the model. db.create_all()
def setup_module():
app.config['SQLALCHEMY_DATABASE_URI'] = HEROKU_POSTGRESQL_CHARCOAL_URL
db.create_all()
from webapp import db, app db.create_all(app=app)
def start_test_server():
with app.app_context():
db.drop_all()
db.create_all()
server.start()
__bind_key__ = 'sample_bind'
__tablename__ = "my_table"
id = Column(Integer, primary_key=True)
versions = Column(String(255))
name = Column(String(255))
try:
os.remove("webapp/sample.db")
except:
pass
app = create_app("config.Config")
with app.app_context():
db.create_all(bind=['sample_bind'], app=app)
row1 = MyTable()
row1.versions = "1"
row1.name = "The First Version"
row2 = MyTable()
row2.versions = "1.1"
row2.name = "The First Version With Lots Of BugFix"
db.session.add(row1)
db.session.add(row2)
db.session.commit()
def setUp(self):
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite://'
db.create_all()
def setUp(self):
self.app = create_app(TestConfig)
self.app_context = self.app.app_context()
self.app_context.push()
db.create_all()
def init_db():
try:
db.create_all()
return json.dumps({'success': 'Init success'})
except Exception as e:
return json.dumps({'error': str(e), 'repr': repr(e)})
