Java SQLUpdateClause.execute方法代码示例

import com.mysema.query.sql.dml.SQLUpdateClause; //导入方法依赖的package包/类
@Override
@Transactional(readOnly=false)
public void updateInitiative(InitiativeManagement initiative, Long userId, boolean basic, boolean extra) {
    Assert.notNull(initiative, "initiative");
    Assert.notNull(userId, "userId");

    Long initiativeId = initiative.getId();
    Assert.notNull(initiativeId, "initiative.id");

    SQLUpdateClause update = queryFactory.update(qInitiative);
    populateInitiative(update, initiative, userId, basic, extra);
    update.where(qInitiative.id.eq(initiative.getId()));
    
    if (update.execute() != 1) {
        throw new NotFoundException(qInitiative.getTableName(), initiative.getId());
    } 
}
 

import com.mysema.query.sql.dml.SQLUpdateClause; //导入方法依赖的package包/类
private void updateLink(Link link, Long initiativeId) {
    Long linkId = link.getId();
    Assert.notNull(linkId, "link.id");

    SQLUpdateClause update = queryFactory
            .update(qInitiativeLink)
            .where(
                    qInitiativeLink.id.eq(linkId),
                    qInitiativeLink.initiativeId.eq(initiativeId) // Defensive... 
                );
    populateLink(update, link);
    
    if (update.execute() != 1) {
        throw new NotFoundException(qInitiativeLink.getTableName(), linkId);
    }
}
 

import com.mysema.query.sql.dml.SQLUpdateClause; //导入方法依赖的package包/类
private void updateUnsentInvitation(Long initiativeId, Invitation invitation) {
    if (invitation.getSent() == null) {
        Long invitationId = invitation.getId();
        Assert.notNull(invitationId, "invitation.id");

        SQLUpdateClause update = queryFactory
                .update(qInvitation)
                .where(
                        qInvitation.id.eq(invitationId),
                        qInvitation.initiativeId.eq(initiativeId) // Defensive... 
                    );
        update.set(qInvitation.email, invitation.getEmail());
        
        if (update.execute() != 1) {
            throw new NotFoundException(qInitiativeLink.getTableName(), invitationId);
        }
    }
}
 

import com.mysema.query.sql.dml.SQLUpdateClause; //导入方法依赖的package包/类
@Override
@Transactional(readOnly=false)
public void updateInvitationSent(Long initiativeId, Long invitationId, String invitationCode) {
    Assert.notNull(initiativeId, "initiativeId");
    Assert.notNull(invitationId, "invitationId");
    Assert.notNull(invitationCode, "invitationCode");

    SQLUpdateClause update = queryFactory
            .update(qInvitation)
            .where(
                    qInvitation.id.eq(invitationId),
                    qInvitation.initiativeId.eq(initiativeId),  // Defensive... 
                    qInvitation.sent.isNull()
                );
    update.set(qInvitation.sent, CURRENT_TIME);
    update.set(qInvitation.invitationcode, invitationCode);
    
    if (update.execute() != 1) {
        throw new NotFoundException(qInvitation.getTableName(), invitationId);
    }
}
 

import com.mysema.query.sql.dml.SQLUpdateClause; //导入方法依赖的package包/类
@Override
public void saveAndUnlock(final String numberName, final long current) {
	SQLUpdateClause update = queryFactory.update(nm);
	update.set(nm.currentValue, current);
	update.set(nm.lockVersion, nm.lockVersion.add(1));
	update.where(nm.name.eq(numberName), nm.deletedFlg.eq(DeletedFlag.NOT_DELETED.code()));
	long count = update.execute();
	checkState(count == 1, "Failed to update %s: name=%s, currentValue=%s, count=%s", nm.getTableName(),
			numberName, current, count);
}
 

import com.mysema.query.sql.dml.SQLUpdateClause; //导入方法依赖的package包/类
@Override
public void finishMessage(long messageId) {

	SQLUpdateClause update = queryFactory.update(ml);
	update.set(ml.mailStatus, FlagCode.TRUE.code());
	update.set(ml.sentAt, bizDateTime.now());
	update.set(ml.lockVersion, ml.lockVersion.add(1));
	update.where(ml.id.eq(messageId), ml.deletedFlg.eq(DeletedFlag.NOT_DELETED.code()));
	long count = update.execute();
	checkState(count == 1L, "failed to update QMailLog: id=%s, mailStatus=%s", messageId, FlagCode.TRUE.code());

	long c = queryFactory.delete(mq)
			.where(mq.mailId.eq(messageId), mq.deletedFlg.eq(DeletedFlag.NOT_DELETED.code())).execute();
	checkState(c == 1L, "failed to delete QMailQueue: mailId=%s", messageId);
}
 

import com.mysema.query.sql.dml.SQLUpdateClause; //导入方法依赖的package包/类
@Override
@Transactional(readOnly = false)
public void updateSendToParliament(Long initiativeId, SendToParliamentData data) {
    SQLUpdateClause update = queryFactory.update(qInitiative)
            .set(qInitiative.parliamentidentifier, data.getParliamentIdentifier())
            .set(qInitiative.parliamentsenttime, data.getParliamentSentTime())
            .set(qInitiative.parliamenturl, data.getParliamentURL())
            .set(qInitiative.state, InitiativeState.DONE)
            .set(qInitiative.statedate, CURRENT_TIME)
            .where(qInitiative.id.eq(initiativeId));

    if (update.execute() != 1) {
        throw new NotFoundException(qInitiative.getTableName(), initiativeId);
    }
}
 

import com.mysema.query.sql.dml.SQLUpdateClause; //导入方法依赖的package包/类
@Override
public void endInitiative(Long initiativeId, LocalDate lastRunningDate) {
    SQLUpdateClause update = queryFactory.update(qInitiative)
            .set(qInitiative.enddate, lastRunningDate)
            .where(qInitiative.id.eq(initiativeId));

    if (update.execute() != 1) {
        throw new NotFoundException(qInitiative.getTableName(), initiativeId);
    }
}
 

import com.mysema.query.sql.dml.SQLUpdateClause; //导入方法依赖的package包/类
@Override
@Transactional(readOnly=false)
public void clearConfirmations(Long initiativeId, Long userId) {
    Expression<DateTime> confirmed = new CaseBuilder()
        .when(qAuthor.userId.eq(userId))
        .then(CURRENT_TIME)
        .otherwise(NULL_TIME);

    SQLUpdateClause update = queryFactory.update(qAuthor)
        .set(qAuthor.confirmed, confirmed)
        .set(qAuthor.confirmationrequestsent, NULL_TIME)
        .where(qAuthor.initiativeId.eq(initiativeId));

    update.execute();
}
 

import com.mysema.query.sql.dml.SQLUpdateClause; //导入方法依赖的package包/类
@Override
@Transactional(readOnly=false)
public void updateConfirmationRequestSent(Long initiativeId, Long userId) {
    SQLUpdateClause update = queryFactory.update(qAuthor)
            .set(qAuthor.confirmationrequestsent, CURRENT_TIME)
            .where(qAuthor.initiativeId.eq(initiativeId), qAuthor.userId.eq(userId));

    update.execute();
}
 

import com.mysema.query.sql.dml.SQLUpdateClause; //导入方法依赖的package包/类
@Override
@Transactional(readOnly=false)
public void confirmAuthor(Long initiativeId, Long userId) {
    SQLUpdateClause update = queryFactory.update(qAuthor)
            .set(qAuthor.confirmed, CURRENT_TIME)
            .where(qAuthor.initiativeId.eq(initiativeId), qAuthor.userId.eq(userId));

    if (update.execute() != 1) {
        throw new NotFoundException("author", initiativeId + ":" + userId);
    }
}
 

import com.mysema.query.sql.dml.SQLUpdateClause; //导入方法依赖的package包/类
@Override
@Transactional(readOnly=false)
public void updateAuthor(Long initiativeId, Long userId, Author author) {
    SQLUpdateClause update = queryFactory
            .update(qAuthor)
            .where(qAuthor.initiativeId.eq(initiativeId), qAuthor.userId.eq(userId));
    
    populateAuthor(update, author);
    
    if (update.execute() != 1) {
        throw new NotFoundException("author", initiativeId + ":" + userId);
    }
}
 

import com.mysema.query.sql.dml.SQLUpdateClause; //导入方法依赖的package包/类
@Override
@Transactional(readOnly=false)
public void incrementSupportCount(Long initiativeId) {
    // Increment Initiative.supportCount
    SQLUpdateClause update = queryFactory.update(qInitiative)
            .set(qInitiative.supportcount, qInitiative.supportcount.add(1))
            .where(qInitiative.id.eq(initiativeId));
    update.execute();
}
 

import com.mysema.query.sql.dml.SQLUpdateClause; //导入方法依赖的package包/类
private void finishAsyncProcess(long asyncId, LocalDateTime dtm, AsyncStatus status) {
	SQLUpdateClause update = queryFactory.update(ap);
	update.set(ap.asyncStatus, status.code());
	update.set(ap.finishedAt, dtm);
	update.set(ap.updatedAt, currentTimestamp(LocalDateTime.class));
	update.set(ap.lockVersion, ap.lockVersion.add(1));
	update.where(ap.id.eq(asyncId));
	update.where(ap.deletedFlg.eq(DeletedFlag.NOT_DELETED.code()));
	long count = update.execute();
	checkState(count == 1L, "failed to update QAsyncProcess: id=%s, asyncStatus=%s, finishedAt=%s, count=%s",
			asyncId, status.code(), dtm, count);
}
 

import com.mysema.query.sql.dml.SQLUpdateClause; //导入方法依赖的package包/类
@Override
public void setUserRoles(Long userId, boolean vrk, boolean om) {
    Assert.notNull(userId, "userId");
    SQLUpdateClause update = queryFactory.update(qUser);
    update.set(qUser.vrk, vrk);
    update.set(qUser.om, om);
    update.where(qUser.id.eq(userId));
    update.execute();
}