in src/middleware/db.go [195:219]
func (s SQLStorage) Create(t Todo) (Todo, error) {
sql := `
INSERT INTO todo(title, updated)
VALUES($1, NOW() )
RETURNING id
`
if t.Complete {
sql = `
INSERT INTO todo(title, updated, completed)
VALUES($1,NOW(),NOW())
RETURNING id
`
}
var id int
if err := s.db.QueryRow(sql, t.Title).Scan(&id); err != nil {
return t, fmt.Errorf("create error: on exec: %s", err)
}
t.ID = int(id)
return t, nil
}