def setUp(self): db.create_all() user = User(username='******', email="*****@*****.**", password="******") db.session.add(user) db.session.commit()
def setUp(self): app.config['TESTING'] = True app.config['CSRF_ENABLED'] = False app.config['DEBUG'] = False app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///' + os.path.join( BASE_DIR, TEST_DB) self.app = app.test_client() db.create_all() self.invite_link = ''.join( random.choice(string.ascii_lowercase + string.digits) for _ in range(32)) our_time = "2019-01-05 22:14:39" our_time_to_live = "2019-04-05 22:14:39" our_datetime = datetime.strptime(our_time, "%Y-%m-%d %H:%M:%S") our_datetime_to_live = datetime.strptime(our_time_to_live, "%Y-%m-%d %H:%M:%S") self.user = User() self.user.add() print(self.user.id) self.tournament = Tournament("CTF", "description", self.user, our_datetime, our_datetime_to_live, "45.408062, -123.007827", self.invite_link, True, True, False, True) self.tournament.add()
def create(cls): db.create_all() if not os.path.exists(cls.__migrate_repo_path): api.create(cls.__migrate_repo_path, 'database repository') api.version_control(cls.__database_uri, cls.__migrate_repo_path) else: api.version_control(cls.__database_uri, cls.__migrate_repo_path, api.version(cls.__migrate_repo_path))
def main(): db.create_all() if not os.path.exists(config.App.MIGRATE_REPO_PATH): api.create(config.App.MIGRATE_REPO_PATH, 'database repository') api.version_control(config.Flask.SQLALCHEMY_DATABASE_URI, config.App.MIGRATE_REPO_PATH) else: api.version_control(config.Flask.SQLALCHEMY_DATABASE_URI, config.App.MIGRATE_REPO_PATH, api.version(config.App.MIGRATE_REPO_PATH))
def initialize_database(): with current_app.app_context(): db.create_all() yield db with current_app.app_context(): try: db.session.commit() except Exception as exception: app_logger.warning(f"Exception occurred: {exception}") pass db.session.remove() db.drop_all()
def create_db(): "Create RoseGuarden database" print "Create database (this will remove old data)" db.create_all() User.query.delete() # add syncmaster-user for synchronisation print "Add syncmaster user" syncMasterUser = User('*****@*****.**', SYNC_MASTER_DEFAULT_PASSWORD, 'Sync', 'Master', 1) syncMasterUser.syncMaster = 1 db.session.add(syncMasterUser) # you can add some default user here print "Add admin user" defaultUser1 = User('Administrator', 'Admin1234', 'RoseGuarden', 'Admin', 1) defaultUser1.accessType = 1 db.session.add(defaultUser1) #db.session.add(Door(id = 0, name = 'front door', address = 'http://192.168.2.137', keyMask = 0x01, local = 0x00 )) #db.session.add(Door(id = 0, name = 'front door', address = 'http://192.168.2.138', keyMask = 0x01, local = 0x00 )) #db.session.add(Door(id = 0, name = 'front door', address = 'http://192.168.2.139', keyMask = 0x01, local = 0x00 )) print "Add local door" Door.query.delete() db.session.add( Door(name=config.NODE_NAME, displayName='Local', address='http://localhost', keyMask=0x03, local=0x01, password=config.SYNC_MASTER_DEFAULT_PASSWORD)) print "Add default settings" Setting.query.delete() db.session.add( Setting('NODE_VALID_KEYS_MASK', '3', Setting.SETTINGTYPE_INT)) print "Add log-entry" Action.query.delete() db.session.add( Action(datetime.datetime.utcnow(), config.NODE_NAME, syncMasterUser.firstName + ' ' + syncMasterUser.lastName, syncMasterUser.email, 'Remove all data & regenerate database', 'Init systen', 'L1', 1, 'Internal')) print "Save new database" db.session.commit() print "Successfully create new database"
def setUp(self): app.config['TESTING'] = True app.config['CSRF_ENABLED'] = False app.config['DEBUG'] = False app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///' + os.path.join( BASE_DIR, TEST_DB) self.app = app.test_client() db.create_all() our_time = "2019-01-05 22:14:39" our_datetime = datetime.strptime(our_time, "%Y-%m-%d %H:%M:%S") self.attemp = Attempt('flag', True, 12, our_datetime, 'user') self.attemp.add()
def drop_and_rebuild_sql(): app = create_app() context = app.app_context() context.push() # define working database working_database = config.DATABASE_NAME # drop working database print(f"Dropping database: {working_database}") db.drop_all() # recreate working database print(f"Creating database: {working_database}") db.create_all() context.pop()
def create_db(): "Create RoseGuarden database" print "Create database (this will remove old data)" db.create_all() User.query.delete() # add syncmaster-user for synchronisation print "Add syncmaster user" syncMasterUser = User('*****@*****.**', SYNC_MASTER_DEFAULT_PASSWORD, 'Sync','Master',1) syncMasterUser.syncMaster = 1 db.session.add(syncMasterUser) # you can add some default user here print "Add admin user" defaultUser1 = User('Administrator','pleasechangethepassword','RoseGuarden','Admin', 1) defaultUser1.accessType = 1 db.session.add(defaultUser1) #db.session.add(Door(id = 0, name = 'front door', address = 'http://192.168.2.137', keyMask = 0x01, local = 0x00 )) #db.session.add(Door(id = 0, name = 'front door', address = 'http://192.168.2.138', keyMask = 0x01, local = 0x00 )) #db.session.add(Door(id = 0, name = 'front door', address = 'http://192.168.2.139', keyMask = 0x01, local = 0x00 )) print "Add local door" Door.query.delete() db.session.add(Door(name = config.NODE_NAME, displayName = 'Local', address = 'http://localhost', keyMask = 0x03, local = 0x01, password= config.SYNC_MASTER_DEFAULT_PASSWORD)) print "Add default settings" Setting.query.delete() db.session.add(Setting('NODE_VALID_KEYS_MASK', '3', Setting.SETTINGTYPE_INT)) print "Add log-entry" Action.query.delete() db.session.add(Action(datetime.datetime.utcnow(), config.NODE_NAME, syncMasterUser.firstName + ' ' + syncMasterUser.lastName, syncMasterUser.email, 'Remove all data & regenerate database', 'Init systen', 'L1', 1, 'Internal')) print "Save new database" db.session.commit() print "Successfully create new database"
from app.server import db from app.server.api.models.Tournament import Tournament from app.server.api.models.TournametsToObjects import TournamentsToObject from app.server.api.models.user import User from app.server.api.models.contestant import Contestant from app.server.api.models.team import Team from app.server.api.models import * db.drop_all() db.create_all() db.session.commit()
def setUp(self): app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///:memory:' db.drop_all() db.create_all()
from app.server import db db.create_all()
def create_db(): """Creates the db tables.""" db.create_all()
def setUp(self): db.drop_all() db.create_all()
def setUp(self): super(BaseTestCase, self).setUp() app.config.update(self.TEST_CONFIG) db.init_app(app) db.create_all() app.config['CSRF_ENABLED'] = False