Support for inserting multiple rows in a single statement

[florianreinhart]

In node-mysql I can do something like this:

let users: [User] = [user1, user2, user3]
try connection.query("INSERT INTO User (id, name, age) VALUES ?", [users])

In mysql-swift I have to manually build the query string depending on the number of rows, e.g. "INSERT INTO User (id, name, age) VALUES (?,?,?), (?,?,?), (?,?,?)".

I could also be missing something. Is there another way to achieve this in mysql-swift?

[novi]

We already have the way to do multiple inserting (or bulk inserting) like this. But we have to convert models into QueryArray to do that.

[florianreinhart]

Thanks! That's better then my previous implementation.