orm

Documentation

Index

• Constants
• Variables
• func InitDB(sub string, logger *zap.Logger) *gorm.DB
• func InitDefaultDB(logger *zap.Logger) *gorm.DB
• func InitMysqlViews(tx *gorm.DB, logger *zap.Logger) error
• type CleanupService
  • func (cs *CleanupService) Cleanup(req *DBCleanupReq) error
  • func (cs *CleanupService) GetDefaultRequest() *DBCleanupReq
  • func (cs *CleanupService) RegConnection(name string, db *gorm.DB)
• type DBCleanupReq
• type DBCronJob
  • func (job *DBCronJob) FireJob()
• type HealthController
  • func (h *HealthController) Ping(c *gin.Context)
• type OrmDialector
• type RawQuery
  • func (r *RawQuery) Query(db *gorm.DB, data map[string]interface{}) ([]map[string]interface{}, error)
• type RawQuerySerice
• type SerivceItem

Constants

const (
	KeyInitDB      = ginshared.KeyInitDB
	KeyTablePrefix = "database.tablePrefix"
)

const (
	HealthURIKey   = "healthz"
	HealthURIValue = "/healthz"
)

const ViewMysqlTmp = "CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW %s%s AS %s"

Variables

var DialectorMap = make(map[string]OrmDialector)

Functions

func InitDB

func InitDB(sub string, logger *zap.Logger) *gorm.DB

func InitDefaultDB

func InitDefaultDB(logger *zap.Logger) *gorm.DB

func InitMysqlViews

func InitMysqlViews(tx *gorm.DB, logger *zap.Logger) error

Types

type CleanupService

type CleanupService struct {
	DBMap map[string]*gorm.DB
	// contains filtered or unexported fields
}

func (*CleanupService) Cleanup

func (cs *CleanupService) Cleanup(req *DBCleanupReq) error

func (*CleanupService) GetDefaultRequest

func (cs *CleanupService) GetDefaultRequest() *DBCleanupReq

func (*CleanupService) RegConnection

func (cs *CleanupService) RegConnection(name string, db *gorm.DB)

type DBCleanupReq

type DBCleanupReq struct {
	Cnn          string   //connection name
	Tables       []string //tables to be clean
	DeletedField string   //field name, default is deletedAt
	Duration     string   // only delete DeletedAt <  now - duration
	Batch        int      // batch per deleted
}

type DBCronJob

type DBCronJob struct {
	Name     string
	Schedule string
	Sql      string
	// contains filtered or unexported fields
}

func (*DBCronJob) FireJob

func (job *DBCronJob) FireJob()

type HealthController

type HealthController struct {
	// contains filtered or unexported fields
}

func (*HealthController) Ping

func (h *HealthController) Ping(c *gin.Context)

type OrmDialector

type OrmDialector func(dsn string) gorm.Dialector

type RawQuery

type RawQuery struct {
	Sql    string
	Preset map[string]interface{}
	Params []string
}

func (*RawQuery) Query

func (r *RawQuery) Query(db *gorm.DB, data map[string]interface{}) ([]map[string]interface{}, error)

type RawQuerySerice

type RawQuerySerice struct {
	EnabledAuth bool
	Base        string
	Items       []SerivceItem
	// contains filtered or unexported fields
}

type SerivceItem

type SerivceItem struct {
	Uri   string
	Query RawQuery
}