view psql_test.py @ 0:6895de35a263 draft

planemo upload commit 844a891e4eaf732830043204ac636907eefb011d-dirty

import psycopg2, os

os.system('source /nfs/sw/apps/galaxy-dev/galaxy/.venv/bin/activate')

connection = psycopg2.connect(database="galaxy", user="galaxy", host="galaxydev.cvkyaz9id4ml.us-east-1.rds.amazonaws.com", password="cF$cl0udh9c", port="5432")
print "monkey made a connection!" 

worker = connection.cursor()
worker.execute('SELECT name FROM library_dataset_dataset_association WHERE dataset_id = 4;')
result = worker.fetchall()
print result, '4'

worker = connection.cursor()
worker.execute('SELECT name FROM library_dataset_dataset_association WHERE dataset_id = 10;')
result = worker.fetchall()
print result, '10'

worker = connection.cursor()
worker.execute('SELECT name FROM library_dataset_dataset_association WHERE dataset_id = 11;')
result = worker.fetchall()
print result, '11'

worker = connection.cursor()
worker.execute('SELECT name FROM library_dataset_dataset_association WHERE dataset_id = 18;')
result = worker.fetchall()
print result, '18'