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); }
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(); }