Hi there - I have no idea what you are seeing. an actual ALTER COLUMN operation does not delete rows. Of course, if you are using SQLite and batch mode, that might affect things, but you have not specified this. Please specify complete information including log output, stack traces, database in use, sample schema, etc.
On Mon, Oct 8, 2018 at 9:36 AM Richard <goo...@richard.do> wrote: > > > Note that if I do the same op.alter_column on another table which has a > customer FK, it works fine and does not delete all the rows. > > On Monday, October 8, 2018 at 1:50:38 PM UTC+1, Richard wrote: >> >> I have an alembic migration which renames a FK column on a table from >> 'customer_id' to 'customer_pk'. >> >> I used to have more in the migration file but narrowed it down to this code >> causing all the rows to be deleted. >> >> def upgrade(): >> op.alter_column( >> 'daily_smart_meter_readings', column_name='customer_id', >> new_column_name='customer_pk', >> ) >> >> >> I'm using alembic==1.0.0 and Python 3.6.4. >> >> Is there something wrong with the above code or is this a bug in the library? >> >> Thanks > > -- > 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. -- 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.
