src/eu/alefzero/owncloud/db/DbHandler.java

   1 /* ownCloud Android client application
   2  *   Copyright (C) 2011  Bartek Przybylski
   3  *
   4  *   This program is free software: you can redistribute it and/or modify
   5  *   it under the terms of the GNU General Public License as published by
   6  *   the Free Software Foundation, either version 3 of the License, or
   7  *   (at your option) any later version.
   8  *
   9  *   This program is distributed in the hope that it will be useful,
  10  *   but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  *   GNU General Public License for more details.
  13  *
  14  *   You should have received a copy of the GNU General Public License
  15  *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
  16  *
  17  */
  18 package eu.alefzero.owncloud.db;
  19
  20 import java.util.Vector;
  21
  22 import eu.alefzero.owncloud.OwnCloudSession;
  23
  24 import android.content.ContentValues;
  25 import android.content.Context;
  26 import android.database.Cursor;
  27 import android.database.sqlite.SQLiteDatabase;
  28 import android.database.sqlite.SQLiteOpenHelper;
  29
  30 /**
  31  * Custom database helper for ownCloud
  32  *
  33  * @author Bartek Przybylski
  34  *
  35  */
  36 public class DbHandler {
  37     private SQLiteDatabase mDB;
  38     private OpenerHepler mHelper;
  39     private final String mDatabaseName = "ownCloud";
  40     private final String TABLE_SESSIONS = "sessions";
  41     private final int mDatabaseVersion = 1;
  42
  43     public DbHandler(Context context) {
  44         mHelper = new OpenerHepler(context);
  45         mDB = mHelper.getWritableDatabase();
  46     }
  47
  48     public Vector<OwnCloudSession> getSessionList() {
  49         Cursor c = mDB
  50                 .query(TABLE_SESSIONS, null, null, null, null, null, null);
  51         Vector<OwnCloudSession> v = new Vector<OwnCloudSession>();
  52         if (!c.moveToFirst()) {
  53             return v;
  54         }
  55         while (!c.isAfterLast()) {
  56             v.add(new OwnCloudSession(c.getString(c
  57                     .getColumnIndex("sessionName")), c.getString(c
  58                     .getColumnIndex("sessionUrl")), c.getInt(c
  59                     .getColumnIndex("_id"))));
  60             c.moveToNext();
  61         }
  62         c.close();
  63         return v;
  64     }
  65
  66     public void addSession(String sessionName, String uri) {
  67         ContentValues cv = new ContentValues();
  68         cv.put("sessionName", sessionName);
  69         cv.put("sessionUrl", uri);
  70         mDB.insert(TABLE_SESSIONS, null, cv);
  71     }
  72
  73     public void removeSessionWithId(int sessionId) {
  74         mDB.delete(TABLE_SESSIONS, "_id = ?",
  75                 new String[] { String.valueOf(sessionId) });
  76     }
  77
  78     public void changeSessionFields(int id, String hostname, String uri) {
  79         ContentValues cv = new ContentValues();
  80         cv.put("sessionName", hostname);
  81         cv.put("sessionUrl", uri);
  82         mDB.update(TABLE_SESSIONS, cv, "_id = ?",
  83                 new String[] { String.valueOf(id) });
  84     }
  85
  86     public void close() {
  87         mDB.close();
  88     }
  89
  90     private class OpenerHepler extends SQLiteOpenHelper {
  91         public OpenerHepler(Context context) {
  92             super(context, mDatabaseName, null, mDatabaseVersion);
  93         }
  94
  95         @Override
  96         public void onCreate(SQLiteDatabase db) {
  97             db.execSQL("CREATE TABLE " + TABLE_SESSIONS + " ("
  98                     + " _id INTEGER PRIMARY KEY, " + " sessionName TEXT, "
  99                     + " sessionUrl  TEXT);");
 100         }
 101
 102         @Override
 103         public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
 104         }
 105     }
 106 }