package com.jasonchen.microlang.database;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.DatabaseUtils;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import com.google.gson.Gson;
import com.google.gson.JsonSyntaxException;
import com.jasonchen.microlang.beans.FavBean;
import com.jasonchen.microlang.beans.FavListBean;
import com.jasonchen.microlang.database.table.FavouriteTable;
import com.jasonchen.microlang.debug.AppLogger;
import com.jasonchen.microlang.utils.AppConfig;
import java.util.ArrayList;
import java.util.List;
/**
* jasonchen
* 2015/04/10
*/
public class FavouriteDBTask {
private FavouriteDBTask() {
}
private static SQLiteDatabase getWsd() {
DatabaseHelper databaseHelper = DatabaseHelper.getInstance();
return databaseHelper.getWritableDatabase();
}
private static SQLiteDatabase getRsd() {
DatabaseHelper databaseHelper = DatabaseHelper.getInstance();
return databaseHelper.getReadableDatabase();
}
private static void add(List<FavBean> msgList, int page, String accountId) {
Gson gson = new Gson();
DatabaseUtils.InsertHelper ih = new DatabaseUtils.InsertHelper(getWsd(),
FavouriteTable.FavouriteDataTable.TABLE_NAME);
final int mblogidColumn = ih.getColumnIndex(FavouriteTable.FavouriteDataTable.MBLOGID);
final int accountidColumn = ih.getColumnIndex(FavouriteTable.FavouriteDataTable.ACCOUNTID);
final int jsondataColumn = ih.getColumnIndex(FavouriteTable.FavouriteDataTable.JSONDATA);
try {
getWsd().beginTransaction();
for (FavBean msg : msgList) {
ih.prepareForInsert();
ih.bind(mblogidColumn, msg.getStatus().getId());
ih.bind(accountidColumn, accountId);
String json = gson.toJson(msg);
ih.bind(jsondataColumn, json);
ih.execute();
}
getWsd().setTransactionSuccessful();
} catch (SQLException e) {
} finally {
getWsd().endTransaction();
ih.close();
}
String sql = "select * from " + FavouriteTable.TABLE_NAME + " where "
+ FavouriteTable.ACCOUNTID + " = "
+ accountId;
Cursor c = getRsd().rawQuery(sql, null);
if (c.moveToNext()) {
try {
String[] args = {accountId};
ContentValues cv = new ContentValues();
cv.put(FavouriteTable.PAGE, page);
getWsd().update(FavouriteTable.TABLE_NAME, cv, FavouriteTable.ACCOUNTID + "=?",
args);
} catch (JsonSyntaxException e) {
}
} else {
ContentValues cv = new ContentValues();
cv.put(FavouriteTable.ACCOUNTID, accountId);
cv.put(FavouriteTable.PAGE, page);
getWsd().insert(FavouriteTable.TABLE_NAME,
FavouriteTable.ID, cv);
}
}
public static FavListBean getFavouriteMsgList(String accountId, int total) {
FavListBean result = new FavListBean();
int limit = AppConfig.DEFAULT_MSG_COUNT_50;
List<FavBean> msgList = new ArrayList<FavBean>();
String sql = "select * from " + FavouriteTable.FavouriteDataTable.TABLE_NAME + " where "
+ FavouriteTable.FavouriteDataTable.ACCOUNTID + " = "
+ accountId + " order by " + FavouriteTable.FavouriteDataTable.MBLOGID + " desc limit " + limit;
Cursor c = getRsd().rawQuery(sql, null);
Gson gson = new Gson();
while (c.moveToNext()) {
String json = c.getString(c.getColumnIndex(FavouriteTable.FavouriteDataTable.JSONDATA));
try {
FavBean value = gson.fromJson(json, FavBean.class);
if (value != null && !value.getStatus().isMiddleUnreadItem()) {
value.getStatus().getListViewSpannableString();
}
msgList.add(value);
} catch (JsonSyntaxException e) {
AppLogger.e(e.getMessage());
}
}
result.setFavorites(msgList);
c.close();
sql = "select * from " + FavouriteTable.TABLE_NAME + " where " + FavouriteTable.ACCOUNTID
+ " = "
+ accountId;
c = getRsd().rawQuery(sql, null);
int page = 0;
while (c.moveToNext()) {
page = c.getInt(c.getColumnIndex(FavouriteTable.PAGE));
}
c.close();
return result;
}
public static int getTotalNumber(String accountId){
String searchCount = "select count(" + FavouriteTable.FavouriteDataTable.ID + ") as total"
+ " from " + FavouriteTable.FavouriteDataTable.TABLE_NAME + " where "
+ FavouriteTable.FavouriteDataTable.ACCOUNTID
+ " = " + accountId;
int total = 0;
Cursor c = getRsd().rawQuery(searchCount, null);
if (c.moveToNext()) {
total = c.getInt(c.getColumnIndex("total"));
}
c.close();
return total;
}
static void deleteAllFavourites(String accountId) {
String sql = "delete from " + FavouriteTable.FavouriteDataTable.TABLE_NAME + " where "
+ FavouriteTable.FavouriteDataTable.ACCOUNTID + " in " + "(" + accountId + ")";
getWsd().execSQL(sql);
sql = "delete from " + FavouriteTable.TABLE_NAME + " where " + FavouriteTable.ACCOUNTID
+ " in " + "(" + accountId + ")";
getWsd().execSQL(sql);
}
/*
public static void asyncUpdatePosition(final TimeLinePosition position,
final String accountId) {
if (position == null) {
return;
}
Runnable runnable = new Runnable() {
@Override
public void run() {
updatePosition(position, accountId);
}
};
new Thread(runnable).start();
}
private static void updatePosition(TimeLinePosition position, String accountId) {
String sql = "select * from " + FavouriteTable.TABLE_NAME + " where "
+ FavouriteTable.ACCOUNTID + " = "
+ accountId;
Cursor c = getRsd().rawQuery(sql, null);
Gson gson = new Gson();
if (c.moveToNext()) {
try {
String[] args = {accountId};
ContentValues cv = new ContentValues();
cv.put(FavouriteTable.TIMELINEDATA, gson.toJson(position));
getWsd().update(FavouriteTable.TABLE_NAME, cv, FavouriteTable.ACCOUNTID + "=?",
args);
} catch (JsonSyntaxException e) {
}
} else {
ContentValues cv = new ContentValues();
cv.put(FavouriteTable.ACCOUNTID, accountId);
cv.put(FavouriteTable.TIMELINEDATA, gson.toJson(position));
getWsd().insert(FavouriteTable.TABLE_NAME,
FavouriteTable.ID, cv);
}
}
private static TimeLinePosition getPosition(String accountId) {
String sql = "select * from " + FavouriteTable.TABLE_NAME + " where "
+ FavouriteTable.ACCOUNTID + " = "
+ accountId;
Cursor c = getRsd().rawQuery(sql, null);
Gson gson = new Gson();
while (c.moveToNext()) {
String json = c.getString(c.getColumnIndex(FavouriteTable.TIMELINEDATA));
if (!TextUtils.isEmpty(json)) {
try {
TimeLinePosition value = gson.fromJson(json, TimeLinePosition.class);
c.close();
return value;
} catch (JsonSyntaxException e) {
e.printStackTrace();
}
}
}
c.close();
return TimeLinePosition.empty();
}
*/
public static void asyncReplace(final FavListBean data, final int page,
final String accountId) {
final List<FavBean> msgList = new ArrayList<FavBean>();
msgList.addAll(data.getFavorites());
new Thread(new Runnable() {
@Override
public void run() {
deleteAllFavourites(accountId);
add(msgList, page, accountId);
}
}).start();
}
}