/* ownCloud Android client application\r
- * Copyright (C) 2011 Bartek Przybylski\r
+ * Copyright (C) 2011-2012 Bartek Przybylski\r
*\r
* This program is free software: you can redistribute it and/or modify\r
* it under the terms of the GNU General Public License as published by\r
*/\r
package com.owncloud.android.db;\r
\r
-import java.util.Vector;\r
-\r
-import com.owncloud.android.OwnCloudSession;\r
-\r
-\r
import android.content.ContentValues;\r
import android.content.Context;\r
import android.database.Cursor;\r
*/\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 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
+ 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