PHP werx\Core Database::getPrettyQueryLog Examples

Example #1

File: DatabaseTests.php Project: werx/core

 public function testGetPrettyQueries()
 {
     $this->databaseInitSimple();
     // run some queries
     \werx\Core\Tests\App\Models\Captain::search(['first_name' => 'James', 'last_name' => 'Picard']);
     \werx\Core\Tests\App\Models\Captain::search(['first_name' => 'Foo', 'last_name' => 'Bar']);
     $queries = Database::getPrettyQueryLog();
     $expected1 = 'select * from "captains" where "first_name" like \'James%\' and "last_name" like \'Picard%\'';
     $expected2 = 'select * from "captains" where "first_name" like \'Foo%\' and "last_name" like \'Bar%\'';
     $this->assertEquals($expected1, $queries[0]);
     $this->assertEquals($expected2, $queries[1]);
 }