END_OF_UPGRADE_HELP;
-require_once INSTALLDIR.'/scripts/commandline.inc';
+require_once INSTALLDIR.'/scripts/commandline.inc.php';
function main()
{
fixupFileGeometry();
deleteLocalFileThumbnailsWithoutFilename();
deleteMissingLocalFileThumbnails();
+ setFilehashOnLocalFiles();
initGroupProfileId();
initLocalGroup();
$schema = Schema::get();
$schemaUpdater = new SchemaUpdater($schema);
foreach (tableDefs() as $table => $def) {
- preAlterFixes($schemaUpdater, $table);
$schemaUpdater->register($table, $def);
}
$schemaUpdater->checkSchema();
printfnq("DONE.\n");
}
-function preAlterFixes($schemaUpdater, $table)
-{
- switch ($table) {
- case 'file':
- $schemadef = $schemaUpdater->schema->getTableDef($table);
- if (isset($schemadef['fields']['urlhash'])) {
- // We already have the urlhash field, so no need to migrate it.
- break;
- }
- printfnq("\nFound old $table table, upgrading it to contain 'urlhash' field...\n");
- // We have to create a urlhash that is _not_ the primary key,
- // transfer data and THEN run checkSchema
- $schemadef['fields']['urlhash'] = array (
- 'type' => 'varchar',
- 'length' => 64,
- 'description' => 'sha256 of destination URL after following redirections',
- );
- $schemaUpdater->schema->ensureTable($table, $schemadef);
- printfnq("DONE.\n");
-
- $filefix = new File();
- // urlhash is hash('sha256', $url) in the File table
- printfnq("Updating urlhash fields in $table table...\n");
- $filefix->query(sprintf('UPDATE %1$s SET %2$s=%3$s;',
- $schemaUpdater->schema->quoteIdentifier($table),
- 'urlhash',
- // The line below is "result of sha256 on column `url`"
- 'SHA2(url, 256)'));
- printfnq("DONE.\n");
- printfnq("Resuming core schema upgrade...");
- break;
- }
-}
-
function updateSchemaPlugins()
{
printfnq("Upgrading plugin schema...");
// Checking if there were any File_thumbnail entries without filename
if ($thumbs->find()) {
while ($thumbs->fetch()) {
- if (!file_exists(File_thumbnail::path($thumbs->filename))) {
+ try {
+ $thumbs->getPath();
+ } catch (FileNotFoundException $e) {
$thumbs->delete();
}
}
printfnq("DONE.\n");
}
+/*
+ * Files are now stored with their hash, so let's generate for previously uploaded files.
+ */
+function setFilehashOnLocalFiles()
+{
+ printfnq('Ensuring all local files have the filehash field set...');
+
+ $file = new File();
+ $file->whereAdd('filename IS NOT NULL'); // local files
+ $file->whereAdd('filehash IS NULL', 'AND'); // without filehash value
+
+ if ($file->find()) {
+ while ($file->fetch()) {
+ try {
+ $orig = clone($file);
+ $file->filehash = hash_file(File::FILEHASH_ALG, $file->getPath());
+ $file->update($orig);
+ } catch (FileNotFoundException $e) {
+ echo "\n WARNING: file ID {$file->id} does not exist on path '{$e->path}'. Clean up the file table?";
+ }
+ }
+ }
+
+ printfnq("DONE.\n");
+}
+
main();