I'm trying to set up a prepared statement and execute it using the database/sql
package, but it is giving me this error saying 2018/07/24 08:34:44 pq: syntax error at or near ","
, and I am not sure what I am doing wrong.
db, err := sql.Open("postgres", connStr)
if err != nil {
fmt.Errorf("error Connecting to DB")
}
defer db.Close()
stmt, err := db.Prepare(`INSERT INTO "TEST_TABLE" ("pid", "name", "brand", "sku", url, price, image, "dateInserted", "dateUpdated") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict ("pid") do update set "dateUpdated" = EXCLUDED."dateUpdated"`)
defer stmt.Close()
if err != nil {
log.Fatal(err)
}
_, err = stmt.Exec(obj.Id, obj.Name, obj.Brand, obj.Sku, obj.Url, obj.Price.Regular, obj.Image, time.Now(), time.Now())
if err != nil {
log.Fatal(err)
}