function testGetColumnTypeAccessors()
{
$mapping = lmbDbTypeInfo::getColumnTypeAccessors();
foreach ($this->columnList as $columnType) {
$this->assertTrue(isset($mapping[$columnType]));
}
foreach ($mapping as $col => $name) {
$this->assertTrue(in_array($col, $this->columnList));
$this->assertTrue(is_callable(array($this->queryStmtClass, $name)), "'{$name}' is not callable in {$this->queryStmtClass}");
}
}
function setTypedValue($type, $column, $value)
{
$setterList = lmbDbTypeInfo::getColumnTypeAccessors();
$setter = $setterList[$type];
$this->assertNotNull($setter);
$sql = "\n INSERT INTO standard_types (\n {$column}\n ) VALUES (\n :{$column}:\n )";
$stmt = $this->connection->newStatement($sql);
$stmt->{$setter}($column, $value);
$id = $stmt->insertId('id');
$sql = "SELECT * FROM standard_types WHERE id = :id:";
$stmt = $this->connection->newStatement($sql);
$stmt->setInteger('id', $id);
$record = $stmt->getOneRecord();
return $record;
}
protected function _bindValuesToStatement($stmt, $values)
{
$accessors = lmbDbTypeInfo::getColumnTypeAccessors();
foreach ($values as $key => $value) {
$accessor = $accessors[$this->getColumnInfo($key)->getType()];
$stmt->{$accessor}($key, $value);
}
}
