diff psql_test.py @ 0:6895de35a263 draft

planemo upload commit 844a891e4eaf732830043204ac636907eefb011d-dirty

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/psql_test.py	Thu Oct 19 18:16:51 2017 -0400
@@ -0,0 +1,26 @@
+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'