A team's name is given in the input file (the whole file content, stripped, is that name).
For every match hosted by that team that has a referee assignment, report the assignment. Print, in this exact order:
Join matches to teams on the host team id, and to match_referees on match number, keeping only matches whose host team name equals the input value.
Output one row per line, columns separated by a single space, ordered by match date ascending, then match number ascending.
Note: Do not hard-code the database name — your program is run against a different database instance for evaluation. The input file is in the same folder as your program.
For the database connection, use these variables:
database = sys.argv[1] # database name, from the command line
user = os.environ.get('PGUSER')
password = os.environ.get('PGPASSWORD')
host = os.environ.get('PGHOST')
port = os.environ.get('PGPORT')
The input is a file named team.txt in the same folder — A single line holding a team name, e.g. Vindhya..
primary keyforeign keyarrow points to the referenced columndrag to pan