public function testLastID()
 {
     require __DIR__ . '/config/database_test.php';
     $db = new DatabaseConnection($host, $database, $user, $password);
     $insert_result = $db->query("INSERT INTO characters (id, name, description, type, dead, stage, hp) \r\n\t\t\tVALUES ('9999', 'Carla', 'The swordmaster of Melee Island', 'pirate', 'false',  '4',  '87');");
     $actual = $db->lastID();
     $expected = '9999';
     $delete_result = $db->query("DELETE FROM characters WHERE id = '9999'");
     $this->assertNotEmpty($actual, 'Function LastID returning empty value. Check TestDatabaseConnection::lastID()');
     $this->assertEquals($expected, $actual, 'Function LastID not returning expected value. Check TestDatabaseConnection::lastID()');
 }
예제 #2
0
 /**
  * Get the ID of the last row inserted
  * 
  * @throws StatusCodeException if was not success
  *
  * @param DatabaseConnection database class instance
  * @return string returns the id of the last row inserted
  */
 public static function lastID(DatabaseConnection $db)
 {
     return $db->lastID();
 }