Test our Postgres profileStore implementation.
Update all our test cases to use time.Now().Round(time.Millisecond), because Go
uses nanosecond precision on time values, but Postgres silently truncates that
to millisecond precision. This caused our tests to report false failures that
were just silent precision loss, not actual failures.
Set up our authd server to use the Postgres store for profiles and automatically
create a test scope when starting up.
Log errors when creating Clients through the API, instead of just swallowing
them and sending back cryptic act of god errors.
Add a NewPostgres helper that returns a postgres profileStore from a connection
string (passed through pq transparently).
Add an Empty() bool helper to ProfileChange and BulkProfileChange types, so we
can determine if there are any changes we need to act on easily.
Log errors when creating Pofiles through the API, instead of just swalloing them
and sending back cryptic act of god errors.
Remove the ` quotes around field and table names, which are not supported in
Postgres. This required adding a few functions/methods to pan.
Detect situations where a profile was expected and not found, and return
ErrProfileNotFound.
Detect pq errors thrown when the profiles_pkey constraint is violated, and
transform them to the ErrProfileAlreadyExists error.
Detect empty ProfileChange and BulkProfileChange variables and abort the
updateProfile and updateProfiles methods early, before invalid SQL is generated.
Detect pq errors thrown when the logins_pkey constraint is violated, and
transform them to the ErrLoginAlreadyExists error.
Detect when removing a Login and no rows were affected, and return an
ErrLoginNotFound.
Create an sql dir with a postgres_init script that will initialize the schema of
the tables expected in the database.
10 ErrNoScopeStore = errors.New("scopeStore not set in Context")
13 type ErrScopeNotFound struct {
18 func (e ErrScopeNotFound) Error() string {
19 return fmt.Sprintf("scope %s couldn't be found", e.ID)
22 type ErrScopeAlreadyExists struct {
27 func (e ErrScopeAlreadyExists) Error() string {
28 return fmt.Sprintf("scope %s already exists", e.ID)
31 // Scope represents a limit on the access that a grant provides.
38 func (s *Scope) ApplyChange(change ScopeChange) {
39 if change.Name != nil {
42 if change.Description != nil {
43 s.Description = *change.Description
47 type sortedScopes []Scope
49 func (s sortedScopes) Len() int {
53 func (s sortedScopes) Swap(i, j int) {
54 s[i], s[j] = s[j], s[i]
57 func (s sortedScopes) Less(i, j int) bool {
58 return s[i].ID < s[j].ID
61 // ScopeChange represents a change to a Scope.
62 type ScopeChange struct {
68 type scopeStore interface {
69 createScopes(scopes []Scope) error
70 getScopes(ids []string) ([]Scope, error)
71 updateScopes(changes []ScopeChange) ([]Scope, error)
72 removeScopes(ids []string) error
73 listScopes() ([]Scope, error)
76 func (m *memstore) createScopes(scopes []Scope) error {
78 defer m.scopeLock.Unlock()
80 for pos, scope := range scopes {
81 if _, ok := m.scopes[scope.ID]; ok {
82 return ErrScopeAlreadyExists{Pos: pos, ID: scope.ID}
85 for _, scope := range scopes {
86 m.scopes[scope.ID] = scope
91 func (m *memstore) getScopes(ids []string) ([]Scope, error) {
93 defer m.scopeLock.RUnlock()
96 for pos, id := range ids {
97 scope, ok := m.scopes[id]
99 return []Scope{}, ErrScopeNotFound{ID: id, Pos: pos}
101 scopes = append(scopes, scope)
103 sorted := sortedScopes(scopes)
109 func (m *memstore) updateScopes(changes []ScopeChange) ([]Scope, error) {
111 defer m.scopeLock.Unlock()
115 for pos, change := range changes {
116 if _, ok := m.scopes[change.ID]; !ok {
117 return []Scope{}, ErrScopeNotFound{Pos: pos, ID: change.ID}
120 for _, change := range changes {
121 scope := m.scopes[change.ID]
122 scope.ApplyChange(change)
123 m.scopes[change.ID] = scope
124 scopes = append(scopes, scope)
126 sorted := sortedScopes(scopes)
132 func (m *memstore) removeScopes(ids []string) error {
134 defer m.scopeLock.Unlock()
136 for pos, id := range ids {
137 if _, ok := m.scopes[id]; !ok {
138 return ErrScopeNotFound{Pos: pos, ID: id}
141 for _, id := range ids {
147 func (m *memstore) listScopes() ([]Scope, error) {
149 defer m.scopeLock.RUnlock()
152 for _, scope := range m.scopes {
153 scopes = append(scopes, scope)
155 sorted := sortedScopes(scopes)