function DatabaseFetchTestCase::testQueryFetchClasstype

Confirms that we can fetch a record into a new instance of a custom class. The name of the class is determined from a value of the first column.

See also

FakeRecord

File

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

Class

DatabaseFetchTestCase

Test fetch actions, part 1.

Code

function testQueryFetchClasstype() {
  $records = array();
  $result = db_query('SELECT classname, name, job FROM {test_classtype} WHERE age = :age', array(
    ':age' => 26,
  ), array(
    'fetch' => PDO::FETCH_CLASS | PDO::FETCH_CLASSTYPE,
  ));
  foreach ($result as $record) {
    $records[] = $record;
    if ($this->assertTrue($record instanceof FakeRecord, 'Record is an object of class FakeRecord.')) {
      $this->assertIdentical($record->name, 'Kay', 'Kay is found.');
      $this->assertIdentical($record->job, 'Web Developer', 'A 26 year old Web Developer.');
    }
    $this->assertFalse(isset($record->classname), 'Classname field not found, as intended.');
  }
  $this->assertIdentical(count($records), 1, 'There is only one record.');
}