Python create_all Examples

Example #1

File: modeltest.py Project: JackRamey/MTGLeague

    def setUpClass(cls):
        db.drop_all()
        db.create_all()

        u1 = User('user1', '*****@*****.**', 'u1')
        u2 = User('user2', '*****@*****.**', 'u2')
        db.session.add(u1)
        db.session.add(u2)
        db.session.commit()

        league = League('TestLeague')
        db.session.add(league)
        db.session.commit()

        event = Event('TestEvent', league)
        db.session.add(event)
        db.session.commit()

        stage = Stage(event, date.today(), date.today())
        db.session.add(stage)
        db.session.commit()

        p1 = Participant(u1, event)
        p2 = Participant(u2, event)
        db.session.add(p1)
        db.session.add(p2)
        db.session.commit()

        m = Match(stage, p1, p2)
        m.add_results(p1_wins=2,p2_wins=0)
        db.session.add(m)
        db.session.commit()

Example #2

    def setUpClass(cls):
        db.drop_all()
        db.create_all()

        u1 = User('user1', '*****@*****.**', 'u1')
        u2 = User('user2', '*****@*****.**', 'u2')
        db.session.add(u1)
        db.session.add(u2)
        db.session.commit()

        league = League('TestLeague')
        db.session.add(league)
        db.session.commit()

        event = Event('TestEvent', league)
        db.session.add(event)
        db.session.commit()

        stage = Stage(event, date.today(), date.today())
        db.session.add(stage)
        db.session.commit()

        p1 = Participant(u1, event)
        p2 = Participant(u2, event)
        db.session.add(p1)
        db.session.add(p2)
        db.session.commit()

        m = Match(stage, p1, p2)
        m.add_results(p1_wins=2, p2_wins=0)
        db.session.add(m)
        db.session.commit()

Example #3

File: db_create.py Project: JackRamey/MTGLeague

from migrate.versioning import api
from config import SQLALCHEMY_DATABASE_URI
from config import SQLALCHEMY_MIGRATE_REPO
from mtgleague.util import db
import os.path

db.create_all()

if not os.path.exists(SQLALCHEMY_MIGRATE_REPO):
    api.create(SQLALCHEMY_MIGRATE_REPO, 'database repository')
    api.version_control(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO)
else:
    api.version_control(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO, api.version(SQLALCHEMY_MIGRATE_REPO))

Example #4

File: db_create.py Project: JackRamey/MTGLeague

from migrate.versioning import api
from config import SQLALCHEMY_DATABASE_URI
from config import SQLALCHEMY_MIGRATE_REPO
from mtgleague.util import db
import os.path

db.create_all()

if not os.path.exists(SQLALCHEMY_MIGRATE_REPO):
    api.create(SQLALCHEMY_MIGRATE_REPO, 'database repository')
    api.version_control(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO)
else:
    api.version_control(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO,
                        api.version(SQLALCHEMY_MIGRATE_REPO))