cwssql

type BaseIdModel struct {
	Id string `gorm:"type:text;primaryKey;default:uuid_generate_v4()"`
}

type BaseJsonBModel struct {
	Attributes JSONB `gorm:"type:jsonb" json:"attributes"`
}

type BaseTimeModel struct {
	CreatedAt time.Time
	UpdatedAt time.Time
}

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

type IRepository[T any] interface {
	GetSession() *DBSession                             // Get the gorm db session
	GetContext() context.Context                        // Get the context
	GetAll(whereClause ...WhereCaluse) ([]*T, error)    // Get entities. Note: GetAll() equals Select all records.
	Get(whereClause ...WhereCaluse) (*T, error)         // Get entity
	Upsert(entity *T) error                             // Create or Replace
	Delete(entity *T) error                             // Delete entity
	DeleteAll(whereClause ...WhereCaluse) ([]*T, error) // Delete entities
	Refresh(entity *T) error                            // Refresh entity
	Count(whereClause ...WhereCaluse) (int64, error)    // Count entities.
	Begin() error                                       // Start a transaction
	Rollback() error                                    // Rollback a transiction
	Commit() error                                      // Commit a transiction
}

type JSONB json.RawMessage

type NewBaseIdModel struct {
	Id string `gorm:"type:text;primaryKey;default:gen_random_uuid()"`
}

type Repository[T any] struct {
	IRepository[T]
	// contains filtered or unexported fields
}

type WhereCaluse map[string][]any