1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283 |
- package repository
- import (
- "context"
- "fmt"
- "github.com/go-nunu/nunu-layout-advanced/pkg/log"
- "github.com/go-nunu/nunu-layout-advanced/pkg/zapgorm2"
- "github.com/redis/go-redis/v9"
- "github.com/spf13/viper"
- "gorm.io/driver/mysql"
- "gorm.io/gorm"
- "time"
- )
- const ctxTxKey = "TxKey"
- type Repository struct {
- db *gorm.DB
- rdb *redis.Client
- logger *log.Logger
- }
- func NewRepository(db *gorm.DB, rdb *redis.Client, logger *log.Logger) *Repository {
- return &Repository{
- db: db,
- rdb: rdb,
- logger: logger,
- }
- }
- type Transaction interface {
- Transaction(ctx context.Context, fn func(ctx context.Context) error) error
- }
- func NewTransaction(r *Repository) Transaction {
- return r
- }
- // DB return tx
- // If you need to create a Transaction, you must call DB(ctx) and Transaction(ctx,fn)
- func (r *Repository) DB(ctx context.Context) *gorm.DB {
- v := ctx.Value(ctxTxKey)
- if v != nil {
- if tx, ok := v.(*gorm.DB); ok {
- return tx
- }
- }
- return r.db.WithContext(ctx)
- }
- func (r *Repository) Transaction(ctx context.Context, fn func(ctx context.Context) error) error {
- return r.db.WithContext(ctx).Transaction(func(tx *gorm.DB) error {
- ctx = context.WithValue(ctx, ctxTxKey, tx)
- return fn(ctx)
- })
- }
- func NewDB(conf *viper.Viper, l *log.Logger) *gorm.DB {
- logger := zapgorm2.New(l.Logger)
- db, err := gorm.Open(mysql.Open(conf.GetString("data.mysql.user")), &gorm.Config{Logger: logger})
- if err != nil {
- panic(err)
- }
- db = db.Debug()
- return db
- }
- func NewRedis(conf *viper.Viper) *redis.Client {
- rdb := redis.NewClient(&redis.Options{
- Addr: conf.GetString("data.redis.addr"),
- Password: conf.GetString("data.redis.password"),
- DB: conf.GetInt("data.redis.db"),
- })
- ctx, cancel := context.WithTimeout(context.Background(), 5*time.Second)
- defer cancel()
- _, err := rdb.Ping(ctx).Result()
- if err != nil {
- panic(fmt.Sprintf("redis error: %s", err.Error()))
- }
- return rdb
- }
|