-
Notifications
You must be signed in to change notification settings - Fork 1
/
audit_changeStore.go
132 lines (100 loc) · 3.16 KB
/
audit_changeStore.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
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
package storage
import (
_ "embed"
"time"
"github.com/google/uuid"
zap "go.uber.org/zap"
"github.com/cmsgov/mint-app/pkg/models"
)
//go:embed SQL/audit_change/collection_by_id_and_table.sql
var auditChangeCollectionByIDAndTable string
//go:embed SQL/audit_change/collection_by_id_and_table_and_field.sql
var auditChangeCollectionByIDAndTableAndField string
//go:embed SQL/audit_change/collection_by_primary_key_or_foreign_keyand_date.sql
var auditChangeCollectionByPrimaryKeyOrForeignKeyAndDate string
// AuditChangeCollectionByIDAndTable returns changes based on tablename and primary key from the database
func (s *Store) AuditChangeCollectionByIDAndTable(
_ *zap.Logger,
tableName string,
primaryKey uuid.UUID,
) ([]*models.AuditChange, error) {
var auditChanges []*models.AuditChange
stmt, err := s.db.PrepareNamed(auditChangeCollectionByIDAndTable)
if err != nil {
return nil, err
}
defer stmt.Close()
//Add support for secondary key perhaps
arg := map[string]interface{}{"primary_key": primaryKey,
"table_name": tableName,
}
err = stmt.Select(&auditChanges, arg)
if err != nil {
return nil, err
}
return auditChanges, nil
}
// AuditChangeCollectionByIDAndTableAndField returns changes based on tablename
// and primary key from the database. It will only return record sets where the
// given field was modified. It will return all changed fields anywyas
func (s *Store) AuditChangeCollectionByIDAndTableAndField(
_ *zap.Logger,
tableName string,
primaryKey uuid.UUID,
fieldName string,
sortDir models.SortDirection,
) ([]*models.AuditChange, error) {
var auditChanges []*models.AuditChange
orderedQuery := auditChangeCollectionByIDAndTableAndField
orderClause := "" //default to ASCENDING
if sortDir == models.SortDesc {
orderClause = " ORDER BY 1 DESC"
}
orderedQuery = orderedQuery + orderClause
stmt, err := s.db.PrepareNamed(orderedQuery)
if err != nil {
return nil, err
}
defer stmt.Close()
arg := map[string]interface{}{"primary_key": primaryKey,
"table_name": tableName,
"field_name": fieldName,
}
err = stmt.Select(&auditChanges, arg)
if err != nil {
return nil, err
}
return auditChanges, nil
}
// AuditChangeCollectionByPrimaryKeyOrForeignKeyAndDate returns changes based on foreign key and date from the database.
func (s *Store) AuditChangeCollectionByPrimaryKeyOrForeignKeyAndDate(
_ *zap.Logger,
primaryKey uuid.UUID,
foreignKey uuid.UUID,
dayToAnalyze time.Time,
sortDir models.SortDirection,
) ([]*models.AuditChange, error) {
var auditChanges []*models.AuditChange
orderedQuery := auditChangeCollectionByPrimaryKeyOrForeignKeyAndDate
orderClause := "" //default to ASCENDING
if sortDir == models.SortDesc {
orderClause = " ORDER BY 1 DESC"
}
orderedQuery = orderedQuery + orderClause
stmt, err := s.db.PrepareNamed(orderedQuery)
if err != nil {
return nil, err
}
defer stmt.Close()
arg := map[string]interface{}{
"primary_key": primaryKey,
"foreign_key": foreignKey,
"start_date": dayToAnalyze.Format("2006-01-02"),
"end_date": dayToAnalyze.AddDate(0, 0, 1).Format("2006-01-02"),
}
err = stmt.Select(&auditChanges, arg)
if err != nil {
return nil, err
}
return auditChanges, nil
}