Db Migration

[majid1f]

hi,
what can I do for updating db in my extensions? I see MW core and see MW has been created a separate SQL file for each version of MW core and for update worker MW used the current version which stored in DB and compare to version in file, and run DB queries, (as I understood), now what should i do in the my extensions? (i see checkUpdate() and update() methods in the ExtensionInit file)

another question, why MW don't use Yii DB migration strategy for updating DB?

 

[frm.mwz]

what can I do for updating db in my extensions?

If there are changes in the database from one MailWizz version to the next (see update databases sql files), one can update extensions if need be.

 

[majid1f]

i mean my own extensions which i developed, how can i update my added tables? for install i added install.php and then run it in before enable method of the extension page and for delete in same way, but now for update, what should i do?

 

[twisted1919]

@majid1f - extensions upgrade for database should be handled by yourself, for example you can use $this->setOption() and $this->getOption() to set and get options for your extension, and then compare these and if needed be, run the extension update sql.
You should know that the update method is called only when your extension version number changes.

another question, why MW don't use Yii DB migration strategy for updating DB?

There's no real reason, at the time of deciding how to handle upgrades, we decided to roll our own workers instead of migrations because most of the time we had additional work to do in the workers, not just database changes.