auth

Paddy 2015-04-07 Parent:5f670aba87b4 Child:cf6c1f05eb21

155:762953f6a7f2 Go to Latest

auth/session_postgres.go

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.

Download raw file
View source Diff to previous Annotate
History
1 package auth
2
3 import (
4 "time"
5
6 "code.secondbit.org/uuid.hg"
7
8 "github.com/lib/pq"
9 "github.com/secondbit/pan"
10 )
11
12 func (s Session) GetSQLTableName() string {
13 return "sessions"
14 }
15
16 func (p *postgres) createSessionSQL(session Session) *pan.Query {
17 fields, values := pan.GetFields(session)
18 query := pan.New(pan.POSTGRES, "INSERT INTO "+pan.GetTableName(session))
19 query.Include("(" + pan.QueryList(fields) + ")")
20 query.Include("VALUES")
21 query.Include("("+pan.VariableList(len(values))+")", values...)
22 return query.FlushExpressions(" ")
23 }
24
25 func (p *postgres) createSession(session Session) error {
26 query := p.createSessionSQL(session)
27 _, err := p.db.Exec(query.String(), query.Args...)
28 if e, ok := err.(*pq.Error); ok && e.Constraint == "sessions_pkey" {
29 err = ErrSessionAlreadyExists
30 }
31 return err
32 }
33
34 func (p *postgres) getSessionSQL(id string) *pan.Query {
35 var session Session
36 fields, _ := pan.GetFields(session)
37 query := pan.New(pan.POSTGRES, "SELECT "+pan.QueryList(fields)+" FROM "+pan.GetTableName(session))
38 query.IncludeWhere()
39 query.Include(pan.GetUnquotedColumn(session, "ID")+" = ?", id)
40 return query.FlushExpressions(" ")
41 }
42
43 func (p *postgres) getSession(id string) (Session, error) {
44 query := p.getSessionSQL(id)
45 rows, err := p.db.Query(query.String(), query.Args...)
46 if err != nil {
47 return Session{}, err
48 }
49 var session Session
50 var found bool
51 for rows.Next() {
52 err := pan.Unmarshal(rows, &session)
53 if err != nil {
54 return session, err
55 }
56 found = true
57 }
58 if err = rows.Err(); err != nil {
59 return session, err
60 }
61 if !found {
62 return session, ErrSessionNotFound
63 }
64 return session, nil
65 }
66
67 func (p *postgres) removeSessionSQL(id string) *pan.Query {
68 var session Session
69 query := pan.New(pan.POSTGRES, "DELETE FROM "+pan.GetTableName(session))
70 query.IncludeWhere()
71 query.Include(pan.GetUnquotedColumn(session, "ID")+" = ?", id)
72 return query.FlushExpressions(" ")
73 }
74
75 func (p *postgres) removeSession(id string) error {
76 query := p.removeSessionSQL(id)
77 res, err := p.db.Exec(query.String(), query.Args...)
78 if err != nil {
79 return err
80 }
81 rows, err := res.RowsAffected()
82 if err != nil {
83 return err
84 }
85 if rows < 1 {
86 return ErrSessionNotFound
87 }
88 return nil
89 }
90
91 func (p *postgres) listSessionsSQL(profile uuid.ID, before time.Time, num int64) *pan.Query {
92 var session Session
93 fields, _ := pan.GetFields(session)
94 query := pan.New(pan.POSTGRES, "SELECT "+pan.QueryList(fields)+" FROM "+pan.GetTableName(session))
95 query.IncludeWhere()
96 query.Include(pan.GetUnquotedColumn(session, "ProfileID")+" = ?", profile)
97 if !before.IsZero() {
98 query.Include(pan.GetUnquotedColumn(session, "Created")+" < ?", before)
99 }
100 query.FlushExpressions(" AND ")
101 if num > 0 {
102 query.IncludeLimit(num)
103 }
104 return query.FlushExpressions(" ")
105 }
106
107 func (p *postgres) listSessions(profile uuid.ID, before time.Time, num int64) ([]Session, error) {
108 query := p.listSessionsSQL(profile, before, num)
109 rows, err := p.db.Query(query.String(), query.Args...)
110 if err != nil {
111 return []Session{}, err
112 }
113 var sessions []Session
114 for rows.Next() {
115 var session Session
116 err := pan.Unmarshal(rows, &session)
117 if err != nil {
118 return sessions, err
119 }
120 sessions = append(sessions, session)
121 }
122 if err = rows.Err(); err != nil {
123 return sessions, err
124 }
125 return sessions, nil
126 }