summaryrefslogtreecommitdiff
path: root/kolab.org/www/drupal-7.26/modules/simpletest/tests/upgrade/drupal-6.upload.database.php
diff options
context:
space:
mode:
Diffstat (limited to 'kolab.org/www/drupal-7.26/modules/simpletest/tests/upgrade/drupal-6.upload.database.php')
-rw-r--r--kolab.org/www/drupal-7.26/modules/simpletest/tests/upgrade/drupal-6.upload.database.php449
1 files changed, 449 insertions, 0 deletions
diff --git a/kolab.org/www/drupal-7.26/modules/simpletest/tests/upgrade/drupal-6.upload.database.php b/kolab.org/www/drupal-7.26/modules/simpletest/tests/upgrade/drupal-6.upload.database.php
new file mode 100644
index 0000000..46ebe2c
--- /dev/null
+++ b/kolab.org/www/drupal-7.26/modules/simpletest/tests/upgrade/drupal-6.upload.database.php
@@ -0,0 +1,449 @@
+<?php
+
+db_insert('files')->fields(array(
+ 'fid',
+ 'uid',
+ 'filename',
+ 'filepath',
+ 'filemime',
+ 'filesize',
+ 'status',
+ 'timestamp',
+))
+/*
+ * This entry is deliberately omitted to test the upgrade routine when facing
+ * possible data corruption.
+ *
+->values(array(
+ 'fid' => '1',
+ 'uid' => '1',
+ 'filename' => 'powered-blue-80x15.png',
+ 'filepath' => 'sites/default/files/powered-blue-80x15.png',
+ 'filemime' => 'image/png',
+ 'filesize' => '1011',
+ 'status' => '1',
+ 'timestamp' => '1285700240',
+)) */
+->values(array(
+ 'fid' => '2',
+ 'uid' => '1',
+ 'filename' => 'powered-blue-80x15.png',
+ 'filepath' => 'sites/default/files/powered-blue-80x15_0.png',
+ 'filemime' => 'image/png',
+ 'filesize' => '1011',
+ 'status' => '1',
+ 'timestamp' => '1285700317',
+))
+->values(array(
+ 'fid' => '3',
+ 'uid' => '1',
+ 'filename' => 'powered-blue-88x31.png',
+ 'filepath' => 'sites/default/files/powered-blue-88x31.png',
+ 'filemime' => 'image/png',
+ 'filesize' => '2113',
+ 'status' => '1',
+ 'timestamp' => '1285700343',
+))
+->values(array(
+ 'fid' => '4',
+ 'uid' => '1',
+ 'filename' => 'powered-blue-135x42.png',
+ 'filepath' => 'sites/default/files/powered-blue-135x42.png',
+ 'filemime' => 'image/png',
+ 'filesize' => '3027',
+ 'status' => '1',
+ 'timestamp' => '1285700366',
+))
+->values(array(
+ 'fid' => '5',
+ 'uid' => '1',
+ 'filename' => 'powered-black-80x15.png',
+ 'filepath' => 'sites/default/files/powered-black-80x15.png',
+ 'filemime' => 'image/png',
+ 'filesize' => '1467',
+ 'status' => '1',
+ 'timestamp' => '1285700529',
+))
+->values(array(
+ 'fid' => '6',
+ 'uid' => '1',
+ 'filename' => 'powered-black-135x42.png',
+ 'filepath' => 'sites/default/files/powered-black-135x42.png',
+ 'filemime' => 'image/png',
+ 'filesize' => '2817',
+ 'status' => '1',
+ 'timestamp' => '1285700552',
+))
+->values(array(
+ 'fid' => '7',
+ 'uid' => '1',
+ 'filename' => 'forum-hot-new.png',
+ 'filepath' => 'sites/default/files/forum-hot-new.png',
+ 'filemime' => 'image/png',
+ 'filesize' => '237',
+ 'status' => '1',
+ 'timestamp' => '1285708937',
+))
+->values(array(
+ 'fid' => '8',
+ 'uid' => '1',
+ 'filename' => 'forum-hot.png',
+ 'filepath' => 'sites/default/files/forum-hot.png',
+ 'filemime' => 'image/png',
+ 'filesize' => '229',
+ 'status' => '1',
+ 'timestamp' => '1285708944',
+))
+->values(array(
+ 'fid' => '9',
+ 'uid' => '1',
+ 'filename' => 'forum-new.png',
+ 'filepath' => 'sites/default/files/forum-new.png',
+ 'filemime' => 'image/png',
+ 'filesize' => '175',
+ 'status' => '1',
+ 'timestamp' => '1285708950',
+))
+->values(array(
+ 'fid' => '10',
+ 'uid' => '1',
+ 'filename' => 'forum-sticky.png',
+ 'filepath' => 'sites/default/files/forum-sticky.png',
+ 'filemime' => 'image/png',
+ 'filesize' => '329',
+ 'status' => '1',
+ 'timestamp' => '1285708957',
+))
+/*
+ * This is a case where the path is repeated twice.
+ */
+->values(array(
+ 'fid' => '11',
+ 'uid' => '1',
+ 'filename' => 'crazy-basename.png',
+ 'filepath' => '/drupal-6/file/directory/path/drupal-6/file/directory/path/crazy-basename.png',
+ 'filemime' => 'image/png',
+ 'filesize' => '329',
+ 'status' => '1',
+ 'timestamp' => '1285708958',
+))
+->execute();
+
+db_insert('node')->fields(array(
+ 'nid',
+ 'vid',
+ 'type',
+ 'language',
+ 'title',
+ 'uid',
+ 'status',
+ 'created',
+ 'changed',
+ 'comment',
+ 'promote',
+ 'moderate',
+ 'sticky',
+ 'tnid',
+ 'translate',
+))
+->values(array(
+ 'nid' => '38',
+ 'vid' => '50',
+ 'type' => 'page',
+ 'language' => '',
+ 'title' => 'node title 38 revision 50',
+ 'uid' => '1',
+ 'status' => '1',
+ 'created' => '1285603317',
+ 'changed' => '1285603317',
+ 'comment' => '0',
+ 'promote' => '0',
+ 'moderate' => '0',
+ 'sticky' => '0',
+ 'tnid' => '0',
+ 'translate' => '0',
+))
+->values(array(
+ 'nid' => '39',
+ 'vid' => '52',
+ 'type' => 'page',
+ 'language' => '',
+ 'title' => 'node title 39 revision 52',
+ 'uid' => '1',
+ 'status' => '1',
+ 'created' => '1285700317',
+ 'changed' => '1285700600',
+ 'comment' => '0',
+ 'promote' => '0',
+ 'moderate' => '0',
+ 'sticky' => '0',
+ 'tnid' => '0',
+ 'translate' => '0',
+))
+->values(array(
+ 'nid' => '40',
+ 'vid' => '53',
+ 'type' => 'page',
+ 'language' => '',
+ 'title' => 'node title 40 revision 53',
+ 'uid' => '1',
+ 'status' => '1',
+ 'created' => '1285709012',
+ 'changed' => '1285709012',
+ 'comment' => '0',
+ 'promote' => '0',
+ 'moderate' => '0',
+ 'sticky' => '0',
+ 'tnid' => '0',
+ 'translate' => '0',
+))
+ ->execute();
+
+db_insert('node_revisions')->fields(array(
+ 'nid',
+ 'vid',
+ 'uid',
+ 'title',
+ 'body',
+ 'teaser',
+ 'log',
+ 'timestamp',
+ 'format',
+))
+->values(array(
+ 'nid' => '38',
+ 'vid' => '50',
+ 'uid' => '1',
+ 'title' => 'node title 38 revision 50',
+ 'body' => "Attachments:\r\npowered-blue-80x15.png",
+ 'teaser' => "Attachments:\r\npowered-blue-80x15.png",
+ 'log' => '',
+ 'timestamp' => '1285603317',
+ 'format' => '1',
+))
+->values(array(
+ 'nid' => '39',
+ 'vid' => '51',
+ 'uid' => '1',
+ 'title' => 'node title 39 revision 51',
+ 'body' => "Attachments:\r\npowered-blue-80x15.png\r\npowered-blue-88x31.png\r\npowered-blue-135x42.png",
+ 'teaser' => "Attachments:\r\npowered-blue-80x15.png\r\npowered-blue-88x31.png\r\npowered-blue-135x42.png",
+ 'log' => '',
+ 'timestamp' => '1285700487',
+ 'format' => '1',
+))
+->values(array(
+ 'nid' => '39',
+ 'vid' => '52',
+ 'uid' => '1',
+ 'title' => 'node title 39 revision 52',
+ 'body' => "Attachments:\r\npowered-blue-88x31.png\r\npowered-black-80x15.png\r\npowered-black-135x42.png",
+ 'teaser' => "Attachments:\r\npowered-blue-88x31.png\r\npowered-black-80x15.png\r\npowered-black-135x42.png",
+ 'log' => '',
+ 'timestamp' => '1285700600',
+ 'format' => '1',
+))
+->values(array(
+ 'nid' => '40',
+ 'vid' => '53',
+ 'uid' => '1',
+ 'title' => 'node title 40 revision 53',
+ 'body' => "Attachments:\r\nforum-hot-new.png\r\nforum-hot.png\r\nforum-sticky.png\r\nforum-new.png\r\ncrazy-basename.png",
+ 'teaser' => "Attachments:\r\nforum-hot-new.png\r\nforum-hot.png\r\nforum-sticky.png\r\nforum-new.png\r\ncrazy-basename.png",
+ 'log' => '',
+ 'timestamp' => '1285709012',
+ 'format' => '1',
+))
+ ->execute();
+
+db_create_table('upload', array(
+ 'fields' => array(
+ 'fid' => array(
+ 'type' => 'int',
+ 'unsigned' => TRUE,
+ 'not null' => TRUE,
+ 'default' => 0,
+ ),
+ 'nid' => array(
+ 'type' => 'int',
+ 'unsigned' => TRUE,
+ 'not null' => TRUE,
+ 'default' => 0,
+ ),
+ 'vid' => array(
+ 'type' => 'int',
+ 'unsigned' => TRUE,
+ 'not null' => TRUE,
+ 'default' => 0,
+ ),
+ 'description' => array(
+ 'type' => 'varchar',
+ 'length' => 255,
+ 'not null' => TRUE,
+ 'default' => '',
+ ),
+ 'list' => array(
+ 'type' => 'int',
+ 'unsigned' => TRUE,
+ 'not null' => TRUE,
+ 'default' => 0,
+ 'size' => 'tiny',
+ ),
+ 'weight' => array(
+ 'type' => 'int',
+ 'not null' => TRUE,
+ 'default' => 0,
+ 'size' => 'tiny',
+ ),
+ ),
+ 'primary key' => array(
+ 'vid',
+ 'fid',
+ ),
+ 'indexes' => array(
+ 'fid' => array(
+ 'fid',
+ ),
+ 'nid' => array(
+ 'nid',
+ ),
+ ),
+ 'module' => 'upload',
+ 'name' => 'upload',
+));
+db_insert('upload')->fields(array(
+ 'fid',
+ 'nid',
+ 'vid',
+ 'description',
+ 'list',
+ 'weight',
+))
+->values(array(
+ 'fid' => '1',
+ 'nid' => '38',
+ 'vid' => '50',
+ 'description' => 'powered-blue-80x15.png',
+ 'list' => '1',
+ 'weight' => '0',
+))
+->values(array(
+ 'fid' => '2',
+ 'nid' => '39',
+ 'vid' => '51',
+ 'description' => 'powered-blue-80x15.png',
+ 'list' => '1',
+ 'weight' => '0',
+))
+->values(array(
+ 'fid' => '3',
+ 'nid' => '39',
+ 'vid' => '51',
+ 'description' => 'powered-blue-88x31.png',
+ 'list' => '1',
+ 'weight' => '0',
+))
+->values(array(
+ 'fid' => '4',
+ 'nid' => '39',
+ 'vid' => '51',
+ 'description' => 'powered-blue-135x42.png',
+ 'list' => '1',
+ 'weight' => '0',
+))
+->values(array(
+ 'fid' => '3',
+ 'nid' => '39',
+ 'vid' => '52',
+ 'description' => 'powered-blue-88x31.png',
+ 'list' => '1',
+ 'weight' => '0',
+))
+->values(array(
+ 'fid' => '5',
+ 'nid' => '39',
+ 'vid' => '52',
+ 'description' => 'powered-black-80x15.png',
+ 'list' => '1',
+ 'weight' => '0',
+))
+->values(array(
+ 'fid' => '6',
+ 'nid' => '39',
+ 'vid' => '52',
+ 'description' => 'powered-black-135x42.png',
+ 'list' => '1',
+ 'weight' => '0',
+))
+->values(array(
+ 'fid' => '7',
+ 'nid' => '40',
+ 'vid' => '53',
+ 'description' => 'forum-hot-new.png',
+ 'list' => '1',
+ 'weight' => '-4',
+))
+->values(array(
+ 'fid' => '8',
+ 'nid' => '40',
+ 'vid' => '53',
+ 'description' => 'forum-hot.png',
+ 'list' => '1',
+ 'weight' => '-3',
+))
+->values(array(
+ 'fid' => '10',
+ 'nid' => '40',
+ 'vid' => '53',
+ 'description' => 'forum-sticky.png',
+ 'list' => '1',
+ 'weight' => '-2',
+))
+->values(array(
+ 'fid' => '9',
+ 'nid' => '40',
+ 'vid' => '53',
+ 'description' => 'forum-new.png',
+ 'list' => '1',
+ 'weight' => '-1',
+))
+->values(array(
+ 'fid' => '11',
+ 'nid' => '40',
+ 'vid' => '53',
+ 'description' => 'crazy-basename.png',
+ 'list' => '1',
+ 'weight' => '0',
+))
+->execute();
+
+// Add series of entries for invalid node vids to the {upload} table.
+for ($i = 30; $i < 250; $i += 2) {
+ db_insert('upload')->fields(array(
+ 'fid',
+ 'nid',
+ 'vid',
+ 'description',
+ 'list',
+ 'weight',
+ ))
+ // Invalid fid, invalid vid.
+ ->values(array(
+ 'fid' => $i,
+ 'nid' => '40',
+ 'vid' => 24 + $i,
+ 'description' => 'crazy-basename.png',
+ 'list' => '1',
+ 'weight' => '0',
+ ))
+ // Valid fid, invalid vid.
+ ->values(array(
+ 'fid' => 2,
+ 'nid' => '40',
+ 'vid' => 24 + $i + 1,
+ 'description' => 'crazy-basename.png',
+ 'list' => '1',
+ 'weight' => '0',
+ ))
+ ->execute();
+}