jsonsql/general processeschain (setup_db)
Install the automated processing chains tables
The json command file general_processeschain_v090_sql.json is part of karttur’s GeoImagine project setup_db. Calling the json file will execute the following commands of the GeoImagine Framework.
{
"process": [
{
"processid": "createtable",
"overwrite": false,
"delete": false,
"parameters": {
"db": "karttur",
"schema": "process",
"table": "prcesschain",
"command": [
"chainid TEXT",
"title TEXT",
"label TEXT",
"creator varchar(32)",
"owner varchar(32)",
"sharing varchar(8)",
"createdate date",
"PRIMARY KEY (chainid)"
]
}
},
{
"processid": "createtable",
"overwrite": false,
"delete": false,
"parameters": {
"db": "karttur",
"schema": "process",
"table": "chainprocess",
"command": [
"chainid TEXT",
"chainstep smallint",
"subprocid TEXT",
"version varchar(16)",
"PRIMARY KEY (chainid,chainstep,subprocid)"
]
}
},
{
"processid": "createtable",
"overwrite": false,
"delete": false,
"parameters": {
"db": "karttur",
"schema": "process",
"table": "chaincompin",
"command": [
"chainid TEXT",
"chainstep smallint",
"compid varchar(16)",
"suffix varchar(64)",
"PRIMARY KEY (chainid,chainstep,compid,suffix)"
]
}
},
{
"processid": "createtable",
"overwrite": false,
"delete": false,
"parameters": {
"db": "karttur",
"schema": "process",
"table": "chainparams",
"command": [
"chainid TEXT",
"chainstep smallint",
"parameter varchar(32)",
"value varchar(64)",
"PRIMARY KEY (chainid,chainstep,parameter,value)"
]
}
},
{
"processid": "createtable",
"overwrite": false,
"delete": false,
"parameters": {
"db": "karttur",
"schema": "process",
"table": "chaincompout",
"command": [
"chainid TEXT",
"chainstep smallint",
"compid varchar(16)",
"suffix varchar(64)",
"cellnull integer",
"celltype varchar(8)",
"scalefac real",
"offsetadd integer",
"dataunit varchar(32)",
"measure char(1)",
"PRIMARY KEY (chainid,chainstep,compid,suffix)"
]
}
}
]
}