/**
* Copyright (c) 2013, Redsolution LTD. All rights reserved.
*
* This file is part of Xabber project; you can redistribute it and/or
* modify it under the terms of the GNU General Public License, Version 3.
*
* Xabber is distributed in the hope that it will be useful, but
* WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
* See the GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License,
* along with this program. If not, see http://www.gnu.org/licenses/.
*/
package com.xabber.android.data.database.sqlite;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteStatement;
import com.xabber.android.data.database.DatabaseManager;
/**
* Storage for chats with disabled history.
*
* @author alexander.ivanov
*/
public class PrivateChatTable extends AbstractEntityTable {
static final class Fields implements AbstractEntityTable.Fields {
private Fields() {
}
}
static final String NAME = "private_chats";
private static final String[] PROJECTION = new String[]{Fields.ACCOUNT,
Fields.USER};
private final DatabaseManager databaseManager;
private SQLiteStatement writeStatement;
private final Object writeLock;
private static PrivateChatTable instance;
public static PrivateChatTable getInstance() {
if (instance == null) {
instance = new PrivateChatTable(DatabaseManager.getInstance());
}
return instance;
}
private PrivateChatTable(DatabaseManager databaseManager) {
this.databaseManager = databaseManager;
writeStatement = null;
writeLock = new Object();
}
@Override
public void create(SQLiteDatabase db) {
String sql = "CREATE TABLE " + NAME + " (" + Fields.ACCOUNT + " TEXT,"
+ Fields.USER + " TEXT);";
DatabaseManager.execSQL(db, sql);
sql = "CREATE UNIQUE INDEX " + NAME + "_index ON " + NAME + " " + "("
+ Fields.ACCOUNT + ", " + Fields.USER + ");";
DatabaseManager.execSQL(db, sql);
}
@Override
public void migrate(SQLiteDatabase db, int toVersion) {
super.migrate(db, toVersion);
String sql;
switch (toVersion) {
case 16:
sql = "CREATE TABLE chats (" + "account TEXT," + "user TEXT,"
+ "save BOOLEAN);";
DatabaseManager.execSQL(db, sql);
sql = "CREATE UNIQUE INDEX chats_index ON chats "
+ "(account, user);";
DatabaseManager.execSQL(db, sql);
break;
case 18:
sql = "ALTER TABLE chats ADD COLUMN " + "message TEXT;";
DatabaseManager.execSQL(db, sql);
sql = "UPDATE chats SET message = \"\";";
DatabaseManager.execSQL(db, sql);
break;
case 19:
sql = "UPDATE chats SET message = \"\";";
DatabaseManager.execSQL(db, sql);
break;
case 20:
DatabaseManager.dropTable(db, "chats");
sql = "CREATE TABLE chats (" + "account TEXT," + "user TEXT,"
+ "save_messages BOOLEAN, typed_message TEXT);";
DatabaseManager.execSQL(db, sql);
sql = "CREATE UNIQUE INDEX chats_index ON chats "
+ "(account, user);";
DatabaseManager.execSQL(db, sql);
break;
case 26:
sql = "CREATE TABLE private_chats (" + "account TEXT,"
+ "user TEXT);";
DatabaseManager.execSQL(db, sql);
sql = "CREATE UNIQUE INDEX private_chats_index ON private_chats "
+ "(account, user);";
DatabaseManager.execSQL(db, sql);
sql = "INSERT INTO private_chats (account, user) "
+ "SELECT account, user FROM chats WHERE NOT save_messages;";
DatabaseManager.execSQL(db, sql);
DatabaseManager.dropTable(db, "chats");
break;
default:
break;
}
}
/**
* Sets that messages for specified chat must not to be saved.
*/
public void write(String account, String user) {
synchronized (writeLock) {
if (writeStatement == null) {
SQLiteDatabase db = databaseManager.getWritableDatabase();
writeStatement = db.compileStatement("INSERT OR REPLACE INTO "
+ NAME + " (" + Fields.ACCOUNT + ", " + Fields.USER
+ ") VALUES (?, ?);");
}
writeStatement.bindString(1, account);
writeStatement.bindString(2, user);
writeStatement.execute();
}
}
/**
* Sets that messages for specified chat can be saved.
*/
public void remove(String account, String user) {
SQLiteDatabase db = databaseManager.getWritableDatabase();
db.delete(NAME, Fields.ACCOUNT + " = ? AND " + Fields.USER + " = ?",
new String[]{account, user});
}
@Override
protected String getTableName() {
return NAME;
}
@Override
protected String[] getProjection() {
return PROJECTION;
}
}