database

type Database interface {
	Reader
	Writer
	Migration
}

type DatabaseParam struct {
	ConnectionStr string
	DatabaseName  string
	MaxLifetime   time.Duration
	MaxIdleConns  int
	MaxOpenConns  int
}

type Migration interface {
	RunSchema(schemas []string, logger *logrus.Logger)
	RebuildIndexes(logger *logrus.Logger)
	Insert(ctx context.Context, query string, args ...interface{}) (int64, bool)
	Query(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)
	Select(ctx context.Context, query string, args ...interface{}) *sql.Row
	Update(ctx context.Context, query string, args ...interface{}) bool
	Delete(ctx context.Context, query string, args ...interface{}) bool
}

type Reader interface {
	Query(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)
	Select(ctx context.Context, query string, args ...interface{}) *sql.Row
}

type Writer interface {
	Insert(ctx context.Context, query string, args ...interface{}) (int64, bool)
	Update(ctx context.Context, query string, args ...interface{}) bool
	Delete(ctx context.Context, query string, args ...interface{}) bool
}