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

Example 1 with DeleteBuilder

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

the class Approval method approveSSHUserHost.

public static synchronized void approveSSHUserHost(OpenDatabaseHelper db, UUID pairingUUID, String user, String host) throws CryptoException, IOException, SQLException {
    Approval approval = new Approval(ApprovalType.SSH_USER_HOST, pairingUUID, new Date());
    approval.sshUserHashHostHash = hashSSHUserHost(user, host);
    approval.user = user;
    approval.host = host;
    DeleteBuilder deleteExisting = db.getApprovalDao().deleteBuilder();
    deleteExisting.where().eq("pairing_uuid", pairingUUID).and().eq("type", ApprovalType.SSH_USER_HOST).and().eq("ssh_user_hash_host_hash", approval.sshUserHashHostHash);
    deleteExisting.delete();
    db.getApprovalDao().create(approval);
}

Example 2 with DeleteBuilder

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

the class Approval method approveGitTagSignatures.

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

Example 3 with DeleteBuilder

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

the class Approval method approveReadTeamData.

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

Example 4 with DeleteBuilder

use of com.j256.ormlite.stmt.DeleteBuilder in project ETSMobile-Android2 by ApplETS.

the class NoteManager method deleteExpiredListeDesElementsEvaluation.

/**
 * Deletes marks in DB that doesn't exist on API
 *
 * @param
 */
private void deleteExpiredListeDesElementsEvaluation(String id) {
    DatabaseHelper dbHelper = new DatabaseHelper(context);
    try {
        Dao<ListeDesElementsEvaluation, String> listeDesElementsEvaluationDao = dbHelper.getDao(ListeDesElementsEvaluation.class);
        ListeDesElementsEvaluation listeDesElementsEvaluation = listeDesElementsEvaluationDao.queryForId(id);
        if (listeDesElementsEvaluation != null) {
            Dao<ElementEvaluation, String> elementsEvaluationDao = dbHelper.getDao(ElementEvaluation.class);
            DeleteBuilder<ElementEvaluation, String> deleteBuilder = elementsEvaluationDao.deleteBuilder();
            Where where = deleteBuilder.where();
            where.eq("listeDesElementsEvaluation_id", listeDesElementsEvaluation);
            deleteBuilder.delete();
        }
        listeDesElementsEvaluationDao.deleteById(id);
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

Example 5 with DeleteBuilder

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

the class Approval method deleteApprovalsForPairing.

public static synchronized void deleteApprovalsForPairing(Dao<Approval, Long> db, UUID pairingUUID) throws SQLException {
    DeleteBuilder deleteBuilder = db.deleteBuilder();
    deleteBuilder.where().eq("pairing_uuid", pairingUUID);
    deleteBuilder.delete();
}