Advertisement
jrsanborn

Untitled

May 16th, 2020
1,918
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Go 0.58 KB | None | 0 0
  1. // New creates a new todo.
  2. func (db *Database) New(mid int, params *NewParams) (*Todo, error) {
  3.     // Create a new Todo.
  4.     todo := &Todo{
  5.         MemberID: mid,
  6.         Created:  time.Now(),
  7.         Detail:   params.Detail,
  8.     }
  9.  
  10.     // Create variable to hold the result.
  11.     var res sql.Result
  12.     var err error
  13.  
  14.     // Execute the query.
  15.     if res, err = db.db.Exec(stmtInsert, todo.MemberID, todo.Created, todo.Detail, todo.Completed); err != nil {
  16.         return nil, err
  17.     }
  18.  
  19.     // Get last insert ID.
  20.     id, err := res.LastInsertId()
  21.     if err != nil {
  22.         return nil, err
  23.     }
  24.     todo.ID = int(id)
  25.  
  26.     return todo, nil
  27. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement