comparison psql_test.py @ 2:381e1e7109fc draft default tip

planemo upload commit 464b391afaa5819bc681452e85bea9d882730eb6-dirty

1:139f1e77d834

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'