Convert US subchannels to feeds

[freearhey]

Currently, each of the >10,000 US subchannels in the database has its own entry in channels.csv and another entry in feeds.csv.

channels.csv

id	name	alt_names	network	owners	country	categories	is_nsfw	launched	closed	replaced_by	website
WACP48.us	WACP 4.8	DIYA	Diya TV	Faith Broadcasting Network Inc.	US	religious	FALSE	2012-06-18			https://www.tct.tv/
WSWFLD101.us	WSWF-LD 10.1	DiyaTV	Diya TV	Major Market Broadcasting of Florida Inc.	US	religious	FALSE
WTBTLD451.us	WTBT-LD 45.1	WGCT-LD	Diya TV	Major Market Broadcasting of Florida Inc.	US	religious	FALSE

feeds.csv

channel	id	name	alt_names	is_main	broadcast_area	timezones	languages	format
WACP48.us	SD	SD		TRUE	ct/USAIY	America/New_York	eng	480i
WSWFLD101.us	SD	SD		TRUE	ct/USORL	America/New_York	eng	480i
WTBTLD451.us	SD	SD		TRUE	ct/USTPA	America/New_York	eng	480i

In addition, we have to store a logo for each subchannel (even if it's the same one):

logos.csv

channel	feed	in_use	tags	width	height	format	url
WACP48.us		TRUE		1000	613	PNG	https://i.imgur.com/xNCDWHR.png
WSWFLD101.us		TRUE		1000	613	PNG	https://i.imgur.com/xNCDWHR.png
WTBTLD451.us		TRUE		1000	613	PNG	https://i.imgur.com/xNCDWHR.png

---

The new system proposes grouping subchannels by network and using the call sign as the feed name.

In this case, a single entry in both channels.csv and feeds.csv will suffice:

channels.csv

id	name	alt_names	network	owners	country	categories	is_nsfw	launched	closed	replaced_by	website
DiyaTV.us	Diya TV			Ravi Kapur	US	religious	FALSE	2009-01-01			https://www.diyatvusa.com/

logos.csv

channel	feed	in_use	tags	width	height	format	url
DiyaTV.us		TRUE		1000	613	PNG	https://i.imgur.com/xNCDWHR.png

And in feeds.csv, we can store all the channel variants like this:

feeds.csv

channel	id	name	alt_names	is_main	broadcast_area	timezones	languages	format
DiyaTV.us	National	National		TRUE	c/US	America/New_York	eng	480i
DiyaTV.us	WACP	WACP	4.8;DIYA	FALSE	ct/USAIY	America/New_York	eng	480i
DiyaTV.us	WSWFLD	WSWF-LD	10.1;DiyaTV	FALSE	ct/USORL	America/New_York	eng	480i
DiyaTV.us	WTBTLD	WTBT-LD	45.1;WGCT-LD	FALSE	ct/USTPA	America/New_York	eng	480i

This should not only significantly reduce the number of records in the database but also make it much easier to keep the data up to date.

[freearhey]

@LPhilip1999 @Pecaquito @StrangeDrVN

[Pecaquito]

On the playlist they are so many channels that have more than one link, but only one Link are being used, because playing selected the one with the best quality, but I think that the playlist should show All the link on list for that channel that only has a single feed, I have know it that when the channel link go broken, we have to remove that link in order for the playlist select one the other link that never been used, I think if a channel have 3 Link, those 3 options should be on the playlist.

[freearhey]

If the links have different Stream IDs, they are all added to public playlists. So this update shouldn't affect that in any way.

[StrangeDrVN]

The new system proposes grouping subchannels by network and using the call sign as the feed name.

This is a good idea, and I have thought about this. But, each feed has different owners. Although the network is same, their operator and transmission seem to be owned by different companies.

[freearhey]

In this case, only the network owner will be listed in the owners field of channels.csv. However, if we need to store additional information in the future, we can add new fields to feeds.csv as well.