MCPcopy Create free account
hub / github.com/electric-sql/electric / makeInsertQuery

Function makeInsertQuery

examples/linearlite-read-only/db/load_data.js:15–23  ·  view source on GitHub ↗
(db, table, data)

Source from the content-addressed store, hash-verified

13const db = createPool(DATABASE_URL)
14
15async function makeInsertQuery(db, table, data) {
16 const columns = Object.keys(data)
17 const columnsNames = columns.join(`, `)
18 const values = columns.map((column) => data[column])
19 return await db.query(sql`
20 INSERT INTO ${sql.ident(table)} (${sql(columnsNames)})
21 VALUES (${sql.join(values.map(sql.value), `, `)})
22 `)
23}
24
25async function importIssue(db, issue) {
26 const { comments: _, ...rest } = issue

Callers 2

importIssueFunction · 0.85
importCommentFunction · 0.85

Calls 4

queryMethod · 0.80
keysMethod · 0.45
joinMethod · 0.45
mapMethod · 0.45

Tested by

no test coverage detected