X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/301fd7f7e8d97755849e26427c12eed070f21b5f..c4f22a42eba499ed1854c5967b2e3932fe9b3896:/test/php/Nominatim/DBTest.php diff --git a/test/php/Nominatim/DBTest.php b/test/php/Nominatim/DBTest.php index 8a3157a8..1c6f7637 100644 --- a/test/php/Nominatim/DBTest.php +++ b/test/php/Nominatim/DBTest.php @@ -1,4 +1,12 @@ assertRegExp( - '/unit_test/', - $unit_test_dsn, - 'Test database will get destroyed, thus should have a name like unit_test to be safe' - ); - ## Create the database. { $aDSNParsed = \Nominatim\DB::parseDSN($unit_test_dsn); @@ -159,31 +161,11 @@ class DBTest extends \PHPUnit\Framework\TestCase # Tables, Indices { - $this->assertEmpty($oDB->getListOfTables()); $oDB->exec('CREATE TABLE table1 (id integer, city varchar, country varchar)'); - $oDB->exec('CREATE TABLE table2 (id integer, city varchar, country varchar)'); - $this->assertEquals( - array('table1', 'table2'), - $oDB->getListOfTables() - ); - $this->assertTrue($oDB->deleteTable('table2')); - $this->assertTrue($oDB->deleteTable('table99')); - $this->assertEquals( - array('table1'), - $oDB->getListOfTables() - ); $this->assertTrue($oDB->tableExists('table1')); $this->assertFalse($oDB->tableExists('table99')); $this->assertFalse($oDB->tableExists(null)); - - $this->assertEmpty($oDB->getListOfIndices()); - $oDB->exec('CREATE UNIQUE INDEX table1_index ON table1 (id)'); - $this->assertEquals( - array('table1_index'), - $oDB->getListOfIndices() - ); - $this->assertEmpty($oDB->getListOfIndices('table2')); } # select queries