1package db
2
3func (d *DB) AddRepo(knot, owner, name string) error {
4 _, err := d.Exec(`insert or ignore into repos (knot, owner, name) values (?, ?, ?)`, knot, owner, name)
5 return err
6}
7
8func (d *DB) Knots() ([]string, error) {
9 rows, err := d.Query(`select knot from repos`)
10 if err != nil {
11 return nil, err
12 }
13
14 var knots []string
15 for rows.Next() {
16 var knot string
17 if err := rows.Scan(&knot); err != nil {
18 return nil, err
19 }
20 knots = append(knots, knot)
21 }
22
23 if err = rows.Err(); err != nil {
24 return nil, err
25 }
26
27 return knots, nil
28}