| | |
| | | driver: mysql |
| | | host: 192.168.20.115 |
| | | port: 3306 |
| | | # username: root |
| | | # password: c++java123 |
| | | username: root |
| | | password: c++java123 |
| | | name: faceanalysis |
| | | elastic: |
| | | host: 192.168.20.115 |
| | |
| | | } |
| | | |
| | | type database struct { |
| | | Driver string `mapstructure: "driver"` |
| | | Host string `mapstructure: "host"` |
| | | Port string `mapstructure: "port"` |
| | | Name string `mapstructure: "name"` |
| | | Driver string `mapstructure: "driver"` |
| | | Host string `mapstructure: "host"` |
| | | Port string `mapstructure: "port"` |
| | | Name string `mapstructure: "name"` |
| | | Username string `mapstructure: "username"` |
| | | Password string `mapstructure: "password"` |
| | | } |
| | | |
| | | type elastic struct { |
| | |
| | | // return nil |
| | | //} |
| | | |
| | | func ConnectDB() (error) { |
| | | dsn := "root:c++java123@tcp(" + config.DataBase.Host + ":" + config.DataBase.Port + ")/" + config.DataBase.Name + "?charset=utf8mb4&parseTime=True&loc=Local" |
| | | func ConnectDB() error { |
| | | dsn := config.DataBase.Username + ":" + config.DataBase.Password + "@tcp(" + config.DataBase.Host + ":" + config.DataBase.Port + ")/" + config.DataBase.Name + "?charset=utf8mb4&parseTime=True&loc=Local" |
| | | db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{}) |
| | | if err != nil { |
| | | return err |
| | | } |
| | | sqlDb,err := db.DB() |
| | | if err != nil{ |
| | | sqlDb, err := db.DB() |
| | | if err != nil { |
| | | return err |
| | | } |
| | | sqlDb.SetMaxIdleConns(2) |
| | |
| | | } |
| | | } |
| | | |
| | | return |
| | | //return |
| | | ruleInfo, err := db.GetAllData() |
| | | if err != nil { |
| | | logger.Error("GetAllData Error", err) |