Creating partial unique index with sqlalchemy on Postgres

by 
class ScheduledPayment(Base):
    id = Column(Integer, primary_key=True)
    invoice_id = Column(Integer)
    is_canceled = Column(Boolean, default=False)

    __table_args__ = (
        Index('only_one_active_invoice', invoice_id, is_canceled,
              unique=True,
              postgresql_where=(~is_canceled)),
    )

More Related Contents:

  1. How to write DataFrame to postgres table
  2. CS50: LIKE operator, variable substitution with % expansion
  3. SQLAlchemy create_all() does not create tables
  4. Executing multiple statements with Postgresql via SQLAlchemy does not persist changes
  5. How to create an SQL View with SQLAlchemy?
  6. Generate sql with subquery as a column in select statement using SQLAlchemy
  7. Updates to JSON field don’t persist to DB
  8. Complex foreign key constraint in SQLAlchemy
  9. Connection problems with SQLAlchemy and multiple processes
  10. How to upsert pandas DataFrame to PostgreSQL table?
  11. SQLAlchemy multiple foreign keys in one mapped class to the same primary key
  12. sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
  13. SQLAlchemy – performing a bulk upsert (if exists, update, else insert) in postgresql
  14. Strange SQLAlchemy error message: TypeError: ‘dict’ object does not support indexing
  15. SQLAlchemy func.count on boolean column
  16. How to set connection timeout in SQLAlchemy
  17. SQLAlchemy: filtering on values stored in nested list of the JSONB field
  18. How to prevent UUID primary key for new SQLAlchemy objects being created with the same value
  19. Django JSONField inside ArrayField
  20. Error: pg_config executable not found when installing psycopg2 on Alpine in Docker
  21. SQLAlchemy, get object not bound to a Session
  22. psycopg2.OperationalError: FATAL: unsupported frontend protocol 1234.5679: server supports 2.0 to 3.0
  23. How to delete a record by id in Flask-SQLAlchemy
  24. Error Installing Psycopg2 on MacOS 10.9.5
  25. SQLAlchemy printing raw SQL from create()
  26. Docker- django throws error while connecting to postgres: psycopg2.OperationalError: could not connect to server: Connection refused
  27. sqlalchemy existing database query
  28. Flask-SQLAlchemy Constructor
  29. convert selected datetime to date in sqlalchemy
  30. How does COPY work and why is it so much faster than INSERT?

Leave a Comment