public function testQueryInsertSqlStringSingleColumn()
{
$query = new QueryInsert('MyTable');
$query->setColumns(array('col'));
$requiredSql = 'INSERT INTO MyTable(col) VALUES(?)';
$this->assertEquals($query->__toString(), $requiredSql);
}
public function insert($table, $colsAndValues = null)
{
$query = new QueryInsert($table);
$query->setColumns(array_keys($colsAndValues));
$stmt = $this->_db->prepare($query);
$index = 1;
foreach ($colsAndValues as $column => $value) {
$stmt->bindValue($index++, $value);
}
return $stmt->execute();
}
public function insert($table, $values)
{
$queryInsert = new QueryInsert();
return $queryInsert->getSql();
}
