X-Git-Url: http://git.linex4red.de/pub/Android/ownCloud.git/blobdiff_plain/a4ba6170ea7696e085b07adfef73eeb8b77cb8e2..7d84fd0c9f15227bc65a2ae00a74e1cfd8f8d33b:/src/com/owncloud/android/db/DbHandler.java

diff --git a/src/com/owncloud/android/db/DbHandler.java b/src/com/owncloud/android/db/DbHandler.java
index 61d56557..9f9b50fc 100644
--- a/src/com/owncloud/android/db/DbHandler.java
+++ b/src/com/owncloud/android/db/DbHandler.java
@@ -1,5 +1,5 @@
 /* ownCloud Android client application
- *   Copyright (C) 2011  Bartek Przybylski
+ *   Copyright (C) 2011-2012  Bartek Przybylski
  *
  *   This program is free software: you can redistribute it and/or modify
  *   it under the terms of the GNU General Public License as published by
@@ -17,11 +17,6 @@
  */
 package com.owncloud.android.db;
 
-import java.util.Vector;
-
-import com.owncloud.android.OwnCloudSession;
-
-
 import android.content.ContentValues;
 import android.content.Context;
 import android.database.Cursor;
@@ -36,15 +31,14 @@ import android.database.sqlite.SQLiteOpenHelper;
  */
 public class DbHandler {
     private SQLiteDatabase mDB;
-    private OpenerHepler mHelper;
+    private OpenerHelper mHelper;
     private final String mDatabaseName = "ownCloud";
-    private final String TABLE_SESSIONS = "sessions";
     private final int mDatabaseVersion = 1;
     
     private final String TABLE_INSTANT_UPLOAD = "instant_upload";
 
     public DbHandler(Context context) {
-        mHelper = new OpenerHepler(context);
+        mHelper = new OpenerHelper(context);
         mDB = mHelper.getWritableDatabase();
     }
 
@@ -67,15 +61,28 @@ public class DbHandler {
         mDB.delete(TABLE_INSTANT_UPLOAD, null, null);
     }
     
-    private class OpenerHepler extends SQLiteOpenHelper {
-        public OpenerHepler(Context context) {
+    /**
+     * 
+     * @param localPath
+     * @param accountName
+     * @return true when one or more pendin files was removed
+     */
+    public boolean removeIUPendingFile(String localPath, String accountName) {
+        return mDB.delete(TABLE_INSTANT_UPLOAD,
+                          "path = ?",
+                          new String[]{ localPath }) != 0;
+        
+    }
+    
+    private class OpenerHelper extends SQLiteOpenHelper {
+        public OpenerHelper(Context context) {
             super(context, mDatabaseName, null, mDatabaseVersion);
         }
 
         @Override
         public void onCreate(SQLiteDatabase db) {
             db.execSQL("CREATE TABLE " + TABLE_INSTANT_UPLOAD + " ("
-            		+ " _id INTEGET PRIMARY KEY, "
+            		+ " _id INTEGER PRIMARY KEY, "
             		+ " path TEXT,"
             		+ " account TEXT);");
         }