📺 EPG

EPG (Electronic Program Guide) system written in Go using SQLite and web backend.

This is NOT a complete turnkey project simply a roll-you-own concept to use with my repeater project. DATV Repeater

🧠 My Goal

1. Understnad the underly mechanisum in implementing A EPG and injecting the EIT into a running DVB transport stream 🛰️ 2. Use a SQLite database backend in Go 3. implement a web backend to show current events and basic management of the EPG and Repeaters operation remotely. Use TSL and proper security.

I've since looked into CherryEPG as a subsitute EPG system however, I'll continual working on this GO version and support anyone whom has experience with EPG's and is able to assist with this project.

🛢 Database

To create a new epg, simply delete the epg.db file in bin folder. On execution a new epg.db file is created using GORM migrate which uses the csv files to populate the tables. I used this method over static constants to keep the executable smaller in size and to provide flexibility for additions and changes. Some thought on how to package the csv files with the GO install. I'm yet to decide.

🌟 Ratings

Each of the ratings systems uses a country identifier (au) here for the rating icon files.

🌐 CRID

CRID (content reference identifier)

I'm yet to work out how modern TV's show the channel icon and current program in their EPG? I'm sure it able to be immplemented and is a url to a specific address where these resources are visible. Anyone like to explain how this actully works and what is needed at the CRID/URL side? 😜

📝 TODO

• Implement a query to fill the events table with a full 24 hours of events which is populated once a channel/s is associated to a network.
• Show the current events for channels using SSE (dynamic webpage) as one would see on the TV or set top box.
• Once events have been created, generate the EIT.xml file containing the relavent tags which is injected into the DVB transport stream using TSduck eitinject plugin or alternatively roll my own using pure GO https://github.com/tsduck/tsduck/tree/master/src/tsplugins
• Add users table and TSL secure socket handling to remote manage.

Below is the file structure:

epg
|   build-and-run.sh
|   go.mod
|   go.sum
|   README.md
|   details.txt
|   
+---bin
|       epg.db
|       
+---cert
+---csv
|       categories.csv
|       color.csv
|       countries.csv
|       events_template.csv
|       genre.csv
|       ratings.csv
|       ratingsystems.csv
|       timezones.csv
|       
+---notes
|       CRID info.doc
|       
+---src
|   +---app
|   |       main.go
|   |       
|   +---config
|   |       config.go
|   |       config.json
|   |       
|   +---controller
|   |       base.go
|   |       categoryHandler.go
|   |       channelHandler.go
|   |       countryHandler.go
|   |       eventHandler.go
|   |       eventRatingHandler.go
|   |       genreHandler.go
|   |       networkHandler.go
|   |       ratingHandler.go
|   |       ratingValueHandler.go
|   |       timezoneHandler.go
|   |       
|   \---model
|           categoryModel.go
|           channelModel.go
|           countryModel.go
|           eventModel.go
|           genreModel.go
|           model.go
|           networkModel.go
|           ratingsModel.go
|           timezoneModel.go
|           
\---static
    +---css
    |       styles.css
    |       
    +---html
    |       about.html
    |       base.html
    |       category.html
    |       channel.html
    |       contact.html
    |       epg.html
    |       genre.html
    |       index.html
    |       network.html
    |       rating.html
    |       
    +---icon
    |       favicon.ico
    |       
    +---img
    |   +---logos
    |   |       default-50x50.png
    |   |       vk3rgl-hd1-50x50.png
    |   |       vk3rgl-hd2-50x50.png
    |   |       
    |   \---ratings
    |       \---au
    |               AV15+.png
    |               C.png
    |               Check.png
    |               E.png
    |               G.png
    |               M.png
    |               MA15+.png
    |               P.png
    |               PG.png
    |               R18+.png
    |               X18+.png
    |               
    \---js
            scripts.js

The project requires a number of Go packages "gorm.io/gorm" "github.com/gorilla/mux"