Beispiel #1
0
func initDb() {
	var err error
	Engine, err = xorm.NewEngine("mysql", mysql_dsn)

	if err != nil {
		panic(err.Error()) // proper error handling instead of panic in your app
	}

	tbMapper := core.NewPrefixMapper(core.SnakeMapper{}, "pk_")
	Engine.SetTableMapper(tbMapper)

	Engine.ShowSQL = true   //则会在控制台打印出生成的SQL语句;
	Engine.ShowDebug = true //则会在控制台打印调试信息;
	Engine.ShowErr = true   //则会在控制台打印错误信息;
	Engine.ShowWarn = true  //则会在控制台打印警告信息;

	f, err := os.Create("sql.log")
	if err != nil {
		println("error:")
		println(err.Error())
		return
	}
	defer f.Close()
	Engine.Logger = xorm.NewSimpleLogger(f)
	//	fmt.Println(Engine)
}
Beispiel #2
0
func main() {
	var err error
	engine, err = xorm.NewEngine("mysql", "root:123456@tcp(192.168.1.172:3306)/jc_test")

	if err != nil {
		panic(err.Error()) // proper error handling instead of panic in your app
	}

	tbMapper := core.NewPrefixMapper(core.SnakeMapper{}, "pk_")
	engine.SetTableMapper(tbMapper)

	engine.ShowSQL = true   //则会在控制台打印出生成的SQL语句;
	engine.ShowDebug = true //则会在控制台打印调试信息;
	engine.ShowErr = true   //则会在控制台打印错误信息;
	engine.ShowWarn = true  //则会在控制台打印警告信息;
	fmt.Println(err)
	//	fmt.Println(engine.DBMetas())

	//	sql := "show tables"
	//results, err := engine.Query(sql)
	//fmt.Println(results)
	//fmt.Println(err)

	f, err := os.Create("sql.log")
	if err != nil {
		println(err.Error())
		return
	}
	defer f.Close()
	engine.Logger = xorm.NewSimpleLogger(f)
	var odds_url = "http://odds.500.com/fenxi/yazhi-TTT.shtml"

	a := time.Now().Unix() - 86400
	fmt.Println(a)

	yesday := time.Unix(a, 0).Format("2006-01-02")

	schs := make([]Schedule, 0)
	engine.Distinct("schedule_fid", "schedule_no", "schedule_date").Where("schedule_date = ?", yesday).Find(&schs)
	//fmt.Println(schs)
	for _, sch_info := range schs {
		fmt.Println(sch_info.ScheduleFid)
		fid := fmt.Sprintf("%d", sch_info.ScheduleFid)
		schedule_no := sch_info.ScheduleNo
		schedule_date := sch_info.ScheduleDate
		schedule_odds_url := strings.Replace(odds_url, "TTT", fid, -1)
		fmt.Println(schedule_odds_url)

		res := ParseOddUrl(schedule_odds_url, fid, schedule_no, schedule_date)
		fmt.Println(res)

	}

}
Beispiel #3
0
func init() {
	var err error
	DB, err = xorm.NewEngine("mysql", "root:1@/chat?charset=utf8")
	if err != nil {
		panic(err)
	}

	tbMapper := core.NewPrefixMapper(core.SnakeMapper{}, "t_")
	DB.SetTableMapper(tbMapper)

	DB.SetColumnMapper(core.SameMapper{})

	DB.SetMaxOpenConns(10)
}
Beispiel #4
0
func EngineForCfg(cfg *MysqlConfig) (engine *xorm.Engine, err error) {
	dataSourceName := fmt.Sprintf("%s:%s@tcp(%s:%d)/%s?charset=utf8", cfg.Username, cfg.Password, cfg.Host, cfg.Port, cfg.DbName)
	engine, err1 := xorm.NewEngine("mysql", dataSourceName)
	if err1 != nil {
		err = err1
		return
	}

	tbMapper := core.NewPrefixMapper(core.SnakeMapper{}, "t_")
	engine.SetTableMapper(tbMapper)
	engine.SetColumnMapper(core.SameMapper{})
	engine.ShowSQL = cfg.ShowSql
	engine.ShowDebug = cfg.ShowDebug
	engine.ShowErr = cfg.ShowErr
	engine.ShowWarn = cfg.ShowWarn
	err = engine.Ping()
	return
}
Beispiel #5
0
Datei: conf.go Projekt: ohko/gmdd
func init() {
	// read configure
	Conf = ReadConf()

	// setup xorm
	var err error
	if DB, err = xorm.NewEngine(Conf["DB"], Conf["DSN"]); err != nil {
		panic(err.Error())
	}

	// set table prefix
	tbMapper := core.NewPrefixMapper(core.SnakeMapper{}, Conf["PREFIX"])
	DB.SetTableMapper(tbMapper)

	// record sql
	DB.ShowSQL = true
	f, err := os.Create("sql.log")
	if err != nil {
		panic(err.Error())
	}
	DB.Logger = xorm.NewSimpleLogger(f)
}
Beispiel #6
0
var InitDB func() = func() {
	driver, spec := driverInfoFromConfig()
	var err error
	Db, err = sql.Open(driver, spec)
	if err != nil {
		log.Fatal("SQL Open failed:", err)
	}

	app.Engine, err = xorm.NewEngine(driver, spec)
	if err != nil {
		log.Fatal("NewEngine failed:", err)
	}
	app.Engine.ShowSQL = true // revel.Config.BoolDefault("db.show_sql", true)
	app.Engine.ShowDebug = true

	app.Engine.SetTableMapper(core.NewPrefixMapper(core.SnakeMapper{}, "t_"))
	app.Engine.DropTables("t_user")

	err = app.Engine.Sync2(new(entity.User), new(entity.UserRole), new(entity.UserLevel),
		new(entity.Location), new(entity.UserDetail), new(entity.UserItem))
	if err != nil {
		log.Fatal("Sync2 with error:", err)
	}

	// do init
	tryInitData()
}

func tryInitData() {
	total, err := app.Engine.Count(&entity.User{})
	if total > 0 && err == nil {
Beispiel #7
0
//初始化模塊
func Initialize() {
	driver, ok := revel.Config.String("database.driver")
	if !ok {

		panic("database.driver ( app.conf )	not configure")
	}
	str, ok := revel.Config.String("database.str")
	if !ok {
		panic("database.str ( app.conf )	not configure")
	}

	var err error
	g_engine, err = xorm.NewEngine(driver, str)
	if err != nil {
		panic(err)
	}

	//打開 日誌 默認為 false
	//g_engine.ShowSQL = true //在控制台打印生成的 sql

	//設置 表名 前綴 後綴
	prefix, ok := revel.Config.String("database.prefix")
	if !ok {
		prefix = "cerberus_"
	}
	g_prefix = prefix
	suffix, ok := revel.Config.String("database.suffix")
	if !ok {
		suffix = "_test"
	}
	g_suffix = suffix

	var mapper core.IMapper
	mapper = core.NewPrefixMapper(core.SnakeMapper{}, prefix)
	mapper = core.NewSuffixMapper(mapper, suffix)
	g_engine.SetTableMapper(mapper)

	//初始化 數據庫 表
	session := g_engine.NewSession()
	defer func() {
		//捕獲異常
		if err := recover(); err != nil {
			session.Rollback()
			session.Close()
			//關閉 數據庫 連接
			g_engine.Close()
			g_engine = nil
			panic(err)
		} else {
			session.Commit()
			session.Close()
		}
	}()

	//初始化表
	/*user := &data.User{}
	if ok, err = session.IsTableExist(user); !ok {
		if err = session.CreateTable(user); err != nil {
			panic(err)
		}
		if err = session.CreateUniques(user); err != nil {
			panic(err)
		}
	}*/
}