cached instant upload

[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 ab35dda..23b8bb6 100644 (file)
--- a/src/eu/alefzero/owncloud/db/DbHandler.java
+++ b/src/eu/alefzero/owncloud/db/DbHandler.java
@@ -39,54 +39,33 @@ public class DbHandler {
     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
-    public Vector<OwnCloudSession> getSessionList() {\r
-        Cursor c = mDB\r
-                .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\r
-                    .getColumnIndex("sessionName")), c.getString(c\r
-                    .getColumnIndex("sessionUrl")), c.getInt(c\r
-                    .getColumnIndex("_id"))));\r
-            c.moveToNext();\r
-        }\r
-        c.close();\r
-        return v;\r
+    public void close() {\r
+        mDB.close();\r
     }\r
 \r
-    public void addSession(String sessionName, String uri) {\r
+    public boolean putFileForLater(String filepath, String account) {\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 = ?",\r
-                new String[] { String.valueOf(sessionId) });\r
+        cv.put("path", filepath);\r
+        cv.put("account", account);\r
+        return mDB.insert(TABLE_INSTANT_UPLOAD, null, cv) != -1;\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 = ?",\r
-                new String[] { String.valueOf(id) });\r
+    \r
+    public Cursor getAwaitingFiles() {\r
+        return mDB.query(TABLE_INSTANT_UPLOAD, null, null, null, null, null, null);\r
     }\r
-\r
-    public void close() {\r
-        mDB.close();\r
+    \r
+    public void clearFiles() {\r
+        mDB.delete(TABLE_INSTANT_UPLOAD, null, null);\r
     }\r
-\r
+    \r
     private class OpenerHepler extends SQLiteOpenHelper {\r
         public OpenerHepler(Context context) {\r
             super(context, mDatabaseName, null, mDatabaseVersion);\r
@@ -94,9 +73,10 @@ public class DbHandler {
 \r
         @Override\r
         public void onCreate(SQLiteDatabase db) {\r
-            db.execSQL("CREATE TABLE " + TABLE_SESSIONS + " ("\r
-                    + " _id INTEGER PRIMARY KEY, " + " sessionName TEXT, "\r
-                    + " sessionUrl  TEXT);");\r
+            db.execSQL("CREATE TABLE " + TABLE_INSTANT_UPLOAD + " ("\r
+                       + " _id INTEGET PRIMARY KEY, "\r
+                       + " path TEXT,"\r
+                       + " account TEXT);");\r
         }\r
 \r
         @Override\r