Android Open Source - rfcx-guardian-android Sms Db

From Project

Back to project page rfcx-guardian-android.
License

The source code is released under:
Apache License
If you think the Android project rfcx-guardian-android listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.
Java Source Code

package org.rfcx.guardian.database;
//  w w  w . ja v a2 s. c  o  m
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import org.rfcx.guardian.utility.DateTimeUtils;


import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.text.TextUtils;
import android.util.Log;

public class SmsDb {

  private static final String NULL_EXC = "Exception thrown, but exception itself is null.";
  
  public SmsDb(Context context) {
    this.dbSms = new DbSms(context);
  }
  
  private static final String TAG = SmsDb.class.getSimpleName();
  public DateTimeUtils dateTimeUtils = new DateTimeUtils();
  static final int VERSION = 1;
  static final String DATABASE = "sms";
  static final String C_CREATED_AT = "created_at";
  static final String C_ORIGIN = "origin";
  static final String C_MESSAGE = "message";
  private static final String[] ALL_COLUMNS = new String[] { C_CREATED_AT, C_ORIGIN, C_MESSAGE };

  private String createColumnString(String tableName) {
    StringBuilder sbOut = new StringBuilder();
    sbOut.append("CREATE TABLE ").append(tableName).append("(").append(C_CREATED_AT).append(" DATETIME");
    sbOut.append(", "+C_ORIGIN+" TEXT");
    sbOut.append(", "+C_MESSAGE+" TEXT");
    return sbOut.append(")").toString();
  }
  
  public class DbSms {
    private String TABLE = "sms";
    class DbHelper extends SQLiteOpenHelper {
      public DbHelper(Context context) {
        super(context, DATABASE+"-"+TABLE+".db", null, VERSION);
      }
      @Override
      public void onCreate(SQLiteDatabase db) {
        try {
          db.execSQL(createColumnString(TABLE));
        } catch (SQLException e) { Log.e(TAG,(e!=null) ? e.getMessage() : NULL_EXC); }
      }
      @Override
      public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        try { db.execSQL("DROP TABLE IF EXISTS " + TABLE); onCreate(db);
        } catch (SQLException e) { Log.e(TAG,(e!=null) ? e.getMessage() : NULL_EXC); }
      }
    }
    final DbHelper dbHelper;
    public DbSms(Context context) {
      this.dbHelper = new DbHelper(context);
    }
    public void close() {
      this.dbHelper.close();
    }
    public void insert(String origin, String message) {
      ContentValues values = new ContentValues();
      values.put(C_CREATED_AT, (new DateTimeUtils()).getDateTime());
      values.put(C_ORIGIN, origin);
      values.put(C_MESSAGE, message);
      SQLiteDatabase db = this.dbHelper.getWritableDatabase();
      try {
        db.insertWithOnConflict(TABLE, null, values, SQLiteDatabase.CONFLICT_IGNORE);
      } finally {
        db.close();
      }
    }
    public List<String[]> getSmsAll() {
      SQLiteDatabase db = this.dbHelper.getWritableDatabase();
      ArrayList<String[]> list = new ArrayList<String[]>();
      try { Cursor cursor = db.query(TABLE, ALL_COLUMNS, null, null, null, null, null, null);
        if (cursor.getCount() > 0) {
          try { if (cursor.moveToFirst()) { do { list.add(new String[] { cursor.getString(0), cursor.getString(1), cursor.getString(2) });
          } while (cursor.moveToNext()); } } finally { cursor.close(); } }
      } catch (Exception e) { Log.e(TAG,(e!=null) ? e.getMessage() : NULL_EXC); } finally { db.close(); }
      return list;
    }
    public void clearSmsBefore(Date date) {
      SQLiteDatabase db = this.dbHelper.getWritableDatabase();
      try { db.execSQL("DELETE FROM "+TABLE+" WHERE "+C_CREATED_AT+"<='"+(new DateTimeUtils()).getDateTime(date)+"'");
      } finally { db.close(); }
    }
    public String getSerializedSmsAll() {
      List<String[]> smsList = getSmsAll();
      String[] smsArray = new String[smsList.size()];
      for (int i = 0; i < smsList.size(); i++) {
        smsArray[i] = TextUtils.join("|", smsList.get(i));
      }
      return (smsList.size() > 0) ? TextUtils.join("$", smsArray) : "";
    }
  }
  public final DbSms dbSms;

}
Java Source Code List
