func init() {
	// dbhost := beego.AppConfig.String("dbhost")
	// dbport := beego.AppConfig.String("dbport")
	dbuser := beego.AppConfig.String("dbuser")
	dbpassword := beego.AppConfig.String("dbpassword")
	dbname := beego.AppConfig.String("dbname")

	// if dbport == "" {
	// 	dbport = "3306"
	// }

	//注册mysql Driver
	orm.RegisterDriver("mysql", orm.DRMySQL)
	//构造conn连接
	conn := dbuser + ":" + dbpassword + "@/" + dbname + "?charset=utf8"
	//数据库别名
	alice := "default"
	//不强制建数据库
	force := false
	//打印建表过程
	verbose := true

	orm.RegisterDataBase(alice, "mysql", conn)
	orm.RegisterModel(new(Admin), new(Article), new(ArticleCate), new(AutoUser), new(Baoliao), new(Item), new(ItemCate), new(ItemComment), new(ItemTag), new(Mall), new(Tag))
	//建表
	err := orm.RunSyncdb(alice, force, verbose)
	if err != nil {
		beego.Error(err)
	}

	if beego.AppConfig.String("runmode") == "dev" {
		orm.Debug = true
	}

}

func RegistDB() {
	orm.RegisterModel(new(User), new(Article), new(Stream))
	orm.RegisterDriver("mysql", orm.DR_MySQL)
	orm.RegisterDataBase("default", "mysql", "root:[email protected]/newblog?charset=utf8")
	orm.RunSyncdb("default", false, true)

}

// Init will initialize database to create tables automatically.
func init() {
	// Registry archci database models.
	models.RegisterModels()

	// Initialize database with environment variables.
	server := ""
	username := "root"
	password := "root"
	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:[email protected]/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() {
	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 main() {
	orm.Debug = true
	orm.RunSyncdb("default", false, true)
	/* 设置Session配置*/
	beego.SessionOn = false
	beego.Run()
}

func init() {
	/* 로그기록 */
	//NewLogger(10000)
	beego.SetLogger("file", `{"filename":"server.log"}`)

	/* 데이타베이스 드라이브 설정 */
	orm.RegisterDriver("mysql", orm.DR_MySQL)
	orm.RegisterDataBase("default", "mysql", "root:[email protected]/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 main() {
	orm.Debug = true
	orm.RunSyncdb("default", true, true)
	beego.Router("/", &controllers.MainController{})

	beego.Run()
}

func LoadConfig() {
	redisServer := beego.AppConfig.String("redis_resource")
	redisServer = "{\"conn\":\"" + redisServer + "\"}"
	store, err := cache.NewCache("redis", redisServer)
	if err != nil {
		log.Panic("缓存出错" + err.Error())
	}
	Captcha = captcha.NewWithFilter("/captcha/", store)

	driverName := beego.AppConfig.String("driverName")
	dataSource := beego.AppConfig.String("dataSource")
	maxIdle, _ := beego.AppConfig.Int("maxIdle")
	maxOpen, _ := beego.AppConfig.Int("maxOpen")

	orm.RegisterDriver("mysql", orm.DR_MySQL)

	// set default database
	err = orm.RegisterDataBase("default", driverName, dataSource, maxIdle, maxOpen)
	if err != nil {
		beego.Error(err)
	}
	orm.RunCommand()

	err = orm.RunSyncdb("default", false, false)
	if err != nil {
		beego.Error(err)
	}
	SocialAuthInit()

	config.InitConfig()
}

func main() {
	// Database alias.
	name := "default"

	// Drop table and re-create.
	force := true

	// Print log.
	verbose := true

	// Error.
	err := orm.RunSyncdb(name, force, verbose)
	if err != nil {
		fmt.Println(err)
	}
	o := orm.NewOrm()
	o.Using("default")
	seed(o)

	beego.InsertFilter("*", beego.BeforeRouter, cors.Allow(&cors.Options{
		AllowAllOrigins: true,
	}))

	beego.Run()
}

func main() {

	// get config data
	db_driver := beego.AppConfig.String("db_driver")
	if db_driver != "" {
		log.Println("db_driver: ", db_driver)
	}
	db_source := beego.AppConfig.String("db_source")
	if db_source != "" {
		log.Println("db_source: ", db_source)
	}
	db_maxidle, err := beego.AppConfig.Int("db_maxidle")
	if err == nil && db_maxidle != 0 {
		log.Println("db_maxidle: ", db_maxidle)
	}
	db_maxconn, err := beego.AppConfig.Int("db_maxconn")
	if err == nil && db_maxconn != 0 {
		log.Println("db_maxconn: ", db_maxconn)
	}

	// set database
	err = orm.RegisterDataBase("default", db_driver, db_source, db_maxidle, db_maxconn)
	if err != nil {
		beego.Error(err)
	}
	err = orm.RunSyncdb("default", false, false)
	if err != nil {
		beego.Error(err)
	}

	beego.SetStaticPath("/upload", "upload")

	beego.SessionOn = true
	beego.Run()
}

func DBInit() {
	orm.Debug = true

	orm.RegisterDataBase("default", "sqlite3", "data.db", 30)
	orm.RunSyncdb("default", true, true)

	o := orm.NewOrm()
	o.Using("default")

	user := &User{
		Account:  "[email protected]",
		Password: "admin",
		Showname: "管理员",
	}

	h := md5.New()
	h.Write([]byte(user.Password))
	user.Password = hex.EncodeToString(h.Sum(nil))

	id, err := o.Insert(user)
	if err != nil {
		log.Info("%s.", err.Error())
	} else {
		log.Info("User added,ID is:%d.", id)
	}
}

//////////////////////////////////////////////////
// init initializes the database and rebuilds the tables from file data
func init() {
	dbuser := beego.AppConfig.String("mysqluser")
	dbpass := beego.AppConfig.String("mysqlpass")
	database := beego.AppConfig.String("mysqldb")

	orm.RegisterDataBase("default", "mysql", dbuser+":"+dbpass+"@/"+database+"?charset=utf8")
	orm.SetMaxIdleConns("default", 30)
	orm.SetMaxOpenConns("default", 30)

	orm.RegisterModel(new(User), new(Project), new(ProjectUser), new(Message), new(Star), new(Groups), new(GroupUser), new(Rights), new(SessionToken))

	// Drop all runtime tables
	o := orm.NewOrm()
	o.Raw("SET FOREIGN_KEY_CHECKS=0;").Exec()
	_, err := o.Raw("TRUNCATE TABLE user;").Exec()
	if err != nil {
		// If table can't be truncated, rebuild all tables (CAUTION: Star and Message db are lost!)
		// This is only for absolute startup
		err := orm.RunSyncdb("default", true, true)
		if err != nil {
			beego.Error(err)
		}
	}
	o.Raw("TRUNCATE TABLE message;").Exec()
	o.Raw("TRUNCATE TABLE rights;").Exec()
	o.Raw("TRUNCATE TABLE project;").Exec()
	o.Raw("TRUNCATE TABLE project_user;").Exec()
	o.Raw("TRUNCATE TABLE groups;").Exec()
	o.Raw("TRUNCATE TABLE group_user;").Exec()
	o.Raw("SET FOREIGN_KEY_CHECKS=1;").Exec()

	createAllUserDatabaseEntries()
}

func main() {
	orm.Debug = true
	orm.RunSyncdb("default", false, true)

	beego.Router("/", &controllers.MainController{})
	beego.Router("/login", &controllers.LoginController{})
	beego.Router("/category", &controllers.CategoryController{})
	beego.Router("/reply", &controllers.ReplyController{})
	beego.AutoRouter(&controllers.ReplyController{})
	beego.Router("/topic", &controllers.TopicController{})
	beego.AutoRouter(&controllers.TopicController{})

	os.Mkdir("attachment", os.ModePerm)
	beego.SetStaticPath("/attachment", "attachment")

	err := i18n.SetMessage("en-US", "conf/locale_en-US.ini")
	if err != nil {
		beego.Error(err)
	}
	err = i18n.SetMessage("zh-CN", "conf/locale_zh-CN.ini")
	if err != nil {
		beego.Error(err)
	}
	err = i18n.SetMessage("zh-HK", "conf/locale_zh-HK.ini")
	if err != nil {
		beego.Error(err)
	}

	beego.AddFuncMap("i18n", i18n.Tr)

	beego.Run()
}

func init() {
	//orm.RegisterDataBase("default", "mysql", "[email protected]/gotalk?charset=utf8", 30)
	beego.AppConfigPath = "../conf/app.conf"
	beego.ParseConfig()
	setting.ReadConfig()
	orm.RunSyncdb("default", true, false)
}

/**
* 同步数据库
 */
func Syncdb() {

	createdb()
	Connect()
	o = orm.NewOrm()

	// 数据库别名
	name := "default"
	// drop table 后再建表
	force := true
	// 打印执行过程
	verbose := true
	// 遇到错误立即返回

	err := orm.RunSyncdb(name, force, verbose)
	if err != nil {
		fmt.Println(err)
	}
	insertUser()
	insertCategory()
	insertShop()
	insertFood()
	//insertNodes()
	fmt.Println("database init is complete.\nPlease restart the application")

}

func init() {
	//For version 1.6
	//orm.DRMySQL
	//orm.DRSqlite
	//orm.DRPostgres

	// < 1.6
	//orm.DR_MySQL
	//orm.DR_Sqlite
	//orm.DR_Postgres

	// 参数1   driverName
	// 参数2   数据库类型
	// 这个用来设置 driverName 对应的数据库类型
	// mysql / sqlite3 / postgres 这三种是默认已经注册过的，所以可以无需设置
	orm.RegisterDriver("mysql", orm.DRMySQL)

	// 参数1        数据库的别名，用来在ORM中切换数据库使用
	// 参数2        driverName
	// 参数3        对应的链接字符串
	orm.RegisterDataBase("default", "mysql", "root:[email protected]/sport_collage?charset=utf8")

	// 参数4(可选)  设置最大空闲连接
	// 参数5(可选)  设置最大数据库连接 (go >= 1.2)
	//maxIdle := 30
	//maxConn := 30
	//orm.RegisterDataBase("default", "mysql", "root:[email protected]/orm_test?charset=utf8", maxIdle, maxConn)
	orm.RunSyncdb("default", false, false)
}

func main() {
	err := orm.RunSyncdb("default", false, false)
	if err != nil {
		beego.Error(err)
	}
	beego.Run()
}

func main() {
	// 开启 ORM 调试模式
	orm.Debug = true
	// 自动建表
	orm.RunSyncdb("default", false, true)

	// o := orm.NewOrm()
	// //o.Using("default")

	// var user models.User
	// user.Id = 1
	// user.Name = "admin"
	// user.Age = 20

	// var user_conn models.UserConn
	// user_conn.Id = 1
	// user_conn.Phone = "023-1231123"
	// user_conn.Mobile = "12312312312"
	// user_conn.Email = "[email protected]"
	// user_conn.User = &user

	// fmt.Println(o.Insert(&user))
	// fmt.Println(o.Insert(&user_conn))

	beego.Run()
}

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 main() {

	//初始化
	initialize()

	beego.Info(beego.AppName, APP_VER)

	if !controllers.IsPro {
		beego.SetStaticPath("/static_source", "static_source")
		beego.DirectoryIndex = true
	}

	// 开启 ORM 调试模式
	orm.Debug = true
	// 自动建表
	orm.RunSyncdb("default", false, true)

	beego.Router("/", &controllers.MainController{})
	beego.Router("/user/reg", &controllers.UserController{}, "post:reg")

	// Register template functions.
	beego.AddFuncMap("i18n", i18n.Tr)

	beego.Run()
}