*/\r
public class DbHandler {\r
private SQLiteDatabase mDB;\r
- private OpenerHepler mHelper;\r
+ private OpenerHelper mHelper;\r
private final String mDatabaseName = "ownCloud";\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
+ mHelper = new OpenerHelper(context);\r
mDB = mHelper.getWritableDatabase();\r
}\r
\r
mDB.delete(TABLE_INSTANT_UPLOAD, null, null);\r
}\r
\r
- private class OpenerHepler extends SQLiteOpenHelper {\r
- public OpenerHepler(Context context) {\r
+ /**\r
+ * \r
+ * @param localPath\r
+ * @param accountName\r
+ * @return true when one or more pendin files was removed\r
+ */\r
+ public boolean removeIUPendingFile(String localPath, String accountName) {\r
+ return mDB.delete(TABLE_INSTANT_UPLOAD,\r
+ "path = ?",\r
+ new String[]{ localPath }) != 0;\r
+ \r
+ }\r
+ \r
+ private class OpenerHelper extends SQLiteOpenHelper {\r
+ public OpenerHelper(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
+ + " _id INTEGER PRIMARY KEY, "\r
+ " path TEXT,"\r
+ " account TEXT);");\r
}\r