Realm with ContentProvider

Transcript

1. 1.

   Realm with ContentProvider Realm meetup #2

2. 2.

   About me 4 Լ઒ ܟ߂ (@androhi) 4 גࣜձࣾZaim (AndroidΞϓϦ୲౰) 4

   DroidKaigiͰൃද͠·͢ 4 JellyBeanͱKitKatͰ࣮ݱ͢ΔϚςϦΞϧσβΠϯ
3. 3.

   Tried ContentProviderͰΞΫηε͢ΔDBΛɺRealmʹͯ͠Έ·͠ ͨ Reason AndroidͷSyncAdapterΛ࢖ͬͨࣗಈಉظͷ࢓૊ΈͰ͸ɺό οΫάϥ΢ϯυͰಉظॲཧΛ͢ΔࡍʹContentProviderΛ༻ ͍Δͱ͍͏ϧʔϧ͕͋ΔͨΊ

4. 4.

   None
5. 5.

   Extend ContentProvider 1. Queryϝιουͷ࣮૷ (+ ಠࣗCursorͷੜ੒) 2. Insertϝιουͷ࣮૷ 3. Updateϝιουͷ࣮૷

   4. Deleteϝιουͷ࣮૷ 5. BulkInsertϝιουͷ࣮૷
6. 6.

   This time 1. Queryϝιουͷ࣮૷ (+ ಠࣗCursorͷੜ੒) 2. Insertϝιουͷ࣮૷ 3. Updateϝιουͷ࣮૷

   4. Deleteϝιουͷ࣮૷ 5. BulkInsertϝιουͷ࣮૷
7. 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. 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. 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. 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. 11.

    compare with SQLite Query/Insert -> 10,000݅ Xperia Z1f (Android 4.4.2)

12. 12.

    SQLite with ContentProvider 4 Insert͸ɺ͔ͳΓ஗͍ 4 Query͕ૣ͍

13. 13.

    Realm with ContentProvider 4 Insert͕ɺͦΜͳʹ஗͘ͳ͍ 4 Query͕SQLiteʹൺ΂Δͱ஗͍ ʢCursorੜ੒ͷӨڹʣ 4 BulkInsert͸ޓ֯ʁ

14. 14.

    None
15. 15.

    None
16. 16.

    None
17. 17.

    Summary 4 ύϑΥʔϚϯε͸མͪΔʢʁʣ͚ͲContentProviderͰ΋ ࢖͑Δ 4 Queryϝιου͸վળͷ༨஍͕͋Γͦ͏ 4 ࣗಈಉظ͚ͩContentProviderܦ༝ʹ͠ɺΞϓϦຊମ͸ RealmΛͦͷ··࢖͏ͷ͕ྑͦ͞͏