function testChaining()
 {
     $startId = $this->db->insert('test_db_table', array('description' => 'text1'));
     $this->db->insert('test_db_table', array('description' => 'text2'));
     $query = new lmbDeleteQuery('test_db_table', $this->conn);
     $query->where($this->conn->quoteIdentifier('id') . '=' . intval($startId))->execute();
     $rs = $this->db->select('test_db_table');
     $arr = $rs->getArray();
     $this->assertEqual($arr[0]['id'], $startId + 1);
     $this->assertEqual(sizeof($arr), 1);
 }
Example #2
0
 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();
 }