Hi everyone,
I'm new in the amazing world of Flask & SA and I'm running into a loop.
I'm using Flask and SA using:
*db = SQLAlchemy(app)*
*db.reflect('__all__', app)*
I wrote 3 migrations using ForeignKey with Alembic
op.create_table(
'website_infos',
sa.Column('id', sa.Integer, primary_key=True),
sa.Column('website_id', sa.Integer, sa.ForeignKey('websites.id')),
sa.Column('country_id', sa.Integer, sa.ForeignKey('countries.id')),
...
)
op.create_table(
'website_urls',
sa.Column('id', sa.Integer, primary_key=True),
...
)
op.create_table(
'visits',
sa.Column('id', sa.Integer, primary_key=True),
sa.Column('country_id', sa.Integer, sa.ForeignKey('countries.id')),
sa.Column('device_id', sa.Integer, sa.ForeignKey('devices.id')),
sa.Column('website_url_id', sa.Integer,
sa.ForeignKey('website_urls.id')),
sa.Column('website_info_id', sa.Integer,
sa.ForeignKey('website_infos.id')),
...
)
and when I run *alembic upgrade head* I get this error:
*sqlalchemy.exc.NoSuchTableError: website_urls*
Website_urls is part of my 3 migrations I want Alembic to generate.
If I remove db.reflect('__all__', app) I get an other error from sqlalchemy:
*could not assemble any primary key columns for mapped table 'website_info'*
I believe sqlalchemy wants me to define my table in my models but I'm using
the reflexion to not have to do that.
If anyone can provide me guidance that will be awesome.
Full stacks:
https://gist.github.com/GabKlein/43d520cc458e1acb10de
https://gist.github.com/GabKlein/b29b1ae6fae55460fbbb
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy-alembic" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy-alembic+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
