public function testAllCommonWhere()
{
$query = new CM_Db_Query_SelectMultiple(self::$_client, 't`est', array('f`oo', 'bar'), array(array('foo' => 'foo1'), array('foo' => 'foo1'), array('foo' => 'foo1')));
$this->assertSame('SELECT `f``oo`,`bar` FROM `t``est` WHERE `foo` = ?', $query->getSqlTemplate());
$this->assertSame(array('foo1'), $query->getParameters());
$query = new CM_Db_Query_SelectMultiple(self::$_client, 't`est', array('f`oo', 'bar'), array(array('foo' => 'foo1', 'poo' => 'poo1'), array('foo' => 'foo1', 'poo' => 'poo1')));
$this->assertSame('SELECT `f``oo`,`bar` FROM `t``est` WHERE `foo` = ? AND `poo` = ?', $query->getSqlTemplate());
$this->assertSame(array('foo1', 'poo1'), $query->getParameters());
}
/**
* @param string $table
* @param string|string[] $fields Column-name OR Column-names array
* @param array[] $whereList Outer array-entries are combined using OR, inner arrays using AND
* @param string|null $order
* @return CM_Db_Result
*/
public static function selectMultiple($table, $fields, array $whereList, $order = null)
{
$client = self::getClient();
$query = new CM_Db_Query_SelectMultiple($client, $table, $fields, $whereList, $order);
return $query->execute();
}
