Lines Matching refs:MessageColumns
84 import com.android.emailcommon.provider.EmailContent.MessageColumns;
181 = new String[] {MessageColumns.ID, MessageColumns.MAILBOX_KEY};
457 deleteUnlinked(mDatabase, Message.TABLE_NAME, MessageColumns.ACCOUNT_KEY,
882 values.put(MessageColumns.MAILBOX_KEY, longId);
1572 + " ON m." + MessageColumns.ACCOUNT_KEY + "=a." + AccountColumns.ID
1575 + " WHERE m." + MessageColumns.ID + "=?";
1773 Long dstFolderId = values.getAsLong(MessageColumns.MAILBOX_KEY);
1777 Integer flagRead = values.getAsInteger(MessageColumns.FLAG_READ);
1778 Integer flagFavorite = values.getAsInteger(MessageColumns.FLAG_FAVORITE);
1995 result.putParcelable(UIProvider.MessageColumns.URI, messageUri);
2143 sqlBuilder.append(MessageColumns.MAILBOX_KEY).append(", ");
2145 .append(MessageColumns.FLAG_READ).append(" WHEN 0 THEN 1 ELSE 0 END), ");
2147 .append(MessageColumns.FLAG_SEEN).append(" WHEN 0 THEN 1 ELSE 0 END)\n");
2151 sqlBuilder.append(MessageColumns.ACCOUNT_KEY).append(" = ?\n");
2153 sqlBuilder.append(MessageColumns.MAILBOX_KEY);
2184 "CASE WHEN (" + MessageColumns.FLAGS + "&" + Message.FLAG_INCOMING_MEETING_INVITE +
2187 "CASE WHEN (" + MessageColumns.FLAGS + "&" + Message.FLAG_FORWARDED +
2190 "CASE WHEN (" + MessageColumns.FLAGS + "&" + Message.FLAG_REPLIED_TO +
2203 "@CASE (" + MessageColumns.ACCOUNT_KEY + " - 1) % " + ACCOUNT_COLORS.length +
2234 .add(BaseColumns._ID, MessageColumns.ID)
2237 .add(UIProvider.ConversationColumns.SUBJECT, MessageColumns.SUBJECT)
2238 .add(UIProvider.ConversationColumns.SNIPPET, MessageColumns.SNIPPET)
2240 .add(UIProvider.ConversationColumns.DATE_RECEIVED_MS, MessageColumns.TIMESTAMP)
2241 .add(UIProvider.ConversationColumns.HAS_ATTACHMENTS, MessageColumns.FLAG_ATTACHMENT)
2248 .add(UIProvider.ConversationColumns.READ, MessageColumns.FLAG_READ)
2249 .add(UIProvider.ConversationColumns.SEEN, MessageColumns.FLAG_SEEN)
2250 .add(UIProvider.ConversationColumns.STARRED, MessageColumns.FLAG_FAVORITE)
2253 uriWithColumn("uiaccount", MessageColumns.ACCOUNT_KEY))
2254 .add(UIProvider.ConversationColumns.SENDER_INFO, MessageColumns.FROM_LIST)
2265 "CASE WHEN (" + MessageColumns.FLAGS + "&" + Message.FLAG_TYPE_ORIGINAL +
2267 " WHEN (" + MessageColumns.FLAGS + "&" + Message.FLAG_TYPE_REPLY_ALL +
2269 " WHEN (" + MessageColumns.FLAGS + "&" + Message.FLAG_TYPE_REPLY +
2271 " WHEN (" + MessageColumns.FLAGS + "&" + Message.FLAG_TYPE_FORWARD +
2276 "CASE WHEN (" + MessageColumns.FLAGS + "&" + Message.FLAG_INCOMING_MEETING_INVITE +
2287 .add(BaseColumns._ID, Message.TABLE_NAME + "." + EmailContent.MessageColumns.ID)
2288 .add(UIProvider.MessageColumns.SERVER_ID, SyncColumns.SERVER_ID)
2289 .add(UIProvider.MessageColumns.URI, uriWithFQId("uimessage", Message.TABLE_NAME))
2290 .add(UIProvider.MessageColumns.CONVERSATION_ID,
2292 .add(UIProvider.MessageColumns.SUBJECT, EmailContent.MessageColumns.SUBJECT)
2293 .add(UIProvider.MessageColumns.SNIPPET, EmailContent.MessageColumns.SNIPPET)
2294 .add(UIProvider.MessageColumns.FROM, EmailContent.MessageColumns.FROM_LIST)
2295 .add(UIProvider.MessageColumns.TO, EmailContent.MessageColumns.TO_LIST)
2296 .add(UIProvider.MessageColumns.CC, EmailContent.MessageColumns.CC_LIST)
2297 .add(UIProvider.MessageColumns.BCC, EmailContent.MessageColumns.BCC_LIST)
2298 .add(UIProvider.MessageColumns.REPLY_TO, EmailContent.MessageColumns.REPLY_TO_LIST)
2299 .add(UIProvider.MessageColumns.DATE_RECEIVED_MS,
2300 EmailContent.MessageColumns.TIMESTAMP)
2301 .add(UIProvider.MessageColumns.BODY_HTML, Body.HTML_CONTENT)
2302 .add(UIProvider.MessageColumns.BODY_TEXT, Body.TEXT_CONTENT)
2303 .add(UIProvider.MessageColumns.REF_MESSAGE_ID, "0")
2304 .add(UIProvider.MessageColumns.DRAFT_TYPE, NOT_A_DRAFT_STRING)
2305 .add(UIProvider.MessageColumns.APPEND_REF_MESSAGE_CONTENT, "0")
2306 .add(UIProvider.MessageColumns.HAS_ATTACHMENTS,
2307 EmailContent.MessageColumns.FLAG_ATTACHMENT)
2308 .add(UIProvider.MessageColumns.ATTACHMENT_LIST_URI,
2310 .add(UIProvider.MessageColumns.MESSAGE_FLAGS, MESSAGE_FLAGS)
2311 .add(UIProvider.MessageColumns.DRAFT_TYPE, MESSAGE_DRAFT_TYPE)
2312 .add(UIProvider.MessageColumns.MESSAGE_ACCOUNT_URI,
2313 uriWithColumn("uiaccount", MessageColumns.ACCOUNT_KEY))
2314 .add(UIProvider.MessageColumns.STARRED, EmailContent.MessageColumns.FLAG_FAVORITE)
2315 .add(UIProvider.MessageColumns.READ, EmailContent.MessageColumns.FLAG_READ)
2316 .add(UIProvider.MessageColumns.SEEN, EmailContent.MessageColumns.FLAG_SEEN)
2317 .add(UIProvider.MessageColumns.SPAM_WARNING_STRING, null)
2318 .add(UIProvider.MessageColumns.SPAM_WARNING_LEVEL,
2320 .add(UIProvider.MessageColumns.SPAM_WARNING_LINK_TYPE,
2322 .add(UIProvider.MessageColumns.VIA_DOMAIN, null)
2406 "(SELECT group_concat(" + MessageColumns.FROM_LIST + ") FROM " +
2407 "(SELECT " + MessageColumns.FROM_LIST + " FROM " + Message.TABLE_NAME +
2408 " WHERE " + MessageColumns.MAILBOX_KEY + "=" + Mailbox.TABLE_NAME + "." +
2409 MailboxColumns.ID + " AND " + MessageColumns.FLAG_READ + "=0" +
2410 " GROUP BY " + MessageColumns.FROM_LIST + " ORDER BY " +
2411 MessageColumns.TIMESTAMP + " DESC))")
2638 values.put(UIProvider.MessageColumns.EMBEDS_EXTERNAL_RESOURCES, 1);
2652 values.put(UIProvider.MessageColumns.ALWAYS_SHOW_IMAGES, autoShowImages);
2684 values.put(UIProvider.MessageColumns.ATTACHMENTS, "@?"); // @ for literal
2688 values.put(UIProvider.MessageColumns.APPEND_REF_MESSAGE_CONTENT,
2690 MessageColumns.QUOTE_START_POS,
2694 values.put(UIProvider.MessageColumns.EVENT_INTENT_URI,
2706 values.put(UIProvider.MessageColumns.ATTACHMENT_LIST_URI, attachmentListUri.toString());
2720 stringBuilder.append(',').append(MessageColumns.DISPLAY_NAME)
2721 .append(',').append(MessageColumns.FROM_LIST);
2738 sb.append("AND ").append(MessageColumns.FLAG_SEEN).append(" = 0 ");
2739 sb.append("AND ").append(MessageColumns.FLAG_READ).append(" = 0 ");
2741 sb.append("ORDER BY " + MessageColumns.TIMESTAMP + " DESC ");
2766 sb.append(MessageColumns.FLAG_SEEN).append("=0 AND ");
2767 sb.append(MessageColumns.FLAG_READ).append("=0 AND ");
2774 sb.append(MessageColumns.ACCOUNT_KEY).append("=? AND ");
2779 sb.append(MessageColumns.MAILBOX_KEY + " IN (SELECT " + MailboxColumns.ID +
2784 sb.append(MessageColumns.FLAG_FAVORITE + "=1");
2787 sb.append(MessageColumns.FLAG_READ + "=0 AND " + MessageColumns.MAILBOX_KEY +
2794 sb.append(" ORDER BY " + MessageColumns.TIMESTAMP + " DESC");
3423 MessageColumns.MAILBOX_KEY + " IN (SELECT " + MailboxColumns.ID
3425 + "=" + Mailbox.TYPE_INBOX + ") AND " + MessageColumns.FLAG_READ + "=0",
3440 accountKeyClause = MessageColumns.ACCOUNT_KEY + "= ? AND ";
3444 accountKeyClause + MessageColumns.FLAG_READ + "=0 AND "
3445 + MessageColumns.MAILBOX_KEY + " NOT IN (SELECT " + MailboxColumns.ID
3460 accountKeyClause = MessageColumns.ACCOUNT_KEY + "= ? AND ";
3464 accountKeyClause + MessageColumns.FLAG_FAVORITE + "=1", whereArgs);
3806 contentValues.put(MessageColumns.FLAG_SEEN, true);
3808 resolver.update(uri, contentValues, MessageColumns.MAILBOX_KEY + " = ?",
3860 final String senderString = getString(getColumnIndex(MessageColumns.DISPLAY_NAME));
3862 final String fromString = getString(getColumnIndex(MessageColumns.FROM_LIST));
4406 * - UIProvider.MessageColumns.SNIPPET
4407 * - UIProvider.MessageColumns.REPLY_TO
4408 * - UIProvider.MessageColumns.FROM
4416 extras.getString(UIProvider.MessageColumns.CUSTOM_FROM_ADDRESS);
4423 msg.mTo = extras.getString(UIProvider.MessageColumns.TO);
4424 msg.mCc = extras.getString(UIProvider.MessageColumns.CC);
4425 msg.mBcc = extras.getString(UIProvider.MessageColumns.BCC);
4426 msg.mSubject = extras.getString(UIProvider.MessageColumns.SUBJECT);
4427 msg.mText = extras.getString(UIProvider.MessageColumns.BODY_TEXT);
4428 msg.mHtml = extras.getString(UIProvider.MessageColumns.BODY_HTML);
4435 final Integer quoteStartPos = extras.getInt(UIProvider.MessageColumns.QUOTE_START_POS);
4438 final int draftType = extras.getInt(UIProvider.MessageColumns.DRAFT_TYPE);
4454 if (extras.containsKey(UIProvider.MessageColumns.QUOTE_START_POS)) {
4455 draftInfo = extras.getInt(UIProvider.MessageColumns.QUOTE_START_POS);
4456 if (extras.getInt(UIProvider.MessageColumns.APPEND_REF_MESSAGE_CONTENT) != 0) {
4460 if (!extras.containsKey(UIProvider.MessageColumns.APPEND_REF_MESSAGE_CONTENT)) {
4466 final String ref = extras.getString(UIProvider.MessageColumns.REF_MESSAGE_ID);
4479 extras.getString(UIProvider.MessageColumns.ATTACHMENTS));
4776 values.put(MessageColumns.FLAG_SEEN, 1);
4777 final String whereClause = MessageColumns.MAILBOX_KEY + " = ?";
4788 putIntegerLongOrBoolean(ourValues, MessageColumns.FLAG_FAVORITE, val);
4790 putIntegerLongOrBoolean(ourValues, MessageColumns.FLAG_READ, val);
4792 putIntegerLongOrBoolean(ourValues, MessageColumns.FLAG_SEEN, val);
4793 } else if (columnName.equals(MessageColumns.MAILBOX_KEY)) {
4794 putIntegerLongOrBoolean(ourValues, MessageColumns.MAILBOX_KEY, val);
4808 putIntegerLongOrBoolean(ourValues, MessageColumns.MAILBOX_KEY, mailboxId);
4810 } else if (columnName.equals(UIProvider.MessageColumns.ALWAYS_SHOW_IMAGES)) {
4924 if (columnName.equals(MessageColumns.MAILBOX_KEY)) {
4925 undoValues.put(MessageColumns.MAILBOX_KEY, msg.mMailboxKey);
4926 } else if (columnName.equals(MessageColumns.FLAG_READ)) {
4927 undoValues.put(MessageColumns.FLAG_READ, msg.mFlagRead);
4928 } else if (columnName.equals(MessageColumns.FLAG_SEEN)) {
4929 undoValues.put(MessageColumns.FLAG_SEEN, msg.mFlagSeen);
4930 } else if (columnName.equals(MessageColumns.FLAG_FAVORITE)) {
4931 undoValues.put(MessageColumns.FLAG_FAVORITE, msg.mFlagFavorite);
4955 { MessageColumns.MAILBOX_KEY, MessageColumns.ACCOUNT_KEY };
4972 if (values.containsKey(MessageColumns.FLAG_READ) ||
4973 values.containsKey(MessageColumns.MAILBOX_KEY)) {
5016 values.put(MessageColumns.MAILBOX_KEY, trashMailbox.mId);
