scripts/migrate_to_lane_table.py

   1 #!/usr/bin/env python
   2
   3 from htsworkflow.frontend.experiments.models import FlowCell, Lane
   4
   5
   6 if __name__ == '__main__':
   7
   8     print "Migration starting..."
   9
  10     #Get all flowcells
  11     for flowcell in FlowCell.objects.all():
  12
  13         ##################
  14         # Lane 1
  15         lane1 = Lane()
  16
  17         # ForeignKey Links
  18         lane1.flowcell = flowcell
  19         lane1.library = flowcell.lane_1_library
  20
  21         # Meta Data
  22         lane1.lane_number = 1
  23         lane1.pM = flowcell.lane_1_pM
  24         lane1.cluster_estimate = flowcell.lane_1_cluster_estimate
  25
  26         # Save
  27         lane1.save()
  28
  29         ##################
  30         # Lane 2
  31         lane2 = Lane()
  32
  33         # ForeignKey Links
  34         lane2.flowcell = flowcell
  35         lane2.library = flowcell.lane_2_library
  36
  37         # Meta Data
  38         lane2.lane_number = 2
  39         lane2.pM = flowcell.lane_2_pM
  40         lane2.cluster_estimate = flowcell.lane_2_cluster_estimate
  41
  42         # Save
  43         lane2.save()
  44
  45         ##################
  46         # Lane 3
  47         lane3 = Lane()
  48
  49         # ForeignKey Links
  50         lane3.flowcell = flowcell
  51         lane3.library = flowcell.lane_3_library
  52
  53         # Meta Data
  54         lane3.lane_number = 3
  55         lane3.pM = flowcell.lane_3_pM
  56         lane3.cluster_estimate = flowcell.lane_3_cluster_estimate
  57
  58         # Save
  59         lane3.save()
  60
  61         ##################
  62         # Lane 4
  63         lane4 = Lane()
  64
  65         # ForeignKey Links
  66         lane4.flowcell = flowcell
  67         lane4.library = flowcell.lane_4_library
  68
  69         # Meta Data
  70         lane4.lane_number = 4
  71         lane4.pM = flowcell.lane_4_pM
  72         lane4.cluster_estimate = flowcell.lane_4_cluster_estimate
  73
  74         # Save
  75         lane4.save()
  76
  77         ##################
  78         # Lane 5
  79         lane5 = Lane()
  80
  81         # ForeignKey Links
  82         lane5.flowcell = flowcell
  83         lane5.library = flowcell.lane_5_library
  84
  85         # Meta Data
  86         lane5.lane_number = 5
  87         lane5.pM = flowcell.lane_5_pM
  88         lane5.cluster_estimate = flowcell.lane_5_cluster_estimate
  89
  90         # Save
  91         lane5.save()
  92
  93         ##################
  94         # Lane 6
  95         lane6 = Lane()
  96
  97         # ForeignKey Links
  98         lane6.flowcell = flowcell
  99         lane6.library = flowcell.lane_6_library
 100
 101         # Meta Data
 102         lane6.lane_number = 6
 103         lane6.pM = flowcell.lane_6_pM
 104         lane6.cluster_estimate = flowcell.lane_6_cluster_estimate
 105
 106         # Save
 107         lane6.save()
 108
 109         ##################
 110         # Lane 7
 111         lane7 = Lane()
 112
 113         # ForeignKey Links
 114         lane7.flowcell = flowcell
 115         lane7.library = flowcell.lane_7_library
 116
 117         # Meta Data
 118         lane7.lane_number = 7
 119         lane7.pM = flowcell.lane_7_pM
 120         lane7.cluster_estimate = flowcell.lane_7_cluster_estimate
 121
 122         # Save
 123         lane7.save()
 124
 125         ##################
 126         # Lane 8
 127         lane8 = Lane()
 128
 129         # ForeignKey Links
 130         lane8.flowcell = flowcell
 131         lane8.library = flowcell.lane_8_library
 132
 133         # Meta Data
 134         lane8.lane_number = 8
 135         lane8.pM = flowcell.lane_8_pM
 136         lane8.cluster_estimate = flowcell.lane_8_cluster_estimate
 137
 138         # Save
 139         lane8.save()
 140
 141     print "Migration Complete."