function DatabaseTestCase::addSampleData

Setup our sample data.

These are added using db_query(), since we're not trying to test the INSERT operations here, just populate.

File

modules/simpletest/tests/database_test.test, line 95

Database tests.

Class

DatabaseTestCase

Base test class for databases.

Code

function addSampleData() {
  // We need the IDs, so we can't use a multi-insert here.
  $john = db_insert('test')
    ->fields(array(
      'name' => 'John',
      'age' => 25,
      'job' => 'Singer',
    ))
    ->execute();

  $george = db_insert('test')
    ->fields(array(
      'name' => 'George',
      'age' => 27,
      'job' => 'Singer',
    ))
    ->execute();

  $ringo = db_insert('test')
    ->fields(array(
      'name' => 'Ringo',
      'age' => 28,
      'job' => 'Drummer',
    ))
    ->execute();

  $paul = db_insert('test')
    ->fields(array(
      'name' => 'Paul',
      'age' => 26,
      'job' => 'Songwriter',
    ))
    ->execute();

  db_insert('test_people')
    ->fields(array(
      'name' => 'Meredith',
      'age' => 30,
      'job' => 'Speaker',
    ))
    ->execute();

  db_insert('test_task')
    ->fields(array('pid', 'task', 'priority'))
    ->values(array(
      'pid' => $john,
      'task' => 'eat',
      'priority' => 3,
    ))
    ->values(array(
      'pid' => $john,
      'task' => 'sleep',
      'priority' => 4,
    ))
    ->values(array(
      'pid' => $john,
      'task' => 'code',
      'priority' => 1,
    ))
    ->values(array(
      'pid' => $george,
      'task' => 'sing',
      'priority' => 2,
    ))
    ->values(array(
      'pid' => $george,
      'task' => 'sleep',
      'priority' => 2,
    ))
    ->values(array(
      'pid' => $paul,
      'task' => 'found new band',
      'priority' => 1,
    ))
    ->values(array(
      'pid' => $paul,
      'task' => 'perform at superbowl',
      'priority' => 3,
    ))
    ->execute();

  db_insert('virtual')
    ->fields(array(
      'function' => 'Function value 1',
    ))
    ->execute();
}