Roster of a Team

A team's name is given in the input file (the whole file content, stripped, is that name).

List every player who belongs to that team. For each player print, in this exact order:

1. player name
2. jersey number
3. team name
4. team playground

Join the players and teams tables on team_id, keeping only rows whose team name equals the input value.

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

---

Database: FLIS

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