func()

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
}