import android.database.sqlite.SQLiteQueryBuilder;\r
import android.net.Uri;\r
import android.text.TextUtils;\r
+import android.util.Log;\r
\r
/**\r
* The ContentProvider for the ownCloud App.\r
ProviderTableMeta.FILE_STORAGE_PATH);\r
mProjectionMap.put(ProviderTableMeta.FILE_LAST_SYNC_DATE,\r
ProviderTableMeta.FILE_LAST_SYNC_DATE);\r
+ mProjectionMap.put(ProviderTableMeta.FILE_KEEP_IN_SYNC,\r
+ ProviderTableMeta.FILE_KEEP_IN_SYNC);\r
}\r
\r
private static final int SINGLE_FILE = 1;\r
\r
@Override\r
public Uri insert(Uri uri, ContentValues values) {\r
- if (mUriMatcher.match(uri) != SINGLE_FILE) {\r
+ if (mUriMatcher.match(uri) != SINGLE_FILE &&\r
+ mUriMatcher.match(uri) != ROOT_DIRECTORY) {\r
+ \r
throw new IllegalArgumentException("Unknown uri id: " + uri);\r
}\r
\r
@Override\r
public void onCreate(SQLiteDatabase db) {\r
// files table\r
+ Log.i("SQL", "Entering in onCreate");\r
db.execSQL("CREATE TABLE " + ProviderTableMeta.DB_NAME + "("\r
+ ProviderTableMeta._ID + " INTEGER PRIMARY KEY, "\r
+ ProviderTableMeta.FILE_NAME + " TEXT, "\r
+ ProviderTableMeta.FILE_CONTENT_LENGTH + " INTEGER, "\r
+ ProviderTableMeta.FILE_STORAGE_PATH + " TEXT, "\r
+ ProviderTableMeta.FILE_ACCOUNT_OWNER + " TEXT, "\r
- + ProviderTableMeta.FILE_LAST_SYNC_DATE + " INTEGER );");\r
+ + ProviderTableMeta.FILE_LAST_SYNC_DATE + " INTEGER, "\r
+ + ProviderTableMeta.FILE_KEEP_IN_SYNC + " INTEGER );");\r
}\r
\r
@Override\r
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {\r
-\r
+ Log.i("SQL", "Entering in onUpgrade");\r
+ if (oldVersion == 1 && newVersion >= 2) {\r
+ Log.i("SQL", "Entering in the ADD in onUpgrade");\r
+ db.execSQL("ALTER TABLE " + ProviderTableMeta.DB_NAME +\r
+ " ADD COLUMN " + ProviderTableMeta.FILE_KEEP_IN_SYNC + " INTEGER " +\r
+ " DEFAULT 0");\r
+ } else Log.i("SQL", "OUT of the ADD in onUpgrade; oldVersion == " + oldVersion + ", newVersion == " + newVersion);\r
}\r
\r
}\r