sqlalchemy unique across multiple columns

by

Extract from the documentation of the Column:

unique – When True, indicates that this column contains a unique
constraint, or if index is True as well, indicates that the Index
should be created with the unique flag. To specify multiple columns in
the constraint/index or to specify an explicit name, use the
UniqueConstraint or Index constructs explicitly.

As these belong to a Table and not to a mapped Class, one declares those in the table definition, or if using declarative as in the __table_args__:

# version1: table definition
mytable = Table('mytable', meta,
    # ...
    Column('customer_id', Integer, ForeignKey('customers.customer_id')),
    Column('location_code', Unicode(10)),

    UniqueConstraint('customer_id', 'location_code', name="uix_1")
    )
# or the index, which will ensure uniqueness as well
Index('myindex', mytable.c.customer_id, mytable.c.location_code, unique=True)


# version2: declarative
class Location(Base):
    __tablename__ = 'locations'
    id = Column(Integer, primary_key = True)
    customer_id = Column(Integer, ForeignKey('customers.customer_id'), nullable=False)
    location_code = Column(Unicode(10), nullable=False)
    __table_args__ = (UniqueConstraint('customer_id', 'location_code', name="_customer_location_uc"),
                     )

More Related Contents:

  1. How to serialize SqlAlchemy result to JSON?
  2. SQLAlchemy: print the actual query
  3. SQLAlchemy create_all() does not create tables
  4. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  5. SQL Alchemy ORM returning a single column, how to avoid common post processing
  6. Python call sql-server stored procedure with table valued parameter
  7. Generate sql with subquery as a column in select statement using SQLAlchemy
  8. Bulk insert with SQLAlchemy ORM
  9. Can SQLAlchemy be used with Google Cloud SQL?
  10. How can I verify Column data types in the SQLAlchemy ORM?
  11. Updates to JSON field don’t persist to DB
  12. Complex foreign key constraint in SQLAlchemy
  13. ImportError: No module named MySQLdb
  14. Connection problems with SQLAlchemy and multiple processes
  15. How to upsert pandas DataFrame to Microsoft SQL Server table?
  16. How do I select literal values in an sqlalchemy query?
  17. Get inserted key before commit session
  18. SQLAlchemy multiple foreign keys in one mapped class to the same primary key
  19. SQLAlchemy: engine, connection and session difference
  20. Relations on composite keys using sqlalchemy
  21. SQLAlchemy default DateTime
  22. flake8 complains on boolean comparison “==” in filter clause
  23. SQLAlchemy – Mapping self-referential relationship as one to many (declarative form)
  24. Setting SQLAlchemy autoincrement start value
  25. How to close a SQLAlchemy session?
  26. Using SQLAlchemy models in and out of Flask
  27. SQLAlchemy column name with space
  28. Connecting to SQL Server 2012 using sqlalchemy and pyodbc
  29. using sqlalchemy to load csv file into a database
  30. pyodbc.connect() works, but not sqlalchemy.create_engine().connect()

Leave a Comment