From fb57f05083b0512b7bb9f9e15b6cc6efaded5a1f Mon Sep 17 00:00:00 2001
From: Pjotr Prins
Date: Tue, 3 Apr 2018 07:50:28 +0000
Subject: @acenteno added data upload scripts into main repo

---
 .../Update_Case_Attributes_MySQL_tab.py            | 27 ++++++++++++++++++++++
 1 file changed, 27 insertions(+)
 create mode 100644 scripts/maintenance/Update_Case_Attributes_MySQL_tab.py

(limited to 'scripts/maintenance/Update_Case_Attributes_MySQL_tab.py')

diff --git a/scripts/maintenance/Update_Case_Attributes_MySQL_tab.py b/scripts/maintenance/Update_Case_Attributes_MySQL_tab.py
new file mode 100644
index 00000000..0f8602c9
--- /dev/null
+++ b/scripts/maintenance/Update_Case_Attributes_MySQL_tab.py
@@ -0,0 +1,27 @@
+#!/usr/bin/python2
+########################################################################
+# Last Updated Apr 11, 2016 By Arthur and Zach
+########################################################################
+import string
+import sys
+import MySQLdb
+import getpass
+import time
+import csv
+########################################################################
+
+mydb = MySQLdb.connect(host='localhost',
+    user='username',
+    passwd='',
+    db='db_webqtl')
+cursor = mydb.cursor()
+
+csv_data = csv.reader(file('GN711_pvalues.txt'), delimiter ="\t")
+for row in csv_data:
+
+    cursor.execute("""UPDATE ProbeSetXRef SET pValue = %s WHERE ProbeSetFreezeId = %s AND ProbeSetId = %s """,
+          (row))
+#close the connection to the database.
+mydb.commit()
+cursor.close()
+print "Done"
\ No newline at end of file
-- 
cgit v1.2.3