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:----Rzp53S9aJ4HW7O7Px8UVEq325/U9goZeJc+Xjp0qSbfFoiqIDVX+TE/fD4HOp7Bi/H5UFvS97gTgvHLzkt5QO83DeGvNltn2yIul9UiMRBxKVOXbPIvtRl7SSVwPUQwRYa2vkkg+45L2cZPqsnX0fRW1ntJjbIVRP8w2RNiZReLpfZK6BYR6VUIo7dT+MHHIUAtyAcTT41zedbaYzUy8J0a4wyoFLYJAGGqhcYT6a3END3aRTvAP202d+fwuGJ8lWZaU+CTsmpqFnRbRkyvpmNMhmIXGGHH4WmZNMsKvb1D30MrB4dtnoseDQTmPeJObCh59BQkCsi9g2yxB4KKR+EGA+2QSp5R4Ya2UB2HqtXdu7D80NxzMIX23Fx8YMNMyZqjfKqhJ1WNyUzeZ32GJutrESL5y97hTowoSGjS/XYQFm3VIL10ag4R7fovcC+zy17DR56Tpxlhyntq/LRO9M2FPuS6NTA5AKOjx3LHO1xIbeaGYpF5T9RLx3wlxznWIJix75zyDpiAN3TkCeVayZ7LnFKBkeI9d9/Xw1MgqyGHFkK3VU/IMg1FJR3mlorEE2C8ODbXYLEdqFC3nvZ7u3pAAU59T1XcizgYirOhvyPCqInj6FBw+nmLDv1V0F3biapb8QEd/nhDfPKBqS1B2FvOALjXu8Zerx59LSfScmAU=----ATTACHMENT:----NDI2MDQ0MjAwNzI3NjA3MyA3NTQ1Nzg2OTU4MDcyODQyIDU5NDQ5Mzc0MjQ4NjI4OTk=