function migrate_example_wine_data_comment in Migrate 6.2

Same name and namespace in other branches

1. 7.2 migrate_example/wine.install.inc \migrate_example_wine_data_comment()

1 call to migrate_example_wine_data_comment()

migrate_example_wine_install in migrate_example/wine.install.inc

File

migrate_example/wine.install.inc, line 953

Set up for the wine (advanced) example.

Code

function migrate_example_wine_data_comment() {
  $data = array(
    array(
      1,
      1,
      NULL,
      'im first',
      'Tasty',
      'grace',
      'grace@example.com',
      0,
      '123.456.78.9',
      'http:://grace.example.com/',
      strtotime('2010-01-02 03:04:05'),
      strtotime('2010-04-05 06:07:08'),
    ),
    array(
      2,
      1,
      NULL,
      'im second',
      'Delicious',
      'horace',
      'horace@example.com',
      0,
      'example.com',
      NULL,
      strtotime('2010-02-02 03:04:05'),
      strtotime('2010-05-05 06:07:08'),
    ),
    array(
      3,
      1,
      NULL,
      'im parent',
      'Don\'t care for it',
      'irene',
      'irene@example.com',
      0,
      '254.0.2.5',
      'http:://www.example.com/irene',
      strtotime('2010-03-02 03:04:05'),
      strtotime('2010-03-02 03:04:05'),
    ),
    array(
      4,
      1,
      3,
      'im child',
      'But it\'s so good!',
      'emily',
      NULL,
      3,
      '58.29.126.1',
      'http:://www.wine.com/',
      strtotime('2010-01-02 03:04:05'),
      strtotime('2010-01-02 03:04:05'),
    ),
    array(
      5,
      1,
      4,
      'im grandchild',
      'Right on, Emily!',
      'thefonz@example.com',
      NULL,
      9,
      '123.456.78.9',
      NULL,
      strtotime('2010-06-02 03:04:05'),
      strtotime('2010-06-02 03:04:05'),
    ),
  );
  foreach ($data as $row) {
    db_query("INSERT INTO {migrate_example_wine_comment}\n              (commentid, wineid, comment_parent, subject, body, name, mail,\n               accountid, commenthost, userpage, posted, lastchanged)\n              VALUES(%d, %d, %d, '%s', '%s', '%s', '%s', %d, '%s', '%s', '%s', '%s')", $row);
  }
}