Guest User

Untitled

a guest
Mar 20th, 2019
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. package main
  2.  
  3. import (
  4. "database/sql"
  5. "fmt"
  6. _ "github.com/lib/pq"
  7. )
  8.  
  9. const (
  10. DB_USER = "postgres"
  11. DB_PASSWORD = "postgres"
  12. DB_NAME = "users"
  13. )
  14.  
  15. func main() {
  16. dbinfo := fmt.Sprintf("user=%s password=%s dbname=%s sslmode=disable",
  17. DB_USER, DB_PASSWORD, DB_NAME)
  18. db, err := sql.Open("postgres", dbinfo)
  19. checkErr(err)
  20. defer db.Close()
  21.  
  22. sqlStatement := `
  23. INSERT INTO basictable(firstCol,secondCol)
  24. VALUES ("Yellow", "Colour")`
  25. _, err = db.Exec(sqlStatement)
  26. if err != nil {
  27. panic(err)
  28. }
  29.  
  30. first := "Yellow"
  31. second := "Colour"
  32.  
  33. sqlStatement := `
  34. INSERT INTO basictable(firstCol,secondCol)
  35. VALUES (first,second)`
  36. _, err = db.Exec(sqlStatement)
  37. if err != nil {
  38. panic(err)
  39. }
Add Comment
Please, Sign In to add comment