Difference between revisions of "Add Tools18 module"

From DISI
Jump to: navigation, search
(Created page with "Here is quick guide to add your script into Tools18 interface === Scripts === === Creating Template === === Add job type into psql table === === Test run! ===")
 
(Add job type into psql table)
Line 3: Line 3:
 
=== Creating Template ===
 
=== Creating Template ===
 
=== Add job type into psql table ===
 
=== Add job type into psql table ===
 +
*Access the database
 +
$ psql -h mem blaster blasteruser
 +
 +
*Look for the next available index on job_types table
 +
blaster=> select * from job_types order by job_type_id;
 +
You will see table like this
 +
  job_type_id |        last_updated        |    short_name   
 +
-------------+----------------------------+-------------------
 +
            1 | 2018-10-05 00:00:00        | analog
 +
            2 | 2018-10-05 00:00:00        | blaster
 +
            3 | 2018-10-05 00:00:00        | blasterpdb
 +
            4 | 2018-10-05 00:00:00        | build2d
 +
            5 | 2018-10-05 00:00:00        | build3d
 +
            6 | 2018-10-05 00:00:00        | cluster
 +
            7 | 2018-10-05 00:00:00        | covalent
 +
            8 | 2018-10-05 00:00:00        | dude
 +
            9 | 2018-10-05 00:00:00        | libanalysis
 +
          10 | 2018-10-05 00:00:00        | reaction
 +
          11 | 2018-10-05 00:00:00        | sea
 +
          12 | 2018-10-05 00:00:00        | threec
 +
          13 | 2018-10-05 00:00:00        | transform
 +
          14 | 2018-10-05 00:00:00        | zincbatch
 +
          15 | 2018-12-01 18:47:34        | cluster_molecules
 +
 +
* Insert new job type (Please be extra careful when doing this step)
 +
'''This is important to start command with 'begin;' so that if any syntax mistakes could be undo.'''
 +
blaster=> begin; insert into job_types values(<next_available_id>, now(), '<your_job_name>');
 +
Example:
 +
blaster=> begin; insert into job_types values(16, now(), 'shape');
 +
 
=== Test run! ===
 
=== Test run! ===

Revision as of 16:38, 21 March 2019

Here is quick guide to add your script into Tools18 interface

Scripts

Creating Template

Add job type into psql table

  • Access the database
$ psql -h mem blaster blasteruser
  • Look for the next available index on job_types table
blaster=> select * from job_types order by job_type_id;
You will see table like this
 job_type_id |        last_updated        |    short_name     
-------------+----------------------------+-------------------
           1 | 2018-10-05 00:00:00        | analog
           2 | 2018-10-05 00:00:00        | blaster
           3 | 2018-10-05 00:00:00        | blasterpdb
           4 | 2018-10-05 00:00:00        | build2d
           5 | 2018-10-05 00:00:00        | build3d
           6 | 2018-10-05 00:00:00        | cluster
           7 | 2018-10-05 00:00:00        | covalent
           8 | 2018-10-05 00:00:00        | dude
           9 | 2018-10-05 00:00:00        | libanalysis
          10 | 2018-10-05 00:00:00        | reaction
          11 | 2018-10-05 00:00:00        | sea
          12 | 2018-10-05 00:00:00        | threec
          13 | 2018-10-05 00:00:00        | transform
          14 | 2018-10-05 00:00:00        | zincbatch
          15 | 2018-12-01 18:47:34        | cluster_molecules
  • Insert new job type (Please be extra careful when doing this step)
This is important to start command with 'begin;' so that if any syntax mistakes could be undo.
blaster=> begin; insert into job_types values(<next_available_id>, now(), '<your_job_name>');
Example: 
blaster=> begin; insert into job_types values(16, now(), 'shape');

Test run!