func dbInit() { orm.RegisterModel(new(UserInfo), new(UserStatus), new(UserRecord)) //register mysql driver err := orm.RegisterDriver("mysql", orm.DR_MySQL) if err != nil { beego.Critical(err) } //register default database if !localSwitch { orm.RegisterDataBase("default", "mysql", "autelan:Autelan1202@tcp(rdsrenv7vrenv7v.mysql.rds.aliyuncs.com:3306)/umsdb?charset=utf8&&loc=Asia%2FShanghai") } else { dbIp := beego.AppConfig.String("DbIp") dbPort := beego.AppConfig.String("DbPort") dbName := beego.AppConfig.String("DbName") dbUser := beego.AppConfig.String("DbUser") dbPassword := beego.AppConfig.String("DbPassword") dbUrl := dbUser + ":" + dbPassword + "@tcp(" + dbIp + ":" + dbPort + ")/" + dbName + "?charset=utf8&loc=Asia%2FShanghai" beego.Debug("dbUrl=", dbUrl) err = orm.RegisterDataBase("default", "mysql", dbUrl) if err != nil { beego.Critical(err) } } orm.SetMaxIdleConns("default", 30) orm.SetMaxOpenConns("default", 30) ormer = orm.NewOrm() }
func init() { dbname := "default" runmode := beego.AppConfig.String("runmode") datasource := beego.AppConfig.String("datasource") switch runmode { case "prod": //orm.RegisterDriver("postgres", orm.DR_Postgres) //orm.RegisterDataBase(dbname, "postgres", datasource, 30) //orm.SetMaxIdleConns(dbname, 100) //orm.SetMaxOpenConns(dbname, 100) orm.RegisterDriver("mysql", orm.DRMySQL) orm.RegisterDataBase(dbname, "mysql", datasource) case "dev": orm.RegisterDriver("mysql", orm.DRMySQL) orm.RegisterDataBase(dbname, "mysql", datasource) default: //orm.RegisterDataBase(dbname, "sqlite3", datasource) orm.RegisterDriver("mysql", orm.DRMySQL) orm.RegisterDataBase(dbname, "mysql", datasource) } orm.DefaultTimeLoc = time.FixedZone("Asia/Tokyo", 9*60*60) force, verbose := false, true err := orm.RunSyncdb(dbname, force, verbose) if err != nil { panic(err) } // orm.RunCommand() }
func InitDatabase() { // set default database config := g.Config() orm.RegisterDataBase("default", "mysql", config.Uic.Addr, config.Uic.Idle, config.Uic.Max) orm.RegisterDataBase("falcon_portal", "mysql", config.FalconPortal.Addr, config.FalconPortal.Idle, config.FalconPortal.Max) // register model orm.RegisterModel(new(uic.User), new(uic.Session), new(event.Events), new(event.EventCases)) if config.Debug { orm.Debug = true } }
func init() { dbname := "default" // 数据库别名 dbtype := beego.AppConfig.String("dbtype") dbcfg, err := beego.AppConfig.GetSection(dbtype) if err != nil { panic(err) } // 统一采用 UTC 时间 orm.DefaultTimeLoc = time.UTC orm.Debug = true switch dbtype { case "mysql": var username string = dbcfg["username"] if username, err = utils.AesDecrypt(username); err != nil { panic(err) } var password string = dbcfg["password"] if password, err = utils.AesDecrypt(password); err != nil { panic(err) } url := dbcfg["url"] maxidle, _ := strconv.Atoi(dbcfg["maxidle"]) maxconn, _ := strconv.Atoi(dbcfg["maxconn"]) orm.RegisterDriver("mysql", orm.DR_MySQL) orm.RegisterDataBase(dbname, "mysql", username+":"+password+"@"+url, maxidle, maxconn) case "sqlite": url := dbcfg["url"] orm.RegisterDriver("sqlite3", orm.DR_Sqlite) orm.RegisterDataBase(dbname, "sqlite3", url) } orm.RegisterModel(new(User), new(UserBind), new(UserStats)) orm.RegisterModel(new(Question), new(Reply), new(QuestionMark), new(AnswerMark)) orm.RegisterModel(new(Category)) orm.RegisterModel(new(Blog)) orm.RegisterModel(new(Comment)) force := false // drop table 后再建表 verbose, _ := beego.AppConfig.Bool("SqlLogOn") // 打印执行过程 // 遇到错误立即返回 err = orm.RunSyncdb(dbname, force, verbose) if err != nil { fmt.Println(err) } }
func InitDatabase() { // set default database config := g.Config() orm.RegisterDataBase("default", "mysql", config.Db.Addr, config.Db.Idle, config.Db.Max) // register model orm.RegisterModel(new(Host), new(Grp), new(Grp_host), new(Grp_tpl), new(Tpl)) strConn := strings.Replace(config.Db.Addr, "graph", "grafana", 1) orm.RegisterDataBase("grafana", "mysql", strConn, config.Db.Idle, config.Db.Max) orm.RegisterModel(new(Province), new(City), new(Idc)) if config.Debug == true { orm.Debug = true } }
func (this *StellarAddressManager) regDatabase() { orm.RegisterModel(new(databasefunction.StellarAddrT)) orm.Debug = true orm.RegisterDriver("mysql", orm.DR_MySQL) dataSrcName := "root:1234@tcp(localhost:3306)/default?charset=utf8&loc=Asia%2FShanghai" orm.RegisterDataBase("default", "mysql", dataSrcName, 30) dataSrcName = "root:1234@tcp(localhost:3306)/stellaraddr_info?charset=utf8&loc=Asia%2FShanghai" orm.RegisterDataBase("stellaraddr_info", "mysql", dataSrcName, 30) this.dbPointer = orm.NewOrm() this.dbPointer.Using("stellaraddr_info") orm.RunSyncdb("stellaraddr_info", false, true) }
func initDb() { iniconf, err := config.NewConfig("ini", "conf/app.conf") if err != nil { beego.Error(err) } driverName := iniconf.String("orm::driver_name") dataSource := iniconf.String("orm::data_source") maxIdle, _ := iniconf.Int("orm::max_idle_conn") maxOpen, _ := iniconf.Int("orm::max_open_conn") // set default database err = orm.RegisterDataBase("default", driverName, dataSource, maxIdle, maxOpen) if err != nil { beego.Error(err) } // orm.Debug = true //orm.RunCommand() //执行命令行的 err = orm.RunSyncdb("default", false, false) //建表的 ////数据库别名,不强制建数据库,打印建表过程 if err != nil { beego.Error(err) } }
func init() { orm.RegisterDataBase("default", "sqlite3", DATABASEPATH) orm.RegisterModel(new(DB_message), new(DB_transaction), new(DB_blocks), new(DB_send)) orm.RunSyncdb("default", false, true) myorm = orm.NewOrm() myorm.Using("default") }
func init() { orm.RegisterDriver("mymysql", orm.DR_MySQL) orm.RegisterDataBase("default", "mymysql", "tcp:127.0.0.1:3306*test/root/mysql") orm.Debug = true orm.RegisterModel(new(Entity)) orm.BootStrap() }
func init() { // register model orm.RegisterModel(new(User)) // set default database orm.RegisterDataBase("go_blog", "postgres", "root:root@/my_db?charset=utf8", 30) }
func RegistDB() { orm.RegisterModel(new(User), new(Article), new(Stream)) orm.RegisterDriver("mysql", orm.DR_MySQL) orm.RegisterDataBase("default", "mysql", "root:mysql@/newblog?charset=utf8") orm.RunSyncdb("default", false, true) }
func init() { orm.RegisterDriver("mysql", orm.DRMySQL) orm.RegisterDataBase("go", "mysql", "cmsuser:cms@tcp(10.255.223.241:3306)/bookbar_fuzuokui?charset=utf8") orm.SetMaxIdleConns("go", 30) //设置数据库最大空闲连接 orm.SetMaxOpenConns("go", 30) //设置数据库最大连接数 orm.RegisterModel(new(GoBar)) }
func initDb(dbType string) { orm.DefaultRowsLimit = -1 switch dbType { case "mysql": orm.RegisterDriver("mysql", orm.DRMySQL) case "postgres": orm.RegisterDriver("postgres", orm.DRPostgres) default: panic("not specific db Type") } var initOk bool configerMap, _ := config.GlobalConfiger.Map(dbType) for key, value := range configerMap { if key == "default" { initOk = true } if err := orm.RegisterDataBase(key, dbType, value.(string)); err != nil { panic(err) } } if !initOk { panic("a database instance called default must be inited") } if config.GlobalConfiger.String("runmode") == "dev" { orm.Debug = true } }
func init() { if cfg, err := goconfig.LoadConfigFile("config.ini"); err == nil { dbUser, _ = cfg.GetValue(goconfig.DEFAULT_SECTION, "dbuser") dbPassword, _ = cfg.GetValue(goconfig.DEFAULT_SECTION, "dbpass") dbHost, _ = cfg.GetValue(goconfig.DEFAULT_SECTION, "dbhost") dbPort, _ = cfg.GetValue(goconfig.DEFAULT_SECTION, "dbport") dbName, _ = cfg.GetValue(goconfig.DEFAULT_SECTION, "dbname") } else { log.Println("读取配置文件conf.ini失败") } orm.DefaultTimeLoc = time.Local maxIdle := 50 //(可选) 设置最大空闲连接 maxConn := 100 //(可选) 设置最大数据库连接 (go >= 1.2) connStr := fmt.Sprintf("%s:%s@tcp(%s:%s)/%s?charset=utf8", dbUser, dbPassword, dbHost, dbPort, dbName, ) + "&loc=" + url.QueryEscape("Local") if err := orm.RegisterDataBase("default", "mysql", connStr, maxIdle, maxConn, ); err != nil { log.Println(err.Error()) } }
func init() { orm.RegisterDriver("mysql", orm.DR_MySQL) orm.RegisterDataBase("default", "mysql", "user:Passwd@/ayp?charset=utf8") orm.RegisterModel(new(models.Articulos), new(models.Categoria), new(models.Proveedor), new(models.Usuarios), new(models.Empresa)) }
func init() { orm.RegisterDriver("mysql", orm.DR_MySQL) err := orm.RegisterDataBase("default", "mysql", global.C.MySqlUrl) if err != nil { fmt.Println(err) } }
func init() { orm.RegisterDriver("mysql", orm.DR_MySQL) orm.RegisterDataBase("default", "mysql", "root:1234@tcp(localhost:3306)/os?charset=utf8") orm.RegisterModel(new(Groups), new(User), new(Grel)) ORM = orm.NewOrm() orm.Debug = true }
//InitDB initializes the database func InitDB() { orm.RegisterDriver("mysql", orm.DRMySQL) addr := os.Getenv("MYSQL_HOST") port := os.Getenv("MYSQL_PORT") username := os.Getenv("MYSQL_USR") password := os.Getenv("MYSQL_PWD") log.Debugf("db url: %s:%s, db user: %s", addr, port, username) dbStr := username + ":" + password + "@tcp(" + addr + ":" + port + ")/registry" ch := make(chan int, 1) go func() { var err error var c net.Conn for { c, err = net.DialTimeout("tcp", addr+":"+port, 20*time.Second) if err == nil { c.Close() ch <- 1 } else { log.Errorf("failed to connect to db, retry after 2 seconds :%v", err) time.Sleep(2 * time.Second) } } }() select { case <-ch: case <-time.After(60 * time.Second): panic("Failed to connect to DB after 60 seconds") } err := orm.RegisterDataBase("default", "mysql", dbStr) if err != nil { panic(err) } }
func init() { orm.RegisterDriver("mysql", orm.DR_MySQL) // orm.RegisterDataBase("local", "mysql", "root:1234@tcp(localhost:3306)/os?charset=utf8") orm.RegisterDataBase("default", "mysql", "cdb_outerroot:root1234@tcp(55c354e17de4e.sh.cdb.myqcloud.com:7276)/os?charset=utf8") orm.RegisterModel(new(Groups), new(User), new(Grel), new(Message), new(Item), new(Friends), new(Login)) ORM = orm.NewOrm() }
func init() { //register all tables orm.RegisterModel(new(Userinfo), new(Admininfo), new(Deviceinfo), new(Historyinfo), new(Command), new(OperationRecord), new(Alarm), new(Script)) //register mysql driver err := orm.RegisterDriver("mysql", orm.DR_MySQL) if err != nil { beego.Critical(err) } //register default database dbIp := beego.AppConfig.String("DbIp") dbPort := beego.AppConfig.String("DbPort") dbName := beego.AppConfig.String("DbName") dbUser := beego.AppConfig.String("DbUser") dbPassword := beego.AppConfig.String("DbPassword") dbUrl := dbUser + ":" + dbPassword + "@tcp(" + dbIp + ":" + dbPort + ")/" + dbName + "?charset=utf8&loc=Asia%2FShanghai" beego.Debug("dbUrl=", dbUrl) err = orm.RegisterDataBase("default", "mysql", dbUrl) if err != nil { beego.Critical(err) } //orm.RegisterDataBase("default", "mysql", "root:autelan@/lte_test?charset=utf8&&loc=Asia%2FShanghai") orm.SetMaxIdleConns("default", 30) orm.SetMaxOpenConns("default", 30) }
func init() { // orm.RegisterDataBase("default", "mysql", "root:1234@tcp(localhost:3306)/qq?charset=utf8") orm.RegisterDataBase("default", "mysql", "cdb_outerroot:root1234@tcp(55c354e17de4e.sh.cdb.myqcloud.com:7276)/qq?charset=utf8") orm.RegisterDriver("mysql", orm.DR_MySQL) orm.RegisterModel(new(User), new(Profile), new(Userz), new(Friends)) ORM = orm.NewOrm() }
func init() { /* 로그기록 */ //NewLogger(10000) beego.SetLogger("file", `{"filename":"server.log"}`) /* 데이타베이스 드라이브 설정 */ orm.RegisterDriver("mysql", orm.DR_MySQL) orm.RegisterDataBase("default", "mysql", "root:Kim616294.@/cluber?charset=utf8&loc=Asia%2FSeoul") /* 데이타베이스 테이블 등록 */ orm.RegisterModel(new(models.User)) orm.RegisterModel(new(models.Log)) orm.RegisterModel(new(models.Contents)) // 사용 데이타베이스 name := "default" // 서버 시작시 테이블 재생성 force := false // SQL 로그 확인 verbose := true // 데이타베이스를 동기화 하고 에러 발생시 err 에 에러내용 입력 err := orm.RunSyncdb(name, force, verbose) if err != nil { fmt.Println(err) } }
func initORM() { if ormInitiated { return } appConf, err := config.NewConfig("ini", "conf/app.conf") if err != nil { panic(err) } dbAddr := appConf.String("admin::dbAddr") dbUser := appConf.String("admin::dbUser") dbPass := appConf.String("admin::dbPass") controllers.ALI_YUN_AK_ID = appConf.String("admin::akId") controllers.ALI_YUN_AK_KEY = appConf.String("admin::akKey") controllers.QQ_OAUTH_CONSUMER_KEY = appConf.String("admin::qqOAuthConsumerKey") clientId := appConf.String("admin::clientId") clientSecret := appConf.String("admin::clientSecret") controllers.BASIC_AUTH_AUTHORIZATION = utils.Base64(clientId + ":" + clientSecret) controllers.VISITOR_TOKEN = appConf.String("admin::visitorToken") orm.RegisterDriver("mymysql", orm.DRMySQL) conn := fmt.Sprintf("%s:%s@tcp(%s)/beego_unit_test?charset=utf8mb4", dbUser, dbPass, dbAddr) orm.RegisterDataBase("default", "mysql", conn) ormInitiated = true }
// Init will initialize database to create tables automatically. func init() { // Registry archci database models. models.RegisterModels() // Initialize database with environment variables. server := "" username := "******" password := "******" database := "mysql" if os.Getenv(ENV_MYSQL_SERVER) != "" { server = os.Getenv(ENV_MYSQL_SERVER) } if os.Getenv(ENV_MYSQL_USERNAME) != "" { username = os.Getenv(ENV_MYSQL_USERNAME) } if os.Getenv(ENV_MYSQL_PASSWORD) != "" { password = os.Getenv(ENV_MYSQL_PASSWORD) } if os.Getenv(ENV_MYSQL_DATABASE) != "" { database = os.Getenv(ENV_MYSQL_DATABASE) } // The datasource looks like "root:root@/archci?charset=utf8". DATASOURCE := username + ":" + password + "@" + server + "/" + database + "?charset=utf8" fmt.Println("Connect to database with " + DATASOURCE) orm.RegisterDriver(MYSQL_DRIVER, orm.DR_MySQL) orm.RegisterDataBase("default", MYSQL_DRIVER, DATASOURCE, 30) orm.RunSyncdb("default", false, true) }
func init() { //获取服务器数据库相关信息 dbhost := beego.AppConfig.String("db_host") dbport := beego.AppConfig.String("db_port") dbuser := beego.AppConfig.String("db_user") dbpassword := beego.AppConfig.String("db_pass") dbname := beego.AppConfig.String("db_name") dbIdle, _ := beego.AppConfig.Int("db_max_idle_conn") dbConn, _ := beego.AppConfig.Int("db_max_open_conn") dburl := dbuser + ":" + dbpassword + "@tcp(" + dbhost + ":" + dbport + ")/" + dbname + "?charset=utf8" orm.RegisterDataBase("default", "mysql", dburl, dbIdle, dbConn) //注册模型 orm.RegisterModel(new(Category), new(Topic), new(Comment)) if beego.AppConfig.String("runmode") == "dev" { orm.Debug = true } //新建数据库表 orm.RunSyncdb("default", false, true) //附件上传文件夹处理 os.Mkdir("attachment", os.ModePerm) }
func init() { duangcfg, err := config.NewConfig("ini", "conf/duang.conf") if err != nil { fmt.Println(err) return } orm.RegisterDriver("mysql", orm.DR_MySQL) orm.RegisterDataBase("default", "mysql", fmt.Sprintf("%s:%s@%s/%s?charset=utf8", duangcfg.String("db_user"), duangcfg.String("db_pass"), duangcfg.String("db_addr"), duangcfg.String("db_name"))) orm.RegisterModel( new(Unit), new(UnitParameter), new(Dockerd), new(Ip), new(Container), //new(Frontend), //new(Backend), ) force, err := duangcfg.Bool("db_dropifexist") if err != nil { force = false } verbose := true err = orm.RunSyncdb("default", force, verbose) if err != nil { beego.Error(err) } }
func init() { orm.Debug = true orm.RegisterDriver("sqlite", orm.DR_Sqlite) orm.RegisterDataBase("default", "sqlite3", "./gowebssh.db") }
//初始化mysql或postgresql数据库,配置参数如下 // // db_type 数据库类型,mysql或postgres(mysql) // // db_host 数据库主机地址(127.0.0.1) // // db_port 数据库端口(3306) // // db_user 数据库用户(root) // // db_pass 数据库密码 // // db_name 数据库名 // // db_sslmode 是否SSL模式连接,仅用于postgresql(disable) func InitDB() { if beego.BConfig.RunMode == "dev" { beego.Info("initiating db") } var dsn string db_type := beego.AppConfig.DefaultString("db_type", "mysql") db_host := beego.AppConfig.DefaultString("db_host", "127.0.0.1") db_port := beego.AppConfig.DefaultString("db_port", "3306") db_user := beego.AppConfig.DefaultString("db_user", "root") db_pass := beego.AppConfig.DefaultString("db_pass", "") db_name := beego.AppConfig.String("db_name") //db_path := beego.AppConfig.String("db_path") db_sslmode := beego.AppConfig.DefaultString("db_sslmode", "disable") switch db_type { case "mysql": orm.RegisterDriver("mysql", orm.DRMySQL) dsn = fmt.Sprintf("%s:%s@tcp(%s:%s)/%s?charset=utf8", db_user, db_pass, db_host, db_port, db_name) break case "postgres": orm.RegisterDriver("postgres", orm.DRPostgres) dsn = fmt.Sprintf("dbname=%s host=%s user=%s password=%s port=%s sslmode=%s", db_name, db_host, db_user, db_pass, db_port, db_sslmode) // case "sqlite3": // orm.RegisterDriver("sqlite3", orm.DR_Sqlite) // if db_path == "" { // db_path = "./" // } // dns = fmt.Sprintf("%s%s.db", db_path, db_name) // break default: panic("Database driver is not allowed:" + db_type) } orm.RegisterDataBase("default", db_type, dsn) }
func RegistDB() { host := beego.AppConfig.String("DBhost") dataSource := "root:arvin@(" + host + ":3306)/test?charset=utf8" orm.RegisterModel(new(Category), new(Topic), new(Reply)) orm.RegisterDriver("mysql", orm.DRMySQL) orm.RegisterDataBase("default", "mysql", dataSource) }
func init() { //读取配置文件信息 settings := func(path string) map[string]string { return goutils.NewConfig().Load(path).GlobalContent() }("conf/app.conf") //获取settings中的信息 dbinfo, ok := settings["DBINFO"] if !ok { log.Fatal("not found DBINFO in config file") } orm.RegisterDriver("mysql", orm.DRMySQL) orm.RegisterDataBase("default", "mysql", dbinfo) orm.RegisterModel( new(First), new(Second), new(System), new(Userinfo), new(Userlog), new(Novel), new(Content), new(Collectrank), new(Clickrank), new(Recommend), ) }