I've just done something like this the other day, but it was with an existing sequence. We're using Alembic for schema updates, so I'm not sure whether SQLAlchemy's built-in create_all would behave the same way. You should still be able to use a similar approach.
shared_sequence = Sequence('shared_id__seq') class ModelA(Base): shared_id = Column(Integer, primary_key=True, default=shared_sequence.next_value(), server_default=shared_sequence.next_value()) class ModelB(Base): shared_id = Column(Integer, primary_key=True, default=shared_sequence.next_value(), server_default=shared_sequence.next_value()) This seems to be working fine. Before that I'd tried providing Sequence as an arg to Column like you have and I'd run into some problems and this seemed like an easier option. On Wed, 5 Aug 2020 at 13:59, Zsolt Ero <zsolt....@gmail.com> wrote: > Hi, > > I've split a table into two tables, for performance reasons. I'd like to > insert into both tables using the same sequence. I'm inserting using > executemany_mode='values'. > > My idea is to call nextval() on the sequence before insert and fill in the > values client side, before inserting. > > select nextval('mysql') FROM generate_series(1,...) > > Everything looks good, except for the default behaviour of SQLAlchemy to > turn an integer + pk column into a SERIAL. > > As an alternative I'm also looking at using Sequence('myseq') from > https://docs.sqlalchemy.org/en/13/dialects/postgresql.html#sequences-serial-identity, > but this is broken for issuing "CREATE SEQUENCE myseq" before the table > creation, which is missing the IF NOT EXISTS part. > > How can I either: > - turn off the automatic behaviour of making a pg + int = serial? > - add a IF NOT EXISTS to the Sequence()? > > Or any alternative ideas? > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/7860f5ab-64a4-481d-8e72-9b40d2ab2527o%40googlegroups.com > <https://groups.google.com/d/msgid/sqlalchemy/7860f5ab-64a4-481d-8e72-9b40d2ab2527o%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Michael Mulqueen *Method B Ltd* m...@method-b.uk / +44 (0)330 223 0864 http://www.method-b.uk/ Method B Limited is registered in England and Wales with the company number 9189496. Registered office: 28-29 Richmond Place, Brighton, East Sussex, England, BN2 9NA -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/CAHxMHYXTJ8zLobCdW%2BAtTMaUHGFKkub-9L8cEJMJhYBfPUO%3DQA%40mail.gmail.com.