db.go 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364
  1. package models
  2. import (
  3. "hongze/hongze_task/models/company_approval"
  4. "hongze/hongze_task/models/company_contract"
  5. "hongze/hongze_task/utils"
  6. _ "github.com/go-sql-driver/mysql"
  7. "time"
  8. "rdluck_tools/orm"
  9. )
  10. func init() {
  11. _ = orm.RegisterDataBase("default", "mysql", utils.MYSQL_URL)
  12. orm.SetMaxIdleConns("default", 50)
  13. orm.SetMaxOpenConns("default", 100)
  14. db, _ := orm.GetDB("default")
  15. db.SetConnMaxLifetime(10 * time.Minute)
  16. _ = orm.RegisterDataBase("rddp", "mysql", utils.MYSQL_URL_RDDP)
  17. orm.SetMaxIdleConns("rddp", 50)
  18. orm.SetMaxOpenConns("rddp", 100)
  19. report_db, _ := orm.GetDB("rddp")
  20. report_db.SetConnMaxLifetime(10 * time.Minute)
  21. _ = orm.RegisterDataBase("edb", "mysql", utils.MYSQL_URL_EDB)
  22. orm.SetMaxIdleConns("edb", 50)
  23. orm.SetMaxOpenConns("edb", 100)
  24. edb_db, _ := orm.GetDB("edb")
  25. edb_db.SetConnMaxLifetime(10 * time.Minute)
  26. _ = orm.RegisterDataBase("data", "mysql", utils.MYSQL_URL_DATA)
  27. orm.SetMaxIdleConns("data", 50)
  28. orm.SetMaxOpenConns("data", 100)
  29. data_db, _ := orm.GetDB("data")
  30. data_db.SetConnMaxLifetime(10 * time.Minute)
  31. //注册对象
  32. orm.RegisterModel(
  33. new(EdbinfoSendMsgRecord),
  34. new(Company),
  35. new(CompanyReportPermission),
  36. new(CompanyReportPermissionLog),
  37. new(DataSourceLongzhong),
  38. new(Longzhonginfo),
  39. new(Longzhongdata),
  40. new(EdbdataClassify),
  41. new(Longzhongpriceinfo),
  42. new(Longzhongpricedata),
  43. new(CompanyOperationRecord),
  44. new(CompanyProduct),
  45. new(StackCompanyStatistic),
  46. new(CompanyPermissionLog),
  47. new(company_contract.CompanyContract),
  48. new(company_approval.CompanyApproval),
  49. )
  50. }