Python create_all Examples

Example #1

def initdb():
    """Initialize the database."""
    click.echo('Init the db...')
    db.create_all()

    for i in range(30):
        click.echo("Creating user/address combo #{}...".format(i))
        address = Address(description='Address#2' + str(i).rjust(2, "0"))
        db.session.add(address)
        user = User(name='User#1' + str(i).rjust(2, "0"))
        user.address = address
        db.session.add(user)
        sleep(1)
    db.session.commit()

Example #2

File: __init__.py Project: Pegase745/sqlalchemy-datatables

def initdb():
    """Initialize the database."""
    click.echo('Init the db...')
    db.create_all()

    for i in range(30):
        click.echo("Creating user/address combo #{}...".format(i))
        address = Address(description='Address#2' + str(i).rjust(2, "0"))
        db.session.add(address)
        user = User(name='User#1' + str(i).rjust(2, "0"))
        user.address = address
        db.session.add(user)
        sleep(1)
    db.session.commit()

Example #3

File: initializedb.py Project: vitasiku/sqlalchemy-datatables

"""Initialize DB with fixtures."""
from time import sleep
from flask_tut.models import (
    db,
    User,
    Address,
)

db.create_all()

i = 0
while i < 30:
    address = Address(description='Address#2' + str(i).rjust(2, "0"))
    db.session.add(address)
    user = User(name='User#1' + str(i).rjust(2, "0"))
    user.address = address
    db.session.add(user)
    sleep(1)
    i += 1
db.session.commit()

Example #4

File: initializedb.py Project: NicolasBertrand/sqlalchemy-datatables

"""Initialize DB with fixtures."""
from time import sleep
from flask import Flask
from flask_tut.models import (
    db,
    User,
    Address,
)

app = Flask(__name__)

with app.app_context():
    db.create_all()

i = 0
while i < 30:
    address = Address(description='Address#2' + str(i).rjust(2, "0"))
    db.session.add(address)
    user = User(name='User#1' + str(i).rjust(2, "0"))
    user.address = address
    db.session.add(user)
    sleep(1)
    i += 1
db.session.commit()