Opened 9 years ago

Last modified 4 weeks ago

#8774 assigned Developer Task

Store channel type in database

Reported by: Stuart Auchterlonie Owned by: Klaas de Waal
Priority: minor Milestone: 31.0
Component: MythTV - Channel Scanner Version: Master Head
Severity: medium Keywords: schemachange
Cc: Ticket locked: no

Description

Store channel type (TV/Radio/Data etc) into database when we find that information during channel scanning.

This information can then be leveraged in other areas, such as when setting up a recorder and the type of streams it expects to find.

Change History (19)

comment:1 Changed 9 years ago by Stuart Auchterlonie

Status: new → assigned

comment:2 Changed 9 years ago by stuartm

Milestone: 0.25

Milestone 0.25 deleted

comment:3 Changed 8 years ago by stuartm

Type: task → Developer Task

This seems like an interesting and very simple addition, one for 0.26 maybe?

comment:4 Changed 8 years ago by Stuart Auchterlonie

Milestone: 0.25 → 0.26

Yes, its a good one for 0.26. Fixing the milestone

comment:5 Changed 7 years ago by Kenni Lund [kenni a kelu dot dk]

Milestone: 0.26 → 0.27

comment:6 Changed 6 years ago by paulh

Milestone: 0.27 → 0.28

comment:7 Changed 4 years ago by Karl Egly

Keywords: schemachange added

I'd love to see us store the SD/HD/UHD/3D part of the service type, too. My plan is to use it in MFDB for a fixup similar to FixHD on EIT.

comment:8 Changed 4 years ago by Stuart Auchterlonie

Milestone: 0.28 → 0.29

comment:9 Changed 4 years ago by Stuart Auchterlonie

Milestone: 0.29 → 29.0

Milestone renamed

comment:10 Changed 2 years ago by Stuart Auchterlonie

Milestone: 29.0 → 29.1

comment:11 Changed 22 months ago by Stuart Auchterlonie

Milestone: 29.1 → 0.28.2

Moving remaining open tickets to 0.28.2 milestone

comment:12 Changed 22 months ago by Stuart Auchterlonie

Milestone: 0.28.2 → 29.2

Moving remaining open tickets to 29.2 milestone

comment:13 Changed 7 months ago by Klaas de Waal

This would be useful to setup the buffering parameters for Live TV/Radio. At the moment the Live TV is setup for 8Mbit/s for all channels. This is OK for TV but for radio/audio-only channels a much lower setting would be better.

comment:14 Changed 7 months ago by Stuart Auchterlonie

Milestone: 29.2 → 31.0
Owner: changed from Stuart Auchterlonie to Klaas de Waal

Klaas you are welcome to do this.

Regards Stuart

comment:15 Changed 5 weeks ago by Klaas de Waal

It looks like the best value to use for channel type is the service_type as described in the DVB Bluebook A038, Feb 2019, pages 82 and 83. The way to do this is to extend database table channel with a field service_type and copy the service_type into this field when found during the channel scan.

comment:16 Changed 5 weeks ago by Stuart Auchterlonie

Klass, this just needs a DB schema update to add an appropriate column, and then the code as you mention to store the relevant info

comment:17 Changed 5 weeks ago by Klaas de Waal

Column service_type is added to database table channel in commit 8ae1c0b7958f3693ca4361bc9d116e55958a47ad which bumps the database schema version to 1352.

The code to retrieve and store the data as described in comment:15 is added in commit c7ad89a7eb999982c702eda9347603a9a7a1f532.

comment:18 Changed 4 weeks ago by Klaas de Waal <kdewaal@…>

In 8ae1c0b79/mythtv:

Update database schema to version 1352

Revert type change in update to version 1351, part of
commit 6f876b31e9e1a3dbc4f1ef3a27d58f25daacae07
In update to version 1352:

  • change type of region_id and bouquet_id from int to unsigned int
  • add service_type to table channel for ticket #8774
  • change schema version number to 1352

Refs #8774

comment:19 Changed 4 weeks ago by Klaas de Waal <klaas@…>

In bba208158/mythtv:

Support for channel service_type in services API

Add support for service_type in the C++ code of the services API.
Partial support added for perl, python and php bindings.

Refs #8774

Note: See TracTickets for help on using tickets.