On Sun, Jul 10, 2022, at 11:36 PM, Carl Brewer wrote: > On 11/07/2022 1:19 am, Mike Bayer wrote: > > background on mapping ORM classes to reflected tables is at > > https://docs.sqlalchemy.org/en/14/orm/declarative_tables.html#mapping-declaratively-with-reflected-tables > > > > <https://docs.sqlalchemy.org/en/14/orm/declarative_tables.html#mapping-declaratively-with-reflected-tables> > > and there are three general methods depending on your needs. > > DeferredReflection is oriented towards explicit class setup, and automap is > > oriented towards "just give me pre-made classes", with much less ability to > > customize how the classes look and behave. > > > > if you were using automap and needed to override PK for this one class: > > > > from sqlalchemy.ext.automap import automap_base > > from sqlalchemy import create_engine, Integer, Column > > > > Base = automap_base() > > > > > > > > class MyTable(Base): > > __tablename__ = 'my_table' > > > > userID = Column(Integer, primary_key=True) > > groupID = Column(Integer, primary_key=True) > > It's the setting of both as primary_key that does it?
that's the theory anyway yes > > Thank you > > Carl > > -- > 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 > <mailto:sqlalchemy%2bunsubscr...@googlegroups.com>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/258f6797-ed5a-18c1-6fba-a05b538151d1%40bl.echidna.id.au. > -- 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/a313f253-764a-4855-b67d-58dcf0a28b65%40www.fastmail.com.