1 /* 2 * Copyright (C) 2015 The Android Open Source Project 3 * 4 * Licensed under the Apache License, Version 2.0 (the "License"); 5 * you may not use this file except in compliance with the License. 6 * You may obtain a copy of the License at 7 * 8 * http://www.apache.org/licenses/LICENSE-2.0 9 * 10 * Unless required by applicable law or agreed to in writing, software 11 * distributed under the License is distributed on an "AS IS" BASIS, 12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 13 * See the License for the specific language governing permissions and 14 * limitations under the License. 15 */ 16 17 package com.android.messaging.datamodel.data; 18 19 import android.content.ContentValues; 20 import android.database.sqlite.SQLiteDatabase; 21 import android.net.Uri; 22 import android.provider.BaseColumns; 23 import android.provider.ContactsContract.CommonDataKinds.Phone; 24 import android.provider.ContactsContract.Contacts; 25 import android.provider.MediaStore.Images.Media; 26 27 import com.android.messaging.datamodel.BugleDatabaseOperations; 28 import com.android.messaging.datamodel.DatabaseHelper; 29 import com.android.messaging.datamodel.DatabaseHelper.ConversationColumns; 30 import com.android.messaging.datamodel.DatabaseHelper.MessageColumns; 31 import com.android.messaging.datamodel.DatabaseHelper.PartColumns; 32 import com.android.messaging.datamodel.DatabaseHelper.ParticipantColumns; 33 import com.android.messaging.datamodel.FakeCursor; 34 import com.android.messaging.datamodel.data.ConversationListItemData.ConversationListViewColumns; 35 import com.android.messaging.datamodel.data.ConversationMessageData.ConversationMessageViewColumns; 36 import com.android.messaging.util.Assert; 37 import com.android.messaging.util.ContactUtil; 38 import com.android.messaging.util.ContentType; 39 40 import java.util.Arrays; 41 import java.util.List; 42 43 /** 44 * A factory for fake objects that can be useful for multiple tests. 45 */ 46 public class TestDataFactory { 47 private final static String[] sConversationListCursorColumns = new String[] { 48 ConversationListViewColumns._ID, 49 ConversationListViewColumns.NAME, 50 ConversationListViewColumns.ICON, 51 ConversationListViewColumns.SNIPPET_TEXT, 52 ConversationListViewColumns.PREVIEW_URI, 53 ConversationListViewColumns.SORT_TIMESTAMP, 54 ConversationListViewColumns.READ, 55 ConversationListViewColumns.PREVIEW_CONTENT_TYPE, 56 ConversationListViewColumns.MESSAGE_STATUS, 57 }; 58 59 private final static String[] sContactCursorColumns = new String[] { 60 Phone.CONTACT_ID, 61 Phone.DISPLAY_NAME_PRIMARY, 62 Phone.PHOTO_THUMBNAIL_URI, 63 Phone.NUMBER, 64 Phone.TYPE, 65 Phone.LABEL, 66 Phone.LOOKUP_KEY, 67 Phone._ID, 68 Phone.SORT_KEY_PRIMARY, 69 }; 70 71 private final static String[] sFrequentContactCursorColumns = new String[] { 72 Contacts._ID, 73 Contacts.DISPLAY_NAME, 74 Contacts.PHOTO_URI, 75 Phone.LOOKUP_KEY, 76 }; 77 78 private final static String[] sConversationMessageCursorColumns = new String[] { 79 ConversationMessageViewColumns._ID, 80 ConversationMessageViewColumns.CONVERSATION_ID, 81 ConversationMessageViewColumns.PARTICIPANT_ID, 82 ConversationMessageViewColumns.SENT_TIMESTAMP, 83 ConversationMessageViewColumns.RECEIVED_TIMESTAMP, 84 ConversationMessageViewColumns.STATUS, 85 ConversationMessageViewColumns.SENDER_FULL_NAME, 86 ConversationMessageViewColumns.SENDER_PROFILE_PHOTO_URI, 87 ConversationMessageViewColumns.PARTS_IDS, 88 ConversationMessageViewColumns.PARTS_CONTENT_TYPES, 89 ConversationMessageViewColumns.PARTS_CONTENT_URIS, 90 ConversationMessageViewColumns.PARTS_WIDTHS, 91 ConversationMessageViewColumns.PARTS_HEIGHTS, 92 ConversationMessageViewColumns.PARTS_TEXTS, 93 ConversationMessageViewColumns.PARTS_COUNT 94 }; 95 96 private final static String[] sGalleryCursorColumns = new String[] { 97 Media._ID, 98 Media.DATA, 99 Media.WIDTH, 100 Media.HEIGHT, 101 Media.MIME_TYPE 102 }; 103 getConversationListCursor()104 public static FakeCursor getConversationListCursor() { 105 final Object[][] cursorData = new Object[][] { 106 new Object[] { Long.valueOf(1), "name1", "content://icon1", 107 "snippetText1", "content://snippetUri1", Long.valueOf(10), 1, 108 ContentType.IMAGE_JPEG, MessageData.BUGLE_STATUS_INCOMING_COMPLETE}, 109 new Object[] { Long.valueOf(2), "name2", "content://icon2", 110 "snippetText2", "content://snippetUri2", Long.valueOf(20) + 24*60*60*1000, 111 0, ContentType.IMAGE_JPEG, MessageData.BUGLE_STATUS_INCOMING_COMPLETE}, 112 new Object[] { Long.valueOf(3), "name3", "content://icon3", 113 "snippetText3", "content://snippetUri3", Long.valueOf(30) + 2*24*60*60*1000, 114 0, ContentType.IMAGE_JPEG, MessageData.BUGLE_STATUS_OUTGOING_COMPLETE} 115 }; 116 return new FakeCursor(ConversationListItemData.PROJECTION, sConversationListCursorColumns, 117 cursorData); 118 } 119 public static final int CONVERSATION_LIST_CURSOR_READ_MESSAGE_INDEX = 0; 120 public static final int CONVERSATION_LIST_CURSOR_UNREAD_MESSAGE_INDEX = 1; 121 getEmptyConversationListCursor()122 public static FakeCursor getEmptyConversationListCursor() { 123 return new FakeCursor(ConversationListItemData.PROJECTION, sConversationListCursorColumns, 124 new Object[][] {}); 125 } 126 getConversationMessageCursor()127 public static FakeCursor getConversationMessageCursor() { 128 final Object[][] cursorData = new Object[][] { 129 new Object[] { Long.valueOf(0), Long.valueOf(1), Long.valueOf(1), 130 Long.valueOf(10), Long.valueOf(10), 131 MessageData.BUGLE_STATUS_INCOMING_COMPLETE, "Alice", null, 132 "0", "text/plain", "''", -1, -1, "msg0", 1}, 133 new Object[] { Long.valueOf(1), Long.valueOf(1), Long.valueOf(2), 134 Long.valueOf(20), Long.valueOf(20), 135 MessageData.BUGLE_STATUS_OUTGOING_COMPLETE, "Bob", null, 136 "1", "text/plain", "''", -1, -1, "msg1", 1}, 137 new Object[] { Long.valueOf(2), Long.valueOf(1), Long.valueOf(1), 138 Long.valueOf(30), Long.valueOf(30), 139 MessageData.BUGLE_STATUS_OUTGOING_COMPLETE, "Alice", null, 140 "2", "contentType3", "'content://fakeUri3'", "0", "0", "msg1", 1}, 141 new Object[] { Long.valueOf(3), Long.valueOf(1), Long.valueOf(1), 142 Long.valueOf(40), Long.valueOf(40), 143 MessageData.BUGLE_STATUS_OUTGOING_COMPLETE, "Alice", null, 144 "3|4", "'contentType4'|'text/plain'", "'content://fakeUri4'|''", "0|-1", "0|-1", "''|'msg3'", 2}, 145 }; 146 return new FakeCursor( 147 ConversationMessageData.getProjection(), 148 sConversationMessageCursorColumns, 149 cursorData); 150 } 151 getMessageText(final FakeCursor messageCursor, final int row)152 public static String getMessageText(final FakeCursor messageCursor, final int row) { 153 final String allPartsText = messageCursor.getAt(ConversationMessageViewColumns.PARTS_TEXTS, row) 154 .toString(); 155 final int partsCount = (Integer) messageCursor.getAt( 156 ConversationMessageViewColumns.PARTS_COUNT, row); 157 final String messageId = messageCursor.getAt( 158 ConversationMessageViewColumns._ID, row).toString(); 159 final List<MessagePartData> parts = ConversationMessageData.makeParts( 160 messageCursor.getAt(ConversationMessageViewColumns.PARTS_IDS, row).toString(), 161 messageCursor.getAt(ConversationMessageViewColumns.PARTS_CONTENT_TYPES, row).toString(), 162 messageCursor.getAt(ConversationMessageViewColumns.PARTS_CONTENT_URIS, row).toString(), 163 messageCursor.getAt(ConversationMessageViewColumns.PARTS_WIDTHS, row).toString(), 164 messageCursor.getAt(ConversationMessageViewColumns.PARTS_HEIGHTS, row).toString(), 165 messageCursor.getAt(ConversationMessageViewColumns.PARTS_TEXTS, row).toString(), 166 partsCount, 167 messageId); 168 169 for (final MessagePartData part : parts) { 170 if (part.isText()) { 171 return part.getText(); 172 } 173 } 174 return null; 175 } 176 177 // Indexes where to find consecutive and non consecutive messages from same participant 178 // (respect to index - 1). 179 public static final int MESSAGE_WITH_SAME_PARTICIPANT_AS_PREVIOUS = 3; 180 public static final int MESSAGE_WITH_DIFFERENT_PARTICIPANT_AS_PREVIOUS = 2; 181 getConversationParticipantsCursor()182 public static FakeCursor getConversationParticipantsCursor() { 183 final String[] sConversationParticipantsCursorColumns = new String[] { 184 ParticipantColumns._ID, 185 ParticipantColumns.SUB_ID, 186 ParticipantColumns.NORMALIZED_DESTINATION, 187 ParticipantColumns.SEND_DESTINATION, 188 ParticipantColumns.FULL_NAME, 189 ParticipantColumns.FIRST_NAME, 190 ParticipantColumns.PROFILE_PHOTO_URI, 191 }; 192 193 final Object[][] cursorData = new Object[][] { 194 new Object[] { 1, ParticipantData.OTHER_THAN_SELF_SUB_ID, "+15554567890", 195 "(555)456-7890", "alice in wonderland", "alice", "alice.png" }, 196 new Object[] { 2, ParticipantData.OTHER_THAN_SELF_SUB_ID, "+15551011121", 197 "(555)101-1121", "bob the baker", "bob", "bob.png"}, 198 new Object[] { 3, ParticipantData.OTHER_THAN_SELF_SUB_ID, "+15551314152", 199 "(555)131-4152", "charles in charge", "charles", "charles.png" }, 200 }; 201 202 return new FakeCursor(ParticipantData.ParticipantsQuery.PROJECTION, 203 sConversationParticipantsCursorColumns, cursorData); 204 } 205 206 public static final int CONTACT_LIST_CURSOR_FIRST_LEVEL_CONTACT_INDEX = 0; 207 public static final int CONTACT_LIST_CURSOR_SECOND_LEVEL_CONTACT_INDEX = 2; 208 209 /** 210 * Returns a cursor for the all contacts list consumable by ContactPickerFragment. 211 */ getAllContactListCursor()212 public static FakeCursor getAllContactListCursor() { 213 final Object[][] cursorData = new Object[][] { 214 new Object[] { Long.valueOf(0), "John Smith", "content://uri1", 215 "425-555-1234", Phone.TYPE_HOME, "", "0", Long.valueOf(0), 0 }, 216 new Object[] { Long.valueOf(1), "Sun Woo Kong", "content://uri2", 217 "425-555-1235", Phone.TYPE_MOBILE, "", "1", Long.valueOf(1), 1 }, 218 new Object[] { Long.valueOf(1), "Sun Woo Kong", "content://uri2", 219 "425-555-1238", Phone.TYPE_HOME, "", "1", Long.valueOf(2), 2 }, 220 new Object[] { Long.valueOf(2), "Anna Kinney", "content://uri3", 221 "425-555-1236", Phone.TYPE_MAIN, "", "3", Long.valueOf(3), 3 }, 222 new Object[] { Long.valueOf(3), "Mike Jones", "content://uri3", 223 "425-555-1236", Phone.TYPE_MAIN, "", "5", Long.valueOf(4), 4 }, 224 }; 225 return new FakeCursor(ContactUtil.PhoneQuery.PROJECTION, sContactCursorColumns, 226 cursorData); 227 } 228 229 /** 230 * Returns a cursor for the frequent contacts list consumable by ContactPickerFragment. 231 * Note: make it so that this cursor is the generated result of getStrequentContactsCursor() 232 * and getAllContactListCursor(), i.e., expand the entries in getStrequentContactsCursor() 233 * with the details from getAllContactListCursor() 234 */ getFrequentContactListCursor()235 public static FakeCursor getFrequentContactListCursor() { 236 final Object[][] cursorData = new Object[][] { 237 new Object[] { Long.valueOf(2), "Anna Kinney", "content://uri3", 238 "425-555-1236", Phone.TYPE_MAIN, "", "3", Long.valueOf(3), 0 }, 239 new Object[] { Long.valueOf(1), "Sun Woo Kong", "content://uri2", 240 "425-555-1235", Phone.TYPE_MOBILE, "", "1", Long.valueOf(1), 1}, 241 new Object[] { Long.valueOf(1), "Sun Woo Kong", "content://uri2", 242 "425-555-1238", Phone.TYPE_HOME, "", "1", Long.valueOf(2), 2 }, 243 new Object[] { Long.valueOf(0), "John Smith", "content://uri1", 244 "425-555-1234", Phone.TYPE_HOME, "", "0", Long.valueOf(0), 3 }, 245 }; 246 return new FakeCursor(ContactUtil.PhoneQuery.PROJECTION, sContactCursorColumns, 247 cursorData); 248 } 249 250 /** 251 * Returns a strequent (starred + frequent) cursor (like the one produced by android contact 252 * provider's CONTENT_STREQUENT_URI query) that's consumable by FrequentContactsCursorBuilder. 253 */ getStrequentContactsCursor()254 public static FakeCursor getStrequentContactsCursor() { 255 final Object[][] cursorData = new Object[][] { 256 new Object[] { Long.valueOf(0), "Anna Kinney", "content://uri1", "3" }, 257 new Object[] { Long.valueOf(1), "Sun Woo Kong", "content://uri2", "1" }, 258 new Object[] { Long.valueOf(2), "John Smith", "content://uri3", "0" }, 259 // Email-only entry that shouldn't be included in the result. 260 new Object[] { Long.valueOf(3), "Email Contact", "content://uri4", "100" }, 261 }; 262 return new FakeCursor(ContactUtil.FrequentContactQuery.PROJECTION, 263 sFrequentContactCursorColumns, cursorData); 264 } 265 266 public static final int SMS_MMS_THREAD_ID_CURSOR_VALUE = 123456789; 267 getSmsMmsThreadIdCursor()268 public static FakeCursor getSmsMmsThreadIdCursor() { 269 final String[] ID_PROJECTION = { BaseColumns._ID }; 270 final Object[][] cursorData = new Object[][] { 271 new Object[] { Long.valueOf(SMS_MMS_THREAD_ID_CURSOR_VALUE) }, 272 }; 273 return new FakeCursor(ID_PROJECTION, ID_PROJECTION, cursorData); 274 } 275 getGalleryGridCursor()276 public static FakeCursor getGalleryGridCursor() { 277 final Object[][] cursorData = new Object[][] { 278 new Object[] { Long.valueOf(0), "/sdcard/image1", 100, 100, "image/jpeg" }, 279 new Object[] { Long.valueOf(1), "/sdcard/image2", 200, 200, "image/png" }, 280 new Object[] { Long.valueOf(2), "/sdcard/image3", 300, 300, "image/jpeg" }, 281 }; 282 return new FakeCursor(GalleryGridItemData.MEDIA_PROJECTION, sGalleryCursorColumns, 283 cursorData); 284 } 285 286 public static final int NUM_TEST_CONVERSATIONS = 10; 287 288 /** 289 * Create test data in our db. 290 * 291 * Ideally this will create more realistic data with more variety. 292 */ createTestData(final SQLiteDatabase db)293 public static void createTestData(final SQLiteDatabase db) { 294 BugleDatabaseOperations.clearParticipantIdCache(); 295 296 // Timestamp for 1 day ago 297 final long yesterday = System.currentTimeMillis() - (24 * 60 * 60 * 1000); 298 299 final ContentValues conversationValues = new ContentValues(); 300 for (int i = 1; i <= NUM_TEST_CONVERSATIONS; i++) { 301 conversationValues.put(ConversationColumns.NAME, "Conversation " + i); 302 final long conversationId = db.insert(DatabaseHelper.CONVERSATIONS_TABLE, null, 303 conversationValues); 304 305 final ContentValues messageValues = new ContentValues(); 306 for (int m = 1; m <= 25; m++) { 307 // Move forward ten minutes per conversation, 1 minute per message. 308 final long messageTime = yesterday + (i * 10 * 60 * 1000) + (m * 60 * 1000); 309 messageValues.put(MessageColumns.RECEIVED_TIMESTAMP, messageTime); 310 messageValues.put(MessageColumns.CONVERSATION_ID, conversationId); 311 messageValues.put(MessageColumns.SENDER_PARTICIPANT_ID, 312 Math.abs(("" + messageTime).hashCode()) % 2); 313 final long messageId = db.insert(DatabaseHelper.MESSAGES_TABLE, null, messageValues); 314 315 // Create a text part for this message 316 final ContentValues partValues = new ContentValues(); 317 partValues.put(PartColumns.MESSAGE_ID, messageId); 318 partValues.put(PartColumns.CONVERSATION_ID, conversationId); 319 partValues.put(PartColumns.TEXT, "Conversation: " + conversationId + 320 " Message: " + m); 321 db.insert(DatabaseHelper.PARTS_TABLE, null, partValues); 322 323 // Update the snippet for this conversation to the latest message inserted 324 conversationValues.clear(); 325 conversationValues.put(ConversationColumns.LATEST_MESSAGE_ID, messageId); 326 final int updatedCount = db.update(DatabaseHelper.CONVERSATIONS_TABLE, 327 conversationValues, 328 "_id=?", new String[]{String.valueOf(conversationId)}); 329 Assert.isTrue(updatedCount == 1); 330 } 331 } 332 } 333 getTestDraftAttachments()334 public static List<MessagePartData> getTestDraftAttachments() { 335 final MessagePartData[] retParts = new MessagePartData[] { 336 new MessagePartData(ContentType.IMAGE_JPEG, Uri.parse("content://image"), 337 100, 100), 338 new MessagePartData(ContentType.VIDEO_3GPP, Uri.parse("content://video"), 339 100, 100), 340 new MessagePartData(ContentType.TEXT_VCARD, Uri.parse("content://vcard"), 341 0, 0), 342 new MessagePartData(ContentType.AUDIO_3GPP, Uri.parse("content://audio"), 343 0, 0) 344 }; 345 return Arrays.asList(retParts); 346 } 347 } 348