History log of /packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
Revision Date Author Comments (<<< Hide modified files) (Show modified files >>>)
8a3efc3f02588fed425ea744b25a5bbf8e7e309a 13-Apr-2016 Dongwon Kang <dwkang@google.com> Add Programs.COLUMN_RECORDING_PROHIBITED

Bug: 28039913
Change-Id: Idce9dfd6024c3300f148c14832e9545b9c95435e
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
e98791890461274af70882bff6d1193da7d749b1 12-Apr-2016 Chulwoo Lee <chulwoo@google.com> Merge "Set recorded_programs.channel_id as the foreign key of channels._id" into nyc-dev
b5fb0ab500fe4dcb3dbd95b58cc91de4c7d91e71 12-Apr-2016 Chulwoo Lee <chulwoo@google.com> Set recorded_programs.channel_id as the foreign key of channels._id

If the channel is deleted, channel_id is set to null.
If the channel is updated, channel_id is changed together.

Bug: 26245328
Change-Id: Id3d5d09a4bfea54d1b1ae9a7e5fa5c5af175d63e
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
a03389ecfc40982a30677e78975509fe545e572e 08-Apr-2016 Dongwon Kang <dwkang@google.com> Do not close the singleton SQLiteOpenHelper for further use

Bug: 28085122
Change-Id: I33ee97a7bae95195a458052fa7eb11b289c77bac
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
b9f9641d758dd3c84b65b876c98f6d9221919e4e 05-Apr-2016 Dongwon Kang <dwkang@google.com> Not running upgrade logic when app starts

- Run the DB upgrade on PRE_BOOT_COMPLETED like other system providers.
(e.g. ag/52589, ag/129329)
- Do not run DB operation, which may trigger upgrade, in TvProvider.onCreate.

Bug: 27615817
Change-Id: I5a034ce20e5c01fc89539eac1f76dd4a3d5a3103
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
1faf8dfa021c94360cbe1fd4c9e0b9b5d2547af3 18-Feb-2016 Dongwon Kang <dwkang@google.com> TIF: Add COLUMN_SEASON_TITLE and COLUMN_(SEASON|EPISODE)_DISPLAY_NUMBER

Bug: 21778419
Change-Id: Id71bfc9e0e855f76831dfa97179f1fba46a69807
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
6dc803a0142267d45899faaf637c6a2b184e9b83 06-Feb-2016 Youngsang Cho <youngsang@google.com> Add INPUT_ID field in RecordedPrograms table

Change-Id: I18a2580439c6ef39042fefc75543a3514fa7c404
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
2cda3c446a1e78dd82c200f167ed7eecae5d81fa 11-Feb-2016 Chulwoo Lee <chulwoo@google.com> Add table name prefix for the join query

Fixes SQLiteException.

Bug: 27166083
Change-Id: I021b32b92f91ff1921b347e9973b0f92d5a9bfb4
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
7036e085864f762b68290ed2951a3dc1a23980c0 05-Feb-2016 Youngsang Cho <youngsang@google.com> Add RecordedPrograms.COLUMN_TITLE in the projection map

Bug: 27039026
Change-Id: Ideeb51b83204b9f7ac7d55a409acb99f6f89c98f
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
7e0ee2b198815ebd11bc1320bb25d304f6793227 29-Jan-2016 Dongwon Kang <dwkang@google.com> Support channel param in recorded program Uri

And, fix several nonsenses introduced in I42a4fc84c4bbc8a3c360150

Change-Id: Iaa755ffb0c6b3709b4b4c06b7e5b4ee604c9d8d2
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
4f8ad54d317ae473b9ffe0d176bc42694667d63d 26-Jan-2016 Dongwon Kang <dwkang@google.com> Add recorded_programs table

Bug: 23786643
Change-Id: I42a4fc84c4bbc8a3c36015032bdc5082c215a242
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
12355b83c1f6c1d01d5bc8304fa48e7f7a8e6efd 18-Jul-2015 Dongwon Kang <dwkang@google.com> TIF: do not throw exception for watchlog insertion with invalid channel id

Because it's possible if the channel has been deleted right before the tune request.

Bug: 22286134
Change-Id: I6cdea27c9dbb578ae422fb53a87d2f64e9a48e15
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
006f2e1d624a3d34d1bd26f42d9746083be1802c 23-Jun-2015 Jae Seo <jaeseo@google.com> Consolidate access control for watched programs

Change-Id: Ib397d836c2ce7acf121cfdcce3c1c609116dd619
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
b58138a677e9b08f22339c29743da41c999c25f5 23-Jun-2015 Jae Seo <jaeseo@google.com> Consolidate permission checking

Moved the permission check from needsToLimitPackage() to
createSqlParams() and removed needsToLimitPackage().

Change-Id: Ie046eae7ce10252cfd0a3971e8512fc0ce2c4827
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
2ff926c4c6a7d848467781f0080ec43ba9adffb7 23-Jun-2015 Jae Seo <jaeseo@google.com> Reboot the EPG permissions

Remove both READ_EPG_DATA and WRITE_EPG_DATA permissions that have not
been used effectively and instead add a new READ_TV_LISTINGS permission
that allows EPG apps to access the TV listings from all channel sources.

Bug: 20124415
Change-Id: Ic83ad99664dfcecf0dde33a34f2c79d953deac77
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
55d8e67f7f32598f9cc7ae7e28269369ec0271d6 22-Jun-2015 Jae Seo <jaeseo@google.com> Enable read access to channel logos

Bug: 18910284
Change-Id: I8f4a5ed074a7f74aae151afa93bb9d7eb350156f
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
7f2c93b05c85e413aacc9ded43b808e4d4579089 22-Jun-2015 Jae Seo <jaeseo@google.com> Minor code improvement

- Removed unnecessary 'final' keywords for private methods
- Removed unused imports
- Removed dependency on com.google.android.collect.Sets
- Replaced explicit types with <>
- Replaced an if statement with a switch statement
- Used the right size for a call to toArray()
- Removed a redundant initializer

Change-Id: I3f22e82034872c80958f44235cbffbbc721bb017
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
95568a08e665feefa32cab509fd7fd5748da3e69 21-Jun-2015 Jae Seo <jaeseo@google.com> Up the version to 26

Added following columns recently introduced:
Channels.COLUMN_APP_LINK_ICON_URI
Channels.COLUMN_APP_LINK_POSTER_ART_URI
Channels.COLUMN_APP_LINK_TEXT
Channels.COLUMN_APP_LINK_COLOR
Channels.COLUMN_APP_LINK_INTENT_URI
Programs.COLUMN_SEARCHABLE

Bug: 18910284, Bug: 21884742
Change-Id: Ie44409ac937cad8a7fc3f01f3c9495ec6c007fff
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
ae1c0ec4d5278dafce91f57e3400cc3ec3c2dc42 20-Jun-2015 Jae Seo <jaeseo@google.com> Enable read access to EPG data

Bug: 18910284
Change-Id: I4e100190a73f56a98981724f50c8fdb6e6eadbdf
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
818386592bd39f53b7a190c5866b20c314b86187 02-Jun-2015 Jae Seo <jaeseo@google.com> Fix lint warnings

Change-Id: Ieb8f64c38ad8ac78c0d0a8e16f50c080f0f4f512
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
dc327386750e29e09bdb1f88daada8188a3f0c38 15-Apr-2015 Dongwon Kang <dwkang@google.com> Allow 3rd-party apps to supply sort order.

Previously, we blocked sort order to make TvProvider secure, but this
limited developers to access EPG data in an efficient way. This change
allows the sort order with validation on the input param.

Bug: 19357901
Change-Id: I8a2f601f1a736d53a11cd4b973d90e41d827d9ee
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
c988ce484ba066e47629346ea1fdb1290930d0c1 14-Apr-2015 Dongwon Kang <dwkang@google.com> Drop the default sort order for Channels table.

TvProviderPerfTest on fugu:
Channels table query performance (base, ToT) : 1776.51ms
Channels table query performance (No sortOrder) : 1506.33ms

Bug: 19357901
Change-Id: I4c4262668795e4ca46f7ea07d534d643c119cb93
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
7b3f8e9eec35ada8ea1da0757e1049ec511ec337 09-Mar-2015 Dongwon Kang <dwkang@google.com> Add Programs.COLUMN_INTERNAL_PROVIDER_FLAGX in TvProvider.

Bug: 19190140
Change-Id: I546e4d53c255cdd95c8e174ebe5fca50997d6146
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
4d7ed300f89cf4ee9a8a3e99b406ad02e43475b0 09-Mar-2015 Dongwon Kang <dwkang@google.com> Add COLUMN_INTERNAL_PROVIDER_FLAGX in TvProvider.

No noticeable performance degradation found (tested with TvProviderPerfTest):
Before)
Overall elapsed time: 683 secs
Average elapsed time for (insert, update, delete): 1441.04 1678.79 2073.0 ms
Average elapsed time for (insert, update, query, delete programs): 1416.59 1845.15 16.22 179.07 ms
After)
Overall elapsed time: 684 secs
Average elapsed time for (insert, update, delete): 1372.88 1692.38 2077.0 ms
Average elapsed time for (insert, update, query, delete programs): 1403.45 1885.96 16.14 176.13 ms

Bug: 19382355, Bug: 19190140
Change-Id: I4782318aceea4f386a6c6c569c750c0468330560
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
344b2d4293049df49881664a5c4c20dcb68ae7ec 14-Nov-2014 Terry Heo <terryheo@google.com> Throw FileNotFoundException when openLogoFile() fails

ContentProvider should throw the exception instead of returning null object.

Bug: 18335090
Change-Id: Iffa0370b6c1c901ce665ca21aac6c94239fa476f
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
6331ea953c11bbea7d7e027c8fa45fb4281cb1b0 28-Oct-2014 Dongwon Kang <dwkang@google.com> Merge "Remove the UNIQUE constraint on channels table to reflect the real broadcast data" into lmp-mr1-dev
c2327ef98c214dae072719ab89bb7fd037ceb054 24-Oct-2014 Dongwon Kang <dwkang@google.com> Remove the UNIQUE constraint on channels table to reflect the real broadcast data

Bug: 17923833, Bug: 18096550
Change-Id: I0b81ebc6b171a13e94a7d9150407067756e8911e
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
eb0c19804d0f1e0b69ecc32b56e5ebc7ab633c1f 22-Oct-2014 Chulwoo Lee <chulwoo@google.com> Add genre for Brazil

BUG: 17601374
Change-Id: Ia694980c45d5acac64035639e8ea71e7114d5c17
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
1b77bffff64175afe2f37ec100447ddc3afeff76 22-Oct-2014 Dongwon Kang <dwkang@google.com> Delete the channel logo when deletion is requested for logo URI

Bug: 17970649
Change-Id: I850beb747f0a039c9e578efbd01fd6358636a371
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
2bc4d93507f22e0ed0da9410fbb0c60a6ae81593 20-Oct-2014 Dongwon Kang <dwkang@google.com> Improve the channel deletion performance of TvProvider

Experimental Results:
- 1.1M programs, 4000 channels, and 10000 watched programs.
- Time for deleting 100 channels :
- No index on programs and watched_programs table : 204,885ms
- Index on programs table (previous change Ia3cb9d8, current status) : 12,363ms
- Additional index on watched programs table (this change) : 6,946ms
- Insertion time of a watched program : 53.0ms => 53.4ms
- Update time of a watched program : 25.1ms => 24.4ms
- Deletion time of a watched program : 27.4ms => 23.5ms

Bug: 17979670
Change-Id: Ic2f9a80012458ad0003915fe88d80050b3608020
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
ae89c84dbfa7be3c3ca0dfd177671c0fc8bf4503 17-Oct-2014 Dongwon Kang <dwkang@google.com> Merge "Improve the query performance of programs table" into lmp-mr1-dev
86c6896ec54053b601546ce80478e273b50063f0 13-Oct-2014 Dongwon Kang <dwkang@google.com> Improve the query performance of programs table

Use-cases of quries:
1. In the TV app, the guide fragment will query programs in a specific time range.
2. In the TV app, the channel guide wants to show all the currnet programs for all channels.
3. In the TV app, channel banner will query the current progrom of a specific channel.
4. When TIS adds programs, it might checks if there is any existing programs.

Experimental results:
- # of records : 1.1M programs
- URI used for query : TvContract.buildProgramsUriForChannel(#,start,end)
- Query time : 2700ms => 29.9ms
- Insertion time : 50.9ms => 51.4ms
- Bulk insertion time - 100 programs : 570.7ms => 643.7ms
- Update time : 53.4ms => 51.3ms
- Deletion time : 56.4ms => 60.6ms
- DB size : 408MB => 503MB (~20% increase)

Bug: 17514090, Bug: 16858261
Change-Id: Ia3cb9d8a4c7e96687c001575a890319aadbe9398
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
7427c583b89f6c3ac49f8498d4cb7bc9d69f44f6 16-Oct-2014 Chulwoo Lee <chulwoo@google.com> Merge "Enhance the performance of bulkInsert()" into lmp-mr1-dev
5462b213ed14735289692cf525a46aa27fc3ba26 15-Oct-2014 Dongwon Kang <dwkang@google.com> Fix the type of COLUMN_TYPE and COLUMN_SERVICE_TYPE.

They should be texts per the definition in TvContract.Channels.

Bug: 17993656
Change-Id: I6ed6267726154a41cd0ee25145a56ac850f6a633
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
323e13d3949e7eb1c5c1c613d8de7ba370d8dbce 14-Oct-2014 Chulwoo Lee <chulwoo@google.com> Enhance the performance of bulkInsert()

- Enclosed the method with DB transaction.
- Time to insert 4000 channels(seconds) : 92.151 -> 18.280
- reduced by 80%

BUG: 17961422, BUG: 16858261
Change-Id: I7c2c4c109d3e030802cc36e34312caa98a1b2dd1
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
e6f740348311ed89e948a72227aaa413f21e4624 15-Oct-2014 Chulwoo Lee <chulwoo@google.com> Revert "Enhance the performance of bulkInsert()"

This reverts commit de479fb00db74e4e3742be39ef776c3e9fde422a.

Change-Id: I32743cbf283f93ecb553d084dcbd5092cfa141eb
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
de479fb00db74e4e3742be39ef776c3e9fde422a 14-Oct-2014 Chulwoo Lee <chulwoo@google.com> Enhance the performance of bulkInsert()

- Enclosed the method with DB transaction.
- Time to insert 4000 channels(seconds) : 92.151 -> 18.280
- reduced by 80%

BUG: 17961422, BUG: 16858261
Change-Id: I50fc367ad9b3e46b93563b37747bc386c257d7cf
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
4cf2b25671ca94b824cc80b540075fb34afeae1c 16-Sep-2014 Jae Seo <jaeseo@google.com> Protect watched programs data with ACCESS_WATCHED_PROGRAMS permission

Also turned off debugging and set the retention period for wached
programs data to 90 days.

Bug: 17512367
Change-Id: I4c9653c0b05d5a3ee3e373d7938af0bc6aa0b061
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
e7957cfb42fcfdc5710246d80b980e232aac1ef7 07-Sep-2014 Wonsik Kim <wonsik@google.com> Add BROWSABLE to deleted_channels table

Bug: 17383633
Change-Id: Id04c672f890e5d94b5b80380d7f9cfe0340b2b8a
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
d79322ce0f814dc7acfebbb2481f765259a736ce 03-Sep-2014 Wonsik Kim <wonsik@google.com> Store locked channels separately when deleted

Store locked channels separately when deleted, so that TvProvider can
restore locked state when the channel is added again.

Bug: 17321896, Bug: 17241409
Change-Id: Ie5ef71ca632f446b02c39b56e55bb8f1d55e85b4
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
628460fc4c6ab290aea312dc8a912bde65676815 01-Sep-2014 Chulwoo Lee <chulwoo@google.com> Add unique constraint to channels table

The tuple for uniqueness is {input_id, original_network_id,
transport_stream_id, service_id}.
One of the three columns except input_id should be set.

BUG: 17320894
Change-Id: If92cd7e11738e255526187904569696a59eaa198
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
6c03ca644bcc3da46587390cce29eba3afdadddf 28-Aug-2014 Jae Seo <jaeseo@google.com> Change the default value of Channels.COLUMN_BROWSABLE to 0

Until the user decides to add the new channels, they should remain
non-browsable.

Bug: 17310177
Change-Id: Ib9d8d8011f374889981f313ddfadc2852945afa5
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
28f33edd74058a498cdfc84001ee2173895cba06 27-Aug-2014 Jae Seo <jaeseo@google.com> Merge "Revert "Temporarily disable parental controls permission check"" into lmp-dev
99c10998ff754242ba0c9cdde5de11dc373457ed 27-Aug-2014 Jae Seo <jaeseo@google.com> Revert "Temporarily disable parental controls permission check"

This reverts commit de09c108eabb884924ae87597f2abaaf1cb39958.

Change-Id: Ic0b0f0cc95410ef6d91a6387b5cb264887e70cbf
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
5d05aa72ee869d63828305e86a784b30b795f411 20-Aug-2014 Chulwoo Lee <chulwoo@google.com> Map ISDB genres to canonical genres

BUG: 17110874
Change-Id: I284e8a7e5532dca1cd72511361cce8f007441f58
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
de09c108eabb884924ae87597f2abaaf1cb39958 15-Aug-2014 Jae Seo <jaeseo@google.com> Temporarily disable parental controls permission check

Until b/16984416 is resolved.

Bug: 17052558
Change-Id: I3775047a7de1e7ccc1f6b415f2cef593639e730e
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
66deb422aaf1bc5400bdcefac78d3e2c6c4f3189 13-Aug-2014 Sungsoo Lim <sungsoo@google.com> Notify the insertion of watched programs when they are consolidated

TvProvider does not allow to query for a watched program whose
COLUMN_CONSOLIDATED is 0. Therefore, if notifyChange() is called when
it is inserted, ContentObserver can't get the information of the watched
program since at that time COLUMN_CONSOLIDATED is 0.

This CL postpones to call notifyChange till COLUMN_CONSOLIDATED becomes 1.

Bug: 16966390
Change-Id: Ia39efe7d7698b0da3670f5fa72441b42116da2a7
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
2f1a3b6808ac14bc024deca6139d72a648f8b43a 14-Aug-2014 Jae Seo <jaeseo@google.com> Require MODIFY_PARENTAL_CONTROLS permission to update COLUMN_LOCKED

Since the locked column (TvContract.Channels.COLUMN_LOCKED) is used for
parental control it should be restricted by the parental control
permission (android.permission.MODIFY_PARENTAL_CONTROLS).

Bug: 16992858
Change-Id: I0129e85dbc1fddde612ee1a51ab8c836eb9272bf
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
55d148657809a115754aa06de2e20147f8a98696 13-Aug-2014 Jae Seo <jaeseo@google.com> Fix the permission name for accessing all EPG data

Change-Id: I41d6f0fbba37fcd3e12fa62d4fa2496304b53a01
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
13b32cf3dd4eed429f5dda7f1cad6dc50f2b5b84 12-Aug-2014 Jae Seo <jaeseo@google.com> Correct the permission names

Bug: 16955875
Change-Id: I019603addee0e9205a1aa810e77b2ee84dbacf38
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
c692956369b72c8b79b9557989c46e1f85ed4dbb 11-Aug-2014 Jae Seo <jaeseo@google.com> Fix a bug that scheduleNext() is not called in some cases

When the most recent log entry splits into multiple entries, the number of
unconsolidated entries was miscalculated resulting in scheduleNext() being not
called. This change fixes the bug.

Also made some minor cosmetic changes.

Change-Id: I112617ce8fd905ae4bc64496c476832f27f38afd
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
c172ef43f0963d0c8452d1819ec812be0a7320fb 11-Aug-2014 Jae Seo <jaeseo@google.com> Merge "Put some delay before trying to consolidate watch logs" into lmp-dev
f5ed20db5e1239f1a28d63ef7bed36beeaebc2e2 11-Aug-2014 Jae Seo <jaeseo@google.com> Put some delay before trying to consolidate watch logs

This prevents excessive calls of onTryConsolidateAll() and helps
increase probability of finding program data.

Also fixes a minor typo.

Change-Id: I7912ed61c1b79206cbf349d3f0dfcccdd6341322
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
0fd53133eed104e0c228376e0f24194a7f6ff724 08-Aug-2014 Jae Seo <jaeseo@google.com> Move watch history logging from the system service

Now the system service is only responsible for inserting raw data when the TV is
tuned to a new channel (watch start time) or the current input session is
released (watch end time), which minimizes database operations in the system
service. On the other hand, it is now responsibility of TvProvider to fill up
missing program information and consolidate the log entries.

Bug: 14791151, Bug: 15921205, Bug: 15988715, Bug: 16831555
Change-Id: I468c35f2e120448f184380be4c8899a8e5e55d36
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
f0b8729f2dc0834129904b7bf10b8ac9af2bffaa 06-Aug-2014 Ji-Hwan Lee <jihwan@google.com> Add missing columns in TvContract

Add:
- Channels.COLUMN_NETWORK_AFFLIATION
- Channels.COLUMN_VIDEO_FORMAT
- Channels.COLUMN_LOCKED
- Programs.COLUMN_VIDEO_WIDTH
- Programs.COLUMN_VIDEO_HEIGHT
- Programs.COLUMN_AUDIO_LANGUAGE

Remove:
- Programs.COLUMN_VIDEO_RESOLUTION

Bug: 16810754
Change-Id: I4f55121deac856ed3a460657bc6b8aac5df31244
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
b8a3d1049d6afec93fa5bcc5c8a9b0712369ed29 06-Aug-2014 Ji-Hwan Lee <jihwan@google.com> Apply new TvContract URIs

Bug: 16806157, Bug: 16804331
Change-Id: If91877810277660fc0d690a824d2a63846def5a7
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
d9f937e4769668da59d614600ea3405ee0353ef6 05-Aug-2014 Ji-Hwan Lee <jihwan@google.com> Refactor common URI processing for DB operations

This is a preliminary work for further bug fixes.

Change-Id: Icc7b5a5a01cba508caa707478a7a69d021f66512
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
5cc3550c2e3bea2b88e4b8d75bdb246665ce5f34 08-Aug-2014 Ji-Hwan Lee <jihwan@google.com> Merge "Do not allow inserting programs with invalid channel ID" into lmp-dev
916624c91fe0e53aa3e7b220b6f488ac6507285b 06-Aug-2014 Ji-Hwan Lee <jihwan@google.com> Prevent inserting rows through URIs with ID

Also, throw UnsupportedOperationException, instead of
IllegalArgumentException, for invalid operations on URI.

Bug: 16810558
Change-Id: I1c2044eeaaa24b2c641ce8e07deb0ab1addd4f08
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
c9d7274db686189d6ac9d09a07b3d0286fc81fa0 07-Aug-2014 Ji-Hwan Lee <jihwan@google.com> Do not allow inserting programs with invalid channel ID

Bug: 16811007
Change-Id: I71db7d8f17cb323f3b7bde611474c199eac6fcbd
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
f9c2dc2ebbcc25bcb45b79a9614786fc4b72511c 11-Aug-2014 Wonsik Kim <wonsik@google.com> Merge "Add Channels.COLUMN_SERVICE_ID to projection map" into lmp-dev
06379c1487f9f5b3fc6da48c41ab056289ca2b81 10-Aug-2014 Wonsik Kim <wonsik@google.com> Add Channels.COLUMN_SERVICE_ID to projection map

Change-Id: I61b41eb83adc90ba523768b0ec879c0d8b6b6db5
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
188cdb111aa780ce7cffa78140c68ee1f80c1247 10-Aug-2014 Ji-Hwan Lee <jihwan@google.com> Merge "Fix IllegalArgumentException for genre query" into lmp-dev
1f29945e3b1f90ad287df664be30c4296dc96ff4 10-Aug-2014 Ji-Hwan Lee <jihwan@google.com> Fix IllegalArgumentException for genre query

Change-Id: I9941ac16a8b0678052b1ad7e405598a2bc972c30
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
e1437ba576f50d812981d6d12634610ee64bc759 09-Jul-2014 Sungsoo Lim <sungsoo@google.com> Add COLUMN_TUNE_PARAMS in watched_program table

Bug: 15809017
Change-Id: I80629dad4791a66c5ac483ba6c32ce0be41647e3
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
443a7feb6f6077c2309f1fb33cce72116732b43a 02-Jul-2014 Chulwoo Lee <chulwoo@google.com> Map broadcast genre to canonical genre

BUG: 14069779
Change-Id: Id3c6d766ba02585ea939594fbf91ac5f6730ac5a
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
9dad7589a8c4e31db3130b4d6e05a10e58b4952b 24-Jul-2014 Dongwon Kang <dwkang@google.com> Remove COLUMN_CONDITIONAL_ACCESS from TvProvider.

It turned out that having this flag in Channels table does not
make sense for some European countries because they scremble the signal
per program basis. Also, the current flag does not fit to the use-case
like 'pay per view'. Decided to remove this in L release because it's not
clear how we will handle the cases raised at this moment.

Change-Id: I52d292e7f37325725146165c4c66c2568ca08b6c
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
1604d0f9529ad3d0fcaee47f8e87c7abd7da3675 22-Jul-2014 Youngsang Cho <youngsang@google.com> Add season/episode related fields

Added Programs.COLUMN_SEASON_NUMBER, Programs.COLUMN_EPISODE_NUMBER,
Programs.COLUMN_EPISODE_TITLE.

Change-Id: I38d8ed66ab793cee6ee2e768776c8cd7476797d8
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
cf688af6c5dcc9e6926b6b3e8fdf5732b9ec36a8 19-Jul-2014 Youngsang Cho <youngsang@google.com> Add a channel URI pattern for passthough inputs

Change-Id: Iccad90ebdfa18509933c2158aaf7db8fc5c32ce3
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
023be771801a56970689b2cfe4892d04a66e99b9 15-Jul-2014 Chulwoo Lee <chulwoo@google.com> Introduce "input_id" column to the channels table

Removed service_name column

BUG: 16138420
Change-Id: I82ee9fa97095f73be0c77351bb5399075fec9907
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
0389724e1aabf49351ffaf5e139b74b072d190cb 07-Jul-2014 Sungsoo Lim <sungsoo@google.com> Add a content rating column in programs table

Bug: 13172379
Change-Id: I95379d1a455abc129ae93747a4a78f92b3888dba
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
ac117ad70762672243573f9c8a5ea3220c4884bf 25-Jun-2014 Ji-Hwan Lee <jihwan@google.com> Clean up EPG data

Bug: 14903289
Change-Id: I3f2b04c7f6e46fc172c055abab7be3ca98536a55
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
aa098bda71fe210b9169092e79e333a1d9d32058 30-Jun-2014 Ji-Hwan Lee <jihwan@google.com> Disallow querying with sort order without permission

Bug: 15876810
Change-Id: Iab34b46d5bb02132396acaf3f68364a03598bedd
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
8497462c04c89dd06d4346a8104d524c420c4087 01-Jul-2014 Dongwon Kang <dwkang@google.com> Add COLUMN_CONDITIONAL_ACCESS in Channels table.

Related change: I62d744b92e31fbbb95ba10b2595686114f6fbb6f

Bug: 14073703
Change-Id: If098208ce068f281e03cf8692a6865697067feb6
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
d308c6157aa068ee75425dae1e852b57fe5872b7 17-Jun-2014 Chulwoo Lee <chulwoo@google.com> Handle query parameter "canonical_genre"

BUG: 14069779
Change-Id: I2a65e417bc7fbf3aa5a842fbc9d74ea3d7709a2d
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
711f02f31b2be633a19fc929761581116cb0c64b 19-Jun-2014 Ji-Hwan Lee <jihwan@google.com> Use blob, instead of file, for channel logo

To maintain consistency more easily.
Also, notify logo URI instead of channel URI, after writing.

Bug: 15579802
Change-Id: I5449d55b1c13159e4b618c7b0336cdd70530ecf5
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
5f930ebc1e117d6c3ec53d22e296901857a45ae4 19-Jun-2014 Ji-Hwan Lee <jihwan@google.com> Avoid foreign key constraint failure on DB upgrade

Bug: 15737778
Change-Id: I700972cff39b94141f4d26a6f7dc8a574de83751
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
2bcac69ea4f774c4a90d2e4aa7ceee64e8f78523 18-Jun-2014 Jae Seo <jaeseo@google.com> Merge "Add the PACKAGE_NAME column to the WatchedPrograms table"
fd946b63c5b3b4b550d57fdbe9d831c77b8508a2 18-Jun-2014 Jae Seo <jaeseo@google.com> Make batch operations atomic

Borrowed the code from EmailProvider.

Change-Id: I581ea91c0d4bfd9133e27b53d9e926b01a4c2e81
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
fa6697c5c240228a4382896570cf197977ab99f7 16-Jun-2014 Jae Seo <jaeseo@google.com> Turn foreign key support on

Bug: 15606303
Change-Id: I2c5ac6713838d16c7b88b8a35f2a8b193ea5d15d
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
c3f5ab6043a490428ac01e8831251c9b045cc1a7 13-Jun-2014 Ji-Hwan Lee <jihwan@google.com> Check permission to read channel logo

Only an app that owns channel, or a system app that has ALL_EPG_DATA
permission can read channel logo.

Bug: 15580354
Change-Id: I0d13c7a0b9ba7420290b2fc4f02304a12bc46b5d
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
37f64851eaf6be870c8bc590bc863f1a4f9cc0fc 13-Jun-2014 Jae Seo <jaeseo@google.com> Add the PACKAGE_NAME column to the WatchedPrograms table

Bug: 14981342
Change-Id: Ifcc3d274a3003d9584caad0b4d530b6dddcddcd0
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
91889005be78e8f5382eff5e9fdb44a210a473e9 11-Jun-2014 Jae Seo <jaeseo@google.com> Temporarily add a field for video resolution to the Programs table

Bug: 15547369
Change-Id: I8e5b34cf776db3bb5262bb82748852cfd859d0c9
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
a859d255484f0fbcd3e5ba2f07afb18a7613c0a3 09-Jun-2014 Jaekyun Seok <jaekyun@google.com> Merge "Add poster art uri and thumbnail to program projection map" into lmp-preview-dev
85a19bdaf429f2cff3413219932419a3718a5fdc 09-Jun-2014 Jaekyun Seok <jaekyun@google.com> Add poster art uri and thumbnail to program projection map

Bug: 15502803, Bug: 15473740
Change-Id: I1d7270d1ae0755d74a5b2b871165b7e27b58b84b
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
042f9556da1805360a66f6d3bbf2ca217e2c057e 09-Jun-2014 Chulwoo Lee <chulwoo@google.com> Merge "Add "searchable" column to the database" into lmp-preview-dev
992930b401cdf9dd136473fe514b70b3e213926a 09-Jun-2014 Chulwoo Lee <chulwoo@google.com> Add "searchable" column to the database

And removed unnecessary files.

BUG: 15492103
Change-Id: I4d19680d927865bad69ca5f07ec7f0f69cd8a921
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
e29b8bca36c686a54045f806b277ab4194419717 08-Jun-2014 Ji-Hwan Lee <jihwan@google.com> Delete programs for specified channel only

Currently, when start and end time is given, TvProvider deletes overlapping
programs of all channels owned by calling packages.

Change-Id: Ifee006f8a19a32f1e1890f29eb1ca34d43017d0b
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
8a196b59e334924a316e6545bd877c0efc4316c8 05-Jun-2014 Ji-Hwan Lee <jihwan@google.com> Support channel logo and program thumbnail

Change-Id: Iaad30b7b735b2351742ce6d7cebe7a3833bb9aeb
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
15201d2d9dbd6db6db99da3517f5a5d7802c45ce 03-Jun-2014 Jae Seo <jaeseo@google.com> Use the new column names and authorities

Also incremented the version number to purge the old columns.

Change-Id: I89422f49ecb98816b90c504aa852ccab09e70408
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
6456b82982d57b46ea9f7dc87ac65a768e16cb73 31-May-2014 Jae Seo <jaeseo@google.com> Use the new contract class android.media.tv.TvContract

Change-Id: Ibbd2fcb0085037a772e3c580f1984e841505df41
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
bd5e96d5de099fa674b5d9d0e7dc04783ef49681 19-May-2014 Chulwoo Lee <chulwoo@google.com> Mistake while merging

Change-Id: Ic3576aed37976cc6cff817eba3e801cadb395ea8
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
6b0092e2a3a928342aad23fc02ece8668b2e5ac0 14-May-2014 Chulwoo Lee <chulwoo@google.com> Include start/end time for the selection of programs

I think start/end time should be inclusive for the
exact match.

Change-Id: Ibf37fbd11a5946fc8a4af6f0ccb6e623d8129d36
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
7cbf5dbfd20cd1a4ed35bc7c1f170c9e30a50f05 14-May-2014 Jae Seo <jaeseo@google.com> Change the column names of the TvContract tables

Change-Id: Iede13119f10288215ce54918612fc6f346497ae4
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
fe690e3df0f514b339b3d623c148bf96a2657e67 28-Apr-2014 Jae Seo <jaeseo@google.com> Disable user-provided selection

Now normal (non-system) applications that do not have permission to access all
TV metadata can use the following URI patterns to get filtered data:
content://com.android.tv/input/*/*/channel
content://com.android.tv/input/*/*/channel?browsable_only=
content://com.android.tv/channel/#/program
content://com.android.tv/channel/#/program?start_time=&end_time=
which allows us to disable user-provided selection on query/delete/update to
help avoid SQL injection.

Bug: 14133838
Change-Id: I716e9f0d31ba5b2b7e6119ead8ee649a652ea189
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java
bbbbf738a6502a5e1d1c2d4ae4c3bb9984362b11 27-Mar-2014 Jae Seo <jaeseo@google.com> Initial skeleton of TvProvider

Implemented the very first version of TvProvider (ContentProvider for
TV) that manages access to TV channel/program data as well as the user’s
TV watch log. The contract between this provider and applications is
defined in android.provider.TvContract.

Change-Id: I7c04a952983ae28287398c720c945da0d7d4726b
/packages/providers/TvProvider/src/com/android/providers/tv/TvProvider.java