/
conn.go
128 lines (108 loc) · 3.84 KB
/
conn.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
package conn
import (
"database/sql"
"fmt"
"log"
"os"
"time"
. "github.com/golangast/groundup/pkg/utility/generate"
_ "modernc.org/sqlite"
)
const file string = "../src/db/urls.db"
func DbConnection() (*sql.DB, error) {
//db urls conn to db database used
db, err := sql.Open("sqlite", file)
if err != nil {
fmt.Println(err)
}
db.Driver()
db.SetMaxOpenConns(20)
db.SetMaxIdleConns(20)
db.SetConnMaxLifetime(time.Minute * 5)
//check if it pings
err = db.Ping()
if err != nil {
fmt.Println(err)
}
log.Printf("Connected to DB %s successfully\n", file)
return db, nil
} //end of connect
func ErrorCheck(err error) {
if err != nil {
fmt.Println(err.Error())
}
}
const appfile string = "../app/db/database.db"
func AppDbConnection() (*sql.DB, error) {
_, err := os.Stat(appfile)
ErrorCheck(err)
if os.IsNotExist(err) {
// file does not exist
Makefolder("../app/db/")
_ = Makefile("../app/db/database.db")
//db urls conn to db database used
db, err := sql.Open("sqlite", appfile)
if err != nil {
fmt.Println(err)
}
db.Driver()
db.SetMaxOpenConns(20)
db.SetMaxIdleConns(20)
db.SetConnMaxLifetime(time.Minute * 5)
//check if it pings
err = db.Ping()
if err != nil {
fmt.Println(err)
}
log.Printf("Connected to DB %s successfully\n", file)
return db, nil
} else {
//db urls conn to db database used
db, err := sql.Open("sqlite", appfile)
if err != nil {
fmt.Println(err)
}
db.Driver()
db.SetMaxOpenConns(20)
db.SetMaxIdleConns(20)
db.SetConnMaxLifetime(time.Minute * 5)
//check if it pings
err = db.Ping()
if err != nil {
fmt.Println(err)
}
log.Printf("Connected to DB %s successfully\n", file)
return db, nil
// other error
} //end of connect
var a *sql.DB
return a, nil
}
type DBFields struct {
ID int `param:"id" query:"id" header:"id" form:"id" json:"id" xml:"id"`
Stable string `param:"stable" query:"stable" header:"stable" form:"stable" json:"stable" xml:"stable"`
F0 string `param:"f0" query:"f0" header:"f0" form:"f0" json:"f0" xml:"f0"`
F1 string `param:"f1" query:"f1" header:"f1" form:"f1" json:"f1" xml:"f1"`
F2 string `param:"f2" query:"f2" header:"f2" form:"f2" json:"f2" xml:"f2"`
F3 string `param:"f3" query:"f3" header:"f3" form:"f3" json:"f3" xml:"f3"`
F4 string `param:"f4" query:"f4" header:"f4" form:"f4" json:"f4" xml:"f4"`
F5 string `param:"f5" query:"f5" header:"f5" form:"f5" json:"f5" xml:"f5"`
F6 string `param:"f6" query:"f6" header:"f6" form:"f6" json:"f6" xml:"f6"`
F7 string `param:"f7" query:"f7" header:"f7" form:"f7" json:"f7" xml:"f7"`
F8 string `param:"f8" query:"f8" header:"f8" form:"f8" json:"f8" xml:"f8"`
F9 string `param:"f9" query:"f9" header:"f9" form:"f9" json:"f9" xml:"f9"`
F10 string `param:"f10" query:"f10" header:"f10" form:"f10" json:"f10" xml:"f10"`
F11 string `param:"f11" query:"f11" header:"f11" form:"f11" json:"f11" xml:"f11"`
T0 string `param:"t0" query:"t0" header:"t0" form:"t0" json:"t0" xml:"t0"`
T1 string `param:"t1" query:"t1" header:"t1" form:"t1" json:"t1" xml:"t1"`
T2 string `param:"t2" query:"t2" header:"t2" form:"t2" json:"t2" xml:"t2"`
T3 string `param:"t3" query:"t3" header:"t3" form:"t3" json:"t3" xml:"t3"`
T4 string `param:"t4" query:"t4" header:"t4" form:"t4" json:"t4" xml:"t4"`
T5 string `param:"t5" query:"t5" header:"t5" form:"t5" json:"t5" xml:"t5"`
T6 string `param:"t6" query:"t6" header:"t6" form:"t6" json:"t6" xml:"t6"`
T7 string `param:"t7" query:"t7" header:"t7" form:"t7" json:"t7" xml:"t7"`
T8 string `param:"t8" query:"t8" header:"t8" form:"t8" json:"t8" xml:"t8"`
T9 string `param:"t9" query:"t9" header:"t9" form:"t9" json:"t9" xml:"t9"`
T10 string `param:"t10" query:"t10" header:"t10" form:"t10" json:"t10" xml:"t10"`
T11 string `param:"t11" query:"t11" header:"t11" form:"t11" json:"t11" xml:"t11"`
}