public function testBuildSelectWhereQuery()
{
$stmt = Sabel_Db::createStatement("default");
$stmt->type(Sabel_Db_Statement::SELECT);
$stmt->setMetadata(Sabel_Db_Metadata::getTableInfo("student"));
$stmt->where('WHERE "ID" = 1');
$expected = 'SELECT "ID", "NAME" FROM "STUDENT" WHERE "ID" = 1';
$this->assertEquals($expected, $stmt->getQuery());
}
public function testBuildSelectOrderByQuery2()
{
$stmt = Sabel_Db::createStatement("default");
$stmt->type(Sabel_Db_Statement::SELECT);
$stmt->setMetadata(Sabel_Db_Metadata::getTableInfo("student"));
$stmt->constraints(array("order" => array("id" => "DESC", "name" => "ASC")));
$expected = 'SELECT "ID", "NAME" FROM "STUDENT" ORDER BY "ID" DESC, "NAME" ASC';
$this->assertEquals($expected, $stmt->getQuery());
}
public function testBuildSelectOrderByQuery2()
{
$stmt = Sabel_Db::createStatement("default");
$stmt->type(Sabel_Db_Statement::SELECT);
$stmt->setMetadata(Sabel_Db_Metadata::getTableInfo("student"));
$stmt->constraints(array("order" => array("id" => array("mode" => "DESC", "nulls" => "LAST"), "name" => array("mode" => "ASC", "nulls" => "LAST"))));
$expected = "SELECT `id`, `name` FROM `student` ORDER BY `id` IS NULL, `id` DESC, `name` IS NULL, `name` ASC";
$this->assertEquals($expected, $stmt->getQuery());
}
private function createStatement()
{
$stmt = Sabel_Db::createStatement($this->connectionName);
$stmt->setMetadata(Sabel_Db_Metadata::getTableInfo($this->tableName, $this->connectionName));
return $stmt;
}
/**
* @param string $mdlName
*
* @return void
*/
protected function initialize($mdlName = null)
{
if ($mdlName === null) {
$mdlName = get_class($this);
}
$this->modelName = $mdlName;
if ($this->tableName === "") {
$this->tableName = convert_to_tablename($mdlName);
}
$this->metadata = Sabel_Db_Metadata::getTableInfo($this->tableName, $this->connectionName);
$this->metaCols = $this->metadata->getColumns();
}
