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));
}
