/**
* @covers Zend\Db\Sql\Insert::getSqlString
* @todo Implement testGetSqlString().
*/
public function testGetSqlString()
{
$this->insert->into('foo')
->values(array('bar' => 'baz'));
$this->assertEquals('INSERT INTO "foo" ("bar") VALUES (\'baz\')', $this->insert->getSqlString());
}
function insert()
{
pitch("Dodeye.core.db.Insert");
$data = $this->request->getParam($this->type);
$xml = simplexml_load_string($data);
$array_val = ToArray($xml);
$row_key = key($array_val);
$row1_key = key($array_val[$row_key]);
$Insert = new Insert();
$Insert->into($this->table);
//@NOTE: peple might send multiple insert
if (is_numeric($row1_key)) {
//there are may rows
$tbl_cols = array_keys($array_val[$row_key][$row1_key]);
$Insert->columns($tbl_cols);
$sql = $this->dbcon->prepare($Insert->bindable_sql());
// foreach ($tbl_cols as $key =>$val)
// $sql->bindParam($key,$val);
} else {
//single entry
$tbl_cols = array_keys($array_val[$row_key]);
$Insert->columns($tbl_cols);
$sql = $this->dbcon->prepare($Insert->bindable_sql());
foreach ($tbl_cols as $key => $val) {
$sql->bindParam($key + 1, $array_val[$row_key][$val]);
}
//$rs = $sql->execute();
if ($rs) {
print "true";
} else {
print "false";
}
}
//$sql
exit;
}
public function testGenerateSqlForValues()
{
$this->out->into('Test')->values(['super' => 'data', 'next' => 'fieldData']);
$expected = 'INSERT INTO `[prefix]_Test` ' . '(`super`,`next`) VALUES ("data","fieldData")';
$this->assertEquals($expected, $this->out->generateSql());
}
