Hi all, Is there a way to update values in the database when new features are deployed to the prod environnement ? I came from the Magento world and there was a handy command called

setup:upgrade

that ran php code from SetupData.php and UpgradeData.php files to edit the values in the database among other things. In Spryker the

propel:install

command modifies the structure of the tables, the

data:import

command imports new data in the database and modify existing data based on keys. Now is there a command to delete data in the database ? Besides deleting the data one by one manually. Thanks !

Not out of the box. Normally you could put that into propel migrations, but they are dropped an regenerated during deployment. We have written a module to do exactly that, run automatic migration before/after deployment, bound to a version. It can not only execute SQL queries, but also trigger commands, for example to republish parts of the data or do whatever is necessary. This resolved a lot of manual work for each deployment for us. Sadly I can't share the code as it's the property of our customer.