CoolCMS API

Db

Table of Contents

Classes

AdminMenuItemRepository
Abstract ORM repository with dynamic-includes support.
AdminPageRepository
Abstract ORM repository with dynamic-includes support.
ApiClientRepository
External Api clients (`cms_system_api_clients`), their keys (`cms_system_api_client_keys`: several keys per application, optional expiry) and allowed roles (`cms_system_api_client_roles`).
AssetRepository
Abstract ORM repository with dynamic-includes support.
AssetUsageRepository
Image usages (`cms_system_asset_usages`) and their variant assignments (`cms_system_asset_usage_variants`). Assignments are read and written with raw DBAL; writing one set of usages is a single transaction (`DELETE` + `INSERT` of the assignments and `keep_original`), not a collection on the entity.
AssetVariantRepository
Image variants (`cms_system_asset_variants`). CRUD goes through the ORM; the upload plan of all usages and the overview "where is the variant used" are one `JOIN` query through raw DBAL.
AuthLogRepository
Abstract ORM repository with dynamic-includes support.
BlacklistedWordRepository
Abstract ORM repository with dynamic-includes support.
BlacklistRepository
Abstract ORM repository with dynamic-includes support.
CountryRepository
Abstract ORM repository with dynamic-includes support.
CronJobRepository
Cron jobs of the scheduler (`cms_system_cron_jobs`) and the single scheduler state row (`cms_system_cron_scheduler`). Plain DBAL: the scheduler writes small result rows, never whole entities.
CurrencyRepository
Abstract ORM repository with dynamic-includes support.
CustomAssetRepository
Abstract ORM repository with dynamic-includes support.
EmailQueueRepository
Abstract ORM repository with dynamic-includes support.
EmailRepository
Abstract ORM repository with dynamic-includes support.
ExternalConnectionRepository
Abstract ORM repository with dynamic-includes support.
FileRepository
Abstract ORM repository with dynamic-includes support.
GeocodingCacheRepository
`cms_system_geocoding_cache`, raw SQL: reads by `query_hash`, `hits + 1` and an atomic upsert (concurrent saves of the same address must not fail on the `UNIQUE` index).
InvoiceTypeRepository
Abstract ORM repository with dynamic-includes support.
LanguageRepository
Abstract ORM repository with dynamic-includes support.
LocalizationRepository
Abstract ORM repository with dynamic-includes support.
LoginProviderRepository
Abstract ORM repository with dynamic-includes support.
MenuItemRepository
Abstract ORM repository with dynamic-includes support.
MenuRepository
Abstract ORM repository with dynamic-includes support.
NotificationRepository
Abstract ORM repository with dynamic-includes support.
NotificationTypeRepository
Abstract ORM repository with dynamic-includes support.
PageRepository
Abstract ORM repository with dynamic-includes support.
PageSectionRepository
Abstract ORM repository with dynamic-includes support.
PaymentCallbackRepository
Abstract ORM repository with dynamic-includes support.
PaymentErrorLogRepository
Abstract ORM repository with dynamic-includes support.
PaymentGatePhoneRepository
Abstract ORM repository with dynamic-includes support.
PaymentGateRepository
Abstract ORM repository with dynamic-includes support.
PaymentGatewayNotificationRepository
Owner of the table `cms_system_payment_gateway_notifications`.
PaymentItemRepository
Abstract ORM repository with dynamic-includes support.
PaymentRegionRepository
Abstract ORM repository with dynamic-includes support.
PaymentRepository
Abstract ORM repository with dynamic-includes support.
PaymentStatusRepository
Abstract ORM repository with dynamic-includes support.
PaymentTransactionRepository
Owner of the table `cms_system_payment_transactions`.
PdfTemplateLayoutRepository
Abstract ORM repository with dynamic-includes support.
PdfTemplateRepository
Abstract ORM repository with dynamic-includes support.
PrivilegeGroupRepository
Abstract ORM repository with dynamic-includes support.
ProductTypeRepository
Abstract ORM repository with dynamic-includes support.
RegionRepository
Abstract ORM repository with dynamic-includes support.
RouteRepository
Abstract ORM repository with dynamic-includes support.
SettingRepository
Abstract ORM repository with dynamic-includes support.
SmtpSettingRepository
Abstract ORM repository with dynamic-includes support.
SupplyKindRepository
Abstract ORM repository with dynamic-includes support.
TariffRepository
Abstract ORM repository with dynamic-includes support.
UnitRepository
Abstract ORM repository with dynamic-includes support.
UserDiscountLevelRepository
Abstract ORM repository with dynamic-includes support.
UserExternalLoginRepository
Abstract ORM repository with dynamic-includes support.
UserGroupRepository
Abstract ORM repository with dynamic-includes support.
UserPaymentRepository
Abstract ORM repository with dynamic-includes support.
UserRefreshTokenRepository
Abstract ORM repository with dynamic-includes support.
UserRepository
Abstract ORM repository with dynamic-includes support.
UserRolePrivilegeRepository
Abstract ORM repository with dynamic-includes support.
UserRoleRepository
Abstract ORM repository with dynamic-includes support.
UserTypeRepository
Abstract ORM repository with dynamic-includes support.
VatIdCheckRepository
VAT id checks (`cms_system_vat_id_checks`). Raw DBAL on purpose — the check runs inside a checkout / payment submit while the order graph is being built, where an ORM read would run `UoW::clear()`.
VatRateRepository
VAT rates (`cms_system_vat_rates`). Raw DBAL reads on purpose: the tax engine reads rates in the middle of building an order/payment graph, where an ORM read would run `UoW::clear()`.
VatRepository
Abstract ORM repository with dynamic-includes support.
On this page

Search results