eZPublishCommunityProject(LegacyStack)  2013.9
ezconvertmysqltabletype.php File Reference

Namespaces

 kernel
 Autoloader definition for eZ Publish Kernel files.
 

Functions

 alterType ($db, $tableName, $newType)
 
 checkParameters ($cli, $script, $options, $host, $user, $password, $database, $listMode, $newType)
 Check whether the parameters are correctly set. More...
 
 connectToDatabase ($cli, $script, $host, $user, $password, $database)
 Connect to the database. More...
 
 copyTable ($db, $tableFrom, $tableTo)
 
 createTableStructure ($db, $tableFrom, $tableTo, $newType)
 
 dropTable ($db, $tableName)
 
 eZTriedDatabaseString ($database, $host, $user, $password)
 
 getTableType ($db, $tableName)
 
 listTypes ($cli, $db)
 
 renameTable ($db, $tableFrom, $tableTo)
 
 setNewType ($cli, $db, $newType, $usecopy)
 

Variables

 $cli = eZCLI::instance()
 
 $database = $options['database']
 
 $db = connectToDatabase( $cli, $script, $host, $user, $password, $database )
 
 $host = $options['host']
 
 $listMode = $options['list']
 
 $newType = $options["newtype"]
 
 $options
 
 $password = is_string( $options['password'] ) ? $options['password'] : ""
 
 $script
 
 $usecopy = $options["usecopy"]
 
 $user = $options['user']
 
if($listMode||!isset($newType)) else
 

Function Documentation

alterType (   $db,
  $tableName,
  $newType 
)

Referenced by setNewType().

checkParameters (   $cli,
  $script,
  $options,
  $host,
  $user,
  $password,
  $database,
  $listMode,
  $newType 
)

Check whether the parameters are correctly set.

connectToDatabase (   $cli,
  $script,
  $host,
  $user,
  $password,
  $database 
)

Connect to the database.

copyTable (   $db,
  $tableFrom,
  $tableTo 
)

Referenced by setNewType().

createTableStructure (   $db,
  $tableFrom,
  $tableTo,
  $newType 
)

Referenced by setNewType().

dropTable (   $db,
  $tableName 
)

Referenced by setNewType().

eZTriedDatabaseString (   $database,
  $host,
  $user,
  $password 
)

Referenced by connectToDatabase().

getTableType (   $db,
  $tableName 
)

Referenced by listTypes(), and setNewType().

listTypes (   $cli,
  $db 
)
renameTable (   $db,
  $tableFrom,
  $tableTo 
)

Referenced by setNewType().

setNewType (   $cli,
  $db,
  $newType,
  $usecopy 
)

Variable Documentation

$cli = eZCLI::instance()
$database = $options['database']
$db = connectToDatabase( $cli, $script, $host, $user, $password, $database )
$listMode = $options['list']
$newType = $options["newtype"]

Referenced by checkParameters(), and setNewType().

$options
Initial value:
= $script->getOptions( "[host:][user:][password:][database:][list][newtype:][usecopy]",
"",
array(
'list' => "List the table types",
'host' => "Connect to host database",
'user' => "User for login to the database",
'password' => "Password to use when connecting to the database",
'newtype' => "Convert the database to the given type.\nType can either be: myisam or innodb\n".
"Make sure that you have made a BACKUP UP of YOUR DATABASE!",
'usecopy' => "To convert the table we rename the original table and copy the data to the new table structure.\n".
"This conversion method is much slower and has a higher risk to corrupt the data in the database.\n".
"However this option may circumvent the MySQL crash on the ALTER query." )
)
$script
Definition: adddefaultstates.php:22
$script
Initial value:
= eZScript::instance( array( 'description' => ( "eZ Publish Database Converter\n\n" .
"Convert the database to the given type\n".
"ezconvertmysqltabletype.php [--host=VALUE --user=VALUE --database=VALUE [--password=VALUE]] [--list] [--newtype=TYPE] [--usecopy]" ),
'use-session' => false,
'use-modules' => false,
'use-extensions' => true ) )
static instance($settings=array())
Returns a shared instance of the eZScript class.
Definition: ezscript.php:1084
$usecopy = $options["usecopy"]

Referenced by setNewType().

$user = $options['user']

Referenced by eZDefaultShopAccountHandler\accountInformation(), eZDefaultShopAccountHandler\accountName(), eZUserOperationCollection\activation(), eZCollaborationItemMessageLink\addMessage(), eZGeneralDigestUserSettings\address(), eZContentObject\allowedAssignStateIDList(), eZContentObject\allowedAssignStateList(), eZSubTreeHandler\attribute(), eZWebDAVContentBackendAuth\authenticateBasic(), eZUser\authenticateHash(), eZWebDAVContentBackendAuth\authorize(), ezpRestClient\authorizeFor(), eZContentObject\cacheInfo(), eZContentObject\canCreateClassList(), eZContentObjectTreeNode\canCreateClassList(), eZContentObjectTreeNode\canEdit(), eZContentObject\canEdit(), eZContentClass\canInstantiateClassList(), eZOrder\canModifyStatus(), eZContentObject\canTranslate(), eZContentObjectVersion\checkAccess(), eZContentObject\checkAccess(), eZContentObjectTreeNode\checkAccess(), eZUserOperationCollection\checkActivation(), eZSubtreeNotificationRule\checkObjectAccess(), eZPackageCreationHandler\checkPackageMaintainer(), checkParameters(), checkTimeout(), eZUserLoginHandler\checkUser(), eZContentObject\classListFromPolicy(), eZContentObjectTreeNode\classListFromPolicy(), eZMySQLiDB\connect(), eZPostgreSQLDB\connectString(), connectToDatabase(), eZContentObject\copy(), eZContentObject\copyVersion(), eZCollaborationSimpleMessage\create(), eZRSSImport\create(), eZInformationCollection\create(), eZContentObjectVersion\create(), eZBasket\createOrder(), eZContentObjectTreeNode\createPermissionCheckingSQL(), eZUser\currentUser(), eZInformationCollection\currentUserIdentifier(), eZWishList\currentWishList(), databaseCleanup(), dfsCleanup(), eZDiscount\discountPercent(), eZWishList\discountPercent(), eZDefaultShopAccountHandler\email(), eZApproveType\execute(), eZMultiplexerType\execute(), eZDBInterface\eZDBInterface(), eZPostgreSQLDB\eZPostgreSQLDB(), eZTriedDatabaseString(), eZContentFunctionCollection\fetchBookmarks(), eZUserFunctionCollection\fetchCurrentUser(), eZGeneralDigestUserSettings\fetchForUser(), eZSubTreeHandler\fetchHttpInput(), eZUserFunctionCollection\fetchMemberOf(), eZUserType\fetchObjectAttributeHTTPInput(), eZCollaborationFunctionCollection\fetchParticipant(), eZContentFunctionCollection\fetchRecent(), eZUserDiscountRule\fetchUserID(), eZUserFunctionCollection\fetchUserRole(), ezpRestAuthConfiguration\filter(), eZUserOperationCollection\forgotpassword(), eZUserType\fromString(), eZContentCacheManager\generateObjectViewCache(), eZUser\generateUserCacheForFile(), eZInformationCollection\generateUserIdentifier(), eZNodeviewfunctions\generateViewCacheFile(), eZVATManager\getUserCountry(), eZApproveCollaborationHandler\handleCustomAction(), eZShopOperationCollection\handleUserCountry(), eZUserFunctionCollection\hasAccessTo(), eZUserType\hasObjectAttributeContent(), eZContentClass\initializeCopy(), eZStepCreateSites\initializePackage(), eZPackageCreationHandler\initializePackageChangelog(), eZPackageCreationHandler\initializePackageInformation(), eZPackageCreationHandler\initializePackageMaintainer(), eZCollaborationProfile\instance(), eZDB\instance(), eZContentClass\instantiate(), ezpRestClient\isAuthorizedByUser(), eZCollaborationGroup\itemCount(), loadDatabaseSchema(), eZUser\loginSucceeded(), eZLDAPUser\loginUser(), eZTextFileUser\loginUser(), eZUser\loginUser(), eZUserType\metaData(), eZTopMenuOperator\modify(), Cpdf\o_encryption(), eZAuthorType\objectAttributeContent(), eZUserType\objectAttributeContent(), eZSubtreeSubscriptionType\onPublish(), eZUserOperationCollection\password(), eZStepSiteAdmin\processPostData(), eZContentOperationCollection\publishNode(), eZLDAPUser\publishUpdateUser(), eZGeneralDigestUserSettings\removeByAddress(), eZUser\removeUser(), eZCollaborationNotificationHandler\rules(), eZSubTreeHandler\rules(), eZSubTreeHandler\rulesCount(), eZScriptTrashPurge\run(), eZTrigger\runTrigger(), eZUserOperationCollection\sendActivationEmail(), eZSMTPTransport\sendMail(), eZUserOperationCollection\sendUserNotification(), eZUserType\serializeContentObjectAttribute(), eZUserSetting\setAttribute(), eZUser\setCurrentlyLoggedInUser(), eZGeneralDigestHandler\settings(), eZVATManager\setUserCountry(), eZPreferences\setValue(), eZOrder\statusModificationList(), eZPDFExport\store(), eZRSSExport\store(), eZRSSImport\store(), eZUserType\storeObjectAttribute(), eZGeneralDigestHandler\storeSettings(), eZSubTreeHandler\subscribedNodes(), eZCollaborationGroup\subTree(), eZUserType\title(), eZUserType\toString(), eZUserType\unserializeContentObjectAttribute(), eZSiteInstaller\updateContentObjectAttributes(), eZPreferences\value(), eZPreferences\values(), and eZAudit\writeAudit().

if ($listMode||!isset($newType)) else
Initial value:
{
$db
Definition: adddefaultstates.php:36
$usecopy
Definition: ezconvertmysqltabletype.php:46
setNewType($cli, $db, $newType, $usecopy)
Definition: ezconvertmysqltabletype.php:225
$newType
Definition: ezconvertmysqltabletype.php:45
$cli
Definition: adddefaultstates.php:14