-
Notifications
You must be signed in to change notification settings - Fork 42
/
namespaces.go
108 lines (92 loc) · 2.71 KB
/
namespaces.go
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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
package datastoresql
import (
"context"
"errors"
"fmt"
"regexp"
"strings"
"github.com/direktiv/direktiv/pkg/refactor/datastore"
"github.com/google/uuid"
"gorm.io/gorm"
)
type sqlNamespacesStore struct {
db *gorm.DB
}
func (s *sqlNamespacesStore) GetByID(ctx context.Context, id uuid.UUID) (*datastore.Namespace, error) {
namespace := &datastore.Namespace{}
res := s.db.WithContext(ctx).Raw(`
SELECT id, name, created_at, updated_at
FROM namespaces
WHERE id=?`,
id).
First(namespace)
if errors.Is(res.Error, gorm.ErrRecordNotFound) {
return nil, datastore.ErrNotFound
}
if res.Error != nil {
return nil, res.Error
}
return namespace, nil
}
func (s *sqlNamespacesStore) GetByName(ctx context.Context, name string) (*datastore.Namespace, error) {
namespace := &datastore.Namespace{}
res := s.db.WithContext(ctx).Raw(`
SELECT id, name, created_at, updated_at
FROM namespaces
WHERE name=?`,
name).
First(namespace)
if errors.Is(res.Error, gorm.ErrRecordNotFound) {
return nil, datastore.ErrNotFound
}
if res.Error != nil {
return nil, res.Error
}
return namespace, nil
}
func (s *sqlNamespacesStore) GetAll(ctx context.Context) ([]*datastore.Namespace, error) {
var namespaces []*datastore.Namespace
res := s.db.WithContext(ctx).Raw(`
SELECT id, name, created_at, updated_at
FROM namespaces`).
Find(&namespaces)
if res.Error != nil {
return nil, res.Error
}
return namespaces, nil
}
func (s *sqlNamespacesStore) Delete(ctx context.Context, name string) error {
res := s.db.WithContext(ctx).Exec(`DELETE FROM namespaces WHERE name=?`, name)
if res.Error != nil {
return res.Error
}
if res.RowsAffected > 1 {
return fmt.Errorf("unexpected namespaces delete count, got: %d, want: %d", res.RowsAffected, 1)
}
if res.RowsAffected == 0 {
return datastore.ErrNotFound
}
return nil
}
func (s *sqlNamespacesStore) Create(ctx context.Context, namespace *datastore.Namespace) (*datastore.Namespace, error) {
const nameRegex = `^(([a-z][a-z0-9_\-\.]*[a-z0-9])|([a-z]))$`
matched, _ := regexp.MatchString(nameRegex, namespace.Name)
if !matched {
return nil, datastore.ErrInvalidNamespaceName
}
newUUID := uuid.New()
res := s.db.WithContext(ctx).Exec(`
INSERT INTO namespaces(id, name) VALUES(?, ?);
`, newUUID, namespace.Name)
if res.Error != nil && strings.Contains(res.Error.Error(), "duplicate key") {
return nil, datastore.ErrDuplicatedNamespaceName
}
if res.Error != nil {
return nil, res.Error
}
if res.RowsAffected != 1 {
return nil, fmt.Errorf("unexpected namespaces insert count, got: %d, want: %d", res.RowsAffected, 1)
}
return s.GetByID(ctx, newUUID)
}
var _ datastore.NamespacesStore = &sqlNamespacesStore{}