/**
* @param array $options
* @param object $joinDependency
* @param array $bindVars
* @return string
*/
protected function _selectLimitedIdsList($options, $joinDependency, $bindVars)
{
$result = $this->connection->selectAll($this->_constructFinderSqlForAssocLimiting($options, $joinDependency, $bindVars), "{$this->_className} Load IDs For Limited Eager Loading");
$ids = array();
foreach ($result as $row) {
$ids[] = $this->connection->quote($row[$this->primaryKey()]);
}
return join(', ', $ids);
}
/**
* Insert a row of data into the table
* @param string $tableName
* @param array $attributes (column_name => value)
*/
private function _insertRow($tableName, $attributes)
{
foreach ($attributes as $col => $value) {
$cols[] = $this->_connection->quoteColumnName($col);
$vals[] = $this->_connection->quote($value);
}
$colStr = implode(', ', $cols);
$valStr = implode(', ', $vals);
// build & execute SQL
$sql = "INSERT INTO {$tableName} (" . " {$colStr}" . ") VALUES (" . " {$valStr}" . ")";
$this->_connection->execute($sql);
}
