Exemplo n.º 1
0
def create_tables(client):

    return tables.create_all(client)
Exemplo n.º 2
0
def __create(args):
    print('--- Creating tables ---')
    pprint.pprint(tables.create_all(args.client), indent=2)
Exemplo n.º 3
0
from random import randint

import datetime
from sqlalchemy import create_engine, select, func
from sqlalchemy.engine.url import URL

import settings
import utils
import tables

engine = create_engine(URL(**settings.DATABASE))
tables.create_all(engine)

data = utils.get_static_data()

with engine.begin() as conn:
    for book in data['books']:
        ins = tables.Book.insert().values(title=book)
        conn.execute(ins)

ins = tables.Person.insert()
values = []
for person in data['persons']:
    dob = utils.get_dob(1980, 2010)
    values.append({'name': person, 'date_of_birth': dob})

with engine.begin() as conn:
    conn.execute(ins, values)

ins = tables.Write.insert()
with engine.begin() as conn: