Merge branch 'master' of gitorious.org:owncloud/android-devel

[pub/Android/ownCloud.git] / src / eu / alefzero / owncloud / db / DbHandler.java

diff --git a/src/eu/alefzero/owncloud/db/DbHandler.java b/src/eu/alefzero/owncloud/db/DbHandler.java
index d2e0b11..23b8bb6 100644 (file)
--- a/src/eu/alefzero/owncloud/db/DbHandler.java
+++ b/src/eu/alefzero/owncloud/db/DbHandler.java
@@ -26,78 +26,61 @@ import android.content.Context;
 import android.database.Cursor;\r
 import android.database.sqlite.SQLiteDatabase;\r
 import android.database.sqlite.SQLiteOpenHelper;\r
 import android.database.Cursor;\r
 import android.database.sqlite.SQLiteDatabase;\r
 import android.database.sqlite.SQLiteOpenHelper;\r

-import android.util.Log;\r

 \r
 /**\r
  * Custom database helper for ownCloud\r
 \r
 /**\r
  * Custom database helper for ownCloud\r

+ * \r

  * @author Bartek Przybylski\r
  * @author Bartek Przybylski\r

- *\r
+ * \r

  */\r
 public class DbHandler {\r
  */\r
 public class DbHandler {\r

-  private SQLiteDatabase mDB;\r
-  private OpenerHepler mHelper;\r
-  private final String mDatabaseName = "ownCloud";\r
-  private final String TABLE_SESSIONS = "sessions";\r
-  private final int mDatabaseVersion = 1;\r
-  \r
-  public DbHandler(Context context) {\r
-    mHelper = new OpenerHepler(context);\r
-    mDB = mHelper.getWritableDatabase();\r
-  }\r
-  \r
-  public Vector<OwnCloudSession> getSessionList() {\r
-    Cursor c = mDB.query(TABLE_SESSIONS, null, null, null, null, null, null);\r
-    Vector<OwnCloudSession> v = new Vector<OwnCloudSession>();\r
-    if (!c.moveToFirst()) {\r
-      return v;\r
-    }\r
-    while (!c.isAfterLast()) {\r
-      v.add(new OwnCloudSession(c.getString(c.getColumnIndex("sessionName")),\r
-                                c.getString(c.getColumnIndex("sessionUrl")),\r
-                                c.getInt(c.getColumnIndex("_id"))));\r
-      c.moveToNext();\r
+    private SQLiteDatabase mDB;\r
+    private OpenerHepler mHelper;\r
+    private final String mDatabaseName = "ownCloud";\r
+    private final String TABLE_SESSIONS = "sessions";\r
+    private final int mDatabaseVersion = 1;\r
+    \r
+    private final String TABLE_INSTANT_UPLOAD = "instant_upload";\r
+\r
+    public DbHandler(Context context) {\r
+        mHelper = new OpenerHepler(context);\r
+        mDB = mHelper.getWritableDatabase();\r

     }\r
     }\r

-    c.close();\r
-    return v;\r
-  }\r
-  \r
-  public void addSession(String sessionName, String uri) {\r
-    ContentValues cv = new ContentValues();\r
-    cv.put("sessionName", sessionName);\r
-    cv.put("sessionUrl", uri);\r
-    mDB.insert(TABLE_SESSIONS, null, cv);\r
-  }\r
-  \r
-  public void removeSessionWithId(int sessionId) {\r
-    mDB.delete(TABLE_SESSIONS, "_id = ?", new String[] {String.valueOf(sessionId)});\r
-  }\r

 \r
 \r

-  public void changeSessionFields(int id, String hostname, String uri) {\r
-    ContentValues cv = new ContentValues();\r
-    cv.put("sessionName", hostname);\r
-    cv.put("sessionUrl", uri);\r
-    mDB.update(TABLE_SESSIONS, cv, "_id = ?", new String[] {String.valueOf(id)});\r
-  }\r
-  \r
-  public void close() {\r
-    mDB.close();\r
-  }\r
-  \r
-  private class OpenerHepler extends SQLiteOpenHelper {\r
-    public OpenerHepler(Context context) {\r
-      super(context, mDatabaseName, null, mDatabaseVersion);\r
+    public void close() {\r
+        mDB.close();\r

     }\r
 \r
     }\r
 \r

-    @Override\r
-    public void onCreate(SQLiteDatabase db) {\r
-      db.execSQL("CREATE TABLE " + TABLE_SESSIONS + " (" +\r
-                 " _id INTEGER PRIMARY KEY, " +\r
-                 " sessionName TEXT, " +\r
-                 " sessionUrl  TEXT);");\r
+    public boolean putFileForLater(String filepath, String account) {\r
+        ContentValues cv = new ContentValues();\r
+        cv.put("path", filepath);\r
+        cv.put("account", account);\r
+        return mDB.insert(TABLE_INSTANT_UPLOAD, null, cv) != -1;\r

     }\r
     }\r

+    \r
+    public Cursor getAwaitingFiles() {\r
+        return mDB.query(TABLE_INSTANT_UPLOAD, null, null, null, null, null, null);\r
+    }\r
+    \r
+    public void clearFiles() {\r
+        mDB.delete(TABLE_INSTANT_UPLOAD, null, null);\r
+    }\r
+    \r
+    private class OpenerHepler extends SQLiteOpenHelper {\r
+        public OpenerHepler(Context context) {\r
+            super(context, mDatabaseName, null, mDatabaseVersion);\r
+        }\r
+\r
+        @Override\r
+        public void onCreate(SQLiteDatabase db) {\r
+            db.execSQL("CREATE TABLE " + TABLE_INSTANT_UPLOAD + " ("\r
+                       + " _id INTEGET PRIMARY KEY, "\r
+                       + " path TEXT,"\r
+                       + " account TEXT);");\r
+        }\r

 \r
 \r

-    @Override\r
-    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {\r
+        @Override\r
+        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {\r
+        }\r

     }\r
     }\r

-  }\r

 }\r
 }\r