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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/7860f5ab-64a4-481d-8e72-9b40d2ab2527o%40googlegroups.com.
