public function testis_self_referencing()
{
//unset and reconnect Db to resolve mysqli fetch exeception
global $db;
unset($db->database);
$db->checkConnection();
//test without setting any attributes
$relationship = new Relationship();
$result = $relationship->is_self_referencing();
$this->assertEquals(true, $result);
//test with attributes set to different values
$relationship = new Relationship();
$relationship->lhs_table = 'lhs_table';
$relationship->rhs_table = 'rhs_table';
$relationship->lhs_key = 'lhs_key';
$relationship->rhs_key = 'rhs_key';
$result = $relationship->is_self_referencing();
$this->assertEquals(false, $result);
//test with attributes set to same values
$relationship = new Relationship();
$relationship->lhs_table = 'table';
$relationship->rhs_table = 'table';
$relationship->lhs_key = 'key';
$relationship->rhs_key = 'key';
$result = $relationship->is_self_referencing();
$this->assertEquals(true, $result);
}
