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; }