66304f698f561779bd820dfda3b6a12c423270bc |
|
02-Sep-2017 |
Fyodor Kupolov <fkupolov@google.com> |
Close idle connections to release RAM Close idle connections after 30s of inactivity to release RAM. Savings: ~1MB on marlin, 0.5MB on low-ram devices Bug: 63398887 Test: reboot and dumpsys meminfo com.android.phone Change-Id: I38256e224ee090f1be0e26b2c5e8451743ca8c96
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
c1f7e0a116f7d3a20992e50a8e803eca6803370f |
|
01-Aug-2017 |
fionaxu <fionaxu@google.com> |
remove the extra slash from insert uri withAppendedPath API adds extra slash before appending, there is no need to add it twice. Bug: 64161300 Test: runtest --path tests/src/com/android/providers/telephony/SmsProviderTest.java --test-method testInsertUri Change-Id: Ie7e1e1532c1e666752a5513abd345fb3d5816145
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
893040f464b0745029628f001ecee06064b314b5 |
|
24-Jan-2017 |
fionaxu <fionaxu@google.com> |
add display_originating_address in the mms raw db Bug: 34118154 Test: Manual Change-Id: I0f90e84de4c6b8cba7aeaa50173b621a21e54c83
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
50c4f841ac13c66fdfe32bba4b08e839f265d742 |
|
08-Nov-2016 |
Amit Mahajan <amitmahajan@google.com> |
Handle exception upgrading to db version 65 gracefully. Test: Upgrade build on a device from nyc-mr1-dev to master. Bug: 32547917 Change-Id: If970c33fb160bff68dc28082b5b137803cf5ae07
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
13c051e23637a774e42438738fbc06f64163ebeb |
|
14-Apr-2016 |
Amit Mahajan <amitmahajan@google.com> |
Merge "Add message_body to raw table when it is created." into nyc-dev am: 6f820c1 * commit '6f820c1197900afd524589d0a9cd5f7b31193452': Add message_body to raw table when it is created. Change-Id: Ib7d4dc46c868d191b023ffcaf91e1eb924dc7aad
|
c5ef99ee0e490e65816472e0dd826f2c1e2a0961 |
|
14-Apr-2016 |
Amit Mahajan <amitmahajan@google.com> |
Add message_body to raw table when it is created. Earlier CL handled only the upgrade code path. Bug: 28183891 Change-Id: I92f5843b260953ca1ee1f90f5d52e1037220faf6
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
bf9c60f1f5dbd4050cec7ddde0721bea2b0145bd |
|
13-Apr-2016 |
Amit Mahajan <amitmahajan@google.com> |
Change to fix build failure. 2 copies of 'case 63' got introduced due to merges from aosp and nyc-dev. Bug: 27974596 Change-Id: I0ca74a8c87eca31059466be2d030845febc7f3f2
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
6215a4f6b109479dd0e746bdb32fb17697ea921d |
|
13-Apr-2016 |
Amit Mahajan <amitmahajan@google.com> |
Merge "Add message_body column to raw table." into nyc-dev am: 36379ef * commit '36379ef4d2ae21eb68914f7dc3ef3fea9dfb7f52': Add message_body column to raw table. Change-Id: I2b63428e5f8e8578406fd30b03e5f9e7128dd732
|
5fc743c1b57541afad447dc3baa31ae6bed61471 |
|
05-Apr-2016 |
Amit Mahajan <amitmahajan@google.com> |
Add message_body column to raw table. Use this column in addition to other fields to compare if messages are the same. Bug: 27974596 Change-Id: Ibe3b556aaf8e7918acec493e9dac36fdf86a9728
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
70948658ebf1184fabd03bbaee634561e12a5c47 |
|
30-Mar-2016 |
Amit Mahajan <amitmahajan@google.com> |
resolve merge conflicts of 9dbdf2d to nyc-dev-plus-aosp Change-Id: Ifc64b039c995b89b858054d20a0b7f5af3e00168
|
86bbb17d2b263ba7426443c98c7fdfe7afd37134 |
|
28-Mar-2016 |
Amit Mahajan <amitmahajan@google.com> |
Adding DELETED column to SMS raw table to support message de-duping. Bug: 27820591 Change-Id: I72466d7e3fbd224dc16e5dbb6351c48d99c6d96d
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
ef070df1fdec048cf21a9a597c263364de2b5ee0 |
|
09-Mar-2016 |
Paul Lawrence <paullawrence@google.com> |
Add API to IMountService to get encryption state am: 9be1ca3903 * commit '9be1ca39036f5d73c6cba344d1c1703383562512': Add API to IMountService to get encryption state
|
9be1ca39036f5d73c6cba344d1c1703383562512 |
|
08-Mar-2016 |
Paul Lawrence <paullawrence@google.com> |
Add API to IMountService to get encryption state Bug: 18002358 Change-Id: I178766e871900a8650c61fda190c3ba7efb30f25
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
c2bd355a1ebb364c76576c81fb19a1d5e5a7b2a5 |
|
06-Oct-2015 |
Snild Dolkow <snild.dolkow@sonymobile.com> |
Speed up MmsSmsDatabaseHelper thread updates As the database grew, the updateAllThreads() method took way too long. Overarching changes: * Rename to updateThreads() -- "all" is technically untrue. * Changed everything to bulk queries, instead of looping over all matches, to reduce overhead. * Turn updateThread() into an updateThreads() call with a very specific selection. * Use DISTINCT to reduce duplicates in the subqueries of the delete (as was already done in updateAllThreads, but not updateThread). * Used a WITH clause for the date/snippet update. The subquery is unfortunately still run thrice, but code deduplication, yay! * Moved subquery WHERE clauses for the date/snippet update inwards, to allow for proper utilization of indices. * Speed up the date/snippet subqueries with a (thread_id, date) index. * Simplified the error update by using the EXISTS operator. * Changed the error update from three queries (calculate-read-update) into just one. * Formatted the new queries the way *I* like them. :) This can be easily benchmarked from the shell on userdebug: (but you'll need a fix in appops to make it accept the "root" package) adb root adb shell appops set root READ_SMS allow adb shell appops set root WRITE_SMS allow adb shell time content delete --uri content://mms-sms/conversations/ --where "0=1" This, of course, deletes nothing (still, don't risk your data!), but it does trigger a call to updateAllThreads(db, null, null). My benchmark: 1000 threads with 1 sms each, 1 thread with 2000 sms. Before: 0m59.09s real 0m0.26s user 0m0.19s system After: 0m00.75s real 0m0.23s user 0m0.09s system Note that most of the "after" time is process-launch and communication overhead -- setting db.log.slow_query_threshold to 0 and summing up the queries tells us that we're now spending less than 150 ms on SQL. Change-Id: I379f6712c2d569226dbeedac2ef2df9e49d42ec7
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
0b59ce424fca21bc1141ba5a1a9d2aaba42b6408 |
|
19-Feb-2016 |
Ji Yang <yangji@google.com> |
Update MMS parts(attachment files) path after db upgrade. BUG: 27198048 Change-Id: I35a6f40146ea5b3a2000df2399fe73b178b47e7b
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
5a3194d943854ec3c2ec5df18a95a5b04ab5efa1 |
|
28-Jan-2016 |
Ji Yang <yangji@google.com> |
Move all sms tables except raw into credential encrypted storage. BUG: 26232405 Change-Id: I478528ed8eea5013c79263d469b50ada44f647bd
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
8fcbd4e96706b21873b7bdd62fc6cbf46a2b830f |
|
26-Jan-2016 |
Ji Yang <yangji@google.com> |
Revert "Move all sms tables except raw into credential encrypted storage." This reverts commit 8f3ad6fe306155ffe87d6d0860db2e2c238d158d. Change-Id: I1c1ca585fdeeed6cf34f1f682b42ea74d3127993
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
8f3ad6fe306155ffe87d6d0860db2e2c238d158d |
|
13-Jan-2016 |
Ji Yang <yangji@google.com> |
Move all sms tables except raw into credential encrypted storage. All other tables already live inside the device encrypted storage because of the application level setting in the manifest file. Bug: 26232405 Change-Id: I7c7fd3da823b13285e3b5c75dd0c0290b476f8b9
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
5c890027f5a76a560f8ac4f3723e2c5479dc3755 |
|
04-Sep-2015 |
Snild Dolkow <snild.dolkow@sonymobile.com> |
Avoid expression tree depth error in removeUnferencedAddresses() With more than 1000 referenced canonical addresses, the expression tree will be too deep for the default sqlite setting of 1000. This causes the delete to fail, bringing with it the whole transaction. It looks something like this: E SQLiteLog: (1) Expression tree is too large (maximum depth 1000) E MmsSmsDatabaseHelper: Expression tree is too large (maximum depth 1000) (code 1): , while compiling: DELETE FROM canonical_addresses WHERE _id != 1158 AND _id != 1650 AND _id != 1459 AND _id != 1021 AND _id != 1701 AND _id != 1973 AND _id != 1124 AND _id != 1720 AND _id != 1494 AND _id != 1282 AND _id != 1042 AND _id != 1312 AND _id != 1781 AND _id != 1525 AND _id != 1262 AND _id != 1265 AND so on... Using NOT IN avoids the depth problem (and is marginally prettier). Change-Id: I8d39a3ee7ad30948d0179adb75d579e01a0eb749
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
72f135589e5d705bcac4a3db3019e4d9d2d04d36 |
|
10-Mar-2015 |
Ye Wen <ywen@google.com> |
Restricted view of SMS/MMS providers (2/2) Only expose sent/received SMS/MMS and non-wap push MMS messages for non-default SMS apps, preventing non-default SMS apps to interfere internal states of default SMS app, like stealing wap push to download or sending outbox message. b/19348537 Change-Id: Icec639a01ab8f5cd2d1346b76418ec487979295a
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
a42e4178285fb7811f4b5d71c1c947a1725e42f2 |
|
10-Dec-2014 |
Wink Saville <wink@google.com> |
Fix long lines associated with INVALID_SUBSCRIPTION_ID. Bug: 18668873 Change-Id: Ie709a62bbb74e0a767daeb9e3fb3aecd4c45df44
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
72b147363200ff3f0bc467f23579042bd800ff13 |
|
20-Nov-2014 |
Wink Saville <wink@google.com> |
Additional changes to SubscriptionManager API as per API council. bug: 17575308 Change-Id: Idd98aa46c15a9219ccf28091c62602ac8bf16c62
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
3fdec6f0bce8bcbec7c6685a43a32e1a1425e2bf |
|
20-Nov-2014 |
Wink Saville <wink@google.com> |
Revert "Additional changes to SubscriptionManager API as per API council." This reverts commit 4879328fea0c08af22f34163141ee9a1a72923fe. Change-Id: I06a10d96b48e8fcfcf076a119570e3d957e52a37
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
4879328fea0c08af22f34163141ee9a1a72923fe |
|
15-Nov-2014 |
Wink Saville <wink@google.com> |
Additional changes to SubscriptionManager API as per API council. bug: 17575308 Change-Id: I7773965094510999bfce8fc6b2b31ba6ce496653
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
a58acf3093d4bd46593ca16180a52285dde82c73 |
|
18-Sep-2014 |
Shri Borde <shri@google.com> |
Use INVALID_SUB_ID as default value for sub_id columns Change-Id: I1908f263d8403a3abe600e28aaa5171748e8c309
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
82fc72b94a54eb3c70bcfbb1effd9b3a9b775af9 |
|
29-Jul-2014 |
Ye Wen <ywen@google.com> |
Move archived column from pdu/sms to threads (3/4) Add new update logic to change threads' archived column value Change-Id: I24cb9b163471c1daebb767aff342fe588b8cf249
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
49776410646ba3eb7aef3ec34871a38aa69441c4 |
|
10-Jul-2014 |
Ye Wen <ywen@google.com> |
New SMS and MMS APIs and semantics (3/4) New SMS and MMS database columns: archived and creator b/14095333 Change-Id: I4d79014c12ac622b098c1b7892134ce842f70f83
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
8b6ec7667b9174188116d0ef6a5d2af22e0cb85a |
|
12-Jul-2014 |
Colin Cross <ccross@google.com> |
Revert "New SMS and MMS APIs and semantics (3/4)" This reverts commit 955261609370cfae1083974d3c815edfa3453a77. Change-Id: I2f509217e0904359a8c37630f783097729d09709
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
955261609370cfae1083974d3c815edfa3453a77 |
|
10-Jul-2014 |
Ye Wen <ywen@google.com> |
New SMS and MMS APIs and semantics (3/4) New SMS and MMS database columns: archived and creator b/14095333 Change-Id: I6e7a91aa3a6371b621982083419341939d95e610
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
cfb8bbdc3932473966d043fbd72b6c067933f2c1 |
|
17-Jun-2014 |
Ye Wen <ywen@google.com> |
Add SUB_ID columns for SmsProvider and MmsProvider b/15673719 Change-Id: I0f3d6c3bfaead109edef283ac45d7e5f8c3220b4
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
15156cd6afcc7ed57ac7be40ef2d32a615e83599 |
|
15-Nov-2012 |
Tom Taylor <tomtaylor@google.com> |
App crashed as it was moving to foreground and message was received Bug 7540115 In the MmsSmsProvider, wrap the code that creates a new thread in a transaction. Creating a new thread requires multiple database operations. It's possible for the newly created thread to be deleted part of the way through the operation. Change-Id: I3cbf8ba4ad3f3f30b513280ac3defc276b4a70a0
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
1a45ce5c6e417fee13c55221a97c3d36b4bea846 |
|
17-Oct-2012 |
Tom Taylor <tomtaylor@google.com> |
Empty draft created on deleting a group MMS message Bug 7360609 Cleanup pdu table on db upgrade to remove all rows with a NULL threadId. An earlier change made sure we only inserted rows with a valid threadId or with 0. A NULL threadId in the pdu table causes deleting a thread to fail. Change-Id: I38824aa879fed80fe2385633c46d3c7eab0ae3b8
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
842e3110ccca88661d06c733b56ead009f90b988 |
|
27-Sep-2012 |
Tom Taylor <tomtaylor@google.com> |
SMS delete behavior odd Bug 7175606 Wrap the delete operations in a transaction. Change-Id: I6b07a83f2dbac6e2bdb4da872863708aac27f5bc
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
49c9ede3206cf2b9504cb9d06deeea8fd856900c |
|
09-Sep-2012 |
Tom Taylor <tomtaylor@google.com> |
Old thumbnail shown Bug 6602473 Don't reuse part and pdu ids because their uri's are used as keys for the pdu and thumbnail caches. Change the part and pdu tables to use AUTOINCREMENT keys. When copying over a table to a temp table, dropping the original, and renaming the temp to the original, all triggers associated with the original table are dropped. Those triggers have to be recreated. The changes look more extensive than they really are. There were many mms-related triggers in createCommonTriggers() that had to be moved to CreateMmsTriggers(). I used a diff tool to compare the schema dumps from the database before and after to verify the tables and triggers are the same (and used that same tool in the first place to identify those missing triggers). Change-Id: I92a100db7479e28f3c1d62ff6adab961c5871113
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
f88d1d6733158144e9e0c87f29b446068edf0507 |
|
07-Sep-2012 |
Tom Taylor <tomtaylor@google.com> |
Group MMS flickers between white square and received message when initially checking Bug 7113015 Add a new column in the pdu that keeps track of whether a message is text-only. The UI can use that flag to decide whether to show the attachment box or not. Change-Id: I158dd07d415f24f0200c81f39de6feac03f37f8b
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
10a8c9b23ac380d728ecc839d753e26d9b21015a |
|
05-Jun-2012 |
Tom Taylor <tomtaylor@google.com> |
Crash on deleting messaging thread Bug 6609647 Change-Id: I6cce1746238cb02b112340298adfd23896c39b3f
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
4b14c35e9e44d5df2b5340141f2b24bab351c603 |
|
02-Jun-2012 |
Tom Taylor <tomtaylor@google.com> |
Thread can't be deleted Bug 6593778 Delete all the messages in a thread and the thread comes back. If you get a row in the pdu or sms table with an empty thread_id, the query to delete threads that aren't referenced by any message fails. The query has to weed out messages with no thread_ids. Change-Id: I2a2121a27a4d4ce9ed02b8415dc50b0a59623d94
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
f409b0e23a37080c3b8c501671c4ea436a1e6346 |
|
19-Dec-2011 |
Tom Taylor <tomtaylor@google.com> |
Deleting a thread will mess up a multi-recipient thread with the same recipient Bug 5763490 The previous DB query for deleting unreferenced recipient id's didn't work on threads addressed to multiple recipients because the recipient id's are stored as a space-separated list of ids in a single column. With this change, the work for identifying unreferenced recipient id's is done in java, rather than in an sqlite3 selection statement. Change-Id: Id6ad32408a67dc7550b32ce8ab095635c324a799
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
09710cec4926bcd3708376face04507e661bcc02 |
|
07-Dec-2011 |
Tom Taylor <tomtaylor@google.com> |
Message received with wrong sender Bug 5622048 If the last message of a thread is deleted which results in the very last recipient in the canonical_addresses table getting deleted, and the messaging app is still running, and a new message arrives for an address the messaging app has never seen before, then the new message will appear to have been sent from the recently deleted recipient. The recipient id cache in the app doesn't know the recipient was deleted and its cache it out of date. The fix is to never reuse recipient ids by setting the _id on the canonical_addresses table to AUTOINCREMENT. Change-Id: Ia3618fb906e09b3a305ac778b8d73983586fa938
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
3ce9cb8e04c821453dd7731b30309d508017f89c |
|
28-Sep-2011 |
Tom Taylor <tomtaylor@google.com> |
Delete unreferenced phone numbers Bug 5375782. Bug 5172594 The canonical_addresses table in mmssms.db is used to keep a reference between recipientIds and phone numbers/email addresses. The threads table contains references to these recipient ids. When a thread is deleted, the recipients are orphaned. With this change, whenever a thread is deleted, we delete unreferenced numbers. Change-Id: I7e1b7a11317d2e6662fab3f434239fe21ca313ec
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
527fcced9fe9cf8525e33ffb098fd28650af24af |
|
22-Sep-2011 |
Tom Taylor <tomtaylor@google.com> |
Fix a number of draft-related bugs Remove the triggers that delete threads when there are no sms or pdu entries referring to those threads. These triggers end up killing a thread while we're saving drafts. Bug 5354900 among others. Change-Id: I85879ad8ae819a5262fbaaed325b2e3a4b2b3e7d
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
10faf3f5f0c16a812c25f02d208715fabc556a7d |
|
27-Apr-2011 |
Tom Taylor <tomtaylor@google.com> |
Make upgrading to AUTO INCREMENT more robust If the upgrade fails, turn on a receiver that listens for storage ok. When there's more storage try the upgrade again. Tested the normal upgrade path with 10,000 threads. Tested the upgrade path with 10,000 threads and low memory. Left the test code in, but turned off. Change-Id: Ia273428af4e7f0160414ef49b4d18998c25725b4
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
1ab4800f1598cae72846ae4d24d6c545a5965d97 |
|
19-Apr-2011 |
Tom Taylor <tomtaylor@google.com> |
Auto-increment the thread_id The thread_id is the row_id of the Mms provider's threads table. Threads are created and deleted as various drafts come and go. Bugs in the past have been linked to using the wrong thread. One issue was the result of not clearing the app's thread cache when a thread was deleted. To help avoid these sorts of problems, the thread_id is now an autoincrement key. The threads table will never reuse a thread_id. A new thread will always have a thread_id one greater than the max ever seen in the table. The upgrade to add the AUTOINCREMENT keyword is only executed after the other db upgrades have run. Change-Id: Iaed04bc02af504d4132ff3f5cf9b732ebf9eaf47
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
ea5c40c18a83bd984da79ecda301bd5a7cd9daa1 |
|
18-Nov-2010 |
Fredrik Roubert <roubert@google.com> |
Add the field date_sent to keep track of the date a message was sent. Change-Id: If3dcfe7d3c86454f67dbdd432e54e94ad56c1c67
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
0ebbb48f9f83ad65d738d1910a38e4fbdb920ac7 |
|
13-May-2010 |
Jeff Hamilton <jham@android.com> |
Stop using private APIs that are going away. Change-Id: I2e6ac42f577041aec889fa41c9d923b0f4657957
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
a882662df39eb5af84cc386fc09df4636166f48f |
|
31-Mar-2010 |
Wei Huang <weih@google.com> |
bug #2553905: handle upgrading the "seen" column in sms/mms db better. - when upgrading the sms and pdu tables from Donut, we add a new column called "seen". That's used to compute the statusbar notifications. "seen=0" means we need to throw up a notification. The bug is that we were adding the "seen" column with value=0, which makes the MMS app notify for all messages that are in the SMS/MMS database after the upgrade. Obviously that's no good. So, add some logic in the upgrade code to set the 'seen' value the same as the 'read' value for each message in the table. That will made the app notify only the unread messages. Change-Id: I1bb5a10c84d165c5fb463628b35c4c49ed36f1d3
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
8a4060ec0c2433ceeb619a3a35fba5aabedbc1c6 |
|
23-Mar-2010 |
Tom Taylor <tomtaylor@google.com> |
Revert "Add metadata column" This reverts commit fc0eb2f2905477c7200eb54584d2c104cd6d1adb. Conflicts: src/com/android/providers/telephony/MmsSmsDatabaseHelper.java Change-Id: Ic0dd4a602763ef643539f14c3a78afaed2b328fe
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
1e47c4888938f8abbe581707b8762d49c12b9b7a |
|
13-Mar-2010 |
Tom Taylor <tomtaylor@google.com> |
Fix thread not read One of the triggers for setting a thread's "read" status wasn't narrowing its search for message types that can be read. As a result, an unread "deliver ind" in the pdu that isn't displayed to the user caused the thread table's "read" column to be set to 0. The other triggers, such as message_count, only count the pdu messages the user can see. Update this particular trigger the same way. Bug 2511065 Change-Id: I259717f9692fe68fd15ab7cb1583bc109e93e5f7
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
fc0eb2f2905477c7200eb54584d2c104cd6d1adb |
|
12-Mar-2010 |
Tom Taylor <tomtaylor@google.com> |
Add metadata column Add a new column to sms and pdu tables. Change-Id: Ib489d3d4bcdade3dbbd787fee472bc78e1562504
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
b1bae65bf18dc22762cf7b8210fdad836b3e4ee5 |
|
09-Mar-2010 |
Tom Taylor <tomtaylor@google.com> |
Remove mms-common lib Refer to mms in its old location in the framework. Change-Id: Id2e7fd636be814495c92c7aaf09a11c35ad92218
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
9565e7f07472931ccefbe6804234d3543f96c9b8 |
|
01-Mar-2010 |
Tom Taylor <tomtaylor@google.com> |
Speedup error column update Follow the suggestions in bug 2467382 and do separate queries to update the error column. Only do an update if the desired error value doesn't match the current value. Change-Id: I1c422565ceb1bf11dca584d26b1da4949185e29d
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
dfac57630db2993a1cda15ee4fb697ea1baadb0b |
|
26-Feb-2010 |
Wei Huang <weih@google.com> |
bug 2030420: add the "seen" column for sms and pdu tables. - add new "seen" columns for sms and pdu tables. - implement onUpgrade to add the new columns.
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
a6e44cb0cc7866439acba48ea18bdac9862afbde |
|
01-Mar-2010 |
Tom Taylor <tomtaylor@google.com> |
Add sms index Add an index of threadid and type to the sms table. Bug 2467372. Change-Id: Ib6511361a15c8f72d6a0d4977642236546120145
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
94489f821be2401e4a9045901d9112d42273b362 |
|
23-Feb-2010 |
Tom Taylor <tomtaylor@google.com> |
Fix has_attachment triggers If you create a thread by sending an MMS text message to an email address and then create another thread by sending an MMS with an attachment to a different address, both threads would show an attachment icon in the conversation list. In the MMS provider, there are four triggers that deal with setting the thread's has_attachment column. Two of the triggers were wrong and needed an extra comparison to only select parts that matched the target thread id. Bug 2235425. Change-Id: I497a3243f56de216049f18eaa0e96898679f7c62
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
c71e770495e0b4597b4b3d947cbc68a0d35051be |
|
28-Jan-2010 |
Tom Taylor <tomtaylor@google.com> |
Remove MMS from the framework Reference the new mms-common library for MMS stuff that used to live in the framework. Change-Id: I79f35fa0ba0f51adbdf386688469318e40688ef6
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
7ad939ed205080002ab32d318414337fc9c3ce1f |
|
15-Jan-2010 |
Tom Taylor <tomtaylor@google.com> |
Bump Mms database number Bump the DB number so the database will get upgraded and the new search tables built. Change-Id: I75660c280dfbf6f06dd63d9c5f9d5446ae4df5ee
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
8e5ee782690175e9cfb9a37f600f207b952ba8a6 |
|
05-Jan-2010 |
Mark Wagner <mxw@google.com> |
search work 1. introduce an FTS3 indexed table called "words" 2. put all sms messages into the words table (done in the SmsProvider's insert). 3. put all part messages which are plain text into the words table (done in the MmsProvider's insert). 4. put triggers on the delete and update for sms and part and update words appropriately. 5. remove the search recents code (mainly commented out) within the mms app. 6. implement a suggest provider which queries the words table for matches. 7. modify the search activity to use the words table rather than a LIKE clause. 8. modify the search activity to use a regular expression (rather than String.indexOf) for generating the snippet and highlighting the appropriate words within the snippet. NOTE that originally I wanted to compute the matching words positions using the sql offsets function but it doesn't work within the slightly complicated query which is used for doing the search (two joins and a union, etc.) 9. modify the highlighting code within compose message activity to use regular expressions rather than indexof to do the highlighting. 10. what else did I forget?
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
7d4e56b5fb5726342a3e0ebfba91dac48f56c107 |
|
04-Nov-2009 |
Tom Taylor <tomtaylor@google.com> |
Fix Mms DB Missing a comma when creating new DB tables. Bug 2236361.
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
ddf267c20a697f66b8238538fb6ad31507724692 |
|
29-Oct-2009 |
Tom Taylor <tomtaylor@google.com> |
Add new error code column to SMS
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
1047ab43a2bcdad9b8e8cf27afabe40ab8608b3d |
|
30-Sep-2009 |
Wei Huang <weih@google.com> |
bug 2155021: add sql trigger to update thread attachment column when pdu's thread_id column is modified. - when the pdu's thread_id column is changed (the user changed the to address), we need to update the new thread's has_attachment column. Change-Id: I017835b0c4445618eb835bb63d16427558715743
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
075b10540170f65f868d283950216d543cfe38a0 |
|
25-Aug-2009 |
Wei Huang <weih@google.com> |
fix sms/mms db upgrade code. When upgrading from ver 43 to 46, the code stopped after upgrading to ver 44's schema, but failed to fall thru. to perform the rest of the upgrade for ver 45 and 46. Change-Id: I7b23c83382d4034234e39e236fa620db7c3bfa69
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
f0a9e90721310bed023a9ff1f176f1b5e05a14f7 |
|
20-Jun-2009 |
Mark Wagner <mxw@google.com> |
mods to support searching of mms messages
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
3ddbfd0e8b3affa7cfb3b82078f122dd4533bd63 |
|
05-Jun-2009 |
Ficus Kirkpatrick <ficus@android.com> |
Remove trailing comma in SQL statement to create MMS database table. Fixes MMS app crash on launch.
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
a48a9665519f98d1e89b24d17726d7a478e575f2 |
|
04-Jun-2009 |
Tom Taylor <tomtaylor@google.com> |
Add locked column to sms and pdu tables. Add support for the ability to lock individual messages from getting automatically deleted by the recycler. A new column was added to both the sms and mms side of the messaging world.
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
2ad5ba8b1fc7b9197b78a9c3a0039522bdbd402f |
|
25-Mar-2009 |
Wei Huang <> |
Automated import from //branches/master/...@141313,141313
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
5f1e43fe6163014d8c56325daf7af364c2ff077f |
|
05-Mar-2009 |
The Android Open Source Project <initial-contribution@android.com> |
auto import from //depot/cupcake/@136594
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
7236c3ad7ff01dd5ece14a2cabbf5ce3a570d793 |
|
04-Mar-2009 |
The Android Open Source Project <initial-contribution@android.com> |
auto import from //depot/cupcake/@135843
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
9812a61b6cc6a630b836d3c4d3a1a95ae25e3abb |
|
04-Mar-2009 |
The Android Open Source Project <initial-contribution@android.com> |
auto import from //depot/cupcake/@135843
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
692628d08125876df80f3ad06d7d7e3e7bc94c2a |
|
03-Mar-2009 |
The Android Open Source Project <initial-contribution@android.com> |
auto import from //depot/cupcake/@132589
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
b7e851834b865657944db81476856b2bbc9b7a06 |
|
03-Mar-2009 |
The Android Open Source Project <initial-contribution@android.com> |
auto import from //depot/cupcake/@137055
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
fdf470d79a0ad961692c50eac9c956c6ce4c944a |
|
20-Feb-2009 |
The Android Open Source Project <initial-contribution@android.com> |
auto import from //branches/cupcake/...@132569
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
62f78e4e0ae991f0df285488a1af382bd5105483 |
|
18-Dec-2008 |
The Android Open Source Project <initial-contribution@android.com> |
Code drop from //branches/cupcake/...@124589
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
15fe736a6429ed6e4cc0138ce88b241807af207e |
|
21-Oct-2008 |
The Android Open Source Project <initial-contribution@android.com> |
Initial Contribution
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|