search

SeqWare / seqware

This is the SeqWare Project's main repo.
http://seqware.io/
GNU General Public License v3.0
27 stars 17 forks source link

Store SGE job names and SGE ids in workflow runs #338

Closed denis-yuen closed 8 years ago

denis-yuen commented 8 years ago

Format of new column is as follows:

test_seqware_meta_db=# select wr.sw_accession, wr.sge_name_id_map from workflow_run wr where wr.sge_name_id_map IS NOT NULL order by sw_accession desc;
 sw_accession |                                                                                                           sge_name_id_map                                                                                                           
--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
         7084 | s7084_start_0=104,s7084_pfi_file_in_0_1=105,s7084_bash_mkdir_2=106,s7084_bash_cp_3=107,s7084_bash_cp_4=108,s7084_bash_cp_5=109,s7084_bash_cp_6=110,s7084_pfo_bash_cp_7_b0=111,s7084_pfo_bash_cp_8_b0=112,s7084_pfo_bash_cp_9_b0=113
         7044 | s7044_start_0=84,s7044_pfi_file_in_0_1=85,s7044_bash_mkdir_2=86,s7044_bash_cp_3=87,s7044_bash_cp_4=88,s7044_bash_cp_5=89,s7044_bash_cp_6=90,s7044_pfo_bash_cp_7_b0=91,s7044_pfo_bash_cp_8_b0=92,s7044_pfo_bash_cp_9_b0=93

or 

test_seqware_meta_db=# select wr.sw_accession, regexp_split_to_table(wr.sge_name_id_map, ',') from workflow_run wr order by sw_accession desc;
 sw_accession |   regexp_split_to_table    
--------------+----------------------------
         7084 | s7084_start_0=104
         7084 | s7084_pfi_file_in_0_1=105
         7084 | s7084_bash_mkdir_2=106
         7084 | s7084_bash_cp_3=107
         7084 | s7084_bash_cp_4=108
         7084 | s7084_bash_cp_5=109
         7084 | s7084_bash_cp_6=110
         7084 | s7084_pfo_bash_cp_7_b0=111
         7084 | s7084_pfo_bash_cp_8_b0=112
         7084 | s7084_pfo_bash_cp_9_b0=113
         7044 | s7044_start_0=84
         7044 | s7044_pfi_file_in_0_1=85
         7044 | s7044_bash_mkdir_2=86
         7044 | s7044_bash_cp_3=87
         7044 | s7044_bash_cp_4=88
         7044 | s7044_bash_cp_5=89
         7044 | s7044_bash_cp_6=90
         7044 | s7044_pfo_bash_cp_7_b0=91
         7044 | s7044_pfo_bash_cp_8_b0=92
         7044 | s7044_pfo_bash_cp_9_b0=93
(20 rows)