All,
Is there a way to figure out the table prefix that Simpletest generates at runtime? I am trying to run a test that does a bunch of inserts, then I need to figure out how many rows were created in the table. However, I can't query the table because simpletest changes the name of it every time. Also, I tried {table_name} instead of table_name in the query but it didn't work (line numbers inserted below to help with reading the error message later):
21 public function test_sync () {
22 require_once(drupal_get_path('module','compoundmanagement').'/compoundmanagement.inc');
23 $result = db_query('select count(objdid) as count from {cpd_compounds}');
24 $row = $result->db_fetch_object($result);
25 $this->pass('There are '.$row->count.' compounds in cpd_compounds');
26 $this->drupalGet('sync_cpds',array('absolute' => TRUE));
27 $result = db_query('select count(objdid) as count from {cpd_compounds}');
28 $row = $result->db_fetch_object($result);
29 $this->pass('There are now '.$row->count.' compounds in cpd_compounds');
30 $this->assertEqual($row->count,1313,"CPD_COMPOUNDS should have 1313 rows.");
31 }
The test above threw this error:
An error occurred.
/batch?id=18&op=do
<br />
<b>Fatal error</b>: Call to a member function db_fetch_object() on a non-object in <b>C:\wamp\www\drupal\sites\all\modules\compoundmanagement\compoundmanagement.test</b> on line <b>24</b><br />
Any ideas what to do here? I have been developing in Drupal for a while now but am just now discovering the unit testing available in SimpleTest.
Best,
Dave
