Hi, thank you for quick response - I will try again. Maybe my UI tool was giving me bad output since I did not see any error while inserting and while debugging I saw statement similar to yours. Will report back.
best regards On Saturday, March 25, 2017 at 2:37:29 PM UTC+1, Nikola Radovanovic wrote: > > Hello, > I need help; google search and trial-and-error did not do me any good also. > > I cant figure out how to populate DB table with ENUM values during > migration using bulk_insert. to be more precise, NULL values are inserted > instead of proper strings. I can insert using plain SQL from DB UI tools > (DBeaver), tried same SQL in alembic script - still not working. > > Maybe this what I currently have is not the best approach, so feel free to > point me into right direction. DB is Postgres and here is the relevant code > > # model > class ConnectorType(Base): > __tablename__ = 'ConnectorTypes' > > id = Column(Integer, primary_key=True) > description = Column(String(255)) > type = Column(ENUM('MODBUS', 'BACNET', 'SNTP', 'SYSLOG', 'IPTV', > name='connector_type')) > > # alembic > connector_types = op.create_table('ConnectorTypes', > sa.Column('id', sa.Integer(), nullable=False), > sa.Column('description', sa.String(length=255), nullable=True), > sa.Column('type', ENUM(u'MODBUS', u'BACNET', u'SNTP', u'SYSLOG', u'IPTV', > name='connector_type'), autoincrement=False, nullable=True), > sa.PrimaryKeyConstraint('id') > ) > # insert connector types > op.bulk_insert(connector_types, [ > {'description': '', 'type': 'MODBUS'}, > {'description': '', 'type': 'BACNET'}, > {'description': '', 'type': 'SNTP'}, > {'description': '', 'type': 'SYSLOG'}, > {'description': '', 'type': 'IPTV'}, > ]) > > > Thank you in advance. > > > -- 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.