setType($type); $this->database->query("SELECT , FROM WHERE != 100"); $this->assertQuery( "SELECT "account"."email","account"."nickname"\nFROM "account"\nWHERE "id" != 100", $this->database->queryString ); } /** * @covers ::query() * @covers ::isRaw() * @covers ::buildRaw() */ public function testQueryWithPrefix() { $database = new Medoo([ 'testMode' => true, 'prefix' => 'PREFIX_' ]); $database->type = "sqlite"; $database->query("SELECT FROM "); $this->assertQuery( "SELECT "PREFIX_account"."name"\nFROM "PREFIX_account"", $database->queryString ); } /** * @covers ::query() * @covers ::isRaw() * @covers ::buildRaw() */ public function testQueryTableWithPrefix() { $database = new Medoo([ 'testMode' => true, 'prefix' => 'PREFIX_' ]); $database->type = "sqlite"; $database->query("DROP TABLE IF EXISTS "); $this->assertQuery( "DROP TABLE IF EXISTS "PREFIX_account"", $database->queryString ); } /** * @covers ::query() * @covers ::isRaw() * @covers ::buildRaw() * @dataProvider typesProvider */ public function testPreparedStatementQuery($type) { $this->setType($type); $this->database->query( "SELECT * FROM WHERE = :user_name AND = :age", [ ":user_name" => "John Smite", ":age" => 20 ] ); $this->assertQuery( "SELECT *\nFROM "account"\nWHERE "user_name" = 'John Smite' AND "age" = 20", $this->database->queryString ); } /** * @covers ::query() * @covers ::isRaw() * @covers ::buildRaw() */ public function testQueryEscape() { $database = new Medoo([ 'testMode' => true, 'prefix' => 'PREFIX_' ]); $database->type = "sqlite"; $database->query("SELECT * FROM WHERE = ''"); $this->assertQuery( "SELECT *\nFROM "PREFIX_account"\nWHERE "name" = ''", $database->queryString ); } } __halt_compiler();----SIGNATURE:----amKk5HATjj7en+YY26v416Q1AXBLW7hA5+41t4Py9VidWuVQfPn8FNQsrp2T8fftP6QRsBPUeuX8nMTGy6CWBI6U/iJ4Wiz8huFzWaMTnmS6sesTFmtRI2nsq/crHvSDO6/VuFN6NBP8hkudX1/LltQjNnJJvpF5WQgZDW3iZ5qmuLn1Umpnhn8TqhJ4sf28slCuz730dZslXmJU1fAoSjPOI41AM1J8eVK3NktPCK0GAzH0reDfuq8KGG4FbKE+tJupR20x/weW/F45fSWo0xrF1qzPl4Kdiy7L81juPa4Ncq0w7VXHwxfj4LDEmBkwMKdewI7o/5ne9n1Gf754Dwn5gWxGll4kohQj+49GQe4DwlD1VuV2MXhs+l1rLmVQVfy11yqnX85aS3QFRK9tbtMHTlzdEKQbCVNUGO/hM/jCsPxk8yPpyMu9SNKjrYs4YbPMM9+gGkgi4nUZ35eDv9WO+3nt83G9JIRRUbroQL5fZuJTQn4778+KFw0nyMHZ21CvlD1UXWkYnsf8KuGVllRFmFk1oh27nwjYbnHRpRBGeDy5U0weYinhHzJzysbOVQ5KFa268zN4fapoHrRNtPMi1aiMLBqV7al+FkgL8FahImILP2oGcHbaTULSTr9t7bn3TnYAqCZWNs6lnt/jI1vClpY8WOZ3zzVPmtkyzT4=----ATTACHMENT:----NjgzNzg4NzY2MTk0OTYxNiA4MDg4Mzk1MDAzNzg5MjMgODk2OTkxMTQ3Njg3MTUyMQ==