Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import psycopg2
- # Connecting to database.
- try:
- connect = psycopg2.connect(database='fn1132_2017', user='student', host='195.19.32.74', password='bmstu')
- cursor = connect.cursor()
- except:
- print("Unable connect to database.")
- exit(100)
- program_run = True
- query = ""
- while program_run:
- print("Please enter your command or EXIT to leave program:")
- query = input()
- if query == "EXIT":
- program_run = False
- else:
- try:
- cursor.execute(query)
- connect.commit()
- except:
- print("Bad query.")
- finally:
- if "select" in query.lower():
- try:
- for row in cursor:
- print(row)
- except:
- print("No data to print.")
- connect.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement