Example #1
0
 public function testSwapPrefix()
 {
     $query = new Query($this->db);
     $origPrefix = 'db_';
     $newPrefix = 'ci_';
     $origSQL = 'SELECT * FROM db_users WHERE db_users.id = 1';
     $newSQL = 'SELECT * FROM ci_users WHERE ci_users.id = 1';
     $query->setQuery($origSQL);
     $query->swapPrefix($origPrefix, $newPrefix);
     $this->assertEquals($newSQL, $query->getQuery());
 }