Hey, Using sqldelight, I’m trying to create a query that would insert variant number of key-value pa...

# squarelibraries

[krzysztof]

Hey,
Using sqldelight, I’m trying to create a query that would insert variant number of key-value pairs into the table:

CREATE TABLE IF NOT EXISTS example_table(
    key TEXT NOT NULL UNIQUE PRIMARY KEY,
    value TEXT
);

In sql, you can do something like

INSERT INTO example_table (key, value)
VALUES ("k1", "v1"), ("k2", "v2")

How can I create such query, so that I can pass a list of my key-value entries? Such as
db.insertMany(listOf(Entry(k1, v1), Entry(k2, v2))) ?

[alec]

https://github.com/cashapp/sqldelight/issues/3260

[alec]

planned for 2.0

[alec]

for now, best to just run the insert multiple times in a transaction

[krzysztof]

Nice, thanks Alec 👍