From: Brandon King <kingb@caltech.edu>
Date: Thu, 20 Aug 2009 21:29:49 +0000 (+0000)
Subject: Update user db when doing update.
X-Git-Tag: 0.3.0~7
X-Git-Url: http://woldlab.caltech.edu/gitweb/?p=htsworkflow.git;a=commitdiff_plain;h=5772b0b0a32a6998157817e965646b0877ee0847

Update user db when doing update.
---

diff --git a/docs/upgrade_v0.2.6_to_v0.3.py b/docs/upgrade_v0.2.6_to_v0.3.py
index 98772b0..7a755f6 100644
--- a/docs/upgrade_v0.2.6_to_v0.3.py
+++ b/docs/upgrade_v0.2.6_to_v0.3.py
@@ -10,6 +10,10 @@ def main(cmdline=None):
     shutil.copy(cmdline[0], dest)
     conn = sqlite3.connect(dest)
     c = conn.cursor()
+    
+    #Copy user id's from auth User to new HTSUser
+    c.execute('INSERT INTO samples_htsuser (user_ptr_id) SELECT id FROM auth_user;')
+    
     c.execute("""CREATE TEMPORARY TABLE experiments_flowcell_temp (
     "id" integer NOT NULL PRIMARY KEY,                                     
     "flowcell_id" varchar(20) NOT NULL UNIQUE,                             
@@ -81,6 +85,7 @@ WHERE id=%(id)d;"""
             c.execute( lane_insert % {'lane': int(lane), 'id': int(pk)} )
             
     c.execute('DROP TABLE experiments_flowcell_temp;')
+    
     conn.commit()
 
 if __name__ == "__main__":