Hello, I tried now and it worked - very strange since I was debugging at Saturday more than 5 hours and kept displaying NULL. Thank you very much for your help!
Best regards On Sunday, March 26, 2017 at 12:37:21 PM UTC+2, Nikola Radovanovic wrote: > > 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.