function testAddFieldWithoutValueOnlyReservesAPlaceholder() { $query = new lmbInsertOnDuplicateUpdateQuery('test_db_table', $this->conn); $query->addField('description'); $query->addField('title'); $stmt = $query->getStatement(); $stmt->set('description', $description = 'Some \'description\''); $stmt->set('title', $title = 'Some title'); $stmt->execute(); $rs = $this->db->select('test_db_table'); $arr = $rs->getArray(); $this->assertEqual(sizeof($arr), 1); $this->assertEqual($arr[0]['description'], $description); $this->assertEqual($arr[0]['title'], $title); }
function insertOnDuplicateUpdate($row) { $filtered_row = $this->_filterRow($row); if (!count($filtered_row)) { throw new lmbException('All fields filtered!! Insert statement must contain atleast one field!'); } $query = new lmbInsertOnDuplicateUpdateQuery($this->_db_table_name, $this->_conn); $values = array(); $update_sequence = false; foreach ($filtered_row as $key => $value) { if (is_null($value) && $this->isAutoIncrement($key)) { continue; } $query->addField($key); $values[$key] = $value; } $this->_stmt = $query->getStatement($this->_conn); $this->_bindValuesToStatement($this->_stmt, $values); return (int) $this->_stmt->insertId($this->_primary_key_name); }