123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345 |
- <?php
- /**
- * @file
- * Set up source data and destination configuration for the migration example
- * module. We do this in a separate module so migrate_example itself is a pure
- * migration module.
- */
- function migrate_example_setup_schema() {
- $schema['migrate_example_beer_account'] = migrate_example_beer_schema_account();
- $schema['migrate_example_beer_node'] = migrate_example_beer_schema_node();
- $schema['migrate_example_beer_comment'] = migrate_example_beer_schema_comment();
- $schema['migrate_example_beer_topic'] = migrate_example_beer_schema_topic();
- $schema['migrate_example_beer_topic_node'] = migrate_example_beer_schema_topic_node();
- return $schema;
- }
- function migrate_example_setup_install() {
- // Populate our tables.
- migrate_example_beer_data_account();
- migrate_example_beer_data_node();
- migrate_example_beer_data_comment();
- migrate_example_beer_data_topic();
- migrate_example_beer_data_topic_node();
- }
- function migrate_example_beer_schema_node() {
- return array(
- 'description' => 'Beers of the world.',
- 'fields' => array(
- 'bid' => array(
- 'type' => 'serial',
- 'not null' => TRUE,
- 'description' => 'Beer ID.',
- ),
- 'name' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- ),
- 'body' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => FALSE,
- 'description' => 'Full description of the beer.',
- ),
- 'excerpt' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => FALSE,
- 'description' => 'Abstract for this beer.',
- ),
- 'countries' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => FALSE,
- 'description' => 'Countries of origin. Multiple values, delimited by pipe',
- ),
- 'aid' => array(
- 'type' => 'int',
- 'not null' => FALSE,
- 'description' => 'Account Id of the author.',
- ),
- 'image' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => FALSE,
- 'description' => 'Image path',
- ),
- 'image_alt' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => FALSE,
- 'description' => 'Image ALT',
- ),
- 'image_title' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => FALSE,
- 'description' => 'Image title',
- ),
- 'image_description' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => FALSE,
- 'description' => 'Image description',
- ),
- ),
- 'primary key' => array('bid'),
- );
- }
- function migrate_example_beer_schema_topic() {
- return array(
- 'description' => 'Categories',
- 'fields' => array(
- 'style' => array(
- 'type' => 'varchar_ascii',
- 'length' => 255,
- 'not null' => TRUE,
- ),
- 'details' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => FALSE,
- ),
- 'style_parent' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => FALSE,
- 'description' => 'Parent topic, if any',
- ),
- 'region' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => FALSE,
- 'description' => 'Region first associated with this style',
- ),
- 'hoppiness' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => FALSE,
- 'description' => 'Relative hoppiness of the beer',
- ),
- ),
- 'primary key' => array('style'),
- );
- }
- function migrate_example_beer_schema_topic_node() {
- return array(
- 'description' => 'Beers topic pairs.',
- 'fields' => array(
- 'bid' => array(
- 'type' => 'int',
- 'not null' => TRUE,
- 'description' => 'Beer ID.',
- ),
- 'style' => array(
- 'type' => 'varchar_ascii',
- 'length' => 255,
- 'not null' => TRUE,
- 'description' => 'Topic name',
- ),
- ),
- 'primary key' => array('style', 'bid'),
- );
- }
- function migrate_example_beer_schema_comment() {
- return array(
- 'description' => 'Beers comments.',
- 'fields' => array(
- 'cid' => array(
- 'type' => 'serial',
- 'not null' => TRUE,
- 'description' => 'Comment ID.',
- ),
- 'bid' => array(
- 'type' => 'int',
- 'not null' => TRUE,
- 'description' => 'Beer ID that is being commented upon',
- ),
- 'cid_parent' => array(
- 'type' => 'int',
- 'not null' => FALSE,
- 'description' => 'Parent comment ID in case of comment replies.',
- ),
- 'subject' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => FALSE,
- 'description' => 'Comment subject',
- ),
- 'body' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => FALSE,
- 'description' => 'Comment body',
- ),
- 'name' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => FALSE,
- 'description' => 'Comment name (if anon)',
- ),
- 'mail' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => FALSE,
- 'description' => 'Comment email (if anon)',
- ),
- 'aid' => array(
- 'type' => 'int',
- 'not null' => FALSE,
- 'description' => 'Account ID (if any).',
- ),
- ),
- 'primary key' => array('cid'),
- );
- }
- function migrate_example_beer_schema_account() {
- return array(
- 'description' => 'Beers accounts.',
- 'fields' => array(
- 'aid' => array(
- 'type' => 'serial',
- 'not null' => TRUE,
- 'description' => 'Account ID',
- ),
- 'status' => array(
- 'type' => 'int',
- 'not null' => TRUE,
- 'description' => 'Blocked_Allowed',
- ),
- 'registered' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'description' => 'Registration date',
- ),
- 'username' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => FALSE,
- 'description' => 'Account name (for login)',
- ),
- 'nickname' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => FALSE,
- 'description' => 'Account name (for display)',
- ),
- 'password' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => FALSE,
- 'description' => 'Account password (raw)',
- ),
- 'email' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => FALSE,
- 'description' => 'Account email',
- ),
- 'sex' => array(
- 'type' => 'int',
- 'not null' => FALSE,
- 'description' => 'Gender (0 for male, 1 for female)',
- ),
- 'beers' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => FALSE,
- 'description' => 'Favorite Beers',
- ),
- ),
- 'primary key' => array('aid'),
- );
- }
- function migrate_example_beer_data_node() {
- $fields = array('bid', 'name', 'body', 'excerpt', 'countries', 'aid', 'image',
- 'image_alt', 'image_title', 'image_description');
- $query = db_insert('migrate_example_beer_node')
- ->fields($fields);
- // Use high bid numbers to avoid overwriting an existing node id.
- $data = array(
- array(99999999, 'Heineken', 'Blab Blah Blah Green', 'Green', 'Netherlands|Belgium', 0, 'heineken.jpg', 'Heinekin alt', 'Heinekin title', 'Heinekin description'), // comes with migrate_example project.
- array(99999998, 'Miller Lite', 'We love Miller Brewing', 'Tasteless', 'USA|Canada', 1, NULL, NULL, NULL, NULL),
- array(99999997, 'Boddington', 'English occasionally get something right', 'A treat', 'United Kingdom', 1, NULL, NULL, NULL, NULL),
- );
- foreach ($data as $row) {
- $query->values(array_combine($fields, $row));
- }
- $query->execute();
- }
- // Note that alice has duplicate username. Exercises dedupe_entity plugin.
- // @TODO duplicate email also.
- function migrate_example_beer_data_account() {
- $fields = array('status', 'registered', 'username', 'nickname', 'password', 'email', 'sex', 'beers');
- $query = db_insert('migrate_example_beer_account')
- ->fields($fields);
- $data = array(
- array(1, '2010-03-30 10:31:05', 'alice', 'alice in beerland', 'alicepass', 'alice@example.com', '1', '99999999|99999998|99999997'),
- array(1, '2010-04-04 10:31:05', 'alice', 'alice in aleland', 'alicepass', 'alice2@example.com', '1', '99999999|99999998|99999997'),
- array(0, '2007-03-15 10:31:05', 'bob', 'rebob', 'bobpass', 'bob@example.com', '0', '99999999|99999997'),
- array(1, '2004-02-29 10:31:05', 'charlie', 'charlie chocolate', 'mykids', 'charlie@example.com', '0', '99999999|99999998'),
- );
- foreach ($data as $row) {
- $query->values(array_combine($fields, $row));
- }
- $query->execute();
- }
- function migrate_example_beer_data_comment() {
- $fields = array('bid', 'cid_parent', 'subject', 'body', 'name', 'mail', 'aid');
- $query = db_insert('migrate_example_beer_comment')
- ->fields($fields);
- $data = array(
- array(99999998, NULL, 'im first', 'full body', 'alice', 'alice@example.com', 0),
- array(99999998, NULL, 'im second', 'aromatic', 'alice', 'alice@example.com', 0),
- array(99999999, NULL, 'im parent', 'malty', 'alice', 'alice@example.com', 0),
- array(99999999, 1, 'im child', 'cold body', 'bob', NULL, 1),
- array(99999999, 4, 'im grandchild', 'bitter body', 'charlie@example.com', NULL, 1),
- );
- foreach ($data as $row) {
- $query->values(array_combine($fields, $row));
- }
- $query->execute();
- }
- function migrate_example_beer_data_topic() {
- $fields = array('style', 'details', 'style_parent', 'region', 'hoppiness');
- $query = db_insert('migrate_example_beer_topic')
- ->fields($fields);
- $data = array(
- array('ale', 'traditional', NULL, 'Medieval British Isles', 'Medium'),
- array('red ale', 'colorful', 'ale', NULL, NULL),
- array('pilsner', 'refreshing', NULL, 'Pilsen, Bohemia (now Czech Republic)', 'Low'),
- );
- foreach ($data as $row) {
- $query->values(array_combine($fields, $row));
- }
- $query->execute();
- }
- function migrate_example_beer_data_topic_node() {
- $fields = array('bid', 'style');
- $query = db_insert('migrate_example_beer_topic_node')
- ->fields($fields);
- $data = array(
- array(99999999, 'pilsner'),
- array(99999999, 'red ale'),
- array(99999998, 'red ale'),
- );
- foreach ($data as $row) {
- $query->values(array_combine($fields, $row));
- }
- $query->execute();
- }
|