Implement postgres version of the tokenStore.
Create a postgres implementation for the tokenStore. Note that because pq
doesn't support Postgres' array types (see https://github.com/lib/pq/issues/49),
we couldn't just store the token.Scopes field as a Postgres array of varchars,
which would have been the ideal. Instead, we need a many-to-many table that maps
tokens to scopes. This meant we needed a special tokenScope type for our
database mapping, and we needed to complicate the token storage/retrieval
functions a little bit. It's kind of ugly, I'm not a huge fan of it, and I'd
much rather be using the Postgres array types, but... well, here we are.
We also added the postgres tokenStore to our slice of tokenStores to test when
the correct environment variables are present.
We wrote initialization SQL for the tables required by the postgres tokenStore.
Also, added a helper script for emptying the test database, because I got tired
of doing it by hand. We should be doing that in an automated fashion in the
tests themselves, but that would mean extending the *Store interfaces.
9 ErrNoScopeStore = errors.New("scopeStore not set in Context")
10 ErrScopeNotFound = errors.New("scope not found")
11 ErrScopeAlreadyExists = errors.New("scope already exists")
14 // Scope represents a limit on the access that a grant provides.
21 func (s *Scope) ApplyChange(change ScopeChange) {
22 if change.Name != nil {
25 if change.Description != nil {
26 s.Description = *change.Description
30 type sortedScopes []Scope
32 func (s sortedScopes) Len() int {
36 func (s sortedScopes) Swap(i, j int) {
37 s[i], s[j] = s[j], s[i]
40 func (s sortedScopes) Less(i, j int) bool {
41 return s[i].ID < s[j].ID
44 // ScopeChange represents a change to a Scope.
45 type ScopeChange struct {
50 func (s ScopeChange) Empty() bool {
51 return s.Name == nil && s.Description == nil
54 type scopeStore interface {
55 createScopes(scopes []Scope) error
56 getScopes(ids []string) ([]Scope, error)
57 updateScope(id string, change ScopeChange) error
58 removeScopes(ids []string) error
59 listScopes() ([]Scope, error)
62 func (m *memstore) createScopes(scopes []Scope) error {
64 defer m.scopeLock.Unlock()
66 for _, scope := range scopes {
67 if _, ok := m.scopes[scope.ID]; ok {
68 return ErrScopeAlreadyExists
71 for _, scope := range scopes {
72 m.scopes[scope.ID] = scope
77 func (m *memstore) getScopes(ids []string) ([]Scope, error) {
79 defer m.scopeLock.RUnlock()
82 for _, id := range ids {
83 scope, ok := m.scopes[id]
87 scopes = append(scopes, scope)
89 sorted := sortedScopes(scopes)
95 func (m *memstore) updateScope(id string, change ScopeChange) error {
97 defer m.scopeLock.Unlock()
99 scope, ok := m.scopes[id]
101 return ErrScopeNotFound
103 scope.ApplyChange(change)
108 func (m *memstore) removeScopes(ids []string) error {
110 defer m.scopeLock.Unlock()
112 for _, id := range ids {
113 if _, ok := m.scopes[id]; !ok {
114 return ErrScopeNotFound
117 for _, id := range ids {
123 func (m *memstore) listScopes() ([]Scope, error) {
125 defer m.scopeLock.RUnlock()
128 for _, scope := range m.scopes {
129 scopes = append(scopes, scope)
131 sorted := sortedScopes(scopes)