Child pages
  • Mapping Information

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

We can find all channels in mediestream with a query like 

Code Block
http://marsprod-search03:57308/doms/sbsolr/collection1/select?q=*%3A*&fq=recordBase%3Adoms_radioTVCollection&wt=json&indent=true&facet=true&facet.field=channel_name&facet.limit=10000100000

BTA_TRANSCODES

In BTA we record the start-time offset in the database so we can get walltime out of the bta database with a command like

...

Code Block
 psql -h digitv-prod -d digitaltv -U digitvro -t -A -F"," -W -c "select id, program_id, starttid from ritzauprogram WHERE channel_name IN ('drp1','drp2','drp3','drp4o','drp4k','voice','drp8j','drp7j','100fm','drp6b','novafm','drp4s','drrar','drmamar'drmamara', '24syv', 'drp5', 'drpk', 'drp7m', 'tv2radio', 'rakl', 'drp5000', 'radio2', 'boomerang', 'drp4k94', 'drp4re', 'drp4mv', 'drp4b', 'drp4nj', 'drp4f', 'drp4fyn', 'drp4miv', 'drp4nor', 'drp4blm')" > all_programs.csv

MEDIESTREAM

...