Mercurial > repos > charles_s_test > seqsero
diff psql_test.py @ 2:381e1e7109fc draft default tip
planemo upload commit 464b391afaa5819bc681452e85bea9d882730eb6-dirty
author | charles_s_test |
---|---|
date | Sun, 12 Nov 2017 02:26:17 -0500 |
parents | 139f1e77d834 |
children |
line wrap: on
line diff
--- a/psql_test.py Fri Oct 27 17:22:36 2017 -0400 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,26 +0,0 @@ -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'