Java EntityManager.createNativeQuery方法代码示例

import com.haulmont.cuba.core.EntityManager; //导入方法依赖的package包/类
@Override
public void clearScheduledTasks() {
    Transaction tx = persistence.createTransaction();
    try {
        EntityManager em = persistence.getEntityManager();

        Query query = em.createNativeQuery("delete from SYS_SCHEDULED_EXECUTION");
        query.executeUpdate();

        query = em.createNativeQuery("delete from SYS_SCHEDULED_TASK");
        query.executeUpdate();

        tx.commit();
    } finally {
        tx.end();
    }
}
 

import com.haulmont.cuba.core.EntityManager; //导入方法依赖的package包/类
protected void checkSequenceExists(String entityName, long startValue, long increment) {
    String seqName = getSequenceName(entityName);
    if (existingSequences.contains(seqName))
        return;

    // Create sequence in separate transaction because it's name is cached and we want to be sure it is created
    // regardless of possible errors in the invoking code
    Transaction tx = persistence.createTransaction(getDataStore(entityName));
    try {
        EntityManager em = persistence.getEntityManager(getDataStore(entityName));
        SequenceSupport sequenceSupport = getSequenceSupport(entityName);
        Query query = em.createNativeQuery(sequenceSupport.sequenceExistsSql(seqName));
        List list = query.getResultList();
        if (list.isEmpty()) {
            query = em.createNativeQuery(sequenceSupport.createSequenceSql(seqName, startValue, increment));
            query.executeUpdate();
        }
        existingSequences.add(seqName);

        tx.commit();
    } finally {
        tx.end();
    }
}
 

import com.haulmont.cuba.core.EntityManager; //导入方法依赖的package包/类
protected void checkSequenceExists(String domain) {
    String seqName = getSequenceName(domain);
    if (containsSequence(seqName))
        return;

    // Create sequence in separate transaction because it's name is cached and we want to be sure it is created
    // regardless of possible errors in the invoking code
    Transaction tx = persistence.createTransaction(getDataStore(domain));
    try {
        lock.readLock().unlock();
        lock.writeLock().lock();

        EntityManager em = persistence.getEntityManager(getDataStore(domain));

        Query query = em.createNativeQuery(getSequenceSupport(domain).sequenceExistsSql(seqName));
        List list = query.getResultList();
        if (list.isEmpty()) {
            query = em.createNativeQuery(getSequenceSupport(domain).createSequenceSql(seqName, 1, 1));
            query.executeUpdate();
        }
        tx.commit();
        existingSequences.add(seqName);
    } finally {
        lock.readLock().lock();
        lock.writeLock().unlock();
        tx.end();
    }
}
 

import com.haulmont.cuba.core.EntityManager; //导入方法依赖的package包/类
@Override
@Transactional(timeout = 2)
public String executeUpdateSql(String sql) {
    checkTestMode();

    log.info("started: " + sql);
    EntityManager em = persistence.getEntityManager();
    Query query = em.createNativeQuery(sql);
    query.executeUpdate();
    log.info("finished: " + sql);
    return "Done";
}
 

import com.haulmont.cuba.core.EntityManager; //导入方法依赖的package包/类
@Override
@Transactional(timeout = 2)
public String executeSelectSql(String sql) {
    checkTestMode();

    log.info("started: " + sql);
    EntityManager em = persistence.getEntityManager();
    Query query = em.createNativeQuery(sql);
    query.getResultList();
    log.info("finished: " + sql);
    return "Done";
}
 

import com.haulmont.cuba.core.EntityManager; //导入方法依赖的package包/类
@Test
public void testNativeQuery() {
    appender.clearMessages();
    assertEquals(0, queryCache.size());
    try (Transaction tx = cont.persistence().createTransaction()) {
        EntityManager em = cont.entityManager();
        TypedQuery<User> query = em.createNativeQuery("select * from SEC_USER", User.class);
        query.setCacheable(true);
        query.getResultList();
        tx.commit();
    }
    assertEquals(0, queryCache.size());
}
 

import com.haulmont.cuba.core.EntityManager; //导入方法依赖的package包/类
@After
public void tearDown() throws Exception {
    Transaction tx = cont.persistence().createTransaction();
    try {
        EntityManager em = cont.persistence().getEntityManager();

        Query q;

        q = em.createNativeQuery("delete from SEC_USER_ROLE where ID = ? or ID = ?");
        q.setParameter(1, userRole1Id.toString());
        q.setParameter(2, userRole2Id.toString());
        q.executeUpdate();

        q = em.createNativeQuery("delete from SEC_USER where ID = ?");
        q.setParameter(1, userId.toString());
        q.executeUpdate();

        q = em.createNativeQuery("delete from SEC_GROUP where ID = ?");
        q.setParameter(1, groupId.toString());
        q.executeUpdate();

        q = em.createNativeQuery("delete from SEC_PERMISSION where ID = ? or ID = ?");
        q.setParameter(1, permission1Id.toString());
        q.setParameter(2, permission2Id.toString());
        q.executeUpdate();

        q = em.createNativeQuery("delete from SEC_ROLE where ID = ? or ID = ?");
        q.setParameter(1, role1Id.toString());
        q.setParameter(2, role2Id.toString());
        q.executeUpdate();

        tx.commit();
    } finally {
        tx.end();
    }
}
 

import com.haulmont.cuba.core.EntityManager; //导入方法依赖的package包/类
@Before
public void setUp() throws Exception {
    cleanup();

    Transaction tx = cont.persistence().createTransaction();
    try {
        EntityManager em = cont.persistence().getEntityManager();

        Query q;
        q = em.createNativeQuery("delete from SEC_ENTITY_LOG");
        q.executeUpdate();

        LoggedEntity le = new LoggedEntity();
        le.setName("sec$User");
        le.setAuto(true);
        em.persist(le);

        LoggedAttribute la = new LoggedAttribute();
        la.setEntity(le);
        la.setName("email");
        em.persist(la);

        le = new LoggedEntity();
        le.setName("sec$Role");
        le.setAuto(true);
        em.persist(le);

        la = new LoggedAttribute();
        la.setEntity(le);
        la.setName("type");
        em.persist(la);

        tx.commit();
    } finally {
        tx.end();
    }

    entityLog = AppBeans.get(EntityLogAPI.NAME);
    entityLog.invalidateCache();
}
 

import com.haulmont.cuba.core.EntityManager; //导入方法依赖的package包/类
@After
public void tearDown() throws Exception {
    Transaction tx = cont.persistence().createTransaction();
    try {
        EntityManager em = cont.persistence().getEntityManager();
        Query q = em.createNativeQuery("delete from SEC_USER_SETTING where USER_ID = ?");
        q.setParameter(1, TestUserSessionSource.USER_ID);
        q.executeUpdate();
        tx.commit();
    } finally {
        tx.end();
    }
}