Add Tools18 module: Difference between revisions
Jump to navigation
Jump to 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! ===") |
|||
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 23: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');