[development] Simpletest question

[Jennifer Hodgdon]

The table aliasing with {} should definitely work just fine in 
SimpleTest, or else nothing in Drupal would work. You probably have 
some other error. Do your queries work in PHPMyAdmin or in the MySQL 
command line, in the regular database where you know the table names??

That said, there's a global $db_prefix that gives you the database 
prefix (see settings.php and the db_prefix_tables function in 
includes/database.inc).

    --Jennifer

David Thibault wrote:
> 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 />

-- 
Jennifer Hodgdon * Poplar ProductivityWare
www.poplarware.com
Drupal, WordPress, and custom Web programming