ProviderTests.java revision 5b0c2c7f344e72915ac63ff45cf3d65885373a39
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 19e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blankimport com.android.email.Snippet; 207143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadlerimport com.android.email.provider.EmailContent.Account; 219e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadlerimport com.android.email.provider.EmailContent.AccountColumns; 22976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blankimport com.android.email.provider.EmailContent.Attachment; 236c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadlerimport com.android.email.provider.EmailContent.AttachmentColumns; 247143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadlerimport com.android.email.provider.EmailContent.Body; 259627d014e16235eadf981b9165807dc72a14a383Mihai Predaimport com.android.email.provider.EmailContent.BodyColumns; 26da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadlerimport com.android.email.provider.EmailContent.HostAuth; 277143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadlerimport com.android.email.provider.EmailContent.Mailbox; 2841f775bbc731b25854da9f5a80c66a4aa1eb0af9satokimport com.android.email.provider.EmailContent.MailboxColumns; 297143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadlerimport com.android.email.provider.EmailContent.Message; 30ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadlerimport com.android.email.provider.EmailContent.MessageColumns; 317143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 32ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadlerimport android.content.ContentResolver; 337143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadlerimport android.content.ContentUris; 34ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadlerimport android.content.ContentValues; 357143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadlerimport android.content.Context; 367143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadlerimport android.database.Cursor; 37574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onukiimport android.database.sqlite.SQLiteDatabase; 387143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadlerimport android.net.Uri; 394a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadlerimport android.os.Bundle; 40976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blankimport android.os.Environment; 414a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadlerimport android.os.Parcel; 42e37881aac562c066e6e666349749e40b7c116a21Makoto Onukiimport android.test.MoreAsserts; 437143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadlerimport android.test.ProviderTestCase2; 447143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 45758a532fce2f672673d38b2daa5f67eb757b118bMarc Blankimport java.io.File; 46758a532fce2f672673d38b2daa5f67eb757b118bMarc Blankimport java.io.IOException; 47758a532fce2f672673d38b2daa5f67eb757b118bMarc Blankimport java.util.ArrayList; 48758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 497143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler/** 507143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * Tests of the Email provider. 51758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank * 527143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * You can run this entire test case with: 537143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * runtest -c com.android.email.provider.ProviderTests email 547143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 557143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadlerpublic class ProviderTests extends ProviderTestCase2<EmailProvider> { 56758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 577143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler EmailProvider mProvider; 587143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler Context mMockContext; 597143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 607143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public ProviderTests() { 617143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler super(EmailProvider.class, EmailProvider.EMAIL_AUTHORITY); 627143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 63758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 647143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler @Override 657143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public void setUp() throws Exception { 667143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler super.setUp(); 677143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler mMockContext = getMockContext(); 687143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 697143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 707143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler @Override 717143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public void tearDown() throws Exception { 727143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler super.tearDown(); 737143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 747143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 757143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 760d00889f83fc8c1d69039a2c849b630fb4dd28ddAndrew Stadler * TODO: Database upgrade tests 770d00889f83fc8c1d69039a2c849b630fb4dd28ddAndrew Stadler */ 780d00889f83fc8c1d69039a2c849b630fb4dd28ddAndrew Stadler 790d00889f83fc8c1d69039a2c849b630fb4dd28ddAndrew Stadler /** 807143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * Test simple account save/retrieve 817143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 827143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public void testAccountSave() { 8328448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("account-save", true, mMockContext); 847143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long account1Id = account1.mId; 85758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 867143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler Account account2 = EmailContent.Account.restoreAccountWithId(mMockContext, account1Id); 87758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 8828448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler ProviderTestUtils.assertAccountEqual("testAccountSave", account1, account2); 897143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 9041f775bbc731b25854da9f5a80c66a4aa1eb0af9satok 914a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler /** 92da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler * Test simple account save/retrieve with predefined hostauth records 93da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler */ 94da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler public void testAccountSaveHostAuth() { 95da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler Account account1 = ProviderTestUtils.setupAccount("account-hostauth", false, mMockContext); 96da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler // add hostauth data, which should be saved the first time 97da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler account1.mHostAuthRecv = ProviderTestUtils.setupHostAuth("account-hostauth-recv", -1, false, 98da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler mMockContext); 99da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler account1.mHostAuthSend = ProviderTestUtils.setupHostAuth("account-hostauth-send", -1, false, 100da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler mMockContext); 101da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler account1.save(mMockContext); 102da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler long account1Id = account1.mId; 103da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler 104da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler // Confirm account reads back correctly 105da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler Account account1get = EmailContent.Account.restoreAccountWithId(mMockContext, account1Id); 106da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler ProviderTestUtils.assertAccountEqual("testAccountSave", account1, account1get); 107da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler 108da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler // Confirm hostauth fields can be accessed & read back correctly 109da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler HostAuth hostAuth1get = EmailContent.HostAuth.restoreHostAuthWithId(mMockContext, 110da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler account1get.mHostAuthKeyRecv); 111da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler ProviderTestUtils.assertHostAuthEqual("testAccountSaveHostAuth-recv", 112da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler account1.mHostAuthRecv, hostAuth1get); 113da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler HostAuth hostAuth2get = EmailContent.HostAuth.restoreHostAuthWithId(mMockContext, 114da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler account1get.mHostAuthKeySend); 115da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler ProviderTestUtils.assertHostAuthEqual("testAccountSaveHostAuth-send", 116da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler account1.mHostAuthSend, hostAuth2get); 117da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler } 118da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler 119da8836a76cd8a6eaa7e3693eeacc6393870b2066Andrew Stadler /** 1204a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler * Simple test of account parceling. The rather tortuous path is to ensure that the 1214a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler * account is really flattened all the way down to a parcel and back. 1224a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler */ 1234a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler public void testAccountParcel() { 1244a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler Account account1 = ProviderTestUtils.setupAccount("parcel", false, mMockContext); 1254a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler Bundle b = new Bundle(); 1264a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler b.putParcelable("account", account1); 1274a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler Parcel p = Parcel.obtain(); 1284a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler b.writeToParcel(p, 0); 1294a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler p.setDataPosition(0); // rewind it for reading 1304a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler Bundle b2 = new Bundle(Account.class.getClassLoader()); 1314a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler b2.readFromParcel(p); 1324a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler Account account2 = (Account) b2.getParcelable("account"); 1334a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler p.recycle(); 1344a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler 1354a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler ProviderTestUtils.assertAccountEqual("testAccountParcel", account1, account2); 1364a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler } 1374a8c70c09be3914ded18031b4cca5a6d867de0d3Andrew Stadler 138e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki /** 139e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki * Test for {@link Account#getShortcutSafeUri()} and 140e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki * {@link Account#getAccountIdForShortcutSafeUri}. 141e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki */ 142e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki public void testAccountShortcutSafeUri() { 143e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki final Account account1 = ProviderTestUtils.setupAccount("account-1", true, mMockContext); 144e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki final Account account2 = ProviderTestUtils.setupAccount("account-2", true, mMockContext); 145e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki final long account1Id = account1.mId; 146e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki final long account2Id = account2.mId; 147e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki 148e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki final Uri uri1 = account1.getShortcutSafeUri(); 149e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki final Uri uri2 = account2.getShortcutSafeUri(); 150e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki 151e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki // Check the path part of the URIs. 152e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki MoreAsserts.assertEquals(new String[] {"account", account1.mCompatibilityUuid}, 153e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki uri1.getPathSegments().toArray()); 154e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki MoreAsserts.assertEquals(new String[] {"account", account2.mCompatibilityUuid}, 155e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki uri2.getPathSegments().toArray()); 156e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki 157e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki assertEquals(account1Id, Account.getAccountIdFromShortcutSafeUri(mMockContext, uri1)); 158e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki assertEquals(account2Id, Account.getAccountIdFromShortcutSafeUri(mMockContext, uri2)); 159e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki 160e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki // Test for the Eclair(2.0-2.1) style URI. 161e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki assertEquals(account1Id, Account.getAccountIdFromShortcutSafeUri(mMockContext, 162e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki getEclairStyleShortcutUri(account1))); 163e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki assertEquals(account2Id, Account.getAccountIdFromShortcutSafeUri(mMockContext, 164e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki getEclairStyleShortcutUri(account2))); 165e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki } 166e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki 167e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki private static Uri getEclairStyleShortcutUri(Account account) { 168e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki // We used _id instead of UUID only on Eclair(2.0-2.1). 169e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki return Account.CONTENT_URI.buildUpon().appendEncodedPath("" + account.mId).build(); 170e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki } 171e37881aac562c066e6e666349749e40b7c116a21Makoto Onuki 1728d8f86e899165772a7d91250b98dfc3c0d78b538Marc Blank public void testGetProtocol() { 1738d8f86e899165772a7d91250b98dfc3c0d78b538Marc Blank Account account1 = ProviderTestUtils.setupAccount("account-hostauth", false, mMockContext); 1748d8f86e899165772a7d91250b98dfc3c0d78b538Marc Blank // add hostauth data, with protocol 1758d8f86e899165772a7d91250b98dfc3c0d78b538Marc Blank account1.mHostAuthRecv = ProviderTestUtils.setupHostAuth("eas", "account-hostauth-recv", -1, 1768d8f86e899165772a7d91250b98dfc3c0d78b538Marc Blank false, mMockContext); 1778d8f86e899165772a7d91250b98dfc3c0d78b538Marc Blank // Note that getProtocol uses the receive host auth, so the protocol here shouldn't matter 1788d8f86e899165772a7d91250b98dfc3c0d78b538Marc Blank // to the test result 1798d8f86e899165772a7d91250b98dfc3c0d78b538Marc Blank account1.mHostAuthSend = ProviderTestUtils.setupHostAuth("foo", "account-hostauth-send", -1, 1808d8f86e899165772a7d91250b98dfc3c0d78b538Marc Blank false, mMockContext); 1818d8f86e899165772a7d91250b98dfc3c0d78b538Marc Blank account1.save(mMockContext); 18225144e2b7990c50bb3650faf1aec341837c05348Makoto Onuki assertEquals("eas", Account.getProtocol(mMockContext, account1.mId)); 18325144e2b7990c50bb3650faf1aec341837c05348Makoto Onuki assertEquals("eas", account1.getProtocol(mMockContext)); 1848d8f86e899165772a7d91250b98dfc3c0d78b538Marc Blank Account account2 = ProviderTestUtils.setupAccount("account-nohostauth", false, 1858d8f86e899165772a7d91250b98dfc3c0d78b538Marc Blank mMockContext); 1868d8f86e899165772a7d91250b98dfc3c0d78b538Marc Blank account2.save(mMockContext); 1878d8f86e899165772a7d91250b98dfc3c0d78b538Marc Blank // Make sure that we return null when there's no host auth 1888d8f86e899165772a7d91250b98dfc3c0d78b538Marc Blank assertNull(Account.getProtocol(mMockContext, account2.mId)); 1898d8f86e899165772a7d91250b98dfc3c0d78b538Marc Blank assertNull(account2.getProtocol(mMockContext)); 1908d8f86e899165772a7d91250b98dfc3c0d78b538Marc Blank // And when there's no account 1918d8f86e899165772a7d91250b98dfc3c0d78b538Marc Blank assertNull(Account.getProtocol(mMockContext, 0)); 1928d8f86e899165772a7d91250b98dfc3c0d78b538Marc Blank } 1938d8f86e899165772a7d91250b98dfc3c0d78b538Marc Blank 194652be6fb3d04a4ceba6b765cd3160cdaef9e6107Makoto Onuki public void testAccountIsValidId() { 195652be6fb3d04a4ceba6b765cd3160cdaef9e6107Makoto Onuki final Account account1 = ProviderTestUtils.setupAccount("account-1", true, mMockContext); 196652be6fb3d04a4ceba6b765cd3160cdaef9e6107Makoto Onuki final Account account2 = ProviderTestUtils.setupAccount("account-2", true, mMockContext); 197652be6fb3d04a4ceba6b765cd3160cdaef9e6107Makoto Onuki 198652be6fb3d04a4ceba6b765cd3160cdaef9e6107Makoto Onuki assertTrue(Account.isValidId(mMockContext, account1.mId)); 199652be6fb3d04a4ceba6b765cd3160cdaef9e6107Makoto Onuki assertTrue(Account.isValidId(mMockContext, account2.mId)); 200652be6fb3d04a4ceba6b765cd3160cdaef9e6107Makoto Onuki 201652be6fb3d04a4ceba6b765cd3160cdaef9e6107Makoto Onuki assertFalse(Account.isValidId(mMockContext, 1234567)); // Some random ID 202c133e6f1858e33fabaa6ffa173c1402bf9a98e31Makoto Onuki assertFalse(Account.isValidId(mMockContext, -1)); 203c133e6f1858e33fabaa6ffa173c1402bf9a98e31Makoto Onuki assertFalse(Account.isValidId(mMockContext, -500)); 204652be6fb3d04a4ceba6b765cd3160cdaef9e6107Makoto Onuki } 205652be6fb3d04a4ceba6b765cd3160cdaef9e6107Makoto Onuki 20641f775bbc731b25854da9f5a80c66a4aa1eb0af9satok private final static String[] MAILBOX_UNREAD_COUNT_PROJECTION = new String [] { 20741f775bbc731b25854da9f5a80c66a4aa1eb0af9satok MailboxColumns.UNREAD_COUNT 20841f775bbc731b25854da9f5a80c66a4aa1eb0af9satok }; 20941f775bbc731b25854da9f5a80c66a4aa1eb0af9satok private final static int MAILBOX_UNREAD_COUNT_COLMUN = 0; 21041f775bbc731b25854da9f5a80c66a4aa1eb0af9satok 21141f775bbc731b25854da9f5a80c66a4aa1eb0af9satok /** 21241f775bbc731b25854da9f5a80c66a4aa1eb0af9satok * Get the value of the unread count in the mailbox of the account. 21341f775bbc731b25854da9f5a80c66a4aa1eb0af9satok * This can be different from the actual number of unread messages in that mailbox. 21441f775bbc731b25854da9f5a80c66a4aa1eb0af9satok * @param accountId 21541f775bbc731b25854da9f5a80c66a4aa1eb0af9satok * @param mailboxId 21641f775bbc731b25854da9f5a80c66a4aa1eb0af9satok * @return 21741f775bbc731b25854da9f5a80c66a4aa1eb0af9satok */ 21841f775bbc731b25854da9f5a80c66a4aa1eb0af9satok private int getUnreadCount(long mailboxId) { 21941f775bbc731b25854da9f5a80c66a4aa1eb0af9satok String text = null; 22041f775bbc731b25854da9f5a80c66a4aa1eb0af9satok Cursor c = null; 22141f775bbc731b25854da9f5a80c66a4aa1eb0af9satok try { 22241f775bbc731b25854da9f5a80c66a4aa1eb0af9satok c = mMockContext.getContentResolver().query( 22341f775bbc731b25854da9f5a80c66a4aa1eb0af9satok Mailbox.CONTENT_URI, 22441f775bbc731b25854da9f5a80c66a4aa1eb0af9satok MAILBOX_UNREAD_COUNT_PROJECTION, 22541f775bbc731b25854da9f5a80c66a4aa1eb0af9satok EmailContent.RECORD_ID + "=?", 22641f775bbc731b25854da9f5a80c66a4aa1eb0af9satok new String[] { String.valueOf(mailboxId) }, 22741f775bbc731b25854da9f5a80c66a4aa1eb0af9satok null); 22841f775bbc731b25854da9f5a80c66a4aa1eb0af9satok c.moveToFirst(); 22941f775bbc731b25854da9f5a80c66a4aa1eb0af9satok text = c.getString(MAILBOX_UNREAD_COUNT_COLMUN); 23041f775bbc731b25854da9f5a80c66a4aa1eb0af9satok } finally { 23141f775bbc731b25854da9f5a80c66a4aa1eb0af9satok c.close(); 23241f775bbc731b25854da9f5a80c66a4aa1eb0af9satok } 23341f775bbc731b25854da9f5a80c66a4aa1eb0af9satok return Integer.valueOf(text); 23441f775bbc731b25854da9f5a80c66a4aa1eb0af9satok } 23541f775bbc731b25854da9f5a80c66a4aa1eb0af9satok 2367143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 2377143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: HostAuth tests 2387143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 239758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 2407143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 241e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler * Test the various combinations of SSL, TLS, and trust-certificates encoded as Uris 242e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler */ 243ef83299b99288c00b9d661260d19715e73e6889cMarc Blank @SuppressWarnings("deprecation") 244e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler public void testHostAuthSecurityUri() { 245e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler HostAuth ha = ProviderTestUtils.setupHostAuth("uri-security", 1, false, mMockContext); 246e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler 247e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler final int MASK = 248e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler HostAuth.FLAG_SSL | HostAuth.FLAG_TLS | HostAuth.FLAG_TRUST_ALL_CERTIFICATES; 249e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler 250e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Set various URIs and check the resulting flags 251e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("protocol://user:password@server:123"); 252e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(0, ha.mFlags & MASK); 253e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("protocol+ssl+://user:password@server:123"); 254e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(HostAuth.FLAG_SSL, ha.mFlags & MASK); 255e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("protocol+ssl+trustallcerts://user:password@server:123"); 256e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(HostAuth.FLAG_SSL | HostAuth.FLAG_TRUST_ALL_CERTIFICATES, ha.mFlags & MASK); 257e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("protocol+tls+://user:password@server:123"); 258e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(HostAuth.FLAG_TLS, ha.mFlags & MASK); 259e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("protocol+tls+trustallcerts://user:password@server:123"); 260e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(HostAuth.FLAG_TLS | HostAuth.FLAG_TRUST_ALL_CERTIFICATES, ha.mFlags & MASK); 261e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler 262e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Now check the retrival method (building URI from flags) 263e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.mFlags &= ~MASK; 264e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler String uriString = ha.getStoreUri(); 265e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertTrue(uriString.startsWith("protocol://")); 266e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.mFlags |= HostAuth.FLAG_SSL; 267e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler uriString = ha.getStoreUri(); 268e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertTrue(uriString.startsWith("protocol+ssl+://")); 269e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.mFlags |= HostAuth.FLAG_TRUST_ALL_CERTIFICATES; 270e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler uriString = ha.getStoreUri(); 271e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertTrue(uriString.startsWith("protocol+ssl+trustallcerts://")); 272e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.mFlags &= ~MASK; 273e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.mFlags |= HostAuth.FLAG_TLS; 274e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler uriString = ha.getStoreUri(); 275e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertTrue(uriString.startsWith("protocol+tls+://")); 276e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.mFlags |= HostAuth.FLAG_TRUST_ALL_CERTIFICATES; 277e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler uriString = ha.getStoreUri(); 278e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertTrue(uriString.startsWith("protocol+tls+trustallcerts://")); 279e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler } 280e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler 281e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler /** 282e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler * Test port assignments made from Uris 283e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler */ 284ef83299b99288c00b9d661260d19715e73e6889cMarc Blank @SuppressWarnings("deprecation") 285e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler public void testHostAuthPortAssignments() { 286e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler HostAuth ha = ProviderTestUtils.setupHostAuth("uri-port", 1, false, mMockContext); 287e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler 288e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Set various URIs and check the resulting flags 289e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Hardwired port 290e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("imap://user:password@server:123"); 291e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(123, ha.mPort); 292e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Auto-assigned ports 293e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("imap://user:password@server"); 294e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(143, ha.mPort); 295e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("imap+ssl://user:password@server"); 296e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(993, ha.mPort); 297e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("imap+ssl+trustallcerts://user:password@server"); 298e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(993, ha.mPort); 299e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("imap+tls://user:password@server"); 300e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(143, ha.mPort); 301e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("imap+tls+trustallcerts://user:password@server"); 302e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(143, ha.mPort); 303e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler 304e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Hardwired port 305e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("pop3://user:password@server:123"); 306e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(123, ha.mPort); 307e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Auto-assigned ports 308e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("pop3://user:password@server"); 309e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(110, ha.mPort); 310e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("pop3+ssl://user:password@server"); 311e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(995, ha.mPort); 312e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("pop3+ssl+trustallcerts://user:password@server"); 313e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(995, ha.mPort); 314e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("pop3+tls://user:password@server"); 315e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(110, ha.mPort); 316e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("pop3+tls+trustallcerts://user:password@server"); 317e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(110, ha.mPort); 318e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler 319e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Hardwired port 320e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("eas://user:password@server:123"); 321e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(123, ha.mPort); 322e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Auto-assigned ports 323e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("eas://user:password@server"); 324e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(80, ha.mPort); 325e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("eas+ssl://user:password@server"); 326e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(443, ha.mPort); 327e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("eas+ssl+trustallcerts://user:password@server"); 328e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(443, ha.mPort); 329e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler 330e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Hardwired port 331e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("smtp://user:password@server:123"); 332e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(123, ha.mPort); 333e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler // Auto-assigned ports 334e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("smtp://user:password@server"); 335e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(587, ha.mPort); 336e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("smtp+ssl://user:password@server"); 337e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(465, ha.mPort); 338e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("smtp+ssl+trustallcerts://user:password@server"); 339e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(465, ha.mPort); 340e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("smtp+tls://user:password@server"); 341e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(587, ha.mPort); 342e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler ha.setStoreUri("smtp+tls+trustallcerts://user:password@server"); 343e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler assertEquals(587, ha.mPort); 344e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler } 345e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler 346e4a7cc440f081ef9c4375a2bd2f82680cc11b152Andrew Stadler /** 3477143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * Test simple mailbox save/retrieve 3487143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 3497143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public void testMailboxSave() { 35028448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("mailbox-save", true, mMockContext); 3517143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long account1Id = account1.mId; 35228448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, 35328448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler mMockContext); 3547143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long box1Id = box1.mId; 355758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 3567143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler Mailbox box2 = EmailContent.Mailbox.restoreMailboxWithId(mMockContext, box1Id); 357758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 35828448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler ProviderTestUtils.assertMailboxEqual("testMailboxSave", box1, box2); 3597143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 360758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 3614119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler private static String[] expectedAttachmentNames = 362976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank new String[] {"attachment1.doc", "attachment2.xls", "attachment3"}; 363976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank // The lengths need to be kept in ascending order 3644119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler private static long[] expectedAttachmentSizes = new long[] {31415L, 97701L, 151213L}; 365976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank 366fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda /* 367fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * Returns null if the message has no body. 368fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda */ 369fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda private Body loadBodyForMessageId(long messageId) { 370fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Cursor c = null; 371fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda try { 372fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda c = mMockContext.getContentResolver().query( 373fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda EmailContent.Body.CONTENT_URI, 374fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda EmailContent.Body.CONTENT_PROJECTION, 375fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda EmailContent.Body.MESSAGE_KEY + "=?", 376fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda new String[] {String.valueOf(messageId)}, 377fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda null); 378fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda int numBodies = c.getCount(); 379fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda assertTrue("at most one body", numBodies < 2); 380fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda return c.moveToFirst() ? EmailContent.getContent(c, Body.class) : null; 381fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda } finally { 382fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda c.close(); 383fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda } 384fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda } 385fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 3867143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 3877143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * Test simple message save/retrieve 388758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank * 3897143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: serverId vs. serverIntId 3907143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 3917143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public void testMessageSave() { 39228448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("message-save", true, mMockContext); 3937143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long account1Id = account1.mId; 39428448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 3957143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long box1Id = box1.mId; 3967143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 3977143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // Test a simple message (saved with no body) 39828448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Message message1 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, false, 39928448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler true, mMockContext); 4007143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long message1Id = message1.mId; 4017143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler Message message1get = EmailContent.Message.restoreMessageWithId(mMockContext, message1Id); 40228448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler ProviderTestUtils.assertMessageEqual("testMessageSave", message1, message1get); 4037143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 4047143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // Test a message saved with a body 4057143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // Note that it will read back w/o the text & html so we must extract those 40628448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Message message2 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, true, 40728448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler true, mMockContext); 4087143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long message2Id = message2.mId; 4097143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler String text2 = message2.mText; 4107143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler String html2 = message2.mHtml; 411936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler String textReply2 = message2.mTextReply; 412936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler String htmlReply2 = message2.mHtmlReply; 4136c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler long sourceKey2 = message2.mSourceKey; 4145fc57eccefeba517fe5e6f093786f37c6c4d50e6Marc Blank String introText2 = message2.mIntroText; 4157143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler message2.mText = null; 4167143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler message2.mHtml = null; 417936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler message2.mTextReply = null; 418936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler message2.mHtmlReply = null; 419e25698319325d5e9619bc45ae85d861b0f1c5954Marc Blank message2.mSourceKey = 0; 4205fc57eccefeba517fe5e6f093786f37c6c4d50e6Marc Blank message2.mIntroText = null; 4217143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler Message message2get = EmailContent.Message.restoreMessageWithId(mMockContext, message2Id); 42228448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler ProviderTestUtils.assertMessageEqual("testMessageSave", message2, message2get); 423758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 4247143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // Now see if there's a body saved with the right stuff 425fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Body body2 = loadBodyForMessageId(message2Id); 426fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda assertEquals("body text", text2, body2.mTextContent); 427fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda assertEquals("body html", html2, body2.mHtmlContent); 428936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler assertEquals("reply text", textReply2, body2.mTextReply); 429936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler assertEquals("reply html", htmlReply2, body2.mHtmlReply); 4306c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler assertEquals("source key", sourceKey2, body2.mSourceKey); 4315fc57eccefeba517fe5e6f093786f37c6c4d50e6Marc Blank assertEquals("intro text", introText2, body2.mIntroText); 432976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank 4334119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler // Message with attachments and body 434976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank Message message3 = ProviderTestUtils.setupMessage("message3", account1Id, box1Id, true, 435976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank false, mMockContext); 436976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank ArrayList<Attachment> atts = new ArrayList<Attachment>(); 437976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank for (int i = 0; i < 3; i++) { 4384119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler atts.add(ProviderTestUtils.setupAttachment( 4394119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler -1, expectedAttachmentNames[i], expectedAttachmentSizes[i], 4404119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler false, mMockContext)); 441976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } 442976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank message3.mAttachments = atts; 4439e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler message3.save(mMockContext); 444976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank long message3Id = message3.mId; 445976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank 446976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank // Now check the attachments; there should be three and they should match name and size 447fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Cursor c = null; 448976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank try { 449976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank // Note that there is NO guarantee of the order of returned records in the general case, 450976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank // so we specifically ask for ordering by size. The expectedAttachmentSizes array must 451976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank // be kept sorted by size (ascending) for this test to work properly 452976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank c = mMockContext.getContentResolver().query( 453976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank Attachment.CONTENT_URI, 454976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank Attachment.CONTENT_PROJECTION, 455976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank Attachment.MESSAGE_KEY + "=?", 456976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank new String[] { 457976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank String.valueOf(message3Id) 458976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank }, 459976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank Attachment.SIZE); 460976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank int numAtts = c.getCount(); 461976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank assertEquals(3, numAtts); 462976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank int i = 0; 463976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank while (c.moveToNext()) { 4644119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Attachment actual = EmailContent.getContent(c, Attachment.class); 4654119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler ProviderTestUtils.assertAttachmentEqual("save-message3", atts.get(i), actual); 4664119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler i++; 4674119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler } 4684119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler } finally { 4694119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler c.close(); 4704119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler } 4714119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler 4724119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler // Message with attachments but no body 4734119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Message message4 = ProviderTestUtils.setupMessage("message4", account1Id, box1Id, false, 4744119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler false, mMockContext); 4754119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler atts = new ArrayList<Attachment>(); 4764119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler for (int i = 0; i < 3; i++) { 4774119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler atts.add(ProviderTestUtils.setupAttachment( 4784119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler -1, expectedAttachmentNames[i], expectedAttachmentSizes[i], 4794119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler false, mMockContext)); 4804119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler } 4814119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler message4.mAttachments = atts; 4829e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler message4.save(mMockContext); 4834119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler long message4Id = message4.mId; 4844119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler 4854119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler // Now check the attachments; there should be three and they should match name and size 4864119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler c = null; 48741f775bbc731b25854da9f5a80c66a4aa1eb0af9satok 4884119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler try { 4894119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler // Note that there is NO guarantee of the order of returned records in the general case, 4904119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler // so we specifically ask for ordering by size. The expectedAttachmentSizes array must 4914119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler // be kept sorted by size (ascending) for this test to work properly 4924119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler c = mMockContext.getContentResolver().query( 4934119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Attachment.CONTENT_URI, 4944119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Attachment.CONTENT_PROJECTION, 4954119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Attachment.MESSAGE_KEY + "=?", 4964119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler new String[] { 4974119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler String.valueOf(message4Id) 4984119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler }, 4994119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Attachment.SIZE); 5004119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler int numAtts = c.getCount(); 5014119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler assertEquals(3, numAtts); 5024119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler int i = 0; 5034119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler while (c.moveToNext()) { 5044119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Attachment actual = EmailContent.getContent(c, Attachment.class); 5054119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler ProviderTestUtils.assertAttachmentEqual("save-message4", atts.get(i), actual); 506976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank i++; 507976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } 508976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } finally { 509976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank c.close(); 5107143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 51144144d0301213536b02f2080237b63d8271b2d0bMihai Preda 51244144d0301213536b02f2080237b63d8271b2d0bMihai Preda // test EmailContent.restoreAttachmentsWitdMessageId() 51344144d0301213536b02f2080237b63d8271b2d0bMihai Preda Attachment[] attachments = 51444144d0301213536b02f2080237b63d8271b2d0bMihai Preda Attachment.restoreAttachmentsWithMessageId(mMockContext, message4Id); 51544144d0301213536b02f2080237b63d8271b2d0bMihai Preda int size = attachments.length; 51644144d0301213536b02f2080237b63d8271b2d0bMihai Preda assertEquals(3, size); 51744144d0301213536b02f2080237b63d8271b2d0bMihai Preda for (int i = 0; i < size; ++i) { 51844144d0301213536b02f2080237b63d8271b2d0bMihai Preda ProviderTestUtils.assertAttachmentEqual("save-message4", atts.get(i), attachments[i]); 51944144d0301213536b02f2080237b63d8271b2d0bMihai Preda } 5207143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 521758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 5227143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 523e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank * Test that saving a message creates the proper snippet for that message 524e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank */ 525e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank public void testMessageSaveAddsSnippet() { 526e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank Account account = ProviderTestUtils.setupAccount("message-snippet", true, mMockContext); 527e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank Mailbox box = ProviderTestUtils.setupMailbox("box1", account.mId, true, mMockContext); 528e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank 529e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank // Create a message without a body, unsaved 530e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank Message message = ProviderTestUtils.setupMessage("message", account.mId, box.mId, false, 531e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank false, mMockContext); 532e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank message.mText = "This is some text"; 533e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank message.mHtml = "<html>This is some text</html>"; 534e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank message.save(mMockContext); 535e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank Message restoredMessage = Message.restoreMessageWithId(mMockContext, message.mId); 536e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank // We should have the plain text as the snippet 537e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank assertEquals(restoredMessage.mSnippet, Snippet.fromPlainText(message.mText)); 538e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank 539e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank // Start again 540e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank message = ProviderTestUtils.setupMessage("message", account.mId, box.mId, false, 541e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank false, mMockContext); 542e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank message.mText = null; 543e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank message.mHtml = "<html>This is some text</html>"; 544e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank message.save(mMockContext); 545e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank restoredMessage = Message.restoreMessageWithId(mMockContext, message.mId); 546e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank // We should have the plain text as the snippet 547e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank assertEquals(restoredMessage.mSnippet, Snippet.fromHtmlText(message.mHtml)); 548e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank } 549e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank 550e7b9e4ab94093127002f4cddd3ffcc3deb1c0b41Marc Blank /** 5517143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: update account 5527143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 553758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 5547143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 5557143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: update mailbox 5567143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 557758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 5587143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 5597143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: update message 5607143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 561758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 5627143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 5637143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * Test delete account 5647143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: hostauth 5657143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 5667143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public void testAccountDelete() { 56728448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("account-delete-1", true, mMockContext); 5687143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long account1Id = account1.mId; 56928448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account2 = ProviderTestUtils.setupAccount("account-delete-2", true, mMockContext); 5707143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long account2Id = account2.mId; 5717143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 5727143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there are two accounts 5737143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler int numBoxes = EmailContent.count(mMockContext, Account.CONTENT_URI, null, null); 5747143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(2, numBoxes); 5757143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 5767143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // now delete one of them 5777143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler Uri uri = ContentUris.withAppendedId(Account.CONTENT_URI, account1Id); 5787143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 5797143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 5807143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there's only one account now 5817143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler numBoxes = EmailContent.count(mMockContext, Account.CONTENT_URI, null, null); 5827143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(1, numBoxes); 5837143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 5847143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // now delete the other one 5857143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler uri = ContentUris.withAppendedId(Account.CONTENT_URI, account2Id); 5867143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 5877143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 5887143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there are no accounts now 5897143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler numBoxes = EmailContent.count(mMockContext, Account.CONTENT_URI, null, null); 5907143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(0, numBoxes); 5917143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 592758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 5937143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 5949627d014e16235eadf981b9165807dc72a14a383Mihai Preda * Test for Body.lookupBodyIdWithMessageId() 5959627d014e16235eadf981b9165807dc72a14a383Mihai Preda * Verifies that: 5969627d014e16235eadf981b9165807dc72a14a383Mihai Preda * - for a message without body, -1 is returned. 5979627d014e16235eadf981b9165807dc72a14a383Mihai Preda * - for a mesage with body, the id matches the one from loadBodyForMessageId. 5989627d014e16235eadf981b9165807dc72a14a383Mihai Preda */ 5999627d014e16235eadf981b9165807dc72a14a383Mihai Preda public void testLookupBodyIdWithMessageId() { 6009627d014e16235eadf981b9165807dc72a14a383Mihai Preda final ContentResolver resolver = mMockContext.getContentResolver(); 6019627d014e16235eadf981b9165807dc72a14a383Mihai Preda Account account1 = ProviderTestUtils.setupAccount("orphaned body", true, mMockContext); 6029627d014e16235eadf981b9165807dc72a14a383Mihai Preda long account1Id = account1.mId; 6039627d014e16235eadf981b9165807dc72a14a383Mihai Preda Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 6049627d014e16235eadf981b9165807dc72a14a383Mihai Preda long box1Id = box1.mId; 6059627d014e16235eadf981b9165807dc72a14a383Mihai Preda 6069627d014e16235eadf981b9165807dc72a14a383Mihai Preda // 1. create message with no body, check that returned bodyId is -1 6079627d014e16235eadf981b9165807dc72a14a383Mihai Preda Message message1 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, false, 6089627d014e16235eadf981b9165807dc72a14a383Mihai Preda true, mMockContext); 6099627d014e16235eadf981b9165807dc72a14a383Mihai Preda long message1Id = message1.mId; 610bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki long bodyId1 = Body.lookupBodyIdWithMessageId(mMockContext, message1Id); 6119627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertEquals(bodyId1, -1); 6129627d014e16235eadf981b9165807dc72a14a383Mihai Preda 6139627d014e16235eadf981b9165807dc72a14a383Mihai Preda // 2. create message with body, check that returned bodyId is correct 6149627d014e16235eadf981b9165807dc72a14a383Mihai Preda Message message2 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, true, 6159627d014e16235eadf981b9165807dc72a14a383Mihai Preda true, mMockContext); 6169627d014e16235eadf981b9165807dc72a14a383Mihai Preda long message2Id = message2.mId; 617bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki long bodyId2 = Body.lookupBodyIdWithMessageId(mMockContext, message2Id); 6189627d014e16235eadf981b9165807dc72a14a383Mihai Preda Body body = loadBodyForMessageId(message2Id); 6199627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertNotNull(body); 6209627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertEquals(body.mId, bodyId2); 6219627d014e16235eadf981b9165807dc72a14a383Mihai Preda } 6229627d014e16235eadf981b9165807dc72a14a383Mihai Preda 6239627d014e16235eadf981b9165807dc72a14a383Mihai Preda /** 6249627d014e16235eadf981b9165807dc72a14a383Mihai Preda * Test for Body.updateBodyWithMessageId(). 6259627d014e16235eadf981b9165807dc72a14a383Mihai Preda * 1. - create message without body, 6269627d014e16235eadf981b9165807dc72a14a383Mihai Preda * - update its body (set TEXT_CONTENT) 6279627d014e16235eadf981b9165807dc72a14a383Mihai Preda * - check correct updated body is read back 6289627d014e16235eadf981b9165807dc72a14a383Mihai Preda * 6299627d014e16235eadf981b9165807dc72a14a383Mihai Preda * 2. - create message with body, 6309627d014e16235eadf981b9165807dc72a14a383Mihai Preda * - update body (set TEXT_CONTENT) 6319627d014e16235eadf981b9165807dc72a14a383Mihai Preda * - check correct updated body is read back 6329627d014e16235eadf981b9165807dc72a14a383Mihai Preda */ 6339627d014e16235eadf981b9165807dc72a14a383Mihai Preda public void testUpdateBodyWithMessageId() { 6349627d014e16235eadf981b9165807dc72a14a383Mihai Preda Account account1 = ProviderTestUtils.setupAccount("orphaned body", true, mMockContext); 6359627d014e16235eadf981b9165807dc72a14a383Mihai Preda long account1Id = account1.mId; 6369627d014e16235eadf981b9165807dc72a14a383Mihai Preda Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 6379627d014e16235eadf981b9165807dc72a14a383Mihai Preda long box1Id = box1.mId; 6389627d014e16235eadf981b9165807dc72a14a383Mihai Preda 6399627d014e16235eadf981b9165807dc72a14a383Mihai Preda final String textContent = "foobar some odd text"; 640936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler final String htmlContent = "and some html"; 641936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler final String textReply = "plain text reply"; 642936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler final String htmlReply = "or the html reply"; 6435fc57eccefeba517fe5e6f093786f37c6c4d50e6Marc Blank final String introText = "fred wrote:"; 6449627d014e16235eadf981b9165807dc72a14a383Mihai Preda 6459627d014e16235eadf981b9165807dc72a14a383Mihai Preda ContentValues values = new ContentValues(); 6469627d014e16235eadf981b9165807dc72a14a383Mihai Preda values.put(BodyColumns.TEXT_CONTENT, textContent); 647936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler values.put(BodyColumns.HTML_CONTENT, htmlContent); 648936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler values.put(BodyColumns.TEXT_REPLY, textReply); 649936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler values.put(BodyColumns.HTML_REPLY, htmlReply); 650e25698319325d5e9619bc45ae85d861b0f1c5954Marc Blank values.put(BodyColumns.SOURCE_MESSAGE_KEY, 17); 6515fc57eccefeba517fe5e6f093786f37c6c4d50e6Marc Blank values.put(BodyColumns.INTRO_TEXT, introText); 6529627d014e16235eadf981b9165807dc72a14a383Mihai Preda 6539627d014e16235eadf981b9165807dc72a14a383Mihai Preda // 1 6549627d014e16235eadf981b9165807dc72a14a383Mihai Preda Message message1 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, false, 6559627d014e16235eadf981b9165807dc72a14a383Mihai Preda true, mMockContext); 6569627d014e16235eadf981b9165807dc72a14a383Mihai Preda long message1Id = message1.mId; 6579627d014e16235eadf981b9165807dc72a14a383Mihai Preda Body body1 = loadBodyForMessageId(message1Id); 6589627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertNull(body1); 6599627d014e16235eadf981b9165807dc72a14a383Mihai Preda Body.updateBodyWithMessageId(mMockContext, message1Id, values); 6609627d014e16235eadf981b9165807dc72a14a383Mihai Preda body1 = loadBodyForMessageId(message1Id); 6619627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertNotNull(body1); 6629627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertEquals(body1.mTextContent, textContent); 663936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler assertEquals(body1.mHtmlContent, htmlContent); 664936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler assertEquals(body1.mTextReply, textReply); 665936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler assertEquals(body1.mHtmlReply, htmlReply); 666e25698319325d5e9619bc45ae85d861b0f1c5954Marc Blank assertEquals(body1.mSourceKey, 17); 6675fc57eccefeba517fe5e6f093786f37c6c4d50e6Marc Blank assertEquals(body1.mIntroText, introText); 6689627d014e16235eadf981b9165807dc72a14a383Mihai Preda 6699627d014e16235eadf981b9165807dc72a14a383Mihai Preda // 2 6709627d014e16235eadf981b9165807dc72a14a383Mihai Preda Message message2 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, true, 6719627d014e16235eadf981b9165807dc72a14a383Mihai Preda true, mMockContext); 6729627d014e16235eadf981b9165807dc72a14a383Mihai Preda long message2Id = message2.mId; 6739627d014e16235eadf981b9165807dc72a14a383Mihai Preda Body body2 = loadBodyForMessageId(message2Id); 6749627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertNotNull(body2); 6759627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertTrue(!body2.mTextContent.equals(textContent)); 6769627d014e16235eadf981b9165807dc72a14a383Mihai Preda Body.updateBodyWithMessageId(mMockContext, message2Id, values); 6779627d014e16235eadf981b9165807dc72a14a383Mihai Preda body2 = loadBodyForMessageId(message1Id); 6789627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertNotNull(body2); 6799627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertEquals(body2.mTextContent, textContent); 680936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler assertEquals(body2.mHtmlContent, htmlContent); 681936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler assertEquals(body2.mTextReply, textReply); 682936babc145e2e6eb2e222f2ce5e3da8f9e4fb9f2Andrew Stadler assertEquals(body2.mHtmlReply, htmlReply); 683e25698319325d5e9619bc45ae85d861b0f1c5954Marc Blank assertEquals(body2.mSourceKey, 17); 6845fc57eccefeba517fe5e6f093786f37c6c4d50e6Marc Blank assertEquals(body2.mIntroText, introText); 6859627d014e16235eadf981b9165807dc72a14a383Mihai Preda } 6869627d014e16235eadf981b9165807dc72a14a383Mihai Preda 6879627d014e16235eadf981b9165807dc72a14a383Mihai Preda /** 688c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler * Test body retrieve methods 689c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler */ 690c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler public void testBodyRetrieve() { 691c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler // No account needed 692c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler // No mailbox needed 693c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler Message message1 = ProviderTestUtils.setupMessage("bodyretrieve", 1, 1, true, 694c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler true, mMockContext); 695c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler long messageId = message1.mId; 696c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler 697c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler assertEquals(message1.mText, 698c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler Body.restoreBodyTextWithMessageId(mMockContext, messageId)); 699c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler assertEquals(message1.mHtml, 700c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler Body.restoreBodyHtmlWithMessageId(mMockContext, messageId)); 701c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler assertEquals(message1.mTextReply, 702c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler Body.restoreReplyTextWithMessageId(mMockContext, messageId)); 703c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler assertEquals(message1.mHtmlReply, 704c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler Body.restoreReplyHtmlWithMessageId(mMockContext, messageId)); 705c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler assertEquals(message1.mIntroText, 706c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler Body.restoreIntroTextWithMessageId(mMockContext, messageId)); 7071575e7860d2259f1aed201ab23d526cddf787365Mihai Preda assertEquals(message1.mSourceKey, 7081575e7860d2259f1aed201ab23d526cddf787365Mihai Preda Body.restoreBodySourceKey(mMockContext, messageId)); 709c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler } 710c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler 711c41c47fa07a22f8a7612fb0191f152a36d95b7a5Andrew Stadler /** 712fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * Test delete body. 713fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * 1. create message without body (message id 1) 714fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * 2. create message with body (message id 2. The body has _id 1 and messageKey 2). 715fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * 3. delete first message. 716fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * 4. verify that body for message 2 has not been deleted. 717fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * 5. delete message 2, verify body is deleted. 718fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda */ 719fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda public void testDeleteBody() { 720fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda final ContentResolver resolver = mMockContext.getContentResolver(); 721fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 722fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // Create account and mailboxes 723fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Account account1 = ProviderTestUtils.setupAccount("orphaned body", true, mMockContext); 724fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda long account1Id = account1.mId; 725fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 726fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda long box1Id = box1.mId; 727fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 728fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // 1. create message without body 729fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Message message1 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, false, 730fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda true, mMockContext); 731fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda long message1Id = message1.mId; 732fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 733fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // 2. create message with body 734fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Message message2 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, true, 735fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda true, mMockContext); 736fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda long message2Id = message2.mId; 737fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // verify body is there 738fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda assertNotNull(loadBodyForMessageId(message2Id)); 739fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 740fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // 3. delete first message 741fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda resolver.delete(ContentUris.withAppendedId(Message.CONTENT_URI, message1Id), null, null); 742c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank 743fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // 4. verify body for second message wasn't deleted 744fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda assertNotNull(loadBodyForMessageId(message2Id)); 745fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 746fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // 5. delete second message, check its body is deleted 747fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda resolver.delete(ContentUris.withAppendedId(Message.CONTENT_URI, message2Id), null, null); 748fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda assertNull(loadBodyForMessageId(message2Id)); 749fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda } 750fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 751fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda /** 752fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * Test delete orphan bodies. 753fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * 1. create message without body (message id 1) 754fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * 2. create message with body (message id 2. Body has _id 1 and messageKey 2). 755fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * 3. delete first message. 756fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * 4. delete some other mailbox -- this triggers delete orphan bodies. 757fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda * 5. verify that body for message 2 has not been deleted. 758fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda */ 759fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda public void testDeleteOrphanBodies() { 760fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda final ContentResolver resolver = mMockContext.getContentResolver(); 761fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 762ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Create account and two mailboxes 763fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Account account1 = ProviderTestUtils.setupAccount("orphaned body", true, mMockContext); 764fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda long account1Id = account1.mId; 765fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 766fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda long box1Id = box1.mId; 767fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Mailbox box2 = ProviderTestUtils.setupMailbox("box2", account1Id, true, mMockContext); 768fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda long box2Id = box2.mId; 769fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 770fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // 1. create message without body 771fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Message message1 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, false, 772fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda true, mMockContext); 773fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda long message1Id = message1.mId; 774fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 775fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // 2. create message with body 776fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda Message message2 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, true, 777fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda true, mMockContext); 778fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda long message2Id = message2.mId; 779fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda //verify body is there 780fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda assertNotNull(loadBodyForMessageId(message2Id)); 781fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 782fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // 3. delete first message 783fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda resolver.delete(ContentUris.withAppendedId(Message.CONTENT_URI, message1Id), null, null); 784fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 785fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // 4. delete some mailbox (because it triggers "delete orphan bodies") 786fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda resolver.delete(ContentUris.withAppendedId(Mailbox.CONTENT_URI, box2Id), null, null); 787fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 788fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda // 5. verify body for second message wasn't deleted during "delete orphan bodies" 789fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda assertNotNull(loadBodyForMessageId(message2Id)); 790fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda } 791fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda 792fb7974f5bfb6275fb856b0f7ff386ef10680c83aMihai Preda /** 793ef83299b99288c00b9d661260d19715e73e6889cMarc Blank * Test delete orphan messages 794ef83299b99288c00b9d661260d19715e73e6889cMarc Blank * 1. create message without body (message id 1) 795ef83299b99288c00b9d661260d19715e73e6889cMarc Blank * 2. create message with body (message id 2. Body has _id 1 and messageKey 2). 796ef83299b99288c00b9d661260d19715e73e6889cMarc Blank * 3. delete first message. 797ef83299b99288c00b9d661260d19715e73e6889cMarc Blank * 4. delete some other mailbox -- this triggers delete orphan bodies. 798ef83299b99288c00b9d661260d19715e73e6889cMarc Blank * 5. verify that body for message 2 has not been deleted. 799ef83299b99288c00b9d661260d19715e73e6889cMarc Blank */ 800ef83299b99288c00b9d661260d19715e73e6889cMarc Blank public void testDeleteOrphanMessages() { 801ef83299b99288c00b9d661260d19715e73e6889cMarc Blank final ContentResolver resolver = mMockContext.getContentResolver(); 802ef83299b99288c00b9d661260d19715e73e6889cMarc Blank final Context context = mMockContext; 803ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 804ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Create account and two mailboxes 805ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Account acct = ProviderTestUtils.setupAccount("orphaned body", true, context); 806ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Mailbox box1 = ProviderTestUtils.setupMailbox("box1", acct.mId, true, context); 807ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Mailbox box2 = ProviderTestUtils.setupMailbox("box2", acct.mId, true, context); 808ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 809ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Create 4 messages in box1 810ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msg1_1 = 811ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("message1", acct.mId, box1.mId, false, true, context); 812ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msg1_2 = 813ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("message2", acct.mId, box1.mId, false, true, context); 814ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msg1_3 = 815ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("message3", acct.mId, box1.mId, false, true, context); 816ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msg1_4 = 817ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("message4", acct.mId, box1.mId, false, true, context); 818ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 819ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Create 4 messages in box2 820ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msg2_1 = 821ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("message1", acct.mId, box2.mId, false, true, context); 822ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msg2_2 = 823ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("message2", acct.mId, box2.mId, false, true, context); 824ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msg2_3 = 825ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("message3", acct.mId, box2.mId, false, true, context); 826ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msg2_4 = 827ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("message4", acct.mId, box2.mId, false, true, context); 828ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 829ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Delete 2 from each mailbox 830ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.delete(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, msg1_1.mId), 831ef83299b99288c00b9d661260d19715e73e6889cMarc Blank null, null); 832ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.delete(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, msg1_2.mId), 833ef83299b99288c00b9d661260d19715e73e6889cMarc Blank null, null); 834ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.delete(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, msg2_1.mId), 835ef83299b99288c00b9d661260d19715e73e6889cMarc Blank null, null); 836ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.delete(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, msg2_2.mId), 837ef83299b99288c00b9d661260d19715e73e6889cMarc Blank null, null); 838ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 839ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // There should be 4 items in the deleted item table 840ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(4, EmailContent.count(context, Message.DELETED_CONTENT_URI, null, null)); 841ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 842ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Update 2 from each mailbox 843ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ContentValues v = new ContentValues(); 844ef83299b99288c00b9d661260d19715e73e6889cMarc Blank v.put(MessageColumns.DISPLAY_NAME, "--updated--"); 845ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.update(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, msg1_3.mId), 846ef83299b99288c00b9d661260d19715e73e6889cMarc Blank v, null, null); 847ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.update(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, msg1_4.mId), 848ef83299b99288c00b9d661260d19715e73e6889cMarc Blank v, null, null); 849ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.update(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, msg2_3.mId), 850ef83299b99288c00b9d661260d19715e73e6889cMarc Blank v, null, null); 851ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.update(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, msg2_4.mId), 852ef83299b99288c00b9d661260d19715e73e6889cMarc Blank v, null, null); 853ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 854ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // There should be 4 items in the updated item table 855ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(4, EmailContent.count(context, Message.UPDATED_CONTENT_URI, null, null)); 856ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 857ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Manually add 2 messages from a "deleted" mailbox to deleted and updated tables 858ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Use a value > 2 for the deleted box id 859ef83299b99288c00b9d661260d19715e73e6889cMarc Blank long delBoxId = 10; 860ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Create 4 messages in the "deleted" mailbox 861ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msgX_A = 862ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("messageA", acct.mId, delBoxId, false, false, context); 863ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msgX_B = 864ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("messageB", acct.mId, delBoxId, false, false, context); 865ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msgX_C = 866ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("messageC", acct.mId, delBoxId, false, false, context); 867ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message msgX_D = 868ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("messageD", acct.mId, delBoxId, false, false, context); 869ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 870ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ContentValues cv; 871ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // We have to assign id's manually because there are no autoincrement id's for these tables 872ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Start with an id that won't exist, since id's in these tables must be unique 873ef83299b99288c00b9d661260d19715e73e6889cMarc Blank long msgId = 10; 874ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // It's illegal to manually insert these, so we need to catch the exception 875ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // NOTE: The insert succeeds, and then throws the exception 876ef83299b99288c00b9d661260d19715e73e6889cMarc Blank try { 877ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv = msgX_A.toContentValues(); 878ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv.put(EmailContent.RECORD_ID, msgId++); 879ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.insert(Message.DELETED_CONTENT_URI, cv); 880ef83299b99288c00b9d661260d19715e73e6889cMarc Blank } catch (IllegalArgumentException e) { 881ef83299b99288c00b9d661260d19715e73e6889cMarc Blank } 882ef83299b99288c00b9d661260d19715e73e6889cMarc Blank try { 883ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv = msgX_B.toContentValues(); 884ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv.put(EmailContent.RECORD_ID, msgId++); 885ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.insert(Message.DELETED_CONTENT_URI, cv); 886ef83299b99288c00b9d661260d19715e73e6889cMarc Blank } catch (IllegalArgumentException e) { 887ef83299b99288c00b9d661260d19715e73e6889cMarc Blank } 888ef83299b99288c00b9d661260d19715e73e6889cMarc Blank try { 889ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv = msgX_C.toContentValues(); 890ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv.put(EmailContent.RECORD_ID, msgId++); 891ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.insert(Message.UPDATED_CONTENT_URI, cv); 892ef83299b99288c00b9d661260d19715e73e6889cMarc Blank } catch (IllegalArgumentException e) { 893ef83299b99288c00b9d661260d19715e73e6889cMarc Blank } 894ef83299b99288c00b9d661260d19715e73e6889cMarc Blank try { 895ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv = msgX_D.toContentValues(); 896ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv.put(EmailContent.RECORD_ID, msgId++); 897ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.insert(Message.UPDATED_CONTENT_URI, cv); 898ef83299b99288c00b9d661260d19715e73e6889cMarc Blank } catch (IllegalArgumentException e) { 899ef83299b99288c00b9d661260d19715e73e6889cMarc Blank } 900ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 901ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // There should be 6 items in the deleted and updated tables 902ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(6, EmailContent.count(context, Message.UPDATED_CONTENT_URI, null, null)); 903ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(6, EmailContent.count(context, Message.DELETED_CONTENT_URI, null, null)); 904ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 905ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Delete the orphans 906ef83299b99288c00b9d661260d19715e73e6889cMarc Blank EmailProvider.deleteOrphans(EmailProvider.getReadableDatabase(context), 907ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message.DELETED_TABLE_NAME); 908ef83299b99288c00b9d661260d19715e73e6889cMarc Blank EmailProvider.deleteOrphans(EmailProvider.getReadableDatabase(context), 909ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message.UPDATED_TABLE_NAME); 910ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 911ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // There should now be 4 messages in each of the deleted and updated tables again 912ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(4, EmailContent.count(context, Message.UPDATED_CONTENT_URI, null, null)); 913ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(4, EmailContent.count(context, Message.DELETED_CONTENT_URI, null, null)); 914ef83299b99288c00b9d661260d19715e73e6889cMarc Blank } 915ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 916ef83299b99288c00b9d661260d19715e73e6889cMarc Blank /** 9177143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * Test delete mailbox 9187143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 9197143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public void testMailboxDelete() { 92028448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("mailbox-delete", true, mMockContext); 9217143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long account1Id = account1.mId; 92228448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 9237143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long box1Id = box1.mId; 92428448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Mailbox box2 = ProviderTestUtils.setupMailbox("box2", account1Id, true, mMockContext); 9257143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long box2Id = box2.mId; 926758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 9277143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler String selection = EmailContent.MailboxColumns.ACCOUNT_KEY + "=?"; 9287143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler String[] selArgs = new String[] { String.valueOf(account1Id) }; 9297143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 9307143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there are two mailboxes 9317143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler int numBoxes = EmailContent.count(mMockContext, Mailbox.CONTENT_URI, selection, selArgs); 9327143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(2, numBoxes); 9337143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 9347143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // now delete one of them 9357143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler Uri uri = ContentUris.withAppendedId(Mailbox.CONTENT_URI, box1Id); 9367143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 9377143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 9387143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there's only one mailbox now 9397143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler numBoxes = EmailContent.count(mMockContext, Mailbox.CONTENT_URI, selection, selArgs); 9407143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(1, numBoxes); 9417143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 9427143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // now delete the other one 9437143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler uri = ContentUris.withAppendedId(Mailbox.CONTENT_URI, box2Id); 9447143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 9457143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 9467143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there are no mailboxes now 9477143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler numBoxes = EmailContent.count(mMockContext, Mailbox.CONTENT_URI, selection, selArgs); 9487143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(0, numBoxes); 9497143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 950758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 9517143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 9527143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * Test delete message 9537143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: body 9547143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: attachments 9557143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 9567143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public void testMessageDelete() { 95728448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("message-delete", true, mMockContext); 9587143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long account1Id = account1.mId; 95928448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 9607143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long box1Id = box1.mId; 96128448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Message message1 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, false, 96228448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler true, mMockContext); 9637143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long message1Id = message1.mId; 96428448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Message message2 = ProviderTestUtils.setupMessage("message2", account1Id, box1Id, false, 96528448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler true, mMockContext); 9667143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long message2Id = message2.mId; 9677143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 9687143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler String selection = EmailContent.MessageColumns.ACCOUNT_KEY + "=? AND " + 9697143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler EmailContent.MessageColumns.MAILBOX_KEY + "=?"; 9707143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler String[] selArgs = new String[] { String.valueOf(account1Id), String.valueOf(box1Id) }; 9717143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 9727143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there are two messages 9737143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler int numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, selection, selArgs); 9747143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(2, numMessages); 9757143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 9767143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // now delete one of them 9777143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler Uri uri = ContentUris.withAppendedId(Message.CONTENT_URI, message1Id); 9787143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 9797143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 9807143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there's only one message now 9817143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, selection, selArgs); 9827143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(1, numMessages); 9837143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 9847143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // now delete the other one 9857143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler uri = ContentUris.withAppendedId(Message.CONTENT_URI, message2Id); 9867143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 9877143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 9887143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there are no messages now 9897143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, selection, selArgs); 9907143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(0, numMessages); 9917143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 992758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 9937143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 994ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler * Test delete synced message 995ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler * TODO: body 996ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler * TODO: attachments 997ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler */ 998ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler public void testSyncedMessageDelete() { 99928448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("synced-message-delete", true, 100028448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler mMockContext); 1001ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler long account1Id = account1.mId; 100228448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 1003ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler long box1Id = box1.mId; 100428448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Message message1 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, false, 100528448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler true, mMockContext); 1006ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler long message1Id = message1.mId; 100728448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Message message2 = ProviderTestUtils.setupMessage("message2", account1Id, box1Id, false, 100828448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler true, mMockContext); 1009ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler long message2Id = message2.mId; 1010ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1011ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler String selection = EmailContent.MessageColumns.ACCOUNT_KEY + "=? AND " 1012ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler + EmailContent.MessageColumns.MAILBOX_KEY + "=?"; 1013ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler String[] selArgs = new String[] { 1014ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler String.valueOf(account1Id), String.valueOf(box1Id) 1015ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler }; 1016ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1017ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // make sure there are two messages 1018ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler int numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, selection, selArgs); 1019ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(2, numMessages); 1020ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1021ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // make sure we start with no synced deletions 1022ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler numMessages = EmailContent.count(mMockContext, Message.DELETED_CONTENT_URI, selection, 1023ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler selArgs); 1024ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(0, numMessages); 1025ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1026ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // now delete one of them SYNCED 1027ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler Uri uri = ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, message1Id); 1028ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 1029ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1030ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // make sure there's only one message now 1031ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, selection, selArgs); 1032ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(1, numMessages); 1033ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1034ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // make sure there's one synced deletion now 1035ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler numMessages = EmailContent.count(mMockContext, Message.DELETED_CONTENT_URI, selection, 1036ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler selArgs); 1037ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(1, numMessages); 1038ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1039ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // now delete the other one NOT SYNCED 1040ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler uri = ContentUris.withAppendedId(Message.CONTENT_URI, message2Id); 1041ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 1042ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1043ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // make sure there are no messages now 1044ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, selection, selArgs); 1045ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(0, numMessages); 1046ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1047ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // make sure there's still one deletion now 1048ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler numMessages = EmailContent.count(mMockContext, Message.DELETED_CONTENT_URI, selection, 1049ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler selArgs); 1050ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(1, numMessages); 1051ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler } 1052ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1053ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler /** 1054ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler * Test message update 1055ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler * TODO: body 1056ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler * TODO: attachments 1057ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler */ 1058ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler public void testMessageUpdate() { 105928448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("message-update", true, mMockContext); 1060ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler long account1Id = account1.mId; 106128448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 1062ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler long box1Id = box1.mId; 106328448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Message message1 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, false, 106428448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler true, mMockContext); 1065ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler long message1Id = message1.mId; 106628448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Message message2 = ProviderTestUtils.setupMessage("message2", account1Id, box1Id, false, 106728448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler true, mMockContext); 1068ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler long message2Id = message2.mId; 1069ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler ContentResolver cr = mMockContext.getContentResolver(); 1070ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1071ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler String selection = EmailContent.MessageColumns.ACCOUNT_KEY + "=? AND " 1072ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler + EmailContent.MessageColumns.MAILBOX_KEY + "=?"; 1073ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler String[] selArgs = new String[] { 1074ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler String.valueOf(account1Id), String.valueOf(box1Id) 1075ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler }; 1076ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1077ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // make sure there are two messages 1078ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler int numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, selection, selArgs); 1079ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(2, numMessages); 1080ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1081ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // change the first one 1082ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler Uri uri = ContentUris.withAppendedId(Message.CONTENT_URI, message1Id); 1083ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler ContentValues cv = new ContentValues(); 1084ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler cv.put(MessageColumns.FROM_LIST, "from-list"); 1085ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler cr.update(uri, cv, null, null); 1086ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1087ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // make sure there's no updated message 1088ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler numMessages = EmailContent.count(mMockContext, Message.UPDATED_CONTENT_URI, selection, 1089ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler selArgs); 1090ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(0, numMessages); 1091ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1092ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // get the message back from the provider, make sure the change "stuck" 1093ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler Message restoredMessage = Message.restoreMessageWithId(mMockContext, message1Id); 1094ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals("from-list", restoredMessage.mFrom); 1095ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1096ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // change the second one 1097ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler uri = ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, message2Id); 1098ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler cv = new ContentValues(); 1099ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler cv.put(MessageColumns.FROM_LIST, "from-list"); 1100ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler cr.update(uri, cv, null, null); 1101ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1102ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // make sure there's one updated message 1103ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler numMessages = EmailContent.count(mMockContext, Message.UPDATED_CONTENT_URI, selection, 1104ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler selArgs); 1105ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(1, numMessages); 1106ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1107ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // get the message back from the provider, make sure the change "stuck", 1108ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // as before 1109ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler restoredMessage = Message.restoreMessageWithId(mMockContext, message2Id); 1110ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals("from-list", restoredMessage.mFrom); 1111ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1112ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // get the original message back from the provider 1113ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler Cursor c = cr.query(Message.UPDATED_CONTENT_URI, Message.CONTENT_PROJECTION, null, null, 1114ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler null); 1115ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler try { 1116ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertTrue(c.moveToFirst()); 1117ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler Message originalMessage = EmailContent.getContent(c, Message.class); 1118ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // make sure this has the original value 1119ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals("from message2", originalMessage.mFrom); 1120ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // Should only be one 1121ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertFalse(c.moveToNext()); 1122ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler } finally { 1123ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler c.close(); 1124ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler } 1125ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1126ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // delete the second message 1127ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler cr.delete(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, message2Id), null, null); 1128ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1129ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // hey, presto! the change should be gone 1130ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler numMessages = EmailContent.count(mMockContext, Message.UPDATED_CONTENT_URI, selection, 1131ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler selArgs); 1132ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(0, numMessages); 1133ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1134ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler // and there should now be a deleted record 1135ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler numMessages = EmailContent.count(mMockContext, Message.DELETED_CONTENT_URI, selection, 1136ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler selArgs); 1137ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler assertEquals(1, numMessages); 1138ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler } 1139ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler 1140ddc871d9eddd088c0200a30dbfeb24812a81cf80Andrew Stadler /** 11417143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: cascaded delete account 11427143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: hostauth 11437143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: body 11447143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: attachments 11457143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: create other account, mailbox & messages and confirm the right objects were deleted 11467143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 11477143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public void testCascadeDeleteAccount() { 114828448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("account-delete-cascade", true, 114928448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler mMockContext); 11507143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long account1Id = account1.mId; 115128448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 11527143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long box1Id = box1.mId; 115328448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler /* Message message1 = */ ProviderTestUtils.setupMessage("message1", account1Id, box1Id, 115428448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler false, true, mMockContext); 115528448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler /* Message message2 = */ ProviderTestUtils.setupMessage("message2", account1Id, box1Id, 115628448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler false, true, mMockContext); 11577143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 11587143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there is one account, one mailbox, and two messages 11597143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler int numAccounts = EmailContent.count(mMockContext, Account.CONTENT_URI, null, null); 11607143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(1, numAccounts); 11617143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler int numBoxes = EmailContent.count(mMockContext, Mailbox.CONTENT_URI, null, null); 11627143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(1, numBoxes); 11637143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler int numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, null, null); 11647143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(2, numMessages); 11657143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 11667143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // delete the account 11677143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler Uri uri = ContentUris.withAppendedId(Account.CONTENT_URI, account1Id); 11687143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 11697143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 11707143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // make sure there are no accounts, mailboxes, or messages 11717143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler numAccounts = EmailContent.count(mMockContext, Account.CONTENT_URI, null, null); 11727143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(0, numAccounts); 11737143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler numBoxes = EmailContent.count(mMockContext, Mailbox.CONTENT_URI, null, null); 11747143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(0, numBoxes); 11757143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, null, null); 11767143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(0, numMessages); 11777143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 1178758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 11797143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 11807143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * Test cascaded delete mailbox 11817143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: body 11827143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: attachments 11837143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler * TODO: create other mailbox & messages and confirm the right objects were deleted 11847143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 11857143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler public void testCascadeDeleteMailbox() { 118628448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("mailbox-delete-cascade", true, 118728448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler mMockContext); 11887143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long account1Id = account1.mId; 118928448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 11907143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler long box1Id = box1.mId; 1191ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message message1 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, 119228448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler false, true, mMockContext); 1193ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message message2 = ProviderTestUtils.setupMessage("message2", account1Id, box1Id, 1194ef83299b99288c00b9d661260d19715e73e6889cMarc Blank false, true, mMockContext); 1195ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message message3 = ProviderTestUtils.setupMessage("message3", account1Id, box1Id, 1196ef83299b99288c00b9d661260d19715e73e6889cMarc Blank false, true, mMockContext); 1197ef83299b99288c00b9d661260d19715e73e6889cMarc Blank Message message4 = ProviderTestUtils.setupMessage("message4", account1Id, box1Id, 119828448e782b825d1978c0923003a2cf91efe733dcAndrew Stadler false, true, mMockContext); 1199ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("message5", account1Id, box1Id, false, true, mMockContext); 1200ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ProviderTestUtils.setupMessage("message6", account1Id, box1Id, false, true, mMockContext); 12017143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 12027143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler String selection = EmailContent.MessageColumns.ACCOUNT_KEY + "=? AND " + 12037143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler EmailContent.MessageColumns.MAILBOX_KEY + "=?"; 12047143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler String[] selArgs = new String[] { String.valueOf(account1Id), String.valueOf(box1Id) }; 12057143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 12060e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // make sure there are six messages 12077143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler int numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, selection, selArgs); 1208ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(6, numMessages); 1209ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 1210ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ContentValues cv = new ContentValues(); 1211ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv.put(Message.SERVER_ID, "SERVER_ID"); 1212ef83299b99288c00b9d661260d19715e73e6889cMarc Blank ContentResolver resolver = mMockContext.getContentResolver(); 1213ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 1214ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Update two messages 1215ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.update(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, message1.mId), 1216ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv, null, null); 1217ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.update(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, message2.mId), 1218ef83299b99288c00b9d661260d19715e73e6889cMarc Blank cv, null, null); 1219ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // Delete two messages 1220ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.delete(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, message3.mId), 1221ef83299b99288c00b9d661260d19715e73e6889cMarc Blank null, null); 1222ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.delete(ContentUris.withAppendedId(Message.SYNCED_CONTENT_URI, message4.mId), 1223ef83299b99288c00b9d661260d19715e73e6889cMarc Blank null, null); 1224ef83299b99288c00b9d661260d19715e73e6889cMarc Blank 1225ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // There should now be two messages in updated/deleted, and 4 in messages 1226ef83299b99288c00b9d661260d19715e73e6889cMarc Blank numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, selection, selArgs); 1227ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(4, numMessages); 1228ef83299b99288c00b9d661260d19715e73e6889cMarc Blank numMessages = EmailContent.count(mMockContext, Message.DELETED_CONTENT_URI, selection, 1229ef83299b99288c00b9d661260d19715e73e6889cMarc Blank selArgs); 1230ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(2, numMessages); 1231ef83299b99288c00b9d661260d19715e73e6889cMarc Blank numMessages = EmailContent.count(mMockContext, Message.UPDATED_CONTENT_URI, selection, 1232ef83299b99288c00b9d661260d19715e73e6889cMarc Blank selArgs); 12337143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(2, numMessages); 1234758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 12357143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler // now delete the mailbox 12367143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler Uri uri = ContentUris.withAppendedId(Mailbox.CONTENT_URI, box1Id); 1237ef83299b99288c00b9d661260d19715e73e6889cMarc Blank resolver.delete(uri, null, null); 1238758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1239ef83299b99288c00b9d661260d19715e73e6889cMarc Blank // there should now be zero messages in all three tables 12407143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler numMessages = EmailContent.count(mMockContext, Message.CONTENT_URI, selection, selArgs); 12417143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler assertEquals(0, numMessages); 1242ef83299b99288c00b9d661260d19715e73e6889cMarc Blank numMessages = EmailContent.count(mMockContext, Message.DELETED_CONTENT_URI, selection, 1243ef83299b99288c00b9d661260d19715e73e6889cMarc Blank selArgs); 1244ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(0, numMessages); 1245ef83299b99288c00b9d661260d19715e73e6889cMarc Blank numMessages = EmailContent.count(mMockContext, Message.UPDATED_CONTENT_URI, selection, 1246ef83299b99288c00b9d661260d19715e73e6889cMarc Blank selArgs); 1247ef83299b99288c00b9d661260d19715e73e6889cMarc Blank assertEquals(0, numMessages); 12487143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler } 1249758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 12507143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler /** 12516c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler * Test cascaded delete message 12526c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler * Confirms that deleting a message will also delete its body & attachments 12537143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler */ 12546c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler public void testCascadeMessageDelete() { 12556c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Account account1 = ProviderTestUtils.setupAccount("message-cascade", true, mMockContext); 12566c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler long account1Id = account1.mId; 12576c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Mailbox box1 = ProviderTestUtils.setupMailbox("box1", account1Id, true, mMockContext); 12586c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler long box1Id = box1.mId; 1259bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki 12606c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // Each message has a body, and also give each 2 attachments 12616c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Message message1 = ProviderTestUtils.setupMessage("message1", account1Id, box1Id, true, 12626c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler false, mMockContext); 12636c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler ArrayList<Attachment> atts = new ArrayList<Attachment>(); 12646c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler for (int i = 0; i < 2; i++) { 12656c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler atts.add(ProviderTestUtils.setupAttachment( 12666c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler -1, expectedAttachmentNames[i], expectedAttachmentSizes[i], 12676c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler false, mMockContext)); 12686c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler } 12696c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler message1.mAttachments = atts; 12706c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler message1.save(mMockContext); 12716c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler long message1Id = message1.mId; 12726c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 12736c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Message message2 = ProviderTestUtils.setupMessage("message2", account1Id, box1Id, true, 12746c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler false, mMockContext); 12756c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler atts = new ArrayList<Attachment>(); 12766c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler for (int i = 0; i < 2; i++) { 12776c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler atts.add(ProviderTestUtils.setupAttachment( 12786c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler -1, expectedAttachmentNames[i], expectedAttachmentSizes[i], 12796c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler false, mMockContext)); 12806c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler } 12816c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler message2.mAttachments = atts; 12826c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler message2.save(mMockContext); 12836c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler long message2Id = message2.mId; 12846c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 12856c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // Set up to test total counts of bodies & attachments for our test messages 12866c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler String bodySelection = BodyColumns.MESSAGE_KEY + " IN (?,?)"; 12876c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler String attachmentSelection = AttachmentColumns.MESSAGE_KEY + " IN (?,?)"; 12886c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler String[] selArgs = new String[] { String.valueOf(message1Id), String.valueOf(message2Id) }; 1289bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki 12906c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // make sure there are two bodies 12916c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler int numBodies = EmailContent.count(mMockContext, Body.CONTENT_URI, bodySelection, selArgs); 12926c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler assertEquals(2, numBodies); 12936c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 12946c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // make sure there are four attachments 12956c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler int numAttachments = EmailContent.count(mMockContext, Attachment.CONTENT_URI, 12966c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler attachmentSelection, selArgs); 12976c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler assertEquals(4, numAttachments); 12986c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 12996c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // now delete one of the messages 13006c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Uri uri = ContentUris.withAppendedId(Message.CONTENT_URI, message1Id); 13016c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 13026c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 13036c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // there should be one body and two attachments 13046c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler numBodies = EmailContent.count(mMockContext, Body.CONTENT_URI, bodySelection, selArgs); 13056c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler assertEquals(1, numBodies); 13066c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 13076c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler numAttachments = EmailContent.count(mMockContext, Attachment.CONTENT_URI, 13086c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler attachmentSelection, selArgs); 13096c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler assertEquals(2, numAttachments); 13106c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 13116c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // now delete the other message 13126c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler uri = ContentUris.withAppendedId(Message.CONTENT_URI, message2Id); 13136c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 13146c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 13156c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // make sure there are no bodies or attachments 13166c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler numBodies = EmailContent.count(mMockContext, Body.CONTENT_URI, bodySelection, selArgs); 13176c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler assertEquals(0, numBodies); 13186c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 13196c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler numAttachments = EmailContent.count(mMockContext, Attachment.CONTENT_URI, 13206c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler attachmentSelection, selArgs); 13216c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler assertEquals(0, numAttachments); 13226c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler } 13237143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler 1324976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank /** 1325976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank * Test that our unique file name algorithm works as expected. Since this test requires an 1326976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank * SD card, we check the environment first, and return immediately if none is mounted. 1327976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank * @throws IOException 1328976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank */ 1329976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank public void testCreateUniqueFile() throws IOException { 1330976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank // Delete existing files, if they exist 1331976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank if (!Environment.getExternalStorageState().equals(Environment.MEDIA_MOUNTED)) { 1332976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank return; 1333976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } 1334976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank try { 1335976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank String fileName = "A11achm3n1.doc"; 1336976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank File uniqueFile = Attachment.createUniqueFile(fileName); 1337976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank assertEquals(fileName, uniqueFile.getName()); 1338976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank if (uniqueFile.createNewFile()) { 1339976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank uniqueFile = Attachment.createUniqueFile(fileName); 1340976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank assertEquals("A11achm3n1-2.doc", uniqueFile.getName()); 1341976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank if (uniqueFile.createNewFile()) { 1342976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank uniqueFile = Attachment.createUniqueFile(fileName); 1343976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank assertEquals("A11achm3n1-3.doc", uniqueFile.getName()); 1344976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } 1345976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } 1346976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank fileName = "A11achm3n1"; 1347976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank uniqueFile = Attachment.createUniqueFile(fileName); 1348976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank assertEquals(fileName, uniqueFile.getName()); 1349976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank if (uniqueFile.createNewFile()) { 1350976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank uniqueFile = Attachment.createUniqueFile(fileName); 1351976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank assertEquals("A11achm3n1-2", uniqueFile.getName()); 1352976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } 1353976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } finally { 1354976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank File directory = Environment.getExternalStorageDirectory(); 1355976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank // These are the files that should be created earlier in the test. Make sure 1356976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank // they are deleted for the next go-around 1357976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank String[] fileNames = new String[] {"A11achm3n1.doc", "A11achm3n1-2.doc", "A11achm3n1"}; 1358976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank int length = fileNames.length; 1359976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank for (int i = 0; i < length; i++) { 1360976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank File file = new File(directory, fileNames[i]); 1361976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank if (file.exists()) { 1362976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank file.delete(); 1363976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } 1364976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } 1365976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } 1366976f92908dd2f69f21f62690632ff24b08d9f5d3Marc Blank } 13674119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler 13684119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler /** 13694119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler * Test retrieving attachments by message ID (using EmailContent.Attachment.MESSAGE_ID_URI) 13704119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler */ 13714119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler public void testGetAttachmentByMessageIdUri() { 13724119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler 13734119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler // Note, we don't strictly need accounts, mailboxes or messages to run this test. 13744119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Attachment a1 = ProviderTestUtils.setupAttachment(1, "a1", 100, true, mMockContext); 13754119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Attachment a2 = ProviderTestUtils.setupAttachment(1, "a2", 200, true, mMockContext); 1376758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank ProviderTestUtils.setupAttachment(2, "a3", 300, true, mMockContext); 1377758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank ProviderTestUtils.setupAttachment(2, "a4", 400, true, mMockContext); 13784119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler 13794119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler // Now ask for the attachments of message id=1 13804119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler // Note: Using the "sort by size" trick to bring them back in expected order 13814119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Uri uri = ContentUris.withAppendedId(Attachment.MESSAGE_ID_URI, 1); 13824119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Cursor c = mMockContext.getContentResolver().query(uri, Attachment.CONTENT_PROJECTION, 13834119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler null, null, Attachment.SIZE); 13844119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler assertEquals(2, c.getCount()); 13854119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler 13864119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler try { 13874119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler c.moveToFirst(); 13884119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Attachment a1Get = EmailContent.getContent(c, Attachment.class); 13894119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler ProviderTestUtils.assertAttachmentEqual("getAttachByUri-1", a1, a1Get); 13904119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler c.moveToNext(); 13914119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler Attachment a2Get = EmailContent.getContent(c, Attachment.class); 13924119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler ProviderTestUtils.assertAttachmentEqual("getAttachByUri-2", a2, a2Get); 13934119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler } finally { 13944119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler c.close(); 13954119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler } 13964119218e2fd64341ac946fb8f2cbdb796a444cb8Andrew Stadler } 139754c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler 139854c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler /** 13996c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler * Test deleting attachments by message ID (using EmailContent.Attachment.MESSAGE_ID_URI) 14006c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler */ 14016c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler public void testDeleteAttachmentByMessageIdUri() { 14026c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler ContentResolver mockResolver = mMockContext.getContentResolver(); 14036c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 14046c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // Note, we don't strictly need accounts, mailboxes or messages to run this test. 14056c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler ProviderTestUtils.setupAttachment(1, "a1", 100, true, mMockContext); 14066c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler ProviderTestUtils.setupAttachment(1, "a2", 200, true, mMockContext); 14076c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Attachment a3 = ProviderTestUtils.setupAttachment(2, "a3", 300, true, mMockContext); 14086c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Attachment a4 = ProviderTestUtils.setupAttachment(2, "a4", 400, true, mMockContext); 14096c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 14106c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // Delete all attachments for message id=1 14116c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Uri uri = ContentUris.withAppendedId(Attachment.MESSAGE_ID_URI, 1); 14126c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler mockResolver.delete(uri, null, null); 14136c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 14146c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // Read back all attachments and confirm that we have the expected remaining attachments 14156c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler // (the attachments that are set for message id=2). Note order-by size to simplify test. 14166c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Cursor c = mockResolver.query(Attachment.CONTENT_URI, Attachment.CONTENT_PROJECTION, 14176c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler null, null, Attachment.SIZE); 14186c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler assertEquals(2, c.getCount()); 14196c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 14206c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler try { 14216c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler c.moveToFirst(); 14226c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Attachment a3Get = EmailContent.getContent(c, Attachment.class); 14236c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler ProviderTestUtils.assertAttachmentEqual("getAttachByUri-3", a3, a3Get); 14246c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler c.moveToNext(); 14256c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler Attachment a4Get = EmailContent.getContent(c, Attachment.class); 14266c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler ProviderTestUtils.assertAttachmentEqual("getAttachByUri-4", a4, a4Get); 14276c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler } finally { 14286c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler c.close(); 14296c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler } 14306c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler } 14316c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler 14326c21942ec45f561d711b3d74ecca8e62afb735c4Andrew Stadler /** 143354c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler * Tests of default account behavior 1434758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank * 143554c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler * 1. Simple set/get 143654c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler * 2. Moving default between 3 accounts 143754c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler * 3. Delete default, make sure another becomes default 143854c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler */ 143954c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler public void testSetGetDefaultAccount() { 144054c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler // There should be no default account if there are no accounts 144154c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler long defaultAccountId = Account.getDefaultAccountId(mMockContext); 144254c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler assertEquals(-1, defaultAccountId); 144354c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler 144454c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler Account account1 = ProviderTestUtils.setupAccount("account-default-1", true, mMockContext); 144554c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler long account1Id = account1.mId; 144654c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler Account account2 = ProviderTestUtils.setupAccount("account-default-2", true, mMockContext); 144754c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler long account2Id = account2.mId; 144854c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler Account account3 = ProviderTestUtils.setupAccount("account-default-3", true, mMockContext); 144954c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler long account3Id = account3.mId; 145054c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler 14519e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler // With three accounts, but none marked default, confirm that some default account 14529e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler // is returned. Which one is undefined here. 145354c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler defaultAccountId = Account.getDefaultAccountId(mMockContext); 14549e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler assertTrue(defaultAccountId == account1Id 14559e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler || defaultAccountId == account2Id 14569e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler || defaultAccountId == account3Id); 145754c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler 14589e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler updateIsDefault(account1, true); 145954c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler defaultAccountId = Account.getDefaultAccountId(mMockContext); 14609e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler assertEquals(account1Id, defaultAccountId); 146154c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler 1462531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank updateIsDefault(account2, true); 1463531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank defaultAccountId = Account.getDefaultAccountId(mMockContext); 1464531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank assertEquals(account2Id, defaultAccountId); 1465531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank 1466531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank updateIsDefault(account3, true); 1467531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank defaultAccountId = Account.getDefaultAccountId(mMockContext); 1468531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank assertEquals(account3Id, defaultAccountId); 146954c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler 147054c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler // Now delete a non-default account and confirm no change 147154c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler Uri uri = ContentUris.withAppendedId(Account.CONTENT_URI, account1Id); 147254c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 147354c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler 1474531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank defaultAccountId = Account.getDefaultAccountId(mMockContext); 1475531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank assertEquals(account3Id, defaultAccountId); 147654c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler 147754c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler // Now confirm deleting the default account and it switches to another one 147854c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler uri = ContentUris.withAppendedId(Account.CONTENT_URI, account3Id); 147954c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 148054c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler 1481531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank defaultAccountId = Account.getDefaultAccountId(mMockContext); 1482531ae9d25f4310e4774e136ed74ed9749f940861Marc Blank assertEquals(account2Id, defaultAccountId); 1483758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 14849e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler // Now delete the final account and confirm there are no default accounts again 14859e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler uri = ContentUris.withAppendedId(Account.CONTENT_URI, account2Id); 14869e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler mMockContext.getContentResolver().delete(uri, null, null); 14879e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler 148854c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler defaultAccountId = Account.getDefaultAccountId(mMockContext); 14899e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler assertEquals(-1, defaultAccountId); 149054c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler } 149154c1f2bf9a6574240b7c9af253f83a2b566442abAndrew Stadler 14929e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler private void updateIsDefault(Account account, boolean newState) { 14939e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler account.setDefaultAccount(newState); 14949e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler ContentValues cv = new ContentValues(); 14959e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler cv.put(AccountColumns.IS_DEFAULT, account.mIsDefault); 14969e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler account.update(mMockContext, cv); 14979e2c6bd5f21f2d19eef7ebfe30e6fdf94ede0857Andrew Stadler } 1498758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1499758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank public static Message setupUnreadMessage(String name, long accountId, long mailboxId, 1500758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank boolean addBody, boolean saveIt, Context context) { 1501758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank Message msg = 1502758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank ProviderTestUtils.setupMessage(name, accountId, mailboxId, addBody, false, context); 1503758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank msg.mFlagRead = false; 1504758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank if (saveIt) { 1505758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank msg.save(context); 1506758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank } 1507758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank return msg; 1508758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank } 1509758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1510758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank public void testUnreadCountTriggers() { 1511758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank // Start with one account and three mailboxes 1512758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank Account account = ProviderTestUtils.setupAccount("triggers", true, mMockContext); 1513758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank Mailbox boxA = ProviderTestUtils.setupMailbox("boxA", account.mId, true, mMockContext); 1514758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank Mailbox boxB = ProviderTestUtils.setupMailbox("boxB", account.mId, true, mMockContext); 1515758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank Mailbox boxC = ProviderTestUtils.setupMailbox("boxC", account.mId, true, mMockContext); 1516758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1517758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank // Make sure there are no unreads 1518758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(0, getUnreadCount(boxA.mId)); 1519758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(0, getUnreadCount(boxB.mId)); 1520758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(0, getUnreadCount(boxC.mId)); 1521758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1522758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank // Create 4 unread messages (only 3 named) in boxA 1523758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank Message message1 = setupUnreadMessage("message1", account.mId, boxA.mId, 1524758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank false, true, mMockContext); 1525758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank Message message2= setupUnreadMessage("message2", account.mId, boxA.mId, 1526758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank false, true, mMockContext); 1527758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank Message message3 = setupUnreadMessage("message3", account.mId, boxA.mId, 1528758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank false, true, mMockContext); 1529758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank setupUnreadMessage("message4", account.mId, boxC.mId, false, true, mMockContext); 1530758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1531758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank // Make sure the unreads are where we expect them 1532758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(3, getUnreadCount(boxA.mId)); 1533758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(0, getUnreadCount(boxB.mId)); 1534758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(1, getUnreadCount(boxC.mId)); 1535758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1536758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank // After deleting message 1, the count in box A should be decremented (to 2) 1537758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank ContentResolver cr = mMockContext.getContentResolver(); 1538758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank Uri uri = ContentUris.withAppendedId(Message.CONTENT_URI, message1.mId); 1539758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cr.delete(uri, null, null); 1540758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(2, getUnreadCount(boxA.mId)); 1541758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(0, getUnreadCount(boxB.mId)); 1542758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(1, getUnreadCount(boxC.mId)); 1543758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1544758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank // Move message 2 to box B, leaving 1 in box A and 1 in box B 1545758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank message2.mMailboxKey = boxB.mId; 1546758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank ContentValues cv = new ContentValues(); 1547758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cv.put(MessageColumns.MAILBOX_KEY, boxB.mId); 1548758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cr.update(ContentUris.withAppendedId(Message.CONTENT_URI, message2.mId), cv, null, null); 1549758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(1, getUnreadCount(boxA.mId)); 1550758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(1, getUnreadCount(boxB.mId)); 1551758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(1, getUnreadCount(boxC.mId)); 1552758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1553758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank // Mark message 3 (from box A) read, leaving 0 in box A 1554758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cv.clear(); 1555758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cv.put(MessageColumns.FLAG_READ, 1); 1556758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cr.update(ContentUris.withAppendedId(Message.CONTENT_URI, message3.mId), cv, null, null); 1557758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(0, getUnreadCount(boxA.mId)); 1558758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(1, getUnreadCount(boxB.mId)); 1559758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(1, getUnreadCount(boxC.mId)); 1560758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1561758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank // Move message 3 to box C; should be no change (it's read) 1562758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank message3.mMailboxKey = boxC.mId; 1563758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cv.clear(); 1564758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cv.put(MessageColumns.MAILBOX_KEY, boxC.mId); 1565758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cr.update(ContentUris.withAppendedId(Message.CONTENT_URI, message3.mId), cv, null, null); 1566758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(0, getUnreadCount(boxA.mId)); 1567758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(1, getUnreadCount(boxB.mId)); 1568758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(1, getUnreadCount(boxC.mId)); 1569758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank 1570758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank // Mark message 3 unread; it's now in box C, so that box's count should go up to 3 1571758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cv.clear(); 1572758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cv.put(MessageColumns.FLAG_READ, 0); 1573758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank cr.update(ContentUris.withAppendedId(Message.CONTENT_URI, message3.mId), cv, null, null); 1574758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(0, getUnreadCount(boxA.mId)); 1575758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(1, getUnreadCount(boxB.mId)); 1576758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank assertEquals(2, getUnreadCount(boxC.mId)); 1577758a532fce2f672673d38b2daa5f67eb757b118bMarc Blank } 15789627d014e16235eadf981b9165807dc72a14a383Mihai Preda 15799627d014e16235eadf981b9165807dc72a14a383Mihai Preda /** 15809627d014e16235eadf981b9165807dc72a14a383Mihai Preda * Test for EmailProvider.createIndex(). 15819627d014e16235eadf981b9165807dc72a14a383Mihai Preda * Check that it returns exacly the same string as the one used previously for index creation. 15829627d014e16235eadf981b9165807dc72a14a383Mihai Preda */ 15839627d014e16235eadf981b9165807dc72a14a383Mihai Preda public void testCreateIndex() { 15849627d014e16235eadf981b9165807dc72a14a383Mihai Preda String oldStr = "create index message_" + MessageColumns.TIMESTAMP 15859627d014e16235eadf981b9165807dc72a14a383Mihai Preda + " on " + Message.TABLE_NAME + " (" + MessageColumns.TIMESTAMP + ");"; 15869627d014e16235eadf981b9165807dc72a14a383Mihai Preda String newStr = EmailProvider.createIndex(Message.TABLE_NAME, MessageColumns.TIMESTAMP); 15879627d014e16235eadf981b9165807dc72a14a383Mihai Preda assertEquals(newStr, oldStr); 15889627d014e16235eadf981b9165807dc72a14a383Mihai Preda } 1589c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank 1590c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank public void testIdAddToField() { 1591c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank ContentResolver cr = mMockContext.getContentResolver(); 1592c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank ContentValues cv = new ContentValues(); 1593c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank 1594c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank // Try changing the newMessageCount of an account 1595c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank Account account = ProviderTestUtils.setupAccount("field-add", true, mMockContext); 1596c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank int startCount = account.mNewMessageCount; 1597c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank // "field" and "add" are the two required elements 1598c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank cv.put(EmailContent.FIELD_COLUMN_NAME, AccountColumns.NEW_MESSAGE_COUNT); 1599c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank cv.put(EmailContent.ADD_COLUMN_NAME, 17); 1600c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank cr.update(ContentUris.withAppendedId(Account.ADD_TO_FIELD_URI, account.mId), 1601c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank cv, null, null); 1602c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank Account restoredAccount = Account.restoreAccountWithId(mMockContext, account.mId); 1603c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank assertEquals(17 + startCount, restoredAccount.mNewMessageCount); 1604c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank cv.put(EmailContent.ADD_COLUMN_NAME, -11); 1605c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank cr.update(ContentUris.withAppendedId(Account.ADD_TO_FIELD_URI, account.mId), 1606c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank cv, null, null); 1607c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank restoredAccount = Account.restoreAccountWithId(mMockContext, account.mId); 1608c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank assertEquals(17 - 11 + startCount, restoredAccount.mNewMessageCount); 1609c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank 1610c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank // Now try with a mailbox 1611c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank Mailbox boxA = ProviderTestUtils.setupMailbox("boxA", account.mId, true, mMockContext); 1612c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank assertEquals(0, boxA.mUnreadCount); 1613c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank cv.put(EmailContent.FIELD_COLUMN_NAME, MailboxColumns.UNREAD_COUNT); 1614c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank cv.put(EmailContent.ADD_COLUMN_NAME, 11); 1615c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank cr.update(ContentUris.withAppendedId(Mailbox.ADD_TO_FIELD_URI, boxA.mId), cv, null, null); 1616c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank Mailbox restoredBoxA = Mailbox.restoreMailboxWithId(mMockContext, boxA.mId); 1617c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank assertEquals(11, restoredBoxA.mUnreadCount); 1618c0c9c33322deecace00a32766e0a1b355aad4b31Marc Blank } 16190e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16200e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank public void testDatabaseCorruptionRecovery() { 16210e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank final ContentResolver resolver = mMockContext.getContentResolver(); 16220e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank final Context context = mMockContext; 16230e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16240e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Create account and two mailboxes 16250e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank Account acct = ProviderTestUtils.setupAccount("acct1", true, context); 16260e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank Mailbox box1 = ProviderTestUtils.setupMailbox("box1", acct.mId, true, context); 16270e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16280e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Create 4 messages in box1 with bodies 16290e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank ProviderTestUtils.setupMessage("message1", acct.mId, box1.mId, true, true, context); 16300e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank ProviderTestUtils.setupMessage("message2", acct.mId, box1.mId, true, true, context); 16310e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank ProviderTestUtils.setupMessage("message3", acct.mId, box1.mId, true, true, context); 16320e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank ProviderTestUtils.setupMessage("message4", acct.mId, box1.mId, true, true, context); 16330e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16340e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Confirm there are four messages 16350e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank int count = EmailContent.count(mMockContext, Message.CONTENT_URI, null, null); 16360e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertEquals(4, count); 16370e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Confirm there are four bodies 16380e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank count = EmailContent.count(mMockContext, Body.CONTENT_URI, null, null); 16390e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertEquals(4, count); 16400e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16410e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Find the EmailProvider.db file 16420e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank File dbFile = mMockContext.getDatabasePath(EmailProvider.DATABASE_NAME); 16430e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // The EmailProvider.db database should exist (the provider creates it automatically) 16440e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertTrue(dbFile != null); 16450e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertTrue(dbFile.exists()); 16460e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Delete it, and confirm it is gone 16470e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertTrue(dbFile.delete()); 16480e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertFalse(dbFile.exists()); 16490e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16500e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Find the EmailProviderBody.db file 16510e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank dbFile = mMockContext.getDatabasePath(EmailProvider.BODY_DATABASE_NAME); 16520e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // The EmailProviderBody.db database should still exist 16530e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertTrue(dbFile != null); 16540e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertTrue(dbFile.exists()); 16550e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16560e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // URI to uncache the databases 16570e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // This simulates the Provider starting up again (otherwise, it will still be pointing to 16580e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // the already opened files) 16590e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Note that we only have access to the EmailProvider via the ContentResolver; therefore, 16600e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // we cannot directly call into the provider and use a URI for this 16610e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank resolver.update(EmailProvider.INTEGRITY_CHECK_URI, null, null, null); 16620e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16630e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // TODO We should check for the deletion of attachment files once this is implemented in 16640e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // the provider 1665bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki 16660e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Explanation for what happens below... 16670e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // The next time the database is created by the provider, it will notice that there's 16680e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // already a EmailProviderBody.db file. In this case, it will delete that database to 16690e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // ensure that both are in sync (and empty) 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 16750e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Confirm there are no messages 16760e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank count = EmailContent.count(mMockContext, Message.CONTENT_URI, null, null); 16770e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertEquals(0, count); 16780e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank } 16790e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16800e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank public void testBodyDatabaseCorruptionRecovery() { 16810e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank final ContentResolver resolver = mMockContext.getContentResolver(); 16820e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank final Context context = mMockContext; 16830e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16840e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Create account and two mailboxes 16850e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank Account acct = ProviderTestUtils.setupAccount("acct1", true, context); 16860e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank Mailbox box1 = ProviderTestUtils.setupMailbox("box1", acct.mId, true, context); 16870e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16880e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Create 4 messages in box1 with bodies 16890e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank ProviderTestUtils.setupMessage("message1", acct.mId, box1.mId, true, true, context); 16900e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank ProviderTestUtils.setupMessage("message2", acct.mId, box1.mId, true, true, context); 16910e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank ProviderTestUtils.setupMessage("message3", acct.mId, box1.mId, true, true, context); 16920e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank ProviderTestUtils.setupMessage("message4", acct.mId, box1.mId, true, true, context); 16930e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 16940e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Confirm there are four messages 16950e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank int count = EmailContent.count(mMockContext, Message.CONTENT_URI, null, null); 16960e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertEquals(4, count); 16970e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Confirm there are four bodies 16980e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank count = EmailContent.count(mMockContext, Body.CONTENT_URI, null, null); 16990e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertEquals(4, count); 17000e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 17010e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Find the EmailProviderBody.db file 17020e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank File dbFile = mMockContext.getDatabasePath(EmailProvider.BODY_DATABASE_NAME); 17030e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // The EmailProviderBody.db database should exist (the provider creates it automatically) 17040e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertTrue(dbFile != null); 17050e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertTrue(dbFile.exists()); 17060e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Delete it, and confirm it is gone 17070e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertTrue(dbFile.delete()); 17080e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertFalse(dbFile.exists()); 17090e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 17100e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Find the EmailProvider.db file 17110e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank dbFile = mMockContext.getDatabasePath(EmailProvider.DATABASE_NAME); 17120e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // The EmailProviderBody.db database should still exist 17130e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertTrue(dbFile != null); 17140e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertTrue(dbFile.exists()); 17150e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 17160e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // URI to uncache the databases 17170e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // This simulates the Provider starting up again (otherwise, it will still be pointing to 17180e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // the already opened files) 17190e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Note that we only have access to the EmailProvider via the ContentResolver; therefore, 17200e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // we cannot directly call into the provider and use a URI for this 17210e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank resolver.update(EmailProvider.INTEGRITY_CHECK_URI, null, null, null); 17220e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 17230e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // TODO We should check for the deletion of attachment files once this is implemented in 17240e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // the provider 17250e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 17260e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Explanation for what happens below... 17270e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // The next time the body database is created by the provider, it will notice that there's 17280e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // already a populated EmailProvider.db file. In this case, it will delete that database to 17290e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // ensure that both are in sync (and empty) 17300e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 17310e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Confirm there are no messages 17320e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank count = EmailContent.count(mMockContext, Message.CONTENT_URI, null, null); 17330e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertEquals(0, count); 17340e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank 17350e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank // Confirm there are no bodies 17360e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank count = EmailContent.count(mMockContext, Body.CONTENT_URI, null, null); 17370e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank assertEquals(0, count); 17380e1595c177e40428b267a8696dfc05d015ce6a2fMarc Blank } 1739694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank 1740694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank public void testFindMailboxOfType() { 1741694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank final Context context = mMockContext; 1742694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank 1743694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank // Create two accounts and a variety of mailbox types 1744694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Account acct1 = ProviderTestUtils.setupAccount("acct1", true, context); 1745694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct1Inbox = 1746694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.setupMailbox("Inbox1", acct1.mId, true, context, Mailbox.TYPE_INBOX); 1747694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct1Calendar 1748694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank = ProviderTestUtils.setupMailbox("Cal1", acct1.mId, true, context, Mailbox.TYPE_CALENDAR); 1749694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct1Contacts = 1750694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.setupMailbox("Con1", acct1.mId, true, context, Mailbox.TYPE_CONTACTS); 1751694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Account acct2 = ProviderTestUtils.setupAccount("acct1", true, context); 1752694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct2Inbox = 1753694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.setupMailbox("Inbox2", acct2.mId, true, context, Mailbox.TYPE_INBOX); 1754694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct2Calendar = 1755694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.setupMailbox("Cal2", acct2.mId, true, context, Mailbox.TYPE_CALENDAR); 1756694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct2Contacts = 1757694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.setupMailbox("Con2", acct2.mId, true, context, Mailbox.TYPE_CONTACTS); 1758694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank 1759694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank // Check that we can find them by type 1760694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank assertEquals(acct1Inbox.mId, 1761694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.findMailboxOfType(context, acct1.mId, Mailbox.TYPE_INBOX)); 1762694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank assertEquals(acct2Inbox.mId, 1763694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.findMailboxOfType(context, acct2.mId, Mailbox.TYPE_INBOX)); 1764694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank assertEquals(acct1Calendar.mId, 1765694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.findMailboxOfType(context, acct1.mId, Mailbox.TYPE_CALENDAR)); 1766694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank assertEquals(acct2Calendar.mId, 1767694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.findMailboxOfType(context, acct2.mId, Mailbox.TYPE_CALENDAR)); 1768694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank assertEquals(acct1Contacts.mId, 1769694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.findMailboxOfType(context, acct1.mId, Mailbox.TYPE_CONTACTS)); 1770694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank assertEquals(acct2Contacts.mId, 1771694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.findMailboxOfType(context, acct2.mId, Mailbox.TYPE_CONTACTS)); 1772694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank } 1773694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank 1774694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank public void testRestoreMailboxOfType() { 1775694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank final Context context = mMockContext; 1776694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank 1777694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank // Create two accounts and a variety of mailbox types 1778694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Account acct1 = ProviderTestUtils.setupAccount("acct1", true, context); 1779694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct1Inbox = 1780694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.setupMailbox("Inbox1", acct1.mId, true, context, Mailbox.TYPE_INBOX); 1781694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct1Calendar 1782694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank = ProviderTestUtils.setupMailbox("Cal1", acct1.mId, true, context, Mailbox.TYPE_CALENDAR); 1783694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct1Contacts = 1784694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.setupMailbox("Con1", acct1.mId, true, context, Mailbox.TYPE_CONTACTS); 1785694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Account acct2 = ProviderTestUtils.setupAccount("acct1", true, context); 1786694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct2Inbox = 1787694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.setupMailbox("Inbox2", acct2.mId, true, context, Mailbox.TYPE_INBOX); 1788694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct2Calendar = 1789694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.setupMailbox("Cal2", acct2.mId, true, context, Mailbox.TYPE_CALENDAR); 1790694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox acct2Contacts = 1791694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.setupMailbox("Con2", acct2.mId, true, context, Mailbox.TYPE_CONTACTS); 1792694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank 1793694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank // Check that we can find them by type 1794694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.assertMailboxEqual("testRestoreMailboxOfType", acct1Inbox, 1795694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.restoreMailboxOfType(context, acct1.mId, Mailbox.TYPE_INBOX)); 1796694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.assertMailboxEqual("testRestoreMailboxOfType", acct2Inbox, 1797694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.restoreMailboxOfType(context, acct2.mId, Mailbox.TYPE_INBOX)); 1798694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.assertMailboxEqual("testRestoreMailboxOfType", acct1Calendar, 1799694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.restoreMailboxOfType(context, acct1.mId, Mailbox.TYPE_CALENDAR)); 1800694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.assertMailboxEqual("testRestoreMailboxOfType", acct2Calendar, 1801694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.restoreMailboxOfType(context, acct2.mId, Mailbox.TYPE_CALENDAR)); 1802694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.assertMailboxEqual("testRestoreMailboxOfType", acct1Contacts, 1803694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.restoreMailboxOfType(context, acct1.mId, Mailbox.TYPE_CONTACTS)); 1804694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank ProviderTestUtils.assertMailboxEqual("testRestoreMailboxOfType", acct2Contacts, 1805694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank Mailbox.restoreMailboxOfType(context, acct2.mId, Mailbox.TYPE_CONTACTS)); 1806694257cb7e7a191b3314cb209b6c38a8a07583efMarc Blank } 1807bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki 1808bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki public void testAccountIsSecurityHold() { 1809bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki final Context context = mMockContext; 1810bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki Account acct1 = ProviderTestUtils.setupAccount("acct1", true, context); 1811bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki 1812bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki Account acct2 = ProviderTestUtils.setupAccount("acct2", false, context); 1813bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki acct2.mFlags |= Account.FLAGS_SECURITY_HOLD; 1814bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki acct2.save(context); 1815bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki 1816bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki assertFalse(Account.isSecurityHold(context, acct1.mId)); 1817bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki assertTrue(Account.isSecurityHold(context, acct2.mId)); 1818bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki assertFalse(Account.isSecurityHold(context, 9999999)); // No such account 1819bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki } 1820bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki 1821bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki public void testClearAccountHoldFlags() { 1822bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki Account a1 = ProviderTestUtils.setupAccount("holdflag-1", false, mMockContext); 1823bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki a1.mFlags = Account.FLAGS_NOTIFY_NEW_MAIL; 1824bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki a1.save(mMockContext); 1825bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki Account a2 = ProviderTestUtils.setupAccount("holdflag-2", false, mMockContext); 1826bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki a2.mFlags = Account.FLAGS_VIBRATE_ALWAYS | Account.FLAGS_SECURITY_HOLD; 1827bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki a2.save(mMockContext); 1828bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki 1829bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki // bulk clear 1830bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki Account.clearSecurityHoldOnAllAccounts(mMockContext); 1831bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki 1832bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki // confirm new values as expected - no hold flags; other flags unmolested 1833bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki Account a1a = Account.restoreAccountWithId(mMockContext, a1.mId); 1834bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki assertEquals(Account.FLAGS_NOTIFY_NEW_MAIL, a1a.mFlags); 1835bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki Account a2a = Account.restoreAccountWithId(mMockContext, a2.mId); 1836bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki assertEquals(Account.FLAGS_VIBRATE_ALWAYS, a2a.mFlags); 1837bcf32320e2600e96c8a9e997a8903bfc3893b35eMakoto Onuki } 1838574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1839574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki /** 1840574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki * @return the number of messages in a mailbox. 1841574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki */ 1842574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki private int getMessageCount(long mailboxId) { 1843574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki Mailbox b = Mailbox.restoreMailboxWithId(mMockContext, mailboxId); 1844574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki return b.mMessageCount; 1845574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki } 1846574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1847574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki /** Set -1 to the message count of all mailboxes for the recalculateMessageCount test. */ 1848574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki private void setMinusOneToMessageCounts() { 1849574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki ContentValues values = new ContentValues(); 1850574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki values.put(MailboxColumns.MESSAGE_COUNT, -1); 1851574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 18525b0c2c7f344e72915ac63ff45cf3d65885373a39Makoto Onuki // EmailProvider.update() doesn't allow updating messageCount, so directly use the DB. 18535b0c2c7f344e72915ac63ff45cf3d65885373a39Makoto Onuki SQLiteDatabase db = getProvider().getDatabase(mMockContext); 18545b0c2c7f344e72915ac63ff45cf3d65885373a39Makoto Onuki db.update(Mailbox.TABLE_NAME, values, null, null); 1855574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki } 1856574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1857574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki /** 1858833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki * Test for the message count triggers (insert/delete/move mailbox), and also 1859574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki * {@link EmailProvider#recalculateMessageCount}. 1860833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki * 1861833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki * It also covers: 1862833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki * - {@link Mailbox#getMessageCountByMailboxType(Context, int)} 1863833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki * - {@link Mailbox#getUnreadCountByMailboxType(Context, int)} 1864833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki * - {@link Message#getFavoriteMessageCount(Context)} 1865574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki */ 1866574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki public void testMessageCount() { 1867574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki final Context c = mMockContext; 1868574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1869574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki // Create 2 accounts 1870574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki Account a1 = ProviderTestUtils.setupAccount("holdflag-1", true, c); 1871574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki Account a2 = ProviderTestUtils.setupAccount("holdflag-2", true, c); 1872574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1873574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki // Create 2 mailboxes for each account 1874833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki Mailbox b1 = ProviderTestUtils.setupMailbox("box1", a1.mId, true, c, Mailbox.TYPE_INBOX); 1875833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki Mailbox b2 = ProviderTestUtils.setupMailbox("box2", a1.mId, true, c, Mailbox.TYPE_OUTBOX); 1876833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki Mailbox b3 = ProviderTestUtils.setupMailbox("box3", a2.mId, true, c, Mailbox.TYPE_INBOX); 1877833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki Mailbox b4 = ProviderTestUtils.setupMailbox("box4", a2.mId, true, c, Mailbox.TYPE_OUTBOX); 1878574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1879574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki // 0. Check the initial values, just in case. 1880574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1881574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(0, getMessageCount(b1.mId)); 1882574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(0, getMessageCount(b2.mId)); 1883574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(0, getMessageCount(b3.mId)); 1884574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(0, getMessageCount(b4.mId)); 1885574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1886833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki assertEquals(0, Message.getFavoriteMessageCount(c)); 1887833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki assertEquals(0, Mailbox.getUnreadCountByMailboxType(c, Mailbox.TYPE_INBOX)); 1888833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki assertEquals(0, Mailbox.getUnreadCountByMailboxType(c, Mailbox.TYPE_OUTBOX)); 1889833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki assertEquals(0, Mailbox.getMessageCountByMailboxType(c, Mailbox.TYPE_INBOX)); 1890833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki assertEquals(0, Mailbox.getMessageCountByMailboxType(c, Mailbox.TYPE_OUTBOX)); 1891833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki 1892574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki // 1. Test for insert triggers. 1893574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1894574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki // Create some messages 1895833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki // b1: 1 message 1896833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki Message m11 = createMessage(c, b1, true, false); 1897574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1898833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki // b2: 2 message 1899833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki Message m21 = createMessage(c, b2, false, false); 1900833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki Message m22 = createMessage(c, b2, true, true); 1901574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1902833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki // b3: 3 message 1903833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki Message m31 = createMessage(c, b3, false, false); 1904833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki Message m32 = createMessage(c, b3, false, false); 1905833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki Message m33 = createMessage(c, b3, true, true); 1906574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1907574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki // b4 has no messages. 1908574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1909574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki // Check message counts 1910574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(1, getMessageCount(b1.mId)); 1911574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(2, getMessageCount(b2.mId)); 1912574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(3, getMessageCount(b3.mId)); 1913574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(0, getMessageCount(b4.mId)); 1914574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1915833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki // Check the simple counting methods. 1916833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki assertEquals(3, Message.getFavoriteMessageCount(c)); 1917833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki assertEquals(3, Mailbox.getUnreadCountByMailboxType(c, Mailbox.TYPE_INBOX)); 1918833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki assertEquals(1, Mailbox.getUnreadCountByMailboxType(c, Mailbox.TYPE_OUTBOX)); 1919833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki assertEquals(4, Mailbox.getMessageCountByMailboxType(c, Mailbox.TYPE_INBOX)); 1920833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki assertEquals(2, Mailbox.getMessageCountByMailboxType(c, Mailbox.TYPE_OUTBOX)); 1921833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki 1922574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki // 2. test for recalculateMessageCount. 1923574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1924574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki // First, invalidate the message counts. 1925574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki setMinusOneToMessageCounts(); 1926574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(-1, getMessageCount(b1.mId)); 1927574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(-1, getMessageCount(b2.mId)); 1928574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(-1, getMessageCount(b3.mId)); 1929574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(-1, getMessageCount(b4.mId)); 1930574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1931574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki // Batch update. 1932574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki SQLiteDatabase db = getProvider().getDatabase(mMockContext); 1933574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki EmailProvider.recalculateMessageCount(db); 1934574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1935574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki // Check message counts 1936574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(1, getMessageCount(b1.mId)); 1937574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(2, getMessageCount(b2.mId)); 1938574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(3, getMessageCount(b3.mId)); 1939574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(0, getMessageCount(b4.mId)); 1940574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1941574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki // 3. Check the "move mailbox" trigger. 1942574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1943574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki // Move m32 (in mailbox 3) to mailbox 4. 1944574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki ContentValues values = new ContentValues(); 1945574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki values.put(MessageColumns.MAILBOX_KEY, b4.mId); 1946574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1947574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki getProvider().update(Message.CONTENT_URI, values, EmailContent.ID_SELECTION, 1948574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki new String[] {"" + m32.mId}); 1949574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1950574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki // Check message counts 1951574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(1, getMessageCount(b1.mId)); 1952574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(2, getMessageCount(b2.mId)); 1953574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(2, getMessageCount(b3.mId)); 1954574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(1, getMessageCount(b4.mId)); 1955574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1956574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki // 4. Check the delete trigger. 1957574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1958574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki // Delete m11 (in mailbox 1) 1959574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki getProvider().delete(Message.CONTENT_URI, EmailContent.ID_SELECTION, 1960574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki new String[] {"" + m11.mId}); 1961574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki // Delete m21 (in mailbox 2) 1962574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki getProvider().delete(Message.CONTENT_URI, EmailContent.ID_SELECTION, 1963574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki new String[] {"" + m21.mId}); 1964574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki 1965574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki // Check message counts 1966574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(0, getMessageCount(b1.mId)); 1967574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(1, getMessageCount(b2.mId)); 1968574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(2, getMessageCount(b3.mId)); 1969574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki assertEquals(1, getMessageCount(b4.mId)); 1970574854b528163f3bf1a7cb974aa80082d1768edfMakoto Onuki } 1971833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki 1972833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki private static Message createMessage(Context c, Mailbox b, boolean starred, boolean read) { 1973833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki return ProviderTestUtils.setupMessage("1", b.mAccountKey, b.mId, true, true, c, starred, 1974833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki read); 1975833fe73b99e62ad9cf6e80c782717c7de1ff12e4Makoto Onuki } 19766d8bfa67c438ee18921d13d8bfba876aacaa9ff6Makoto Onuki 19775247ab8cae802272b1e29e81d3b31a1c4e710da5Makoto Onuki public void testAccountIsEasAccount() { 19786d8bfa67c438ee18921d13d8bfba876aacaa9ff6Makoto Onuki Account account = new Account(); 197925144e2b7990c50bb3650faf1aec341837c05348Makoto Onuki // No hostauth 19805247ab8cae802272b1e29e81d3b31a1c4e710da5Makoto Onuki assertFalse(account.isEasAccount(mMockContext)); 19816d8bfa67c438ee18921d13d8bfba876aacaa9ff6Makoto Onuki 198225144e2b7990c50bb3650faf1aec341837c05348Makoto Onuki checkAccountIsEasAccount(null, false); 198325144e2b7990c50bb3650faf1aec341837c05348Makoto Onuki checkAccountIsEasAccount("", false); 198425144e2b7990c50bb3650faf1aec341837c05348Makoto Onuki checkAccountIsEasAccount("x", false); 198525144e2b7990c50bb3650faf1aec341837c05348Makoto Onuki checkAccountIsEasAccount("eas", true); 198625144e2b7990c50bb3650faf1aec341837c05348Makoto Onuki } 19876d8bfa67c438ee18921d13d8bfba876aacaa9ff6Makoto Onuki 198825144e2b7990c50bb3650faf1aec341837c05348Makoto Onuki private void checkAccountIsEasAccount(String protocol, boolean expected) { 198925144e2b7990c50bb3650faf1aec341837c05348Makoto Onuki Account account = ProviderTestUtils.setupAccount("account", false, mMockContext); 199025144e2b7990c50bb3650faf1aec341837c05348Makoto Onuki account.mHostAuthRecv = ProviderTestUtils.setupHostAuth(protocol, "account-hostauth-recv", 199125144e2b7990c50bb3650faf1aec341837c05348Makoto Onuki account.mId, false, mMockContext); 199225144e2b7990c50bb3650faf1aec341837c05348Makoto Onuki account.save(mMockContext); 199325144e2b7990c50bb3650faf1aec341837c05348Makoto Onuki assertEquals(expected, account.isEasAccount(mMockContext)); 19946d8bfa67c438ee18921d13d8bfba876aacaa9ff6Makoto Onuki } 1995bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank 1996bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank public void testGetKeyColumnLong() { 1997bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank final Context c = mMockContext; 1998bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank Account a = ProviderTestUtils.setupAccount("acct", true, c); 1999bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank Mailbox b1 = ProviderTestUtils.setupMailbox("box1", a.mId, true, c, Mailbox.TYPE_MAIL); 2000bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank Mailbox b2 = ProviderTestUtils.setupMailbox("box2", a.mId, true, c, Mailbox.TYPE_MAIL); 2001bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank Message m1 = createMessage(c, b1, false, false); 2002bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank Message m2 = createMessage(c, b2, false, false); 2003bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank assertEquals(a.mId, Message.getKeyColumnLong(c, m1.mId, MessageColumns.ACCOUNT_KEY)); 2004bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank assertEquals(a.mId, Message.getKeyColumnLong(c, m2.mId, MessageColumns.ACCOUNT_KEY)); 2005bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank assertEquals(b1.mId, Message.getKeyColumnLong(c, m1.mId, MessageColumns.MAILBOX_KEY)); 2006bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank assertEquals(b2.mId, Message.getKeyColumnLong(c, m2.mId, MessageColumns.MAILBOX_KEY)); 2007bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank } 2008bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank 2009bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank public void testGetAccountMailboxFromMessageId() { 2010bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank final Context c = mMockContext; 2011bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank Account a = ProviderTestUtils.setupAccount("acct", true, c); 2012bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank Mailbox b1 = ProviderTestUtils.setupMailbox("box1", a.mId, true, c, Mailbox.TYPE_MAIL); 2013bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank Mailbox b2 = ProviderTestUtils.setupMailbox("box2", a.mId, true, c, Mailbox.TYPE_MAIL); 2014bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank Message m1 = createMessage(c, b1, false, false); 2015bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank Message m2 = createMessage(c, b2, false, false); 2016bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank ProviderTestUtils.assertAccountEqual("x", a, Account.getAccountForMessageId(c, m1.mId)); 2017bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank ProviderTestUtils.assertAccountEqual("x", a, Account.getAccountForMessageId(c, m2.mId)); 2018bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank // Restore the mailboxes, since the unread & total counts will have changed 2019bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank b1 = Mailbox.restoreMailboxWithId(c, b1.mId); 2020bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank b2 = Mailbox.restoreMailboxWithId(c, b2.mId); 2021bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank ProviderTestUtils.assertMailboxEqual("x", b1, Mailbox.getMailboxForMessageId(c, m1.mId)); 2022bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank ProviderTestUtils.assertMailboxEqual("x", b2, Mailbox.getMailboxForMessageId(c, m2.mId)); 2023bca4e6e70b53ca7db0ac14522f0d26a7b465cf24Marc Blank } 2024e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki 2025e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki public void testGetAccountGetInboxIdTest() { 2026e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki final Context c = mMockContext; 2027e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki 2028e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki // Prepare some data with red-herrings. 2029e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki Account a1 = ProviderTestUtils.setupAccount("acct1", true, c); 2030e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki Account a2 = ProviderTestUtils.setupAccount("acct2", true, c); 2031e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki Mailbox b1i = ProviderTestUtils.setupMailbox("b1i", a1.mId, true, c, Mailbox.TYPE_INBOX); 2032e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki Mailbox b2a = ProviderTestUtils.setupMailbox("b2a", a2.mId, true, c, Mailbox.TYPE_MAIL); 2033e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki Mailbox b2i = ProviderTestUtils.setupMailbox("b2b", a2.mId, true, c, Mailbox.TYPE_INBOX); 2034e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki 2035e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki assertEquals(b2i.mId, Account.getInboxId(c, a2.mId)); 2036e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki } 2037e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki 2038a25aa613f79a94d0dea395234ba383de63d03727Makoto Onuki public void testGetMailboxType() { 2039a25aa613f79a94d0dea395234ba383de63d03727Makoto Onuki final Context c = mMockContext; 2040a25aa613f79a94d0dea395234ba383de63d03727Makoto Onuki 2041a25aa613f79a94d0dea395234ba383de63d03727Makoto Onuki Account a = ProviderTestUtils.setupAccount("acct1", true, c); 2042a25aa613f79a94d0dea395234ba383de63d03727Makoto Onuki Mailbox bi = ProviderTestUtils.setupMailbox("b1", a.mId, true, c, Mailbox.TYPE_INBOX); 2043a25aa613f79a94d0dea395234ba383de63d03727Makoto Onuki Mailbox bm = ProviderTestUtils.setupMailbox("b1", a.mId, true, c, Mailbox.TYPE_MAIL); 2044a25aa613f79a94d0dea395234ba383de63d03727Makoto Onuki 2045a25aa613f79a94d0dea395234ba383de63d03727Makoto Onuki assertEquals(Mailbox.TYPE_INBOX, Mailbox.getMailboxType(c, bi.mId)); 2046a25aa613f79a94d0dea395234ba383de63d03727Makoto Onuki assertEquals(Mailbox.TYPE_MAIL, Mailbox.getMailboxType(c, bm.mId)); 2047a25aa613f79a94d0dea395234ba383de63d03727Makoto Onuki assertEquals(-1, Mailbox.getMailboxType(c, 999999)); // mailbox not found 2048a25aa613f79a94d0dea395234ba383de63d03727Makoto Onuki } 2049a25aa613f79a94d0dea395234ba383de63d03727Makoto Onuki 2050e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki public void testMailboxIsRefreshable() { 2051e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki final Context c = mMockContext; 2052e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki 2053e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki Account a = ProviderTestUtils.setupAccount("acct1", true, c); 2054e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki Mailbox bi = ProviderTestUtils.setupMailbox("b1", a.mId, true, c, Mailbox.TYPE_INBOX); 2055e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki Mailbox bm = ProviderTestUtils.setupMailbox("b1", a.mId, true, c, Mailbox.TYPE_MAIL); 2056e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki Mailbox bd = ProviderTestUtils.setupMailbox("b1", a.mId, true, c, Mailbox.TYPE_DRAFTS); 2057e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki Mailbox bo = ProviderTestUtils.setupMailbox("b1", a.mId, true, c, Mailbox.TYPE_OUTBOX); 2058e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki 2059e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki assertTrue(Mailbox.isRefreshable(c, bi.mId)); 2060e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki assertTrue(Mailbox.isRefreshable(c, bm.mId)); 2061e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki assertFalse(Mailbox.isRefreshable(c, bd.mId)); 2062e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki assertFalse(Mailbox.isRefreshable(c, bo.mId)); 2063e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki 2064e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki // No such mailbox 2065a25aa613f79a94d0dea395234ba383de63d03727Makoto Onuki assertFalse(Mailbox.isRefreshable(c, 9999999)); 2066e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki 2067e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki // Magic mailboxes can't be refreshed. 2068e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki assertFalse(Mailbox.isRefreshable(c, Mailbox.QUERY_ALL_DRAFTS)); 2069e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki assertFalse(Mailbox.isRefreshable(c, Mailbox.QUERY_ALL_INBOXES)); 2070e357f5879187124c7af5c2ece5d7d3e4f60f07d2Makoto Onuki } 2071767f9fe2ebcca7eee20f2a048f33a96ad4bf53daMakoto Onuki 2072767f9fe2ebcca7eee20f2a048f33a96ad4bf53daMakoto Onuki public void testMailboxCanMoveFrom() { 2073767f9fe2ebcca7eee20f2a048f33a96ad4bf53daMakoto Onuki final Context c = mMockContext; 2074767f9fe2ebcca7eee20f2a048f33a96ad4bf53daMakoto Onuki 2075767f9fe2ebcca7eee20f2a048f33a96ad4bf53daMakoto Onuki Account a = ProviderTestUtils.setupAccount("acct1", true, c); 2076767f9fe2ebcca7eee20f2a048f33a96ad4bf53daMakoto Onuki Mailbox bi = ProviderTestUtils.setupMailbox("b1", a.mId, true, c, Mailbox.TYPE_INBOX); 2077767f9fe2ebcca7eee20f2a048f33a96ad4bf53daMakoto Onuki Mailbox bm = ProviderTestUtils.setupMailbox("b1", a.mId, true, c, Mailbox.TYPE_MAIL); 2078767f9fe2ebcca7eee20f2a048f33a96ad4bf53daMakoto Onuki Mailbox bd = ProviderTestUtils.setupMailbox("b1", a.mId, true, c, Mailbox.TYPE_DRAFTS); 2079767f9fe2ebcca7eee20f2a048f33a96ad4bf53daMakoto Onuki Mailbox bo = ProviderTestUtils.setupMailbox("b1", a.mId, true, c, Mailbox.TYPE_OUTBOX); 2080767f9fe2ebcca7eee20f2a048f33a96ad4bf53daMakoto Onuki 2081767f9fe2ebcca7eee20f2a048f33a96ad4bf53daMakoto Onuki assertTrue(Mailbox.canMoveFrom(c, bi.mId)); 2082767f9fe2ebcca7eee20f2a048f33a96ad4bf53daMakoto Onuki assertTrue(Mailbox.canMoveFrom(c, bm.mId)); 2083767f9fe2ebcca7eee20f2a048f33a96ad4bf53daMakoto Onuki assertFalse(Mailbox.canMoveFrom(c, bd.mId)); 2084767f9fe2ebcca7eee20f2a048f33a96ad4bf53daMakoto Onuki assertFalse(Mailbox.canMoveFrom(c, bo.mId)); 2085767f9fe2ebcca7eee20f2a048f33a96ad4bf53daMakoto Onuki } 20867143d969dde180b7a44bdc42ade6ca2878d0760dAndrew Stadler} 2087