Using las-vegas

las-vegas is a utility for generating SQL queries for the TV Guide Channel “Hollywood” software hastily written in Python by Sam (pjfrix; in other words, the person who wrote this guide.) It is licensed under the GNU Public License.

The name is a loose reference to various terminologies given to databases and applications in Hollywood.

The GitHub repository is located here.

Requirements

To use this script, you will need to install Python for your system. It was written with Python 3.9 in mind, however should function the same in newer versions.

If you want to use this on Windows XP (i.e. within the same virtual machine as Hollywood), you will need to use this compiled build of Python 3.9 for Windows XP hosts. Please note that I do not maintain this fork.

Instructions

When you first execute las-vegas, a list of options should appear:

usage: las_vegas.py [-h] [-i INPUT] [-o OUTPUT] [-c CHANNELS] [-p PROGRAMS] [-s]

Experimental Prevue Channel (Hollywood) listings parser with XMLTV.

optional arguments:
  -h, --help            show this help message and exit
  -i INPUT, --input INPUT
                        XMLTV formatted XML file
  -o OUTPUT, --output OUTPUT
                        output SQL file. defaults to the same directory as XMLTV file
  -c CHANNELS, --channels CHANNELS
                        maximum number of channels to parse. (default is null)
  -p PROGRAMS, --programs PROGRAMS
                        maximum number of programs to parse per channel. (default is null)
  -s, --start           skip programs starting/airing before now

The following command will generate an SQL query for all programs and channels in the XMLTV file:

las_vegas.py -i (xmltv file) -o (sql query)

If you want to control how many channels you parse, use the --channels/-c option followed by the amount of channels you want to be parsed:

las_vegas.py -i (xmltv file) -o (sql query) -c 50

Injecting the query into the database

See Populating with current listings under the Hollywood VMware guide for further instructions.

Return to the index