@Test
  public void testGetVmPoolMap() {
    vm_pool_map result = dao.getVmPoolMapByVmGuid(EXISTING_VM_ID);

    assertNotNull(result);
    assertEquals(existingVmPoolMap, result);
  }
  @Test
  public void testRemoveVmFromPool() {
    int before = dao.getVmPoolsMapByVmPoolId(existingVmPoolMap.getvm_pool_id()).size();

    dao.removeVmFromVmPool(EXISTING_VM_ID);

    int after = dao.getVmPoolsMapByVmPoolId(existingVmPoolMap.getvm_pool_id()).size();

    assertEquals(before - 1, after);

    vm_pool_map result = dao.getVmPoolMapByVmGuid(EXISTING_VM_ID);

    assertNull(result);
  }
  @Test
  public void testAddVmToPool() {
    int before = dao.getVmPoolsMapByVmPoolId(newVmPoolMap.getvm_pool_id()).size();

    dao.addVmToPool(newVmPoolMap);

    int after = dao.getVmPoolsMapByVmPoolId(newVmPoolMap.getvm_pool_id()).size();

    assertEquals(before + 1, after);

    vm_pool_map result = dao.getVmPoolMapByVmGuid(newVmPoolMap.getvm_guid());

    assertNotNull(result);
    assertEquals(newVmPoolMap, result);
  }
  @Override
  public void setUp() throws Exception {
    super.setUp();

    dao = prepareDAO(dbFacade.getVmPoolDAO());

    existingVmPool = dao.get(EXISTING_VM_POOL_ID);
    deletableVmPool = dao.get(DELETABLE_VM_POOL_ID);

    newVmPool = new vm_pools();
    newVmPool.setvm_pool_name("New VM Pool");
    newVmPool.setvm_pool_description("This is a new VM pool.");
    newVmPool.setvds_group_id(VDS_GROUP_ID);

    existingVmPoolMap = dao.getVmPoolMapByVmGuid(new Guid("77296e00-0cad-4e5a-9299-008a7b6f4355"));
    newVmPoolMap = new vm_pool_map(FREE_VM_ID, existingVmPool.getvm_pool_id());

    existingTimeLeaseVmPoolMap =
        dao.getTimeLeasedVmPoolMapByIdForVmPool(EXISTING_LEASE_ID, EXISTING_VM_POOL_ID);
    newTimeLeaseVmPoolMap =
        new time_lease_vm_pool_map(new Date(), Guid.NewGuid(), new Date(), 1, FREE_VM_POOL_ID);
  }