function testDeleteWithCondition()
{
$startId = $this->db->insert('test_db_table', array('description' => 'text1'));
$this->db->insert('test_db_table', array('description' => 'text2'));
$this->db->insert('test_db_table', array('description' => 'text3'));
$query = new lmbDeleteQuery('test_db_table', $this->conn);
$query->addCriteria(new lmbSQLFieldCriteria('id', $startId));
$stmt = $query->getStatement();
$stmt->execute();
$rs = $this->db->select('test_db_table')->sort(array('id' => 'ASC'));
$arr = $rs->getArray();
$this->assertEqual($arr[0]['id'], $startId + 1);
$this->assertEqual($arr[1]['id'], $startId + 2);
$this->assertEqual(sizeof($arr), 2);
}
function delete($table, $criteria = null)
{
$query = new lmbDeleteQuery($table, $this->conn);
if ($criteria) {
$query->addCriteria(lmbSQLCriteria::objectify($criteria));
}
$this->stmt = $query->getStatement($this->conn);
$this->stmt->execute();
return $this;
}
function delete($criteria = null)
{
$query = new lmbDeleteQuery($this->_db_table_name, $this->_conn);
if ($criteria) {
$query->addCriteria($criteria);
}
$this->_stmt = $query->getStatement();
$this->_stmt->execute();
}
