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 98772b030c57639e0f51fdf4559a09267d84adb1..7a755f6f8df1836cad5488ba87192cb420fc8259 100644 (file)
--- 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__":