Need to run the super table fix-content-tables from CLI

Question

We have an issue where the super-table fix-content-tables needs to be run. This fixes the issue on local and development environments.

The problem is we have a very restricted production environment from the customer and need to trigger the repair from the CLI (deploy time command) otherwise it has timeout issues running it from frontend.

What's the best way for us to achieve this?

Answer 1

Under the hood, the Super Table fix is running a migration behind a controller, which you can call in a content migration directly in your project. I have done the same, due needing to script it in a deployment.

<?php
namespace craft\contentmigrations;
use craft\db\Migration;
use verbb\supertable\migrations\m190120_000000_fix_supertablecontent_tables;
/**

m190412_102156_fix_super_table_content_tables migration.

Runs the fix content table migration part of Super Table plugin

*/
class m190412_102156_fix_super_table_content_tables extends Migration
{
public function safeUp()
{
    echo &quot;    &gt; Starting migration for fixing Super Table content...\n&quot;;
    (new m190120_000000_fix_supertablecontent_tables())-&gt;safeUp();

    return true;
}

/**
 * @inheritdoc
 */
public function safeDown()
{
    echo &quot;m190412_102156_fix_super_table_content_tables cannot be reverted.\n&quot;;
    return false;
}

}