ilDBConstants Class Reference

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Collaboration diagram for ilDBConstants:

Static Public Member Functions
static	getInstallableTypes ()
static	getAvailableTypes (bool $with_descriptions=true)
static	getSupportedTypes ()
static	getAvailableCollations ()
static	describe (string $type)

Data Fields
const	FETCHMODE_ASSOC = 2
const	FETCHMODE_OBJECT = 3
const	FETCHMODE_DEFAULT = self::FETCHMODE_ASSOC
const	TYPE_INNODB = 'innodb'
const	TYPE_MYSQL = 'mysql'
const	TYPE_GALERA = 'galera'
const	TYPE_MYSQLI = 'mysqli'
const	TYPE_PDO_MYSQL_INNODB = 'pdo-mysql-innodb'
const	TYPE_PDO_MYSQL_GALERA = 'pdo-mysql-galera'
const	LOCK_WRITE = ilAtomQuery::LOCK_WRITE
const	LOCK_READ = ilAtomQuery::LOCK_READ
const	MODULE_MANAGER = 'Manager'
const	MODULE_REVERSE = 'Reverse'
const	INDEX_FORMAT = ilDBPdoFieldDefinition::INDEX_FORMAT
const	SEQUENCE_FORMAT = ilDBPdoFieldDefinition::SEQUENCE_FORMAT
const	SEQUENCE_COLUMNS_NAME = ilDBPdoFieldDefinition::SEQUENCE_COLUMNS_NAME
const	T_CLOB = ilDBPdoFieldDefinition::T_CLOB
const	T_DATE = ilDBPdoFieldDefinition::T_DATE
const	T_DATETIME = ilDBPdoFieldDefinition::T_DATETIME
const	T_FLOAT = ilDBPdoFieldDefinition::T_FLOAT
const	T_INTEGER = ilDBPdoFieldDefinition::T_INTEGER
const	T_TEXT = ilDBPdoFieldDefinition::T_TEXT
const	T_TIME = ilDBPdoFieldDefinition::T_TIME
const	T_TIMESTAMP = ilDBPdoFieldDefinition::T_TIMESTAMP
const	T_BLOB = ilDBPdoFieldDefinition::T_BLOB
const	MYSQL_ENGINE_INNODB = 'InnoDB'
const	MYSQL_CHARACTER_UTF8 = 'utf8'
const	MYSQL_CHARACTER_UTF8MB4 = 'utf8mb4'
const	MYSQL_COLLATION_UTF8 = 'utf8_general_ci'
const	MYSQL_COLLATION_UTF8MB4 = 'utf8mb4_general_ci'
const	MYSQL_COLLATION_UTF8_CZECH = "utf8_czech_ci"
const	MYSQL_COLLATION_UTF8_DANISH = "utf8_danish_ci"
const	MYSQL_COLLATION_UTF8_ESTONIAN = "utf8_estonian_ci"
const	MYSQL_COLLATION_UTF8_ICELANDIC = "utf8_icelandic_ci"
const	MYSQL_COLLATION_UTF8_LATVIAN = "utf8_latvian_ci"
const	MYSQL_COLLATION_UTF8_LITHUANIAN = "utf8_lithuanian_ci"
const	MYSQL_COLLATION_UTF8_PERSIAN = "utf8_persian_ci"
const	MYSQL_COLLATION_UTF8_POLISH = "utf8_polish_ci"
const	MYSQL_COLLATION_UTF8_ROMAN = "utf8_roman_ci"
const	MYSQL_COLLATION_UTF8_ROMANIAN = "utf8_romanian_ci"
const	MYSQL_COLLATION_UTF8_SLOVAK = "utf8_slovak_ci"
const	MYSQL_COLLATION_UTF8_SLOVENIAN = "utf8_slovenian_ci"
const	MYSQL_COLLATION_UTF8_SPANISH2 = "utf8_spanish2_ci"
const	MYSQL_COLLATION_UTF8_SPANISH = "utf8_spanish_ci"
const	MYSQL_COLLATION_UTF8_SWEDISH = "utf8_swedish_ci"
const	MYSQL_COLLATION_UTF8_TURKISH = "utf8_turkish_ci"
const	AUTOQUERY_INSERT = 1
const	AUTOQUERY_UPDATE = 2
const	AUTOQUERY_DELETE = 3
const	AUTOQUERY_SELECT = 4
const	PREPARE_MANIP = false
const	MB4_REPLACEMENT = "?"

Static Protected Attributes
static array	$descriptions

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning Class ilDBConstants

Author

Fabian Schmid fs@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch

Definition at line 26 of file class.ilDBConstants.php.

Member Function Documentation

describe()

static ilDBConstants::describe ( string  $type )

static

Definition at line 173 of file class.ilDBConstants.php.

References $type.

                                                 : string
    {
        return self::$descriptions[$type];
    }

getAvailableCollations()

static ilDBConstants::getAvailableCollations ( )

static

Returns

string[]

Definition at line 149 of file class.ilDBConstants.php.

References MYSQL_COLLATION_UTF8, MYSQL_COLLATION_UTF8_CZECH, MYSQL_COLLATION_UTF8_DANISH, MYSQL_COLLATION_UTF8_ESTONIAN, MYSQL_COLLATION_UTF8_ICELANDIC, MYSQL_COLLATION_UTF8_LATVIAN, MYSQL_COLLATION_UTF8_LITHUANIAN, MYSQL_COLLATION_UTF8_PERSIAN, MYSQL_COLLATION_UTF8_POLISH, MYSQL_COLLATION_UTF8_ROMAN, MYSQL_COLLATION_UTF8_ROMANIAN, MYSQL_COLLATION_UTF8_SLOVAK, MYSQL_COLLATION_UTF8_SLOVENIAN, MYSQL_COLLATION_UTF8_SPANISH, MYSQL_COLLATION_UTF8_SPANISH2, MYSQL_COLLATION_UTF8_SWEDISH, MYSQL_COLLATION_UTF8_TURKISH, and MYSQL_COLLATION_UTF8MB4.

Referenced by ilDatabaseSetupConfig\__construct().

                                                   : array
    {
        return [
            ilDBConstants::MYSQL_COLLATION_UTF8,
            ilDBConstants::MYSQL_COLLATION_UTF8MB4,
            ilDBConstants::MYSQL_COLLATION_UTF8_CZECH,
            ilDBConstants::MYSQL_COLLATION_UTF8_DANISH,
            ilDBConstants::MYSQL_COLLATION_UTF8_ESTONIAN,
            ilDBConstants::MYSQL_COLLATION_UTF8_ICELANDIC,
            ilDBConstants::MYSQL_COLLATION_UTF8_LATVIAN,
            ilDBConstants::MYSQL_COLLATION_UTF8_LITHUANIAN,
            ilDBConstants::MYSQL_COLLATION_UTF8_PERSIAN,
            ilDBConstants::MYSQL_COLLATION_UTF8_POLISH,
            ilDBConstants::MYSQL_COLLATION_UTF8_ROMAN,
            ilDBConstants::MYSQL_COLLATION_UTF8_ROMANIAN,
            ilDBConstants::MYSQL_COLLATION_UTF8_SLOVAK,
            ilDBConstants::MYSQL_COLLATION_UTF8_SLOVENIAN,
            ilDBConstants::MYSQL_COLLATION_UTF8_SPANISH2,
            ilDBConstants::MYSQL_COLLATION_UTF8_SPANISH,
            ilDBConstants::MYSQL_COLLATION_UTF8_SWEDISH,
            ilDBConstants::MYSQL_COLLATION_UTF8_TURKISH
        ];
    }

Here is the caller graph for this function:

getAvailableTypes()

static ilDBConstants::getAvailableTypes ( bool  $with_descriptions = true )

static

Definition at line 122 of file class.ilDBConstants.php.

References $type.

                                                                            : array
    {
        $types = self::getSupportedTypes();
        if ($with_descriptions) {
            $return = array();
            foreach ($types as $type) {
                $return [$type] = self::describe($type);
            }
            $types = $return;
        }

        return $types;
    }

getInstallableTypes()

static ilDBConstants::getInstallableTypes ( )

static

Returns

string[]

Definition at line 110 of file class.ilDBConstants.php.

References TYPE_GALERA, TYPE_INNODB, and TYPE_MYSQL.

Referenced by ilDatabaseSetupConfig\__construct().

                                                : array
    {
        return array(
            // Main
            ilDBConstants::TYPE_MYSQL,
            ilDBConstants::TYPE_INNODB,
            // Experimental
            ilDBConstants::TYPE_GALERA,
            ilDBConstants::TYPE_GALERA,
        );
    }

Here is the caller graph for this function:

getSupportedTypes()

static ilDBConstants::getSupportedTypes ( )

static

Definition at line 137 of file class.ilDBConstants.php.

References TYPE_GALERA, TYPE_INNODB, and TYPE_MYSQL.

                                              : array
    {
        return array(
            ilDBConstants::TYPE_MYSQL,
            ilDBConstants::TYPE_INNODB,
            ilDBConstants::TYPE_GALERA,
        );
    }

Field Documentation

$descriptions

array ilDBConstants::$descriptions

staticprotected

Initial value:

= array(
        
        ilDBConstants::TYPE_MYSQL => "MySQL 5.7.x or higher with InnoDB-Engine",
        ilDBConstants::TYPE_MYSQLI => "MySQL 5.7.x or higher with InnoDB-Engine",
        ilDBConstants::TYPE_INNODB => "MySQL 5.7.x or higher with InnoDB-Engine",
        ilDBConstants::TYPE_GALERA => "Galera-Cluster (experimental)",
        
        ilDBConstants::TYPE_PDO_MYSQL_GALERA => "Galera-Cluster (experimental) [developers-identifier]",
    )

Definition at line 96 of file class.ilDBConstants.php.

AUTOQUERY_DELETE

const ilDBConstants::AUTOQUERY_DELETE = 3

Definition at line 88 of file class.ilDBConstants.php.

AUTOQUERY_INSERT

const ilDBConstants::AUTOQUERY_INSERT = 1

Definition at line 86 of file class.ilDBConstants.php.

AUTOQUERY_SELECT

const ilDBConstants::AUTOQUERY_SELECT = 4

Definition at line 89 of file class.ilDBConstants.php.

AUTOQUERY_UPDATE

const ilDBConstants::AUTOQUERY_UPDATE = 2

Definition at line 87 of file class.ilDBConstants.php.

FETCHMODE_ASSOC

const ilDBConstants::FETCHMODE_ASSOC = 2

Definition at line 28 of file class.ilDBConstants.php.

Referenced by ilObjCourse\__getCrsNonMemberTemplateId(), ilUserXMLWriter\__handleUser(), ilUserDefinedData\__read(), ilObjectDataCache\__storeReference(), ilObjLanguage\_getLastLocalChange(), ilObjLanguageExt\_getModules(), ilStructureObject\_getPresentationTitle(), ilObjLanguageExt\_getValues(), ilContainer\_hasContainerSetting(), ilChangeEvent\_lookupChangeState(), ilContainer\_lookupContainerSetting(), ilPageObject\_lookupContainsDeactivatedElements(), ilObjUserFolder\_lookupNewAccountMail(), ilObjMediaCastAccess\_lookupOnline(), ilObjMediaCastAccess\_lookupPublicFiles(), ilChangeEvent\_lookupUncaughtWriteEvents(), ilObjUserFolder\buildExportFile(), ilNestedSetTree\deleteTree(), ilPDOStatement\fetchAssoc(), ilPDOStatement\fetchRow(), ilUserFilter\filter(), ilADTActiveRecordByType\find(), ilRbacReview\getActiveOperationsOfRole(), ilObjSCORMLearningModule\getAttemptsForUsers(), ilObjUserFolder\getExportSettings(), ilObjectDefinition\getGroupedRepositoryObjectTypes(), ilObjGroup\getGrpStatusClosedTemplateId(), ilObjGroup\getGrpStatusOpenTemplateId(), ilObjectFactory\getInstanceByObjId(), ilObjectFactory\getInstanceByRefId(), ilPageLayout\getLayouts(), ilPageLayout\getLayoutsAsArray(), ilObjLanguage\getLocalChanges(), ilSetupLanguage\getLocalChanges(), ilObjSCORMLearningModule\getModuleVersionForUsers(), ilTree\getNodeTreeData(), ilObjectFactory\getObjectsForOwner(), ilTree\getPathFull(), ilUserXMLWriter\getPictureValue(), ilSoapRBACAdministration\getRoles(), ilDBUpdate\getTableStatus(), ilObjectDefinition\getTranslationType(), ilObjectFactory\getTypeByRefId(), ilBookingReservation\isBookingPoolLimitReachedByUser(), ilLanguage\loadLanguageModule(), ilMemberAgreement\lookupAcceptedAgreements(), ilObjCourse\lookupCourseNonMemberTemplatesId(), ilUserDefinedData\lookupData(), ilObjGroup\lookupGroupStatusTemplateId(), ilTree\moveToTrash(), ilObjectDataCache\preloadReferenceCache(), ilDBPdo\queryCol(), ilDBPdo\queryRow(), ilBookingEntry\read(), ilSecuritySettings\read(), ilPrivacySettings\read(), ilECSSetting\read(), ilAccess\readCache(), ilMaterializedPathTree\validateParentRelations(), and ilNestedSetTree\validateParentRelations().

FETCHMODE_DEFAULT

const ilDBConstants::FETCHMODE_DEFAULT = self::FETCHMODE_ASSOC

Definition at line 30 of file class.ilDBConstants.php.

FETCHMODE_OBJECT

const ilDBConstants::FETCHMODE_OBJECT = 3

Definition at line 29 of file class.ilDBConstants.php.

Referenced by ilCourseObjectiveQuestion\__addTest(), ilCourseObjective\__getLastPosition(), ilTimingAccepted\__read(), ilTimingPlaned\__read(), ilCourseStart\__read(), ilEventItems\__read(), ilLPMarks\__read(), ilSessionFile\__read(), ilCourseObjectiveMaterials\__read(), ilCourseObjective\__read(), ilSessionAppointment\__read(), ilEventParticipants\__read(), ilUserDefinedFields\__read(), ilCourseObjectiveQuestion\__read(), ilObjCourse\__readSettings(), ilTree\__renumber(), ilAdvancedSearch\__searchClassification(), ilMetaDataSearch\__searchContribute(), ilAdvancedSearch\__searchContribute(), ilMetaDataSearch\__searchDescriptions(), ilAdvancedSearch\__searchEducational(), ilAdvancedSearch\__searchEntity(), ilAdvancedSearch\__searchFormat(), ilAdvancedSearch\__searchGeneral(), ilAdvancedSearch\__searchKeyword(), ilMetaDataSearch\__searchKeywords(), ilMDSearch\__searchKeywordsOnly(), ilAdvancedSearch\__searchLanguage(), ilAdvancedSearch\__searchLifecycle(), ilAdvancedSearch\__searchRequirement(), ilAdvancedSearch\__searchRights(), ilTestSearch\__searchSurveyIntroduction(), ilTestSearch\__searchSurveyTitle(), ilAdvancedSearch\__searchTaxon(), ilTestSearch\__searchTestIntroduction(), ilTestSearch\__searchTestTitle(), ilMetaDataSearch\__searchTitles(), ilAdvancedSearch\__searchTypicalAgeRange(), ilObjectDataCache\__storeObjectData(), ilCourseObjectiveResult\__updatePassed(), ilCopyWizardOptions\_allocateCopyId(), ilCourseUserData\_checkRequired(), ilObjUser\_generateRegistrationHash(), ilCourseObjectiveResult\_getAccomplished(), ilAdvancedMDRecord\_getActivatedObjTypes(), ilAdvancedMDRecord\_getActivatedRecordsByObjectType(), ilAdvancedMDRecord\_getActiveSearchableRecords(), ilCourseObjectiveMaterials\_getAllAssignedMaterials(), ilECSExportManager\_getAllEContentIds(), ilAdvancedMDRecord\_getAllRecordsByObjectType(), ilCalendarCategoryAssignments\_getAppointmentCalendars(), ilCalendarCategoryAssignments\_getAssignedAppointments(), ilCourseObjectiveMaterials\_getAssignedMaterials(), ilCalendarCategoryAssignments\_getAutoGeneratedAppointmentsByObjId(), ilLPStatusManual\_getCompleted(), ilLPStatusTestFinished\_getCompleted(), ilLPStatusManualByTutor\_getCompleted(), ilConditionHandler\_getCondition(), ilConditionHandler\_getDistinctTargetRefIds(), ilECSExportManager\_getExportedIDsByServer(), ilLocalUser\_getFolderIds(), ilMDUtilSelect\_getFormatSelect(), ilObjCourseGrouping\_getGroupings(), ilMDLifecycle\_getId(), ilMDRights\_getId(), ilMDMetaMetadata\_getId(), ilMDTechnical\_getId(), ilMDGeneral\_getId(), ilMDEducational\_getId(), ilMDFormat\_getIds(), ilMDEntity\_getIds(), ilMDOrComposite\_getIds(), ilMDIdentifier_\_getIds(), ilMDLocation\_getIds(), ilMDKeyword\_getIds(), ilMDDescription\_getIds(), ilMDIdentifier\_getIds(), ilMDLanguage\_getIds(), ilMDTaxon\_getIds(), ilMDTypicalAgeRange\_getIds(), ilMDAnnotation\_getIds(), ilMDTaxonPath\_getIds(), ilMDContribute\_getIds(), ilMDRelation\_getIds(), ilMDRequirement\_getIds(), ilMDClassification\_getIds(), ilLPStatusTestFinished\_getInProgress(), ilCalendarCategory\_getInstanceByObjId(), ilEventItems\_getItemsOfContainer(), ilItemGroupItems\_getItemsOfContainer(), ilEventItems\_getItemsOfEvent(), ilMDKeyword\_getKeywordsByLanguage(), ilMDKeyword\_getMatchingKeywords(), ilLPStatusTestFinished\_getNotAttempted(), ilCourseObjective\_getObjectiveIds(), ilUtil\_getObjectsByOperations(), ilRbacReview\_getOperationIdByName(), ilEventParticipants\_getParticipated(), ilConditionHandler\_getPersistedConditionsOfTrigger(), ilTimingPlaned\_getPlanedTimings(), ilTimingPlaned\_getPlanedTimingsByItem(), ilAdvancedMDRecord\_getRecords(), ilCalendarRecurrences\_getRecurrences(), ilEventParticipants\_getRegistered(), ilLDAPRoleAssignmentRule\_getRules(), ilSearchSettings\_getSearchSettingRefId(), ilLPStatusObjectives\_getStatusInfo(), ilCourseObjectiveResult\_getSuggested(), ilCourseObjectiveQuestion\_getTest(), ilMDEducational\_getTypicalLearningTimeSeconds(), ilObjUser\_getUserIdsByInactivationPeriod(), ilCourseUserData\_getValuesByObjId(), ilObjCourseGrouping\_getVisibleGroupings(), ilMemberAgreement\_hasAccepted(), ilLPMarks\_hasCompleted(), ilContainerReferenceAccess\_isAccessible(), ilCourseObjectiveQuestion\_isAssigned(), ilECSExportManager\_isExported(), ilEventParticipants\_isRegistered(), ilECSExportManager\_isRemote(), ilParticipants\_isSubscriber(), ilObjCourse\_lookupAboStatus(), ilObjUser\_lookupActive(), ilSessionAppointment\_lookupAppointment(), ilMDContribute\_lookupAuthors(), ilCalendarCategoryAssignments\_lookupCategories(), ilCalendarCategories\_lookupCategoryIdByObjId(), ilLPMarks\_lookupComment(), ilCourseObjective\_lookupContainerIdByObjectiveId(), ilLPObjSettings\_lookupDBMode(), ilLPObjSettings\_lookupDBModeForObjects(), ilMDRights\_lookupDescription(), ilECSImportManager\_lookupEContentId(), ilMDLanguage\_lookupFirstLanguage(), ilLDAPAttributeMapping\_lookupGlobalRole(), ilObjGroup\_lookupIdByTitle(), ilObject\_lookupImportId(), ilLPMarks\_lookupMark(), ilCourseDefinedFieldDefinition\_lookupName(), ilECSImportManager\_lookupObjId(), ilECSImportManager\_lookupObjIds(), ilECSImportManager\_lookupObjIdsByMID(), ilObjRemoteGlossary\_lookupOnline(), ilObjRemoteWiki\_lookupOnline(), ilObjRemoteLearningModule\_lookupOnline(), ilObjRemoteCourse\_lookupOnline(), ilObjRemoteTest\_lookupOnline(), ilObjRemoteGroup\_lookupOnline(), ilRemoteObjectBaseListGUI\_lookupOrganization(), ilObjUser\_lookupPref(), ilAdvancedMDRecord\_lookupRecordIdByImportId(), ilObjSessionAccess\_lookupRegistered(), ilObjSessionAccess\_lookupRegistration(), ilObjSession\_lookupRegistrationEnabled(), ilContainerSortingSettings\_lookupSortMode(), ilContainerReference\_lookupSourceId(), ilContainerReference\_lookupSourceIds(), ilContainerReference\_lookupTargetId(), ilContainerReference\_lookupTargetRefId(), ilContainerReference\_lookupTargetTitle(), ilContainerReference\_lookupTitle(), ilAdvancedMDRecord\_lookupTitle(), ilObjCourseAccess\_lookupViewMode(), ilObjCourse\_lookupViewMode(), ilLPObjSettings\_lookupVisits(), ilSessionAppointment\_readAppointmentsBySession(), ilCourseObjectiveResult\_readAssignedObjectives(), ilCourseObjectiveResult\_readAssignedObjectivesOfQuestion(), ilMemberAgreement\_readByObjId(), ilSessionFile\_readFilesByEvent(), ilContainerSortingSettings\_readSortMode(), ilObjGroupAccess\_registrationEnabled(), ilObjCourseAccess\_registrationEnabled(), ilMDKeyword\_searchKeywords(), ilUtil\_sortIds(), ilCourseObjectiveResult\_updateObjectiveStatus(), ilExportOptions\addOption(), ilCalendarCategories\addSubitemCalendars(), ilExportOptions\allocateExportId(), ilDidacticTemplateCopier\appendCopyInfo(), ilCopyWizardOptions\appendMapping(), ilRbacAdmin\assignUserLimited(), ilRbacSystem\checkAccessOfUser(), ilSCTreeTasks\checkDuplicates(), ilContainerSorting\cloneSorting(), ilRbacAdmin\copyRolePermissionIntersection(), ilObjRole\createDefaultRole(), ilLPCollectionOfRepositoryObjects\createNewGrouping(), ilObjRole\createPermissionIntersection(), ilFileDataMail\deassignAttachmentFromDirectory(), ilCourseObjectiveQuestion\delete(), ilUserSearchCache\deleteCachedEntries(), ilSCTreeTasks\deleteDuplicate(), ilSCTreeTasks\deleteMissingTreeEntry(), ilSoapLearningProgressAdministration\deleteScorm2004Tracking(), ilShibbolethRoleAssignmentRules\doAssignments(), ilWebLinkDatabaseRepository\doesListExist(), ilWebLinkDatabaseRepository\doesOnlyOneItemExist(), ilECSCourseMappingRule\doMappings(), ilRemoteObjectBase\doRead(), ilValidator\dumpTree(), ilECSRemoteUserRepository\exists(), ilPDOStatement\fetchObject(), ilPDOStatement\fetchRow(), ilAuthProviderLTI\findAuthKeyId(), ilAuthProviderLTI\findAuthPrefix(), ilConsultationHourUtils\findCalendarAppointmentsForBooking(), ilSCTreeTasks\findDeepestDuplicate(), ilECSCmsData\findDeletedNodes(), ilValidator\findDeletedObjects(), ilSCTreeTasks\findDuplicates(), ilAuthProviderLTI\findGlobalRole(), ilValidator\findInvalidChilds(), ilValidator\findInvalidRBACEntries(), ilValidator\findInvalidReferences(), ilValidator\findInvalidRolefolders(), ilValidator\findMissingObjects(), ilTreeTrashQueries\findRepositoryLocationForDeletedNode(), ilValidator\findUnboundObjects(), ilCalendarSharedStatus\getAcceptedCalendars(), ilDidacticTemplateActionFactory\getActionsByTemplateId(), ilAuthProviderLTI\getActiveAuthModes(), ilECSCategoryMapping\getActiveRules(), ilMailingLists\getAll(), ilECSImportManager\getAllImportedRemoteObjects(), ilWebLinkDatabaseRepository\getAllItemsAsContainer(), ilLDAPRoleAssignmentRules\getAllPossibleRoles(), ilForumTopic\getAllPostIds(), ilConsultationHourAppointments\getAppointmentIds(), ilConsultationHourAppointments\getAppointmentIdsByGroup(), ilRbacReview\getAssignableRolesInSubtree(), ilMailingList\getAssignedEntries(), ilDidacticTemplateObjSettings\getAssignmentsByTemplateID(), ilLDAPRoleAssignmentRules\getAssignmentsForCreation(), ilDidacticTemplateObjSettings\getAssignmentsForTemplates(), ilLDAPRoleAssignmentRules\getAssignmentsForUpdate(), ilLDAPRoleAssignmentRules\getAttributeNames(), ilAuthProviderLTI\getAuthModes(), ilECSParticipantSettings\getAvailabeMids(), ilLDAPServer\getAvailableDataSources(), ilCalendarSchedule\getChangedEvents(), ilTree\getChildIds(), ilSCTreeTasks\getChilds(), ilConsultationHourGroups\getCountGroupsOfUser(), ilShibbolethRoleAssignmentRules\getCountRules(), ilMDCopyrightUsageTableGUI\getCountSubItemsFromDB(), ilLDAPServer\getDataSource(), ilECSRemoteUserRepository\getECSRemoteUserById(), ilECSRemoteUserRepository\getECSRemoteUserByRemoteId(), ilECSRemoteUserRepository\getECSRemoteUserByUsrId(), ilCalendarSchedule\getEvents(), ilEventItems\getEventsForItemOrderedByStartingTime(), ilCalendarRecurrenceExclusions\getExclusionDates(), ilSessionControl\getExistingSessionCount(), ilECSParticipantSettingsRepository\getExportableParticipants(), ilECSExportManager\getExportedIds(), ilECSExportManager\getExportedIdsByType(), ilECSExportManager\getExportServerIds(), ilLTIDataConnector\getGlobalToolConsumerSettings(), ilLPCollectionOfRepositoryObjects\getGroupedItemsForLPStatus(), ilLPCollectionOfRepositoryObjects\getGroupingIds(), ilObjGroup\getGroupMemberData(), ilConsultationHourGroups\getGroupsOfUser(), ilECSCourseMappingRule\getInstanceByAttribute(), ilLPStatusSurveyFinished\getInvitations(), ilWebLinkDatabaseRepository\getItemByLinkId(), ilCourseLMHistory\getLastLM(), ilRoleAutoComplete\getList(), ilWebLinkDatabaseRepository\getList(), ilRoleAutoComplete\getListByObject(), ilCourseLMHistory\getLMHistory(), ilAdvancedMDFieldDefinitionInternalLink\getLuceneSearchString(), ilSCTreeTasks\getNodeInfo(), ilParticipants\getNotificationRecipients(), ilRbacReview\getNumberOfAssignedUsers(), ilConditionHandler\getNumberOfConditionsOfTrigger(), ilRbacReview\getObjectReferenceOfRole(), ilRbacReview\getObjectsWithStopedInheritance(), ilRbacReview\getOperationsByTypeAndClass(), ilRbacReview\getOperationsOnTypeString(), ilMDOrComposite\getOrCompositeId(), ilWebLinkDatabaseRepository\getParameterinItemByParamId(), ilWebLinkDatabaseRepository\getParametersByLinkId(), ilRbacReview\getRoleFolderOfRole(), ilECSCourseMappingRule\getRuleRefIds(), ilECSCourseMappingRule\getRulesOfRefId(), ilLOTestRun\getRun(), ilLDAPServer\getServerIds(), ilECSParticipantSettingsRepository\getServersContaingExports(), ilCalendarShared\getSharedCalendarsForUser(), ilDclIliasReferenceRecordFieldModel\getStatus(), ilNestedSetTree\getSubTreeIds(), ilNestedSetTree\getSubtreeInfo(), ilLPCollectionOfRepositoryObjects\getTableGUItemGroup(), ilCourseObjectiveQuestion\getTests(), ilObjWorkspaceRootFolder\getTranslations(), ilObjRootFolder\getTranslations(), ilObjOrgUnit\getTranslations(), ilTreeTrashQueries\getTrashedNodesForContainerUsingRecursion(), ilTreeTrashQueries\getTrashedNodeTypesForContainer(), ilTreeTrashQueries\getTrashNodeForContainer(), ilRbacReview\getTypeId(), ilECSTaskScheduler\handleDeprecatedAccounts(), ilCourseObjectiveResult\hasAccomplishedObjective(), ilECSParticipantConsents\hasConsents(), ilBookingEntry\hasObjectBookingEntries(), ilLOUserResults\hasResults(), ilLDAPRoleAssignmentRule\hasRulesForUpdate(), ilCourseObjective\ilClone(), ilAdvancedMDFieldDefinitionSelect\import(), ilCalendarUtil\initDefaultCalendarByType(), ilCourseObjectiveMaterials\isAssigned(), ilRbacReview\isBlockedAtPosition(), ilRbacReview\isBlockedInUpperContext(), ilBookingEntry\isBookable(), ilRepositoryExplorer\isClickable(), ilLDAPServer\isDataSourceActive(), ilRbacReview\isDeleted(), ilSurveyLP\isLPMember(), ilECSCourseMappingRule\isMatching(), ilRepositoryExplorerGUI\isNodeClickable(), ilLOSettings\isObjectiveTest(), ilRbacReview\isProtected(), ilCalendarShared\isSharedWithUser(), ilParticipants\isSubscriber(), ilTreeTrashQueries\isTrashedTrash(), ilECSNodeMappingAssignments\isWholeTreeMapped(), ilSessionControl\kickFirstRequestAbidencer(), ilSessionControl\kickOneMinIdleSession(), ilLTIDataConnector\loadGlobalToolConsumerSettings(), ilLTIDataConnector\loadUserResult(), ilDBGenerator\lookupAbstractedTables(), ilOrgUnitObjectPositionSetting\lookupActive(), ilCalendarCategory\lookupAppointments(), ilObjSessionListGUI\lookupAssignedMaterials(), ilDidacticTemplateSettings\lookupAssignedObjectTypes(), ilECSCourseMemberAssignment\lookupAssignment(), ilECSNodeMappingAssignments\lookupAssignmentIds(), ilECSNodeMappingAssignments\lookupAssignmentsByRefId(), ilCalendarAuthenticationToken\lookupAuthToken(), ilBookingEntry\lookupBookableUsersForObject(), ilBookingEntry\lookupBookingMessage(), ilBookingEntry\lookupBookingsForObject(), ilBookingEntry\lookupBookingsOfUser(), ilECSCmsData\lookupCmsIds(), ilECSCmsData\lookupCmsIdsOfTree(), ilECSParticipantSettings\lookupCmsMid(), ilSCGroup\lookupComponent(), ilLOTestAssignments\lookupContainerForTest(), ilECSImportManager\lookupContentId(), ilECSNodeMappingAssignments\lookupDefaultTitleUpdate(), ilECSImportManager\lookupEContentIdByContentId(), ilObjectCustomUserFieldHistory\lookupEntriesByObjectId(), ilSession\lookupExpireTime(), ilECSCmsData\lookupFirstTreeOfNode(), ilSCGroups\lookupGroupByComponentId(), ilSCTasks\lookupGroupId(), ilObjGroup\lookupGroupTye(), ilECSCategoryMapping\lookupHandledCategories(), ilOerHarvesterObjectStatus\lookupHarvested(), ilLanguage\lookupId(), ilSCTasks\lookupIdentifierForTask(), ilMDKeyword\lookupKeywords(), ilObjSCORMTracking\lookupLastAccessTimes(), ilECSCourseMappingRule\lookupLastExistingAttribute(), ilExportFileInfo\lookupLastExport(), ilSessionAppointment\lookupLastSessionByCourse(), ilSCTasks\lookupLastUpdate(), ilLORandomTestQuestionPools\lookupLimit(), ilWaitingList\lookupListSize(), ilConsultationHourUtils\lookupManagedUsers(), ilECSNodeMappingAssignments\lookupMappedItemsForRefId(), ilObjUser\lookupMatriculation(), ilLOUtils\lookupMaxAttempts(), ilConsultationHourGroups\lookupMaxBookings(), ilCourseObjective\lookupMaxPasses(), ilObjCourseReference\lookupMemberUpdateEnabled(), ilECSCourseMemberAssignment\lookupMissingAssignmentsOfUser(), ilSessionAppointment\lookupNextSessionByCourse(), ilCalendarCategoryAssignments\lookupNumberOfAssignedAppointments(), ilLORandomTestQuestionPools\lookupObjectiveIdsBySequence(), ilLOTestRun\lookupObjectives(), ilLOTestAssignments\lookupObjectivesForTest(), ilCourseObjectiveQuestion\lookupObjectivesOfQuestion(), ilObjGroup\lookupObjectsByCode(), ilObjCourse\lookupObjectsByCode(), ilECSCmsData\lookupObjId(), ilECSImportManager\lookupObjIdByContentId(), ilOerHarvesterObjectStatus\lookupObjIdByHarvestingId(), ilECSImportManager\lookupObjIdsByContentId(), ilConditionHandler\lookupObligatoryConditionsOfTarget(), ilDidacticTemplateFilterPatternFactory\lookupPatternsByParentId(), ilObjGroupAccess\lookupPeriodInfo(), ilObjCourseAccess\lookupPeriodInfo(), ilConditionHandler\lookupPersistedHiddenStatusByTarget(), ilContainerSorting\lookupPositions(), ilCourseObjectiveQuestion\lookupQuestionsByObjective(), ilLTIDataConnector\lookupRecordIdByGlobalSettingsAndRefId(), ilObjGroupAccess\lookupRegistrationInfo(), ilObjCourseAccess\lookupRegistrationInfo(), ilCalendarCategories\lookupRemoteCalendars(), ilLTIDataConnector\lookupResourcesForAllUsersSinceDate(), ilLTIDataConnector\lookupResourcesForUserObjectRelation(), ilLOUserResults\lookupResult(), ilMDRights\lookupRightsByTypeAndCopyright(), ilECSCmsTree\lookupRootId(), ilLOTestRun\lookupRunExistsForObjective(), ilLORandomTestQuestionPools\lookupSequences(), ilLORandomTestQuestionPools\lookupSequencesByType(), ilECSImportManager\lookupServerId(), ilECSExportManager\lookupServerIds(), ilObjSession\lookupSession(), ilECSNodeMappingAssignments\lookupSettings(), ilObjCourse\lookupShowMembersEnabled(), ilECSCmsData\lookupStatusByCmsId(), ilParticipant\lookupStatusByMembershipRoleType(), ilECSCmsData\lookupStatusByObjId(), ilParticipants\lookupSubscribers(), ilParticipants\lookupSubscribersData(), ilDidacticTemplateObjSettings\lookupTemplateId(), ilObjCourse\lookupTimingMode(), ilConsultationHourGroups\lookupTitle(), ilECSCmsData\lookupTitle(), ilECSCmsData\lookupTopTerm(), ilTree\lookupTrashedObjectTypes(), ilECSCmsData\lookupTreeIds(), ilTree\lookupTreesForNode(), ilCalendarAuthenticationToken\lookupUser(), ilECSCourseMemberAssignment\lookupUserIds(), ilObjGroup\lookupViewMode(), ilCourseObjectiveQuestion\loookupTestLimit(), ILIAS\AdvancedMetaData\Setup\DBUpdateSteps8\migrateData(), ilMediaPoolSearch\performKeywordSearch(), ilLikeUserMultiFieldSearch\performSearch(), ilMediaPoolSearch\performSearch(), ilUserDefinedFieldSearch\performSearch(), ilWikiContentSearch\performSearch(), ilLMContentSearch\performSearch(), ilExerciseSearch\performSearch(), ilGlossaryDefinitionSearch\performSearch(), ilMediaCastSearch\performSearch(), ilForumSearch\performSearch(), ilWebresourceSearch\performSearch(), ilLikeUserOrgUnitSearch\performSearch(), ilUserSearch\performSearch(), ilObjectSearch\performSearch(), ilObjectDataCache\preloadObjectCache(), ilRbacSystem\preloadRbacPaCache(), ilObjectDataCache\preloadTranslations(), ilDBPdo\queryCol(), ilDBPdo\queryRow(), ilRegistrationRoleAccessLimitations\read(), ilLogComponentLevel\read(), ilContainerStartObjects\read(), ilLogComponentLevels\read(), ilSCGroups\read(), ilOrgUnitObjectTypePositionSetting\read(), ilECSUserConsents\read(), ilMDFormat\read(), ilMDEntity\read(), ilSCGroup\read(), ilConsultationHourGroup\read(), ilECSParticipantSettings\read(), ilAdvancedMDRecordTranslations\read(), ilMDIdentifier_\read(), ilMDIdentifier\read(), ilSCTask\read(), ilMDLocation\read(), ilECSDataMappingSettings\read(), ilAdvancedMDRecordScope\read(), ilECSCommunitiesCache\read(), ilMDKeyword\read(), ilDidacticTemplateSettings\read(), ilCalendarRecurrenceExclusion\read(), ilLPCollection\read(), ilObjectCustomUserFieldHistory\read(), ilMDDescription\read(), ilObjCourseReference\read(), ilMDLanguage\read(), ilCalendarRegistration\read(), ilMDTaxon\read(), ilDidacticTemplateAction\read(), ilTimingUser\read(), ilCalendarUserNotification\read(), ilECSCourseAttribute\read(), ilECSExport\read(), ilCalendarAppointmentColors\read(), ilRegistrationRoleAssignments\read(), ilUserFormSettings\read(), ilAdvancedMDFieldTranslations\read(), ilMDAnnotation\read(), ilDidacticTemplateLocalRoleAction\read(), ilMDTypicalAgeRange\read(), ilLOTestAssignment\read(), ilOerHarvesterObjectStatus\read(), ilMDTaxonPath\read(), ilCourseUserData\read(), ilECSDataMappingSetting\read(), ilObject\read(), ilMailingList\read(), ilECSCommunityCache\read(), ilECSImport\read(), ilSCTasks\read(), ilMDContribute\read(), ilMDLifecycle\read(), ilCalendarSharedStatus\read(), ilMDRights\read(), ilExportFileInfo\read(), ilDidacticTemplateFilterPattern\read(), ilMDRelation\read(), ilCalendarAuthenticationToken\read(), ilContainerReference\read(), ilForumTopic\read(), ilMDRequirement\read(), ilMDMetaMetadata\read(), ilLPCollectionOfRepositoryObjects\read(), ilCalendarVisibility\read(), ilExportOptions\read(), ilECSNodeMappingAssignment\read(), ilMDClassification\read(), ilECSCourseAttributes\read(), ilDidacticTemplateBlockRoleAction\read(), ilWaitingList\read(), ilCalendarCategoryAssignments\read(), ilLORandomTestQuestionPools\read(), ilLDAPAttributeMapping\read(), ilCalendarShared\read(), ilLOTestRun\read(), ilBookingEntry\read(), ilAdvancedMDSubstitution\read(), ilObjCourseGrouping\read(), ilContainerSortingSettings\read(), ilShibbolethRoleAssignmentRule\read(), ilLDAPRoleGroupMappingSettings\read(), ilDidacticTemplateLocalPolicyAction\read(), ilMemberAgreement\read(), ilMDTechnical\read(), ilECSCourseMemberAssignment\read(), ilCourseDefinedFieldDefinition\read(), ilCalendarCategory\read(), ilMDGeneral\read(), ilLPObjSettings\read(), ilECSParticipantSetting\read(), ilMDEducational\read(), ilCopyWizardOptions\read(), ilLOSettings\read(), ilCalendarEntry\read(), ilDidacticTemplateSetting\read(), ilContainerSorting\read(), ilUserSearchCache\read(), ilECSCourseMappingRule\read(), ilLDAPRoleAssignmentRule\read(), ilCalendarRecurrence\read(), ilECSEventQueueReader\read(), ilECSCmsData\read(), ilObjSession\read(), ilObjGroup\read(), ilObjectActivation\read(), ilAdvancedMDRecord\read(), ilLDAPServer\read(), ilCalendarCategories\readBookingCalendar(), ilCalendarCategories\readConsultationHoursCalendar(), ilSystemCheckTrash\readDeleted(), ilDidacticTemplateSetting\readEffectiveNodes(), ilDidacticTemplateSettings\readInactive(), ilSCTreeTasks\readMissing(), ilSCTreeTasks\readMissingTreeEntries(), ilParticipants\readParticipantsStatus(), ilParticipant\readParticipantStatus(), ilAdvancedMDRecordObjectOrderings\readPositionsForObject(), ilCalendarCategories\readPrivateCalendars(), ilCalendarCategories\readPublicCalendars(), ilObjLTIAdministration\readReleaseObjects(), ilCalendarCategories\readReposCalendars(), ilCalendarCategories\readSelectedCategories(), ilSystemCheckTrash\readSelectedDeleted(), ilECSServerSettings\readServers(), ilOrgUnitObjectPositionSetting\readSettings(), ilLPStatusCourseReference\readStatusInfo(), ilParticipants\readSubscriberData(), ilParticipants\readSubscribers(), ilLOTestAssignments\readTestAssignments(), ilECSRemoteUserRepository\remoteUserExists(), ilCronDeleteInactiveUserReminderMail\removeEntriesFromTableIfLastLoginIsNewer(), ilTreeImplementationSwitch\renumberNestedSet(), ilSCTreeTasks\repairMissingObject(), ilSCTreeTasks\repairMissingTreeEntries(), ilDidacticTemplateLocalPolicyAction\revertLocalPolicy(), ilRbacReview\roleExists(), ilConsultationHourCron\run(), ilLPCollectionOfRepositoryObjects\saveObligatoryMaterials(), ilAdvancedSearch\searchObjectProperties(), ilCronDeleteInactiveUserReminderMail\sendReminderMailIfNeeded(), ILIAS\AdvancedMetaData\Setup\DBUpdateSteps8\step_3(), ilForumTopicTest\testConstruct(), ilForumTopicTest\testGetAllPostIds(), ilLORandomTestQuestionPools\toXml(), ilDidacticTemplateObjSettings\transferAutoGenerateStatus(), ilECSCmsData\treeExists(), ilECSCmsTree\treeExists(), ilShibbolethRoleAssignmentRules\updateAssignments(), ilParticipant\updateMemberRoles(), ilObjUser\userExists(), ilECSEventQueueReader\writeEventToDB(), and ilLPStatus\writeStatus().

INDEX_FORMAT

const ilDBConstants::INDEX_FORMAT = ilDBPdoFieldDefinition::INDEX_FORMAT

Definition at line 47 of file class.ilDBConstants.php.

LOCK_READ

const ilDBConstants::LOCK_READ = ilAtomQuery::LOCK_READ

Definition at line 42 of file class.ilDBConstants.php.

Referenced by ilMySQLQueryUtils\lock().

LOCK_WRITE

const ilDBConstants::LOCK_WRITE = ilAtomQuery::LOCK_WRITE

Definition at line 41 of file class.ilDBConstants.php.

Referenced by ilMySQLQueryUtils\lock().

MB4_REPLACEMENT

const ilDBConstants::MB4_REPLACEMENT = "?"

Definition at line 92 of file class.ilDBConstants.php.

Referenced by ilDBPdo\sanitizeMB4StringIfNotSupported().

MODULE_MANAGER

const ilDBConstants::MODULE_MANAGER = 'Manager'

Definition at line 44 of file class.ilDBConstants.php.

Referenced by ilDBGenerator\__construct(), ilDBAnalyzer\__construct(), ilDBPdo\dropTable(), ilDBPdo\loadModule(), ilDBPdoMySQL\migrateAllTablesToCollation(), and ilDBPdo\tableColumnExists().

MODULE_REVERSE

const ilDBConstants::MODULE_REVERSE = 'Reverse'

Definition at line 45 of file class.ilDBConstants.php.

Referenced by ilDBGenerator\__construct(), ilDBAnalyzer\__construct(), and ilDBPdo\loadModule().

MYSQL_CHARACTER_UTF8

const ilDBConstants::MYSQL_CHARACTER_UTF8 = 'utf8'

Definition at line 63 of file class.ilDBConstants.php.

MYSQL_CHARACTER_UTF8MB4

const ilDBConstants::MYSQL_CHARACTER_UTF8MB4 = 'utf8mb4'

Definition at line 64 of file class.ilDBConstants.php.

MYSQL_COLLATION_UTF8

const ilDBConstants::MYSQL_COLLATION_UTF8 = 'utf8_general_ci'

Definition at line 66 of file class.ilDBConstants.php.

Referenced by getAvailableCollations().

MYSQL_COLLATION_UTF8_CZECH

const ilDBConstants::MYSQL_COLLATION_UTF8_CZECH = "utf8_czech_ci"

Definition at line 68 of file class.ilDBConstants.php.

Referenced by getAvailableCollations().

MYSQL_COLLATION_UTF8_DANISH

const ilDBConstants::MYSQL_COLLATION_UTF8_DANISH = "utf8_danish_ci"

Definition at line 69 of file class.ilDBConstants.php.

Referenced by getAvailableCollations().

MYSQL_COLLATION_UTF8_ESTONIAN

const ilDBConstants::MYSQL_COLLATION_UTF8_ESTONIAN = "utf8_estonian_ci"

Definition at line 70 of file class.ilDBConstants.php.

Referenced by getAvailableCollations().

MYSQL_COLLATION_UTF8_ICELANDIC

const ilDBConstants::MYSQL_COLLATION_UTF8_ICELANDIC = "utf8_icelandic_ci"

Definition at line 71 of file class.ilDBConstants.php.

Referenced by getAvailableCollations().

MYSQL_COLLATION_UTF8_LATVIAN

const ilDBConstants::MYSQL_COLLATION_UTF8_LATVIAN = "utf8_latvian_ci"

Definition at line 72 of file class.ilDBConstants.php.

Referenced by getAvailableCollations().

MYSQL_COLLATION_UTF8_LITHUANIAN

const ilDBConstants::MYSQL_COLLATION_UTF8_LITHUANIAN = "utf8_lithuanian_ci"

Definition at line 73 of file class.ilDBConstants.php.

Referenced by getAvailableCollations().

MYSQL_COLLATION_UTF8_PERSIAN

const ilDBConstants::MYSQL_COLLATION_UTF8_PERSIAN = "utf8_persian_ci"

Definition at line 74 of file class.ilDBConstants.php.

Referenced by getAvailableCollations().

MYSQL_COLLATION_UTF8_POLISH

const ilDBConstants::MYSQL_COLLATION_UTF8_POLISH = "utf8_polish_ci"

Definition at line 75 of file class.ilDBConstants.php.

Referenced by getAvailableCollations().

MYSQL_COLLATION_UTF8_ROMAN

const ilDBConstants::MYSQL_COLLATION_UTF8_ROMAN = "utf8_roman_ci"

Definition at line 76 of file class.ilDBConstants.php.

Referenced by getAvailableCollations().

MYSQL_COLLATION_UTF8_ROMANIAN

const ilDBConstants::MYSQL_COLLATION_UTF8_ROMANIAN = "utf8_romanian_ci"

Definition at line 77 of file class.ilDBConstants.php.

Referenced by getAvailableCollations().

MYSQL_COLLATION_UTF8_SLOVAK

const ilDBConstants::MYSQL_COLLATION_UTF8_SLOVAK = "utf8_slovak_ci"

Definition at line 78 of file class.ilDBConstants.php.

Referenced by getAvailableCollations().

MYSQL_COLLATION_UTF8_SLOVENIAN

const ilDBConstants::MYSQL_COLLATION_UTF8_SLOVENIAN = "utf8_slovenian_ci"

Definition at line 79 of file class.ilDBConstants.php.

Referenced by getAvailableCollations().

MYSQL_COLLATION_UTF8_SPANISH

const ilDBConstants::MYSQL_COLLATION_UTF8_SPANISH = "utf8_spanish_ci"

Definition at line 81 of file class.ilDBConstants.php.

Referenced by getAvailableCollations().

MYSQL_COLLATION_UTF8_SPANISH2

const ilDBConstants::MYSQL_COLLATION_UTF8_SPANISH2 = "utf8_spanish2_ci"

Definition at line 80 of file class.ilDBConstants.php.

Referenced by getAvailableCollations().

MYSQL_COLLATION_UTF8_SWEDISH

const ilDBConstants::MYSQL_COLLATION_UTF8_SWEDISH = "utf8_swedish_ci"

Definition at line 82 of file class.ilDBConstants.php.

Referenced by getAvailableCollations().

MYSQL_COLLATION_UTF8_TURKISH

const ilDBConstants::MYSQL_COLLATION_UTF8_TURKISH = "utf8_turkish_ci"

Definition at line 83 of file class.ilDBConstants.php.

Referenced by getAvailableCollations().

MYSQL_COLLATION_UTF8MB4

const ilDBConstants::MYSQL_COLLATION_UTF8MB4 = 'utf8mb4_general_ci'

Definition at line 67 of file class.ilDBConstants.php.

Referenced by getAvailableCollations().

MYSQL_ENGINE_INNODB

const ilDBConstants::MYSQL_ENGINE_INNODB = 'InnoDB'

Definition at line 61 of file class.ilDBConstants.php.

Referenced by ILIAS\Setup\ilMysqlMyIsamToInnoDbMigration\getNonInnoDBTables().

PREPARE_MANIP

const ilDBConstants::PREPARE_MANIP = false

Definition at line 90 of file class.ilDBConstants.php.

SEQUENCE_COLUMNS_NAME

const ilDBConstants::SEQUENCE_COLUMNS_NAME = ilDBPdoFieldDefinition::SEQUENCE_COLUMNS_NAME

Definition at line 49 of file class.ilDBConstants.php.

Referenced by ilDBPdoManager\createSequence().

SEQUENCE_FORMAT

const ilDBConstants::SEQUENCE_FORMAT = ilDBPdoFieldDefinition::SEQUENCE_FORMAT

Definition at line 48 of file class.ilDBConstants.php.

Referenced by ilDBPdoManager\fixSequenceName().

T_BLOB

const ilDBConstants::T_BLOB = ilDBPdoFieldDefinition::T_BLOB

Definition at line 59 of file class.ilDBConstants.php.

T_CLOB

const ilDBConstants::T_CLOB = ilDBPdoFieldDefinition::T_CLOB

Definition at line 51 of file class.ilDBConstants.php.

Referenced by ilMySQLQueryUtils\like(), ilSession\lookupExpireTime(), ilMDCopyrightUpdateSteps\step_1(), ilTest8DBUpdateSteps\step_2(), ilMDCopyrightUpdateSteps\step_2(), ilMDCopyrightUpdateSteps\step_3(), ilMDCopyrightUpdateSteps\step_4(), and ilTestQuestionPool80DBUpdateSteps\step_7().

T_DATE

const ilDBConstants::T_DATE = ilDBPdoFieldDefinition::T_DATE

Definition at line 52 of file class.ilDBConstants.php.

Referenced by ilDBPdo\quote().

T_DATETIME

const ilDBConstants::T_DATETIME = ilDBPdoFieldDefinition::T_DATETIME

Definition at line 53 of file class.ilDBConstants.php.

Referenced by ilDBPdo\quote().

T_FLOAT

const ilDBConstants::T_FLOAT = ilDBPdoFieldDefinition::T_FLOAT

Definition at line 54 of file class.ilDBConstants.php.

Referenced by ilDBPdo\quote().

T_INTEGER

const ilDBConstants::T_INTEGER = ilDBPdoFieldDefinition::T_INTEGER

Definition at line 55 of file class.ilDBConstants.php.

Referenced by ILIAS\Mail\Cron\ExpiredOrOrphanedMails\Notifier\__construct(), ilMDDescription\_getIds(), ilMailBoxQuery\_getMailBoxListData(), ilMDCopyrightSelectionEntry\_lookupCopyright(), ilMDCopyrightSelectionEntry\_lookupCopyrightForExport(), ilTreeTrashQueries\appendTrashNodeForContainerQueryFilter(), ilRbacReview\assignedGlobalRoles(), ilADTActiveRecordByType\cloneByPrimary(), ILIAS\Mail\Cron\ExpiredOrOrphanedMails\ExpiredOrOrphanedMailsCollector\collect(), ilObjCourseReference\create(), ilSCGroup\create(), ilSCTask\create(), ilLORandomTestQuestionPools\create(), ilECSParticipantSetting\create(), ilObjSession\create(), ilObjGroup\create(), ilAdvancedMDClaimingPlugin\createDBField(), ILIAS\Notifications\Repository\ilNotificationOSDRepository\createOSDNotification(), ILIAS\Certificate\API\Repository\UserDataRepository\createWhereCondition(), ILIAS\MyStaff\ListCourses\ilMStListCourses\createWhereStatement(), ilECSParticipantConsents\delete(), ilECSUserConsent\delete(), ilAdvancedMDFieldTranslation\delete(), ilAdvancedMDRecordTranslation\delete(), ilLOUserResults\delete(), ilObjCourseReference\delete(), ilMDEducational\delete(), ilMD\deleteAll(), ilMailTemplateRepository\deleteByIds(), ilExportFileInfo\deleteByObjId(), ILIAS\Mail\Cron\ExpiredOrOrphanedMails\MailDeletionHandler\deleteDirectory(), ilSCTreeTasks\deleteDuplicate(), ILIAS\User\Profile\ProfileChangeMailTokenDBRepository\deleteExpiredEntries(), ILIAS\Mail\Cron\ExpiredOrOrphanedMails\MailDeletionHandler\deleteMails(), ILIAS\Mail\Cron\ExpiredOrOrphanedMails\MailDeletionHandler\deleteMarkedAsNotified(), ilSCTreeTasks\deleteMissingTreeEntry(), ilAdvancedMDFieldDefinitionSelect\deleteOptionTranslations(), ILIAS\Notifications\Repository\ilNotificationOSDRepository\deleteOSDNotificationById(), ILIAS\Notifications\Repository\ilNotificationOSDRepository\deleteOSDNotificationByIdentification(), ILIAS\Notifications\Repository\ilNotificationOSDRepository\deleteOSDNotificationByUserAndType(), ILIAS\Notifications\Repository\ilNotificationOSDRepository\deleteStaleOSDNotificationsForUserAndType(), ILIAS\Mail\Cron\ExpiredOrOrphanedMails\MailDeletionHandler\determineDeletableAttachmentPaths(), ilMailTemplateRepository\findById(), ilSCTreeTasks\findDuplicates(), ilTreeTrashQueries\findRepositoryLocationForDeletedNode(), ilDidacticTemplateActionFactory\getActionsByTemplateId(), ilDidacticTemplateObjSettings\getAssignmentsForTemplates(), ilSCTreeTasks\getChilds(), ilMDCopyrightUsageTableGUI\getCountSubItemsFromDB(), ilLPStatusSurveyFinished\getInvitations(), ILIAS\User\Profile\ProfileChangeMailTokenDBRepository\getNewEmailForUser(), ILIAS\User\Profile\ProfileChangeMailTokenDBRepository\getNewTokenForUser(), ilSCTreeTasks\getNodeInfo(), ilParticipants\getNotificationRecipients(), ilConditionHandler\getNumberOfConditionsOfTrigger(), ILIAS\Notifications\Repository\ilNotificationOSDRepository\getOSDNotificationsByUser(), ilAssMultiOptionQuestionFeedback\getSpecificFeedbackContentForFeedbackIds(), ilADTEnumSearchBridgeMulti\getSQLCondition(), ilTreeTrashQueries\getTrashedNodesForContainerUsingRecursion(), ilECSParticipantConsents\hasConsents(), ilBookingEntry\hasObjectBookingEntries(), ILIAS\Notifications\Repository\ilNotificationOSDRepository\ifOSDNotificationExistsById(), ilAdvancedMDFieldDefinitionSelect\import(), ilAdvancedMDFieldTranslation\insert(), ilAdvancedMDRecordTranslation\insert(), ilADTMultiEnumDBBridge\insertIndices(), ilDclFieldTypePlugin\install(), ilRbacReview\isAssigned(), ilRbacReview\isAssignedToAtLeastOneGivenRole(), ilRbacReview\isDeleted(), ilSurveyLP\isLPMember(), ilRbacReview\isProtected(), ilTreeTrashQueries\isTrashedTrash(), ilBookingEntry\lookupBookingsForObject(), ilSCGroup\lookupComponent(), ilMDCopyrightSelectionEntry\lookupCopyyrightTitle(), ilSession\lookupExpireTime(), ilSCTasks\lookupGroupId(), ilSCTasks\lookupIdentifierForTask(), ilSCTasks\lookupLastUpdate(), ilObjCourseReference\lookupMemberUpdateEnabled(), ilDidacticTemplateFilterPatternFactory\lookupPatternsByParentId(), ilObjGroupAccess\lookupPeriodInfo(), ilObjCourseAccess\lookupPeriodInfo(), ilObjGroupAccess\lookupRegistrationInfo(), ilObjCourseAccess\lookupRegistrationInfo(), ilParticipant\lookupStatusByMembershipRoleType(), ilTree\lookupTreesForNode(), ILIAS\AdvancedMetaData\Setup\DBUpdateSteps8\migrate(), ILIAS\AdvancedMetaData\Setup\DBUpdateSteps8\migrateData(), ilMaterializedPathTree\moveTree(), ILIAS\Modules\Test\AccessFileUploadPreview\objectId(), ilADTEnumDBBridge\prepareInsert(), ilDBPdo\quote(), ilECSUserConsents\read(), ilSCGroup\read(), ilAdvancedMDRecordTranslations\read(), ilSCTask\read(), ilObjCourseReference\read(), ilAdvancedMDFieldTranslations\read(), ilDidacticTemplateBlockRoleAction\read(), ilDidacticTemplateLocalPolicyAction\read(), ilAdvancedMDRecord\read(), ilLDAPServer\read(), ilSystemCheckTrash\readSelectedDeleted(), ilLPStatusCourseReference\readStatusInfo(), ilRepUtil\removeDeletedNodes(), ilTreeImplementationSwitch\renumberNestedSet(), ilSCTreeTasks\repairMissingObject(), ilSCTreeTasks\repairMissingTreeEntries(), ilCourseObjectiveResult\reset(), ilECSUserConsent\save(), ilRegistrationRoleAccessLimitations\save(), ilDidacticTemplateBlockRoleAction\save(), ilStartingPoint\save(), ilAdvancedMDFieldDefinitionSelect\saveOptionTranslations(), ilForumCronNotification\sendDeleteNotifications(), ilForumCronNotification\sendNotificationForCensoredPosts(), ilForumCronNotification\sendNotificationForDeletedPosts(), ilForumCronNotification\sendNotificationForDeletedThreads(), ilForumCronNotification\sendNotificationForNewPosts(), ilForumCronNotification\sendNotificationForUncensoredPosts(), ilForumCronNotification\sendNotificationForUpdatedPosts(), ilMDCopyrightMigration\step(), ilECSUpdateSteps8\step_1(), ilDataCollectionDBUpdateSteps\step_12(), ilDataCollectionDBUpdateSteps\step_13(), ilTestQuestionPool80DBUpdateSteps\step_2(), ilUser8DBUpdateSteps\step_2(), ilECSUpdateSteps8\step_4(), ilMDCopyrightUpdateSteps\step_5(), ilTestQuestionPool80DBUpdateSteps\step_6(), ilECSUpdateSteps8\step_7(), ilDataCollectionDBUpdateSteps\step_8(), ilDataCollectionDBUpdateSteps\step_9(), ilMailTemplateRepository\store(), ILIAS\Modules\Test\test\AccessFileUploadPreviewTest\testFalseWithInvalidId(), ILIAS\Modules\Test\test\AccessFileUploadPreviewTest\testWithTypes(), ilAdvancedMDFieldTranslation\update(), ilAdvancedMDRecordTranslation\update(), ilObjCourseReference\update(), ilSCTask\update(), ilStartingPoint\update(), ilECSParticipantSetting\update(), ilObjSession\update(), ilObjGroup\update(), ilAdvancedMDFieldDefinitionSelect\update(), ilEventParticipants\updateExcusedForUser(), ilLOUserResults\updateResultLimit(), ilObjCourse\updateSettings(), ilADTActiveRecordByType\write(), and ilLPStatus\writeStatus().

T_TEXT

const ilDBConstants::T_TEXT = ilDBPdoFieldDefinition::T_TEXT

Definition at line 56 of file class.ilDBConstants.php.

Referenced by ILIAS\Mail\Cron\ExpiredOrOrphanedMails\NotificationsCollector\__construct(), ILIAS\Mail\Cron\ExpiredOrOrphanedMails\MailDeletionHandler\__construct(), ilAdvancedSearch\__createClassificationWhere(), ilAdvancedSearch\__createRequirementWhere(), ilAdvancedSearch\__searchFormat(), ilAdvancedSearch\__searchGeneral(), ilMDSearch\__searchKeywordsOnly(), ilTreeTrashQueries\appendTrashNodeForContainerQueryFilter(), ilADTActiveRecordByType\cloneByPrimary(), ILIAS\Mail\Cron\ExpiredOrOrphanedMails\ExpiredOrOrphanedMailsCollector\collect(), ilSCGroup\create(), ilSCTask\create(), ilECSParticipantSetting\create(), ilAdvancedMDClaimingPlugin\createDBField(), ILIAS\Notifications\Repository\ilNotificationOSDRepository\createOSDNotification(), ILIAS\Certificate\API\Repository\UserDataRepository\createWhereCondition(), db_pwassist_create_id(), ilAdvancedMDFieldTranslation\delete(), ilAdvancedMDRecordTranslation\delete(), ILIAS\User\Profile\ProfileChangeMailTokenDBRepository\deleteEntryByToken(), ILIAS\Notifications\Repository\ilNotificationOSDRepository\deleteOSDNotificationByIdentification(), ILIAS\Notifications\Repository\ilNotificationOSDRepository\deleteOSDNotificationByUserAndType(), ILIAS\Notifications\Repository\ilNotificationOSDRepository\deleteStaleOSDNotificationsForUserAndType(), ilADTLocalizedTextDBBridge\deleteTranslations(), ilMDCopyrightMigration\extractFields(), ilObjCourse\findCoursesWithNotEnoughMembers(), ilObjGroup\findGroupsWithNotEnoughMembers(), ilADTLocalizedTextDBBridge\getAdditionalPrimaryFields(), ILIAS\User\Profile\ProfileChangeMailTokenDBRepository\getNewEmailForUser(), ILIAS\User\Profile\ProfileChangeMailTokenDBRepository\getNewTokenForUser(), ilConditionHandler\getNumberOfConditionsOfTrigger(), ILIAS\Notifications\Repository\ilNotificationOSDRepository\getOSDNotificationsByUser(), ilADTEnumSearchBridgeSingle\getSQLCondition(), ilAdvancedMDFieldTranslation\insert(), ilAdvancedMDRecordTranslation\insert(), ilADTLocalizedTextDBBridge\insertTranslations(), ilDclFieldTypePlugin\install(), ilMySQLQueryUtils\like(), ilSession\lookupExpireTime(), ilSCGroups\lookupGroupByComponentId(), ILIAS\AdvancedMetaData\Setup\DBUpdateSteps8\migrate(), ILIAS\AdvancedMetaData\Setup\DBUpdateSteps8\migrateData(), ilADTLocalizedTextDBBridge\prepareInsert(), ilDBPdo\quote(), ilSystemCheckTrash\readSelectedDeleted(), ilRbacReview\roleExists(), ilRegistrationRoleAccessLimitations\save(), ilStartingPoint\save(), ilDidacticTemplateSetting\save(), ilAdvancedMDRecord\save(), ilAdvancedMDFieldDefinitionSelect\saveOptionTranslations(), ilUser8DBUpdateSteps\step_1(), ILIAS\Object\Setup\ilObjectDBUpdateSteps\step_1(), ilLoggingUpdateSteps8\step_1(), ilDataCollectionDBUpdateSteps\step_12(), ilDataCollectionDBUpdateSteps\step_13(), ILIAS\Object\Setup\ilObjectDBUpdateSteps\step_2(), ilECSUpdateSteps8\step_2(), ilECSUpdateSteps8\step_3(), ilUser8DBUpdateSteps\step_4(), ilECSUpdateSteps8\step_5(), ilUser8DBUpdateSteps\step_6(), ilMailTemplateRepository\store(), ilAdvancedMDFieldTranslation\update(), ilAdvancedMDRecordTranslation\update(), ilSCTask\update(), ilStartingPoint\update(), ilECSParticipantSetting\update(), ilDidacticTemplateSetting\update(), ilAdvancedMDRecord\update(), and ilObjCourse\updateSettings().

T_TIME

const ilDBConstants::T_TIME = ilDBPdoFieldDefinition::T_TIME

Definition at line 57 of file class.ilDBConstants.php.

T_TIMESTAMP

const ilDBConstants::T_TIMESTAMP = ilDBPdoFieldDefinition::T_TIMESTAMP

Definition at line 58 of file class.ilDBConstants.php.

Referenced by ILIAS\Mail\Cron\ExpiredOrOrphanedMails\NotificationsCollector\__construct(), ILIAS\Mail\Cron\ExpiredOrOrphanedMails\ExpiredOrOrphanedMailsCollector\collect(), ilConsultationHourUtils\findCalendarAppointmentsForBooking(), ilDBPdo\quote(), ilObjectCustomUserFieldHistory\save(), ilForumCronNotification\sendNotificationForCensoredPosts(), ilForumCronNotification\sendNotificationForNewPosts(), ilForumCronNotification\sendNotificationForUncensoredPosts(), ilForumCronNotification\sendNotificationForUpdatedPosts(), ilSCTask\update(), ilObjGroup\update(), and ilObjCourse\updateSettings().

TYPE_GALERA

const ilDBConstants::TYPE_GALERA = 'galera'

Definition at line 35 of file class.ilDBConstants.php.

Referenced by getInstallableTypes(), getSupportedTypes(), ilDBWrapperFactory\getWrapper(), and ilDatabasePopulatedObjective\setDefaultEngine().

TYPE_INNODB

const ilDBConstants::TYPE_INNODB = 'innodb'

Definition at line 32 of file class.ilDBConstants.php.

Referenced by ilDatabaseInitializedObjective\achieve(), ilChatroomConfigFileHandler\getClientFileContent(), getInstallableTypes(), getSupportedTypes(), ilDBWrapperFactory\getWrapper(), ilInitialisation\initClientIniFile(), and ilDatabasePopulatedObjective\setDefaultEngine().

TYPE_MYSQL

const ilDBConstants::TYPE_MYSQL = 'mysql'

Definition at line 33 of file class.ilDBConstants.php.

Referenced by ilChatroomConfigFileHandler\getClientFileContent(), getInstallableTypes(), getSupportedTypes(), and ilDatabasePopulatedObjective\setDefaultEngine().

TYPE_MYSQLI

const ilDBConstants::TYPE_MYSQLI = 'mysqli'

Definition at line 36 of file class.ilDBConstants.php.

TYPE_PDO_MYSQL_GALERA

const ilDBConstants::TYPE_PDO_MYSQL_GALERA = 'pdo-mysql-galera'

Definition at line 39 of file class.ilDBConstants.php.

TYPE_PDO_MYSQL_INNODB

const ilDBConstants::TYPE_PDO_MYSQL_INNODB = 'pdo-mysql-innodb'

Definition at line 38 of file class.ilDBConstants.php.

---

The documentation for this class was generated from the following file:

• Services/Database/classes/class.ilDBConstants.php