db = mqttDb.getWritableDatabase();
/** * To upgrade the database, drop and recreate our table * * @param db * the database * @param oldVersion * ignored * @param newVersion * ignored */ @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { traceHandler.traceDebug(TAG, "onUpgrade"); try { db.execSQL("DROP TABLE IF EXISTS " + ARRIVED_MESSAGE_TABLE_NAME); } catch (SQLException e) { traceHandler.traceException(TAG, "onUpgrade", e); throw e; } onCreate(db); traceHandler.traceDebug(TAG, "onUpgrade complete"); } }
db = mqttDb.getWritableDatabase();
MqttMessage message) { db = mqttDb.getWritableDatabase();
public boolean discardArrived(String clientHandle, String id) { db = mqttDb.getWritableDatabase();
MqttMessage message) { db = mqttDb.getWritableDatabase();
public boolean discardArrived(String clientHandle, String id) { db = mqttDb.getWritableDatabase();
/** * Delete all messages (optionally for a specific client) * * @param clientHandle * identifier for the client.<br> * If null, all messages are deleted */ @Override public void clearArrivedMessages(String clientHandle) { db = mqttDb.getWritableDatabase(); String[] selectionArgs = new String[1]; selectionArgs[0] = clientHandle; int rows = 0; if (clientHandle == null) { traceHandler.traceDebug(TAG, "clearArrivedMessages: clearing the table"); rows = db.delete(ARRIVED_MESSAGE_TABLE_NAME, null, null); } else { traceHandler.traceDebug(TAG, "clearArrivedMessages: clearing the table of " + clientHandle + " messages"); rows = db.delete(ARRIVED_MESSAGE_TABLE_NAME, MqttServiceConstants.CLIENT_HANDLE + "=?", selectionArgs); } traceHandler.traceDebug(TAG, "clearArrivedMessages: rows affected = " + rows); }
/** * Delete all messages (optionally for a specific client) * * @param clientHandle * identifier for the client.<br> * If null, all messages are deleted */ @Override public void clearArrivedMessages(String clientHandle) { db = mqttDb.getWritableDatabase(); String[] selectionArgs = new String[1]; selectionArgs[0] = clientHandle; int rows = 0; if (clientHandle == null) { traceHandler.traceDebug(TAG, "clearArrivedMessages: clearing the table"); rows = db.delete(ARRIVED_MESSAGE_TABLE_NAME, null, null); } else { traceHandler.traceDebug(TAG, "clearArrivedMessages: clearing the table of " + clientHandle + " messages"); rows = db.delete(ARRIVED_MESSAGE_TABLE_NAME, MqttServiceConstants.CLIENT_HANDLE + "=?", selectionArgs); } traceHandler.traceDebug(TAG, "clearArrivedMessages: rows affected = " + rows); }
/** * To upgrade the database, drop and recreate our table * * @param db * the database * @param oldVersion * ignored * @param newVersion * ignored */ @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { traceHandler.traceDebug(TAG, "onUpgrade"); try { db.execSQL("DROP TABLE IF EXISTS " + ARRIVED_MESSAGE_TABLE_NAME); } catch (SQLException e) { traceHandler.traceException(TAG, "onUpgrade", e); throw e; } onCreate(db); traceHandler.traceDebug(TAG, "onUpgrade complete"); } }
/** * To upgrade the database, drop and recreate our table * * @param db * the database * @param oldVersion * ignored * @param newVersion * ignored */ @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { traceHandler.traceDebug(TAG, "onUpgrade"); try { db.execSQL("DROP TABLE IF EXISTS " + ARRIVED_MESSAGE_TABLE_NAME); } catch (SQLException e) { traceHandler.traceException(TAG, "onUpgrade", e); throw e; } onCreate(db); traceHandler.traceDebug(TAG, "onUpgrade complete"); } }
/** * Constructor - create a DatabaseMessageStore to store arrived MQTT message * * @param service * our parent MqttService * @param context * a context to use for android calls */ public DatabaseMessageStore(MqttService service, Context context) { this.traceHandler = service; // Open message database mqttDb = new MQTTDatabaseHelper(traceHandler, context); // Android documentation suggests that this perhaps // could/should be done in another thread, but as the // database is only one table, I doubt it matters... traceHandler.traceDebug(TAG, "DatabaseMessageStore<init> complete"); }
/** * Constructor - create a DatabaseMessageStore to store arrived MQTT message * * @param service * our parent MqttService * @param context * a context to use for android calls */ public DatabaseMessageStore(MqttService service, Context context) { this.traceHandler = service; // Open message database mqttDb = new MQTTDatabaseHelper(traceHandler, context); // Android documentation suggests that this perhaps // could/should be done in another thread, but as the // database is only one table, I doubt it matters... traceHandler.traceDebug(TAG, "DatabaseMessageStore<init> complete"); }
MqttMessage message) { db = mqttDb.getWritableDatabase();
public boolean discardArrived(String clientHandle, String id) { db = mqttDb.getWritableDatabase();
/** * Delete all messages (optionally for a specific client) * * @param clientHandle * identifier for the client.<br> * If null, all messages are deleted */ @Override public void clearArrivedMessages(String clientHandle) { db = mqttDb.getWritableDatabase(); String[] selectionArgs = new String[1]; selectionArgs[0] = clientHandle; int rows = 0; if (clientHandle == null) { traceHandler.traceDebug(TAG, "clearArrivedMessages: clearing the table"); rows = db.delete(ARRIVED_MESSAGE_TABLE_NAME, null, null); } else { traceHandler.traceDebug(TAG, "clearArrivedMessages: clearing the table of " + clientHandle + " messages"); rows = db.delete(ARRIVED_MESSAGE_TABLE_NAME, MqttServiceConstants.CLIENT_HANDLE + "=?", selectionArgs); } traceHandler.traceDebug(TAG, "clearArrivedMessages: rows affected = " + rows); }
/** * Constructor - create a DatabaseMessageStore to store arrived MQTT message * * @param service * our parent MqttService * @param context * a context to use for android calls */ public DatabaseMessageStore(MqttService service, Context context) { this.traceHandler = service; // Open message database mqttDb = new MQTTDatabaseHelper(traceHandler, context); // Android documentation suggests that this perhaps // could/should be done in another thread, but as the // database is only one table, I doubt it matters... traceHandler.traceDebug(TAG, "DatabaseMessageStore<init> complete"); }