33 lines
641 B
Go
33 lines
641 B
Go
package Database
|
|
|
|
import (
|
|
_ "github.com/go-sql-driver/mysql"
|
|
"github.com/jmoiron/sqlx"
|
|
"log"
|
|
"time"
|
|
)
|
|
|
|
type DbHandlerType struct {
|
|
Sqlx *sqlx.DB
|
|
}
|
|
|
|
var DbHandler *DbHandlerType
|
|
|
|
func (database *DbHandlerType) ConnectToDb() {
|
|
DbHandler := &DbHandlerType{}
|
|
db, err := sqlx.Connect("mysql", "user:Sml12345@(10.0.1.5:3306)/karma")
|
|
DbHandler.Sqlx = db
|
|
DbHandler.Sqlx.SetConnMaxLifetime(time.Minute * 5)
|
|
if err != nil {
|
|
log.Fatalln(err)
|
|
}
|
|
for i := range schema {
|
|
DbHandler.Sqlx.MustExec(schema[i])
|
|
}
|
|
}
|
|
func (database *DbHandlerType) AddPoint(uid int, cid int) {
|
|
|
|
}
|
|
func (database *DbHandlerType) GetPoints(uid int, cid int) {
|
|
|
|
}
|