-package eu.alefzero.owncloud;
-
-import java.util.Vector;
-
-import android.content.ContentValues;
-import android.content.Context;
-import android.database.Cursor;
-import android.database.sqlite.SQLiteDatabase;
-import android.database.sqlite.SQLiteOpenHelper;
-import android.util.Log;
-
-public class DbHandler {
- private SQLiteDatabase mDB;
- private OpenerHepler mHelper;
- private final String mDatabaseName = "ownCloud";
- private final String TABLE_SESSIONS = "sessions";
- private final int mDatabaseVersion = 1;
-
- public DbHandler(Context context) {
- mHelper = new OpenerHepler(context);
- mDB = mHelper.getWritableDatabase();
- }
-
- public Vector<OwnCloudSession> getSessionList() {
- Cursor c = mDB.query(TABLE_SESSIONS, null, null, null, null, null, null);
- Vector<OwnCloudSession> v = new Vector<OwnCloudSession>();
- if (!c.moveToFirst()) {
- return v;
- }
- while (!c.isAfterLast()) {
- v.add(new OwnCloudSession(c.getString(c.getColumnIndex("sessionName")),
- c.getString(c.getColumnIndex("sessionUrl")),
- c.getInt(c.getColumnIndex("_id"))));
- c.moveToNext();
- }
- c.close();
- return v;
- }
-
- public void addSession(String sessionName, String uri) {
- ContentValues cv = new ContentValues();
- cv.put("sessionName", sessionName);
- cv.put("sessionUrl", uri);
- mDB.insert(TABLE_SESSIONS, null, cv);
- }
-
- public void removeSessionWithId(int sessionId) {
- mDB.delete(TABLE_SESSIONS, "_id = ?", new String[] {String.valueOf(sessionId)});
- }
-
- public void changeSessionFields(int id, String hostname, String uri) {
- ContentValues cv = new ContentValues();
- cv.put("sessionName", hostname);
- cv.put("sessionUrl", uri);
- mDB.update(TABLE_SESSIONS, cv, "_id = ?", new String[] {String.valueOf(id)});
- }
-
- public void close() {
- mDB.close();
- }
-
- private class OpenerHepler extends SQLiteOpenHelper {
- public OpenerHepler(Context context) {
- super(context, mDatabaseName, null, mDatabaseVersion);
- }
-
- @Override
- public void onCreate(SQLiteDatabase db) {
- db.execSQL("CREATE TABLE " + TABLE_SESSIONS + " (" +
- " _id INTEGER PRIMARY KEY, " +
- " sessionName TEXT, " +
- " sessionUrl TEXT);");
- }
-
- @Override
- public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
- }
- }
-}