public function run() { clearstatcache(); $this->checkInputs(); $outputDir = RUN_BASE . DS . LIB_DIR_NAME . DS . "schema"; $this->defineEnvironment($this->arguments[0]); Sabel_Db_Config::initialize(new Config_Database()); $isAll = false; $tables = $this->getOutputTables(); if (isset($tables[0]) && strtolower($tables[0]) === "all") { $isAll = count($tables) === 1; } $tList = new TableListWriter($outputDir); foreach (Sabel_Db_Config::get() as $connectionName => $params) { Sabel_Db_Config::add($connectionName, $params); $db = Sabel_Db::createMetadata($connectionName); foreach ($db->getTableList() as $tblName) { if ($isAll || in_array($tblName, $tables, true)) { $writer = new Sabel_Db_Metadata_FileWriter($outputDir); $writer->write($db->getTable($tblName)); $this->success("generate Schema 'Schema_" . convert_to_modelname($tblName) . "'"); } $tList->add($connectionName, $tblName); } if (Sabel_Console::hasOption("l", $this->arguments)) { $tList->write($connectionName); } } }
public function testSchemaNameOfCustomPackage() { $params = array("package" => "my.db.org", "database" => "mydb", "schema" => "hoge"); Sabel_Db_Config::add("configtest", $params); $this->assertEquals("hoge", Sabel_Db_Config::getSchemaName("configtest")); $params = array("package" => "my.db.org", "database" => "mydb"); Sabel_Db_Config::add("configtest", $params); try { Sabel_Db_Config::getSchemaName("configtest"); } catch (Sabel_Db_Exception $e) { return; } $this->fail(); }
private static function initTable() { if (extension_loaded("mysql")) { $params = array("package" => "sabel.db.mysql", "host" => "127.0.0.1", "user" => "root", "password" => "", "database" => "sdb_test"); } elseif (extension_loaded("pgsql")) { $params = array("package" => "sabel.db.pgsql", "host" => "127.0.0.1", "user" => "root", "password" => "", "database" => "sdb_test"); } elseif (extension_loaded("pdo_sqlite")) { $params = array("package" => "sabel.db.pdo.sqlite", "database" => SABEL_BASE . "/Test/data/sdb_test.sq3"); } else { Sabel_Console::message("skipped 'Test_Session_Database'."); return false; } Sabel_Db_Config::add("default", $params); Sabel_Db::createDriver("default")->execute("DELETE FROM session"); return true; }
private static function initTable() { if (extension_loaded("mysql")) { $params = array("package" => "sabel.db.mysql", "host" => "127.0.0.1", "user" => "root", "password" => "", "database" => "sdb_test"); } elseif (extension_loaded("pgsql")) { $params = array("package" => "sabel.db.pgsql", "host" => "127.0.0.1", "user" => "root", "password" => "", "database" => "sdb_test"); } elseif (extension_loaded("pdo_sqlite")) { $params = array("package" => "sabel.db.pdo.sqlite", "database" => SABEL_BASE . "/Test/data/sdb_test.sq3"); } else { Sabel_Console::message("skipped 'TemplateDb'."); return false; } Sabel_Db_Config::add("default", $params); $stmt = Sabel_Db::createStatement(); $tblName = $stmt->quoteIdentifier("sbl_template"); $nCol = $stmt->quoteIdentifier("name"); $nsCol = $stmt->quoteIdentifier("namespace"); $cCol = $stmt->quoteIdentifier("contents"); $stmt->setQuery("DELETE FROM {$tblName}")->execute(); $data = array(); $data[0]["path"] = "views" . DS . "serverError" . TPL_SUFFIX; $data[0]["cont"] = ""; $data[1]["path"] = "index" . DS . "views" . DS . "error" . TPL_SUFFIX; $data[1]["cont"] = ""; $data[2]["path"] = "index" . DS . "views" . DS . "hoge" . DS . "index" . TPL_SUFFIX; $data[2]["cont"] = "hoge/index.tpl"; $data[3]["path"] = "index" . DS . "views" . DS . "hoge" . DS . "hoge" . TPL_SUFFIX; $data[3]["cont"] = "hoge/hoge.tpl"; $data[4]["path"] = "index" . DS . "views" . DS . "fuga" . DS . "index" . TPL_SUFFIX; $data[4]["cont"] = "fuga/index.tpl"; $data[5]["path"] = "index" . DS . "views" . DS . "fuga" . DS . "fuga" . TPL_SUFFIX; $data[5]["cont"] = "fuga/fuga.tpl"; foreach ($data as $d) { $query = "INSERT INTO {$tblName}({$nCol}, {$nsCol}, {$cCol}) VALUES('{$d["path"]}', '', '{$d["cont"]}')"; $stmt->setQuery($query)->execute(); } return true; }
public function testInit() { Sabel_Db_Config::add("default", Test_DB_TestConfig::getPdoSqliteConfig()); Test_DB_Test::$db = "SQLITE"; }
public function testInit() { Sabel_Db_Config::add("default", Test_DB_TestConfig::getIbaseConfig()); }
public function testInit() { Sabel_Db_Config::add("default", Test_DB_TestConfig::getMysqlConfig()); Test_DB_Test::$db = "MYSQL"; }
public function testInit() { Sabel_Db_Config::add("default", Test_DB_TestConfig::getIbaseConfig()); MODEL("SblKvs")->delete(); }
function isNull($arg1) { if ($arg1 === null) { echo "."; } else { echo "F ( {$arg1} )"; } if (Counter::$count !== 0 && Counter::$count % 40 === 0) { echo "\n"; } Counter::$count++; } define("CONNAME", $_SERVER["argv"][1]); $configs = array("sqlite" => array("package" => "sabel.db.pdo.sqlite", "database" => "/home/ebine/test.sq3"), "mysql" => array("package" => "sabel.db.mysql", "host" => "127.0.0.1", "database" => "sdb_test", "port" => "3306", "user" => "root", "password" => ""), "pgsql" => array("package" => "sabel.db.pgsql", "host" => "127.0.0.1", "database" => "sdb_test", "user" => "pgsql", "password" => "pgsql"), "oci" => array("package" => "sabel.db.oci", "host" => "127.0.0.1", "database" => "XE", "schema" => "DEVELOP", "user" => "DEVELOP", "password" => "DEVELOP")); foreach ($configs as $key => $param) { Sabel_Db_Config::add($key, $param); } echo "[ " . CONNAME . " ]\n"; $path = RUN_BASE . "/migration/tmp/1_Hoge_create.php"; system("php exec.php {$path} " . CONNAME . " upgrade"); $accessor = Sabel_Db::createMetadata(CONNAME); $hoge = $accessor->getTable("hoge"); $id = $hoge->id; $name = $hoge->name; $test = $hoge->test; $body = $hoge->body; $bool = $hoge->bool; isTrue($id->isInt(true)); isTrue($id->primary); isTrue($id->increment); isNull($id->default);
public function testInit() { Sabel_Db_Config::add("default", Test_DB_TestConfig::getOciConfig()); Test_DB_Test::$db = "ORACLE"; }
public function testInit() { Sabel_Db_Config::add("default", self::$params1); Test_DB_Test::$db = "PDO_ORACLE"; }