install.php

<?php
    require_once '../app/vendor/autoload.php';
    require_once 'utilities.php';

    use Carbon\Carbon;
    use Dotenv\Dotenv;
    use Dotenv\Exception\InvalidPathException;
    use Illuminate\Database\Capsule\Manager as Capsule;
    use Illuminate\Database\Schema\Blueprint;
    use Slim\Container;
    use Slim\Http\Uri;

    use UserFrosting\Sprinkle\Core\Initialize\SprinkleManager;

    if (!defined('STDIN')) {
        die('This program must be run from the command line.');
    }

    // TODO: check PHP version


    // First, we create our DI container
    $container = new Container;

    // Attempt to fetch list of Sprinkles
    $sprinklesFile = file_get_contents('../app/sprinkles/sprinkles.json');
    if ($sprinklesFile === false) {
        die(PHP_EOL . "File 'app/sprinkles/sprinkles.json' not found. Please create a 'sprinkles.json' file and try again." . PHP_EOL);
    }
    $sprinkles = json_decode($sprinklesFile)->base;

    // Set up sprinkle manager service and list our Sprinkles.  Core sprinkle does not need to be explicitly listed.
    $container['sprinkleManager'] = function ($c) use ($sprinkles) {
        return new SprinkleManager($c, $sprinkles);
    };

    // Now, run the sprinkle manager to boot up all our sprinkles
    $container->sprinkleManager->init();

    $container->config['settings.displayErrorDetails'] = false;

    $config = $container->config;

    $container->db;

    // Test database connection
    try {
        Capsule::connection()->getPdo();
    } catch (\Exception $e) {
        $dbParams = $config['db.default'];
        die(PHP_EOL . "Could not connect to the database '{$dbParams['username']}@{$dbParams['host']}/{$dbParams['database']}'.  Please check your database configuration." . PHP_EOL);
    }

    $schema = Capsule::schema();

    $installTime = Carbon::now();

    $ufVersion = "4.0.0-alpha";

    $detectedOS = php_uname('s');

    echo PHP_EOL . "Welcome to the UserFrosting installation tool!" . PHP_EOL;
    echo "The detected operating system is '$detectedOS'." . PHP_EOL;
    echo "Is this correct?  [Y/n]: ";

    $answer = trim(fgets(STDIN));

    if (!in_array(strtolower($answer), array('yes', 'y'))) {
        // OS
        echo PHP_EOL . "Please enter 'W' for a Windows-based operating system, or 'U' for OSX, Linux, or another Unix-based platform: ";
        $osCode = strtoupper(trim(fgets(STDIN)));
        while (!($osCode == 'W' || $osCode == 'U')) {
            echo 'Invalid selection, please try again: ';
            $osCode = strtoupper(trim(fgets(STDIN)));
        }

        if ($osCode == 'W') {
            $detectedOS = "Windows";
        } else {
            $detectedOS = "Unix";
        }
    }

    // Get the installed versions
    echo PHP_EOL . "Checking for Sprinkle's version table:" . PHP_EOL;

    if (!$schema->hasTable('version')) {
        $schema->create('version', function (Blueprint $table) {
            $table->string('sprinkle', 45)->nullable();
            $table->string('version', 25)->nullable();
            $table->timestamps();

            $table->engine = 'InnoDB';
            $table->collation = 'utf8_unicode_ci';
            $table->charset = 'utf8';
            $table->unique('sprinkle');
        });
        Capsule::table('version')->insert([
            [
                'sprinkle' => 'core',
                'version' => $ufVersion,
                'created_at' => $installTime,
                'updated_at' => $installTime
            ]
        ]);

        echo "Installing UserFrosting $ufVersion for the first time..." . PHP_EOL;
        echo "Created table 'version'..." . PHP_EOL;
    } else {
        echo "Table 'version' found." . PHP_EOL;
    }

    // Load the sprinkles list
    echo PHP_EOL . "Migrating Sprinkle's:" . PHP_EOL;

    // Looping throught every sprinkle and running their migration
    // N.B.: No migrations in core... yet. Add it manually if migration is added
    // to core at some point
    foreach ($sprinkles as $sprinkle) {

        echo ">> $sprinkle" . PHP_EOL;

        // Find all available version
        $migrations = glob("../app/sprinkles/$sprinkle/migrations/*.php");

        if (empty($migrations)) {
            echo "No migrations found for sprinkle '$sprinkle'..." . PHP_EOL.PHP_EOL;

        } else {

            // Get current installed version
            $installedVersion = Capsule::table('version')->where('sprinkle', $sprinkle)->first();
            $installedVersion = ($installedVersion != null) ? $installedVersion->version : 0;

            // Loop migrations files and run the ones we needs
            foreach ($migrations as $filepath) {
                $version = basename($filepath, ".php");
                if (version_compare($installedVersion, $version, "<")) {
                    require_once $filepath;
                }
            }

            if ($installedVersion == 0) {
                Capsule::table('version')->insert([
                    [
                        'sprinkle' => $sprinkle,
                        'version' => $version,
                        'created_at' => $installTime,
                        'updated_at' => $installTime
                    ]
                ]);

                echo "Migrated sprinkle '$sprinkle' to $version..." . PHP_EOL.PHP_EOL;

            } else if (version_compare($installedVersion, $version, "<")) {
                Capsule::table('version')->where('sprinkle', $sprinkle)
                    ->update(
                        [
                            'version' => $version,
                            'updated_at' => $installTime
                        ]
                    );

                echo PHP_EOL."Migrated sprinkle '$sprinkle' from $installedVersion to $version..." . PHP_EOL.PHP_EOL;
            } else {
                echo "Sprinkle '$sprinkle' already up-to-date..." . PHP_EOL.PHP_EOL;
            }
        }
    }

    /*
    $uri = new Uri(
        empty($_SERVER['HTTPS']) || $_SERVER['HTTPS'] === 'off' ? 'http' : 'https',
        trim($_SERVER['SERVER_NAME'], '/'),
        null,
        trim(realpath(__DIR__ . '/../public'), '/')
    );

    // Slim\Http\Uri likes to add trailing slashes when the path is empty, so this fixes that.
    $uri = trim($uri, '/');
    */

    // Migrate the UF version
    Capsule::table('version')->where('sprinkle', 'core')
        ->update(
            [
                'version' => $ufVersion,
                'updated_at' => $installTime
            ]
        );

    echo PHP_EOL.PHP_EOL."UserFrosting migrated to $ufVersion successfully !".PHP_EOL;