Difference between revisions of "Add Tools18 module"

From DISI
Jump to: navigation, search
(Add job type into psql table)
(Creating Template)
Line 2: Line 2:
 
=== Scripts ===
 
=== Scripts ===
 
=== Creating Template ===
 
=== Creating Template ===
 +
This is recommend that you go though all the currently existing modules on [http://tools18.docking.org/start Tools18] and reuse instead of starting one from scratch.
 +
 
=== Add job type into psql table ===
 
=== Add job type into psql table ===
 
*Access the database
 
*Access the database

Revision as of 16:46, 21 March 2019

Here is quick guide to add your script into Tools18 interface

Scripts

Creating Template

This is recommend that you go though all the currently existing modules on Tools18 and reuse instead of starting one from scratch.

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!