00001 <?php
00002
00003
00004
00005
00006
00007
00008
00009
00010
00011
00012
00013
00014
00015
00016
00017
00018
00019
00020
00021
00022
00023
00024
00025
00026
00027
00028
00029
00030
00031
00032
00033
00034
00035
00036
00037
00038
00039
00040 include_once( 'lib/ezxml/classes/ezxml.php' );
00041 include_once( 'kernel/classes/ezpackagehandler.php' );
00042
00043 class eZDBPackageHandler extends eZPackageHandler
00044 {
00045
00046
00047
00048 function eZDBPackageHandler()
00049 {
00050 $this->eZPackageHandler( 'ezdb' );
00051 }
00052
00053
00054
00055
00056 function install( &$package, $installType, $parameters,
00057 $name, $os, $filename, $subdirectory,
00058 &$content, $installParameters )
00059 {
00060 if ( $installType == 'sql' )
00061 {
00062 $path = $package->path();
00063 $databaseType = false;
00064 if ( isset( $parameters['database-type'] ) )
00065 $databaseType = $parameters['database-type'];
00066 $path .= '/' . eZDBPackageHandler::sqlDirectory();
00067 if ( $databaseType )
00068 $path .= '/' . $databaseType;
00069 if ( file_exists( $path ) )
00070 {
00071 $db =& eZDB::instance();
00072 $canInsert = true;
00073 if ( $databaseType and
00074 $databaseType != $db->databaseName() )
00075 $canInsert = false;
00076 if ( $canInsert )
00077 {
00078 eZDebug::writeDebug( "Installing SQL file $path/$filename" );
00079 $db->insertFile( $path, $filename, false );
00080 return true;
00081 }
00082 else
00083 eZDebug::writeDebug( "Skipping SQL file $path/$filename" );
00084 }
00085 else
00086 eZDebug::writeError( "Could not find SQL file $path/$filename" );
00087 }
00088 return false;
00089 }
00090
00091
00092
00093
00094 function add( $packageType, &$package, &$cli, $parameters )
00095 {
00096 if ( isset( $parameters['sql-file-list'] ) )
00097 {
00098 foreach ( $parameters['sql-file-list'] as $fileItem )
00099 {
00100 $package->appendInstall( 'sql', false, false, true,
00101 $fileItem['file'], false,
00102 array( 'path' => $fileItem['path'],
00103 'database-type' => $fileItem['database_type'],
00104 'copy-file' => true ) );
00105 if ( $fileItem['database_type'] )
00106 $package->appendDependency( 'requires',
00107 array( 'type' => 'ezdb',
00108 'name' => $fileItem['database_type'],
00109 'value' => false ) );
00110 $noticeText = "Adding " . $cli->stylize( 'mark', "sql" ) . " file " . $cli->stylize( 'file', $fileItem['path'] );
00111 if ( $fileItem['database_type'] )
00112 $noticeText .= " for database " . $cli->stylize( 'emphasize', $fileItem['database_type'] );
00113 $cli->notice( $noticeText );
00114 }
00115 }
00116 }
00117
00118 function handleAddParameters( $packageType, &$package, &$cli, $arguments )
00119 {
00120 return $this->handleParameters( $packageType, $package, $cli, 'add', $arguments );
00121 }
00122
00123 function handleParameters( $packageType, &$package, &$cli, $type, $arguments )
00124 {
00125 $sqlFileList = array();
00126 $currentType = false;
00127 $currentDatabaseType = false;
00128 if ( $packageType == 'sql' )
00129 {
00130 $currentType = 'sql';
00131 }
00132 for ( $i = 0; $i < count( $arguments ); ++$i )
00133 {
00134 $argument = $arguments[$i];
00135 if ( $argument[0] == '-' )
00136 {
00137 if ( strlen( $argument ) > 1 and
00138 $argument[1] == '-' )
00139 {
00140 }
00141 else
00142 {
00143 $flag = substr( $argument, 1, 1 );
00144 if ( $flag == 'd' )
00145 {
00146 if ( strlen( $argument ) > 2 )
00147 {
00148 $data = substr( $argument, 2 );
00149 }
00150 else
00151 {
00152 $data = $arguments[$i+1];
00153 ++$i;
00154 }
00155 if ( $flag == 'd' )
00156 {
00157 $currentDatabaseType = $data;
00158 }
00159 }
00160 }
00161 }
00162 else
00163 {
00164 if ( $currentType == 'sql' )
00165 {
00166 $sqlFile = $argument;
00167 $databaseType = $currentDatabaseType;
00168 $realFilePath = $this->sqlFileExists( $sqlFile, $databaseType,
00169 $triedFiles );
00170 if ( !$realFilePath )
00171 {
00172 $cli->error( "SQL file " . $cli->style( 'file' ) . $sqlFile . $cli->style( 'file-end' ) . " does not exist\n" .
00173 "The following files were searched for:\n" .
00174 implode( "\n", $triedFiles ) );
00175 return false;
00176 }
00177 $fileList[] = array( 'file' => $sqlFile,
00178 'database_type' => $databaseType,
00179 'path' => $realFilePath );
00180 }
00181 }
00182 }
00183 if ( count( $fileList ) == 0 )
00184 {
00185 $cli->error( "No files were added" );
00186 return false;
00187 }
00188 return array( 'sql-file-list' => $fileList );
00189 }
00190
00191 function sqlFileExists( &$sqlFile, &$databaseType,
00192 &$triedFiles )
00193 {
00194 $triedFiles = array();
00195 if ( file_exists( $sqlFile ) )
00196 {
00197 $filePath = $sqlFile;
00198 if ( preg_match( '#^.+/([^/]+$)#', $sqlFile, $matches ) )
00199 $sqlFile = $matches[1];
00200 return $filePath;
00201 }
00202 $filePath = 'kernel/sql/' . $databaseType . '/' . $sqlFile;
00203 if ( file_exists( $filePath ) )
00204 return $filePath;
00205 $triedFiles[] = $filePath;
00206 $filePath = 'kernel/sql/' . $databaseType . '/' . $sqlFile . '.sql';
00207 if ( file_exists( $filePath ) )
00208 {
00209 $sqlFile .= '.sql';
00210 return $filePath;
00211 }
00212 $triedFiles[] = $filePath;
00213 return false;
00214 }
00215
00216 function sqlDirectory()
00217 {
00218 return 'sql';
00219 }
00220
00221
00222
00223
00224 function createInstallNode( &$package, $export, &$installNode, $installItem, $installType )
00225 {
00226 if ( $installNode->attributeValue( 'type' ) == 'sql' )
00227 {
00228 if ( !$export )
00229 $installNode->appendAttribute( eZDOMDocument::createAttributeNode( 'original-path',
00230 $installItem['path'] ) );
00231 $installNode->appendAttribute( eZDOMDocument::createAttributeNode( 'database-type',
00232 $installItem['database-type'] ) );
00233 if ( $export )
00234 {
00235 $originalPath = $package->path() . '/' . eZDBPackageHandler::sqlDirectory();
00236 if ( $installItem['database-type'] )
00237 $originalPath .= '/' . $installItem['database-type'];
00238 $originalPath .= '/' . $installItem['filename'];
00239 $exportPath = $export['path'];
00240 $installDirectory = $exportPath . '/' . eZDBPackageHandler::sqlDirectory();
00241 if ( $installItem['database-type'] )
00242 $installDirectory .= '/' . $installItem['database-type'];
00243 if ( !file_exists( $installDirectory ) )
00244 eZDir::mkdir( $installDirectory, eZDir::directoryPermission(), true );
00245 eZFileHandler::copy( $originalPath, $installDirectory . '/' . $installItem['filename'] );
00246 }
00247 else if ( isset( $installItem['copy-file'] ) and $installItem['copy-file'] )
00248 {
00249 $originalPath = $installItem['path'];
00250 $installDirectory = $package->path() . '/' . eZDBPackageHandler::sqlDirectory();
00251 if ( $installItem['database-type'] )
00252 $installDirectory .= '/' . $installItem['database-type'];
00253 if ( !file_exists( $installDirectory ) )
00254 eZDir::mkdir( $installDirectory, eZDir::directoryPermission(), true );
00255 eZFileHandler::copy( $originalPath, $installDirectory . '/' . $installItem['filename'] );
00256 }
00257 }
00258 }
00259
00260
00261
00262
00263 function parseInstallNode( &$package, &$installNode, &$installParameters, $isInstall )
00264 {
00265 if ( $installNode->attributeValue( 'type' ) == 'sql' )
00266 {
00267 $installParameters['path'] = $installNode->attributeValue( 'original-path' );
00268 $installParameters['database-type'] = $installNode->attributeValue( 'database-type' );
00269 }
00270 }
00271 }
00272
00273 ?>