Examples with DeleteBuilder com.j256.ormlite.stmt.DeleteBuilder used on opensource projects

Example 6 with DeleteBuilder

use of com.j256.ormlite.stmt.DeleteBuilder in project krypton-android by kryptco.

the class Approval method approveGitCommitSignatures.

public static synchronized void approveGitCommitSignatures(OpenDatabaseHelper db, UUID pairingUUID) throws CryptoException, IOException, SQLException {
    Approval approval = new Approval(ApprovalType.GIT_COMMIT_SIGNATURES, pairingUUID, new Date());
    DeleteBuilder deleteExisting = db.getApprovalDao().deleteBuilder();
    deleteExisting.where().eq("pairing_uuid", pairingUUID).and().eq("type", ApprovalType.GIT_COMMIT_SIGNATURES);
    deleteExisting.delete();
    db.getApprovalDao().create(approval);
}

Example 7 with DeleteBuilder

use of com.j256.ormlite.stmt.DeleteBuilder in project krypton-android by kryptco.

the class Approval method deleteExpiredApprovals.

public static synchronized void deleteExpiredApprovals(Dao<Approval, Long> db, Long temporaryApprovalSeconds) throws SQLException {
    DeleteBuilder deleteExpiredPolicyAffectedApprovals = db.deleteBuilder();
    deleteExpiredPolicyAffectedApprovals.where().notIn("type", ApprovalType.READ_TEAM_DATA).and().le("approved_at", new Date(System.currentTimeMillis() - temporaryApprovalSeconds * 1000));
    deleteExpiredPolicyAffectedApprovals.delete();
    DeleteBuilder deleteExpiredReadTeamApprovals = db.deleteBuilder();
    deleteExpiredReadTeamApprovals.where().eq("type", // Always 6 hours
    ApprovalType.READ_TEAM_DATA).and().le("approved_at", new Date(System.currentTimeMillis() - (Policy.READ_TEAM_TEMPORARY_APPROVAL_SECONDS) * 1000));
    deleteExpiredReadTeamApprovals.delete();
}

Example 8 with DeleteBuilder

use of com.j256.ormlite.stmt.DeleteBuilder in project krypton-android by kryptco.

the class Approval method approveSSHAnyHost.

public static synchronized void approveSSHAnyHost(OpenDatabaseHelper db, UUID pairingUUID) throws CryptoException, IOException, SQLException {
    Approval approval = new Approval(ApprovalType.SSH_ANY_HOST, pairingUUID, new Date());
    DeleteBuilder deleteExisting = db.getApprovalDao().deleteBuilder();
    deleteExisting.where().eq("pairing_uuid", pairingUUID).and().eq("type", ApprovalType.SSH_ANY_HOST);
    deleteExisting.delete();
    db.getApprovalDao().create(approval);
}