RegisterDataBase 注册数据库
()
| 29 | |
| 30 | // RegisterDataBase 注册数据库 |
| 31 | func RegisterDataBase() { |
| 32 | |
| 33 | host := beego.AppConfig.String("db_host") |
| 34 | database := beego.AppConfig.String("db_database") |
| 35 | username := beego.AppConfig.String("db_username") |
| 36 | password := beego.AppConfig.String("db_password") |
| 37 | |
| 38 | port := beego.AppConfig.String("db_port") |
| 39 | |
| 40 | createDB := fmt.Sprintf("CREATE DATABASE IF NOT EXISTS `%s` DEFAULT CHARSET utf8mb4 COLLATE utf8mb4_general_ci", database) |
| 41 | conn := fmt.Sprintf("%s:%s@tcp(%s:%s)/", username, password, host, port) |
| 42 | db, err := sql.Open("mysql", conn) |
| 43 | if err != nil { |
| 44 | panic(err) |
| 45 | } |
| 46 | _, err = db.Exec(createDB) |
| 47 | if err != nil { |
| 48 | panic(err) |
| 49 | } |
| 50 | |
| 51 | dataSource := fmt.Sprintf("%s:%s@tcp(%s:%s)/%s?charset=utf8mb4&parseTime=true&loc=Local", username, password, host, port, database) |
| 52 | |
| 53 | orm.RegisterDataBase("default", "mysql", dataSource) |
| 54 | |
| 55 | if beego.AppConfig.String("runmode") == "dev" { |
| 56 | orm.Debug = true |
| 57 | } |
| 58 | } |
| 59 | |
| 60 | // RegisterModel 注册Model |
| 61 | func RegisterModel() { |