setType($type); $this->database->query("SELECT , FROM WHERE != 100"); $this->assertQuery( <<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( <<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( <<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( <<queryString ); } }