Manager of a City's Team

A city is given in the input file (the whole file content, stripped, is that city).

Report the manager of the team based in that city. Print, in this exact order:

1. manager name
2. the date the manager has been in charge since (formatted YYYY-MM-DD)
3. team name
4. team city
5. team playground

Join the managers and teams tables on team_id, keeping only the team whose city equals the input value.

Output one row per line, columns separated by a single space, ordered by manager name 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 city.txt in the same folder — A single line holding a city name, e.g. Pune..

---

Database: FLIS

−+Fit
primary keyforeign keyarrow points to the referenced columndrag to pan