src/com/owncloud/android/providers/FileContentProvider.java

   1 /* ownCloud Android client application
   2  *   Copyright (C) 2011  Bartek Przybylski
   3  *   Copyright (C) 2012-2013 ownCloud Inc.
   4  *
   5  *   This program is free software: you can redistribute it and/or modify
   6  *   it under the terms of the GNU General Public License version 2,
   7  *   as published by the Free Software Foundation.
   8  *
   9  *   This program is distributed in the hope that it will be useful,
  10  *   but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  *   GNU General Public License for more details.
  13  *
  14  *   You should have received a copy of the GNU General Public License
  15  *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
  16  *
  17  */
  18
  19 package com.owncloud.android.providers;
  20
  21 import java.util.HashMap;
  22
  23 import com.owncloud.android.Log_OC;
  24 import com.owncloud.android.db.ProviderMeta;
  25 import com.owncloud.android.db.ProviderMeta.ProviderTableMeta;
  26
  27
  28 import android.content.ContentProvider;
  29 import android.content.ContentUris;
  30 import android.content.ContentValues;
  31 import android.content.Context;
  32 import android.content.UriMatcher;
  33 import android.database.Cursor;
  34 import android.database.SQLException;
  35 import android.database.sqlite.SQLiteDatabase;
  36 import android.database.sqlite.SQLiteOpenHelper;
  37 import android.database.sqlite.SQLiteQueryBuilder;
  38 import android.net.Uri;
  39 import android.text.TextUtils;
  40
  41 /**
  42  * The ContentProvider for the ownCloud App.
  43  *
  44  * @author Bartek Przybylski
  45  *
  46  */
  47 public class FileContentProvider extends ContentProvider {
  48
  49     private DataBaseHelper mDbHelper;
  50
  51     private static HashMap<String, String> mProjectionMap;
  52     static {
  53         mProjectionMap = new HashMap<String, String>();
  54         mProjectionMap.put(ProviderTableMeta._ID, ProviderTableMeta._ID);
  55         mProjectionMap.put(ProviderTableMeta.FILE_PARENT,
  56                 ProviderTableMeta.FILE_PARENT);
  57         mProjectionMap.put(ProviderTableMeta.FILE_PATH,
  58                 ProviderTableMeta.FILE_PATH);
  59         mProjectionMap.put(ProviderTableMeta.FILE_NAME,
  60                 ProviderTableMeta.FILE_NAME);
  61         mProjectionMap.put(ProviderTableMeta.FILE_CREATION,
  62                 ProviderTableMeta.FILE_CREATION);
  63         mProjectionMap.put(ProviderTableMeta.FILE_MODIFIED,
  64                 ProviderTableMeta.FILE_MODIFIED);
  65         mProjectionMap.put(ProviderTableMeta.FILE_MODIFIED_AT_LAST_SYNC_FOR_DATA,
  66                 ProviderTableMeta.FILE_MODIFIED_AT_LAST_SYNC_FOR_DATA);
  67         mProjectionMap.put(ProviderTableMeta.FILE_CONTENT_LENGTH,
  68                 ProviderTableMeta.FILE_CONTENT_LENGTH);
  69         mProjectionMap.put(ProviderTableMeta.FILE_CONTENT_TYPE,
  70                 ProviderTableMeta.FILE_CONTENT_TYPE);
  71         mProjectionMap.put(ProviderTableMeta.FILE_STORAGE_PATH,
  72                 ProviderTableMeta.FILE_STORAGE_PATH);
  73         mProjectionMap.put(ProviderTableMeta.FILE_LAST_SYNC_DATE,
  74                 ProviderTableMeta.FILE_LAST_SYNC_DATE);
  75         mProjectionMap.put(ProviderTableMeta.FILE_LAST_SYNC_DATE_FOR_DATA,
  76                 ProviderTableMeta.FILE_LAST_SYNC_DATE_FOR_DATA);
  77         mProjectionMap.put(ProviderTableMeta.FILE_KEEP_IN_SYNC,
  78                 ProviderTableMeta.FILE_KEEP_IN_SYNC);
  79         mProjectionMap.put(ProviderTableMeta.FILE_ACCOUNT_OWNER,
  80                 ProviderTableMeta.FILE_ACCOUNT_OWNER);
  81         mProjectionMap.put(ProviderTableMeta.FILE_ETAG,
  82                 ProviderTableMeta.FILE_ETAG);
  83     }
  84
  85     private static final int SINGLE_FILE = 1;
  86     private static final int DIRECTORY = 2;
  87     private static final int ROOT_DIRECTORY = 3;
  88     private static final UriMatcher mUriMatcher;
  89     static {
  90         mUriMatcher = new UriMatcher(UriMatcher.NO_MATCH);
  91         mUriMatcher.addURI(ProviderMeta.AUTHORITY_FILES, null, ROOT_DIRECTORY);
  92         mUriMatcher.addURI(ProviderMeta.AUTHORITY_FILES, "file/", SINGLE_FILE);
  93         mUriMatcher.addURI(ProviderMeta.AUTHORITY_FILES, "file/#", SINGLE_FILE);
  94         mUriMatcher.addURI(ProviderMeta.AUTHORITY_FILES, "dir/#", DIRECTORY);
  95     }
  96
  97     @Override
  98     public int delete(Uri uri, String where, String[] whereArgs) {
  99         SQLiteDatabase db = mDbHelper.getWritableDatabase();
 100         int count = 0;
 101         switch (mUriMatcher.match(uri)) {
 102         case SINGLE_FILE:
 103             count = db.delete(ProviderTableMeta.DB_NAME,
 104                     ProviderTableMeta._ID
 105                             + "="
 106                             + uri.getPathSegments().get(1)
 107                             + (!TextUtils.isEmpty(where) ? " AND (" + where
 108                                     + ")" : ""), whereArgs);
 109             break;
 110         case ROOT_DIRECTORY:
 111             count = db.delete(ProviderTableMeta.DB_NAME, where, whereArgs);
 112             break;
 113         default:
 114             throw new IllegalArgumentException("Unknown uri: " + uri.toString());
 115         }
 116         getContext().getContentResolver().notifyChange(uri, null);
 117         return count;
 118     }
 119
 120     @Override
 121     public String getType(Uri uri) {
 122         switch (mUriMatcher.match(uri)) {
 123         case ROOT_DIRECTORY:
 124             return ProviderTableMeta.CONTENT_TYPE;
 125         case SINGLE_FILE:
 126             return ProviderTableMeta.CONTENT_TYPE_ITEM;
 127         default:
 128             throw new IllegalArgumentException("Unknown Uri id."
 129                     + uri.toString());
 130         }
 131     }
 132
 133     @Override
 134     public Uri insert(Uri uri, ContentValues values) {
 135         if (mUriMatcher.match(uri) != SINGLE_FILE &&
 136             mUriMatcher.match(uri) != ROOT_DIRECTORY) {
 137
 138             throw new IllegalArgumentException("Unknown uri id: " + uri);
 139         }
 140
 141         SQLiteDatabase db = mDbHelper.getWritableDatabase();
 142         long rowId = db.insert(ProviderTableMeta.DB_NAME, null, values);
 143         if (rowId > 0) {
 144             Uri insertedFileUri = ContentUris.withAppendedId(
 145                     ProviderTableMeta.CONTENT_URI_FILE, rowId);
 146             getContext().getContentResolver().notifyChange(insertedFileUri,
 147                     null);
 148             return insertedFileUri;
 149         }
 150         throw new SQLException("ERROR " + uri);
 151     }
 152
 153     @Override
 154     public boolean onCreate() {
 155         mDbHelper = new DataBaseHelper(getContext());
 156         return true;
 157     }
 158
 159     @Override
 160     public Cursor query(Uri uri, String[] projection, String selection,
 161             String[] selectionArgs, String sortOrder) {
 162         SQLiteQueryBuilder sqlQuery = new SQLiteQueryBuilder();
 163
 164         sqlQuery.setTables(ProviderTableMeta.DB_NAME);
 165         sqlQuery.setProjectionMap(mProjectionMap);
 166
 167         switch (mUriMatcher.match(uri)) {
 168         case ROOT_DIRECTORY:
 169             break;
 170         case DIRECTORY:
 171             sqlQuery.appendWhere(ProviderTableMeta.FILE_PARENT + "="
 172                     + uri.getPathSegments().get(1));
 173             break;
 174         case SINGLE_FILE:
 175             if (uri.getPathSegments().size() > 1) {
 176                 sqlQuery.appendWhere(ProviderTableMeta._ID + "="
 177                         + uri.getPathSegments().get(1));
 178             }
 179             break;
 180         default:
 181             throw new IllegalArgumentException("Unknown uri id: " + uri);
 182         }
 183
 184         String order;
 185         if (TextUtils.isEmpty(sortOrder)) {
 186             order = ProviderTableMeta.DEFAULT_SORT_ORDER;
 187         } else {
 188             order = sortOrder;
 189         }
 190
 191         SQLiteDatabase db = mDbHelper.getReadableDatabase();
 192         // DB case_sensitive
 193         db.execSQL("PRAGMA case_sensitive_like = true");
 194         Cursor c = sqlQuery.query(db, projection, selection, selectionArgs,
 195                 null, null, order);
 196
 197         c.setNotificationUri(getContext().getContentResolver(), uri);
 198
 199         return c;
 200     }
 201
 202     @Override
 203     public int update(Uri uri, ContentValues values, String selection,
 204             String[] selectionArgs) {
 205         return mDbHelper.getWritableDatabase().update(
 206                 ProviderTableMeta.DB_NAME, values, selection, selectionArgs);
 207     }
 208
 209     class DataBaseHelper extends SQLiteOpenHelper {
 210
 211         public DataBaseHelper(Context context) {
 212             super(context, ProviderMeta.DB_NAME, null, ProviderMeta.DB_VERSION);
 213
 214         }
 215
 216         @Override
 217         public void onCreate(SQLiteDatabase db) {
 218             // files table
 219             Log_OC.i("SQL", "Entering in onCreate");
 220             db.execSQL("CREATE TABLE " + ProviderTableMeta.DB_NAME + "("
 221                     + ProviderTableMeta._ID + " INTEGER PRIMARY KEY, "
 222                     + ProviderTableMeta.FILE_NAME + " TEXT, "
 223                     + ProviderTableMeta.FILE_PATH + " TEXT, "
 224                     + ProviderTableMeta.FILE_PARENT + " INTEGER, "
 225                     + ProviderTableMeta.FILE_CREATION + " INTEGER, "
 226                     + ProviderTableMeta.FILE_MODIFIED + " INTEGER, "
 227                     + ProviderTableMeta.FILE_CONTENT_TYPE + " TEXT, "
 228                     + ProviderTableMeta.FILE_CONTENT_LENGTH + " INTEGER, "
 229                     + ProviderTableMeta.FILE_STORAGE_PATH + " TEXT, "
 230                     + ProviderTableMeta.FILE_ACCOUNT_OWNER + " TEXT, "
 231                     + ProviderTableMeta.FILE_LAST_SYNC_DATE + " INTEGER, "
 232                     + ProviderTableMeta.FILE_KEEP_IN_SYNC + " INTEGER, "
 233                     + ProviderTableMeta.FILE_LAST_SYNC_DATE_FOR_DATA + " INTEGER, "
 234                     + ProviderTableMeta.FILE_MODIFIED_AT_LAST_SYNC_FOR_DATA + " INTEGER, "
 235                     + ProviderTableMeta.FILE_ETAG + " TEXT );"
 236                     );
 237         }
 238
 239         @Override
 240         public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
 241             Log_OC.i("SQL", "Entering in onUpgrade");
 242             boolean upgraded = false;
 243             if (oldVersion == 1 && newVersion >= 2) {
 244                 Log_OC.i("SQL", "Entering in the #1 ADD in onUpgrade");
 245                 db.execSQL("ALTER TABLE " + ProviderTableMeta.DB_NAME +
 246                            " ADD COLUMN " + ProviderTableMeta.FILE_KEEP_IN_SYNC  + " INTEGER " +
 247                            " DEFAULT 0");
 248                 upgraded = true;
 249             }
 250             if (oldVersion < 3 && newVersion >= 3) {
 251                 Log_OC.i("SQL", "Entering in the #2 ADD in onUpgrade");
 252                 db.beginTransaction();
 253                 try {
 254                     db.execSQL("ALTER TABLE " + ProviderTableMeta.DB_NAME +
 255                                " ADD COLUMN " + ProviderTableMeta.FILE_LAST_SYNC_DATE_FOR_DATA  + " INTEGER " +
 256                                " DEFAULT 0");
 257
 258                     // assume there are not local changes pending to upload
 259                     db.execSQL("UPDATE " + ProviderTableMeta.DB_NAME +
 260                             " SET " + ProviderTableMeta.FILE_LAST_SYNC_DATE_FOR_DATA + " = " + System.currentTimeMillis() +
 261                             " WHERE " + ProviderTableMeta.FILE_STORAGE_PATH + " IS NOT NULL");
 262
 263                     upgraded = true;
 264                     db.setTransactionSuccessful();
 265                 } finally {
 266                     db.endTransaction();
 267                 }
 268             }
 269             if (oldVersion < 4 && newVersion >= 4) {
 270                 Log_OC.i("SQL", "Entering in the #3 ADD in onUpgrade");
 271                 db.beginTransaction();
 272                 try {
 273                     db .execSQL("ALTER TABLE " + ProviderTableMeta.DB_NAME +
 274                            " ADD COLUMN " + ProviderTableMeta.FILE_MODIFIED_AT_LAST_SYNC_FOR_DATA  + " INTEGER " +
 275                            " DEFAULT 0");
 276
 277                     db.execSQL("UPDATE " + ProviderTableMeta.DB_NAME +
 278                            " SET " + ProviderTableMeta.FILE_MODIFIED_AT_LAST_SYNC_FOR_DATA + " = " + ProviderTableMeta.FILE_MODIFIED +
 279                            " WHERE " + ProviderTableMeta.FILE_STORAGE_PATH + " IS NOT NULL");
 280
 281                     upgraded = true;
 282                     db.setTransactionSuccessful();
 283                 } finally {
 284                     db.endTransaction();
 285                 }
 286             }
 287             if (!upgraded)
 288                 Log_OC.i("SQL", "OUT of the ADD in onUpgrade; oldVersion == " + oldVersion + ", newVersion == " + newVersion);
 289
 290             if (oldVersion < 5 && newVersion >= 5) {
 291                 Log_OC.i("SQL", "Entering in the #4 ADD in onUpgrade");
 292                 db.beginTransaction();
 293                 try {
 294                     db .execSQL("ALTER TABLE " + ProviderTableMeta.DB_NAME +
 295                             " ADD COLUMN " + ProviderTableMeta.FILE_ETAG + " TEXT " +
 296                             " DEFAULT NULL");
 297
 298                     upgraded = true;
 299                     db.setTransactionSuccessful();
 300                 } finally {
 301                     db.endTransaction();
 302                 }
 303             }
 304             if (!upgraded)
 305                 Log_OC.i("SQL", "OUT of the ADD in onUpgrade; oldVersion == " + oldVersion + ", newVersion == " + newVersion);
 306         }
 307     }
 308
 309 }