package com.common.openapi;
|
|
import android.content.ContentValues;
|
import android.content.Context;
|
import android.database.Cursor;
|
import android.database.sqlite.SQLiteDatabase;
|
import android.database.sqlite.SQLiteOpenHelper;
|
|
import com.common.openapi.entity.DeviceLocalCacheData;
|
|
import java.util.ArrayList;
|
import java.util.List;
|
|
public class DeviceLocalCacheDatabase extends SQLiteOpenHelper {
|
private static final String TAG = DeviceLocalCacheDatabase.class.getSimpleName();
|
|
private static final String DB_NAME = "device_local_cache";
|
private static final String TABLE_NAME = "t_device_local_cache";
|
|
private static final String TABLE_CREATE_SQL = "create table " + TABLE_NAME + "(" +
|
"cache_id integer primary key autoincrement, " +
|
"device_id text, " +
|
"device_name text, " +
|
"channel_id text, " +
|
"channel_name text, " +
|
"pic_path text, " +
|
"creation_time integer, " +
|
"modify_time integer " +
|
")";
|
|
private static final String[] TABLE_COLUMNS = {
|
"cache_id",
|
"device_id",
|
"device_name",
|
"channel_id",
|
"channel_name",
|
"pic_path",
|
"creation_time",
|
"modify_time"
|
};
|
|
public DeviceLocalCacheDatabase(Context context) {
|
super(context, DB_NAME, null, 1);
|
}
|
|
@Override
|
public void onCreate(SQLiteDatabase db) {
|
db.execSQL(TABLE_CREATE_SQL);
|
}
|
|
@Override
|
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
|
|
}
|
|
public int addLocalCache(DeviceLocalCacheData deviceLocalCacheData) {
|
SQLiteDatabase db = getWritableDatabase();
|
ContentValues v = new ContentValues();
|
v.put("device_id", deviceLocalCacheData.getDeviceId());
|
v.put("device_name", deviceLocalCacheData.getDeviceName());
|
v.put("channel_id", deviceLocalCacheData.getChannelId());
|
v.put("channel_name", deviceLocalCacheData.getChannelName());
|
v.put("pic_path", deviceLocalCacheData.getPicPath());
|
v.put("creation_time", System.currentTimeMillis());
|
v.put("modify_time", System.currentTimeMillis());
|
long rowid = db.insert(TABLE_NAME, null, v);
|
if (rowid != -1) {
|
return 1;
|
}
|
return 0;
|
}
|
|
public int updateLocalCache(DeviceLocalCacheData deviceLocalCacheData) {
|
ContentValues v = new ContentValues();
|
v.put("pic_path", deviceLocalCacheData.getPicPath());
|
v.put("modify_time", System.currentTimeMillis());
|
SQLiteDatabase db = getWritableDatabase();
|
int ret = db.update(TABLE_NAME, v, "cache_id=?", new String[]{String.valueOf(deviceLocalCacheData.getCacheId())});
|
if (ret > 0) {
|
return 1;
|
}
|
return 0;
|
}
|
|
public DeviceLocalCacheData findLocalCache(DeviceLocalCacheData deviceLocalCacheData) {
|
StringBuilder selectionBuilder = new StringBuilder();
|
List<String> selectionArgs = new ArrayList<>();
|
boolean first = true;
|
if (deviceLocalCacheData.getDeviceId() != null) {
|
selectionBuilder.append(" device_id =? ");
|
selectionArgs.add(deviceLocalCacheData.getDeviceId());
|
first = false;
|
}
|
if (deviceLocalCacheData.getChannelId() != null) {
|
if (!first) {
|
selectionBuilder.append(" and ");
|
}
|
selectionBuilder.append(" channel_id =? ");
|
selectionArgs.add(deviceLocalCacheData.getChannelId());
|
}
|
SQLiteDatabase db = getReadableDatabase();
|
try (Cursor c = db.query(TABLE_NAME, TABLE_COLUMNS, selectionBuilder.toString(), selectionArgs.toArray(new String[0]), null, null, null, "1")) {
|
if (c.moveToFirst()) {
|
return (buildLocalCacheFromCursor(c));
|
}
|
}
|
return null;
|
}
|
|
private DeviceLocalCacheData buildLocalCacheFromCursor(Cursor c) {
|
DeviceLocalCacheData deviceLocalCacheData = new DeviceLocalCacheData();
|
deviceLocalCacheData.setCacheId(c.getInt(0));
|
deviceLocalCacheData.setDeviceId(c.getString(1));
|
deviceLocalCacheData.setDeviceName(c.getString(2));
|
deviceLocalCacheData.setChannelId(c.getString(3));
|
deviceLocalCacheData.setChannelName(c.getString(4));
|
deviceLocalCacheData.setPicPath(c.getString(5));
|
deviceLocalCacheData.setCreationTime(c.getLong(6));
|
deviceLocalCacheData.setModifyTime(c.getLong(7));
|
return deviceLocalCacheData;
|
}
|
}
|
