/
process.go
108 lines (95 loc) · 2.03 KB
/
process.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
package adapters
import (
"database/sql"
"log"
"strconv"
"github.com/antonholmquist/jason"
_ "github.com/go-sql-driver/mysql"
"github.com/hendra009/qrest1/config"
)
const SelectFrom = `select * from `
func CheckField(table, field string) bool {
check := "select COLUMN_NAME from columns where TABLE_NAME = ?"
db := Conn("INFORMATION_SCHEMA")
defer db.Close()
rs, err := db.Query(check, table)
if err != nil {
log.Println(err)
return false
}
columnName := ""
for rs.Next() {
rs.Scan(&columnName)
if columnName == field {
return true
}
}
return false
}
func CheckTable(table string) bool {
query := "show tables"
db := Conn(config.Conf.MDBDatabase)
defer db.Close()
rs, err := db.Query(query)
if err != nil {
log.Println(err)
return false
}
tableName := ""
for rs.Next() {
rs.Scan(&tableName)
if tableName == table {
return true
}
}
return false
}
func ProcessPut(j *jason.Object, table string) string {
for x := range j.Map() {
if CheckField("Player", x) {
} else {
return "json invalid"
}
}
if Insertinto(table, j) {
return "inserted"
}
return "json invalid"
}
func ProcessGet(table, field, value, page, pagesize string) []byte {
log.Println("Processing", table, field, value, page, pagesize)
db := Conn(config.Conf.MDBDatabase)
var x *sql.Rows
var err error
var pagei int
var pagesi int
if db != nil {
pagei, err = strconv.Atoi(page)
if err == nil || pagei == 0 {
pagesi, err = strconv.Atoi(pagesize)
if err == nil || pagesi == 0 {
query := PrepareSelectQuery(table, field, pagei, pagesi)
if value != "" {
x, err = db.Query(query, value)
} else {
x, err = db.Query(query)
}
if err != nil {
log.Println(err)
return nil
}
result, _ := JSONify(x)
return []byte(result)
}
log.Println("error at parsing pagesize")
} else {
log.Println("error at parsing page")
}
} else {
log.Println("Error while creating db conn")
}
return nil
}
func ProcessPost(j *jason.Object, table string) string {
return "not implemented"
}