/** * Class constructor * * @param \Comodojo\Database\EnhancedDatabase $dbh * @param string $table Name of table * @param string $table_prefix Prefix for table * @param \Monolog\Logger $logger Logger instance * * @throws \Comodojo\Exception\CacheException */ public function __construct(EnhancedDatabase $dbh, $table = null, $table_prefix = null, \Monolog\Logger $logger = null) { if (!empty($table)) { $this->table = $table; } else { if (defined("COMODOJO_CACHE_DATABASE_TABLE")) { $this->table = COMODOJO_CACHE_DATABASE_TABLE; } else { throw new CacheException("Database table cannot be undefined"); } } if (empty($table_prefix)) { $this->table_prefix = defined("COMODOJO_CACHE_DATABASE_TABLEPREFIX") ? COMODOJO_CACHE_DATABASE_TABLEPREFIX : null; } else { $this->table_prefix = $table_prefix; } $this->dbh = $dbh; $this->dbh->autoClean(); try { parent::__construct($logger); } catch (CacheException $ce) { throw $ce; } }
protected function initDatabase(Configuration $configuration) { $model = $configuration->get('database-model'); $host = $configuration->get('database-host'); $port = $configuration->get('database-port'); $name = $configuration->get('database-name'); $user = $configuration->get('database-user'); $password = $configuration->get('database-password'); $prefix = $configuration->get('database-prefix'); try { $database = new EnhancedDatabase($model, $host, $port, $name, $user, $password); $database->tablePrefix($prefix); $database->autoClean(); } catch (DatabaseException $de) { throw $de; } catch (Exception $e) { throw $e; } return $database; }
public static function emptyDatabase() { try { $db = new EnhancedDatabase(EXTENDER_DATABASE_MODEL, EXTENDER_DATABASE_HOST, EXTENDER_DATABASE_PORT, EXTENDER_DATABASE_NAME, EXTENDER_DATABASE_USER, EXTENDER_DATABASE_PASS); $db->autoClean(); $db->tablePrefix(EXTENDER_DATABASE_PREFIX)->table(EXTENDER_DATABASE_TABLE_JOBS)->truncate(); // $db->clean(); $db->tablePrefix(EXTENDER_DATABASE_PREFIX)->table(EXTENDER_DATABASE_TABLE_WORKLOGS)->truncate(); } catch (DatabaseException $de) { unset($db); throw new ShellException("Database error: " . $de->getMessage()); } unset($db); }
define("EXTENDER_DATABASE_FOLDER", EXTENDER_REAL_PATH . "database/"); define("EXTENDER_CACHE_FOLDER", EXTENDER_REAL_PATH . "cache/"); define("EXTENDER_DATABASE_MODEL", "SQLITE_PDO"); define("EXTENDER_DATABASE_HOST", "localhost"); define("EXTENDER_DATABASE_PORT", 1); define("EXTENDER_DATABASE_NAME", EXTENDER_DATABASE_FOLDER . "extender.sqlite"); define("EXTENDER_DATABASE_USER", "comodojo"); define("EXTENDER_DATABASE_PASS", ""); define("EXTENDER_DATABASE_PREFIX", "extender_"); define("EXTENDER_DATABASE_TABLE_JOBS", "jobs"); define("EXTENDER_DATABASE_TABLE_WORKLOGS", "worklogs"); // custom config files define("EXTENDER_TASKS_CONFIG", EXTENDER_REAL_PATH . "tasks.yaml"); define("EXTENDER_COMMANDS_CONFIG", EXTENDER_REAL_PATH . "commands.yaml"); define("EXTENDER_PLUGINS_CONFIG", EXTENDER_REAL_PATH . "plugins.yaml"); // override exit codes define("COMODOJO_PHPUNIT_TEST", true); // create database try { $db = new EnhancedDatabase(EXTENDER_DATABASE_MODEL, EXTENDER_DATABASE_HOST, EXTENDER_DATABASE_PORT, EXTENDER_DATABASE_NAME, EXTENDER_DATABASE_USER, EXTENDER_DATABASE_PASS); $db->autoClean(); $db->tablePrefix(EXTENDER_DATABASE_PREFIX)->table(EXTENDER_DATABASE_TABLE_JOBS)->drop(true); $db->tablePrefix(EXTENDER_DATABASE_PREFIX)->table(EXTENDER_DATABASE_TABLE_WORKLOGS)->drop(true); $jobs = $db->tablePrefix(EXTENDER_DATABASE_PREFIX)->table(EXTENDER_DATABASE_TABLE_JOBS)->column(Column::create('id', 'INTEGER')->unsigned()->autoIncrement()->primaryKey())->column(Column::create('name', 'STRING')->length(128)->notNull()->unique())->column(Column::create('task', 'STRING')->length(128)->notNull())->column(Column::create('description', 'TEXT')->defaultValue(null))->column(Column::create('enabled', 'BOOL')->defaultValue(0))->column(Column::create('min', 'STRING')->length(16)->defaultValue(null))->column(Column::create('hour', 'STRING')->length(16)->defaultValue(null))->column(Column::create('dayofmonth', 'STRING')->length(16)->defaultValue(null))->column(Column::create('month', 'STRING')->length(16)->defaultValue(null))->column(Column::create('dayofweek', 'STRING')->length(16)->defaultValue(null))->column(Column::create('year', 'STRING')->length(16)->defaultValue(null))->column(Column::create('params', 'TEXT')->defaultValue(null))->column(Column::create('lastrun', 'INTEGER')->length(64)->defaultValue(null))->column(Column::create('firstrun', 'INTEGER')->length(64)->notNull())->create(EXTENDER_DATABASE_TABLE_JOBS); // $db->clean(); $worklogs = $db->tablePrefix(EXTENDER_DATABASE_PREFIX)->table(EXTENDER_DATABASE_TABLE_WORKLOGS)->column(Column::create('id', 'INTEGER')->unsigned()->autoIncrement()->primaryKey())->column(Column::create('pid', 'INTEGER')->unsigned()->defaultValue(null))->column(Column::create('jobid', 'INTEGER')->unsigned()->defaultValue(null))->column(Column::create('name', 'STRING')->length(128)->notNull())->column(Column::create('task', 'STRING')->length(128)->notNull())->column(Column::create('status', 'STRING')->length(12)->notNull())->column(Column::create('success', 'BOOL')->defaultValue(0))->column(Column::create('result', 'TEXT')->defaultValue(null))->column(Column::create('start', 'STRING')->length(64)->notNull())->column(Column::create('end', 'STRING')->length(64)->defaultValue(null))->create(EXTENDER_DATABASE_TABLE_WORKLOGS); } catch (DatabaseException $de) { unset($db); throw new ShellException("Database error: " . $de->getMessage()); } unset($db);
private static function pushDefaultContent() { try { $db = new EnhancedDatabase(EXTENDER_DATABASE_MODEL, EXTENDER_DATABASE_HOST, EXTENDER_DATABASE_PORT, EXTENDER_DATABASE_NAME, EXTENDER_DATABASE_USER, EXTENDER_DATABASE_PASS); $db->tablePrefix(EXTENDER_DATABASE_PREFIX); $db->autoClean(); // admin role $admin_role_id = $db->table('roles')->keys(array('name', 'description'))->values(array('admin', 'Default administrator role'))->store()->getInsertId(); $authentication_id = $db->table('authentication')->keys(array('name', 'description', 'class'))->values(array('local', 'Local Authentication Provider', '\\Comodojo\\Authentication\\Provider\\LocalProvider'))->store()->getInsertId(); $admin_pwd = password_hash('comodojo', PASSWORD_DEFAULT); $admin_user_id = $db->table('users')->keys(array('username', 'password', 'displayname', 'mail', 'authentication', 'enabled', 'primaryrole'))->values(array('admin', $admin_pwd, 'Administrator', 'administrator@localhost', $authentication_id, 1, $admin_role_id))->store()->getInsertId(); $db->table('users_to_roles')->keys(array('user', 'role'))->values(array($admin_user_id, $admin_role_id))->store(); } catch (DatabaseException $de) { unset($db); throw new ShellException("Database error: " . $de->getMessage()); } unset($db); }