-
Notifications
You must be signed in to change notification settings - Fork 1
/
Q1DBMS.py
36 lines (27 loc) · 1.01 KB
/
Q1DBMS.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
#Write a Python program to output the jersey number of the player. Player's name is given in a file named 'player.txt' resides in the same folder as
#python program file.
#The output of the python program is only jersey number.
#For example, if the jersey number of the player is 99. Then output must be 99 only. Note: No spaces.
import sys
import os
import psycopg2
file = open("player.txt", "r")
name = file.read()
try:
connection = psycopg2.connect(
database = sys.argv[1],
user = os.environ.get('PGUSER'),
password = os.environ.get('PGPASSWORD'),
host = os.environ.get('PGHOST'),
port = os.environ.get('PGPORT'))
cursor = connection.cursor()
query = "select jersey_no from players where name = '{}'".format(name)
cursor.execute(query)
result = cursor.fetchall()
for res in result:
print(res[0])
cursor.close()
except(Exception, psycopg2.DatabaseError) as error:
print(error)
finally:
connection.close