Laravel Useful helpers

helpers.php

<?php


if (! function_exists('change_db_storage')) :

    /**
     * Changing all tables database storage
     * i.e InnoDB/MyISAM
     */
    function change_db_storage( $storage = 'InnoDB' ) {

        $tables = DB::select('SHOW TABLES');

        $tables = array_map(function ($table) use ($storage) {
            DB::statement(sprintf("ALTER TABLE %s ENGINE = {$storage}", $table->Tables_in_smscore_db));
            return $table->Tables_in_smscore_db . " changed to {$storage} successfully.";
        }, $tables);

        return $tables;

    }

endif;