Example usage for org.hibernate Session delete

List of usage examples for org.hibernate Session delete

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.*
  5. Session
  6. delete

Introduction

In this page you can find the example usage for org.hibernate Session delete.

Prototype

void delete(Object object);

Source Link

Document

Remove a persistent instance from the datastore.

Usage

From source file:au.edu.uts.eng.remotelabs.schedserver.dataaccess.dao.tests.UserClassKeyDaoTester.java

License:Open Source License

@Test
public void testDeleteId() {
    Session db = DataAccessActivator.getNewSession();

    db.beginTransaction();/*w  ww  .  ja va 2  s. c o m*/

    UserClass uc = new UserClass();
    uc.setName("UC_Test");
    uc.setPriority((short) 1);
    uc.setTimeHorizon(0);
    db.persist(uc);

    UserClassKey key = new UserClassKey();
    key.setRemaining(1);
    key.setUserClass(uc);
    key.generateKey();
    db.persist(key);

    db.getTransaction().commit();

    int preDelete = (Integer) db.createCriteria(UserClassKey.class)
            .add(Restrictions.eq("redeemKey", key.getRedeemKey())).setProjection(Projections.rowCount())
            .uniqueResult();

    this.dao.delete(key.getId());

    int postDelete = (Integer) db.createCriteria(UserClassKey.class)
            .add(Restrictions.eq("redeemKey", key.getRedeemKey())).setProjection(Projections.rowCount())
            .uniqueResult();

    db.beginTransaction();
    db.delete(uc);
    db.getTransaction().commit();

    assertEquals(1, preDelete);
    assertEquals(0, postDelete);
}

From source file:au.edu.uts.eng.remotelabs.schedserver.dataaccess.dao.tests.UserClassKeyDaoTester.java

License:Open Source License

@Test
public void testDeleteWithConstRef() {
    Session db = DataAccessActivator.getNewSession();

    db.beginTransaction();//  w w  w.j a  va  2  s .  co m

    UserClass uc = new UserClass();
    uc.setName("UC_Test");
    uc.setPriority((short) 1);
    uc.setTimeHorizon(0);
    db.persist(uc);

    UserClassKey key = new UserClassKey();
    key.setRemaining(1);
    key.setUserClass(uc);
    key.generateKey();
    db.persist(key);

    UserClassKeyConstraint keyConst = new UserClassKeyConstraint();
    keyConst.setName("Const_1");
    keyConst.setValue("Value_1");
    keyConst.setClassKey(key);
    db.persist(keyConst);

    UserClassKeyConstraint keyConst2 = new UserClassKeyConstraint();
    keyConst2.setName("Const_2");
    keyConst2.setValue("Value_2");
    keyConst2.setClassKey(key);
    db.persist(keyConst2);

    db.getTransaction().commit();

    int preDelete = (Integer) db.createCriteria(UserClassKey.class)
            .add(Restrictions.eq("redeemKey", key.getRedeemKey())).setProjection(Projections.rowCount())
            .uniqueResult();

    int preRefCount = (Integer) db.createCriteria(UserClassKeyConstraint.class)
            .add(Restrictions.eq("classKey.id", key.getId())).setProjection(Projections.rowCount())
            .uniqueResult();

    this.dao.delete(this.dao.get(key.getId()));

    int postDelete = (Integer) db.createCriteria(UserClassKey.class)
            .add(Restrictions.eq("redeemKey", key.getRedeemKey())).setProjection(Projections.rowCount())
            .uniqueResult();

    int postRefCount = (Integer) db.createCriteria(UserClassKeyConstraint.class)
            .add(Restrictions.eq("classKey.id", key.getId())).setProjection(Projections.rowCount())
            .uniqueResult();

    db.beginTransaction();
    db.delete(uc);
    db.getTransaction().commit();

    assertEquals(1, preDelete);
    assertEquals(2, preRefCount);
    assertEquals(0, postDelete);
    assertEquals(0, postRefCount);
}

From source file:au.edu.uts.eng.remotelabs.schedserver.dataaccess.dao.tests.UserClassKeyDaoTester.java

License:Open Source License

@Test
public void testDeleteWithRedeemRef() {
    Session db = DataAccessActivator.getNewSession();

    db.beginTransaction();/* w  w w . j a  v  a2 s. c  om*/

    UserClass uc = new UserClass();
    uc.setName("UC_Test");
    uc.setPriority((short) 1);
    uc.setTimeHorizon(0);
    db.persist(uc);

    UserClassKey key = new UserClassKey();
    key.setRemaining(1);
    key.setUserClass(uc);
    key.generateKey();
    db.persist(key);

    User user = new User();
    user.setName("uck_test");
    user.setNamespace("TEST");
    user.setPersona("USER");
    db.persist(user);

    User user2 = new User();
    user2.setName("uck_test2");
    user2.setNamespace("TEST");
    user2.setPersona("USER");
    db.persist(user2);

    UserClassKeyRedemption redemp = new UserClassKeyRedemption();
    redemp.setClassKey(key);
    redemp.setUser(user);
    db.persist(redemp);

    UserClassKeyRedemption redemp2 = new UserClassKeyRedemption();
    redemp2.setClassKey(key);
    redemp2.setUser(user2);
    db.persist(redemp2);

    db.getTransaction().commit();

    int preDelete = (Integer) db.createCriteria(UserClassKey.class)
            .add(Restrictions.eq("redeemKey", key.getRedeemKey())).setProjection(Projections.rowCount())
            .uniqueResult();

    int preRefCount = (Integer) db.createCriteria(UserClassKeyRedemption.class)
            .add(Restrictions.eq("classKey.id", key.getId())).setProjection(Projections.rowCount())
            .uniqueResult();

    this.dao.delete(this.dao.get(key.getId()));

    int postDelete = (Integer) db.createCriteria(UserClassKey.class)
            .add(Restrictions.eq("redeemKey", key.getRedeemKey())).setProjection(Projections.rowCount())
            .uniqueResult();

    int postRefCount = (Integer) db.createCriteria(UserClassKeyRedemption.class)
            .add(Restrictions.eq("classKey.id", key.getId())).setProjection(Projections.rowCount())
            .uniqueResult();

    db.beginTransaction();
    db.delete(user);
    db.delete(user2);
    db.delete(uc);
    db.getTransaction().commit();

    assertEquals(1, preDelete);
    assertEquals(2, preRefCount);
    assertEquals(0, postDelete);
    assertEquals(0, postRefCount);
}

From source file:au.edu.uts.eng.remotelabs.schedserver.dataaccess.dao.tests.UserClassKeyDaoTester.java

License:Open Source License

@Test
public void testDeleteWithRefs() {
    Session db = DataAccessActivator.getNewSession();

    db.beginTransaction();//from   ww  w.ja  v  a 2  s.c  om

    UserClass uc = new UserClass();
    uc.setName("UC_Test");
    uc.setPriority((short) 1);
    uc.setTimeHorizon(0);
    db.persist(uc);

    UserClassKey key = new UserClassKey();
    key.setRemaining(1);
    key.setUserClass(uc);
    key.generateKey();
    db.persist(key);

    UserClassKeyConstraint keyConst = new UserClassKeyConstraint();
    keyConst.setName("Const_1");
    keyConst.setValue("Value_1");
    keyConst.setClassKey(key);
    db.persist(keyConst);

    UserClassKeyConstraint keyConst2 = new UserClassKeyConstraint();
    keyConst2.setName("Const_2");
    keyConst2.setValue("Value_2");
    keyConst2.setClassKey(key);
    db.persist(keyConst2);

    User user = new User();
    user.setName("uck_test");
    user.setNamespace("TEST");
    user.setPersona("USER");
    db.persist(user);

    User user2 = new User();
    user2.setName("uck_test2");
    user2.setNamespace("TEST");
    user2.setPersona("USER");
    db.persist(user2);

    UserClassKeyRedemption redemp = new UserClassKeyRedemption();
    redemp.setClassKey(key);
    redemp.setUser(user);
    db.persist(redemp);

    UserClassKeyRedemption redemp2 = new UserClassKeyRedemption();
    redemp2.setClassKey(key);
    redemp2.setUser(user2);
    db.persist(redemp2);

    db.getTransaction().commit();

    int preDelete = (Integer) db.createCriteria(UserClassKey.class)
            .add(Restrictions.eq("redeemKey", key.getRedeemKey())).setProjection(Projections.rowCount())
            .uniqueResult();

    int preConstRefCount = (Integer) db.createCriteria(UserClassKeyConstraint.class)
            .add(Restrictions.eq("classKey.id", key.getId())).setProjection(Projections.rowCount())
            .uniqueResult();

    int preRedempRefCount = (Integer) db.createCriteria(UserClassKeyRedemption.class)
            .add(Restrictions.eq("classKey.id", key.getId())).setProjection(Projections.rowCount())
            .uniqueResult();

    this.dao.delete(this.dao.get(key.getId()));

    int postDelete = (Integer) db.createCriteria(UserClassKey.class)
            .add(Restrictions.eq("redeemKey", key.getRedeemKey())).setProjection(Projections.rowCount())
            .uniqueResult();

    int postConstRefCount = (Integer) db.createCriteria(UserClassKeyConstraint.class)
            .add(Restrictions.eq("classKey.id", key.getId())).setProjection(Projections.rowCount())
            .uniqueResult();

    int postRedempRefCount = (Integer) db.createCriteria(UserClassKeyRedemption.class)
            .add(Restrictions.eq("classKey.id", key.getId())).setProjection(Projections.rowCount())
            .uniqueResult();

    db.beginTransaction();
    db.delete(user);
    db.delete(user2);
    db.delete(uc);
    db.getTransaction().commit();

    assertEquals(1, preDelete);
    assertEquals(2, preConstRefCount);
    assertEquals(2, preRedempRefCount);
    assertEquals(0, postDelete);
    assertEquals(0, postConstRefCount);
    assertEquals(0, postRedempRefCount);
}

From source file:au.edu.uts.eng.remotelabs.schedserver.dataaccess.dao.tests.UserDaoTester.java

License:Open Source License

@Test
public void testDeleteUser() {
    Session ses = DataAccessActivator.getNewSession();

    ses.beginTransaction();/*from  www  .ja  va  2s .com*/
    UserClass uc = new UserClass();
    uc.setName("test1");
    uc.setPriority((short) 10);
    uc.setActive(true);
    uc.setBookable(true);
    uc.setQueuable(true);
    uc.setUsersLockable(true);
    ses.save(uc);
    User us = new User("del1", "ns1", "ACADEMIC");
    ses.save(us);
    ses.getTransaction().commit();

    ses.beginTransaction();
    UserAssociation assoc = new UserAssociation();
    assoc.setUser(us);
    assoc.setUserClass(uc);
    UserAssociationId id = new UserAssociationId();
    id.setUserClassId(uc.getId());
    id.setUsersId(us.getId());
    assoc.setId(id);
    ses.save(assoc);
    ses.getTransaction().commit();

    this.dao.delete(us.getId());

    assertNull(this.dao.findByName("ns1", "test1"));

    ses.beginTransaction();
    ses.delete(uc);
    ses.getTransaction().commit();
}

From source file:au.edu.uts.eng.remotelabs.schedserver.dataaccess.dao.tests.UserLockDaoTester.java

License:Open Source License

@Test
public void testFindLock() {
    Session ses = DataAccessActivator.getNewSession();
    ses.beginTransaction();/* w  w w  . ja  va  2s  .  c  om*/
    User user = new User("locktest", "ns", "USER");
    ses.persist(user);
    UserClass userClass = new UserClass();
    userClass.setName("uc");
    ses.persist(userClass);
    ResourcePermission perm = new ResourcePermission();
    perm.setStartTime(new Date());
    perm.setExpiryTime(new Date());
    perm.setUserClass(userClass);
    perm.setType("RIG");
    ses.persist(perm);
    UserLock lock = new UserLock(user, perm, true, "abc123");
    ses.persist(lock);
    ses.getTransaction().commit();

    UserLock ld = this.dao.findLock(user, perm);
    assertNotNull(ld);
    assertEquals(lock.getId(), ld.getId());
    assertEquals(lock.getLockKey(), ld.getLockKey());
    assertEquals(lock.getUser().getName(), ld.getUser().getName());
    assertEquals(lock.getResourcePermission().getId(), ld.getResourcePermission().getId());

    ses.beginTransaction();
    ses.delete(lock);
    ses.delete(perm);
    ses.delete(userClass);
    ses.delete(user);
    ses.getTransaction().commit();
}

From source file:au.edu.uts.eng.remotelabs.schedserver.permissions.impl.tests.UserAdminTester.java

License:Open Source License

@Test
public void testEditUserNewPersona() {
    String name = "tuser";
    String ns = "tuserns";

    User user = new User(name, ns, User.ADMIN);
    Session ses = DataAccessActivator.getNewSession();
    ses.beginTransaction();// ww  w .  j a v  a  2s .  com
    ses.save(user);
    ses.getTransaction().commit();

    assertTrue(this.admin.editUser(user.getId(), ns, name, User.USER));

    ses.refresh(user);
    assertEquals(name, user.getName());
    assertEquals(ns, user.getNamespace());
    assertEquals(User.USER, user.getPersona());

    ses.beginTransaction();
    ses.delete(user);
    ses.getTransaction().commit();
}

From source file:au.edu.uts.eng.remotelabs.schedserver.permissions.impl.tests.UserAdminTester.java

License:Open Source License

@Test
public void testEditUserNoNameNoNSPersona() {
    String name = "tuser";
    String ns = "tuserns";

    User user = new User(name, ns, User.ADMIN);
    Session ses = DataAccessActivator.getNewSession();
    ses.beginTransaction();/*from  w  w  w. j a va  2  s. co  m*/
    ses.save(user);
    ses.getTransaction().commit();

    assertTrue(this.admin.editUser(user.getId(), null, null, User.USER));

    ses.refresh(user);
    assertEquals(name, user.getName());
    assertEquals(ns, user.getNamespace());
    assertEquals(User.USER, user.getPersona());

    ses.beginTransaction();
    ses.delete(user);
    ses.getTransaction().commit();
}

From source file:au.edu.uts.eng.remotelabs.schedserver.permissions.impl.tests.UserAdminTester.java

License:Open Source License

@Test
public void testDeleteUser() {
    Session ses = DataAccessActivator.getNewSession();

    ses.beginTransaction();//  w ww  .  jav  a2  s  .co m
    UserClass uc = new UserClass();
    uc.setName("test1");
    uc.setPriority((short) 10);
    uc.setActive(true);
    uc.setQueuable(true);
    uc.setBookable(true);
    uc.setUsersLockable(true);
    uc.setKickable(true);
    ses.save(uc);
    User us = new User("del1", "ns1", "ACADEMIC");
    ses.save(us);
    ses.getTransaction().commit();

    ses.beginTransaction();
    UserAssociation assoc = new UserAssociation();
    assoc.setUser(us);
    assoc.setUserClass(uc);
    UserAssociationId id = new UserAssociationId();
    id.setUserClassId(uc.getId());
    id.setUsersId(us.getId());
    assoc.setId(id);
    ses.save(assoc);
    ses.getTransaction().commit();

    this.admin.deleteUser(us.getId());

    assertNull(this.dao.findByName("ns1", "test1"));

    ses.beginTransaction();
    ses.delete(uc);
    ses.getTransaction().commit();
}

From source file:au.edu.uts.eng.remotelabs.schedserver.permissions.intf.tests.PermissionsSOAPImplTester.java

License:Open Source License

/**
 * Test method for {@link PermissionsSOAPImpl#getPermission(GetPermission)}.
 *///from   ww  w  .  ja  v a 2  s  .  c  om
@Test
public void testGetPermission() {
    Session ses = DataAccessActivator.getNewSession();
    ses.beginTransaction();
    UserClass uclass1 = new UserClass();
    uclass1.setName("permTestClass2");
    uclass1.setActive(true);
    uclass1.setQueuable(false);
    uclass1.setBookable(true);
    uclass1.setTimeHorizon(1000);
    ses.save(uclass1);
    RigType rigType1 = new RigType("interRigType1", 300, false);
    ses.save(rigType1);
    ResourcePermission perm1 = new ResourcePermission();
    perm1.setUserClass(uclass1);
    perm1.setType("TYPE");
    perm1.setSessionDuration(3600);
    perm1.setQueueActivityTimeout(300);
    perm1.setAllowedExtensions((short) 10);
    perm1.setSessionActivityTimeout(300);
    perm1.setExtensionDuration(300);
    perm1.setMaximumBookings(10);
    perm1.setRigType(rigType1);
    perm1.setStartTime(new Date());
    perm1.setExpiryTime(new Date());
    perm1.setDisplayName("display_name1");
    ses.save(perm1);
    ses.getTransaction().commit();

    GetPermission request = new GetPermission();
    PermissionIDType pid = new PermissionIDType();
    pid.setPermissionID(perm1.getId().intValue());
    request.setGetPermission(pid);

    GetPermissionResponse response = this.permissions.getPermission(request);

    ses.beginTransaction();
    ses.delete(perm1);
    ses.delete(rigType1);
    ses.delete(uclass1);
    ses.getTransaction().commit();

    assertNotNull(response);
    PermissionType p = response.getGetPermissionResponse();
    assertNotNull(p);

    /* User class. */
    UserClassIDType ucid = p.getUserClass();
    assertNotNull(ucid);
    assertEquals(uclass1.getId().intValue(), ucid.getUserClassID());
    assertEquals(uclass1.getName(), ucid.getUserClassName());

    assertEquals(ResourceClass._TYPE, p.getResourceClass().toString());
    ResourceIDType rid = p.getResource();
    assertNotNull(rid);
    assertEquals(rigType1.getId().intValue(), rid.getResourceID());
    assertEquals(rigType1.getName(), rid.getResourceName());

    assertFalse(p.canQueue());
    assertTrue(p.canBook());

    assertEquals(uclass1.getTimeHorizon(), p.getTimeHorizon());
    assertEquals(perm1.getMaximumBookings(), p.getMaxBookings());
    assertEquals(perm1.getSessionDuration(), p.getSessionDuration());
    assertEquals(perm1.getExtensionDuration(), p.getExtensionDuration());
    assertEquals(perm1.getAllowedExtensions(), p.getAllowedExtensions());
    assertEquals(perm1.getQueueActivityTimeout(), p.getQueueActivityTmOut());
    assertEquals(perm1.getSessionActivityTimeout(), p.getSessionActivityTmOut());
    assertEquals(perm1.getDisplayName(), p.getDisplayName());

    assertEquals(perm1.getStartTime().getTime() / 1000, p.getStart().getTimeInMillis() / 1000);
    assertEquals(perm1.getExpiryTime().getTime() / 1000, p.getExpiry().getTimeInMillis() / 1000);
}