-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathQ1.py
More file actions
28 lines (25 loc) · 714 Bytes
/
Copy pathQ1.py
File metadata and controls
28 lines (25 loc) · 714 Bytes
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
import psycopg2, sys, os
f = open('./player.txt','r')
name = f.read()
#name = name + "%" query for like
database = 'flis'
user = 'postgres'
password = '************'
port = '5432'
host = 'localhost'
conn = None
try:
conn = psycopg2.connect(database=database,user=user,password=password,port=port,host=host)
cur = conn.cursor()
cur.execute("select name from players where name =%s",(name,))
#query for is Like :
# cur.execute("select name from players where name like %s ",(name,))
result = cur.fetchall()
for i in result:
print(i[0])
cur.close()
except(Exception,psycopg2.DatabaseError) as error:
print(error)
finally:
if conn is not None:
conn.close()