<?php
namespace App\Commands;
use \Jackbooted\Config\Cfg;
use \Jackbooted\DB\DB;
class InstallationCLI extends \Jackbooted\Html\WebPage {
public static function init () {
self::$log = \Jackbooted\Util\Log4PHP::logFactory ( __CLASS__ );
}
public static function initialize()
{
$dbType = Cfg::get( 'local-driver' );
switch ( $dbType ) {
case DB::SQLITE:
$dbFileName = Cfg::get( 'local-host' );
echo "Checking that the file $dbFileName exists\n";
if ( file_exists( $dbFileName ) ) {
echo "Database exists ($dbFileName)\n";
}
else {
echo "Creating empty database\n";
touch( $dbFileName );
}
break;
case DB::MYSQL:
$fldHostName = Cfg::get( 'local-host' );
$fldDBName = Cfg::get( 'local-db' );
$fldUsername = Cfg::get( 'local-user' );
$fldPassword = Cfg::get( 'local-pass' );
try {
$dbh = new \PDO( "mysql:host=$fldHostName", $fldUsername, $fldPassword );
$dbh->exec( "CREATE DATABASE IF NOT EXISTS $fldDBName" ) or die( print_r( $dbh->errorInfo(), true ) );
}
catch (PDOException $e) {
die( "DB ERROR: ". $e->getMessage() );
}
break;
default:
die( "Unsupported DB Type: $dbType" );
}
if ( count ( \Jackbooted\DB\DBMaintenance::getTableList() ) == 0 ) {
// Put in the base data
$sqlFileName = Cfg::get ( 'tmp_path' ) . '/base_database.sql';
if ( file_exists( $sqlFileName ) ) {
echo "Running the commands in $sqlFileName against the database\n";
foreach ( explode( ';', file_get_contents( $sqlFileName ) ) as $statement ) {
DB::exec( DB::DEF, $statement );
}
}
else {
die( "Base Database file does not exists ($sqlFileName) aborting\n" );
}
}
else {
die( "Database already seems to be set up." );
}
echo "audititing Table - AlertsDAO\n";
( new \App\Models\AlertsDAO )->auditTable();
return '';
}
}
|
Download
