eZPublish  3.9
ezsqldiff.php File Reference

Functions

loadDatabaseSchema ($type, $host, $user, $password, $socket, $db, &$cli)
 
loadLintSchema (&$dbSchema, &$cli)
 

Variables

 $cli =& eZCLI::instance()
 
if(strlen(trim($sourceType))==0)
if(strlen(trim($matchType))==0) 
$ini =& eZINI::instance()
 
 $matchDB = count( $options['arguments'] ) >= 2 ? $options['arguments'][1] : ''
 
 $matchDBHost = $options['match-host'] ? $options['match-host'] : $options['host']
 
 $matchDBPassword = $options['match-password'] ? $options['match-password'] : $options['password']
 
 $matchDBSocket = $options['match-socket'] ? $options['match-socket'] : $options['socket']
 
 $matchDBUser = $options['match-user'] ? $options['match-user'] : $options['user']
 
 $matchType = $options['match-type'] ? $options['match-type'] : $options['type']
 
 $options
 
 $script
 
 $sourceDB = $options['arguments'][0]
 
 $sourceDBHost = $options['source-host'] ? $options['source-host'] : $options['host']
 
 $sourceDBPassword = $options['source-password'] ? $options['source-password'] : $options['password']
 
 $sourceDBSocket = $options['source-socket'] ? $options['source-socket'] : $options['socket']
 
 $sourceDBUser = $options['source-user'] ? $options['source-user'] : $options['user']
 
 $sourceSchema = loadDatabaseSchema( $sourceType, $sourceDBHost, $sourceDBUser, $sourceDBPassword, $sourceDBSocket, $sourceDB, $cli )
 
if(count($options['arguments'])
< 1) if(count($options['arguments'])
< 2 and!$options['lint-check']) 
$sourceType = $options['source-type'] ? $options['source-type'] : $options['type']
 
if(!$sourceSchema) if($options['lint-check']) else
 
 if (!$matchSchema)
 

Function Documentation

& loadDatabaseSchema (   $type,
  $host,
  $user,
  $password,
  $socket,
  $db,
$cli 
)
& loadLintSchema ( $dbSchema,
$cli 
)

Variable Documentation

$cli =& eZCLI::instance()
if (strlen(trim($sourceType))==0) if (strlen(trim($matchType))==0) $ini =& eZINI::instance()

Referenced by accessAllowed(), eZUser\accessArray(), accessDebugEnabled(), accessExtraDebugEnabled(), accessType(), eZExtension\activateExtensions(), eZExtension\activeExtensions(), eZSearch\addObject(), eZCodeTemplate\allCodeFiles(), eZTemplateDesignResource\allDesignBases(), eZInformationCollection\allowAnonymous(), eZMail\allowedCharsets(), eZTemplateCompiler\alwaysGenerate(), eZImageAnalyzer\analyzerData(), eZImage\attribute(), eZInformationCollection\attributeHideList(), eZUser\authenticationMatch(), eZExtension\baseDirectory(), eZDBInterface\begin(), eZContentBrowse\browse(), eZSearch\buildSearchArray(), eZSearchEngine\buildTempTablesForFullTextSearch(), eZTranslationCache\cacheDirectory(), eZSys\cacheDirectory(), eZURLAlias\cacheInfo(), eZContentCache\cachePathInfo(), eZContentObject\canCreateClassList(), eZContentObjectTreeNode\canCreateClassList(), eZContentClass\canInstantiateClasses(), eZContentClass\canInstantiateClassList(), changeAccess(), eZImageHandler\changeFilePermissions(), eZSSLZone\checkModuleView(), eZTipafriendRequest\checkReceiver(), eZDB\checkTransactionCounter(), eZUserLoginHandler\checkUser(), eZUser\checkUser(), eZContentObjectTreeNode\childrenByName(), eZUserType\classAttributeRemovableInformation(), eZDataType\classDisplayInformation(), eZContentClassPackageHandler\classDOMTree(), eZTipafriendRequest\cleanup(), eZContentCache\cleanup(), eZSearch\cleanup(), eZSubtreeCache\cleanupCacheDir(), eZBasket\cleanupCurrentBasket(), eZContentCacheManager\clearAllContentCache(), eZContentCacheManager\clearObjectViewCache(), eZContentCacheManager\clearObjectViewCacheIfNeeded(), eZContentCacheManager\clearTemplateBlockCacheIfNeeded(), eZDBInterface\commit(), eZTemplateCompiler\compileTemplate(), eZLocale\create(), eZImageManager\createAliasFromINI(), eZImageShellHandler\createFromINI(), eZImageGDHandler\createFromINI(), eZTemplateDesignResource\createOverrideCache(), eZHTTPTool\createRedirectUrl(), eZPackageCreationHandler\creatorList(), eZObjectRelationType\customObjectAttributeHTTPAction(), eZObjectRelationListType\customObjectAttributeHTTPAction(), eZWebDAVServer\dataCharset(), eZContentObject\defaultLanguage(), eZContentCacheManager\dependencyInfo(), eZTemplateDesignResource\designSetting(), eZDir\directoryPermission(), eZInformationCollection\displayHandling(), eZXMLTextType\domString(), eZObjectRelationListType\domString(), eZMatrix\domString(), eZStepSiteTypes\downloadFile(), eZXMLInputType\editorName(), eZHTTPHeader\enabled(), eZSSLZone\enabled(), eZTemplate\error(), eZDefaultConfirmOrderHandler\execute(), eZSimpleShippingType\execute(), eZApproveType\execute(), eZCodeMapper\executeCommandCode(), eZContentObject\expireTemplateBlockCacheIfNeeded(), eZCheckUser(), eZCheckValidity(), eZCodeTemplate\eZCodeTemplate(), eZCollaborationViewHandler\eZCollaborationViewHandler(), eZSys\ezcrc32(), eZDBInterface\eZDBInterface(), eZDisplayDebug(), eZFetchActiveSessionCount(), eZFetchActiveSessions(), eZImageManager\eZImageManager(), eZMail\eZMail(), eZPostgreSQLDB\eZPostgreSQLDB(), eZRegisterSessionFunctions(), eZSessionRead(), eZSessionStart(), eZSessionWrite(), eZSetupCriticalTests(), eZSetupOptionalTests(), eZSetupTestDirectoryPermissions(), eZSetupTestFilePermissions(), eZStaticCache\eZStaticCache(), eZStepCreateSites\eZStepCreateSites(), eZStepDatabaseChoice\eZStepDatabaseChoice(), eZStepDatabaseInit\eZStepDatabaseInit(), eZStepEmailSettings\eZStepEmailSettings(), eZStepFinal\eZStepFinal(), eZStepInstaller\eZStepInstaller(), eZStepLanguageOptions\eZStepLanguageOptions(), eZStepRegistration\eZStepRegistration(), eZStepSecurity\eZStepSecurity(), eZStepSiteAccess\eZStepSiteAccess(), eZStepSiteAdmin\eZStepSiteAdmin(), eZStepSiteDetails\eZStepSiteDetails(), eZStepSitePackages\eZStepSitePackages(), eZStepSiteTemplates\eZStepSiteTemplates(), eZStepSiteTypes\eZStepSiteTypes(), eZStepSystemCheck\eZStepSystemCheck(), eZStepSystemFinetune\eZStepSystemFinetune(), eZStepWelcome\eZStepWelcome(), eZTemplate\eZTemplate(), eZTemplateImageOperator\eZTemplateImageOperator(), eZUpdateDebugSettings(), eZUpdateTextCodecSettings(), eZXHTMLXMLOutput\eZXHTMLXMLOutput(), eZXMLInputParser\eZXMLInputParser(), eZXMLOutputHandler\eZXMLOutputHandler(), eZXMLSchema\eZXMLSchema(), eZUser\fetchAnonymousCount(), eZAudit\fetchAuditEnabled(), eZAudit\fetchAuditNameSettings(), eZCountryType\fetchCountryList(), eZCollaborationViewHandler\fetchGroupList(), eZCache\fetchList(), eZNavigationPart\fetchList(), eZCollaborationViewHandler\fetchList(), eZTSTranslator\fetchList(), eZUser\fetchLoggedInCount(), eZUser\fetchLoggedInList(), eZContentObjectTreeNode\fetchNode(), eZUserType\fetchObjectAttributeHTTPInput(), eZClassFunctionCollection\fetchOverrideTemplateList(), eZProductCategory\fetchProductCountByCategory(), eZRSSImport\fieldMap(), eZFilePackageHandler\fileExists(), eZTemplateDesignResource\fileMatchingRules(), eZExtension\findExtensionType(), eZSiteAccess\findPathToSiteAccess(), eZImageVariation\fullPath(), eZNodeviewfunctions\generateNodeView(), eZContentCacheManager\generateObjectViewCache(), eZNodeviewfunctions\generateViewCacheFile(), eZUser\getCacheFilename(), eZHTTPTool\getDataByURL(), eZDir\getPathFromFilename(), eZDefaultVATHandler\getProductCategory(), eZSSLZone\getSSLZones(), eZVATManager\getUserCountryAttributeName(), getVariable(), eZCharTransform\groupCommands(), eZGeneralDigestHandler\handle(), eZContentObjectPackageHandler\handleParameters(), eZSubTreeHandler\handlePublishEvent(), handleRelationTemplate(), eZUser\hashType(), eZHTTPHeader\headerOverrideArray(), eZLocale\httpLocaleCode(), eZi18nOperator\i18nTrans(), eZImageAliasHandler\imagePath(), eZImageAliasHandler\imagePathByNode(), eZContentCache\inCleanupThresholdRange(), eZSys\indexFile(), eZTemplate\ini(), eZStepCreateSites\init(), eZModule\initialize(), eZScript\initialize(), eZSimpleTagsOperator\initializeIncludes(), eZContentObjectPackageCreator\initializeObjectLimits(), eZContentObjectPackageInstaller\initializeSiteAccess(), eZContentObjectPackageInstaller\initializeTopNodes(), eZURLOperator\iniTrans(), eZFilePackageHandler\install(), eZINIAddonPackageHandler\install(), eZContentObjectPackageHandler\installTemplates(), eZDbSchema\instance(), eZNotificationTransport\instance(), eZXMLInputType\instance(), eZUserLoginHandler\instance(), eZDB\instance(), eZArchiveHandler\instance(), eZUser\instance(), eZFileHandler\instance(), eZLocale\instance(), eZTemplateTreeCache\internalKey(), eZTemplateCompiler\isAccumulatorsEnabled(), eZTemplateTreeCache\isCacheEnabled(), eZTemplateCompiler\isCommentsEnabled(), eZTemplateCompiler\isCompilationEnabled(), eZContentObject\isComplexViewMode(), eZDebugSetting\isConditionTrue(), eZTemplateCompiler\isDevelopmentModeEnabled(), eZTemplateCompiler\isExecutionEnabled(), isExtensionSiteaccess(), eZTemplateCompiler\isFallbackResourceCodeEnabled(), eZSSLZone\isKeepModeView(), eZWebDAVServer\isLoggingEnabled(), eZTemplate\isMethodDebugEnabled(), eZTemplateCompiler\isNodePlacementEnabled(), eZINI\isSettingReadOnly(), eZSys\isSSLNow(), eZTemplate\isTemplatesUsageStatisticsEnabled(), eZTemplateCompiler\isTimingPointsEnabled(), eZTemplateCompiler\isTreeEnabled(), eZUser\isTrusted(), eZUser\isUserLoggedIn(), eZTemplate\isXHTMLCodeIncluded(), eZLintSchema\lintCheckSchema(), eZContentObjectPackageCreator\loadObjectLimits(), eZDBSchemaInterface\loadSchemaTransformationRules(), eZCodeMapper\loadTransformationFiles(), eZTSTranslator\loadTranslationFile(), eZLDAPUser\loginUser(), eZTextFileUser\loginUser(), eZUser\loginUser(), eZContentObjectTreeNode\makeObjectsArray(), eZCurrencyConverter\mathHandler(), eZContentBrowseRecent\maximumRecentItems(), eZUser\maxNumberOfFailedLogin(), eZAutoLinkOperator\modify(), eZSimpleTagsOperator\modify(), eZTopMenuOperator\modify(), eZTemplateImageOperator\modify(), eZTemplateUnitOperator\modify(), eZURLOperator\modify(), eZContentObjectTreeNodeOperations\move(), eZSearch\normalizeText(), eZDataType\objectDisplayInformation(), eZPHPCreator\open(), eZTemplateUnitOperator\operatorTransform(), eZMail\outputCharset(), eZTemplateDesignResource\overrideArray(), eZTemplateDesignResource\overrideKeys(), eZUser\passwordCharacterTable(), eZContentObjectTreeNode\pathWithNames(), precheckAllowed(), eZShopFunctions\preferredCurrencyCode(), eZSearchEngine\prepareWordIDArrays(), eZExtension\prependExtensionSiteAccesses(), eZExtension\prependSiteAccess(), eZContentLanguage\prioritizedLanguages(), eZTemplateCacheFunction\process(), eZLDAPUser\publishNewUserGroup(), eZLDAPUser\publishUpdateUser(), eZImageAnalyzer\readAnalyzerSettingsFromINI(), eZImageManager\readConversionRuleSettingsFromINI(), eZImageManager\readImageAliasesFromINI(), eZImageManager\readImageHandlersFromINI(), eZImageManager\readMIMETypeQualitySettingFromINI(), eZImageManager\readMIMETypeSettingFromINI(), eZImageManager\readMIMETypeSettingsFromINI(), eZImageManager\readSupportedFormatsFromINI(), eZInformationCollection\redirectURL(), eZContentOperationCollection\registerSearchObject(), eZProductCategory\remove(), eZContentObjectTreeNode\remove(), eZSearch\removeObject(), removeRelatedCache(), eZSubtreeCache\renameDir(), eZDBInterface\reportError(), eZImageVariation\requestVariation(), eZUser\requireUniqueEmail(), eZContentBrowse\result(), eZDBInterface\rollback(), eZCurrencyConverter\roundingPrecision(), eZCurrencyConverter\roundingTarget(), eZCurrencyConverter\roundingType(), eZSearch\search(), eZSearchEngine\search(), eZMailNotificationTransport\send(), eZMailTransport\send(), eZSMTPTransport\sendMail(), eZFileTransport\sendMail(), eZSendmailTransport\sendMail(), eZDefaultConfirmOrderHandler\sendOrderEmail(), eZInformationCollection\sendOutEmail(), eZSys\serverURL(), eZUserLoginHandler\sessionCleanup(), eZTemplateTreeCache\setCachedTree(), eZDebugSetting\setDebugINI(), eZContentOperationCollection\setObjectStatusPublished(), eZURI\setURIString(), eZContentObjectTreeNode\showInvisibleNodes(), eZUser\site(), eZSiteAccess\siteAccessList(), eZStepInstaller\siteaccessURLs(), eZScript\startup(), eZSys\storageDirectory(), eZHTTPFile\store(), eZContentCache\store(), eZImageInterface\store(), eZTemplateImageOperator\storeImage(), eZPackageType\storeObjectAttribute(), eZContentObjectTreeNode\subTreeCount(), eZSSLZone\switchIfNeeded(), templateInit(), eZTemplateCacheFunction\templateNodeTransformation(), eZTemplateCompiler\TemplatePrefix(), eZURLTranslator\translate(), eZURLAlias\translate(), eZURLAlias\translateByWildcard(), eZInformationCollection\typeForObject(), eZBinaryFileType\unserializeContentObjectAttribute(), eZMediaType\unserializeContentObjectAttribute(), eZScript\updateDebugSettings(), eZScript\updateTextCodecSettings(), eZContentUpload\upload(), eZURLOperator\urlTransformation(), eZInformationCollection\userDataHandling(), eZUserType\validateObjectAttributeHTTPInput(), eZUser\validatePassword(), eZSys\varDirectory(), eZTemplateStringOperator\wash(), eZTemplateStringOperator\washTransformation(), eZXMLInputParser\wordMatchSupport(), eZLog\write(), and eZLog\writeStorageLog().

$matchDB = count( $options['arguments'] ) >= 2 ? $options['arguments'][1] : ''
$matchDBHost = $options['match-host'] ? $options['match-host'] : $options['host']
$matchDBPassword = $options['match-password'] ? $options['match-password'] : $options['password']
$matchDBSocket = $options['match-socket'] ? $options['match-socket'] : $options['socket']
$matchDBUser = $options['match-user'] ? $options['match-user'] : $options['user']
$matchType = $options['match-type'] ? $options['match-type'] : $options['type']
$options
Initial value:
= $script->getOptions( "[source-type:][source-host:][source-user:][source-password;][source-socket:]" .
"[match-type:][match-host:][match-user:][match-password;][match-socket:]" .
"[t:|type:][host:][u:|user:][p:|password;][socket:]" .
"[lint-check]" .
"[reverse][check-only]",
"[source][match]",
array( 'source-type' => ( "Which database type to use for source, can be one of:\n" .
"mysql, postgresql" ),
'source-host' => "Connect to host source database",
'source-user' => "User for login to source database",
'source-password' => "Password to use when connecting to source database",
'source-socket' => 'Socket to connect to source database (only for MySQL)',
'match-type' => ( "Which database type to use for match, can be one of:\n" .
"mysql, postgresql" ),
'match-host' => "Connect to host match database",
'match-user' => "User for login to match database",
'match-password' => "Password to use when connecting to match database",
'match-socket' => 'Socket to connect to match database (only for MySQL)',
'type' => ( "Which database type to use for match and source, can be one of:\n" .
"mysql, postgresql" ),
'host' => "Connect to host match and source database",
'user' => "User for login to match and source database",
'password' => "Password to use when connecting to match and source database",
'socket' => 'Socket to connect to match and source database (only for MySQL)',
'reverse' => "Reverse the differences",
'check-only' => "Don't show SQLs for the differences, just set exit code and return"
) )
$script
Definition: clusterize.php:132
$script
Initial value:
=& eZScript::instance( array( 'description' => ( "eZ publish SQL diff\n\n" .
"Displays differences between two database schemas,\n" .
"and sets exit code based whether there is a difference or not\n" .
"\n" .
"ezsqldiff.php --type mysql --user=root stable32 stable33" ),
'use-session' => false,
'use-modules' => true,
'use-extensions' => true ) )
& instance($settings=array())
Definition: ezscript.php:1019
$sourceDB = $options['arguments'][0]
$sourceDBHost = $options['source-host'] ? $options['source-host'] : $options['host']
$sourceDBPassword = $options['source-password'] ? $options['source-password'] : $options['password']
$sourceDBSocket = $options['source-socket'] ? $options['source-socket'] : $options['socket']
$sourceDBUser = $options['source-user'] ? $options['source-user'] : $options['user']
$sourceSchema = loadDatabaseSchema( $sourceType, $sourceDBHost, $sourceDBUser, $sourceDBPassword, $sourceDBSocket, $sourceDB, $cli )
if (count($options['arguments'])< 1) if (count($options['arguments'])< 2 and!$options['lint-check']) $sourceType = $options['source-type'] ? $options['source-type'] : $options['type']
if ($options['reverse']) else
Initial value:
{
$matchDB
Definition: ezsqldiff.php:100
$matchType
Definition: ezsqldiff.php:95
$matchDBSocket
Definition: ezsqldiff.php:99
& loadDatabaseSchema($type, $host, $user, $password, $socket, $db, &$cli)
Definition: ezsqldiff.php:121
$matchDBPassword
Definition: ezsqldiff.php:98
$matchDBUser
Definition: ezsqldiff.php:97
$cli
Definition: clusterize.php:131
$matchDBHost
Definition: ezsqldiff.php:96
if
Initial value:
{
$differences = eZDbSchemaChecker::diff( $matchSchema->schema(), $sourceSchema->schema(), $matchType, $sourceType )
$matchType
Definition: ezsqldiff.php:95
diff($schema1, $schema2=array(), $schema1Type=false, $schema2Type=false)
Definition: ezdbschemachecker.php:50
if(count($options['arguments'])< 1) if(count($options['arguments'])< 2 and!$options['lint-check']) $sourceType
Definition: ezsqldiff.php:85
$sourceSchema
Definition: ezsqldiff.php:197

Referenced by Cpdf\output().