Python Operations PostgreSQL Database

	1 import psycopg2 as pg2



	  2



	  3 # Return to database PostgreSQL connection



	  4 def get_db_conn ():



	  5 # Create connection



	  6 return pg2.connect (database = ‘test’, user = ‘admin’, password = ‘admin’, host = ‘127.0.0.1’, port = ‘10001’)



	  8



	  9



	10 # Operate the database PostgreSQL and return a result



	11 def db_fetchone (sql):



	12 try:



	13 conn = get_db_conn ()



	14 cur = conn.cursor ()



	15 cur.execute (sql)



	16 rows = cur.fetchone () # return one result, return multiple results using rows = cur.fetchall ()



	17



	18 return rows [0]



	19 except pg2.DatabaseError as e:



	20 print (‘Error $ s’% e)



	twenty one



	22 finally:



	23 conn.commit ()



	24 cur.close ()



	25 conn.close ()

Python Operations PostgreSQL Database