Python create_all示例

示例#1

文件： base.py 项目： saapooch/Flask-Boilerplate

 def setUp(self):
     db.create_all()
     user = User(username='******',
                 email="*****@*****.**",
                 password="******")
     db.session.add(user)
     db.session.commit()

示例#2

文件： testTournament.py 项目： trmasha2002/Platform-CTF

    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()

示例#3

 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))

示例#4

文件： db_create.py 项目： threatintel-c/poc-1

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))

示例#5

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()

示例#6

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"

示例#7

    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()

示例#8

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()

示例#9

文件： roseGuarden.py 项目： blinzelaffe/roseguarden

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"

示例#10

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()

示例#11

 def setUp(self):
     app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///:memory:'
     db.drop_all()
     db.create_all()

示例#12

文件： db_create.py 项目： Nerevarsoul/bookmark

from app.server import db


db.create_all()

示例#13

def create_db():
    """Creates the db tables."""
    db.create_all()

示例#14

 def setUp(self):
     db.drop_all()
     db.create_all()

示例#15

文件： base_database_test.py 项目： biddyweb/StoreKeeper

 def setUp(self):
     db.drop_all()
     db.create_all()

示例#16

文件： base.py 项目： trmasha2002/Platform-CTF

 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