/** @test */
public function it_tests_pagination()
{
User::create(['id' => 2, 'name' => 'User a 2', 'email' => '*****@*****.**']);
User::create(['id' => 3, 'name' => 'User a 3', 'email' => '*****@*****.**']);
User::create(['id' => 4, 'name' => 'User b 4', 'email' => '*****@*****.**']);
User::create(['id' => 5, 'name' => 'User b 5', 'email' => '*****@*****.**']);
User::create(['id' => 6, 'name' => 'User b 6', 'email' => '*****@*****.**']);
sleep(1);
$this->assertEquals(5, User::count());
$results = User::paginate(2);
$this->assertEquals(2, $results->count());
$this->assertNotNull($results->first()->name);
$this->assertEquals(5, $results->total());
}
/** @test */
public function it_tests_prepared_statements_without_params()
{
User::create(['id' => 2, 'name' => 'User a 2', 'email' => '*****@*****.**']);
User::create(['id' => 3, 'name' => 'User a 3', 'email' => '*****@*****.**']);
sleep(1);
$this->assertEquals(2, User::count());
$user_2 = DB::select('select * from t_users where id = 2');
$user_3 = DB::select('select * from t_users where id = 3');
$this->assertEquals(2, $user_2[0]['id']);
$this->assertEquals(3, $user_3[0]['id']);
$this->assertEquals('*****@*****.**', $user_2[0]['email']);
$this->assertEquals('*****@*****.**', $user_3[0]['email']);
}
