Bulk Insert with Model API

[Wattsun64]

Is there a way to do something along the lines of Model::bulkInsert($data) within Phalcon currently?

If not, is this a feature that has been requested, or is being worked on?

[niden]

There was a discussion some years back about this feature but never got any traction. We do not have any plans on doing this, at least for now. Maybe this can be something that we can investigate and potentially implement in the migrations repo.

[xiaochong0302]

/**
 * build batch insert SQL
 *
 * @param string $table
 * @param array $rows
 * @return string|false
 */
function batch_insert_sql(string $table, array $rows = []): string|false
{
    if (count($rows) == 0) return false;

    $fields = implode(',', array_keys($rows[0]));

    $values = [];

    foreach ($rows as $row) {
        $items = array_map(function ($item) {
            return sprintf("'%s'", htmlspecialchars($item, ENT_QUOTES));
        }, $row);
        $values[] = sprintf('(%s)', implode(',', $items));
    }

    $values = implode(',', $values);

    return sprintf("INSERT INTO %s (%s) VALUES %s", $table, $fields, $values);
}

$this->db->execute($sql);