implement autogen detection for ONUPDATE/ONDELETE in fks

[sqlalchemy-bot]

Migrated issue, originally created by Michael Bayer (@zzzeek)

since some backends support "options" and we support FKs.

[sqlalchemy-bot]

Michael Bayer (@zzzeek) wrote:

Issue #79 was marked as a duplicate of this issue.

[sqlalchemy-bot]

Michael Bayer (@zzzeek) wrote:

• Implemented support for autogenerate detection of changes in the
  ondelete, onupdate, initially and deferrable
  attributes of :class:.ForeignKeyConstraint objects on
  SQLAlchemy backends that support these on reflection
  (as of SQLAlchemy 1.0.8 currently Postgresql for all four,
  MySQL for ondelete and onupdate only). A constraint object
  that modifies these values will be reported as a "diff" and come out
  as a drop/create of the constraint with the modified values.
  The fields are ignored for backends which don't reflect these
  attributes (as of SQLA 1.0.8 this includes SQLite, Oracle, SQL Server,
  others). fixes implement autogen detection for ONUPDATE/ONDELETE in fks #317

→ df92071

[sqlalchemy-bot]

Changes by Michael Bayer (@zzzeek):

• changed status to closed

[sqlalchemy-bot]

jmagnusson (@jmagnusson) wrote:

Fantastic addition, thanks Mike!