-
Notifications
You must be signed in to change notification settings - Fork 0
/
db.go
42 lines (32 loc) · 948 Bytes
/
db.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
package models
import (
"database/sql"
"github.com/coopernurse/gorp"
_ "github.com/go-sql-driver/mysql"
"github.com/macococo/go-gamereviews/conf"
"github.com/macococo/go-gamereviews/utils"
"log"
"os"
)
var (
DbMap *gorp.DbMap
)
func init() {
dataSource := conf.Config.Datasource
maxIdleConns := conf.Config.MaxIdleConns
maxOpenConns := conf.Config.MaxOpenConns
log.Println("mysql datasource:", dataSource, ", maxIdleConns", maxIdleConns, ", maxOpenConns", maxOpenConns)
db, err := sql.Open("mysql", dataSource)
utils.HandleError(err)
db.SetMaxIdleConns(maxIdleConns)
db.SetMaxOpenConns(maxOpenConns)
DbMap = &gorp.DbMap{Db: db, Dialect: gorp.MySQLDialect{"InnoDB", "UTF8"}}
// Trace query log
if conf.IsDev() {
DbMap.TraceOn("", log.New(os.Stdout, "", log.Lmicroseconds))
}
// Define table metadata
new(UserManager).AddTable()
new(ChatroomManager).AddTable()
utils.HandleError(DbMap.CreateTablesIfNotExists())
}