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