/**
* @Title: refreshRecords @Description: refresh records in database
*
* @return boolean operation result
* @throws
*/
public boolean refreshRecords() {
SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
String sql = "SELECT uid, date FROM logs ORDER BY date";
Cursor cursor = null;
try {
cursor = db.rawQuery(sql, null);
while (cursor.moveToNext()) {
String uid = cursor.getString(cursor.getColumnIndex("uid"));
long date = Long.parseLong(cursor.getString(cursor.getColumnIndex("date")));
if (!Utils.isFileExists(uid, date)) {
// updateRecordState(uid, RecordState.DELETED);
deleteLogByUid(uid);
}
}
} catch (SQLException e) {
e.printStackTrace();
return false;
} finally {
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
if (db != null && db.isOpen()) {
db.close();
}
}
return true;
}
/**
* @Title: insertNewLog @Description: insert new log to database
*
* @param callLog MyCallLog instance
* @param recordFlagState is record exists
* @param recordState record storage state
* @return boolean operation result
* @throws
*/
public boolean insertNewLog(
MyCallLog callLog, RecordFlagState recordFlagState, RecordState recordState) {
SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
String sql =
"INSERT INTO logs (name, number, duration, date, type, uid, record_flag, log_state_flag, record_state_flag) VALUES(?, ?, ?, ?, ?, ?, ?, 0, ?)";
try {
db.execSQL(
sql,
new Object[] {
callLog.getName(),
callLog.getNumber(),
callLog.getDuration(),
callLog.getDate(),
callLog.getCallType().ordinal(),
Check.getCRC32(callLog),
recordFlagState.ordinal(),
recordState.ordinal()
});
} catch (SQLException e) {
e.printStackTrace();
return false;
} finally {
if (db != null && db.isOpen()) {
db.close();
}
}
return true;
}
@Override
protected void setUp() throws Exception {
RenamingDelegatingContext context = new RenamingDelegatingContext(getContext(), "test");
DbOpenHelper dbOpenHelper = new DbOpenHelper(context);
db = dbOpenHelper.getWritableDatabase();
db.beginTransaction();
asteroidsDAO = new AsteroidsDAO(db);
}
/**
* 保存一个联系人
*
* @param user
*/
public void saveContact(User user) {
SQLiteDatabase db = dbHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(COLUMN_NAME_ID, user.getUsername());
if (user.getNick() != null) values.put(COLUMN_NAME_NICK, user.getNick());
if (user.getAvatar() != null) values.put(COLUMN_NAME_AVATAR, user.getAvatar());
if (db.isOpen()) {
db.replace(TABLE_NAME, null, values);
}
}
/**
* Throws SprinklesNotInitializedException if you try to access the database before initializing
* Sprinkles.
*
* @return the SQL Database used by Sprinkles.
*/
public static SQLiteDatabase getDatabase() {
if (sInstance == null) {
throw new SprinklesNotInitializedException();
}
if (sDatabase == null) {
DbOpenHelper dbOpenHelper =
new DbOpenHelper(
sInstance.mContext, sInstance.databaseName, sInstance.initialDatabaseVersion);
sDatabase = dbOpenHelper.getWritableDatabase();
}
return sDatabase;
}
/**
* @Title: deleteLogByUid @Description: delete log by uid
*
* @param uid unique id of the log to be deleted
* @return boolean operation result
* @throws
*/
public boolean deleteLogByUid(String uid) {
SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
String sql = "DELETE FROM logs WHERE uid = \"" + uid + "\"";
try {
db.execSQL(sql);
} catch (SQLException e) {
e.printStackTrace();
return false;
} finally {
if (db != null && db.isOpen()) {
db.close();
}
}
return true;
}
/**
* @Title: updateRecordState @Description: update record state
*
* @param uid the unique id of the record
* @param state the state to set
* @return boolean operation result
* @throws
*/
public boolean updateRecordState(String uid, RecordState state) {
SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
String sql =
"UPDATE logs SET record_state_flag = " + state.ordinal() + " WHERE uid = \"" + uid + "\"";
try {
db.execSQL(sql);
} catch (SQLException e) {
e.printStackTrace();
return false;
} finally {
if (db != null && db.isOpen()) {
db.close();
}
}
return true;
}
/**
* 保存message
*
* @param message
* @return 返回这条messaged在db中的id
*/
public synchronized Integer saveMessage(InviteMessage message) {
SQLiteDatabase db = dbHelper.getWritableDatabase();
int id = -1;
if (db.isOpen()) {
ContentValues values = new ContentValues();
values.put(COLUMN_NAME_FROM, message.getFrom());
values.put(COLUMN_NAME_GROUP_ID, message.getGroupId());
values.put(COLUMN_NAME_GROUP_Name, message.getGroupName());
values.put(COLUMN_NAME_REASON, message.getReason());
values.put(COLUMN_NAME_TIME, message.getTime());
values.put(COLUMN_NAME_STATUS, message.getStatus().ordinal());
db.insert(TABLE_NAME, null, values);
Cursor cursor = db.rawQuery("select last_insert_rowid() from " + TABLE_NAME, null);
if (cursor.moveToFirst()) {
id = cursor.getInt(0);
}
}
return id;
}
/**
* @Title: updateLogs @Description: update logs
*
* @param callLogs call logs to update
* @return boolean the result of the operation
* @throws
*/
@Deprecated
public boolean updateLogs(List<MyCallLog> callLogs) {
SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
String sql = "SELECT uid, date FROM logs ORDER BY date";
Cursor cursor = null;
try {
cursor = db.rawQuery(sql, null);
List<String> uids = new ArrayList<String>();
// update log_state
while (cursor.moveToNext()) {
String uid = cursor.getString(cursor.getColumnIndex("uid"));
uids.add(uid);
if (!Utils.containsUid(uid, callLogs)) {
updateLogState(uid, LogState.ONLY_LOCAL);
}
}
// insert new logs into table
for (MyCallLog callLog : callLogs) {
String tmp = Check.getCRC32(callLog);
if (!uids.contains(tmp)) {
insertNewLog(callLog);
}
}
} catch (SQLException e) {
e.printStackTrace();
return false;
} finally {
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
if (db != null && db.isOpen()) {
db.close();
}
}
return true;
}
public SqliteJobQueue(Configuration configuration, long sessionId, JobSerializer serializer) {
this.sessionId = sessionId;
jobStorage = new FileStorage(configuration.getAppContext(), "jobs_" + configuration.getId());
whereQueryCache = new WhereQueryCache(sessionId);
dbOpenHelper =
new DbOpenHelper(
configuration.getAppContext(),
configuration.isInTestMode() ? null : ("db_" + configuration.getId()));
db = dbOpenHelper.getWritableDatabase();
sqlHelper =
new SqlHelper(
db,
DbOpenHelper.JOB_HOLDER_TABLE_NAME,
DbOpenHelper.ID_COLUMN.columnName,
DbOpenHelper.COLUMN_COUNT,
DbOpenHelper.JOB_TAGS_TABLE_NAME,
DbOpenHelper.TAGS_COLUMN_COUNT,
sessionId);
this.jobSerializer = serializer;
if (configuration.resetDelaysOnRestart()) {
sqlHelper.resetDelayTimesTo(JobManager.NOT_DELAYED_JOB_DELAY);
}
cleanupFiles();
}
/**
* 更新message
*
* @param msgId
* @param values
*/
public void updateMessage(int msgId, ContentValues values) {
SQLiteDatabase db = dbHelper.getWritableDatabase();
if (db.isOpen()) {
db.update(TABLE_NAME, values, COLUMN_NAME_ID + " = ?", new String[] {String.valueOf(msgId)});
}
}
public void deleteMessage(String from) {
SQLiteDatabase db = dbHelper.getWritableDatabase();
if (db.isOpen()) {
db.delete(TABLE_NAME, COLUMN_NAME_FROM + " = ?", new String[] {from});
}
}
/**
* 删除一个联系人
*
* @param username
*/
public void deleteContact(String username) {
SQLiteDatabase db = dbHelper.getWritableDatabase();
if (db.isOpen()) {
db.delete(TABLE_NAME, COLUMN_NAME_ID + " = ?", new String[] {username});
}
}
