User talk:Mrdbalaji

We can see streams table:

/data/data/com.google.tv.mediadevicesapp/databases # ls -al

-rw-rw app_24  app_24       5120 2010-10-15 07:03 channellistingprovider.db

-rw-rw app_24  app_24          0 2010-10-15 07:03 channellistingprovider.db -journal -rw-rw app_24  app_24       5120 2010-10-15 07:03 mediadevicesprovider.db

-rw-rw app_24  app_24          0 2010-10-15 07:03 mediadevicesprovider.db-journal

/data/data/com.google.tv.mediadevicesapp/databases # sqlite3 mediadevicesprovider.db;

SQLite version 3.7.4

Enter ".help" for instructions

Enter SQL statements terminated with a ";"

sqlite> select * from sqlite_master;

table|android_metadata|android_metadata|3|CREATE TABLE android_metadata (locale TEXT)

table|streams|streams|4|CREATE TABLE streams (_id INTEGER PRIMARY KEY AUTOINCREM

ENT,deviceId TEXT,streamType INTEGER,disabled INTEGER,name TEXT,subName TEXT,des

cription TEXT,url TEXT,aliases TEXT,icon BLOB,channelNumber TEXT,group_key TEXT, delete_intent TEXT,duration INTEGER,createdDate LONG,data_source TEXT)

table|sqlite_sequence|sqlite_sequence|5|CREATE TABLE sqlite_sequence(name,seq) sqlite> select * from streams;

1|TUNER|0||GPB-HD|||tv://channel/GPB-HD?deviceId=TUNER&channelNumber=8.1&service Rec=0&dbNum=2&servicePositiveFlag=1&serviceNegetiveFlag=114&favouriteGroup=4096& tunerMode=2|||8.1|||||

2|TUNER|0||Kids|||tv://channel/Kids?deviceId=TUNER&channelNumber=8.2&serviceRec= 1&dbNum=2&servicePositiveFlag=1&serviceNegetiveFlag=114&favouriteGroup=4096&tune rMode=2|||8.2|||||

3|TUNER|0||Know|||tv://channel/Know?deviceId=TUNER&channelNumber=8.3&serviceRec= 2&dbNum=2&servicePositiveFlag=1&serviceNegetiveFlag=114&favouriteGroup=4096&tune rMode=2|||8.3|||||

sqlite>

After making changes ATSC_TUNER
data/data/com.google.tv.mediadevicesapp/databases: permission denied


 * 1) cd data/data/com.google.tv.mediadevicesapp/databases


 * ls

channellistingprovider.db

channellistingprovider.db-journal

mediadevicesprovider.db

mediadevicesprovider.db-journal


 * 1) ls -l

-rw-rw app_24  app_24       5120 2012-10-04 09:19 channellistingprovider.db

-rw-rw app_24  app_24          0 2012-10-04 09:19 channellistingprovider.db-journal

-rw-rw app_24  app_24       5120 2012-10-04 09:19 mediadevicesprovider.db

-rw-rw app_24  app_24          0 2012-10-04 09:19 mediadevicesprovider.db-journal


 * 1) sqlite3 mediadevicesprovider.db;

SQLite version 3.7.4

Enter ".help" for instructions

Enter SQL statements terminated with a ";"

sqlite> select * from sqlite_master;

table|android_metadata|android_metadata|3|CREATE TABLE android_metadata (locale TEXT) table|streams|streams|4|CREATE TABLE streams (_id INTEGER PRIMARY KEY AUTOINCREMENT,deviceId TEXT,streamType INTEGER,disable d INTEGER,name TEXT,subName TEXT,description TEXT,url TEXT,aliases TEXT,icon BLOB,channelNumber TEXT,group_key TEXT,delete_i ntent TEXT,duration INTEGER,createdDate LONG,data_source TEXT) table|sqlite_sequence|sqlite_sequence|5|CREATE TABLE sqlite_sequence(name,seq) sqlite> select * from streams;

1|ATSC_TUNER|0||GPB-HD|||tv://channel/GPB-HD?deviceId=ATSC_TUNER&channelNumber=8.1&serviceRec=2&dbNum=3&servicePositiveFlag= 1&serviceNegetiveFlag=114&favouriteGroup=4096&tunerMode=3|||8.1|||||

2|ATSC_TUNER|0||Kids|||tv://channel/Kids?deviceId=ATSC_TUNER&channelNumber=8.2&serviceRec=3&dbNum=3&servicePositiveFlag=1&se rviceNegetiveFlag=114&favouriteGroup=4096&tunerMode=3|||8.2|||||

3|ATSC_TUNER|0||Know|||tv://channel/Know?deviceId=ATSC_TUNER&channelNumber=8.3&serviceRec=4&dbNum=3&servicePositiveFlag=1&se rviceNegetiveFlag=114&favouriteGroup=4096&tunerMode=3|||8.3|||||

4|ATSC_TUNER|0||KNTV-HD|||tv://channel/KNTV-HD?deviceId=ATSC_TUNER&channelNumber=11.1&serviceRec=0&dbNum=3&servicePositiveFl ag=1&serviceNegetiveFlag=114&favouriteGroup=4096&tunerMode=3|||11.1|||||

5|ATSC_TUNER|0||NBC Wea|||tv://channel/NBC%20Wea?deviceId=ATSC_TUNER&channelNumber=11.2&serviceRec=1&dbNum=3&servicePositive Flag=1&serviceNegetiveFlag=114&favouriteGroup=4096&tunerMode=3|||11.2|||||

sqlite> sqlite> sqlite>

after scanning atsc antenna after cable ...
^C channellistingprovider.db channellistingprovider.db-journal mediadevicesprovider.db mediadevicesprovider.db-journal
 * ls
 * 1) sqlite3 mediadevicesprovider.db;
 * 1) sqlite3 mediadevicesprovider.db;

SQLite version 3.7.4 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> select * from sqlite_master;

table|android_metadata|android_metadata|3|CREATE TABLE android_metadata (locale TEXT) table|streams|streams|4|CREATE TABLE streams (_id INTEGER PRIMARY KEY AUTOINCREMENT,deviceId TEXT,streamType INTEGER,disable d INTEGER,name TEXT,subName TEXT,description TEXT,url TEXT,aliases TEXT,icon BLOB,channelNumber TEXT,group_key TEXT,delete_i ntent TEXT,duration INTEGER,createdDate LONG,data_source TEXT) table|sqlite_sequence|sqlite_sequence|5|CREATE TABLE sqlite_sequence(name,seq) sqlite> sqlite> sqlite> sqlite> -- cur_ppm: -6740.2 org_ppm: -6733.8

sqlite> select * from streams;

1|ATSC_TUNER|0||GPB-HD|||tv://channel/GPB-HD?deviceId=ATSC_TUNER&channelNumber=8.1&serviceRec=2&dbNum=3&servicePositiveFlag= 1&serviceNegetiveFlag=114&favouriteGroup=4096&tunerMode=3|||8.1|||||

2|ATSC_TUNER|0||Kids|||tv://channel/Kids?deviceId=ATSC_TUNER&channelNumber=8.2&serviceRec=3&dbNum=3&servicePositiveFlag=1&se rviceNegetiveFlag=114&favouriteGroup=4096&tunerMode=3|||8.2|||||

3|ATSC_TUNER|0||Know|||tv://channel/Know?deviceId=ATSC_TUNER&channelNumber=8.3&serviceRec=4&dbNum=3&servicePositiveFlag=1&se rviceNegetiveFlag=114&favouriteGroup=4096&tunerMode=3|||8.3|||||

4|ATSC_TUNER|0||KNTV-HD|||tv://channel/KNTV-HD?deviceId=ATSC_TUNER&channelNumber=11.1&serviceRec=0&dbNum=3&servicePositiveFl ag=1&serviceNegetiveFlag=114&favouriteGroup=4096&tunerMode=3|||11.1|||||

5|ATSC_TUNER|0||NBC Wea|||tv://channel/NBC%20Wea?deviceId=ATSC_TUNER&channelNumber=11.2&serviceRec=1&dbNum=3&servicePositive Flag=1&serviceNegetiveFlag=114&favouriteGroup=4096&tunerMode=3|||11.2|||||

6|ATSC_TUNER|0||65535.3|||tv://channel/65535.3?deviceId=ATSC_TUNER&channelNumber=65535.3&serviceRec=0&dbNum=1&servicePositiv eFlag=1&serviceNegetiveFlag=114&favouriteGroup=4096&tunerMode=1|||65535.3|||||

7|ATSC_TUNER|0||65535.6|||tv://channel/65535.6?deviceId=ATSC_TUNER&channelNumber=65535.6&serviceRec=1&dbNum=1&servicePositiv eFlag=1&serviceNegetiveFlag=114&favouriteGroup=4096&tunerMode=1|||65535.6|||||

8|ATSC_TUNER|0||KNTV-HD|||tv://channel/KNTV-HD?deviceId=ATSC_TUNER&channelNumber=11.1&serviceRec=0&dbNum=2&servicePositiveFl ag=1&serviceNegetiveFlag=114&favouriteGroup=4096&tunerMode=1|||11.1|||||

9|ATSC_TUNER|0||NBC Wea|||tv://channel/NBC%20Wea?deviceId=ATSC_TUNER&channelNumber=11.2&serviceRec=1&dbNum=2&servicePositive Flag=1&serviceNegetiveFlag=114&favouriteGroup=4096&tunerMode=1|||11.2|||||

10|ATSC_TUNER|0||65535.3|||tv://channel/65535.3?deviceId=ATSC_TUNER&channelNumber=65535.3&serviceRec=0&dbNum=1&servicePositi veFlag=1&serviceNegetiveFlag=114&favouriteGroup=4096&tunerMode=1|||65535.3|||||

11|ATSC_TUNER|0||65535.6|||tv://channel/65535.6?deviceId=ATSC_TUNER&channelNumber=65535.6&serviceRec=1&dbNum=1&servicePositi veFlag=1&serviceNegetiveFlag=114&favouriteGroup=4096&tunerMode=1|||65535.6|||||

12|ATSC_TUNER|0||KNTV-HD|||tv://channel/KNTV-HD?deviceId=ATSC_TUNER&channelNumber=11.1&serviceRec=0&dbNum=2&servicePositiveF lag=1&serviceNegetiveFlag=114&favouriteGroup=4096&tunerMode=1|||11.1|||||

13|ATSC_TUNER|0||NBC Wea|||tv://channel/NBC%20Wea?deviceId=ATSC_TUNER&channelNumber=11.2&serviceRec=1&dbNum=2&servicePositiv eFlag=1&serviceNegetiveFlag=114&favouriteGroup=4096&tunerMode=1|||11.2||||| sqlite> sqlite> sqlite> -- cur_ppm: -6743.4 org_ppm: -6733.8