public function testretrieve_by_sides()
{
//unset and reconnect Db to resolve mysqli fetch exeception
global $db;
unset($db->database);
$db->checkConnection();
$relationship = new Relationship();
//test with invalid relationship
$result = $relationship->retrieve_by_sides('test1', 'test2', $db);
$this->assertEquals(null, $result);
//test with valid relationship
$result = $relationship->retrieve_by_sides('Roles', 'Users', $db);
$this->assertEquals('Users', $result['rhs_module']);
$this->assertEquals('Roles', $result['lhs_module']);
$this->assertEquals('id', $result['rhs_key']);
$this->assertEquals('id', $result['lhs_key']);
$this->assertEquals('many-to-many', $result['relationship_type']);
}
