Lines Matching refs:MailboxColumns
89 import com.android.emailcommon.provider.EmailContent.MailboxColumns;
457 db.execSQL("update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.PARENT_KEY + "="
459 + Mailbox.TABLE_NAME + "." + MailboxColumns.PARENT_SERVER_ID + "="
460 + "b." + MailboxColumns.SERVER_ID + " and "
461 + Mailbox.TABLE_NAME + "." + MailboxColumns.PARENT_SERVER_ID + " not null and "
462 + Mailbox.TABLE_NAME + "." + MailboxColumns.ACCOUNT_KEY
469 db.execSQL("update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.PARENT_KEY
470 + "=" + Mailbox.NO_MAILBOX + " where " + MailboxColumns.PARENT_KEY
471 + "=" + Mailbox.PARENT_KEY_UNINITIALIZED + " or " + MailboxColumns.PARENT_KEY
504 deleteUnlinked(mDatabase, Mailbox.TABLE_NAME, MailboxColumns.ACCOUNT_KEY,
521 mDatabase.execSQL("update " + Mailbox.TABLE_NAME + " set " + MailboxColumns.UI_SYNC_STATUS +
904 values.put(MailboxColumns.UNREAD_COUNT, 0);
905 values.put(MailboxColumns.MESSAGE_COUNT, 0);
956 if (values.containsKey(MailboxColumns.TYPE)) {
957 if (values.getAsInteger(MailboxColumns.TYPE) <
961 values.getAsLong(MailboxColumns.ACCOUNT_KEY);
1012 values.put(MailboxColumns.ACCOUNT_KEY, longId);
1812 " where accountKey=? group by " + MailboxColumns.SERVER_ID + ") where dupes > 1";
1889 if (values.containsKey(MailboxColumns.SYNC_LOOKBACK) ||
1890 values.containsKey(MailboxColumns.SYNC_INTERVAL)) {
1937 values.remove(MailboxColumns.UNREAD_COUNT);
1938 values.remove(MailboxColumns.MESSAGE_COUNT);
2766 "CASE WHEN (" + MailboxColumns.FLAGS + "&" + Mailbox.FLAG_ACCEPTS_MOVED_MAIL +
2773 private static final String FOLDER_TYPE = "CASE " + MailboxColumns.TYPE
2786 private static final String FOLDER_ICON = "CASE " + MailboxColumns.TYPE
2801 + MailboxColumns.TOTAL_COUNT + "<0 OR "
2802 + MailboxColumns.TYPE + "=" + Mailbox.TYPE_DRAFTS + " OR "
2803 + MailboxColumns.TYPE + "=" + Mailbox.TYPE_OUTBOX + " OR "
2804 + MailboxColumns.TYPE + "=" + Mailbox.TYPE_TRASH
2805 + " THEN " + MailboxColumns.MESSAGE_COUNT
2806 + " ELSE " + MailboxColumns.TOTAL_COUNT + " END";
2811 .add(BaseColumns._ID, MailboxColumns._ID)
2812 .add(UIProvider.FolderColumns.PERSISTENT_ID, MailboxColumns.SERVER_ID)
2816 MailboxColumns.FLAGS + "&" + Mailbox.FLAG_HAS_CHILDREN)
2821 .add(UIProvider.FolderColumns.UNREAD_COUNT, MailboxColumns.UNREAD_COUNT)
2824 .add(UIProvider.FolderColumns.SYNC_STATUS, MailboxColumns.UI_SYNC_STATUS)
2825 .add(UIProvider.FolderColumns.LAST_SYNC_RESULT, MailboxColumns.UI_LAST_SYNC_RESULT)
2829 .add(UIProvider.FolderColumns.HIERARCHICAL_DESC, MailboxColumns.HIERARCHICAL_NAME)
2830 .add(UIProvider.FolderColumns.PARENT_URI, "case when " + MailboxColumns.PARENT_KEY
2832 uriWithColumn("uifolder", MailboxColumns.PARENT_KEY) + " end")
2842 MailboxColumns._ID + " AND " + MessageColumns.FLAG_READ + "=0" +
2927 private static final String MAILBOX_ORDER_BY = "CASE " + MailboxColumns.TYPE
2936 + " ," + MailboxColumns.DISPLAY_NAME + " COLLATE LOCALIZED ASC";
3221 sb.append(MessageColumns.MAILBOX_KEY + " IN (SELECT " + MailboxColumns._ID +
3222 " FROM " + Mailbox.TABLE_NAME + " WHERE " + MailboxColumns.TYPE +
3230 " NOT IN (SELECT " + MailboxColumns._ID + " FROM " + Mailbox.TABLE_NAME +
3231 " WHERE " + MailboxColumns.TYPE + "=" + Mailbox.TYPE_TRASH + ")");
3260 sb.append(" FROM " + Mailbox.TABLE_NAME + " WHERE " + MailboxColumns.ACCOUNT_KEY +
3261 "=? AND " + MailboxColumns.TYPE + " < " + Mailbox.TYPE_NOT_EMAIL +
3262 " AND " + MailboxColumns.TYPE + " != " + Mailbox.TYPE_SEARCH +
3263 " AND " + MailboxColumns.PARENT_KEY + " < 0 ORDER BY ");
3278 sb.append(", case when " + MailboxColumns.HIERARCHICAL_NAME + " is null then " +
3279 MailboxColumns.DISPLAY_NAME + " else " + MailboxColumns.HIERARCHICAL_NAME +
3282 sb.append(" FROM " + Mailbox.TABLE_NAME + " WHERE " + MailboxColumns.ACCOUNT_KEY +
3283 "=? AND " + MailboxColumns.TYPE + " < " + Mailbox.TYPE_NOT_EMAIL +
3284 " AND " + MailboxColumns.TYPE + " != " + Mailbox.TYPE_SEARCH +
3297 sb.append(" FROM " + Mailbox.TABLE_NAME + " WHERE " + MailboxColumns.ACCOUNT_KEY +
3298 "=? AND " + MailboxColumns.TYPE + " < " + Mailbox.TYPE_NOT_EMAIL +
3299 " AND " + MailboxColumns.TYPE + " != " + Mailbox.TYPE_SEARCH +
3300 " AND " + MailboxColumns.PARENT_KEY + " < 0 AND " +
3301 MailboxColumns.LAST_TOUCHED_TIME + " > 0 ORDER BY " +
3302 MailboxColumns.LAST_TOUCHED_TIME + " DESC");
3408 sb.append(" FROM " + Mailbox.TABLE_NAME + " WHERE " + MailboxColumns._ID + "=?");
3893 MessageColumns.MAILBOX_KEY + " IN (SELECT " + MailboxColumns._ID
3894 + " FROM " + Mailbox.TABLE_NAME + " WHERE " + MailboxColumns.TYPE
3910 + MessageColumns.MAILBOX_KEY + " NOT IN (SELECT " + MailboxColumns._ID
3911 + " FROM " + Mailbox.TABLE_NAME + " WHERE " + MailboxColumns.TYPE + "="
4122 sb.append(" FROM " + Mailbox.TABLE_NAME + " WHERE " + MailboxColumns.PARENT_KEY +
4202 .append(MailboxColumns.ACCOUNT_KEY)
4206 .append(MailboxColumns.TYPE)
5094 touchValues.put(MailboxColumns.LAST_TOUCHED_TIME, now);
5217 if (columnName.equals(MailboxColumns.LAST_TOUCHED_TIME)) {
5218 ourValues.put(MailboxColumns.LAST_TOUCHED_TIME, uiValues.getAsLong(columnName));
5506 Mailbox.TABLE_NAME, new String[] { MailboxColumns.ACCOUNT_KEY },
5514 MailboxColumns.ACCOUNT_KEY));
5935 cv.put(MailboxColumns.TOTAL_COUNT, totalCount);
6009 private static final String MAILBOXES_FOR_ACCOUNT_SELECTION = MailboxColumns.ACCOUNT_KEY + "=?";
6167 MailboxColumns.TYPE + "=?",