Guest User

Untitled

a guest
Oct 19th, 2017
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. package main
  2.  
  3. import (
  4. "fmt"
  5. "log"
  6. "database/sql"
  7. _ "github.com/lib/pq"
  8. )
  9.  
  10. func main() {
  11. db, err := sql.Open(
  12. "postgres",
  13. "user=test password=test dbname=test sslmode=disable")
  14. if err != nil {
  15. log.Fatalf("error: %vn", err)
  16. }
  17.  
  18. stmt, err := db.Prepare("INSERT INTO test(value) VALUES($1) RETURNING id")
  19. if err != nil {
  20. log.Fatalf("error: %vn", err)
  21. }
  22.  
  23. var id int
  24. err = stmt.QueryRow("value to insert").Scan(&id)
  25. if err != nil {
  26. log.Fatalf("error: %vn", err)
  27. }
  28.  
  29. fmt.Printf("inserted object's ID: %dn", id)
  30. }
  31.  
  32. stmt, _ := connection.Prepare("INSERT ....")
  33. res, _ := stmt.Exec()
  34. id, err := res.LastInsertId()
Add Comment
Please, Sign In to add comment