Examples with SQLiteDatabase net.sqlcipher.database.SQLiteDatabase used on opensource projects

Example 36 with SQLiteDatabase

use of net.sqlcipher.database.SQLiteDatabase in project Signal-Android by signalapp.

the class SignedPreKeyDatabase method getAllSignedPreKeys.

@NonNull
public List<SignedPreKeyRecord> getAllSignedPreKeys() {
    SQLiteDatabase database = databaseHelper.getReadableDatabase();
    List<SignedPreKeyRecord> results = new LinkedList<>();
    try (Cursor cursor = database.query(TABLE_NAME, null, null, null, null, null, null)) {
        while (cursor != null && cursor.moveToNext()) {
            try {
                int keyId = cursor.getInt(cursor.getColumnIndexOrThrow(KEY_ID));
                ECPublicKey publicKey = Curve.decodePoint(Base64.decode(cursor.getString(cursor.getColumnIndexOrThrow(PUBLIC_KEY))), 0);
                ECPrivateKey privateKey = Curve.decodePrivatePoint(Base64.decode(cursor.getString(cursor.getColumnIndexOrThrow(PRIVATE_KEY))));
                byte[] signature = Base64.decode(cursor.getString(cursor.getColumnIndexOrThrow(SIGNATURE)));
                long timestamp = cursor.getLong(cursor.getColumnIndexOrThrow(TIMESTAMP));
                results.add(new SignedPreKeyRecord(keyId, timestamp, new ECKeyPair(publicKey, privateKey), signature));
            } catch (InvalidKeyException | IOException e) {
                Log.w(TAG, e);
            }
        }
    }
    return results;
}

Example 37 with SQLiteDatabase

use of net.sqlcipher.database.SQLiteDatabase in project Signal-Android by signalapp.

the class SignedPreKeyDatabase method insertSignedPreKey.

public void insertSignedPreKey(int keyId, SignedPreKeyRecord record) {
    SQLiteDatabase database = databaseHelper.getWritableDatabase();
    ContentValues contentValues = new ContentValues();
    contentValues.put(KEY_ID, keyId);
    contentValues.put(PUBLIC_KEY, Base64.encodeBytes(record.getKeyPair().getPublicKey().serialize()));
    contentValues.put(PRIVATE_KEY, Base64.encodeBytes(record.getKeyPair().getPrivateKey().serialize()));
    contentValues.put(SIGNATURE, Base64.encodeBytes(record.getSignature()));
    contentValues.put(TIMESTAMP, record.getTimestamp());
    database.replace(TABLE_NAME, null, contentValues);
}

Example 38 with SQLiteDatabase

use of net.sqlcipher.database.SQLiteDatabase in project Signal-Android by signalapp.

the class SmsDatabase method setTimestampRead.

public List<Pair<Long, Long>> setTimestampRead(SyncMessageId messageId, long expireStarted) {
    SQLiteDatabase database = databaseHelper.getWritableDatabase();
    List<Pair<Long, Long>> expiring = new LinkedList<>();
    Cursor cursor = null;
    try {
        cursor = database.query(TABLE_NAME, new String[] { ID, THREAD_ID, ADDRESS, TYPE, EXPIRES_IN }, DATE_SENT + " = ?", new String[] { String.valueOf(messageId.getTimetamp()) }, null, null, null, null);
        while (cursor.moveToNext()) {
            Address theirAddress = messageId.getAddress();
            Address ourAddress = Address.fromSerialized(cursor.getString(cursor.getColumnIndexOrThrow(ADDRESS)));
            if (ourAddress.equals(theirAddress)) {
                long id = cursor.getLong(cursor.getColumnIndexOrThrow(ID));
                long threadId = cursor.getLong(cursor.getColumnIndexOrThrow(THREAD_ID));
                long expiresIn = cursor.getLong(cursor.getColumnIndexOrThrow(EXPIRES_IN));
                ContentValues contentValues = new ContentValues();
                contentValues.put(READ, 1);
                if (expiresIn > 0) {
                    contentValues.put(EXPIRE_STARTED, expireStarted);
                    expiring.add(new Pair<>(id, expiresIn));
                }
                database.update(TABLE_NAME, contentValues, ID_WHERE, new String[] { cursor.getLong(cursor.getColumnIndexOrThrow(ID)) + "" });
                DatabaseFactory.getThreadDatabase(context).updateReadState(threadId);
                DatabaseFactory.getThreadDatabase(context).setLastSeen(threadId);
                notifyConversationListeners(threadId);
            }
        }
    } finally {
        if (cursor != null)
            cursor.close();
    }
    return expiring;
}

Example 39 with SQLiteDatabase

use of net.sqlcipher.database.SQLiteDatabase in project Signal-Android by signalapp.

the class SmsDatabase method getThreadIdForMessage.

public long getThreadIdForMessage(long id) {
    String sql = "SELECT " + THREAD_ID + " FROM " + TABLE_NAME + " WHERE " + ID + " = ?";
    String[] sqlArgs = new String[] { id + "" };
    SQLiteDatabase db = databaseHelper.getReadableDatabase();
    Cursor cursor = null;
    try {
        cursor = db.rawQuery(sql, sqlArgs);
        if (cursor != null && cursor.moveToFirst())
            return cursor.getLong(0);
        else
            return -1;
    } finally {
        if (cursor != null)
            cursor.close();
    }
}

Example 40 with SQLiteDatabase

use of net.sqlcipher.database.SQLiteDatabase in project Signal-Android by signalapp.

the class SmsDatabase method getMessageCount.

public int getMessageCount() {
    SQLiteDatabase db = databaseHelper.getReadableDatabase();
    Cursor cursor = null;
    try {
        cursor = db.query(TABLE_NAME, new String[] { "COUNT(*)" }, null, null, null, null, null);
        if (cursor != null && cursor.moveToFirst())
            return cursor.getInt(0);
        else
            return 0;
    } finally {
        if (cursor != null)
            cursor.close();
    }
}