public static void clearEvents(Context ctx, String tb) {
Log.d("BaseUtility", "clear");
LogHelper logHelper = new LogHelper(ctx);
SQLiteDatabase database = logHelper.getWritableDatabase();
String deleteSql = "DELETE FROM " + tb;
database.execSQL(deleteSql);
database.close();
}
public static void removeEvent(Context ctx, String event) {
Log.d("BaseUtility", "removeEvent:" + event.replace("\r\n", "\\r\\n"));
LogHelper logHelper = new LogHelper(ctx);
SQLiteDatabase database = logHelper.getWritableDatabase();
String[] args = {event};
database.delete(LogHelper.EVENT, "item=?", args);
database.close();
}
public static void logErrorPacket(Context ctx, ErrorRespPacket packet) {
Log.d("BaseUtility", "logErrorPacket:" + packet.toString().replace("\r\n", "\\r\\n"));
LogHelper logHelper = new LogHelper(ctx);
SQLiteDatabase database = logHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("errorcode", packet.getErrorCode());
values.put("errordesc", packet.getErrorDesc());
database.insert(LogHelper.ERROR, null, values);
database.close();
}
public static void recEvent(Context ctx, NetPacket packet) {
Log.d("BaseUtility", "recEvent:" + packet.toString().replace("\r\n", "\\r\\n"));
LogHelper logHelper = new LogHelper(ctx);
SQLiteDatabase database = logHelper.getWritableDatabase();
String[] args = {packet.toString()};
database.delete(LogHelper.EVENT, "item=?", args);
ContentValues values = new ContentValues();
values.put("item", packet.toString());
database.insert(LogHelper.EVENT, null, values);
database.close();
}
public static ArrayList<String> selectEvent(Context ctx) {
Log.d("BaseUtility", "selectEvent");
ArrayList<String> result = new ArrayList<String>();
LogHelper logHelper = new LogHelper(ctx);
SQLiteDatabase database = logHelper.getWritableDatabase();
Cursor cursor = database.rawQuery("SELECT * FROM " + LogHelper.EVENT, null);
while (cursor.moveToNext()) {
result.add(cursor.getString(cursor.getColumnIndex("item")));
}
cursor.close();
database.close();
return result;
}
