CLI script for running maintenance & database migrations

By Madhuchandra Raghu on Wednesday, 23 November 2016

Replies 4

Likes 0

Votes 0

We have a fairly large site which has Easysocial as the community extension. For rolling out changes we have a Jenkins based CI setup where changes flow from Dev > QA > Production. A key piece of this is to ensure our upgrades are smooth. For core Joomla and most other extensions we have created a CLI version of the "Fix" button that Joomla provides, which works for most extensions. However in case of Easysocial it's a little hard to do this.

We were using the Maintenance section to do this after moving our file changes, but that's not optimal. Additionally after the 2.0 upgrade we lost access to admin due to a database error.

Will you be able to share a CLI script for running the maintenance tasks ? Alternately will you be able to share the scaffolding code i.e. the libraries etc from ES that need to be loaded so we can write such a script ourselves ?

May i know what is this purpose of running maintenance section from your site? Because if you upgrade to Easysocial 2.0, it actually won't make your admin lost the access and causing those database error.

What database error you hitting?

Will you be able to share a CLI script for running the maintenance tasks ? Alternately will you be able to share the scaffolding code i.e. the libraries etc from ES that need to be loaded so we can write such a script ourselves ?

Currently we do not have any CLI script available in Easysocial.
To be honestly, I'd never heard of scaffolding used in that sense of the word, perhaps you can elaborate more details regarding this so I will see if I can help you on this? Learn something new every day.

Arlex Wong

Wednesday, 23 November 2016 11:14

0 Likes

0 Votes

0 Comments

#299532

Our workflow is such that

- upgrade extension on dev
- push files to git
- Automatic deployment from git to our development server
- automatic deployment to our QA server
- Automatic deployment to our production server

After deploying files on each of the environments we need to manually redo the upgrade so that the maintenance tasks are run. However in case of the 2.0 upgrade we were locked out since I could not access the Joomla installer. Was seeing an SQL error (I will post it later, but it was about some columns missing that weren't in the old version) and could not get to the migration screen either. Therefore we need the cli script.

By scaffolding i mean the core easysocial or foundry libraries that need to be required in a cli script so that I can call the maintenance task via cli.

Madhuchandra Raghu

Wednesday, 23 November 2016 12:56

0 Likes

0 Votes

0 Comments

#299554

We do not have a CLI method for you to do this. You can use the maintenance library,



$lib = ES::maintenance();

$files = $lib->getScriptFiles('from_version');



foreach ($files as $file ) {

    $lib->runScript($files);

}

Mark

Thursday, 24 November 2016 01:31

0 Likes

0 Votes

0 Comments

#299666