e-mission / cordova-usercache Goto Github PK

We expect to keep timeline data for the past 7 days. But on experimentation, I see that documents are never deleted. If I load data from a year ago, it still reads from the cache. This is probably why the app's data size is so large.

https://github.com/e-mission/e-mission-phone/issues/172

This code

    private void updateReadTimestamp(int keyRes) {
        SQLiteDatabase writeDb = this.getWritableDatabase();
        ContentValues updateValues = new ContentValues();
        updateValues.put(KEY_READ_TS, ((double)System.currentTimeMillis())/1000);
        updateValues.put(KEY_KEY, getKey(keyRes));
        writeDb.update(TABLE_USER_CACHE, updateValues, null, null);
        writeDb.close();
    }

sets the key for all entries in the database to the key of the read document.

According to the logs, this is the query that is executed.

03-29 02:30:28.178  11699-11723/edu.berkeley.eecs.emission D/BuiltinUserCache﹕ Clearing obsolete RW-DOCUMENTS using DELETE FROM userCache WHERE write_ts IN (SELECT B.write_ts FROM userCache A JOIN userCache B  on B.key == A.key WHERE (B.type == 'rw-document' AND A.type == 'document' AND A.write_ts > B.write_ts))

If I run the query manually, against a downloaded database, it works. But it doesn't work seem to work against the actual database. This is not actually a huge tragedy, and we have a lot of work to do today morning, so let's just punt for now.

While investigating documents created directly from javascript today, I discovered that iOS doesn't fill in metadata timezone information, at least for for rw documents. And since the metadata is consistent, it probably doesn't fill in the information for any documents.

We do workaround this by setting the timezone to America/Los_Angeles if it is not present, but that's incorrect for locations other than the west coast of the US. We should either stop using the metadata timezone, or fill it in correctly.