Examples with EntityManager com.haulmont.cuba.core.EntityManager used on opensource projects

Example 96 with EntityManager

use of com.haulmont.cuba.core.EntityManager in project cuba by cuba-platform.

the class Emailer method markAsNonSent.

protected void markAsNonSent(SendingMessage sendingMessage) {
    try (Transaction tx = persistence.createTransaction()) {
        EntityManager em = persistence.getEntityManager();
        SendingMessage msg = em.merge(sendingMessage);
        msg.setStatus(SendingStatus.NOTSENT);
        msg.setAttemptsMade(msg.getAttemptsMade() + 1);
        tx.commit();
    } catch (Exception e) {
        log.error("Error marking message to '{}' as not sent", sendingMessage.getAddress(), e);
    }
}

Example 97 with EntityManager

use of com.haulmont.cuba.core.EntityManager in project cuba by cuba-platform.

the class Emailer method loadEmailsToSend.

protected List<SendingMessage> loadEmailsToSend() {
    Date sendTimeoutTime = DateUtils.addSeconds(timeSource.currentTimestamp(), -config.getSendingTimeoutSec());
    List<SendingMessage> emailsToSend = new ArrayList<>();
    try (Transaction tx = persistence.createTransaction()) {
        EntityManager em = persistence.getEntityManager();
        TypedQuery<SendingMessage> query = em.createQuery("select sm from sys$SendingMessage sm" + " where sm.status = :statusQueue or (sm.status = :statusSending and sm.updateTs < :time)" + " order by sm.createTs", SendingMessage.class);
        query.setParameter("statusQueue", SendingStatus.QUEUE.getId());
        query.setParameter("time", sendTimeoutTime);
        query.setParameter("statusSending", SendingStatus.SENDING.getId());
        View view = metadata.getViewRepository().getView(SendingMessage.class, "sendingMessage.loadFromQueue");
        // because SendingAttachment.content has FetchType.LAZY
        view.setLoadPartialEntities(true);
        query.setView(view);
        query.setMaxResults(config.getMessageQueueCapacity());
        List<SendingMessage> resList = query.getResultList();
        for (SendingMessage msg : resList) {
            if (shouldMarkNotSent(msg)) {
                msg.setStatus(SendingStatus.NOTSENT);
            } else {
                msg.setStatus(SendingStatus.SENDING);
                emailsToSend.add(msg);
            }
        }
        tx.commit();
    }
    for (SendingMessage message : emailsToSend) {
        loadBodyAndAttachments(message);
    }
    return emailsToSend;
}

Example 98 with EntityManager

use of com.haulmont.cuba.core.EntityManager in project cuba by cuba-platform.

the class FoldersServiceBean method importFolder.

@Override
public Folder importFolder(Folder parentFolder, byte[] bytes) throws IOException {
    if (!security.isEntityOpPermitted(Folder.class, EntityOp.CREATE)) {
        throw new AccessDeniedException(PermissionType.ENTITY_OP, Folder.class.getSimpleName());
    }
    Folder folder = null;
    ByteArrayInputStream byteArrayInputStream = new ByteArrayInputStream(bytes);
    ZipArchiveInputStream archiveReader;
    archiveReader = new ZipArchiveInputStream(byteArrayInputStream);
    ZipArchiveEntry archiveEntry;
    while (((archiveEntry = archiveReader.getNextZipEntry()) != null) && (folder == null)) {
        if (archiveEntry.getName().equals("folder.xml")) {
            String xml = new String(IOUtils.toByteArray(archiveReader), StandardCharsets.UTF_8);
            folder = (Folder) createXStream().fromXML(xml);
        }
    }
    byteArrayInputStream.close();
    if (folder != null) {
        checkImportPermissions(folder);
        folder.setParent(parentFolder);
        Transaction tx = persistence.createTransaction();
        try {
            EntityManager em = persistence.getEntityManager();
            em.setSoftDeletion(false);
            Folder existingFolder = em.find(Folder.class, folder.getId());
            if (existingFolder != null) {
                checkImportPermissions(existingFolder);
                folder.setVersion(existingFolder.getVersion());
                folder.setCreateTs(existingFolder.getCreateTs());
                folder.setCreatedBy(existingFolder.getCreatedBy());
            } else {
                User user = userSessionSource.getUserSession().getUser();
                folder.setCreatedBy(user.getLoginLowerCase());
                folder.setCreateTs(timeSource.currentTimestamp());
                folder.setUpdatedBy(null);
                folder.setUpdateTs(null);
                folder.setVersion(0);
            }
            em.merge(folder);
            tx.commit();
        } finally {
            tx.end();
        }
    }
    return folder;
}

Example 99 with EntityManager

use of com.haulmont.cuba.core.EntityManager in project cuba by cuba-platform.

the class NumberIdWorker method executeScript.

protected Object executeScript(String entityName, String sqlScript) {
    EntityManager em = persistence.getEntityManager(getDataStore(entityName));
    StrTokenizer tokenizer = new StrTokenizer(sqlScript, SequenceSupport.SQL_DELIMITER);
    Object value = null;
    Connection connection = em.getConnection();
    while (tokenizer.hasNext()) {
        String sql = tokenizer.nextToken();
        try {
            PreparedStatement statement = connection.prepareStatement(sql);
            try {
                if (statement.execute()) {
                    ResultSet rs = statement.getResultSet();
                    if (rs.next())
                        value = rs.getLong(1);
                }
            } finally {
                DbUtils.closeQuietly(statement);
            }
        } catch (SQLException e) {
            throw new IllegalStateException("Error executing SQL for getting next number", e);
        }
    }
    return value;
}

Example 100 with EntityManager

use of com.haulmont.cuba.core.EntityManager in project cuba by cuba-platform.

the class DbBasedCoordinator method isLastExecutionFinished.

@Override
public boolean isLastExecutionFinished(ScheduledTask task, long now) {
    EntityManager em = persistence.getEntityManager();
    Query query = em.createQuery("select e.finishTime from sys$ScheduledExecution e where e.task.id = ?1 and e.startTime = ?2");
    query.setParameter(1, task.getId());
    query.setParameter(2, task.getLastStartTime());
    List list = query.getResultList();
    if (list.isEmpty() || list.get(0) == null) {
        // Execution finish was not registered for some reason, so using timeout value or just return false
        boolean result = task.getTimeout() != null && (task.getLastStart() + task.getTimeout() * 1000) <= now;
        if (result)
            log.trace(task + ": considered finished because of timeout");
        else
            log.trace(task + ": not finished and not timed out");
        return result;
    }
    Date date = (Date) list.get(0);
    log.trace("{} : finished at {}", task, date.getTime());
    return true;
}