Ah okay! Thanks. Still getting used to using SQLite.
Ah okay! Thanks. Still getting used to using SQLite.



SELECT DISTINCT *
FROM variantValues vv
JOIN options o ON o.optionId = vv.optionId
JOIN optionValues ov ON ov.valueId = vv.valueId
WHERE vv.variantId IN '(7, 8, 9, 10)'
const insertedOptionValues = await c.env.DB.prepare(`INSERT INTO optionValues (optionId, valueName) VALUES (?, ?), (?, ?), (? ,? )`)
.bind(optionId, valueName[0], optionId, valueName[1], optionId, valueName[2])
.run();
SELECT DISTINCT *
FROM variantValues vv
JOIN options o ON o.optionId = vv.optionId
JOIN optionValues ov ON ov.valueId = vv.valueId
WHERE vv.variantId IN '(7, 8, 9, 10)'
const ps = c.env.DB.prepare(`INSERT INTO optionValues (optionId, valueName) VALUES (?, ?)`);
const queries = [];
for(const row of rows) {
queries.push(ps.bind(...row));
}
await c.env.DB.batch(queries);