Guest User

Untitled

a guest
Dec 11th, 2016
137
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Go 0.40 KB | None | 0 0
  1. func dbUpdateOne(name string) error {
  2.     db, err := sql.Open("sqlite3", "data/database.sqlite3")
  3.     if err != nil {
  4.         panic(err)
  5.     }
  6.     defer db.Close()
  7.     tx, err := db.Begin()
  8.     if err != nil {
  9.         panic(err)
  10.     }
  11.     stmt, err := tx.Prepare("INSERT INTO user (one) VALUES(1) WHERE name = ?")
  12.     if err != nil {
  13.         panic(err)
  14.     }
  15.     defer stmt.Close()
  16.     _, err = stmt.Exec(name)
  17.     tx.Commit()
  18.     return err
  19. }
Advertisement
Add Comment
Please, Sign In to add comment