Opened 2 months ago

Last modified 2 months ago

#29377 new New feature

DatabaseSchemaEditor: add a hook to run DML statements after the entire schema is created

Reported by: Maximiliano Robaina Owned by: nobody
Component: Migrations Version: 2.0
Severity: Normal Keywords:
Cc: Maximiliano Robaina Triage Stage: Accepted
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description (last modified by Maximiliano Robaina)

A nice option would be to have a hook to run DML statements after all migrations were applied and commited.

A uses case (for example in Firebird SQL) is to add a new field on already existing and populated table. Is not enough set and drop a default value, we need to update the new field with efective default value. It is not possible without commit the schema alteration.
An aproach could be to have a kind of hook to run sql statements (DML statement in this case) when the schema altereation finished (and commited). Of course, must bu runned in another transaction.

This feature request is to better support of third-party database backends.

Change History (4)

comment:1 Changed 2 months ago by Tim Graham

Did you forgot about #26399 that you created or is this is a different issue?

comment:2 Changed 2 months ago by Maximiliano Robaina

Tim,

It's a different issue. May be I need to write It better.
In this case is just for run a DML statement after all migrations were applied (and commited). About change of defaults values that I mencioned is just an uses case.

comment:3 Changed 2 months ago by Maximiliano Robaina

Cc: Maximiliano Robaina added
Description: modified (diff)

comment:4 Changed 2 months ago by Tim Graham

Triage Stage: UnreviewedAccepted
Note: See TracTickets for help on using tickets.
Back to Top