data

package

v0.8.0 Latest Latest Go to latest Published: Mar 28, 2026 License: Apache-2.0 Imports: 5 Imported by: 0

Details

Package data provides data access repositories for lookup tables.

This section is empty.

This section is empty.

This section is empty.

type LookupItem struct {
	ID       int
	Name     string
	ValidID  int
	IsSystem bool
	TypeID   int // For states
}

LookupItem represents a database lookup value.

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

LookupsRepository handles database operations for lookup values.

func NewLookupsRepository(db *sql.DB) *LookupsRepository

NewLookupsRepository creates a new lookups repository.

func (r *LookupsRepository) AddTranslation(ctx context.Context, tableName, fieldValue, lang, translation string, isSystem bool) error

AddTranslation adds a new translation to the database.

func (r *LookupsRepository) GetAllTranslations(ctx context.Context, lang string) (map[string]map[string]string, error)

GetAllTranslations fetches all translations for a specific language.

func (r *LookupsRepository) GetQueues(ctx context.Context) ([]LookupItem, error)

GetQueues fetches all queues from the database.

func (r *LookupsRepository) GetTicketPriorities(ctx context.Context) ([]LookupItem, error)

GetTicketPriorities fetches all ticket priorities from the database.

func (r *LookupsRepository) GetTicketStates(ctx context.Context) ([]LookupItem, error)

GetTicketStates fetches all ticket states from the database.

func (r *LookupsRepository) GetTicketTypes(ctx context.Context) ([]LookupItem, error)

GetTicketTypes fetches all ticket types from the database.

func (r *LookupsRepository) GetTranslation(ctx context.Context, tableName, fieldValue, lang string) (string, error)

GetTranslation fetches a translation from the lookup_translations table.