1 package com.android.bluetooth.tests; 2 3 import android.test.AndroidTestCase; 4 import android.util.Log; 5 import android.database.Cursor; 6 import android.content.Context; 7 import android.content.ContentResolver; 8 9 import java.text.SimpleDateFormat; 10 import java.util.Date; 11 12 import com.android.bluetooth.map.BluetoothMapContent; 13 import com.android.bluetooth.map.BluetoothMapContentObserver; 14 15 import com.android.emailcommon.provider.EmailContent; 16 import com.android.emailcommon.provider.EmailContent.Message; 17 import com.android.emailcommon.provider.EmailContent.MessageColumns; 18 import com.android.emailcommon.provider.EmailContent.SyncColumns; 19 20 public class BluetoothMapContentTest extends AndroidTestCase { 21 private static final String TAG = "BluetoothMapContentTest"; 22 23 private static final boolean D = true; 24 private static final boolean V = true; 25 26 private Context mContext; 27 private ContentResolver mResolver; 28 29 static final String[] EMAIL_PROJECTION = new String[] { 30 EmailContent.RECORD_ID, 31 MessageColumns.DISPLAY_NAME, MessageColumns.TIMESTAMP, 32 MessageColumns.SUBJECT, MessageColumns.FLAG_READ, 33 MessageColumns.FLAG_ATTACHMENT, MessageColumns.FLAGS, 34 SyncColumns.SERVER_ID, MessageColumns.DRAFT_INFO, 35 MessageColumns.MESSAGE_ID, MessageColumns.MAILBOX_KEY, 36 MessageColumns.ACCOUNT_KEY, MessageColumns.FROM_LIST, 37 MessageColumns.TO_LIST, MessageColumns.CC_LIST, 38 MessageColumns.BCC_LIST, MessageColumns.REPLY_TO_LIST, 39 SyncColumns.SERVER_TIMESTAMP, MessageColumns.MEETING_INFO, 40 MessageColumns.SNIPPET, MessageColumns.PROTOCOL_SEARCH_INFO, 41 MessageColumns.THREAD_TOPIC 42 }; 43 getDateTimeString(long timestamp)44 private String getDateTimeString(long timestamp) { 45 SimpleDateFormat format = new SimpleDateFormat("yyyyMMdd'T'HHmmss"); 46 Date date = new Date(timestamp); 47 return format.format(date); // Format to YYYYMMDDTHHMMSS local time 48 } 49 printEmail(Cursor c)50 private void printEmail(Cursor c) { 51 if (D) Log.d(TAG, "printEmail " + 52 c.getLong(c.getColumnIndex(EmailContent.RECORD_ID)) + 53 "\n " + MessageColumns.DISPLAY_NAME + " : " + c.getString(c.getColumnIndex(MessageColumns.DISPLAY_NAME)) + 54 "\n " + MessageColumns.TIMESTAMP + " : " + getDateTimeString(c.getLong(c.getColumnIndex(MessageColumns.TIMESTAMP))) + 55 "\n " + MessageColumns.SUBJECT + " : " + c.getString(c.getColumnIndex(MessageColumns.SUBJECT)) + 56 "\n " + MessageColumns.FLAG_READ + " : " + c.getString(c.getColumnIndex(MessageColumns.FLAG_READ)) + 57 "\n " + MessageColumns.FLAG_ATTACHMENT + " : " + c.getInt(c.getColumnIndex(MessageColumns.FLAG_ATTACHMENT)) + 58 "\n " + MessageColumns.FLAGS + " : " + c.getInt(c.getColumnIndex(MessageColumns.FLAGS)) + 59 "\n " + SyncColumns.SERVER_ID + " : " + c.getInt(c.getColumnIndex(SyncColumns.SERVER_ID)) + 60 "\n " + MessageColumns.DRAFT_INFO + " : " + c.getInt(c.getColumnIndex(MessageColumns.DRAFT_INFO)) + 61 "\n " + MessageColumns.MESSAGE_ID + " : " + c.getInt(c.getColumnIndex(MessageColumns.MESSAGE_ID)) + 62 "\n " + MessageColumns.MAILBOX_KEY + " : " + c.getInt(c.getColumnIndex(MessageColumns.MAILBOX_KEY)) + 63 "\n " + MessageColumns.ACCOUNT_KEY + " : " + c.getInt(c.getColumnIndex(MessageColumns.ACCOUNT_KEY)) + 64 "\n " + MessageColumns.FROM_LIST + " : " + c.getString(c.getColumnIndex(MessageColumns.FROM_LIST)) + 65 "\n " + MessageColumns.TO_LIST + " : " + c.getString(c.getColumnIndex(MessageColumns.TO_LIST)) + 66 "\n " + MessageColumns.CC_LIST + " : " + c.getString(c.getColumnIndex(MessageColumns.CC_LIST)) + 67 "\n " + MessageColumns.BCC_LIST + " : " + c.getString(c.getColumnIndex(MessageColumns.BCC_LIST)) + 68 "\n " + MessageColumns.REPLY_TO_LIST + " : " + c.getString(c.getColumnIndex(MessageColumns.REPLY_TO_LIST)) + 69 "\n " + SyncColumns.SERVER_TIMESTAMP + " : " + getDateTimeString(c.getLong(c.getColumnIndex(SyncColumns.SERVER_TIMESTAMP))) + 70 "\n " + MessageColumns.MEETING_INFO + " : " + c.getString(c.getColumnIndex(MessageColumns.MEETING_INFO)) + 71 "\n " + MessageColumns.SNIPPET + " : " + c.getString(c.getColumnIndex(MessageColumns.SNIPPET)) + 72 "\n " + MessageColumns.PROTOCOL_SEARCH_INFO + " : " + c.getString(c.getColumnIndex(MessageColumns.PROTOCOL_SEARCH_INFO)) + 73 "\n " + MessageColumns.THREAD_TOPIC + " : " + c.getString(c.getColumnIndex(MessageColumns.THREAD_TOPIC))); 74 } 75 dumpEmailMessageTable()76 public void dumpEmailMessageTable() { 77 Log.d(TAG, "**** Dump of email message table ****"); 78 79 Cursor c = mResolver.query(Message.CONTENT_URI, 80 EMAIL_PROJECTION, null, null, "_id DESC"); 81 if (c != null) { 82 Log.d(TAG, "c.getCount() = " + c.getCount()); 83 c.moveToPosition(-1); 84 while (c.moveToNext()) { 85 printEmail(c); 86 } 87 } else { 88 Log.d(TAG, "query failed"); 89 c.close(); 90 } 91 } 92 BluetoothMapContentTest()93 public BluetoothMapContentTest() { 94 super(); 95 } 96 testDumpMessages()97 public void testDumpMessages() { 98 mContext = this.getContext(); 99 mResolver = mContext.getContentResolver(); 100 dumpEmailMessageTable(); 101 } 102 } 103