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'