1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
|
package entries
import (
"context"
"database/sql"
"fmt"
"git.leonardobishop.net/history/pkg/database/sqlc"
)
type Service interface {
CreateEntry(title, kind, url, description string) (*sqlc.Entry, error)
GetEntries() ([]sqlc.GetEntriesRow, error)
}
type service struct {
db *sql.DB
}
func NewService(db *sql.DB) Service {
return &service{
db: db,
}
}
func (s *service) CreateEntry(title, kind, url, description string) (*sqlc.Entry, error) {
queries := sqlc.New(s.db)
entry, err := queries.CreateEntryWithKindName(context.Background(), sqlc.CreateEntryWithKindNameParams{
Title: title,
Url: url,
Description: description,
Name: kind,
})
if err != nil {
return nil, fmt.Errorf("could not create entry: %w", err)
}
return &entry, nil
}
func (s *service) GetEntries() ([]sqlc.GetEntriesRow, error) {
queries := sqlc.New(s.db)
entries, err := queries.GetEntries(context.Background())
if err != nil {
return make([]sqlc.GetEntriesRow, 0), fmt.Errorf("could not get entries: %w", err)
}
return entries, nil
}
|
