/** * Temporary method for db interaction * * @param Db $db * @return Response */ public function databaseAction(Db $db) { $db->query('CREATE TABLE users(name varchar(255));'); $db->query('INSERT INTO users VALUES (?)', ['matthew']); $results = $db->first("SELECT * FROM users WHERE name = ?", ['matthew']); /** Psr7 example */ $stream = new Stream('php://memory', 'wb+'); $stream->write(json_encode($results)); return (new Response())->withStatus(200)->withBody($stream)->withHeader('Content-Type', 'application/json'); }
public function testCountsCorrectNumberOfExecutedQueries() { $statement = Mockery::mock('\\PDOStatement'); $statement->shouldReceive('execute')->once()->andReturnSelf(); $pdo = Mockery::mock('\\PDO'); $pdo->shouldReceive('prepare')->twice()->with('SELECT 1')->andReturn($statement); $conn = Mockery::mock('\\Fyuze\\Database\\Drivers\\ConnectionInterface'); $conn->shouldReceive('open')->once()->andReturn($pdo); $db = new Db($conn); $query = $db->query('SELECT 1'); $query = $db->query('SELECT 1'); $this->assertCount(2, $db->getQueries()); }