public function execute($params) { $db = MDB2::factory(M::getDatabaseDSN()); $h = $db->dsn['hostspec']; $u = $db->dsn['username']; $p = $db->dsn['password']; $dbn = $db->database_name; $mysqlbin = '/usr/bin/env mysql'; $catbin = '/usr/bin/env cat'; $file = $this->baseFolder . 'src/tag.sql'; $sys = "{$catbin} {$file} | {$mysqlbin} --host={$h} --user={$u} --password={$p} {$dbn}"; system($sys, $return); $this->line('Creating tables :'); $this->line('* tag'); $this->line('* tag_record'); $this->line('* tag_history'); }
public static function executeSQLFile($file) { $db = MDB2::singleton(M::getDatabaseDSN()); $h = $db->dsn['hostspec']; $u = $db->dsn['username']; $p = $db->dsn['password']; $dbn = $db->database_name; $com = "cat {$file} | /usr/bin/env mysql --host={$h} --user={$u} --password={$p} {$dbn}"; self::line($com); system($com); }
public static function db() { return MDB2::singleton(M::getDatabaseDSN(), array('debug' => 1)); }