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:----RY6LX/vTjVkenA6p7BbzqF5Qr2flM7kOrUsyx+JOaItjEXe2szbAHLUrepnS/H3HZiH0+QEPfosXmBrE4us/5O0Z7cKbCSEtgw9+XUcgzdCoNeB0keEgYB8PMj/xzpPxd3HAqtwWIjKmfCI3f3k+imNakCLhaerhs8jIByo4xP5mVYjlMaR799n5rP1cQXIHqV6XO+5yUI+ss2bcft20L5L1ujowJwWHxzkkAKN8trL9zg2XVrCAqQAWWC2KV+WLEGahNLEiLX/XThICKo4u0VDcnYN7eSI1pKsoWksHHnyzgEa2twwbuu5T74r1UjKzQd2oSXQ/sFVYbOq/O6YZPxVzEESU6ARF5L9ce9o6wbrsVWKsK8ATeREdBchlhNslLCUH3PTS7Jmk4aL+szXSPmOWM4fpW4jSa1vEH4xSPi6dtHVAHPPuCQXaIy+c4uRwg36QIBF3NigjKlQ9/PnJ5qj7p0DKJOAD56BV4Msd1zXSTsTp8mcmLJ24lY+PZt0/prHpGAW/sfA6hQtf/KWgXI/+zRgyWmgeYbREUyYi+0u7YAl5dj6uIq4+EbvzGHEUPjWmb0xL6NBY9Ma5JVhCmMcI+JrWdVAnZtp9VpUzAvrJJWesg2pVfsIFkLe7oAy7kdlFo/lq34sn4td5krVUroZwMLy8mh1trBb7oli76qE=----ATTACHMENT:----Njc1NDk2NzY5MDMyNzgxMyAxNjQzMDg4MzYyMjAwNjE1IDg2OTgxOTY5OTM4NjczODY=