SqlHelper::getTopSql

public function getTopSql($sql, $limit, $offset = 0);

/**
 * Builds the strings for the SQL INSERT command for the given table.
 *
 * @param string $tableName A table name.
 * @param array  $fields    Array("column" => $value)[].
 *
 * @param bool   $returnAsArray
 *
 * @return array (columnList, valueList, binds)
 */
public function prepareInsert($tableName, array $fields, $returnAsArray = false)
{
	$columns = array();
	$values = array();

	$tableFields = $this->connection->getTableFields($tableName);

	// one registry
	$tableFields = array_change_key_case($tableFields, CASE_UPPER);
	$fields = array_change_key_case($fields, CASE_UPPER);

	foreach ($fields as $columnName => $value)
	{
		if (isset($tableFields[$columnName]))
		{
			$columns[] = $this->quote($columnName);
			$values[] = $this->convertToDb($value, $tableFields[$columnName]);
		}
		else
		{
			trigger_error("Column `{$columnName}` is not found in the `{$tableName}` table", E_USER_WARNING);
		}
	}

	$binds = $this->prepareBinds($tableFields, $fields);

	return array(
		$returnAsArray ? $columns : implode(", ", $columns),
		$returnAsArray ? $values : implode(", ", $values),
		$binds
	);
}