function test_twoParams()
{
$query = new SQL_Query('table');
$query->addWhere(2, '=', 2);
// test this ...
$query->addWhere(new SQL_Condition(1, '=', 1), 'OR');
$cond = new SQL_Condition(2, '=', 2);
$cond->add(new SQL_Condition(1, '=', 1), 'OR');
$this->assertEquals($cond, $query->getWhere());
}
function test_quotedField()
{
$query = new SQL_Query('city');
$query->addWhere('name', '<>', '\'wolfram\'');
$ren = new $this->_renderer($query);
$this->assertStringEquals('name <> \'wolfram\'', $ren->renderCondition());
}
function test_default()
{
$query = new SQL_Query('table');
$query->addWhere('1', '<>', '2');
$query->resetWhere();
$this->assertEquals(null, $query->getWhere());
}
function test_default()
{
$query = new SQL_Query('table');
$query->addWhere('1', '<>', '2');
$query->addSelect('id', 'name');
$query->reset();
$this->assertEquals(new SQL_Query('table'), $query);
}
function test_slightlyDifferentQueries1()
{
$query = new SQL_Query('table');
$query->addWhere('1', '<>', '2');
$query->addSelect('id', 'name');
$query1 = $query;
$query->resetSelect();
$query->addSelect('name', 'id');
$this->assertFalse($query1->hashKey() == $query->hashKey());
}
*/
ini_set('error_reporting', E_ALL);
ini_set('include_path', realpath(dirname(__FILE__) . '/../../..'));
#define('DB_DSN', 'mysql://root@localhost/test');
$tableStructures = array();
require_once 'SQL/Query.php';
require_once 'SQL/Query/Join.php';
require_once 'SQL/Query/Condition.php';
/*$aliases = array(
TABLE_CONTACT => 'contact'
,TABLE_CONTACT2TREE => 'contact2tree'
,TABLE_CONTACTTREE => 'contactTree'
);
*/
#DB_QueryTool::addAliases($aliases);
$query = new SQL_Query_Join('contact');
$query->autoJoin('contact2tree', 'contactTree');
$query->addLeftJoin('email', new SQL_Query_Condition('email.contact_id', '=', 'id', 'AND', 'email.primaryMail', '=', 1));
$query->addWhere('contactTree.user_id', '=', 7);
$query->addOrder('surname,name');
// this is just to demonstrate nested where clauses, the query doesnt really make sense, at least not to me :-)
// SELECT * FROM user WHERE (name LIKE 'n%' AND name LIKE 'a%') OR name LIKE 's%'
$query = new SQL_Query('user');
$c1 = $query->condition('name', 'LIKE', '"n%"');
$c1->add('name', 'LIKE', '"a%"', 'AND');
$query->addWhere($c1, 'OR', $query->condition('name', 'LIKE', '"%s"'));
require_once 'SQL/Query/Renderer.php';
$render = SQL_Query_Renderer::factory($query, $tableStructures);
print $render->toString();
print "<pre>";
print_r($query);
function test_deleteSearchedWithWhere()
{
$query = new SQL_Query('city', 'delete');
$query->addWhere('id', '=', 1);
$ren = new $this->_renderer($query);
$this->assertStringEquals('DELETE FROM city WHERE id = 1', $ren->render());
}
