Realm with ContentProvider

I tried to implement realm-java with ContentProvider.

Transcript

1. Realm with ContentProvider Realm meetup #2
2. About me 4 Լ઒ ܟ߂ (@androhi) 4 גࣜձࣾZaim (AndroidΞϓϦ୲౰) 4 DroidKaigiͰൃද͠·͢ 4 JellyBeanͱKitKatͰ࣮ݱ͢ΔϚςϦΞϧσβΠϯ
3. Tried ContentProviderͰΞΫηε͢ΔDBΛɺRealmʹͯ͠Έ·͠ ͨ Reason AndroidͷSyncAdapterΛ࢖ͬͨࣗಈಉظͷ࢓૊ΈͰ͸ɺό οΫάϥ΢ϯυͰಉظॲཧΛ͢ΔࡍʹContentProviderΛ༻ ͍Δͱ͍͏ϧʔϧ͕͋ΔͨΊ
5. Extend ContentProvider 1. Queryϝιουͷ࣮૷ (+ ಠࣗCursorͷੜ੒) 2. Insertϝιουͷ࣮૷ 3. Updateϝιουͷ࣮૷ 4. Deleteϝιουͷ࣮૷ 5. BulkInsertϝιουͷ࣮૷
6. This time 1. Queryϝιουͷ࣮૷ (+ ಠࣗCursorͷੜ੒) 2. Insertϝιουͷ࣮૷ 3. Updateϝιουͷ࣮૷ 4. Deleteϝιουͷ࣮૷ 5. BulkInsertϝιουͷ࣮૷
7. 1-1. Create cursor static final String[] sColumns = new String[] {"_id", "name", "price"}; RealmQuery<Item> query = mRealm.where(Item.class); RealmResults<Item> results = query.findAll(); MatrixCursor matrixCursor = new MatrixCursor(sColumns); for (Item item : results) { Object[] rowData = new Object[]{item.get_id(), item.getName(), item.getPrice()}; matrixCursor.addRow(rowData); }
8. 1-2. Implement query @Override public Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) { ... RealmQuery<Item> query = mRealm.where(Item.class); RealmResults<Item> results = query.findAll(); MatrixCursor matrixCursor = new MatrixCursor(sColumns); for (Item item : results) { Object[] rowData = new Object[]{item.get_id(), item.getName(), item.getPrice()}; matrixCursor.addRow(rowData); } return matrixCursor; }
9. 2. Implement insert @Override public Uri insert(Uri uri, ContentValues contentValues) { ... mRealm.beginTransaction(); Item item = mRealm.createObject(Item.class); item.set_id(++count); item.setName(contentValues.getAsString(sColumns[1])); item.setPrice(contentValues.getAsLong(sColumns[2])); mRealm.commitTransaction(); return Uri.withAppendedPath(uri, String.valueOf(item.get_id())); }
10. 5. Implement bulkInsert @Override public int bulkInsert(Uri uri, ContentValues[] values) { ... mRealm.beginTransaction(); try { for (ContentValues value : values) { Item item = mRealm.createObject(Item.class); item.set_id(value.getAsLong(sColumns[0])); item.setName(value.getAsString(sColumns[1])); item.setPrice(value.getAsLong(sColumns[2])); } } finally { mRealm.commitTransaction(); } return values.length; }
11. compare with SQLite Query/Insert -> 10,000݅ Xperia Z1f (Android 4.4.2)
12. SQLite with ContentProvider 4 Insert͸ɺ͔ͳΓ஗͍ 4 Query͕ૣ͍
13. Realm with ContentProvider 4 Insert͕ɺͦΜͳʹ஗͘ͳ͍ 4 Query͕SQLiteʹൺ΂Δͱ஗͍ ʢCursorੜ੒ͷӨڹʣ 4 BulkInsert͸ޓ֯ʁ
17. Summary 4 ύϑΥʔϚϯε͸མͪΔʢʁʣ͚ͲContentProviderͰ΋ ࢖͑Δ 4 Queryϝιου͸վળͷ༨஍͕͋Γͦ͏ 4 ࣗಈಉظ͚ͩContentProviderܦ༝ʹ͠ɺΞϓϦຊମ͸ RealmΛͦͷ··࢖͏ͷ͕ྑͦ͞͏