PE
Size: a a a
PE
TT
PE
DB
PE
TT
DB
DB
TT
TT
PE
if (date.startWith("0")) {
return date.drop(1)
}
D
DC
p
export const insertIntoTable = `
INSERT INTO tableName1 VALUES (
?, ?, ?
)
ON CONFLICT(id) DO UPDATE SET
fieldName1=COALESCE(excluded.fieldName1, )
fieldName2=COALESCE(excluded.fieldName2, )
fieldName3=COALESCE(excluded.fieldName3, )
`
DB
p
export const insertIntoTable = `
INSERT INTO tableName1 VALUES (
:p1, :p2, :p3
)
ON CONFLICT(id) DO UPDATE SET
fieldName1=COALESCE(excluded.fieldName1, :p1)
fieldName2=COALESCE(excluded.fieldName2, :p2)
fieldName3=COALESCE(excluded.fieldName3, :p3)
DB
D
DB
DC