Thank you for the answer, but how it can help...
I tried, but I NEED autoincrement (SERIAL in postgres), NO NEED primary key
on this, particular column.
Also I tried with Sequence and without autoincrement:
Column('id', BIGINT, sa.Sequence('test_seq'), autoincrement=False,
nullable=False)
no result too.
I *need* to get:
[sql] id BIGSERIAL
but *got*:
[sql] id BIGINT
I found some *workaround*, but *with warning*:
t = Table(
'outputs', metadata,
Column('id', BIGINT, primary_key=True, autoincrement=True,
nullable=False)
# Partitioning columns
Column('run_id', None, ForeignKey('runs.id', onupdate='CASCADE',
ondelete='CASCADE'), nullable=False, index=True),
Column('hotel', Integer, nullable=False),
sa.PrimaryKeyConstraint('id', 'hotel', 'run_id'),
postgresql_partition_by='range(hotel, run_id)'
)
in this case I got exactly what I want:
CREATE TABLE me_hotels_bc_fb_prediction_steps_outputs (
id BIGSERIAL NOT NULL,
run_id INTEGER NOT NULL,
hotel INTEGER NOT NULL,
PRIMARY KEY (id, hotel, run_id),
FOREIGN KEY(run_id) REFERENCES runs (id) ON DELETE CASCADE ON UPDATE CASCADE
)
PARTITION BY range(hotel, run_id)
*warning*:
sqlalchemy/sql/schema.py:3615: SAWarning:
Table 'outputs' specifies columns 'id' as primary_key=True, not matching
locally specified columns 'id', 'hotel', 'run_id'; setting the current
primary key columns to 'id', 'hotel', 'run_id'. This warning may become an
exception in a future release
вторник, 29 сентября 2020 г. в 21:05:47 UTC+4, Mike Bayer:
> set autoincrement=False in the Column definition
>
> Column('id', BIGINT, autoincrement=False)
>
>
>
> On Tue, Sep 29, 2020, at 3:49 PM, Павел Фролов wrote:
>
> Hi all,
>
> I need just autoincrement without primary key, like:
>
> CREATE TABLE test (
> id BIGSERIAL NOT NULL,
> run_id INTEGER NOT NULL
> );
>
> How it's do with sqlalchemy core?
>
> I tried:
>
> sa.Column('id', sa.BIGINT(), sa.Sequence('test_seq')),
> or
> sa.Column('id', sa.BIGINT(), autoincrement=True),
> ->
> id BIGINT,
> (no serial)
>
> I see in docs that autoincrement can be only with primary key.
>
> I asked docs and google - can not find solution.
>
>
> --
> 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/4629a9b3-3a8e-47b8-8d9a-580242e81d9fn%40googlegroups.com
>
> <https://groups.google.com/d/msgid/sqlalchemy/4629a9b3-3a8e-47b8-8d9a-580242e81d9fn%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
>
>
--
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/f8a2df2f-05ff-49da-80ef-8eb71aa326a1n%40googlegroups.com.
