ILIAS  release_5-4 Revision v5.4.26-12-gabc799a52e6
ilDBConstants Class Reference

Class ilDBConstants. More...

+ Collaboration diagram for ilDBConstants:

Static Public Member Functions

static getInstallableTypes ()
 
static getAvailableTypes ($with_descriptions=true)
 
static getSupportedTypes ()
 
static describe ($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_POSTGRES = 'postgres'
 
const TYPE_MYSQLI = 'mysqli'
 
const TYPE_PDO_MYSQL_INNODB = 'pdo-mysql-innodb'
 
const TYPE_PDO_MYSQL_MYISAM = 'pdo-mysql-myisam'
 
const TYPE_PDO_MYSQL_GALERA = 'pdo-mysql-galera'
 
const TYPE_PDO_POSTGRE = 'pdo-postgre'
 
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_ENGINE_MYISAM = 'MyISAM'
 
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 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 $descriptions
 

Detailed Description

Member Function Documentation

◆ describe()

static ilDBConstants::describe (   $type)
static
Parameters
$type
Returns
string

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

References $type.

Referenced by ilSetupGUI\getClientDbFormValues().

137  {
138  return self::$descriptions[$type];
139  }
$type
+ Here is the caller graph for this function:

◆ getAvailableTypes()

static ilDBConstants::getAvailableTypes (   $with_descriptions = true)
static
Parameters
bool$with_descriptions
Returns
array

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

References $type.

Referenced by ilSetupGUI\initClientIniForm(), and ilSetupGUI\initDBSelectionForm().

104  {
105  $types = self::getSupportedTypes();
106  if ($with_descriptions) {
107  $return = array();
108  foreach ($types as $type) {
109  $return [$type] = self::describe($type);
110  }
111  $types = $return;
112  }
113 
114  return $types;
115  }
$type
+ Here is the caller graph for this function:

◆ getInstallableTypes()

static ilDBConstants::getInstallableTypes ( )
static
Returns
array

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

References TYPE_GALERA, TYPE_INNODB, and TYPE_MYSQL.

Referenced by ilSetupGUI\initClientDbForm().

87  {
88  return array(
89  // Main
92  // Experimental
95  );
96  }
+ Here is the caller graph for this function:

◆ getSupportedTypes()

static ilDBConstants::getSupportedTypes ( )
static
Returns
array

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

References TYPE_GALERA, TYPE_INNODB, TYPE_MYSQL, and TYPE_POSTGRES.

Field Documentation

◆ $descriptions

ilDBConstants::$descriptions
staticprotected
Initial value:
= array(
ilDBConstants::TYPE_MYSQL => "MySQL 5.5.x or higher (MyISAM engine)",
ilDBConstants::TYPE_MYSQLI => "MySQL 5.5.x or higher (MyISAM engine)",
ilDBConstants::TYPE_INNODB => "MySQL 5.5.x or higher (InnoDB engine)",
ilDBConstants::TYPE_POSTGRES => "Postgres (experimental)",
ilDBConstants::TYPE_GALERA => "Galera-Cluster (experimental)",
ilDBConstants::TYPE_PDO_MYSQL_MYISAM => "MySQL 5.5.x or higher (MyISAM engine) [developers-identifier]",
ilDBConstants::TYPE_PDO_MYSQL_INNODB => "MySQL 5.5.x or higher (InnoDB engine) [developers-identifier]",
ilDBConstants::TYPE_PDO_POSTGRE => "Postgres (experimental) [developers-identifier]",
ilDBConstants::TYPE_PDO_MYSQL_GALERA => "Galera-Cluster (experimental) [developers-identifier]",
)

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

◆ AUTOQUERY_DELETE

const ilDBConstants::AUTOQUERY_DELETE = 3

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

Referenced by ilDBPdo\buildManipSQL().

◆ AUTOQUERY_INSERT

◆ AUTOQUERY_SELECT

const ilDBConstants::AUTOQUERY_SELECT = 4

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

Referenced by ilDBPdo\buildManipSQL().

◆ AUTOQUERY_UPDATE

◆ FETCHMODE_ASSOC

const ilDBConstants::FETCHMODE_ASSOC = 2

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

Referenced by ilObjCourse\__getCrsNonMemberTemplateId(), ilUserXMLWriter\__handleUser(), ilUserDefinedData\__read(), ilObjectDataCache\__storeReference(), ilDiskQuotaChecker\_fetchDiskQuotaReport(), ilObjLanguage\_getLastLocalChange(), ilObjLanguageExt\_getModules(), ilStructureObject\_getPresentationTitle(), ilObjLanguageExt\_getValues(), ilChangeEvent\_lookupChangeState(), ilContainer\_lookupContainerSetting(), ilPageObject\_lookupContainsDeactivatedElements(), ilFileDataMail\_lookupDiskUsageOfUser(), ilDiskQuotaChecker\_lookupDiskUsageReportLastUpdate(), ilObjFileAccess\_lookupFileData(), ilObjUserFolder\_lookupNewAccountMail(), ilObjMediaCastAccess\_lookupOnline(), ilObjMediaCastAccess\_lookupPublicFiles(), ilObjDiskQuotaSettings\_lookupReminderMailTemplate(), ilChangeEvent\_lookupUncaughtWriteEvents(), ilDiskQuotaChecker\_sendReminderMails(), ilObjUserFolder\buildExportFile(), ilSetup\checkClientSessionSettings(), ilForumTopic\countActivePosts(), ilForumTopic\countPosts(), ilNestedSetXML\deleteAllDbData(), ilNestedSetTree\deleteTree(), ilNestedSetXML\export(), ilPDOStatement\fetchAssoc(), ilPDOStatement\fetchRow(), ilUserFilter\filter(), ilADTActiveRecordByType\find(), ilRbacReview\getActiveOperationsOfRole(), ilLinkResourceItems\getAllItemIds(), ilSCORM2004Utilities\getAllowedActions(), ilSCORM2004Item\getAllowedActions(), ilSCORM2004Utilities\getAllSequencingProperties(), ilObjSCORMLearningModule\getAttemptsForUsers(), ilSCORM2004Utilities\getControlModeProperties(), ilObjUserFolder\getExportSettings(), ilObjectDefinition\getGroupedRepositoryObjectTypes(), ilObjGroup\getGrpStatusClosedTemplateId(), ilObjGroup\getGrpStatusOpenTemplateId(), ilSCORM2004Utilities\getImportIdent(), ilObjDiskQuotaSettings\getInstance(), ilObjectFactory\getInstanceByObjId(), ilObjectFactory\getInstanceByRefId(), ilSCORM2004Utilities\getItemId(), ilPageLayout\getLayouts(), ilPageLayout\getLayoutsAsArray(), ilObjLanguage\getLocalChanges(), ilLanguage\getLocalChanges(), ilObjSCORMLearningModule\getModuleVersionForUsers(), ilMDCopyrightSelectionEntry\getNextOrderPosition(), ilTree\getNodePathForTitlePath(), ilTree\getNodeTreeData(), ilObjectFactory\getObjectsForOwner(), ilParameterAppender\getParameterIds(), ilTree\getPathFull(), ilUserXMLWriter\getPictureValue(), ilSoapRBACAdministration\getRoles(), ilSCORM2004Utilities\getSequencingId(), ilSetup\getSessionSettings(), ilDBPdoReversePostgres\getTableConstraintDefinition(), ilDBUpdate\getTableStatus(), ilNestedSetXML\getTagName(), ilNestedSetXML\getTagValue(), ilObjectDefinition\getTranslationType(), ilDBPdoReversePostgres\getTriggerDefinition(), ilObjectFactory\getTypeByRefId(), ilSCORM2004PageLayout\getXMLContent(), ilNestedSetXML\init(), ilBookingReservation\isBookingPoolLimitReachedByUser(), ilDBPdoManagerPostgres\listTables(), ilLanguage\loadLanguageModule(), ilMemberAgreement\lookupAcceptedAgreements(), ilObjCourse\lookupCourseNonMemberTemplatesId(), ilUserDefinedData\lookupData(), ilObjGroup\lookupGroupStatusTemplateId(), ilForumTopic\movePosts(), ilTree\moveToTrash(), ilObjectDataCache\preloadReferenceCache(), ilDBPdo\query(), ilDBPdo\queryCol(), ilDBPdo\queryRow(), ilBookingEntry\read(), ilSecuritySettings\read(), ilPrivacySettings\read(), ilECSSetting\read(), ilAccess\readCache(), ilSetup\setSessionSettings(), ilNestedSetXML\setTagName(), ilNestedSetXML\setTagValue(), ilMaterializedPathTree\validateParentRelations(), and ilNestedSetTree\validateParentRelations().

◆ FETCHMODE_DEFAULT

const ilDBConstants::FETCHMODE_DEFAULT = self::FETCHMODE_ASSOC

◆ FETCHMODE_OBJECT

const ilDBConstants::FETCHMODE_OBJECT = 3

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

Referenced by ilCourseObjectiveQuestion\__addTest(), ilLinkChecker\__fetchUserData(), ilCourseObjective\__getLastPosition(), ilLinkChecker\__getObjIdByPageId(), ilLinkChecker\__getTitle(), ilRegistrationRoleAccessLimitations\__read(), ilContainerStartObjects\__read(), ilTimingAccepted\__read(), ilRegistrationRoleAssignments\__read(), ilTimingPlaned\__read(), ilLPObjSettings\__read(), ilLPMarks\__read(), ilCourseStart\__read(), ilSessionFile\__read(), ilEventItems\__read(), ilEventParticipants\__read(), ilCourseObjectiveMaterials\__read(), ilSessionAppointment\__read(), ilCourseObjective\__read(), ilUserDefinedFields\__read(), ilCourseObjectiveQuestion\__read(), ilSearch\__readDBResult(), ilObjCourse\__readSettings(), 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(), ilAdvancedSearch\__searchTitleDescription(), ilMetaDataSearch\__searchTitles(), ilAdvancedSearch\__searchTypicalAgeRange(), ilLearningProgressBaseGUI\__sort(), ilObjectDataCache\__storeObjectData(), ilDiskQuotaChecker\__updateDiskUsageReportOfTypeHelper(), ilDiskQuotaChecker\__updateDiskUsageReportOfUsers(), ilCourseObjectiveResult\__updatePassed(), ilCopyWizardOptions\_allocateCopyId(), ilCourseUserData\_checkRequired(), ilNestedSetXML\_deleteAllChildMetaData(), ilObjUser\_generateRegistrationHash(), ilCourseObjectiveResult\_getAccomplished(), ilAdvancedMDRecord\_getActivatedObjTypes(), ilAdvancedMDRecord\_getActivatedRecordsByObjectType(), ilAdvancedMDRecord\_getActiveSearchableRecords(), ilCourseObjectiveMaterials\_getAllAssignedMaterials(), ilNestedSetXML\_getAllChildIds(), ilECSExport\_getAllEContentIds(), ilLinkCheckNotify\_getAllNotifiers(), ilAdvancedMDRecord\_getAllRecordsByObjectType(), ilCalendarCategoryAssignments\_getAppointmentCalendars(), ilCalendarCategoryAssignments\_getAssignedAppointments(), ilCourseObjectiveMaterials\_getAssignedMaterials(), ilAuthUtils\_getAuthModeOfUser(), ilCalendarCategoryAssignments\_getAutoGeneratedAppointmentsByObjId(), ilLPStatusManual\_getCompleted(), ilLPStatusTestFinished\_getCompleted(), ilLPStatusManualByTutor\_getCompleted(), ilConditionHandler\_getCondition(), ilConditionHandler\_getDistinctTargetRefIds(), ilMDCopyrightSelectionEntry\_getEntries(), ilECSExport\_getExportedIDsByServer(), ilObjLinkResourceAccess\_getFirstLink(), ilLocalUser\_getFolderIds(), ilMDUtilSelect\_getFormatSelect(), ilObjCourseGrouping\_getGroupings(), ilMDLifecycle\_getId(), ilMDMetaMetadata\_getId(), ilMDRights\_getId(), ilMDTechnical\_getId(), ilMDGeneral\_getId(), ilMDEducational\_getId(), ilMDFormat\_getIds(), ilMDOrComposite\_getIds(), ilMDEntity\_getIds(), ilMDIdentifier_\_getIds(), ilMDLocation\_getIds(), ilMDDescription\_getIds(), ilMDKeyword\_getIds(), ilMDIdentifier\_getIds(), ilMDTaxon\_getIds(), ilMDLanguage\_getIds(), ilMDTypicalAgeRange\_getIds(), ilMDAnnotation\_getIds(), ilMDTaxonPath\_getIds(), ilMDContribute\_getIds(), ilMDRequirement\_getIds(), ilMDRelation\_getIds(), ilMDClassification\_getIds(), ilLPStatusTestFinished\_getInProgress(), ilCalendarCategory\_getInstanceByObjId(), ilEventItems\_getItemsOfContainer(), ilItemGroupItems\_getItemsOfContainer(), ilEventItems\_getItemsOfEvent(), ilMDKeyword\_getKeywordsByLanguage(), ilMDKeyword\_getMatchingKeywords(), ilLPStatusTestFinished\_getNotAttempted(), ilLinkCheckNotify\_getNotifiers(), ilCourseObjective\_getObjectiveIds(), ilUtil\_getObjectsByOperations(), ilRbacReview\_getOperationIdByName(), ilParameterAppender\_getParams(), 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(), ilObjUser\_getUserIdsByInactivityPeriod(), ilCourseUserData\_getValuesByObjId(), ilObjCourseGrouping\_getVisibleGroupings(), ilMemberAgreement\_hasAccepted(), ilLPMarks\_hasCompleted(), ilContainerReferenceAccess\_isAccessible(), ilCourseObjectiveQuestion\_isAssigned(), ilECSExport\_isExported(), ilEventParticipants\_isRegistered(), ilECSExport\_isRemote(), ilParticipants\_isSubscriber(), ilObjCourse\_lookupAboStatus(), ilObjUser\_lookupActive(), ilSessionAppointment\_lookupAppointment(), ilMDContribute\_lookupAuthors(), ilCalendarCategoryAssignments\_lookupCategories(), ilCalendarCategories\_lookupCategoryIdByObjId(), ilLPMarks\_lookupComment(), ilCourseObjective\_lookupContainerIdByObjectiveId(), ilMDCopyrightSelectionEntry\_lookupCopyright(), ilLPObjSettings\_lookupDBModeForObjects(), ilMDRights\_lookupDescription(), ilDiskQuotaChecker\_lookupDiskQuota(), ilDiskQuotaChecker\_lookupDiskUsage(), ilECSImport\_lookupEContentId(), ilObjFile\_lookupFileName(), ilObjFileAccess\_lookupFileSize(), ilObjFileAccess\_lookupFileSizeFromFilesystem(), ilMDLanguage\_lookupFirstLanguage(), ilLDAPAttributeMapping\_lookupGlobalRole(), ilObjGroup\_lookupIdByTitle(), ilLPMarks\_lookupMark(), ilRemoteObjectBase\_lookupMID(), ilECSImport\_lookupMID(), ilECSImport\_lookupMIDs(), ilCourseDefinedFieldDefinition\_lookupName(), ilECSImport\_lookupObjId(), ilECSImport\_lookupObjIds(), ilECSImport\_lookupObjIdsByMID(), ilObjRemoteGlossary\_lookupOnline(), ilObjRemoteLearningModule\_lookupOnline(), ilObjRemoteWiki\_lookupOnline(), ilObjRemoteCourse\_lookupOnline(), ilObjRemoteTest\_lookupOnline(), ilObjRemoteGroup\_lookupOnline(), ilRemoteObjectBase\_lookupOrganization(), ilDiskQuotaChecker\_lookupPersonalWorkspaceDiskQuota(), ilObjUser\_lookupPref(), ilAdvancedMDRecord\_lookupRecordIdByImportId(), ilObjSessionAccess\_lookupRegistered(), ilObjSessionAccess\_lookupRegistration(), ilObjSession\_lookupRegistrationEnabled(), ilContainerSortingSettings\_lookupSortMode(), ilContainerReference\_lookupSourceId(), ilContainerReference\_lookupSourceIds(), ilObjFileAccess\_lookupSuffix(), ilContainerReference\_lookupTargetId(), ilContainerReference\_lookupTargetRefId(), ilContainerReference\_lookupTargetTitle(), ilAdvancedMDRecord\_lookupTitle(), ilContainerReference\_lookupTitle(), ilObjFileAccess\_lookupVersion(), ilObjCourseAccess\_lookupViewMode(), ilObjCourse\_lookupViewMode(), ilLPObjSettings\_lookupVisits(), ilObjLinkResourceAccess\_preloadData(), 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(), ilCronDeleteInactiveUserReminderMail\checkIfReminderMailShouldBeSend(), ilLinkChecker\checkLinks(), ilSCTreeTasks\checkStructure(), ilContainerSorting\cloneSorting(), ilRbacAdmin\copyRolePermissionIntersection(), ilObjRole\createDefaultRole(), ilLPCollectionOfRepositoryObjects\createNewGrouping(), ilObjRole\createPermissionIntersection(), ilFileDataMail\deassignAttachmentFromDirectory(), ilCourseObjectiveQuestion\delete(), ilUserSearchCache\deleteCachedEntries(), ilSCTreeTasks\deleteDuplicate(), ilSCTreeTasks\deleteMissingTreeEntry(), ilSoapLearningProgressAdministration\deleteScorm2004Tracking(), ilShibbolethRoleAssignmentRules\doAssignments(), ilECSCourseMappingRule\doMappings(), ilRemoteObjectBase\doRead(), ilValidator\dumpTree(), ilECSRemoteUser\exists(), ilECSRemoteUser\factory(), 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(), ilValidator\findUnboundObjects(), ilCalendarSharedStatus\getAcceptedCalendars(), ilDidacticTemplateActionFactory\getActionsByTemplateId(), ilAuthProviderLTI\getActiveAuthModes(), ilECSCategoryMapping\getActiveRules(), ilMailingLists\getAll(), ilRoleDesktopItem\getAll(), ilECSImport\getAllImportedRemoteObjects(), ilLinkResourceItems\getAllItems(), ilLDAPRoleAssignmentRules\getAllPossibleRoles(), ilForumTopic\getAllPosts(), ilConsultationHourAppointments\getAppointmentIds(), ilConsultationHourAppointments\getAppointmentIdsByGroup(), ilRbacReview\getAssignableRolesInSubtree(), ilMailingList\getAssignedEntries(), ilDidacticTemplateObjSettings\getAssignmentsByTemplateID(), ilLDAPRoleAssignmentRules\getAssignmentsForCreation(), ilLDAPRoleAssignmentRules\getAssignmentsForUpdate(), ilLDAPRoleAssignmentRules\getAttributeNames(), ilAuthProviderLTI\getAuthModes(), ilECSParticipantSettings\getAvailabeMids(), ilLDAPServer\getAvailableDataSources(), ilCalendarSchedule\getChangedEvents(), ilDBUpdate4963\getChildIds(), ilTree\getChildIds(), ilSCTreeTasks\getChilds(), ilConsultationHourGroups\getCountGroupsOfUser(), ilShibbolethRoleAssignmentRules\getCountRules(), ilLDAPServer\getDataSource(), ilCalendarSchedule\getEvents(), ilEventItems\getEventsForItemOrderedByStartingTime(), ilCalendarRecurrenceExclusions\getExclusionDates(), ilSessionControl\getExistingSessionCount(), ilECSParticipantSettings\getExportableParticipants(), ilECSExport\getExportedIds(), ilECSExport\getExportedIdsByType(), ilECSExport\getExportServerIds(), ilECSParticipantSettings\getExportServers(), ilForumTopic\getFirstPostId(), ilLTIDataConnector\getGlobalToolConsumerSettings(), ilLPCollectionOfRepositoryObjects\getGroupedItemsForLPStatus(), ilLPCollectionOfRepositoryObjects\getGroupingIds(), ilObjGroup\getGroupMemberData(), ilConsultationHourGroups\getGroupsOfUser(), ilECSCourseMappingRule\getInstanceByAttribute(), ilLinkChecker\getInvalidLinksFromDB(), ilRoleDesktopItem\getItem(), ilLinkResourceItems\getItem(), ilForumTopic\getLastActivePost(), ilCourseLMHistory\getLastLM(), ilForumTopic\getLastPost(), ilLearningSequenceRoles\getLearningSequenceMemberData(), ilRoleAutoComplete\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(), ilRbacReview\getRoleFolderOfRole(), ilECSCourseMappingRule\getRuleRefIds(), ilECSCourseMappingRule\getRulesOfRefId(), ilLOTestRun\getRun(), ilLDAPServer\getServerIds(), ilCalendarShared\getSharedCalendarsForUser(), ilDclIliasReferenceRecordFieldModel\getStatus(), ilNestedSetTree\getSubTreeIds(), ilMaterializedPathTree\getSubtreeInfo(), ilNestedSetTree\getSubtreeInfo(), ilLPCollectionOfRepositoryObjects\getTableGUItemGroup(), ilCourseObjectiveQuestion\getTests(), ilObjWorkspaceRootFolder\getTranslations(), ilObjRootFolder\getTranslations(), ilObjOrgUnit\getTranslations(), ilRbacReview\getTypeId(), ilECSTaskScheduler\handleDeprecatedAccounts(), ilCourseObjectiveResult\hasAccomplishedObjective(), ilECSNodeMappingAssignments\hasAssignments(), ilBookingEntry\hasObjectBookingEntries(), ilLOUserResults\hasResults(), ilLDAPRoleAssignmentRule\hasRulesForUpdate(), ilCourseObjective\ilClone(), ilMDConvert(), ilCalendarUtil\initDefaultCalendarByType(), ilRbacReview\isBlockedAtPosition(), ilRbacReview\isBlockedInUpperContext(), ilBookingEntry\isBookable(), ilRepositoryExplorer\isClickable(), ilLDAPServer\isDataSourceActive(), ilRbacReview\isDeleted(), ilECSCourseMappingRule\isMatching(), ilRepositoryExplorerGUI\isNodeClickable(), ilLOSettings\isObjectiveTest(), ilCalendarShared\isSharedWithUser(), ilParticipants\isSubscriber(), ilECSNodeMappingAssignments\isWholeTreeMapped(), ilSessionControl\kickFirstRequestAbidencer(), ilSessionControl\kickOneMinIdleSession(), ilLTIDataConnector\loadGlobalToolConsumerSettings(), ilLTIDataConnector\loadObjectToolConsumerSettings(), ilLTIDataConnector\loadUser(), ilDBGenerator\lookupAbstractedTables(), ilOrgUnitObjectPositionSetting\lookupActive(), ilCalendarCategory\lookupAppointments(), ilObjSessionListGUI\lookupAssignedMaterials(), ilECSCourseMemberAssignment\lookupAssignment(), ilECSNodeMappingAssignments\lookupAssignmentIds(), ilECSNodeMappingAssignments\lookupAssignmentsByRefId(), ilCalendarAuthenticationToken\lookupAuthToken(), ilBookingEntry\lookupBookableUsersForObject(), ilBookingEntry\lookupBookingMessage(), ilBookingEntry\lookupBookingsForObject(), ilBookingEntry\lookupBookingsOfUser(), ilECSCmsData\lookupCmsIds(), ilECSCmsData\lookupCmsIdsOfTree(), ilSCGroup\lookupComponent(), ilComponent\lookupComponentName(), ilLOTestAssignments\lookupContainerForTest(), ilECSImport\lookupContentId(), ilMDCopyrightSelectionEntry\lookupCopyrightByText(), ilMDCopyrightSelectionEntry\lookupCopyyrightTitle(), ilECSNodeMappingAssignments\lookupDefaultTitleUpdate(), ilECSImport\lookupEContentIdByContentId(), ilObjectCustomUserFieldHistory\lookupEntriesByObjectId(), ilSession\lookupExpireTime(), ilECSCmsData\lookupFirstTreeOfNode(), ilSCGroups\lookupGroupByComponentId(), ilSCTasks\lookupGroupId(), ilObjGroup\lookupGroupTye(), ilECSCategoryMapping\lookupHandledCategories(), ilOerHarvesterObjectStatus\lookupHarvested(), ilLanguage\lookupId(), ilSCTasks\lookupIdentifierForTask(), ilLinkResourceItems\lookupItem(), ilMDKeyword\lookupKeywords(), ilObjSCORMTracking\lookupLastAccessTimes(), ilECSCourseMappingRule\lookupLastExistingAttribute(), ilExportFileInfo\lookupLastExport(), ilSessionAppointment\lookupLastSessionByCourse(), ilSCTasks\lookupLastUpdate(), ilLORandomTestQuestionPools\lookupLimit(), ilWaitingList\lookupListSize(), ilConsultationHourUtils\lookupManagedUsers(), ilECSNodeMappingAssignments\lookupMappedItemsForRefId(), ilObjUser\lookupMatriculation(), ilConsultationHourGroups\lookupMaxBookings(), ilCourseObjective\lookupMaxPasses(), ilECSCourseMemberAssignment\lookupMissingAssignmentsOfUser(), ilSessionAppointment\lookupNextSessionByCourse(), ilCalendarCategoryAssignments\lookupNumberOfAssignedAppointments(), ilLinkResourceItems\lookupNumberOfLinks(), ilLORandomTestQuestionPools\lookupObjectiveIdsBySequence(), ilLOUtils\lookupObjectiveRequiredPercentage(), ilLOTestRun\lookupObjectives(), ilLOTestAssignments\lookupObjectivesForTest(), ilCourseObjectiveQuestion\lookupObjectivesOfQuestion(), ilObjGroup\lookupObjectsByCode(), ilObjCourse\lookupObjectsByCode(), ilECSCmsData\lookupObjId(), ilECSImport\lookupObjIdByContentId(), ilOerHarvesterObjectStatus\lookupObjIdByHarvestingId(), ilECSImport\lookupObjIdsByContentId(), ilConditionHandler\lookupObligatoryConditionsOfTarget(), ilDidacticTemplateFilterPatternFactory\lookupPatternsByParentId(), ilConditionHandler\lookupPersistedHiddenStatusByTarget(), ilContainerSorting\lookupPositions(), ilCourseObjectiveQuestion\lookupQuestionsByObjective(), ilLTIDataConnector\lookupRecordIdByGlobalSettingsAndRefId(), ilObjGroupAccess\lookupRegistrationInfo(), ilObjCourseAccess\lookupRegistrationInfo(), ilLTIDataConnector\lookupResourcesForAllUsersSinceDate(), ilLTIDataConnector\lookupResourcesForUserObjectRelation(), ilLOUserResults\lookupResult(), ilMDRights\lookupRightsByTypeAndCopyright(), ilECSCmsTree\lookupRootId(), ilLOTestRun\lookupRunExistsForObjective(), ilLORandomTestQuestionPools\lookupSequences(), ilLORandomTestQuestionPools\lookupSequencesByType(), ilECSImport\lookupServerId(), ilECSExport\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(), ilCalendarAuthenticationToken\lookupUser(), ilECSCourseMemberAssignment\lookupUserIds(), ilObjGroup\lookupViewMode(), ilECSParticipantSettings\loookupCmsMid(), ilCourseObjectiveQuestion\loookupTestLimit(), ilMediaPoolSearch\performKeywordSearch(), ilUserDefinedFieldSearch\performSearch(), ilMediaPoolSearch\performSearch(), ilLikeUserMultiFieldSearch\performSearch(), ilLikeUserOrgUnitSearch\performSearch(), ilWikiContentSearch\performSearch(), ilLMContentSearch\performSearch(), ilWebresourceSearch\performSearch(), ilExerciseSearch\performSearch(), ilGlossaryDefinitionSearch\performSearch(), ilForumSearch\performSearch(), ilMediaCastSearch\performSearch(), ilObjectSearch\performSearch(), ilUserSearch\performSearch(), ilObjectDataCache\preloadObjectCache(), ilRbacSystem\preloadRbacPaCache(), ilObjectDataCache\preloadTranslations(), ilDBPdo\queryCol(), ilDBPdo\queryRow(), ilLogComponentLevel\read(), ilLogComponentLevels\read(), ilSCGroups\read(), ilMDFormat\read(), ilDidacticTemplateSettings\read(), ilSCTask\read(), ilSCGroup\read(), ilMDEntity\read(), ilLPCollection\read(), ilMDIdentifier\read(), ilMDLocation\read(), ilMDIdentifier_\read(), ilECSCourseAttribute\read(), ilECSCommunitiesCache\read(), ilMDDescription\read(), ilMDKeyword\read(), ilOrgUnitObjectTypePositionSetting\read(), ilConsultationHourGroup\read(), ilObjectCustomUserFieldHistory\read(), ilAdvancedMDRecordScope\read(), ilMDTaxon\read(), ilCalendarAppointmentColors\read(), ilMDAnnotation\read(), ilOerHarvesterObjectStatus\read(), ilMDLanguage\read(), ilMDTypicalAgeRange\read(), ilTimingUser\read(), ilECSRemoteUser\read(), ilCalendarRegistration\read(), ilECSDataMappingSettings\read(), ilLOTestAssignment\read(), ilMDTaxonPath\read(), ilMailingList\read(), ilCalendarRecurrenceExclusion\read(), ilECSCommunityCache\read(), ilUserFormSettings\read(), ilDidacticTemplateAction\read(), ilLPCollectionOfRepositoryObjects\read(), ilMDContribute\read(), ilMDRights\read(), ilCalendarUserNotification\read(), ilMDRequirement\read(), ilSCTasks\read(), ilECSDataMappingSetting\read(), ilMDLifecycle\read(), ilDidacticTemplateLocalRoleAction\read(), ilMDRelation\read(), ilECSNodeMappingAssignment\read(), ilECSCourseAttributes\read(), ilForumTopic\read(), ilObject\read(), ilMDMetaMetadata\read(), ilECSParticipantSettings\read(), ilMDClassification\read(), ilExportOptions\read(), ilCalendarAuthenticationToken\read(), ilExportFileInfo\read(), ilCourseUserData\read(), ilDidacticTemplateFilterPattern\read(), ilObjCourseGrouping\read(), ilLORandomTestQuestionPools\read(), ilContainerReference\read(), ilCalendarSharedStatus\read(), ilLOTestRun\read(), ilDidacticTemplateBlockRoleAction\read(), ilECSParticipantSetting\read(), ilLDAPRoleGroupMappingSettings\read(), ilBookingEntry\read(), ilCalendarVisibility\read(), ilMDTechnical\read(), ilLDAPAttributeMapping\read(), ilCalendarCategoryAssignments\read(), ilMDGeneral\read(), ilECSCourseMemberAssignment\read(), ilDidacticTemplateLocalPolicyAction\read(), ilCalendarShared\read(), ilWaitingList\read(), ilECSExport\read(), ilContainerSortingSettings\read(), ilMemberAgreement\read(), ilAdvancedMDSubstitution\read(), ilMDEducational\read(), ilShibbolethRoleAssignmentRule\read(), ilCalendarCategory\read(), ilCourseDefinedFieldDefinition\read(), ilUserSearchCache\read(), ilECSCourseMappingRule\read(), ilMDCopyrightSelectionEntry\read(), ilDidacticTemplateSetting\read(), ilContainerSorting\read(), ilECSImport\read(), ilECSCmsData\read(), ilLOSettings\read(), ilLDAPRoleAssignmentRule\read(), ilCopyWizardOptions\read(), ilECSEventQueueReader\read(), ilCalendarEntry\read(), ilCalendarRecurrence\read(), ilObjSession\read(), ilObjGroup\read(), ilAdvancedMDRecord\read(), ilObjectActivation\read(), ilLDAPServer\read(), ilECSServerSettings\readActiveServers(), ilCalendarCategories\readBookingCalendar(), ilCalendarCategories\readConsultationHoursCalendar(), ilSystemCheckTrash\readDeleted(), ilDidacticTemplateSetting\readEffectiveNodes(), ilDidacticTemplateSettings\readInactive(), ilECSServerSettings\readInactiveServers(), ilLinkResourceItems\readItem(), ilSCTreeTasks\readMissing(), ilSCTreeTasks\readMissingTreeEntries(), ilParticipants\readParticipantsStatus(), ilParticipant\readParticipantStatus(), ilAdvancedMDRecordObjectOrderings\readPositionsForObject(), ilCalendarCategories\readPrivateCalendars(), ilCalendarCategories\readPublicCalendars(), ilObjLTIAdministration\readReleaseObjects(), ilCalendarCategories\readReposCalendars(), ilCalendarCategories\readSelectedCategories(), ilSystemCheckTrash\readSelectedDeleted(), ilOrgUnitObjectPositionSetting\readSettings(), ilParticipants\readSubscriberData(), ilParticipants\readSubscribers(), ilLOTestAssignments\readTestAssignments(), ilCronDeleteInactiveUserReminderMail\removeEntriesFromTableIfLastLoginIsNewer(), ilDBUpdate4963\renumberBookmarkTree(), ilSCTreeTasks\repairMissingObject(), ilSCTreeTasks\repairMissingTreeEntries(), ilDidacticTemplateLocalPolicyAction\revertLocalPolicy(), ilRbacReview\roleExists(), ilConsultationHourCron\run(), ilLPCollectionOfRepositoryObjects\saveObligatoryMaterials(), ilForumXMLWriter\start(), ilLORandomTestQuestionPools\toXml(), ilDidacticTemplateObjSettings\transferAutoGenerateStatus(), ilECSCmsData\treeExists(), ilECSCmsTree\treeExists(), ilShibbolethRoleAssignmentRules\updateAssignments(), ilParticipant\updateMemberRoles(), ilObjUser\userExists(), and ilECSEventQueueReader\writeEventToDB().

◆ INDEX_FORMAT

const ilDBConstants::INDEX_FORMAT = ilDBPdoFieldDefinition::INDEX_FORMAT

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

◆ LOCK_READ

const ilDBConstants::LOCK_READ = ilAtomQuery::LOCK_READ

◆ LOCK_WRITE

const ilDBConstants::LOCK_WRITE = ilAtomQuery::LOCK_WRITE

◆ MB4_REPLACEMENT

const ilDBConstants::MB4_REPLACEMENT = "?"

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

Referenced by ilDBPdo\sanitizeMB4StringIfNotSupported().

◆ MODULE_MANAGER

◆ MODULE_REVERSE

◆ MYSQL_CHARACTER_UTF8

const ilDBConstants::MYSQL_CHARACTER_UTF8 = 'utf8'

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

◆ MYSQL_CHARACTER_UTF8MB4

const ilDBConstants::MYSQL_CHARACTER_UTF8MB4 = 'utf8mb4'

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

◆ MYSQL_COLLATION_UTF8

const ilDBConstants::MYSQL_COLLATION_UTF8 = 'utf8_general_ci'

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

◆ MYSQL_COLLATION_UTF8MB4

const ilDBConstants::MYSQL_COLLATION_UTF8MB4 = 'utf8mb4_general_ci'

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

◆ MYSQL_ENGINE_INNODB

const ilDBConstants::MYSQL_ENGINE_INNODB = 'InnoDB'

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

◆ MYSQL_ENGINE_MYISAM

const ilDBConstants::MYSQL_ENGINE_MYISAM = 'MyISAM'

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

◆ PREPARE_MANIP

const ilDBConstants::PREPARE_MANIP = false

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

◆ SEQUENCE_COLUMNS_NAME

const ilDBConstants::SEQUENCE_COLUMNS_NAME = ilDBPdoFieldDefinition::SEQUENCE_COLUMNS_NAME

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

Referenced by ilDBPdoManager\createSequence().

◆ SEQUENCE_FORMAT

const ilDBConstants::SEQUENCE_FORMAT = ilDBPdoFieldDefinition::SEQUENCE_FORMAT

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

Referenced by ilDBPdoManager\fixSequenceName().

◆ T_BLOB

const ilDBConstants::T_BLOB = ilDBPdoFieldDefinition::T_BLOB

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

◆ T_CLOB

const ilDBConstants::T_CLOB = ilDBPdoFieldDefinition::T_CLOB

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

Referenced by ilMySQLQueryUtils\like(), and ilPostgresQueryUtils\like().

◆ T_DATE

const ilDBConstants::T_DATE = ilDBPdoFieldDefinition::T_DATE

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

Referenced by ilDBPdo\quote().

◆ T_DATETIME

const ilDBConstants::T_DATETIME = ilDBPdoFieldDefinition::T_DATETIME

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

Referenced by ilDBPdo\quote().

◆ T_FLOAT

const ilDBConstants::T_FLOAT = ilDBPdoFieldDefinition::T_FLOAT

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

Referenced by ilDBPdo\quote().

◆ T_INTEGER

const ilDBConstants::T_INTEGER = ilDBPdoFieldDefinition::T_INTEGER

◆ T_TEXT

const ilDBConstants::T_TEXT = ilDBPdoFieldDefinition::T_TEXT

◆ T_TIME

const ilDBConstants::T_TIME = ilDBPdoFieldDefinition::T_TIME

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

◆ T_TIMESTAMP

const ilDBConstants::T_TIMESTAMP = ilDBPdoFieldDefinition::T_TIMESTAMP

◆ TYPE_GALERA

◆ TYPE_INNODB

◆ TYPE_MYSQL

◆ TYPE_MYSQLI

const ilDBConstants::TYPE_MYSQLI = 'mysqli'

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

◆ TYPE_PDO_MYSQL_GALERA

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

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

◆ TYPE_PDO_MYSQL_INNODB

◆ TYPE_PDO_MYSQL_MYISAM

const ilDBConstants::TYPE_PDO_MYSQL_MYISAM = 'pdo-mysql-myisam'

◆ TYPE_PDO_POSTGRE

◆ TYPE_POSTGRES


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