/**
* 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());
}
