Skip to content Skip to sidebar Skip to footer

Alembic Bulk_insert To Table With Schema

I'm looking at the example at bulk_insert. # Create an ad-hoc table to use for the insert statement. accounts_table = table('account', column('id', Integer), column('name',

Solution 1:

The answer I've found so far is to use the sqlalchemy function instead like below:

accounts_table = sa.Table('accounts_table', sa.MetaData(),
    sa.Column('id', sa.Integer),
    sa.Column('name', sa.String(100)),
    sa.Column('create_date', sa.Date),
    schema='phone'
)

Post a Comment for "Alembic Bulk_insert To Table With Schema"