ProviderTests.java revision e37881aac562c066e6e666349749e40b7c116a21
17143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler/* 27143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * Copyright (C) 2009 The Android Open Source Project 37143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * 47143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * Licensed under the Apache License, Version 2.0 (the "License"); 57143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * you may not use this file except in compliance with the License. 67143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * You may obtain a copy of the License at 77143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * 87143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * http://www.apache.org/licenses/LICENSE-2.0 97143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * 107143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * Unless required by applicable law or agreed to in writing, software 117143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * distributed under the License is distributed on an "AS IS" BASIS, 127143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 137143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * See the License for the specific language governing permissions and 147143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * limitations under the License. 157143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 167143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 177143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadlerpackage com.android.email.provider; 187143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 197143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadlerimport com.android.email.provider.EmailContent.Account; 209e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadlerimport com.android.email.provider.EmailContent.AccountColumns; 21976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blankimport com.android.email.provider.EmailContent.Attachment; 226c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadlerimport com.android.email.provider.EmailContent.AttachmentColumns; 237143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadlerimport com.android.email.provider.EmailContent.Body; 249627d014e16235eadf981b9165807dc72a14a383Mihai Predaimport com.android.email.provider.EmailContent.BodyColumns; 25da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadlerimport com.android.email.provider.EmailContent.HostAuth; 267143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadlerimport com.android.email.provider.EmailContent.Mailbox; 2741f775bbc731b25854da9f5a80c66a4aa1eb0af9satokimport com.android.email.provider.EmailContent.MailboxColumns; 287143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadlerimport com.android.email.provider.EmailContent.Message; 29ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadlerimport com.android.email.provider.EmailContent.MessageColumns; 307143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 31ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadlerimport android.content.ContentResolver; 327143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadlerimport android.content.ContentUris; 33ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadlerimport android.content.ContentValues; 347143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadlerimport android.content.Context; 357143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadlerimport android.database.Cursor; 367143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadlerimport android.net.Uri; 374a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadlerimport android.os.Bundle; 38976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blankimport android.os.Environment; 394a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadlerimport android.os.Parcel; 40e37881aac562c066e6e666349749e40b7c116a21Makoto Onukiimport android.test.MoreAsserts; 417143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadlerimport android.test.ProviderTestCase2; 427143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 43758a532fce2f672673d38b2daa5f67eb757b118bMarc Blankimport java.io.File; 44758a532fce2f672673d38b2daa5f67eb757b118bMarc Blankimport java.io.IOException; 45758a532fce2f672673d38b2daa5f67eb757b118bMarc Blankimport java.util.ArrayList; 46758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 477143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler/** 487143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * Tests of the Email provider. 49758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank * 507143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * You can run this entire test case with: 517143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * runtest -c com.android.email.provider.ProviderTests email 527143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 537143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadlerpublic class ProviderTests extends ProviderTestCase2<EmailProvider> { 54758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 557143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler EmailProvider mProvider; 567143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler Context mMockContext; 577143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 587143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public ProviderTests() { 597143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler super(EmailProvider.class, EmailProvider.EMAIL_AUTHORITY); 607143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 61758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 627143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler @Override 637143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public void setUp() throws Exception { 647143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler super.setUp(); 657143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler mMockContext = getMockContext(); 667143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 677143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 687143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler @Override 697143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public void tearDown() throws Exception { 707143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler super.tearDown(); 717143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 727143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 737143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 740d00889f83fc8c1d69039a2c849b630fb4dd28ddAndrew Stadler * TODO: Database upgrade tests 750d00889f83fc8c1d69039a2c849b630fb4dd28ddAndrew Stadler */ 760d00889f83fc8c1d69039a2c849b630fb4dd28ddAndrew Stadler 770d00889f83fc8c1d69039a2c849b630fb4dd28ddAndrew Stadler /** 787143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * Test simple account save/retrieve 797143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 807143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public void testAccountSave() { 8128448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("account-save", true, mMockContext); 827143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long account1Id = account1.mId; 83758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 847143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler Account account2 = EmailContent.Account.restoreAccountWithId(mMockContext, account1Id); 85758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 8628448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler ProviderTestUtils.assertAccountEqual("testAccountSave", account1, account2); 877143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 8841f775bbc731b25854da9f5a80c66a4aa1eb0af9satok 894a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler /** 90da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler * Test simple account save/retrieve with predefined hostauth records 91da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler */ 92da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler public void testAccountSaveHostAuth() { 93da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler Account account1 = ProviderTestUtils.setupAccount("account-hostauth", false, mMockContext); 94da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler // add hostauth data, which should be saved the first time 95da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler account1.mHostAuthRecv = ProviderTestUtils.setupHostAuth("account-hostauth-recv", -1, false, 96da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler mMockContext); 97da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler account1.mHostAuthSend = ProviderTestUtils.setupHostAuth("account-hostauth-send", -1, false, 98da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler mMockContext); 99da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler account1.save(mMockContext); 100da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler long account1Id = account1.mId; 101da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler 102da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler // Confirm account reads back correctly 103da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler Account account1get = EmailContent.Account.restoreAccountWithId(mMockContext, account1Id); 104da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler ProviderTestUtils.assertAccountEqual("testAccountSave", account1, account1get); 105da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler 106da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler // Confirm hostauth fields can be accessed & read back correctly 107da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler HostAuth hostAuth1get = EmailContent.HostAuth.restoreHostAuthWithId(mMockContext, 108da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler account1get.mHostAuthKeyRecv); 109da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler ProviderTestUtils.assertHostAuthEqual("testAccountSaveHostAuth-recv", 110da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler account1.mHostAuthRecv, hostAuth1get); 111da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler HostAuth hostAuth2get = EmailContent.HostAuth.restoreHostAuthWithId(mMockContext, 112da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler account1get.mHostAuthKeySend); 113da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler ProviderTestUtils.assertHostAuthEqual("testAccountSaveHostAuth-send", 114da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler account1.mHostAuthSend, hostAuth2get); 115da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler } 116da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler 117da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler /** 1184a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler * Simple test of account parceling. The rather tortuous path is to ensure that the 1194a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler * account is really flattened all the way down to a parcel and back. 1204a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler */ 1214a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler public void testAccountParcel() { 1224a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler Account account1 = ProviderTestUtils.setupAccount("parcel", false, mMockContext); 1234a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler Bundle b = new Bundle(); 1244a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler b.putParcelable("account", account1); 1254a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler Parcel p = Parcel.obtain(); 1264a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler b.writeToParcel(p, 0); 1274a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler p.setDataPosition(0); // rewind it for reading 1284a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler Bundle b2 = new Bundle(Account.class.getClassLoader()); 1294a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler b2.readFromParcel(p); 1304a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler Account account2 = (Account) b2.getParcelable("account"); 1314a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler p.recycle(); 1324a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler 1334a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler ProviderTestUtils.assertAccountEqual("testAccountParcel", account1, account2); 1344a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler } 1354a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler 136e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki /** 137e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki * Test for {@link Account#getShortcutSafeUri()} and 138e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki * {@link Account#getAccountIdForShortcutSafeUri}. 139e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki */ 140e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki public void testAccountShortcutSafeUri() { 141e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki final Account account1 = ProviderTestUtils.setupAccount("account-1", true, mMockContext); 142e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki final Account account2 = ProviderTestUtils.setupAccount("account-2", true, mMockContext); 143e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki final long account1Id = account1.mId; 144e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki final long account2Id = account2.mId; 145e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki 146e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki final Uri uri1 = account1.getShortcutSafeUri(); 147e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki final Uri uri2 = account2.getShortcutSafeUri(); 148e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki 149e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki // Check the path part of the URIs. 150e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki MoreAsserts.assertEquals(new String[] {"account", account1.mCompatibilityUuid}, 151e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki uri1.getPathSegments().toArray()); 152e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki MoreAsserts.assertEquals(new String[] {"account", account2.mCompatibilityUuid}, 153e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki uri2.getPathSegments().toArray()); 154e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki 155e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki assertEquals(account1Id, Account.getAccountIdFromShortcutSafeUri(mMockContext, uri1)); 156e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki assertEquals(account2Id, Account.getAccountIdFromShortcutSafeUri(mMockContext, uri2)); 157e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki 158e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki // Test for the Eclair(2.0-2.1) style URI. 159e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki assertEquals(account1Id, Account.getAccountIdFromShortcutSafeUri(mMockContext, 160e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki getEclairStyleShortcutUri(account1))); 161e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki assertEquals(account2Id, Account.getAccountIdFromShortcutSafeUri(mMockContext, 162e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki getEclairStyleShortcutUri(account2))); 163e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki } 164e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki 165e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki private static Uri getEclairStyleShortcutUri(Account account) { 166e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki // We used _id instead of UUID only on Eclair(2.0-2.1). 167e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki return Account.CONTENT_URI.buildUpon().appendEncodedPath("" + account.mId).build(); 168e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki } 169e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki 17041f775bbc731b25854da9f5a80c66a4aa1eb0af9satok private final static String[] MAILBOX_UNREAD_COUNT_PROJECTION = new String [] { 17141f775bbc731b25854da9f5a80c66a4aa1eb0af9satok MailboxColumns.UNREAD_COUNT 17241f775bbc731b25854da9f5a80c66a4aa1eb0af9satok }; 17341f775bbc731b25854da9f5a80c66a4aa1eb0af9satok private final static int MAILBOX_UNREAD_COUNT_COLMUN = 0; 17441f775bbc731b25854da9f5a80c66a4aa1eb0af9satok 17541f775bbc731b25854da9f5a80c66a4aa1eb0af9satok /** 17641f775bbc731b25854da9f5a80c66a4aa1eb0af9satok * Get the value of the unread count in the mailbox of the account. 17741f775bbc731b25854da9f5a80c66a4aa1eb0af9satok * This can be different from the actual number of unread messages in that mailbox. 17841f775bbc731b25854da9f5a80c66a4aa1eb0af9satok * @param accountId 17941f775bbc731b25854da9f5a80c66a4aa1eb0af9satok * @param mailboxId 18041f775bbc731b25854da9f5a80c66a4aa1eb0af9satok * @return 18141f775bbc731b25854da9f5a80c66a4aa1eb0af9satok */ 18241f775bbc731b25854da9f5a80c66a4aa1eb0af9satok private int getUnreadCount(long mailboxId) { 18341f775bbc731b25854da9f5a80c66a4aa1eb0af9satok String text = null; 18441f775bbc731b25854da9f5a80c66a4aa1eb0af9satok Cursor c = null; 18541f775bbc731b25854da9f5a80c66a4aa1eb0af9satok try { 18641f775bbc731b25854da9f5a80c66a4aa1eb0af9satok c = mMockContext.getContentResolver().query( 18741f775bbc731b25854da9f5a80c66a4aa1eb0af9satok Mailbox.CONTENT_URI, 18841f775bbc731b25854da9f5a80c66a4aa1eb0af9satok MAILBOX_UNREAD_COUNT_PROJECTION, 18941f775bbc731b25854da9f5a80c66a4aa1eb0af9satok EmailContent.RECORD_ID + "=?", 19041f775bbc731b25854da9f5a80c66a4aa1eb0af9satok new String[] { String.valueOf(mailboxId) }, 19141f775bbc731b25854da9f5a80c66a4aa1eb0af9satok null); 19241f775bbc731b25854da9f5a80c66a4aa1eb0af9satok c.moveToFirst(); 19341f775bbc731b25854da9f5a80c66a4aa1eb0af9satok text = c.getString(MAILBOX_UNREAD_COUNT_COLMUN); 19441f775bbc731b25854da9f5a80c66a4aa1eb0af9satok } finally { 19541f775bbc731b25854da9f5a80c66a4aa1eb0af9satok c.close(); 19641f775bbc731b25854da9f5a80c66a4aa1eb0af9satok } 19741f775bbc731b25854da9f5a80c66a4aa1eb0af9satok return Integer.valueOf(text); 19841f775bbc731b25854da9f5a80c66a4aa1eb0af9satok } 19941f775bbc731b25854da9f5a80c66a4aa1eb0af9satok 2007143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 2017143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: HostAuth tests 2027143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 203758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 2047143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 205e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler * Test the various combinations of SSL, TLS, and trust-certificates encoded as Uris 206e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler */ 207ef83299b99288c00b9d661260d19715e73e6889cMarc Blank @SuppressWarnings("deprecation") 208e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler public void testHostAuthSecurityUri() { 209e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler HostAuth ha = ProviderTestUtils.setupHostAuth("uri-security", 1, false, mMockContext); 210e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler 211e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler final int MASK = 212e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler HostAuth.FLAG_SSL | HostAuth.FLAG_TLS | HostAuth.FLAG_TRUST_ALL_CERTIFICATES; 213e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler 214e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Set various URIs and check the resulting flags 215e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("protocol://user:password@server:123"); 216e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(0, ha.mFlags & MASK); 217e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("protocol+ssl+://user:password@server:123"); 218e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(HostAuth.FLAG_SSL, ha.mFlags & MASK); 219e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("protocol+ssl+trustallcerts://user:password@server:123"); 220e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(HostAuth.FLAG_SSL | HostAuth.FLAG_TRUST_ALL_CERTIFICATES, ha.mFlags & MASK); 221e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("protocol+tls+://user:password@server:123"); 222e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(HostAuth.FLAG_TLS, ha.mFlags & MASK); 223e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("protocol+tls+trustallcerts://user:password@server:123"); 224e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(HostAuth.FLAG_TLS | HostAuth.FLAG_TRUST_ALL_CERTIFICATES, ha.mFlags & MASK); 225e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler 226e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Now check the retrival method (building URI from flags) 227e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.mFlags &= ~MASK; 228e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler String uriString = ha.getStoreUri(); 229e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertTrue(uriString.startsWith("protocol://")); 230e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.mFlags |= HostAuth.FLAG_SSL; 231e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler uriString = ha.getStoreUri(); 232e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertTrue(uriString.startsWith("protocol+ssl+://")); 233e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.mFlags |= HostAuth.FLAG_TRUST_ALL_CERTIFICATES; 234e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler uriString = ha.getStoreUri(); 235e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertTrue(uriString.startsWith("protocol+ssl+trustallcerts://")); 236e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.mFlags &= ~MASK; 237e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.mFlags |= HostAuth.FLAG_TLS; 238e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler uriString = ha.getStoreUri(); 239e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertTrue(uriString.startsWith("protocol+tls+://")); 240e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.mFlags |= HostAuth.FLAG_TRUST_ALL_CERTIFICATES; 241e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler uriString = ha.getStoreUri(); 242e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertTrue(uriString.startsWith("protocol+tls+trustallcerts://")); 243e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler } 244e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler 245e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler /** 246e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler * Test port assignments made from Uris 247e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler */ 248ef83299b99288c00b9d661260d19715e73e6889cMarc Blank @SuppressWarnings("deprecation") 249e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler public void testHostAuthPortAssignments() { 250e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler HostAuth ha = ProviderTestUtils.setupHostAuth("uri-port", 1, false, mMockContext); 251e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler 252e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Set various URIs and check the resulting flags 253e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Hardwired port 254e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("imap://user:password@server:123"); 255e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(123, ha.mPort); 256e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Auto-assigned ports 257e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("imap://user:password@server"); 258e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(143, ha.mPort); 259e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("imap+ssl://user:password@server"); 260e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(993, ha.mPort); 261e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("imap+ssl+trustallcerts://user:password@server"); 262e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(993, ha.mPort); 263e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("imap+tls://user:password@server"); 264e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(143, ha.mPort); 265e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("imap+tls+trustallcerts://user:password@server"); 266e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(143, ha.mPort); 267e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler 268e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Hardwired port 269e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("pop3://user:password@server:123"); 270e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(123, ha.mPort); 271e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Auto-assigned ports 272e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("pop3://user:password@server"); 273e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(110, ha.mPort); 274e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("pop3+ssl://user:password@server"); 275e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(995, ha.mPort); 276e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("pop3+ssl+trustallcerts://user:password@server"); 277e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(995, ha.mPort); 278e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("pop3+tls://user:password@server"); 279e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(110, ha.mPort); 280e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("pop3+tls+trustallcerts://user:password@server"); 281e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(110, ha.mPort); 282e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler 283e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Hardwired port 284e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("eas://user:password@server:123"); 285e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(123, ha.mPort); 286e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Auto-assigned ports 287e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("eas://user:password@server"); 288e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(80, ha.mPort); 289e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("eas+ssl://user:password@server"); 290e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(443, ha.mPort); 291e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("eas+ssl+trustallcerts://user:password@server"); 292e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(443, ha.mPort); 293e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler 294e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Hardwired port 295e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("smtp://user:password@server:123"); 296e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(123, ha.mPort); 297e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Auto-assigned ports 298e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("smtp://user:password@server"); 299e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(587, ha.mPort); 300e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("smtp+ssl://user:password@server"); 301e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(465, ha.mPort); 302e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("smtp+ssl+trustallcerts://user:password@server"); 303e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(465, ha.mPort); 304e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("smtp+tls://user:password@server"); 305e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(587, ha.mPort); 306e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("smtp+tls+trustallcerts://user:password@server"); 307e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(587, ha.mPort); 308e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler } 309e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler 310e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler /** 3117143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * Test simple mailbox save/retrieve 3127143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 3137143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public void testMailboxSave() { 31428448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("mailbox-save", true, mMockContext); 3157143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long account1Id = account1.mId; 31628448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, 31728448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler mMockContext); 3187143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long box1Id = box1.mId; 319758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 3207143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler Mailbox box2 = EmailContent.Mailbox.restoreMailboxWithId(mMockContext, box1Id); 321758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 32228448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler ProviderTestUtils.assertMailboxEqual("testMailboxSave", box1, box2); 3237143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 324758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 3254119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler private static String[] expectedAttachmentNames = 326976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank new String[] {"attachment1.doc", "attachment2.xls", "attachment3"}; 327976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank // The lengths need to be kept in ascending order 3284119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler private static long[] expectedAttachmentSizes = new long[] {31415L, 97701L, 151213L}; 329976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank 330fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda /* 331fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * Returns null if the message has no body. 332fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda */ 333fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda private Body loadBodyForMessageId(long messageId) { 334fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Cursor c = null; 335fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda try { 336fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda c = mMockContext.getContentResolver().query( 337fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda EmailContent.Body.CONTENT_URI, 338fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda EmailContent.Body.CONTENT_PROJECTION, 339fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda EmailContent.Body.MESSAGE_KEY + "=?", 340fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda new String[] {String.valueOf(messageId)}, 341fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda null); 342fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda int numBodies = c.getCount(); 343fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda assertTrue("at most one body", numBodies < 2); 344fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda return c.moveToFirst() ? EmailContent.getContent(c, Body.class) : null; 345fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda } finally { 346fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda c.close(); 347fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda } 348fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda } 349fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 3507143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 3517143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * Test simple message save/retrieve 352758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank * 3537143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: serverId vs. serverIntId 3547143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 3557143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public void testMessageSave() { 35628448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("message-save", true, mMockContext); 3577143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long account1Id = account1.mId; 35828448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 3597143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long box1Id = box1.mId; 3607143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 3617143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // Test a simple message (saved with no body) 36228448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Message message1 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, false, 36328448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler true, mMockContext); 3647143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long message1Id = message1.mId; 3657143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler Message message1get = EmailContent.Message.restoreMessageWithId(mMockContext, message1Id); 36628448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler ProviderTestUtils.assertMessageEqual("testMessageSave", message1, message1get); 3677143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 3687143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // Test a message saved with a body 3697143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // Note that it will read back w/o the text & html so we must extract those 37028448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Message message2 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, true, 37128448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler true, mMockContext); 3727143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long message2Id = message2.mId; 3737143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler String text2 = message2.mText; 3747143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler String html2 = message2.mHtml; 375936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler String textReply2 = message2.mTextReply; 376936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler String htmlReply2 = message2.mHtmlReply; 3776c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler long sourceKey2 = message2.mSourceKey; 3785fc57eccefeba517fe5e6f093786f37c6c4d50e6Marc Blank String introText2 = message2.mIntroText; 3797143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler message2.mText = null; 3807143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler message2.mHtml = null; 381936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler message2.mTextReply = null; 382936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler message2.mHtmlReply = null; 383e25698319325d5e9619bc45ae85d861b0f1c5954Marc Blank message2.mSourceKey = 0; 3845fc57eccefeba517fe5e6f093786f37c6c4d50e6Marc Blank message2.mIntroText = null; 3857143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler Message message2get = EmailContent.Message.restoreMessageWithId(mMockContext, message2Id); 38628448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler ProviderTestUtils.assertMessageEqual("testMessageSave", message2, message2get); 387758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 3887143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // Now see if there's a body saved with the right stuff 389fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Body body2 = loadBodyForMessageId(message2Id); 390fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda assertEquals("body text", text2, body2.mTextContent); 391fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda assertEquals("body html", html2, body2.mHtmlContent); 392936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler assertEquals("reply text", textReply2, body2.mTextReply); 393936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler assertEquals("reply html", htmlReply2, body2.mHtmlReply); 3946c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler assertEquals("source key", sourceKey2, body2.mSourceKey); 3955fc57eccefeba517fe5e6f093786f37c6c4d50e6Marc Blank assertEquals("intro text", introText2, body2.mIntroText); 396976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank 3974119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler // Message with attachments and body 398976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank Message message3 = ProviderTestUtils.setupMessage("message3", account1Id, box1Id, true, 399976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank false, mMockContext); 400976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank ArrayList<Attachment> atts = new ArrayList<Attachment>(); 401976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank for (int i = 0; i < 3; i++) { 4024119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler atts.add(ProviderTestUtils.setupAttachment( 4034119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler -1, expectedAttachmentNames[i], expectedAttachmentSizes[i], 4044119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler false, mMockContext)); 405976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } 406976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank message3.mAttachments = atts; 4079e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler message3.save(mMockContext); 408976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank long message3Id = message3.mId; 409976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank 410976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank // Now check the attachments; there should be three and they should match name and size 411fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Cursor c = null; 412976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank try { 413976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank // Note that there is NO guarantee of the order of returned records in the general case, 414976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank // so we specifically ask for ordering by size. The expectedAttachmentSizes array must 415976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank // be kept sorted by size (ascending) for this test to work properly 416976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank c = mMockContext.getContentResolver().query( 417976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank Attachment.CONTENT_URI, 418976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank Attachment.CONTENT_PROJECTION, 419976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank Attachment.MESSAGE_KEY + "=?", 420976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank new String[] { 421976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank String.valueOf(message3Id) 422976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank }, 423976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank Attachment.SIZE); 424976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank int numAtts = c.getCount(); 425976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank assertEquals(3, numAtts); 426976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank int i = 0; 427976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank while (c.moveToNext()) { 4284119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Attachment actual = EmailContent.getContent(c, Attachment.class); 4294119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler ProviderTestUtils.assertAttachmentEqual("save-message3", atts.get(i), actual); 4304119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler i++; 4314119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler } 4324119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler } finally { 4334119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler c.close(); 4344119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler } 4354119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler 4364119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler // Message with attachments but no body 4374119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Message message4 = ProviderTestUtils.setupMessage("message4", account1Id, box1Id, false, 4384119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler false, mMockContext); 4394119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler atts = new ArrayList<Attachment>(); 4404119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler for (int i = 0; i < 3; i++) { 4414119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler atts.add(ProviderTestUtils.setupAttachment( 4424119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler -1, expectedAttachmentNames[i], expectedAttachmentSizes[i], 4434119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler false, mMockContext)); 4444119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler } 4454119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler message4.mAttachments = atts; 4469e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler message4.save(mMockContext); 4474119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler long message4Id = message4.mId; 4484119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler 4494119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler // Now check the attachments; there should be three and they should match name and size 4504119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler c = null; 45141f775bbc731b25854da9f5a80c66a4aa1eb0af9satok 4524119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler try { 4534119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler // Note that there is NO guarantee of the order of returned records in the general case, 4544119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler // so we specifically ask for ordering by size. The expectedAttachmentSizes array must 4554119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler // be kept sorted by size (ascending) for this test to work properly 4564119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler c = mMockContext.getContentResolver().query( 4574119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Attachment.CONTENT_URI, 4584119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Attachment.CONTENT_PROJECTION, 4594119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Attachment.MESSAGE_KEY + "=?", 4604119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler new String[] { 4614119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler String.valueOf(message4Id) 4624119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler }, 4634119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Attachment.SIZE); 4644119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler int numAtts = c.getCount(); 4654119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler assertEquals(3, numAtts); 4664119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler int i = 0; 4674119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler while (c.moveToNext()) { 4684119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Attachment actual = EmailContent.getContent(c, Attachment.class); 4694119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler ProviderTestUtils.assertAttachmentEqual("save-message4", atts.get(i), actual); 470976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank i++; 471976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } 472976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } finally { 473976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank c.close(); 4747143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 47544144d0301213536b02f2080237b63d8271b2d0bMihai Preda 47644144d0301213536b02f2080237b63d8271b2d0bMihai Preda // test EmailContent.restoreAttachmentsWitdMessageId() 47744144d0301213536b02f2080237b63d8271b2d0bMihai Preda Attachment[] attachments = 47844144d0301213536b02f2080237b63d8271b2d0bMihai Preda Attachment.restoreAttachmentsWithMessageId(mMockContext, message4Id); 47944144d0301213536b02f2080237b63d8271b2d0bMihai Preda int size = attachments.length; 48044144d0301213536b02f2080237b63d8271b2d0bMihai Preda assertEquals(3, size); 48144144d0301213536b02f2080237b63d8271b2d0bMihai Preda for (int i = 0; i < size; ++i) { 48244144d0301213536b02f2080237b63d8271b2d0bMihai Preda ProviderTestUtils.assertAttachmentEqual("save-message4", atts.get(i), attachments[i]); 48344144d0301213536b02f2080237b63d8271b2d0bMihai Preda } 4847143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 485758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 4867143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 4877143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: update account 4887143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 489758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 4907143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 4917143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: update mailbox 4927143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 493758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 4947143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 4957143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: update message 4967143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 497758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 4987143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 4997143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * Test delete account 5007143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: hostauth 5017143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 5027143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public void testAccountDelete() { 50328448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("account-delete-1", true, mMockContext); 5047143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long account1Id = account1.mId; 50528448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account2 = ProviderTestUtils.setupAccount("account-delete-2", true, mMockContext); 5067143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long account2Id = account2.mId; 5077143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 5087143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there are two accounts 5097143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler int numBoxes = EmailContent.count(mMockContext, Account.CONTENT_URI, null, null); 5107143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(2, numBoxes); 5117143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 5127143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // now delete one of them 5137143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler Uri uri = ContentUris.withAppendedId(Account.CONTENT_URI, account1Id); 5147143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 5157143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 5167143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there's only one account now 5177143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler numBoxes = EmailContent.count(mMockContext, Account.CONTENT_URI, null, null); 5187143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(1, numBoxes); 5197143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 5207143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // now delete the other one 5217143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler uri = ContentUris.withAppendedId(Account.CONTENT_URI, account2Id); 5227143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 5237143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 5247143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there are no accounts now 5257143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler numBoxes = EmailContent.count(mMockContext, Account.CONTENT_URI, null, null); 5267143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(0, numBoxes); 5277143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 528758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 5297143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 5309627d014e16235eadf981b9165807dc72a14a383Mihai Preda * Test for Body.lookupBodyIdWithMessageId() 5319627d014e16235eadf981b9165807dc72a14a383Mihai Preda * Verifies that: 5329627d014e16235eadf981b9165807dc72a14a383Mihai Preda * - for a message without body, -1 is returned. 5339627d014e16235eadf981b9165807dc72a14a383Mihai Preda * - for a mesage with body, the id matches the one from loadBodyForMessageId. 5349627d014e16235eadf981b9165807dc72a14a383Mihai Preda */ 5359627d014e16235eadf981b9165807dc72a14a383Mihai Preda public void testLookupBodyIdWithMessageId() { 5369627d014e16235eadf981b9165807dc72a14a383Mihai Preda final ContentResolver resolver = mMockContext.getContentResolver(); 5379627d014e16235eadf981b9165807dc72a14a383Mihai Preda Account account1 = ProviderTestUtils.setupAccount("orphaned body", true, mMockContext); 5389627d014e16235eadf981b9165807dc72a14a383Mihai Preda long account1Id = account1.mId; 5399627d014e16235eadf981b9165807dc72a14a383Mihai Preda Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 5409627d014e16235eadf981b9165807dc72a14a383Mihai Preda long box1Id = box1.mId; 5419627d014e16235eadf981b9165807dc72a14a383Mihai Preda 5429627d014e16235eadf981b9165807dc72a14a383Mihai Preda // 1. create message with no body, check that returned bodyId is -1 5439627d014e16235eadf981b9165807dc72a14a383Mihai Preda Message message1 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, false, 5449627d014e16235eadf981b9165807dc72a14a383Mihai Preda true, mMockContext); 5459627d014e16235eadf981b9165807dc72a14a383Mihai Preda long message1Id = message1.mId; 5469627d014e16235eadf981b9165807dc72a14a383Mihai Preda long bodyId1 = Body.lookupBodyIdWithMessageId(resolver, message1Id); 5479627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertEquals(bodyId1, -1); 5489627d014e16235eadf981b9165807dc72a14a383Mihai Preda 5499627d014e16235eadf981b9165807dc72a14a383Mihai Preda // 2. create message with body, check that returned bodyId is correct 5509627d014e16235eadf981b9165807dc72a14a383Mihai Preda Message message2 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, true, 5519627d014e16235eadf981b9165807dc72a14a383Mihai Preda true, mMockContext); 5529627d014e16235eadf981b9165807dc72a14a383Mihai Preda long message2Id = message2.mId; 5539627d014e16235eadf981b9165807dc72a14a383Mihai Preda long bodyId2 = Body.lookupBodyIdWithMessageId(resolver, message2Id); 5549627d014e16235eadf981b9165807dc72a14a383Mihai Preda Body body = loadBodyForMessageId(message2Id); 5559627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertNotNull(body); 5569627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertEquals(body.mId, bodyId2); 5579627d014e16235eadf981b9165807dc72a14a383Mihai Preda } 5589627d014e16235eadf981b9165807dc72a14a383Mihai Preda 5599627d014e16235eadf981b9165807dc72a14a383Mihai Preda /** 5609627d014e16235eadf981b9165807dc72a14a383Mihai Preda * Test for Body.updateBodyWithMessageId(). 5619627d014e16235eadf981b9165807dc72a14a383Mihai Preda * 1. - create message without body, 5629627d014e16235eadf981b9165807dc72a14a383Mihai Preda * - update its body (set TEXT_CONTENT) 5639627d014e16235eadf981b9165807dc72a14a383Mihai Preda * - check correct updated body is read back 5649627d014e16235eadf981b9165807dc72a14a383Mihai Preda * 5659627d014e16235eadf981b9165807dc72a14a383Mihai Preda * 2. - create message with body, 5669627d014e16235eadf981b9165807dc72a14a383Mihai Preda * - update body (set TEXT_CONTENT) 5679627d014e16235eadf981b9165807dc72a14a383Mihai Preda * - check correct updated body is read back 5689627d014e16235eadf981b9165807dc72a14a383Mihai Preda */ 5699627d014e16235eadf981b9165807dc72a14a383Mihai Preda public void testUpdateBodyWithMessageId() { 5709627d014e16235eadf981b9165807dc72a14a383Mihai Preda Account account1 = ProviderTestUtils.setupAccount("orphaned body", true, mMockContext); 5719627d014e16235eadf981b9165807dc72a14a383Mihai Preda long account1Id = account1.mId; 5729627d014e16235eadf981b9165807dc72a14a383Mihai Preda Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 5739627d014e16235eadf981b9165807dc72a14a383Mihai Preda long box1Id = box1.mId; 5749627d014e16235eadf981b9165807dc72a14a383Mihai Preda 5759627d014e16235eadf981b9165807dc72a14a383Mihai Preda final String textContent = "foobar some odd text"; 576936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler final String htmlContent = "and some html"; 577936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler final String textReply = "plain text reply"; 578936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler final String htmlReply = "or the html reply"; 5795fc57eccefeba517fe5e6f093786f37c6c4d50e6Marc Blank final String introText = "fred wrote:"; 5809627d014e16235eadf981b9165807dc72a14a383Mihai Preda 5819627d014e16235eadf981b9165807dc72a14a383Mihai Preda ContentValues values = new ContentValues(); 5829627d014e16235eadf981b9165807dc72a14a383Mihai Preda values.put(BodyColumns.TEXT_CONTENT, textContent); 583936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler values.put(BodyColumns.HTML_CONTENT, htmlContent); 584936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler values.put(BodyColumns.TEXT_REPLY, textReply); 585936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler values.put(BodyColumns.HTML_REPLY, htmlReply); 586e25698319325d5e9619bc45ae85d861b0f1c5954Marc Blank values.put(BodyColumns.SOURCE_MESSAGE_KEY, 17); 5875fc57eccefeba517fe5e6f093786f37c6c4d50e6Marc Blank values.put(BodyColumns.INTRO_TEXT, introText); 5889627d014e16235eadf981b9165807dc72a14a383Mihai Preda 5899627d014e16235eadf981b9165807dc72a14a383Mihai Preda // 1 5909627d014e16235eadf981b9165807dc72a14a383Mihai Preda Message message1 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, false, 5919627d014e16235eadf981b9165807dc72a14a383Mihai Preda true, mMockContext); 5929627d014e16235eadf981b9165807dc72a14a383Mihai Preda long message1Id = message1.mId; 5939627d014e16235eadf981b9165807dc72a14a383Mihai Preda Body body1 = loadBodyForMessageId(message1Id); 5949627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertNull(body1); 5959627d014e16235eadf981b9165807dc72a14a383Mihai Preda Body.updateBodyWithMessageId(mMockContext, message1Id, values); 5969627d014e16235eadf981b9165807dc72a14a383Mihai Preda body1 = loadBodyForMessageId(message1Id); 5979627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertNotNull(body1); 5989627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertEquals(body1.mTextContent, textContent); 599936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler assertEquals(body1.mHtmlContent, htmlContent); 600936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler assertEquals(body1.mTextReply, textReply); 601936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler assertEquals(body1.mHtmlReply, htmlReply); 602e25698319325d5e9619bc45ae85d861b0f1c5954Marc Blank assertEquals(body1.mSourceKey, 17); 6035fc57eccefeba517fe5e6f093786f37c6c4d50e6Marc Blank assertEquals(body1.mIntroText, introText); 6049627d014e16235eadf981b9165807dc72a14a383Mihai Preda 6059627d014e16235eadf981b9165807dc72a14a383Mihai Preda // 2 6069627d014e16235eadf981b9165807dc72a14a383Mihai Preda Message message2 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, true, 6079627d014e16235eadf981b9165807dc72a14a383Mihai Preda true, mMockContext); 6089627d014e16235eadf981b9165807dc72a14a383Mihai Preda long message2Id = message2.mId; 6099627d014e16235eadf981b9165807dc72a14a383Mihai Preda Body body2 = loadBodyForMessageId(message2Id); 6109627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertNotNull(body2); 6119627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertTrue(!body2.mTextContent.equals(textContent)); 6129627d014e16235eadf981b9165807dc72a14a383Mihai Preda Body.updateBodyWithMessageId(mMockContext, message2Id, values); 6139627d014e16235eadf981b9165807dc72a14a383Mihai Preda body2 = loadBodyForMessageId(message1Id); 6149627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertNotNull(body2); 6159627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertEquals(body2.mTextContent, textContent); 616936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler assertEquals(body2.mHtmlContent, htmlContent); 617936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler assertEquals(body2.mTextReply, textReply); 618936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler assertEquals(body2.mHtmlReply, htmlReply); 619e25698319325d5e9619bc45ae85d861b0f1c5954Marc Blank assertEquals(body2.mSourceKey, 17); 6205fc57eccefeba517fe5e6f093786f37c6c4d50e6Marc Blank assertEquals(body2.mIntroText, introText); 6219627d014e16235eadf981b9165807dc72a14a383Mihai Preda } 6229627d014e16235eadf981b9165807dc72a14a383Mihai Preda 6239627d014e16235eadf981b9165807dc72a14a383Mihai Preda /** 624c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler * Test body retrieve methods 625c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler */ 626c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler public void testBodyRetrieve() { 627c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler // No account needed 628c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler // No mailbox needed 629c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler Message message1 = ProviderTestUtils.setupMessage("bodyretrieve", 1, 1, true, 630c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler true, mMockContext); 631c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler long messageId = message1.mId; 632c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler 633c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler assertEquals(message1.mText, 634c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler Body.restoreBodyTextWithMessageId(mMockContext, messageId)); 635c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler assertEquals(message1.mHtml, 636c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler Body.restoreBodyHtmlWithMessageId(mMockContext, messageId)); 637c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler assertEquals(message1.mTextReply, 638c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler Body.restoreReplyTextWithMessageId(mMockContext, messageId)); 639c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler assertEquals(message1.mHtmlReply, 640c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler Body.restoreReplyHtmlWithMessageId(mMockContext, messageId)); 641c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler assertEquals(message1.mIntroText, 642c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler Body.restoreIntroTextWithMessageId(mMockContext, messageId)); 6431575e7860d2259f1aed201ab23d526cddf787365Mihai Preda assertEquals(message1.mSourceKey, 6441575e7860d2259f1aed201ab23d526cddf787365Mihai Preda Body.restoreBodySourceKey(mMockContext, messageId)); 645c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler } 646c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler 647c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler /** 648fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * Test delete body. 649fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * 1. create message without body (message id 1) 650fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * 2. create message with body (message id 2. The body has _id 1 and messageKey 2). 651fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * 3. delete first message. 652fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * 4. verify that body for message 2 has not been deleted. 653fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * 5. delete message 2, verify body is deleted. 654fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda */ 655fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda public void testDeleteBody() { 656fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda final ContentResolver resolver = mMockContext.getContentResolver(); 657fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 658fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // Create account and mailboxes 659fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Account account1 = ProviderTestUtils.setupAccount("orphaned body", true, mMockContext); 660fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda long account1Id = account1.mId; 661fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 662fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda long box1Id = box1.mId; 663fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 664fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // 1. create message without body 665fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Message message1 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, false, 666fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda true, mMockContext); 667fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda long message1Id = message1.mId; 668fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 669fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // 2. create message with body 670fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Message message2 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, true, 671fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda true, mMockContext); 672fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda long message2Id = message2.mId; 673fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // verify body is there 674fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda assertNotNull(loadBodyForMessageId(message2Id)); 675fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 676fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // 3. delete first message 677fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda resolver.delete(ContentUris.withAppendedId(Message.CONTENT_URI, message1Id), null, null); 678c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank 679fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // 4. verify body for second message wasn't deleted 680fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda assertNotNull(loadBodyForMessageId(message2Id)); 681fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 682fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // 5. delete second message, check its body is deleted 683fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda resolver.delete(ContentUris.withAppendedId(Message.CONTENT_URI, message2Id), null, null); 684fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda assertNull(loadBodyForMessageId(message2Id)); 685fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda } 686fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 687fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda /** 688fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * Test delete orphan bodies. 689fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * 1. create message without body (message id 1) 690fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * 2. create message with body (message id 2. Body has _id 1 and messageKey 2). 691fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * 3. delete first message. 692fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * 4. delete some other mailbox -- this triggers delete orphan bodies. 693fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * 5. verify that body for message 2 has not been deleted. 694fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda */ 695fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda public void testDeleteOrphanBodies() { 696fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda final ContentResolver resolver = mMockContext.getContentResolver(); 697fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 698ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Create account and two mailboxes 699fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Account account1 = ProviderTestUtils.setupAccount("orphaned body", true, mMockContext); 700fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda long account1Id = account1.mId; 701fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 702fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda long box1Id = box1.mId; 703fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Mailbox box2 = ProviderTestUtils.setupMailbox("box2", account1Id, true, mMockContext); 704fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda long box2Id = box2.mId; 705fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 706fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // 1. create message without body 707fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Message message1 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, false, 708fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda true, mMockContext); 709fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda long message1Id = message1.mId; 710fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 711fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // 2. create message with body 712fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Message message2 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, true, 713fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda true, mMockContext); 714fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda long message2Id = message2.mId; 715fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda //verify body is there 716fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda assertNotNull(loadBodyForMessageId(message2Id)); 717fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 718fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // 3. delete first message 719fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda resolver.delete(ContentUris.withAppendedId(Message.CONTENT_URI, message1Id), null, null); 720fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 721fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // 4. delete some mailbox (because it triggers "delete orphan bodies") 722fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda resolver.delete(ContentUris.withAppendedId(Mailbox.CONTENT_URI, box2Id), null, null); 723fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 724fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // 5. verify body for second message wasn't deleted during "delete orphan bodies" 725fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda assertNotNull(loadBodyForMessageId(message2Id)); 726fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda } 727fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 728fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda /** 729ef83299b99288c00b9d661260d19715e73e6889cMarc Blank * Test delete orphan messages 730ef83299b99288c00b9d661260d19715e73e6889cMarc Blank * 1. create message without body (message id 1) 731ef83299b99288c00b9d661260d19715e73e6889cMarc Blank * 2. create message with body (message id 2. Body has _id 1 and messageKey 2). 732ef83299b99288c00b9d661260d19715e73e6889cMarc Blank * 3. delete first message. 733ef83299b99288c00b9d661260d19715e73e6889cMarc Blank * 4. delete some other mailbox -- this triggers delete orphan bodies. 734ef83299b99288c00b9d661260d19715e73e6889cMarc Blank * 5. verify that body for message 2 has not been deleted. 735ef83299b99288c00b9d661260d19715e73e6889cMarc Blank */ 736ef83299b99288c00b9d661260d19715e73e6889cMarc Blank public void testDeleteOrphanMessages() { 737ef83299b99288c00b9d661260d19715e73e6889cMarc Blank final ContentResolver resolver = mMockContext.getContentResolver(); 738ef83299b99288c00b9d661260d19715e73e6889cMarc Blank final Context context = mMockContext; 739ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 740ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Create account and two mailboxes 741ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Account acct = ProviderTestUtils.setupAccount("orphaned body", true, context); 742ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Mailbox box1 = ProviderTestUtils.setupMailbox("box1", acct.mId, true, context); 743ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Mailbox box2 = ProviderTestUtils.setupMailbox("box2", acct.mId, true, context); 744ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 745ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Create 4 messages in box1 746ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msg1_1 = 747ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("message1", acct.mId, box1.mId, false, true, context); 748ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msg1_2 = 749ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("message2", acct.mId, box1.mId, false, true, context); 750ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msg1_3 = 751ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("message3", acct.mId, box1.mId, false, true, context); 752ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msg1_4 = 753ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("message4", acct.mId, box1.mId, false, true, context); 754ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 755ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Create 4 messages in box2 756ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msg2_1 = 757ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("message1", acct.mId, box2.mId, false, true, context); 758ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msg2_2 = 759ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("message2", acct.mId, box2.mId, false, true, context); 760ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msg2_3 = 761ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("message3", acct.mId, box2.mId, false, true, context); 762ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msg2_4 = 763ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("message4", acct.mId, box2.mId, false, true, context); 764ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 765ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Delete 2 from each mailbox 766ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.delete(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, msg1_1.mId), 767ef83299b99288c00b9d661260d19715e73e6889cMarc Blank null, null); 768ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.delete(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, msg1_2.mId), 769ef83299b99288c00b9d661260d19715e73e6889cMarc Blank null, null); 770ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.delete(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, msg2_1.mId), 771ef83299b99288c00b9d661260d19715e73e6889cMarc Blank null, null); 772ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.delete(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, msg2_2.mId), 773ef83299b99288c00b9d661260d19715e73e6889cMarc Blank null, null); 774ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 775ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // There should be 4 items in the deleted item table 776ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(4, EmailContent.count(context, Message.DELETED_CONTENT_URI, null, null)); 777ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 778ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Update 2 from each mailbox 779ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ContentValues v = new ContentValues(); 780ef83299b99288c00b9d661260d19715e73e6889cMarc Blank v.put(MessageColumns.DISPLAY_NAME, "--updated--"); 781ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.update(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, msg1_3.mId), 782ef83299b99288c00b9d661260d19715e73e6889cMarc Blank v, null, null); 783ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.update(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, msg1_4.mId), 784ef83299b99288c00b9d661260d19715e73e6889cMarc Blank v, null, null); 785ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.update(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, msg2_3.mId), 786ef83299b99288c00b9d661260d19715e73e6889cMarc Blank v, null, null); 787ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.update(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, msg2_4.mId), 788ef83299b99288c00b9d661260d19715e73e6889cMarc Blank v, null, null); 789ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 790ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // There should be 4 items in the updated item table 791ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(4, EmailContent.count(context, Message.UPDATED_CONTENT_URI, null, null)); 792ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 793ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Manually add 2 messages from a "deleted" mailbox to deleted and updated tables 794ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Use a value > 2 for the deleted box id 795ef83299b99288c00b9d661260d19715e73e6889cMarc Blank long delBoxId = 10; 796ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Create 4 messages in the "deleted" mailbox 797ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msgX_A = 798ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("messageA", acct.mId, delBoxId, false, false, context); 799ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msgX_B = 800ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("messageB", acct.mId, delBoxId, false, false, context); 801ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msgX_C = 802ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("messageC", acct.mId, delBoxId, false, false, context); 803ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msgX_D = 804ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("messageD", acct.mId, delBoxId, false, false, context); 805ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 806ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ContentValues cv; 807ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // We have to assign id's manually because there are no autoincrement id's for these tables 808ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Start with an id that won't exist, since id's in these tables must be unique 809ef83299b99288c00b9d661260d19715e73e6889cMarc Blank long msgId = 10; 810ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // It's illegal to manually insert these, so we need to catch the exception 811ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // NOTE: The insert succeeds, and then throws the exception 812ef83299b99288c00b9d661260d19715e73e6889cMarc Blank try { 813ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv = msgX_A.toContentValues(); 814ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv.put(EmailContent.RECORD_ID, msgId++); 815ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.insert(Message.DELETED_CONTENT_URI, cv); 816ef83299b99288c00b9d661260d19715e73e6889cMarc Blank } catch (IllegalArgumentException e) { 817ef83299b99288c00b9d661260d19715e73e6889cMarc Blank } 818ef83299b99288c00b9d661260d19715e73e6889cMarc Blank try { 819ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv = msgX_B.toContentValues(); 820ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv.put(EmailContent.RECORD_ID, msgId++); 821ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.insert(Message.DELETED_CONTENT_URI, cv); 822ef83299b99288c00b9d661260d19715e73e6889cMarc Blank } catch (IllegalArgumentException e) { 823ef83299b99288c00b9d661260d19715e73e6889cMarc Blank } 824ef83299b99288c00b9d661260d19715e73e6889cMarc Blank try { 825ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv = msgX_C.toContentValues(); 826ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv.put(EmailContent.RECORD_ID, msgId++); 827ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.insert(Message.UPDATED_CONTENT_URI, cv); 828ef83299b99288c00b9d661260d19715e73e6889cMarc Blank } catch (IllegalArgumentException e) { 829ef83299b99288c00b9d661260d19715e73e6889cMarc Blank } 830ef83299b99288c00b9d661260d19715e73e6889cMarc Blank try { 831ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv = msgX_D.toContentValues(); 832ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv.put(EmailContent.RECORD_ID, msgId++); 833ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.insert(Message.UPDATED_CONTENT_URI, cv); 834ef83299b99288c00b9d661260d19715e73e6889cMarc Blank } catch (IllegalArgumentException e) { 835ef83299b99288c00b9d661260d19715e73e6889cMarc Blank } 836ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 837ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // There should be 6 items in the deleted and updated tables 838ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(6, EmailContent.count(context, Message.UPDATED_CONTENT_URI, null, null)); 839ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(6, EmailContent.count(context, Message.DELETED_CONTENT_URI, null, null)); 840ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 841ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Delete the orphans 842ef83299b99288c00b9d661260d19715e73e6889cMarc Blank EmailProvider.deleteOrphans(EmailProvider.getReadableDatabase(context), 843ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message.DELETED_TABLE_NAME); 844ef83299b99288c00b9d661260d19715e73e6889cMarc Blank EmailProvider.deleteOrphans(EmailProvider.getReadableDatabase(context), 845ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message.UPDATED_TABLE_NAME); 846ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 847ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // There should now be 4 messages in each of the deleted and updated tables again 848ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(4, EmailContent.count(context, Message.UPDATED_CONTENT_URI, null, null)); 849ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(4, EmailContent.count(context, Message.DELETED_CONTENT_URI, null, null)); 850ef83299b99288c00b9d661260d19715e73e6889cMarc Blank } 851ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 852ef83299b99288c00b9d661260d19715e73e6889cMarc Blank /** 8537143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * Test delete mailbox 8547143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 8557143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public void testMailboxDelete() { 85628448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("mailbox-delete", true, mMockContext); 8577143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long account1Id = account1.mId; 85828448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 8597143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long box1Id = box1.mId; 86028448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Mailbox box2 = ProviderTestUtils.setupMailbox("box2", account1Id, true, mMockContext); 8617143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long box2Id = box2.mId; 862758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 8637143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler String selection = EmailContent.MailboxColumns.ACCOUNT_KEY + "=?"; 8647143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler String[] selArgs = new String[] { String.valueOf(account1Id) }; 8657143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 8667143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there are two mailboxes 8677143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler int numBoxes = EmailContent.count(mMockContext, Mailbox.CONTENT_URI, selection, selArgs); 8687143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(2, numBoxes); 8697143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 8707143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // now delete one of them 8717143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler Uri uri = ContentUris.withAppendedId(Mailbox.CONTENT_URI, box1Id); 8727143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 8737143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 8747143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there's only one mailbox now 8757143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler numBoxes = EmailContent.count(mMockContext, Mailbox.CONTENT_URI, selection, selArgs); 8767143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(1, numBoxes); 8777143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 8787143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // now delete the other one 8797143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler uri = ContentUris.withAppendedId(Mailbox.CONTENT_URI, box2Id); 8807143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 8817143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 8827143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there are no mailboxes now 8837143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler numBoxes = EmailContent.count(mMockContext, Mailbox.CONTENT_URI, selection, selArgs); 8847143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(0, numBoxes); 8857143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 886758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 8877143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 8887143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * Test delete message 8897143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: body 8907143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: attachments 8917143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 8927143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public void testMessageDelete() { 89328448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("message-delete", true, mMockContext); 8947143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long account1Id = account1.mId; 89528448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 8967143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long box1Id = box1.mId; 89728448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Message message1 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, false, 89828448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler true, mMockContext); 8997143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long message1Id = message1.mId; 90028448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Message message2 = ProviderTestUtils.setupMessage("message2", account1Id, box1Id, false, 90128448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler true, mMockContext); 9027143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long message2Id = message2.mId; 9037143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 9047143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler String selection = EmailContent.MessageColumns.ACCOUNT_KEY + "=? AND " + 9057143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler EmailContent.MessageColumns.MAILBOX_KEY + "=?"; 9067143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler String[] selArgs = new String[] { String.valueOf(account1Id), String.valueOf(box1Id) }; 9077143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 9087143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there are two messages 9097143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler int numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, selection, selArgs); 9107143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(2, numMessages); 9117143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 9127143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // now delete one of them 9137143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler Uri uri = ContentUris.withAppendedId(Message.CONTENT_URI, message1Id); 9147143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 9157143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 9167143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there's only one message now 9177143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, selection, selArgs); 9187143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(1, numMessages); 9197143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 9207143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // now delete the other one 9217143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler uri = ContentUris.withAppendedId(Message.CONTENT_URI, message2Id); 9227143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 9237143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 9247143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there are no messages now 9257143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, selection, selArgs); 9267143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(0, numMessages); 9277143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 928758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 9297143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 930ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler * Test delete synced message 931ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler * TODO: body 932ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler * TODO: attachments 933ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler */ 934ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler public void testSyncedMessageDelete() { 93528448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("synced-message-delete", true, 93628448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler mMockContext); 937ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler long account1Id = account1.mId; 93828448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 939ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler long box1Id = box1.mId; 94028448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Message message1 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, false, 94128448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler true, mMockContext); 942ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler long message1Id = message1.mId; 94328448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Message message2 = ProviderTestUtils.setupMessage("message2", account1Id, box1Id, false, 94428448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler true, mMockContext); 945ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler long message2Id = message2.mId; 946ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 947ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler String selection = EmailContent.MessageColumns.ACCOUNT_KEY + "=? AND " 948ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler + EmailContent.MessageColumns.MAILBOX_KEY + "=?"; 949ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler String[] selArgs = new String[] { 950ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler String.valueOf(account1Id), String.valueOf(box1Id) 951ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler }; 952ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 953ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // make sure there are two messages 954ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler int numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, selection, selArgs); 955ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(2, numMessages); 956ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 957ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // make sure we start with no synced deletions 958ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler numMessages = EmailContent.count(mMockContext, Message.DELETED_CONTENT_URI, selection, 959ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler selArgs); 960ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(0, numMessages); 961ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 962ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // now delete one of them SYNCED 963ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler Uri uri = ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, message1Id); 964ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 965ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 966ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // make sure there's only one message now 967ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, selection, selArgs); 968ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(1, numMessages); 969ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 970ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // make sure there's one synced deletion now 971ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler numMessages = EmailContent.count(mMockContext, Message.DELETED_CONTENT_URI, selection, 972ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler selArgs); 973ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(1, numMessages); 974ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 975ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // now delete the other one NOT SYNCED 976ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler uri = ContentUris.withAppendedId(Message.CONTENT_URI, message2Id); 977ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 978ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 979ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // make sure there are no messages now 980ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, selection, selArgs); 981ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(0, numMessages); 982ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 983ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // make sure there's still one deletion now 984ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler numMessages = EmailContent.count(mMockContext, Message.DELETED_CONTENT_URI, selection, 985ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler selArgs); 986ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(1, numMessages); 987ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler } 988ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 989ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler /** 990ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler * Test message update 991ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler * TODO: body 992ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler * TODO: attachments 993ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler */ 994ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler public void testMessageUpdate() { 99528448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("message-update", true, mMockContext); 996ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler long account1Id = account1.mId; 99728448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 998ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler long box1Id = box1.mId; 99928448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Message message1 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, false, 100028448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler true, mMockContext); 1001ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler long message1Id = message1.mId; 100228448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Message message2 = ProviderTestUtils.setupMessage("message2", account1Id, box1Id, false, 100328448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler true, mMockContext); 1004ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler long message2Id = message2.mId; 1005ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler ContentResolver cr = mMockContext.getContentResolver(); 1006ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1007ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler String selection = EmailContent.MessageColumns.ACCOUNT_KEY + "=? AND " 1008ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler + EmailContent.MessageColumns.MAILBOX_KEY + "=?"; 1009ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler String[] selArgs = new String[] { 1010ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler String.valueOf(account1Id), String.valueOf(box1Id) 1011ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler }; 1012ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1013ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // make sure there are two messages 1014ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler int numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, selection, selArgs); 1015ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(2, numMessages); 1016ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1017ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // change the first one 1018ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler Uri uri = ContentUris.withAppendedId(Message.CONTENT_URI, message1Id); 1019ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler ContentValues cv = new ContentValues(); 1020ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler cv.put(MessageColumns.FROM_LIST, "from-list"); 1021ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler cr.update(uri, cv, null, null); 1022ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1023ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // make sure there's no updated message 1024ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler numMessages = EmailContent.count(mMockContext, Message.UPDATED_CONTENT_URI, selection, 1025ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler selArgs); 1026ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(0, numMessages); 1027ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1028ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // get the message back from the provider, make sure the change "stuck" 1029ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler Message restoredMessage = Message.restoreMessageWithId(mMockContext, message1Id); 1030ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals("from-list", restoredMessage.mFrom); 1031ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1032ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // change the second one 1033ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler uri = ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, message2Id); 1034ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler cv = new ContentValues(); 1035ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler cv.put(MessageColumns.FROM_LIST, "from-list"); 1036ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler cr.update(uri, cv, null, null); 1037ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1038ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // make sure there's one updated message 1039ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler numMessages = EmailContent.count(mMockContext, Message.UPDATED_CONTENT_URI, selection, 1040ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler selArgs); 1041ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(1, numMessages); 1042ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1043ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // get the message back from the provider, make sure the change "stuck", 1044ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // as before 1045ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler restoredMessage = Message.restoreMessageWithId(mMockContext, message2Id); 1046ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals("from-list", restoredMessage.mFrom); 1047ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1048ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // get the original message back from the provider 1049ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler Cursor c = cr.query(Message.UPDATED_CONTENT_URI, Message.CONTENT_PROJECTION, null, null, 1050ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler null); 1051ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler try { 1052ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertTrue(c.moveToFirst()); 1053ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler Message originalMessage = EmailContent.getContent(c, Message.class); 1054ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // make sure this has the original value 1055ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals("from message2", originalMessage.mFrom); 1056ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // Should only be one 1057ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertFalse(c.moveToNext()); 1058ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler } finally { 1059ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler c.close(); 1060ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler } 1061ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1062ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // delete the second message 1063ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler cr.delete(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, message2Id), null, null); 1064ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1065ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // hey, presto! the change should be gone 1066ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler numMessages = EmailContent.count(mMockContext, Message.UPDATED_CONTENT_URI, selection, 1067ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler selArgs); 1068ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(0, numMessages); 1069ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1070ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // and there should now be a deleted record 1071ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler numMessages = EmailContent.count(mMockContext, Message.DELETED_CONTENT_URI, selection, 1072ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler selArgs); 1073ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(1, numMessages); 1074ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler } 1075ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1076ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler /** 10777143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: cascaded delete account 10787143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: hostauth 10797143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: body 10807143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: attachments 10817143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: create other account, mailbox & messages and confirm the right objects were deleted 10827143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 10837143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public void testCascadeDeleteAccount() { 108428448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("account-delete-cascade", true, 108528448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler mMockContext); 10867143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long account1Id = account1.mId; 108728448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 10887143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long box1Id = box1.mId; 108928448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler /* Message message1 = */ ProviderTestUtils.setupMessage("message1", account1Id, box1Id, 109028448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler false, true, mMockContext); 109128448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler /* Message message2 = */ ProviderTestUtils.setupMessage("message2", account1Id, box1Id, 109228448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler false, true, mMockContext); 10937143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 10947143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there is one account, one mailbox, and two messages 10957143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler int numAccounts = EmailContent.count(mMockContext, Account.CONTENT_URI, null, null); 10967143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(1, numAccounts); 10977143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler int numBoxes = EmailContent.count(mMockContext, Mailbox.CONTENT_URI, null, null); 10987143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(1, numBoxes); 10997143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler int numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, null, null); 11007143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(2, numMessages); 11017143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 11027143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // delete the account 11037143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler Uri uri = ContentUris.withAppendedId(Account.CONTENT_URI, account1Id); 11047143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 11057143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 11067143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there are no accounts, mailboxes, or messages 11077143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler numAccounts = EmailContent.count(mMockContext, Account.CONTENT_URI, null, null); 11087143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(0, numAccounts); 11097143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler numBoxes = EmailContent.count(mMockContext, Mailbox.CONTENT_URI, null, null); 11107143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(0, numBoxes); 11117143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, null, null); 11127143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(0, numMessages); 11137143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 1114758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 11157143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 11167143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * Test cascaded delete mailbox 11177143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: body 11187143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: attachments 11197143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: create other mailbox & messages and confirm the right objects were deleted 11207143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 11217143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public void testCascadeDeleteMailbox() { 112228448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("mailbox-delete-cascade", true, 112328448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler mMockContext); 11247143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long account1Id = account1.mId; 112528448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 11267143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long box1Id = box1.mId; 1127ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message message1 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, 112828448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler false, true, mMockContext); 1129ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message message2 = ProviderTestUtils.setupMessage("message2", account1Id, box1Id, 1130ef83299b99288c00b9d661260d19715e73e6889cMarc Blank false, true, mMockContext); 1131ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message message3 = ProviderTestUtils.setupMessage("message3", account1Id, box1Id, 1132ef83299b99288c00b9d661260d19715e73e6889cMarc Blank false, true, mMockContext); 1133ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message message4 = ProviderTestUtils.setupMessage("message4", account1Id, box1Id, 113428448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler false, true, mMockContext); 1135ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("message5", account1Id, box1Id, false, true, mMockContext); 1136ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("message6", account1Id, box1Id, false, true, mMockContext); 11377143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 11387143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler String selection = EmailContent.MessageColumns.ACCOUNT_KEY + "=? AND " + 11397143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler EmailContent.MessageColumns.MAILBOX_KEY + "=?"; 11407143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler String[] selArgs = new String[] { String.valueOf(account1Id), String.valueOf(box1Id) }; 11417143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 11420e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // make sure there are six messages 11437143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler int numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, selection, selArgs); 1144ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(6, numMessages); 1145ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 1146ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ContentValues cv = new ContentValues(); 1147ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv.put(Message.SERVER_ID, "SERVER_ID"); 1148ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ContentResolver resolver = mMockContext.getContentResolver(); 1149ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 1150ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Update two messages 1151ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.update(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, message1.mId), 1152ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv, null, null); 1153ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.update(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, message2.mId), 1154ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv, null, null); 1155ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Delete two messages 1156ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.delete(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, message3.mId), 1157ef83299b99288c00b9d661260d19715e73e6889cMarc Blank null, null); 1158ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.delete(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, message4.mId), 1159ef83299b99288c00b9d661260d19715e73e6889cMarc Blank null, null); 1160ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 1161ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // There should now be two messages in updated/deleted, and 4 in messages 1162ef83299b99288c00b9d661260d19715e73e6889cMarc Blank numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, selection, selArgs); 1163ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(4, numMessages); 1164ef83299b99288c00b9d661260d19715e73e6889cMarc Blank numMessages = EmailContent.count(mMockContext, Message.DELETED_CONTENT_URI, selection, 1165ef83299b99288c00b9d661260d19715e73e6889cMarc Blank selArgs); 1166ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(2, numMessages); 1167ef83299b99288c00b9d661260d19715e73e6889cMarc Blank numMessages = EmailContent.count(mMockContext, Message.UPDATED_CONTENT_URI, selection, 1168ef83299b99288c00b9d661260d19715e73e6889cMarc Blank selArgs); 11697143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(2, numMessages); 1170758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 11717143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // now delete the mailbox 11727143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler Uri uri = ContentUris.withAppendedId(Mailbox.CONTENT_URI, box1Id); 1173ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.delete(uri, null, null); 1174758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1175ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // there should now be zero messages in all three tables 11767143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, selection, selArgs); 11777143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(0, numMessages); 1178ef83299b99288c00b9d661260d19715e73e6889cMarc Blank numMessages = EmailContent.count(mMockContext, Message.DELETED_CONTENT_URI, selection, 1179ef83299b99288c00b9d661260d19715e73e6889cMarc Blank selArgs); 1180ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(0, numMessages); 1181ef83299b99288c00b9d661260d19715e73e6889cMarc Blank numMessages = EmailContent.count(mMockContext, Message.UPDATED_CONTENT_URI, selection, 1182ef83299b99288c00b9d661260d19715e73e6889cMarc Blank selArgs); 1183ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(0, numMessages); 11847143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 1185758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 11867143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 11876c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler * Test cascaded delete message 11886c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler * Confirms that deleting a message will also delete its body & attachments 11897143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 11906c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler public void testCascadeMessageDelete() { 11916c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Account account1 = ProviderTestUtils.setupAccount("message-cascade", true, mMockContext); 11926c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler long account1Id = account1.mId; 11936c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 11946c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler long box1Id = box1.mId; 11956c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 11966c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // Each message has a body, and also give each 2 attachments 11976c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Message message1 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, true, 11986c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler false, mMockContext); 11996c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler ArrayList<Attachment> atts = new ArrayList<Attachment>(); 12006c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler for (int i = 0; i < 2; i++) { 12016c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler atts.add(ProviderTestUtils.setupAttachment( 12026c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler -1, expectedAttachmentNames[i], expectedAttachmentSizes[i], 12036c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler false, mMockContext)); 12046c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler } 12056c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler message1.mAttachments = atts; 12066c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler message1.save(mMockContext); 12076c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler long message1Id = message1.mId; 12086c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 12096c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Message message2 = ProviderTestUtils.setupMessage("message2", account1Id, box1Id, true, 12106c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler false, mMockContext); 12116c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler atts = new ArrayList<Attachment>(); 12126c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler for (int i = 0; i < 2; i++) { 12136c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler atts.add(ProviderTestUtils.setupAttachment( 12146c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler -1, expectedAttachmentNames[i], expectedAttachmentSizes[i], 12156c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler false, mMockContext)); 12166c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler } 12176c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler message2.mAttachments = atts; 12186c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler message2.save(mMockContext); 12196c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler long message2Id = message2.mId; 12206c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 12216c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // Set up to test total counts of bodies & attachments for our test messages 12226c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler String bodySelection = BodyColumns.MESSAGE_KEY + " IN (?,?)"; 12236c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler String attachmentSelection = AttachmentColumns.MESSAGE_KEY + " IN (?,?)"; 12246c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler String[] selArgs = new String[] { String.valueOf(message1Id), String.valueOf(message2Id) }; 12256c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 12266c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // make sure there are two bodies 12276c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler int numBodies = EmailContent.count(mMockContext, Body.CONTENT_URI, bodySelection, selArgs); 12286c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler assertEquals(2, numBodies); 12296c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 12306c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // make sure there are four attachments 12316c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler int numAttachments = EmailContent.count(mMockContext, Attachment.CONTENT_URI, 12326c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler attachmentSelection, selArgs); 12336c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler assertEquals(4, numAttachments); 12346c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 12356c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // now delete one of the messages 12366c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Uri uri = ContentUris.withAppendedId(Message.CONTENT_URI, message1Id); 12376c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 12386c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 12396c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // there should be one body and two attachments 12406c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler numBodies = EmailContent.count(mMockContext, Body.CONTENT_URI, bodySelection, selArgs); 12416c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler assertEquals(1, numBodies); 12426c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 12436c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler numAttachments = EmailContent.count(mMockContext, Attachment.CONTENT_URI, 12446c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler attachmentSelection, selArgs); 12456c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler assertEquals(2, numAttachments); 12466c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 12476c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // now delete the other message 12486c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler uri = ContentUris.withAppendedId(Message.CONTENT_URI, message2Id); 12496c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 12506c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 12516c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // make sure there are no bodies or attachments 12526c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler numBodies = EmailContent.count(mMockContext, Body.CONTENT_URI, bodySelection, selArgs); 12536c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler assertEquals(0, numBodies); 12546c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 12556c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler numAttachments = EmailContent.count(mMockContext, Attachment.CONTENT_URI, 12566c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler attachmentSelection, selArgs); 12576c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler assertEquals(0, numAttachments); 12586c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler } 12597143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 1260976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank /** 1261976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank * Test that our unique file name algorithm works as expected. Since this test requires an 1262976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank * SD card, we check the environment first, and return immediately if none is mounted. 1263976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank * @throws IOException 1264976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank */ 1265976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank public void testCreateUniqueFile() throws IOException { 1266976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank // Delete existing files, if they exist 1267976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank if (!Environment.getExternalStorageState().equals(Environment.MEDIA_MOUNTED)) { 1268976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank return; 1269976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } 1270976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank try { 1271976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank String fileName = "A11achm3n1.doc"; 1272976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank File uniqueFile = Attachment.createUniqueFile(fileName); 1273976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank assertEquals(fileName, uniqueFile.getName()); 1274976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank if (uniqueFile.createNewFile()) { 1275976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank uniqueFile = Attachment.createUniqueFile(fileName); 1276976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank assertEquals("A11achm3n1-2.doc", uniqueFile.getName()); 1277976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank if (uniqueFile.createNewFile()) { 1278976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank uniqueFile = Attachment.createUniqueFile(fileName); 1279976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank assertEquals("A11achm3n1-3.doc", uniqueFile.getName()); 1280976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } 1281976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } 1282976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank fileName = "A11achm3n1"; 1283976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank uniqueFile = Attachment.createUniqueFile(fileName); 1284976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank assertEquals(fileName, uniqueFile.getName()); 1285976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank if (uniqueFile.createNewFile()) { 1286976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank uniqueFile = Attachment.createUniqueFile(fileName); 1287976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank assertEquals("A11achm3n1-2", uniqueFile.getName()); 1288976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } 1289976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } finally { 1290976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank File directory = Environment.getExternalStorageDirectory(); 1291976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank // These are the files that should be created earlier in the test. Make sure 1292976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank // they are deleted for the next go-around 1293976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank String[] fileNames = new String[] {"A11achm3n1.doc", "A11achm3n1-2.doc", "A11achm3n1"}; 1294976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank int length = fileNames.length; 1295976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank for (int i = 0; i < length; i++) { 1296976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank File file = new File(directory, fileNames[i]); 1297976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank if (file.exists()) { 1298976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank file.delete(); 1299976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } 1300976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } 1301976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } 1302976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } 13034119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler 13044119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler /** 13054119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler * Test retrieving attachments by message ID (using EmailContent.Attachment.MESSAGE_ID_URI) 13064119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler */ 13074119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler public void testGetAttachmentByMessageIdUri() { 13084119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler 13094119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler // Note, we don't strictly need accounts, mailboxes or messages to run this test. 13104119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Attachment a1 = ProviderTestUtils.setupAttachment(1, "a1", 100, true, mMockContext); 13114119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Attachment a2 = ProviderTestUtils.setupAttachment(1, "a2", 200, true, mMockContext); 1312758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank ProviderTestUtils.setupAttachment(2, "a3", 300, true, mMockContext); 1313758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank ProviderTestUtils.setupAttachment(2, "a4", 400, true, mMockContext); 13144119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler 13154119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler // Now ask for the attachments of message id=1 13164119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler // Note: Using the "sort by size" trick to bring them back in expected order 13174119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Uri uri = ContentUris.withAppendedId(Attachment.MESSAGE_ID_URI, 1); 13184119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Cursor c = mMockContext.getContentResolver().query(uri, Attachment.CONTENT_PROJECTION, 13194119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler null, null, Attachment.SIZE); 13204119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler assertEquals(2, c.getCount()); 13214119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler 13224119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler try { 13234119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler c.moveToFirst(); 13244119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Attachment a1Get = EmailContent.getContent(c, Attachment.class); 13254119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler ProviderTestUtils.assertAttachmentEqual("getAttachByUri-1", a1, a1Get); 13264119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler c.moveToNext(); 13274119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Attachment a2Get = EmailContent.getContent(c, Attachment.class); 13284119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler ProviderTestUtils.assertAttachmentEqual("getAttachByUri-2", a2, a2Get); 13294119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler } finally { 13304119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler c.close(); 13314119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler } 13324119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler } 133354c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler 133454c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler /** 13356c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler * Test deleting attachments by message ID (using EmailContent.Attachment.MESSAGE_ID_URI) 13366c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler */ 13376c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler public void testDeleteAttachmentByMessageIdUri() { 13386c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler ContentResolver mockResolver = mMockContext.getContentResolver(); 13396c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 13406c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // Note, we don't strictly need accounts, mailboxes or messages to run this test. 13416c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler ProviderTestUtils.setupAttachment(1, "a1", 100, true, mMockContext); 13426c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler ProviderTestUtils.setupAttachment(1, "a2", 200, true, mMockContext); 13436c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Attachment a3 = ProviderTestUtils.setupAttachment(2, "a3", 300, true, mMockContext); 13446c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Attachment a4 = ProviderTestUtils.setupAttachment(2, "a4", 400, true, mMockContext); 13456c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 13466c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // Delete all attachments for message id=1 13476c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Uri uri = ContentUris.withAppendedId(Attachment.MESSAGE_ID_URI, 1); 13486c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler mockResolver.delete(uri, null, null); 13496c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 13506c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // Read back all attachments and confirm that we have the expected remaining attachments 13516c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // (the attachments that are set for message id=2). Note order-by size to simplify test. 13526c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Cursor c = mockResolver.query(Attachment.CONTENT_URI, Attachment.CONTENT_PROJECTION, 13536c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler null, null, Attachment.SIZE); 13546c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler assertEquals(2, c.getCount()); 13556c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 13566c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler try { 13576c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler c.moveToFirst(); 13586c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Attachment a3Get = EmailContent.getContent(c, Attachment.class); 13596c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler ProviderTestUtils.assertAttachmentEqual("getAttachByUri-3", a3, a3Get); 13606c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler c.moveToNext(); 13616c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Attachment a4Get = EmailContent.getContent(c, Attachment.class); 13626c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler ProviderTestUtils.assertAttachmentEqual("getAttachByUri-4", a4, a4Get); 13636c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler } finally { 13646c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler c.close(); 13656c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler } 13666c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler } 13676c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 13686c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler /** 136954c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler * Tests of default account behavior 1370758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank * 137154c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler * 1. Simple set/get 137254c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler * 2. Moving default between 3 accounts 137354c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler * 3. Delete default, make sure another becomes default 137454c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler */ 137554c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler public void testSetGetDefaultAccount() { 137654c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler // There should be no default account if there are no accounts 137754c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler long defaultAccountId = Account.getDefaultAccountId(mMockContext); 137854c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler assertEquals(-1, defaultAccountId); 137954c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler 138054c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("account-default-1", true, mMockContext); 138154c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler long account1Id = account1.mId; 138254c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler Account account2 = ProviderTestUtils.setupAccount("account-default-2", true, mMockContext); 138354c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler long account2Id = account2.mId; 138454c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler Account account3 = ProviderTestUtils.setupAccount("account-default-3", true, mMockContext); 138554c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler long account3Id = account3.mId; 138654c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler 13879e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler // With three accounts, but none marked default, confirm that some default account 13889e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler // is returned. Which one is undefined here. 138954c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler defaultAccountId = Account.getDefaultAccountId(mMockContext); 13909e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler assertTrue(defaultAccountId == account1Id 13919e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler || defaultAccountId == account2Id 13929e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler || defaultAccountId == account3Id); 139354c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler 13949e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler updateIsDefault(account1, true); 139554c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler defaultAccountId = Account.getDefaultAccountId(mMockContext); 13969e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler assertEquals(account1Id, defaultAccountId); 139754c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler 1398531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank updateIsDefault(account2, true); 1399531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank defaultAccountId = Account.getDefaultAccountId(mMockContext); 1400531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank assertEquals(account2Id, defaultAccountId); 1401531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank 1402531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank updateIsDefault(account3, true); 1403531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank defaultAccountId = Account.getDefaultAccountId(mMockContext); 1404531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank assertEquals(account3Id, defaultAccountId); 140554c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler 140654c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler // Now delete a non-default account and confirm no change 140754c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler Uri uri = ContentUris.withAppendedId(Account.CONTENT_URI, account1Id); 140854c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 140954c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler 1410531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank defaultAccountId = Account.getDefaultAccountId(mMockContext); 1411531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank assertEquals(account3Id, defaultAccountId); 141254c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler 141354c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler // Now confirm deleting the default account and it switches to another one 141454c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler uri = ContentUris.withAppendedId(Account.CONTENT_URI, account3Id); 141554c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 141654c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler 1417531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank defaultAccountId = Account.getDefaultAccountId(mMockContext); 1418531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank assertEquals(account2Id, defaultAccountId); 1419758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 14209e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler // Now delete the final account and confirm there are no default accounts again 14219e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler uri = ContentUris.withAppendedId(Account.CONTENT_URI, account2Id); 14229e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 14239e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler 142454c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler defaultAccountId = Account.getDefaultAccountId(mMockContext); 14259e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler assertEquals(-1, defaultAccountId); 142654c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler } 142754c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler 14289e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler private void updateIsDefault(Account account, boolean newState) { 14299e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler account.setDefaultAccount(newState); 14309e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler ContentValues cv = new ContentValues(); 14319e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler cv.put(AccountColumns.IS_DEFAULT, account.mIsDefault); 14329e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler account.update(mMockContext, cv); 14339e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler } 1434758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1435758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank public static Message setupUnreadMessage(String name, long accountId, long mailboxId, 1436758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank boolean addBody, boolean saveIt, Context context) { 1437758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank Message msg = 1438758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank ProviderTestUtils.setupMessage(name, accountId, mailboxId, addBody, false, context); 1439758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank msg.mFlagRead = false; 1440758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank if (saveIt) { 1441758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank msg.save(context); 1442758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank } 1443758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank return msg; 1444758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank } 1445758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1446758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank public void testUnreadCountTriggers() { 1447758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank // Start with one account and three mailboxes 1448758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank Account account = ProviderTestUtils.setupAccount("triggers", true, mMockContext); 1449758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank Mailbox boxA = ProviderTestUtils.setupMailbox("boxA", account.mId, true, mMockContext); 1450758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank Mailbox boxB = ProviderTestUtils.setupMailbox("boxB", account.mId, true, mMockContext); 1451758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank Mailbox boxC = ProviderTestUtils.setupMailbox("boxC", account.mId, true, mMockContext); 1452758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1453758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank // Make sure there are no unreads 1454758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(0, getUnreadCount(boxA.mId)); 1455758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(0, getUnreadCount(boxB.mId)); 1456758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(0, getUnreadCount(boxC.mId)); 1457758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1458758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank // Create 4 unread messages (only 3 named) in boxA 1459758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank Message message1 = setupUnreadMessage("message1", account.mId, boxA.mId, 1460758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank false, true, mMockContext); 1461758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank Message message2= setupUnreadMessage("message2", account.mId, boxA.mId, 1462758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank false, true, mMockContext); 1463758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank Message message3 = setupUnreadMessage("message3", account.mId, boxA.mId, 1464758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank false, true, mMockContext); 1465758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank setupUnreadMessage("message4", account.mId, boxC.mId, false, true, mMockContext); 1466758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1467758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank // Make sure the unreads are where we expect them 1468758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(3, getUnreadCount(boxA.mId)); 1469758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(0, getUnreadCount(boxB.mId)); 1470758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(1, getUnreadCount(boxC.mId)); 1471758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1472758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank // After deleting message 1, the count in box A should be decremented (to 2) 1473758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank ContentResolver cr = mMockContext.getContentResolver(); 1474758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank Uri uri = ContentUris.withAppendedId(Message.CONTENT_URI, message1.mId); 1475758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cr.delete(uri, null, null); 1476758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(2, getUnreadCount(boxA.mId)); 1477758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(0, getUnreadCount(boxB.mId)); 1478758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(1, getUnreadCount(boxC.mId)); 1479758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1480758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank // Move message 2 to box B, leaving 1 in box A and 1 in box B 1481758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank message2.mMailboxKey = boxB.mId; 1482758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank ContentValues cv = new ContentValues(); 1483758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cv.put(MessageColumns.MAILBOX_KEY, boxB.mId); 1484758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cr.update(ContentUris.withAppendedId(Message.CONTENT_URI, message2.mId), cv, null, null); 1485758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(1, getUnreadCount(boxA.mId)); 1486758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(1, getUnreadCount(boxB.mId)); 1487758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(1, getUnreadCount(boxC.mId)); 1488758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1489758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank // Mark message 3 (from box A) read, leaving 0 in box A 1490758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cv.clear(); 1491758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cv.put(MessageColumns.FLAG_READ, 1); 1492758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cr.update(ContentUris.withAppendedId(Message.CONTENT_URI, message3.mId), cv, null, null); 1493758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(0, getUnreadCount(boxA.mId)); 1494758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(1, getUnreadCount(boxB.mId)); 1495758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(1, getUnreadCount(boxC.mId)); 1496758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1497758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank // Move message 3 to box C; should be no change (it's read) 1498758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank message3.mMailboxKey = boxC.mId; 1499758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cv.clear(); 1500758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cv.put(MessageColumns.MAILBOX_KEY, boxC.mId); 1501758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cr.update(ContentUris.withAppendedId(Message.CONTENT_URI, message3.mId), cv, null, null); 1502758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(0, getUnreadCount(boxA.mId)); 1503758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(1, getUnreadCount(boxB.mId)); 1504758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(1, getUnreadCount(boxC.mId)); 1505758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1506758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank // Mark message 3 unread; it's now in box C, so that box's count should go up to 3 1507758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cv.clear(); 1508758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cv.put(MessageColumns.FLAG_READ, 0); 1509758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cr.update(ContentUris.withAppendedId(Message.CONTENT_URI, message3.mId), cv, null, null); 1510758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(0, getUnreadCount(boxA.mId)); 1511758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(1, getUnreadCount(boxB.mId)); 1512758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(2, getUnreadCount(boxC.mId)); 1513758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank } 15149627d014e16235eadf981b9165807dc72a14a383Mihai Preda 15159627d014e16235eadf981b9165807dc72a14a383Mihai Preda /** 15169627d014e16235eadf981b9165807dc72a14a383Mihai Preda * Test for EmailProvider.createIndex(). 15179627d014e16235eadf981b9165807dc72a14a383Mihai Preda * Check that it returns exacly the same string as the one used previously for index creation. 15189627d014e16235eadf981b9165807dc72a14a383Mihai Preda */ 15199627d014e16235eadf981b9165807dc72a14a383Mihai Preda public void testCreateIndex() { 15209627d014e16235eadf981b9165807dc72a14a383Mihai Preda String oldStr = "create index message_" + MessageColumns.TIMESTAMP 15219627d014e16235eadf981b9165807dc72a14a383Mihai Preda + " on " + Message.TABLE_NAME + " (" + MessageColumns.TIMESTAMP + ");"; 15229627d014e16235eadf981b9165807dc72a14a383Mihai Preda String newStr = EmailProvider.createIndex(Message.TABLE_NAME, MessageColumns.TIMESTAMP); 15239627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertEquals(newStr, oldStr); 15249627d014e16235eadf981b9165807dc72a14a383Mihai Preda } 1525c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank 1526c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank public void testIdAddToField() { 1527c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank ContentResolver cr = mMockContext.getContentResolver(); 1528c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank ContentValues cv = new ContentValues(); 1529c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank 1530c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank // Try changing the newMessageCount of an account 1531c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank Account account = ProviderTestUtils.setupAccount("field-add", true, mMockContext); 1532c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank int startCount = account.mNewMessageCount; 1533c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank // "field" and "add" are the two required elements 1534c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank cv.put(EmailContent.FIELD_COLUMN_NAME, AccountColumns.NEW_MESSAGE_COUNT); 1535c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank cv.put(EmailContent.ADD_COLUMN_NAME, 17); 1536c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank cr.update(ContentUris.withAppendedId(Account.ADD_TO_FIELD_URI, account.mId), 1537c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank cv, null, null); 1538c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank Account restoredAccount = Account.restoreAccountWithId(mMockContext, account.mId); 1539c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank assertEquals(17 + startCount, restoredAccount.mNewMessageCount); 1540c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank cv.put(EmailContent.ADD_COLUMN_NAME, -11); 1541c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank cr.update(ContentUris.withAppendedId(Account.ADD_TO_FIELD_URI, account.mId), 1542c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank cv, null, null); 1543c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank restoredAccount = Account.restoreAccountWithId(mMockContext, account.mId); 1544c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank assertEquals(17 - 11 + startCount, restoredAccount.mNewMessageCount); 1545c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank 1546c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank // Now try with a mailbox 1547c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank Mailbox boxA = ProviderTestUtils.setupMailbox("boxA", account.mId, true, mMockContext); 1548c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank assertEquals(0, boxA.mUnreadCount); 1549c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank cv.put(EmailContent.FIELD_COLUMN_NAME, MailboxColumns.UNREAD_COUNT); 1550c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank cv.put(EmailContent.ADD_COLUMN_NAME, 11); 1551c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank cr.update(ContentUris.withAppendedId(Mailbox.ADD_TO_FIELD_URI, boxA.mId), cv, null, null); 1552c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank Mailbox restoredBoxA = Mailbox.restoreMailboxWithId(mMockContext, boxA.mId); 1553c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank assertEquals(11, restoredBoxA.mUnreadCount); 1554c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank } 15550e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 15560e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank public void testDatabaseCorruptionRecovery() { 15570e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank final ContentResolver resolver = mMockContext.getContentResolver(); 15580e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank final Context context = mMockContext; 15590e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 15600e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Create account and two mailboxes 15610e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank Account acct = ProviderTestUtils.setupAccount("acct1", true, context); 15620e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank Mailbox box1 = ProviderTestUtils.setupMailbox("box1", acct.mId, true, context); 15630e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 15640e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Create 4 messages in box1 with bodies 15650e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank ProviderTestUtils.setupMessage("message1", acct.mId, box1.mId, true, true, context); 15660e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank ProviderTestUtils.setupMessage("message2", acct.mId, box1.mId, true, true, context); 15670e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank ProviderTestUtils.setupMessage("message3", acct.mId, box1.mId, true, true, context); 15680e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank ProviderTestUtils.setupMessage("message4", acct.mId, box1.mId, true, true, context); 15690e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 15700e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Confirm there are four messages 15710e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank int count = EmailContent.count(mMockContext, Message.CONTENT_URI, null, null); 15720e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertEquals(4, count); 15730e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Confirm there are four bodies 15740e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank count = EmailContent.count(mMockContext, Body.CONTENT_URI, null, null); 15750e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertEquals(4, count); 15760e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 15770e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Find the EmailProvider.db file 15780e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank File dbFile = mMockContext.getDatabasePath(EmailProvider.DATABASE_NAME); 15790e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // The EmailProvider.db database should exist (the provider creates it automatically) 15800e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertTrue(dbFile != null); 15810e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertTrue(dbFile.exists()); 15820e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Delete it, and confirm it is gone 15830e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertTrue(dbFile.delete()); 15840e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertFalse(dbFile.exists()); 15850e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 15860e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Find the EmailProviderBody.db file 15870e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank dbFile = mMockContext.getDatabasePath(EmailProvider.BODY_DATABASE_NAME); 15880e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // The EmailProviderBody.db database should still exist 15890e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertTrue(dbFile != null); 15900e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertTrue(dbFile.exists()); 15910e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 15920e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // URI to uncache the databases 15930e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // This simulates the Provider starting up again (otherwise, it will still be pointing to 15940e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // the already opened files) 15950e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Note that we only have access to the EmailProvider via the ContentResolver; therefore, 15960e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // we cannot directly call into the provider and use a URI for this 15970e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank resolver.update(EmailProvider.INTEGRITY_CHECK_URI, null, null, null); 15980e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 15990e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // TODO We should check for the deletion of attachment files once this is implemented in 16000e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // the provider 16010e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16020e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Explanation for what happens below... 16030e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // The next time the database is created by the provider, it will notice that there's 16040e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // already a EmailProviderBody.db file. In this case, it will delete that database to 16050e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // ensure that both are in sync (and empty) 16060e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16070e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Confirm there are no bodies 16080e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank count = EmailContent.count(mMockContext, Body.CONTENT_URI, null, null); 16090e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertEquals(0, count); 16100e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16110e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Confirm there are no messages 16120e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank count = EmailContent.count(mMockContext, Message.CONTENT_URI, null, null); 16130e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertEquals(0, count); 16140e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank } 16150e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16160e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank public void testBodyDatabaseCorruptionRecovery() { 16170e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank final ContentResolver resolver = mMockContext.getContentResolver(); 16180e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank final Context context = mMockContext; 16190e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16200e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Create account and two mailboxes 16210e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank Account acct = ProviderTestUtils.setupAccount("acct1", true, context); 16220e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank Mailbox box1 = ProviderTestUtils.setupMailbox("box1", acct.mId, true, context); 16230e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16240e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Create 4 messages in box1 with bodies 16250e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank ProviderTestUtils.setupMessage("message1", acct.mId, box1.mId, true, true, context); 16260e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank ProviderTestUtils.setupMessage("message2", acct.mId, box1.mId, true, true, context); 16270e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank ProviderTestUtils.setupMessage("message3", acct.mId, box1.mId, true, true, context); 16280e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank ProviderTestUtils.setupMessage("message4", acct.mId, box1.mId, true, true, context); 16290e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16300e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Confirm there are four messages 16310e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank int count = EmailContent.count(mMockContext, Message.CONTENT_URI, null, null); 16320e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertEquals(4, count); 16330e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Confirm there are four bodies 16340e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank count = EmailContent.count(mMockContext, Body.CONTENT_URI, null, null); 16350e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertEquals(4, count); 16360e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16370e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Find the EmailProviderBody.db file 16380e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank File dbFile = mMockContext.getDatabasePath(EmailProvider.BODY_DATABASE_NAME); 16390e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // The EmailProviderBody.db database should exist (the provider creates it automatically) 16400e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertTrue(dbFile != null); 16410e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertTrue(dbFile.exists()); 16420e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Delete it, and confirm it is gone 16430e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertTrue(dbFile.delete()); 16440e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertFalse(dbFile.exists()); 16450e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16460e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Find the EmailProvider.db file 16470e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank dbFile = mMockContext.getDatabasePath(EmailProvider.DATABASE_NAME); 16480e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // The EmailProviderBody.db database should still exist 16490e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertTrue(dbFile != null); 16500e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertTrue(dbFile.exists()); 16510e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16520e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // URI to uncache the databases 16530e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // This simulates the Provider starting up again (otherwise, it will still be pointing to 16540e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // the already opened files) 16550e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Note that we only have access to the EmailProvider via the ContentResolver; therefore, 16560e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // we cannot directly call into the provider and use a URI for this 16570e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank resolver.update(EmailProvider.INTEGRITY_CHECK_URI, null, null, null); 16580e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16590e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // TODO We should check for the deletion of attachment files once this is implemented in 16600e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // the provider 16610e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16620e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Explanation for what happens below... 16630e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // The next time the body database is created by the provider, it will notice that there's 16640e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // already a populated EmailProvider.db file. In this case, it will delete that database to 16650e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // ensure that both are in sync (and empty) 16660e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16670e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Confirm there are no messages 16680e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank count = EmailContent.count(mMockContext, Message.CONTENT_URI, null, null); 16690e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertEquals(0, count); 16700e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16710e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Confirm there are no bodies 16720e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank count = EmailContent.count(mMockContext, Body.CONTENT_URI, null, null); 16730e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertEquals(0, count); 16740e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank } 1675694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank 1676694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank public void testFindMailboxOfType() { 1677694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank final Context context = mMockContext; 1678694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank 1679694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank // Create two accounts and a variety of mailbox types 1680694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Account acct1 = ProviderTestUtils.setupAccount("acct1", true, context); 1681694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct1Inbox = 1682694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.setupMailbox("Inbox1", acct1.mId, true, context, Mailbox.TYPE_INBOX); 1683694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct1Calendar 1684694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank = ProviderTestUtils.setupMailbox("Cal1", acct1.mId, true, context, Mailbox.TYPE_CALENDAR); 1685694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct1Contacts = 1686694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.setupMailbox("Con1", acct1.mId, true, context, Mailbox.TYPE_CONTACTS); 1687694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Account acct2 = ProviderTestUtils.setupAccount("acct1", true, context); 1688694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct2Inbox = 1689694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.setupMailbox("Inbox2", acct2.mId, true, context, Mailbox.TYPE_INBOX); 1690694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct2Calendar = 1691694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.setupMailbox("Cal2", acct2.mId, true, context, Mailbox.TYPE_CALENDAR); 1692694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct2Contacts = 1693694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.setupMailbox("Con2", acct2.mId, true, context, Mailbox.TYPE_CONTACTS); 1694694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank 1695694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank // Check that we can find them by type 1696694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank assertEquals(acct1Inbox.mId, 1697694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.findMailboxOfType(context, acct1.mId, Mailbox.TYPE_INBOX)); 1698694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank assertEquals(acct2Inbox.mId, 1699694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.findMailboxOfType(context, acct2.mId, Mailbox.TYPE_INBOX)); 1700694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank assertEquals(acct1Calendar.mId, 1701694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.findMailboxOfType(context, acct1.mId, Mailbox.TYPE_CALENDAR)); 1702694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank assertEquals(acct2Calendar.mId, 1703694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.findMailboxOfType(context, acct2.mId, Mailbox.TYPE_CALENDAR)); 1704694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank assertEquals(acct1Contacts.mId, 1705694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.findMailboxOfType(context, acct1.mId, Mailbox.TYPE_CONTACTS)); 1706694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank assertEquals(acct2Contacts.mId, 1707694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.findMailboxOfType(context, acct2.mId, Mailbox.TYPE_CONTACTS)); 1708694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank } 1709694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank 1710694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank public void testRestoreMailboxOfType() { 1711694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank final Context context = mMockContext; 1712694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank 1713694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank // Create two accounts and a variety of mailbox types 1714694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Account acct1 = ProviderTestUtils.setupAccount("acct1", true, context); 1715694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct1Inbox = 1716694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.setupMailbox("Inbox1", acct1.mId, true, context, Mailbox.TYPE_INBOX); 1717694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct1Calendar 1718694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank = ProviderTestUtils.setupMailbox("Cal1", acct1.mId, true, context, Mailbox.TYPE_CALENDAR); 1719694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct1Contacts = 1720694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.setupMailbox("Con1", acct1.mId, true, context, Mailbox.TYPE_CONTACTS); 1721694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Account acct2 = ProviderTestUtils.setupAccount("acct1", true, context); 1722694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct2Inbox = 1723694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.setupMailbox("Inbox2", acct2.mId, true, context, Mailbox.TYPE_INBOX); 1724694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct2Calendar = 1725694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.setupMailbox("Cal2", acct2.mId, true, context, Mailbox.TYPE_CALENDAR); 1726694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct2Contacts = 1727694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.setupMailbox("Con2", acct2.mId, true, context, Mailbox.TYPE_CONTACTS); 1728694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank 1729694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank // Check that we can find them by type 1730694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.assertMailboxEqual("testRestoreMailboxOfType", acct1Inbox, 1731694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.restoreMailboxOfType(context, acct1.mId, Mailbox.TYPE_INBOX)); 1732694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.assertMailboxEqual("testRestoreMailboxOfType", acct2Inbox, 1733694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.restoreMailboxOfType(context, acct2.mId, Mailbox.TYPE_INBOX)); 1734694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.assertMailboxEqual("testRestoreMailboxOfType", acct1Calendar, 1735694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.restoreMailboxOfType(context, acct1.mId, Mailbox.TYPE_CALENDAR)); 1736694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.assertMailboxEqual("testRestoreMailboxOfType", acct2Calendar, 1737694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.restoreMailboxOfType(context, acct2.mId, Mailbox.TYPE_CALENDAR)); 1738694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.assertMailboxEqual("testRestoreMailboxOfType", acct1Contacts, 1739694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.restoreMailboxOfType(context, acct1.mId, Mailbox.TYPE_CONTACTS)); 1740694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.assertMailboxEqual("testRestoreMailboxOfType", acct2Contacts, 1741694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.restoreMailboxOfType(context, acct2.mId, Mailbox.TYPE_CONTACTS)); 1742694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank } 17437143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler} 1744