Functions
if(strlen(trim($type))==0) if(!$onlyCleanupSchema and(!file_exists($filename) or!is_file($filename))) if(strlen(trim($user))==0)	eZTriedDatabaseString ($database, $host, $user, $password, $socket)
Variables
	$cli = eZCLI::instance()
	$db
	$dbSchema = eZDbSchema::instance( $schemaArray )
switch(count($options['arguments']))	$dbschemaParameters
	$host = $options['host']
	$includeData = false
	$includeSchema = true
if($options['insert-types'])	$onlyCleanupSchema = $options['clean-existing'] && !$includeSchema && !$includeData
	$options
	$parameters
	$password = $options['password']
	$port = $options['port']
if(!is_object($db)) if(!$db or!$db->isConnected())	$schemaArray = eZDbSchema::read( $filename, true )
if($includeData and!$options['schema-file']) if($options['schema-file']) if($includeSchema and(!isset($schemaArray['schema']) or!$schemaArray['schema'])) if($schemaArray===false)	$schemaArray ['type'] = $type
if($options['clean-existing'])	$schemaArray ['instance'] = & $db
	$script
	$socket = $options['socket']
if($dbSchema===false)	$status = ( $includeSchema or $includeData ) ? $dbSchema->insertSchema( $dbschemaParameters ) : true
	$type = $options['type']
	$user = $options['user']

Function Documentation

if (strlen(trim($type))==0) if (!$onlyCleanupSchema and(!file_exists($filename) or!is_file($filename))) if (strlen(trim($user))==0) eZTriedDatabaseString	(	$	database,
		$	host,
		$	user,
		$	password,
		$	socket
	)

Definition at line 177 of file ezsqlinsertschema.php.

Variable Documentation

$cli = eZCLI::instance()

Definition at line 34 of file ezsqlinsertschema.php.

$db

Initial value:

 eZDB::instance( $type,
                       $parameters,
                       true )

Definition at line 210 of file ezsqlinsertschema.php.

$dbSchema = eZDbSchema::instance( $schemaArray )

Definition at line 293 of file ezsqlinsertschema.php.

switch (count($options['arguments'])) $dbschemaParameters

Initial value:

 array( 'schema' => $includeSchema,
                             'data' => $includeData,
                             'format' => 'local',
                             'table_type' => $options['table-type'],
                             'table_charset' => $options['table-charset'],
                             'allow_multi_insert' => $options['allow-multi-insert'] )

Definition at line 149 of file ezsqlinsertschema.php.

$host = $options['host']

Definition at line 73 of file ezsqlinsertschema.php.

$includeData = false

Definition at line 83 of file ezsqlinsertschema.php.

$includeSchema = true

Definition at line 82 of file ezsqlinsertschema.php.

if ($options['insert-types']) $onlyCleanupSchema = $options['clean-existing'] && !$includeSchema && !$includeData

Definition at line 119 of file ezsqlinsertschema.php.

$options

Initial value:

 $script->getOptions( "[type:][user:][host:][password;][port:][socket:]" .
                                "[table-type:][table-charset:]" .
                                "[insert-types:][allow-multi-insert][schema-file:][clean-existing]",
                                "[filename][database]",
                                array( 'type' => ( "Which database type to use, can be one of:\n" .
                                                   "mysql, postgresql or any other supported by extensions" ),
                                       'host' => "Connect to host source database",
                                       'user' => "User for login to source database",
                                       'password' => "Password to use when connecting to source database",
                                       'port' => 'Port to connect to source database',
                                       'socket' => 'Socket to connect to match and source database (only for MySQL)',
                                       'table-type' => ( "The table storage type to use for SQL output when creating tables.\n" .
                                                         "MySQL: bdb, innodb and myisam\n" .
                                                         "PostgreSQL: \n" .
                                                         "Oracle: " ),
                                       'clean-existing' => 'Clean up existing schema (remove all database objects)',
                                       'table-charset' => 'Defines the charset to use on tables, the names of the charset depends on database type',
                                       'schema-file' => 'The schema file to use when dumping data structures, is only required when dumping from files',
                                       'allow-multi-insert' => ( 'Will create INSERT statements with multiple data entries (applies to data output only)' . "\n" .
                                                                 'Multi-inserts will only be created for databases that support it' ),
                                       'insert-types' => ( "A comma separated list of types to include in dump (default is schema only):\n" .
                                                           "schema - Table schema\n" .
                                                           "data - Table data\n" .
                                                           "all - Both table schema and data\n" .
                                                           "none - Insert nothing (useful if you want to clean up schema only)" )
                                       ) )

Definition at line 44 of file ezsqlinsertschema.php.

$parameters

Initial value:

 array( 'server' => $host,
                     'user' => $user,
                     'password' => $password,
                     'database' => $database )

Definition at line 202 of file ezsqlinsertschema.php.

$password = $options['password']

Definition at line 76 of file ezsqlinsertschema.php.

$port = $options['port']

Definition at line 77 of file ezsqlinsertschema.php.

if (!is_object($db)) if (!$db or!$db->isConnected()) $schemaArray = eZDbSchema::read( $filename, true )

Definition at line 241 of file ezsqlinsertschema.php.

if ($includeData and!$options['schema-file']) if ($options['schema-file']) if ($includeSchema and(!isset($schemaArray['schema']) or!$schemaArray['schema'])) if ($schemaArray===false) $schemaArray['type'] = $type

Definition at line 273 of file ezsqlinsertschema.php.

if ($options['clean-existing']) $schemaArray['instance'] = & $db

Definition at line 292 of file ezsqlinsertschema.php.

$script

Initial value:

 eZScript::instance( array( 'description' => ( "eZ Publish SQL Schema insert\n\n" .
                                                        "Insert database schema and data to specified database\n".
                                                        "ezsqlinsertschema.php --type=mysql --user=root share/db_schema.dba ezp35stable" ),
                                     'use-session' => false,
                                     'use-modules' => true,
                                     'use-extensions' => true ) )

Definition at line 35 of file ezsqlinsertschema.php.

$socket = $options['socket']

Definition at line 75 of file ezsqlinsertschema.php.

if ($dbSchema===false) $status = ( $includeSchema or $includeData ) ? $dbSchema->insertSchema( $dbschemaParameters ) : true

Definition at line 302 of file ezsqlinsertschema.php.

Referenced by eZISBN10To13Converter\addAllClasses(), eZISBN10To13Converter\addAttribute(), eZISBN10To13Converter\addClass(), eZWorkflowProcess\advance(), eZImageManager\analyzeImage(), eZApproveType\checkApproveCollaboration(), eZMySQLiDB\checkCharsetPriv(), eZMySQLDB\checkCharsetPriv(), eZContentObjectVersion\cloneVersion(), eZMySQLDB\connect(), eZMySQLiDB\connect(), eZWebDAVFileServer\copy(), copyDir(), eZContentObject\copyVersion(), eZCollaborationItem\create(), eZContentObject\createNewVersion(), eZContentObject\createNewVersionIn(), delDir(), eZWebDAVFileServer\delete(), eZModuleOperationInfo\executeBody(), eZModuleOperationInfo\executeTrigger(), Cezpdf\ezInsertMode(), Cezpdf\ezPRVTaddPageNumbers(), eZRSSExportItem\fetch(), eZRSSImport\fetch(), eZRSSExport\fetch(), eZRSSExportItem\fetchFilteredList(), eZWorkflowProcess\fetchForStatus(), eZContentObjectVersion\fetchForUser(), eZRSSExport\fetchItems(), eZRSSImport\fetchList(), eZOrderStatusHistory\fetchOrderStatusName(), eZISBN13\formatedISBNValue(), eZSubTreeHandler\handle(), eZCollaborationNotificationHandler\handle(), eZWebDAVServer\handle(), eZApproveCollaborationHandler\handleCustomAction(), eZContentUpload\handleLocalFile(), eZContentUpload\handleUpload(), eZImageType\insertHTTPFile(), eZImageType\insertRegularFile(), eZDBSchemaInterface\insertSchema(), eZScript\iterate(), eZLintSchema\lintCheckSchema(), eZTSTranslator\loadTranslationFile(), eZWebDAVFileServer\mkcol(), eZWebDAVFileServer\move(), eZWebDAVServer\outputSendDataToClient(), eZWebDAVServer\processClientRequest(), eZWebDAVFileServer\put(), eZHTTPTool\redirect(), eZModule\runHooks(), eZModule\setRedirectStatus(), eZOrder\setStatus(), eZOrder\statusModificationList(), eZWorkflowType\statusName(), eZWorkflow\statusName(), eZApproveCollaborationHandler\unreadMessageCount(), eZContentObjectVersion\unserialize(), eZContentObject\validateInput(), eZISBNType\validateISBN13Checksum(), eZISBNType\validateObjectAttributeHTTPInput(), and eZObjectRelationListType\validateObjectAttributeHTTPInput().

$type = $options['type']

Definition at line 72 of file ezsqlinsertschema.php.

$user = $options['user']

Definition at line 74 of file ezsqlinsertschema.php.

Functions

Variables

Function Documentation

Variable Documentation