-
Notifications
You must be signed in to change notification settings - Fork 0
/
db.go
49 lines (43 loc) · 1.05 KB
/
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
43
44
45
46
47
48
49
package main
import (
"database/sql"
"fmt"
"log"
"os"
"time"
_ "github.com/go-sql-driver/mysql"
)
var DB *sql.DB
var errx error
func init() {
fs, errx := os.OpenFile("/var/log/fserver.log", os.O_RDWR|os.O_CREATE|os.O_APPEND, 766)
if errx != nil {
log.Fatalln(errx)
}
logg = log.New(fs, "[fserver]", log.LstdFlags|log.Lshortfile|log.LUTC)
logg.Println("hello")
}
type SaveTable struct {
Id int `json:"id"`
Name string `json:"name"`
HashName string `json:"hash_name"`
CreateTime int64 `json:"create_time"`
}
func init() {
DB, errx = sql.Open("mysql", fmt.Sprintf("%s:%s@%s(%s:%s)/%s", "fileuser", "Fileuser2232@", "tcp", "localhost", "3306", "file"))
if errx != nil {
logg.Fatalln(errx)
}
}
func AddFile(name, hashName string) {
stmt, err := DB.Prepare("insert into save set name=?,hash_name=?,create_time=?")
if err != nil {
logg.Panicln(err)
return
}
_, err = stmt.Exec(name, hashName, time.Now().Unix())
if err != nil {
logg.Panicln(err)
}
logg.Println("save file :[" + name + "]\t" + "=>[" + hashName + "]")
}