general_processes_v090_sql.json

Thomas Gumbricht bio photo By Thomas Gumbricht

jsonsql/general processes (setup_db)

Install tables for handling paths and processes

The json command file general_processes_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": "rootprocesses",
        "command": [
          "rootprocid TEXT",
          "title varchar(128)",
          "label varchar(255)",
          "creator varchar(32)",
          "PRIMARY KEY (rootprocid)"
        ]
      }
    },
    {
      "processid": "createtable",
      "overwrite": false,
      "delete": false,
      "parameters": {
        "db": "karttur",
        "schema": "process",
        "table": "subprocesses",
        "command": [
          "rootprocid TEXT",
          "subprocid TEXT",
          "version varchar(16)",
          "minuserstratum integer",
          "title varchar(128)",
          "label varchar(255)",
          "creator varchar(32)",
          "access varchar(8)",
          "createdate date",
          "PRIMARY KEY (subprocid,version)"
        ]
      }
    },
    {
      "processid": "createtable",
      "overwrite": false,
      "delete": false,
      "parameters": {
        "db": "karttur",
        "schema": "process",
        "table": "procdiv",
        "command": [
          "subprocid TEXT",
          "division varchar(16)",
          "PRIMARY KEY (subprocid,division)"
        ]
      }
    },
    {
      "processid": "createtable",
      "overwrite": false,
      "delete": false,
      "parameters": {
        "db": "karttur",
        "schema": "process",
        "table": "procsys",
        "command": [
          "subprocid TEXT",
          "system varchar(16)",
          "srcsystem varchar(16)",
          "dstsystem varchar(16)",
          "srcdivision varchar(16)",
          "dstdivision varchar(16)",
          "srcepsg integer",
          "dstepsg integer",
          "PRIMARY KEY (subprocid,system,srcsystem,dstsystem,srcdivision,dstdivision)"
        ]
      }
    },
    {
      "processid": "createtable",
      "overwrite": false,
      "delete": false,
      "parameters": {
        "db": "karttur",
        "schema": "process",
        "table": "processparams",
        "command": [
          "rootprocid TEXT",
          "subprocid TEXT",
          "version varchar(16)",
          "parent varchar(32)",
          "element varchar(32)",
          "paramid varchar(32)",
          "paramtyp varchar(8)",
          "required BOOL",
          "defaultvalue varchar(32)",
          "hint varchar(255)",
          "bandid varchar(32) DEFAULT 'False'",
          "PRIMARY KEY (subprocid,version,parent,element,paramid,defaultvalue,bandid)"
        ]
      }
    },
    {
      "processid": "createtable",
      "overwrite": false,
      "delete": false,
      "parameters": {
        "db": "karttur",
        "schema": "process",
        "table": "processparamsetvalues",
        "command": [
          "rootprocid TEXT",
          "subprocid TEXT",
          "version varchar(16)",
          "parent varchar(32)",
          "element varchar(32)",
          "paramid varchar(32)",
          "value varchar(32)",
          "label varchar(128)",
          "PRIMARY KEY (subprocid,version,parent, element,paramid,value)"
        ]
      }
    },
    {
      "processid": "createtable",
      "overwrite": false,
      "delete": false,
      "parameters": {
        "db": "karttur",
        "schema": "process",
        "table": "processparamsetminmax",
        "command": [
          "rootprocid TEXT",
          "subprocid TEXT",
          "version varchar(16)",
          "parent varchar(32)",
          "element varchar(32)",
          "paramid varchar(32)",
          "minval real",
          "maxval real",
          "PRIMARY KEY (subprocid,version,parent,element,paramid)"
        ]
      }
    }
  ]
}