blob: b50a3c2dd841e6814c0896d7e24f00875905269c [file] [log] [blame]
Vikram Aggarwal4f9a4c52012-01-11 15:04:55 -08001/*******************************************************************************
2 * Copyright (C) 2011 Google Inc.
3 * Licensed to The Android Open Source Project.
Mindy Pereira6f92de62011-12-19 11:31:48 -08004 *
Vikram Aggarwal4f9a4c52012-01-11 15:04:55 -08005 * Licensed under the Apache License, Version 2.0 (the "License");
6 * you may not use this file except in compliance with the License.
7 * You may obtain a copy of the License at
Mindy Pereira6f92de62011-12-19 11:31:48 -08008 *
Vikram Aggarwal4f9a4c52012-01-11 15:04:55 -08009 * http://www.apache.org/licenses/LICENSE-2.0
Mindy Pereira6f92de62011-12-19 11:31:48 -080010 *
Vikram Aggarwal4f9a4c52012-01-11 15:04:55 -080011 * Unless required by applicable law or agreed to in writing, software
12 * distributed under the License is distributed on an "AS IS" BASIS,
13 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
14 * See the License for the specific language governing permissions and
15 * limitations under the License.
16 *******************************************************************************/
Mindy Pereira6f92de62011-12-19 11:31:48 -080017
Andy Huang30e2c242012-01-06 18:14:30 -080018package com.android.mail.providers;
Mindy Pereira6f92de62011-12-19 11:31:48 -080019
Mindy Pereira82cc5662012-01-09 17:29:30 -080020import android.content.Context;
Mindy Pereira6f92de62011-12-19 11:31:48 -080021import android.provider.BaseColumns;
Mindy Pereira82cc5662012-01-09 17:29:30 -080022import android.text.TextUtils;
23
24import com.android.common.contacts.DataUsageStatUpdater;
Mindy Pereira6f92de62011-12-19 11:31:48 -080025
Paul Westbrook82ea6da2011-12-15 11:03:51 -080026import java.lang.String;
Mindy Pereira82cc5662012-01-09 17:29:30 -080027import java.util.ArrayList;
Paul Westbrook82ea6da2011-12-15 11:03:51 -080028
Mindy Pereira6f92de62011-12-19 11:31:48 -080029
30public class UIProvider {
Mindy Pereira82cc5662012-01-09 17:29:30 -080031 public static final String EMAIL_SEPARATOR = "\n";
Mindy Pereira326c6602012-01-04 15:32:42 -080032 public static final long INVALID_CONVERSATION_ID = -1;
33 public static final long INVALID_MESSAGE_ID = -1;
34
Paul Westbrook82ea6da2011-12-15 11:03:51 -080035 // The actual content provider should define its own authority
Andy Huang30e2c242012-01-06 18:14:30 -080036 public static final String AUTHORITY = "com.android.mail.providers";
Mindy Pereira6f92de62011-12-19 11:31:48 -080037
38 public static final String ACCOUNT_LIST_TYPE =
Paul Westbrook82ea6da2011-12-15 11:03:51 -080039 "vnd.android.cursor.dir/vnd.com.android.mail.account";
Mindy Pereira6f92de62011-12-19 11:31:48 -080040 public static final String ACCOUNT_TYPE =
Paul Westbrook82ea6da2011-12-15 11:03:51 -080041 "vnd.android.cursor.item/vnd.com.android.mail.account";
Mindy Pereira6f92de62011-12-19 11:31:48 -080042
43 public static final String[] ACCOUNTS_PROJECTION = {
44 BaseColumns._ID,
45 AccountColumns.NAME,
46 AccountColumns.PROVIDER_VERSION,
47 AccountColumns.URI,
48 AccountColumns.CAPABILITIES,
49 AccountColumns.FOLDER_LIST_URI,
50 AccountColumns.SEARCH_URI,
51 AccountColumns.ACCOUNT_FROM_ADDRESSES_URI,
Mindy Pereira33fe9082012-01-09 16:24:30 -080052 AccountColumns.SAVE_DRAFT_URI,
Mindy Pereira7ed1c112012-01-18 10:59:25 -080053 AccountColumns.SEND_MAIL_URI,
Mindy Pereira96b5c352012-02-01 11:33:40 -080054 AccountColumns.EXPUNGE_MESSAGE_URI,
55 AccountColumns.UNDO_URI
Mindy Pereira6f92de62011-12-19 11:31:48 -080056 };
57
Mindy Pereira33fe9082012-01-09 16:24:30 -080058 public static final int ACCOUNT_ID_COLUMN = 0;
59 public static final int ACCOUNT_NAME_COLUMN = 1;
60 public static final int ACCOUNT_PROVIDER_VERISON_COLUMN = 2;
61 public static final int ACCOUNT_URI_COLUMN = 3;
62 public static final int ACCOUNT_CAPABILITIES_COLUMN = 4;
63 public static final int ACCOUNT_FOLDER_LIST_URI_COLUMN = 5;
64 public static final int ACCOUNT_SEARCH_URI_COLUMN = 6;
65 public static final int ACCOUNT_FROM_ADDRESSES_URI_COLUMN = 7;
66 public static final int ACCOUNT_SAVE_DRAFT_URI_COLUMN = 8;
67 public static final int ACCOUNT_SEND_MESSAGE_URI_COLUMN = 9;
Mindy Pereira82cc5662012-01-09 17:29:30 -080068 public static final int ACCOUNT_EXPUNGE_MESSAGE_URI_COLUMN = 10;
Mindy Pereira96b5c352012-02-01 11:33:40 -080069 public static final int ACCOUNT_UNDO_URI_COLUMN = 11;
Mindy Pereira33fe9082012-01-09 16:24:30 -080070
Mindy Pereira6f92de62011-12-19 11:31:48 -080071 public static final class AccountCapabilities {
Vikram Aggarwal859681b2012-02-03 10:02:24 -080072 /**
73 * Whether folders can be synchronized back to the server.
74 */
Paul Westbrook82ea6da2011-12-15 11:03:51 -080075 public static final int SYNCABLE_FOLDERS = 0x0001;
Vikram Aggarwal859681b2012-02-03 10:02:24 -080076 /**
77 * Whether the server allows reporting spam back.
78 */
Paul Westbrook82ea6da2011-12-15 11:03:51 -080079 public static final int REPORT_SPAM = 0x0002;
Vikram Aggarwal859681b2012-02-03 10:02:24 -080080 /**
81 * Whether the server supports a concept of Archive: removing mail from the Inbox but
82 * keeping it around.
83 */
Paul Westbrook82ea6da2011-12-15 11:03:51 -080084 public static final int ARCHIVE = 0x0004;
Vikram Aggarwal859681b2012-02-03 10:02:24 -080085 /**
86 * Whether the server will stop notifying on updates to this thread? This requires
87 * THREADED_CONVERSATIONS to be true, otherwise it should be ignored.
88 */
Paul Westbrook82ea6da2011-12-15 11:03:51 -080089 public static final int MUTE = 0x0008;
Vikram Aggarwal859681b2012-02-03 10:02:24 -080090 /**
91 * Whether the server supports searching over all messages. This requires SYNCABLE_FOLDERS
92 * to be true, otherwise it should be ignored.
93 */
Paul Westbrook82ea6da2011-12-15 11:03:51 -080094 public static final int SERVER_SEARCH = 0x0010;
Vikram Aggarwal859681b2012-02-03 10:02:24 -080095 /**
96 * Whether the server supports constraining search to a single folder. Requires
97 * SYNCABLE_FOLDERS, otherwise it should be ignored.
98 */
Paul Westbrook82ea6da2011-12-15 11:03:51 -080099 public static final int FOLDER_SERVER_SEARCH = 0x0020;
Vikram Aggarwal859681b2012-02-03 10:02:24 -0800100 /**
101 * Whether the server sends us sanitized HTML (guaranteed to not contain malicious HTML).
102 */
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800103 public static final int SANITIZED_HTML = 0x0040;
Vikram Aggarwal859681b2012-02-03 10:02:24 -0800104 /**
105 * Whether the server allows synchronization of draft messages. This does NOT require
106 * SYNCABLE_FOLDERS to be set.
107 */
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800108 public static final int DRAFT_SYNCHRONIZATION = 0x0080;
Vikram Aggarwal859681b2012-02-03 10:02:24 -0800109 /**
110 * Does the server allow the user to compose mails (and reply) using addresses other than
111 * their account name? For instance, GMail allows users to set FROM addresses that are
112 * different from account@gmail.com address. For instance, user@gmail.com could have another
113 * FROM: address like user@android.com. If the user has enabled multiple FROM address, he
114 * can compose (and reply) using either address.
115 */
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800116 public static final int MULTIPLE_FROM_ADDRESSES = 0x0100;
Vikram Aggarwal859681b2012-02-03 10:02:24 -0800117 /**
118 * Whether the server allows the original message to be included in the reply by setting a
119 * flag on the reply. If we can avoid including the entire previous message, we save on
120 * bandwidth (replies are shorter).
121 */
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800122 public static final int SMART_REPLY = 0x0200;
Vikram Aggarwal859681b2012-02-03 10:02:24 -0800123 /**
124 * Does this account support searching locally, on the device? This requires the backend
125 * storage to support a mechanism for searching.
126 */
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800127 public static final int LOCAL_SEARCH = 0x0400;
Vikram Aggarwal859681b2012-02-03 10:02:24 -0800128 /**
129 * Whether the server supports a notion of threaded conversations: where replies to messages
130 * are tagged to keep conversations grouped. This could be full threading (each message
131 * lists its parent) or conversation-level threading (each message lists one conversation
132 * which it belongs to)
133 */
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800134 public static final int THREADED_CONVERSATIONS = 0x0800;
Vikram Aggarwal859681b2012-02-03 10:02:24 -0800135 /**
136 * Whether the server supports allowing a conversation to be in multiple folders. (Or allows
137 * multiple labels on a single conversation, since labels and folders are interchangeable
138 * in this application.)
139 */
Mindy Pereira84648892012-02-03 08:29:55 -0800140 public static final int MULTIPLE_FOLDERS_PER_CONV = 0x1000;
Mindy Pereira6f92de62011-12-19 11:31:48 -0800141 }
142
143 public static final class AccountColumns {
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800144 /**
145 * This string column contains the human visible name for the account.
146 */
Mindy Pereira6f92de62011-12-19 11:31:48 -0800147 public static final String NAME = "name";
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800148
149 /**
150 * This integer column returns the version of the UI provider schema from which this
151 * account provider will return results.
152 */
Mindy Pereira6f92de62011-12-19 11:31:48 -0800153 public static final String PROVIDER_VERSION = "providerVersion";
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800154
155 /**
156 * This string column contains the uri to directly access the information for this account.
157 */
Mindy Pereira6349a042012-01-04 11:25:01 -0800158 public static final String URI = "accountUri";
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800159
160 /**
161 * This integer column contains a bit field of the possible cabibilities that this account
162 * supports.
163 */
Mindy Pereira6f92de62011-12-19 11:31:48 -0800164 public static final String CAPABILITIES = "capabilities";
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800165
166 /**
Mindy Pereira750cc732011-12-21 13:32:29 -0800167 * This string column contains the content provider uri to return the
168 * list of top level folders for this account.
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800169 */
Mindy Pereira6f92de62011-12-19 11:31:48 -0800170 public static final String FOLDER_LIST_URI = "folderListUri";
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800171
172 /**
173 * This string column contains the content provider uri that can be queried for search
174 * results.
175 */
Mindy Pereira6f92de62011-12-19 11:31:48 -0800176 public static final String SEARCH_URI = "searchUri";
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800177
178 /**
179 * This string column contains the content provider uri that can be queried to access the
180 * from addresses for this account.
181 */
Mindy Pereira6f92de62011-12-19 11:31:48 -0800182 public static final String ACCOUNT_FROM_ADDRESSES_URI = "accountFromAddressesUri";
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800183
184 /**
185 * This string column contains the content provider uri that can be used to save (insert)
Mindy Pereira82cc5662012-01-09 17:29:30 -0800186 * new draft messages for this account. NOTE: This might be better to
187 * be an update operation on the messageUri.
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800188 */
Mindy Pereira33fe9082012-01-09 16:24:30 -0800189 public static final String SAVE_DRAFT_URI = "saveDraftUri";
Mindy Pereira6f92de62011-12-19 11:31:48 -0800190
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800191 /**
192 * This string column contains the content provider uri that can be used to send
193 * a message for this account.
194 * NOTE: This might be better to be an update operation on the messageUri.
195 */
Mindy Pereira7ed1c112012-01-18 10:59:25 -0800196 public static final String SEND_MAIL_URI = "sendMailUri";
Mindy Pereira82cc5662012-01-09 17:29:30 -0800197
198 /**
199 * This string column contains the content provider uri that can be used
200 * to expunge a message from this account. NOTE: This might be better to
201 * be an update operation on the messageUri.
202 */
203 public static final String EXPUNGE_MESSAGE_URI = "expungeMessageUri";
Mindy Pereira96b5c352012-02-01 11:33:40 -0800204
205 /**
206 * This string column contains the content provider uri that can be used
207 * to undo the last committed action.
208 */
209 public static String UNDO_URI = "undoUri";
Mindy Pereira3a565bf2011-12-21 11:26:21 -0800210 }
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800211
Mindy Pereira3a565bf2011-12-21 11:26:21 -0800212 // We define a "folder" as anything that contains a list of conversations.
213 public static final String FOLDER_LIST_TYPE =
214 "vnd.android.cursor.dir/vnd.com.android.mail.folder";
215 public static final String FOLDER_TYPE =
Mindy Pereira750cc732011-12-21 13:32:29 -0800216 "vnd.android.cursor.item/vnd.com.android.mail.folder";
Mindy Pereira3a565bf2011-12-21 11:26:21 -0800217
218 public static final String[] FOLDERS_PROJECTION = {
219 BaseColumns._ID,
Mindy Pereira6349a042012-01-04 11:25:01 -0800220 FolderColumns.URI,
Mindy Pereira3a565bf2011-12-21 11:26:21 -0800221 FolderColumns.NAME,
Mindy Pereira750cc732011-12-21 13:32:29 -0800222 FolderColumns.HAS_CHILDREN,
Mindy Pereira0973b202011-12-21 15:48:12 -0800223 FolderColumns.CAPABILITIES,
224 FolderColumns.SYNC_FREQUENCY,
225 FolderColumns.SYNC_WINDOW,
Mindy Pereira750cc732011-12-21 13:32:29 -0800226 FolderColumns.CONVERSATION_LIST_URI,
Mindy Pereirabd8f51c2012-01-06 13:41:48 -0800227 FolderColumns.CHILD_FOLDERS_LIST_URI,
228 FolderColumns.UNREAD_COUNT,
Marc Blankc8a99422012-01-19 14:27:47 -0800229 FolderColumns.TOTAL_COUNT,
Mindy Pereira3a565bf2011-12-21 11:26:21 -0800230 };
231
Mindy Pereira818143e2012-01-11 13:59:49 -0800232 public static final int FOLDER_ID_COLUMN = 0;
233 public static final int FOLDER_URI_COLUMN = 1;
234 public static final int FOLDER_NAME_COLUMN = 2;
235 public static final int FOLDER_HAS_CHILDREN_COLUMN = 3;
236 public static final int FOLDER_CAPABILITIES_COLUMN = 4;
237 public static final int FOLDER_SYNC_FREQUENCY_COLUMN = 5;
238 public static final int FOLDER_SYNC_WINDOW_COLUMN = 6;
239 public static final int FOLDER_CONVERSATION_LIST_URI_COLUMN = 7;
240 public static final int FOLDER_CHILD_FOLDERS_LIST_COLUMN = 8;
241 public static final int FOLDER_UNREAD_COUNT_COLUMN = 9;
242 public static final int FOLDER_TOTAL_COUNT_COLUMN = 10;
243
Mindy Pereira0973b202011-12-21 15:48:12 -0800244 public static final class FolderCapabilities {
245 public static final int SYNCABLE = 0x0001;
246 public static final int PARENT = 0x0002;
247 public static final int CAN_HOLD_MAIL = 0x0004;
248 public static final int CAN_ACCEPT_MOVED_MESSAGES = 0x0008;
249 }
250
Mindy Pereira3a565bf2011-12-21 11:26:21 -0800251 public static final class FolderColumns {
Mindy Pereira6349a042012-01-04 11:25:01 -0800252 public static String URI = "folderUri";
Mindy Pereira3a565bf2011-12-21 11:26:21 -0800253 /**
254 * This string column contains the human visible name for the folder.
255 */
256 public static final String NAME = "name";
257 /**
Mindy Pereira0973b202011-12-21 15:48:12 -0800258 * This int column represents the capabilities of the folder specified by
259 * FolderCapabilities flags.
260 */
261 public static String CAPABILITIES = "capabilities";
262 /**
Mindy Pereirafc2277e2012-01-11 10:23:44 -0800263 * This int column represents whether or not this folder has any
Mindy Pereira750cc732011-12-21 13:32:29 -0800264 * child folders.
265 */
266 public static String HAS_CHILDREN = "hasChildren";
267 /**
Vikram Aggarwalff7d02a2012-01-11 16:37:45 -0800268 * This int column represents how often the folder should be synchronized with the server.
Mindy Pereira0973b202011-12-21 15:48:12 -0800269 */
270 public static String SYNC_FREQUENCY = "syncFrequency";
271 /**
272 * This int column represents how large the sync window is.
273 */
274 public static String SYNC_WINDOW = "syncWindow";
275 /**
Mindy Pereira750cc732011-12-21 13:32:29 -0800276 * This string column contains the content provider uri to return the
277 * list of conversations for this folder.
Mindy Pereira3a565bf2011-12-21 11:26:21 -0800278 */
279 public static final String CONVERSATION_LIST_URI = "conversationListUri";
Mindy Pereira750cc732011-12-21 13:32:29 -0800280 /**
281 * This string column contains the content provider uri to return the
282 * list of child folders of this folder.
283 */
284 public static String CHILD_FOLDERS_LIST_URI = "childFoldersListUri";
Mindy Pereira3a565bf2011-12-21 11:26:21 -0800285
Mindy Pereirabd8f51c2012-01-06 13:41:48 -0800286 public static String UNREAD_COUNT = "unreadCount";
287
288 public static String TOTAL_COUNT = "totalCount";
289
Vikram Aggarwalff7d02a2012-01-11 16:37:45 -0800290 public FolderColumns() {}
Mindy Pereira6f92de62011-12-19 11:31:48 -0800291 }
292
Mindy Pereiraa1406072011-12-22 10:54:06 -0800293 // We define a "folder" as anything that contains a list of conversations.
294 public static final String CONVERSATION_LIST_TYPE =
295 "vnd.android.cursor.dir/vnd.com.android.mail.conversation";
296 public static final String CONVERSATION_TYPE =
297 "vnd.android.cursor.item/vnd.com.android.mail.conversation";
298
Mindy Pereira9cdc4062012-02-02 14:18:08 -0800299
Mindy Pereiraa1406072011-12-22 10:54:06 -0800300 public static final String[] CONVERSATION_PROJECTION = {
301 BaseColumns._ID,
Mindy Pereira6349a042012-01-04 11:25:01 -0800302 ConversationColumns.URI,
Mindy Pereiraf9573c52011-12-22 14:02:49 -0800303 ConversationColumns.MESSAGE_LIST_URI,
Mindy Pereiraa1406072011-12-22 10:54:06 -0800304 ConversationColumns.SUBJECT,
Mindy Pereiraf9573c52011-12-22 14:02:49 -0800305 ConversationColumns.SNIPPET,
306 ConversationColumns.SENDER_INFO,
Mindy Pereiraf30cc092011-12-29 14:02:40 -0800307 ConversationColumns.DATE_RECEIVED_MS,
Mindy Pereira4db59c52012-01-12 09:45:13 -0800308 ConversationColumns.HAS_ATTACHMENTS,
309 ConversationColumns.NUM_MESSAGES,
310 ConversationColumns.NUM_DRAFTS,
311 ConversationColumns.SENDING_STATE,
Marc Blankc8a99422012-01-19 14:27:47 -0800312 ConversationColumns.PRIORITY,
313 ConversationColumns.READ,
314 ConversationColumns.STARRED
Mindy Pereiraa1406072011-12-22 10:54:06 -0800315 };
316
Mindy Pereirafdd984b2011-12-29 09:43:45 -0800317 // These column indexes only work when the caller uses the
318 // default CONVERSATION_PROJECTION defined above.
Mindy Pereirafa7ef6e2011-12-29 14:18:15 -0800319 public static final int CONVERSATION_ID_COLUMN = 0;
Mindy Pereira3263fa92012-01-04 10:15:32 -0800320 public static final int CONVERSATION_URI_COLUMN = 1;
321 public static final int CONVERSATION_MESSAGE_LIST_URI_COLUMN = 2;
322 public static final int CONVERSATION_SUBJECT_COLUMN = 3;
323 public static final int CONVERSATION_SNIPPET_COLUMN = 4;
324 public static final int CONVERSATION_SENDER_INFO_COLUMN = 5;
325 public static final int CONVERSATION_DATE_RECEIVED_MS_COLUMN = 6;
326 public static final int CONVERSATION_HAS_ATTACHMENTS_COLUMN = 7;
Mindy Pereira4db59c52012-01-12 09:45:13 -0800327 public static final int CONVERSATION_NUM_MESSAGES_COLUMN = 8;
328 public static final int CONVERSATION_NUM_DRAFTS_COLUMN = 9;
329 public static final int CONVERSATION_SENDING_STATE_COLUMN = 10;
330 public static final int CONVERSATION_PRIORITY_COLUMN = 11;
Marc Blankc8a99422012-01-19 14:27:47 -0800331 public static final int CONVERSATION_READ_COLUMN = 12;
332 public static final int CONVERSATION_STARRED_COLUMN = 13;
Mindy Pereira4db59c52012-01-12 09:45:13 -0800333
334 public static final class ConversationSendingState {
Mindy Pereiraa4571372012-01-12 14:04:21 -0800335 public static final int OTHER = 0;
336 public static final int SENDING = 1;
337 public static final int SENT = 2;
Mindy Pereira4db59c52012-01-12 09:45:13 -0800338 public static final int SEND_ERROR = -1;
Vikram Aggarwal859681b2012-02-03 10:02:24 -0800339 }
Mindy Pereira4db59c52012-01-12 09:45:13 -0800340
341 public static final class ConversationPriority {
342 public static final int LOW = 0;
343 public static final int HIGH = 1;
Vikram Aggarwal859681b2012-02-03 10:02:24 -0800344 }
Mindy Pereirafa7ef6e2011-12-29 14:18:15 -0800345
Marc Blankc8a99422012-01-19 14:27:47 -0800346 public static final class ConversationFlags {
347 public static final int READ = 1<<0;
348 public static final int STARRED = 1<<1;
349 public static final int REPLIED = 1<<2;
350 public static final int FORWARDED = 1<<3;
Vikram Aggarwal859681b2012-02-03 10:02:24 -0800351 }
Marc Blankc8a99422012-01-19 14:27:47 -0800352
Mindy Pereiraa1406072011-12-22 10:54:06 -0800353 public static final class ConversationColumns {
Mindy Pereira6349a042012-01-04 11:25:01 -0800354 public static final String URI = "conversationUri";
Mindy Pereiraa1406072011-12-22 10:54:06 -0800355 /**
Mindy Pereiraa1406072011-12-22 10:54:06 -0800356 * This string column contains the content provider uri to return the
357 * list of messages for this conversation.
358 */
359 public static final String MESSAGE_LIST_URI = "messageListUri";
Mindy Pereira27a0cf02011-12-22 13:16:32 -0800360 /**
361 * This string column contains the subject string for a conversation.
362 */
363 public static final String SUBJECT = "subject";
364 /**
365 * This string column contains the snippet string for a conversation.
366 */
367 public static final String SNIPPET = "snippet";
368 /**
369 * This string column contains the sender info string for a
370 * conversation.
371 */
372 public static final String SENDER_INFO = "senderInfo";
373 /**
374 * This long column contains the time in ms of the latest update to a
375 * conversation.
376 */
377 public static final String DATE_RECEIVED_MS = "dateReceivedMs";
378
Mindy Pereiraf30cc092011-12-29 14:02:40 -0800379 /**
380 * This boolean column contains whether any messages in this conversation
381 * have attachments.
382 */
383 public static final String HAS_ATTACHMENTS = "hasAttachments";
384
Mindy Pereira4db59c52012-01-12 09:45:13 -0800385 /**
386 * This int column contains the number of messages in this conversation.
387 * For unthreaded, this will always be 1.
388 */
389 public static String NUM_MESSAGES = "numMessages";
390
391 /**
392 * This int column contains the number of drafts associated with this
393 * conversation.
394 */
395 public static String NUM_DRAFTS = "numDrafts";
396
397 /**
398 * This int column contains the state of drafts and replies associated
399 * with this conversation. Use ConversationSendingState to interpret
400 * this field.
401 */
402 public static String SENDING_STATE = "sendingState";
403
404 /**
405 * This int column contains the priority of this conversation. Use
406 * ConversationPriority to interpret this field.
407 */
408 public static String PRIORITY = "priority";
409
Marc Blankc8a99422012-01-19 14:27:47 -0800410 /**
411 * This boolean column indicates whether the conversation has been read
412 */
413 public static String READ = "read";
414
415 /**
416 * This boolean column indicates whether the conversation has been read
417 */
418 public static String STARRED = "starred";
419
Mindy Pereira27a0cf02011-12-22 13:16:32 -0800420 public ConversationColumns() {
Andy Huang732600e2012-01-10 17:47:17 -0800421 }
Mindy Pereiraa1406072011-12-22 10:54:06 -0800422 }
423
Mindy Pereira6f92de62011-12-19 11:31:48 -0800424 /**
425 * Returns a uri that, when queried, will return a cursor with a list of information for the
426 * list of configured accounts.
427 * @return
428 */
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800429 // TODO: create a static registry for the starting point for the UI provider.
430// public static Uri getAccountsUri() {
431// return Uri.parse(BASE_URI_STRING + "/");
432// }
433
434 public static final class DraftType {
Andy Huang97c25be2012-01-12 15:12:09 -0800435 public static final int NOT_A_DRAFT = 0;
436 public static final int COMPOSE = 1;
437 public static final int REPLY = 2;
438 public static final int REPLY_ALL = 3;
439 public static final int FORWARD = 4;
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800440
441 private DraftType() {}
Mindy Pereira6f92de62011-12-19 11:31:48 -0800442 }
443
Mindy Pereiraa1406072011-12-22 10:54:06 -0800444 public static final String[] MESSAGE_PROJECTION = {
445 BaseColumns._ID,
Mindy Pereira326c6602012-01-04 15:32:42 -0800446 MessageColumns.SERVER_ID,
Mindy Pereiraa1406072011-12-22 10:54:06 -0800447 MessageColumns.URI,
Mindy Pereiraa1406072011-12-22 10:54:06 -0800448 MessageColumns.CONVERSATION_ID,
449 MessageColumns.SUBJECT,
450 MessageColumns.SNIPPET,
451 MessageColumns.FROM,
452 MessageColumns.TO,
453 MessageColumns.CC,
454 MessageColumns.BCC,
455 MessageColumns.REPLY_TO,
456 MessageColumns.DATE_RECEIVED_MS,
457 MessageColumns.BODY_HTML,
458 MessageColumns.BODY_TEXT,
459 MessageColumns.EMBEDS_EXTERNAL_RESOURCES,
460 MessageColumns.REF_MESSAGE_ID,
461 MessageColumns.DRAFT_TYPE,
Mindy Pereira3ce64e72012-01-13 14:29:45 -0800462 MessageColumns.APPEND_REF_MESSAGE_CONTENT,
Mindy Pereiraf30cc092011-12-29 14:02:40 -0800463 MessageColumns.HAS_ATTACHMENTS,
Mindy Pereira326c6602012-01-04 15:32:42 -0800464 MessageColumns.ATTACHMENT_LIST_URI,
Mindy Pereiraf944e962012-01-17 11:43:36 -0800465 MessageColumns.MESSAGE_FLAGS,
Mindy Pereira7ed1c112012-01-18 10:59:25 -0800466 MessageColumns.JOINED_ATTACHMENT_INFOS,
467 MessageColumns.SAVE_MESSAGE_URI,
468 MessageColumns.SEND_MESSAGE_URI
Mindy Pereiraa1406072011-12-22 10:54:06 -0800469 };
470
Mindy Pereiraf944e962012-01-17 11:43:36 -0800471 /** Separates attachment info parts in strings in a message. */
472 public static final String MESSAGE_ATTACHMENT_INFO_SEPARATOR = "\n";
Mindy Pereiraa1406072011-12-22 10:54:06 -0800473 public static final String MESSAGE_LIST_TYPE =
474 "vnd.android.cursor.dir/vnd.com.android.mail.message";
475 public static final String MESSAGE_TYPE =
476 "vnd.android.cursor.item/vnd.com.android.mail.message";
Mindy Pereira6f92de62011-12-19 11:31:48 -0800477
Mindy Pereira6349a042012-01-04 11:25:01 -0800478 public static final int MESSAGE_ID_COLUMN = 0;
Mindy Pereira326c6602012-01-04 15:32:42 -0800479 public static final int MESSAGE_SERVER_ID_COLUMN = 1;
480 public static final int MESSAGE_URI_COLUMN = 2;
481 public static final int MESSAGE_CONVERSATION_ID_COLUMN = 3;
482 public static final int MESSAGE_SUBJECT_COLUMN = 4;
483 public static final int MESSAGE_SNIPPET_COLUMN = 5;
484 public static final int MESSAGE_FROM_COLUMN = 6;
485 public static final int MESSAGE_TO_COLUMN = 7;
486 public static final int MESSAGE_CC_COLUMN = 8;
487 public static final int MESSAGE_BCC_COLUMN = 9;
488 public static final int MESSAGE_REPLY_TO_COLUMN = 10;
489 public static final int MESSAGE_DATE_RECEIVED_MS_COLUMN = 11;
Mindy Pereira16668162012-01-11 16:11:19 -0800490 public static final int MESSAGE_BODY_HTML_COLUMN = 12;
491 public static final int MESSAGE_BODY_TEXT_COLUMN = 13;
Mindy Pereira326c6602012-01-04 15:32:42 -0800492 public static final int MESSAGE_EMBEDS_EXTERNAL_RESOURCES_COLUMN = 14;
493 public static final int MESSAGE_REF_MESSAGE_ID_COLUMN = 15;
494 public static final int MESSAGE_DRAFT_TYPE_COLUMN = 16;
Mindy Pereira3ce64e72012-01-13 14:29:45 -0800495 public static final int MESSAGE_APPEND_REF_MESSAGE_CONTENT_COLUMN = 17;
496 public static final int MESSAGE_HAS_ATTACHMENTS_COLUMN = 18;
497 public static final int MESSAGE_ATTACHMENT_LIST_URI_COLUMN = 19;
498 public static final int MESSAGE_FLAGS_COLUMN = 20;
Mindy Pereiraf944e962012-01-17 11:43:36 -0800499 public static final int MESSAGE_JOINED_ATTACHMENT_INFOS_COLUMN = 21;
Mindy Pereira7ed1c112012-01-18 10:59:25 -0800500 public static final int MESSAGE_SAVE_URI_COLUMN = 22;
501 public static final int MESSAGE_SEND_URI_COLUMN = 23;
Mindy Pereira6349a042012-01-04 11:25:01 -0800502
Mindy Pereiraf30cc092011-12-29 14:02:40 -0800503 public static final class MessageFlags {
Andy Huangdb977472012-01-11 19:53:25 -0800504 public static final int STARRED = 1 << 0;
505 public static final int UNREAD = 1 << 1;
506 public static final int REPLIED = 1 << 2;
507 public static final int FORWARDED = 1 << 3;
Mindy Pereiraf30cc092011-12-29 14:02:40 -0800508 }
509
Mindy Pereira6f92de62011-12-19 11:31:48 -0800510 public static final class MessageColumns {
Andy Huangdb977472012-01-11 19:53:25 -0800511 /**
512 * This string column contains a content provider URI that points to this single message.
513 */
Mindy Pereira6349a042012-01-04 11:25:01 -0800514 public static final String URI = "messageUri";
Andy Huangdb977472012-01-11 19:53:25 -0800515 /**
516 * This string column contains a server-assigned ID for this message.
517 */
518 public static final String SERVER_ID = "serverMessageId";
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800519 public static final String CONVERSATION_ID = "conversationId";
Andy Huangdb977472012-01-11 19:53:25 -0800520 /**
521 * This string column contains the subject of a message.
522 */
Mindy Pereira6f92de62011-12-19 11:31:48 -0800523 public static final String SUBJECT = "subject";
Andy Huangdb977472012-01-11 19:53:25 -0800524 /**
525 * This string column contains a snippet of the message body.
526 */
Mindy Pereira6f92de62011-12-19 11:31:48 -0800527 public static final String SNIPPET = "snippet";
Andy Huangdb977472012-01-11 19:53:25 -0800528 /**
529 * This string column contains the single email address (and optionally name) of the sender.
530 */
Mindy Pereira6f92de62011-12-19 11:31:48 -0800531 public static final String FROM = "fromAddress";
Andy Huangdb977472012-01-11 19:53:25 -0800532 /**
533 * This string column contains a comma-delimited list of "To:" recipient email addresses.
534 */
Mindy Pereira6f92de62011-12-19 11:31:48 -0800535 public static final String TO = "toAddresses";
Andy Huangdb977472012-01-11 19:53:25 -0800536 /**
537 * This string column contains a comma-delimited list of "CC:" recipient email addresses.
538 */
Mindy Pereira6f92de62011-12-19 11:31:48 -0800539 public static final String CC = "ccAddresses";
Andy Huangdb977472012-01-11 19:53:25 -0800540 /**
541 * This string column contains a comma-delimited list of "BCC:" recipient email addresses.
542 * This value will be null for incoming messages.
543 */
Mindy Pereira6f92de62011-12-19 11:31:48 -0800544 public static final String BCC = "bccAddresses";
Andy Huangdb977472012-01-11 19:53:25 -0800545 /**
546 * This string column contains the single email address (and optionally name) of the
547 * sender's reply-to address.
548 */
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800549 public static final String REPLY_TO = "replyToAddress";
Andy Huangdb977472012-01-11 19:53:25 -0800550 /**
551 * This long column contains the timestamp (in millis) of receipt of the message.
552 */
Mindy Pereira6f92de62011-12-19 11:31:48 -0800553 public static final String DATE_RECEIVED_MS = "dateReceivedMs";
Andy Huangdb977472012-01-11 19:53:25 -0800554 /**
555 * This string column contains the HTML form of the message body, if available. If not,
556 * a provider must populate BODY_TEXT.
557 */
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800558 public static final String BODY_HTML = "bodyHtml";
Andy Huangdb977472012-01-11 19:53:25 -0800559 /**
560 * This string column contains the plaintext form of the message body, if HTML is not
561 * otherwise available. If HTML is available, this value should be left empty (null).
562 */
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800563 public static final String BODY_TEXT = "bodyText";
Mindy Pereira6f92de62011-12-19 11:31:48 -0800564 public static final String EMBEDS_EXTERNAL_RESOURCES = "bodyEmbedsExternalResources";
Mindy Pereira3ce64e72012-01-13 14:29:45 -0800565 /**
566 * This string column contains an opaque string used by the sendMessage api.
567 */
Mindy Pereira6f92de62011-12-19 11:31:48 -0800568 public static final String REF_MESSAGE_ID = "refMessageId";
Andy Huangdb977472012-01-11 19:53:25 -0800569 /**
Andy Huang97c25be2012-01-12 15:12:09 -0800570 * This integer column contains the type of this draft, or zero (0) if this message is not a
571 * draft. See {@link DraftType} for possible values.
Andy Huangdb977472012-01-11 19:53:25 -0800572 */
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800573 public static final String DRAFT_TYPE = "draftType";
Andy Huangdb977472012-01-11 19:53:25 -0800574 /**
575 * This boolean column indicates whether an outgoing message should trigger special quoted
576 * text processing upon send. The value should default to zero (0) for protocols that do
577 * not support or require this flag, and for all incoming messages.
578 */
Mindy Pereira3ce64e72012-01-13 14:29:45 -0800579 public static final String APPEND_REF_MESSAGE_CONTENT = "appendRefMessageContent";
Andy Huangdb977472012-01-11 19:53:25 -0800580 /**
581 * This boolean column indicates whether a message has attachments. The list of attachments
582 * can be retrieved using the URI in {@link MessageColumns#ATTACHMENT_LIST_URI}.
583 */
Mindy Pereiraf30cc092011-12-29 14:02:40 -0800584 public static final String HAS_ATTACHMENTS = "hasAttachments";
Andy Huangdb977472012-01-11 19:53:25 -0800585 /**
Mindy Pereira7ed1c112012-01-18 10:59:25 -0800586 * This string column contains the content provider URI for the list of
587 * attachments associated with this message.
Andy Huangdb977472012-01-11 19:53:25 -0800588 */
Mindy Pereiraf30cc092011-12-29 14:02:40 -0800589 public static final String ATTACHMENT_LIST_URI = "attachmentListUri";
Andy Huangdb977472012-01-11 19:53:25 -0800590 /**
591 * This long column is a bit field of flags defined in {@link MessageFlags}.
592 */
Andy Huang732600e2012-01-10 17:47:17 -0800593 public static final String MESSAGE_FLAGS = "messageFlags";
Mindy Pereiraf944e962012-01-17 11:43:36 -0800594 /**
595 * This string column contains a specially formatted string representing all
596 * attachments that we added to a message that is being sent or saved.
597 */
Mindy Pereira84554ec2012-01-17 14:44:44 -0800598 public static final String JOINED_ATTACHMENT_INFOS = "joinedAttachmentInfos";
Mindy Pereira7ed1c112012-01-18 10:59:25 -0800599 /**
600 * This string column contains the content provider URI for saving this
601 * message.
602 */
603 public static final String SAVE_MESSAGE_URI = "saveMessageUri";
604 /**
605 * This string column contains content provider URI for sending this
606 * message.
607 */
608 public static final String SEND_MESSAGE_URI = "sendMessageUri";
Mindy Pereira6f92de62011-12-19 11:31:48 -0800609
610 private MessageColumns() {}
611 }
Mindy Pereiraf30cc092011-12-29 14:02:40 -0800612
613 // We define a "folder" as anything that contains a list of conversations.
614 public static final String ATTACHMENT_LIST_TYPE =
615 "vnd.android.cursor.dir/vnd.com.android.mail.attachment";
616 public static final String ATTACHMENT_TYPE =
617 "vnd.android.cursor.item/vnd.com.android.mail.attachment";
618
619 public static final String[] ATTACHMENT_PROJECTION = {
620 BaseColumns._ID,
621 AttachmentColumns.NAME,
622 AttachmentColumns.SIZE,
Mindy Pereira7a07fb42012-01-11 10:32:48 -0800623 AttachmentColumns.URI,
Mindy Pereiraf30cc092011-12-29 14:02:40 -0800624 AttachmentColumns.ORIGIN_EXTRAS,
625 AttachmentColumns.CONTENT_TYPE,
626 AttachmentColumns.SYNCED
627 };
Mindy Pereira82cc5662012-01-09 17:29:30 -0800628 private static final String EMAIL_SEPARATOR_PATTERN = "\n";
Mindy Pereira7a07fb42012-01-11 10:32:48 -0800629 public static final int ATTACHMENT_ID_COLUMN = 0;
630 public static final int ATTACHMENT_NAME_COLUMN = 1;
631 public static final int ATTACHMENT_SIZE_COLUMN = 2;
632 public static final int ATTACHMENT_URI_COLUMN = 3;
Mindy Pereiraf944e962012-01-17 11:43:36 -0800633 public static final int ATTACHMENT_ORIGIN_EXTRAS_COLUMN = 4;
634 public static final int ATTACHMENT_CONTENT_TYPE_COLUMN = 5;
635 public static final int ATTACHMENT_SYNCED_COLUMN = 6;
Mindy Pereiraf30cc092011-12-29 14:02:40 -0800636
637 public static final class AttachmentColumns {
638 public static final String NAME = "name";
639 public static final String SIZE = "size";
Mindy Pereira7a07fb42012-01-11 10:32:48 -0800640 public static final String URI = "uri";
Mindy Pereiraf30cc092011-12-29 14:02:40 -0800641 public static final String ORIGIN_EXTRAS = "originExtras";
642 public static final String CONTENT_TYPE = "contentType";
643 public static final String SYNCED = "synced";
644 }
Mindy Pereira013194c2012-01-06 15:09:33 -0800645
646 public static int getMailMaxAttachmentSize(String account) {
647 // TODO: query the account to see what the max attachment size is?
648 return 5 * 1024 * 1024;
649 }
650
651 public static String getAttachmentTypeSetting() {
652 // TODO: query the account to see what kinds of attachments it supports?
653 return "com.google.android.gm.allowAddAnyAttachment";
654 }
Mindy Pereira82cc5662012-01-09 17:29:30 -0800655
656 public static void incrementRecipientsTimesContacted(Context context, String addressString) {
657 DataUsageStatUpdater statsUpdater = new DataUsageStatUpdater(context);
658 ArrayList<String> recipients = new ArrayList<String>();
659 String[] addresses = TextUtils.split(addressString, EMAIL_SEPARATOR_PATTERN);
660 for (String address : addresses) {
661 recipients.add(address);
662 }
663 statsUpdater.updateWithAddress(recipients);
664 }
Marc Blankb31ab5a2012-02-01 12:28:29 -0800665
666 public static final String[] UNDO_PROJECTION = {
667 ConversationColumns.MESSAGE_LIST_URI
668 };
669 public static final int UNDO_MESSAGE_LIST_COLUMN = 0;
Marc Blankdd10bc82012-02-01 19:10:46 -0800670
671 // Parameter used to indicate the sequence number for an undoable operation
672 public static final String SEQUENCE_QUERY_PARAMETER = "seq";
Paul Westbrook82ea6da2011-12-15 11:03:51 -0800673}