-
Notifications
You must be signed in to change notification settings - Fork 0
/
lowlevel.go
82 lines (69 loc) · 2.34 KB
/
lowlevel.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
package p4db
import (
"database/sql"
"time"
)
func (db *P4db) SubContainersList(pid int64) (res []Container, err error) {
res = []Container{}
err = db.C.Select(&res, "select * from Containers where LinkUp=?", pid)
return
}
func (db *P4db) CAttributes(cid int64) (res []dataValuesCDB, err error) {
res = []dataValuesCDB{}
err = db.C.Select(&res, "select * from DataValuesC where LinkContainer=? ", cid)
return
}
func (db *P4db) IAttributes(cid int64) (res []dataValuesIDB, err error) {
res = []dataValuesIDB{}
err = db.C.Select(&res, "select * from DataValuesI where LinkContainer=?", cid)
return
}
func (db *P4db) DAttributes(cid int64) (res []dataValuesCDB, err error) {
res = []dataValuesCDB{}
err = db.C.Select(&res, "select * from DataValuesD where LinkContainer=? ", cid)
return
}
func (db *P4db) RAttributes(cid int64) (res []dataValuesRDB, err error) {
res = []dataValuesRDB{}
err = db.C.Select(&res, "select * from DataValuesR where LinkContainer=? ", cid)
return
}
func (db *P4db) PAttributes(cid int64) (res []dataValuesPDB, err error) {
res = []dataValuesPDB{}
err = db.C.Select(&res, "select * from DataValuesP where LinkContainer=? ", cid)
return
}
func (db *P4db) XAttributes(cid int64) (res []dataValuesXDB, err error) {
res = []dataValuesXDB{}
err = db.C.Select(&res, "select * from DataValuesX where LinkContainer=? ", cid)
return
}
func (db *P4db) FAttributes(cid int64) (res []dataValuesIDB, err error) {
res = []dataValuesIDB{}
err = db.C.Select(&res, "select * from DataValuesF where LinkContainer=? ", cid)
return
}
type changeLogDB struct {
TableType string `db:"TableType"`
Operation string `db:"Operation"`
Modified time.Time `db:"Modified"`
UserID int16 `db:"UserID"`
Link int64 `db:"Link"`
}
func (db *P4db) LogRecords(id int64, tableName string) (res []changeLogDB, err error) {
res = []changeLogDB{}
err = db.C.Select(&res, "select * from ChangeLog where Link=? and TableType=?", id, tableName)
return
}
type usersDB struct {
UserID int16 `db:"UserID"`
UserName string `db:"UserName"`
// UserPwd sql.NullString `db:"UserPwd"`
UserComment sql.NullString `db:"UserComment"`
IsDbAdmin int8 `db:"IsDbAdmin"`
}
func (db *P4db) Users() (res []usersDB, err error) {
res = []usersDB{}
err = db.C.Select(&res, "select UserID, UserName, UserComment, IsDbAdmin from Users")
return
}