Calling Developers!
We are reenergizing our code contribution process! Learn More

What are the Slack Archives?

It’s a history of our time together in the Slack Community! There’s a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.

Because this space is not active, you won’t be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..

Hi all, Is there a way to update values in the database when new features are deployed to the prod

Options
U04TQ9UG04U
U04TQ9UG04U Posts: 25 🧑🏻‍🚀 - Cadet

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 !

Comments

  • Alberto Reyer
    Alberto Reyer Lead Spryker Solution Architect / Technical Director Posts: 690 🪐 - Explorer
    Options

    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.