MentDB  Mentalese Database Engine
Strong AI, Weak AI, Interoperability and Software Development
    Home  >  MQL Functions
Stack

Here you can execute a script with delay.

stack <exeDate> <scriptName> <varName1> <varlue1> <varNameN> <varlueN>

Description

    To execute a script into the stack

Parameters

    exeDate:   The execution date - string - required
    scriptName:   The script name - string - required
    varName1:   The variable name 1 - string - not required
    varlue1:   The value 1 - string - not required
    varNameN:   The variable name N - string - not required
    varlueN:   The value N - string - not required
admin
stack (date now) "division.post" "[v1]" 10 "[v2]" 5
mentdb
2a

stack process

Description

    Process to execute the stack

admin
stack process
mentdb
1

stack process_limit

Description

    Show the stack config process limit.

admin
stack process_limit
mentdb
4

stack count_wait

Description

    Count all waiting execution in the stack.

admin
stack count_wait
mentdb
2

stack count_running

Description

    Count all running execution in the stack.

admin
stack count_running
mentdb
4

stack count_closed

Description

    Count all closed execution in the stack.

admin
stack count_closed
mentdb
406

stack count_error

Description

    Count all error execution in the stack.

admin
stack count_error
mentdb
122

stack delete_wait_id <pid>

Description

    Delete a specific execution (wait).

Parameters

    pid:   The process id - number - required
admin
stack delete_wait_id 4
mentdb
1

stack delete_wait_script <scriptName>

Description

    Delete all executions for a specific script (wait).

Parameters

    scriptName:   The script name - string - required
admin
stack delete_wait_script "division.post"
mentdb
25

stack delete_closed_id <pid>

Description

    Delete a specific execution (closed).

Parameters

    pid:   The process id - number - required
admin
stack delete_closed_id 4
mentdb
1

stack delete_closed_script <scriptName>

Description

    Delete all executions for a specific script (closed).

Parameters

    scriptName:   The script name - string - required
admin
stack delete_closed_script "division.post"
mentdb
25

stack delete_error_id <pid>

Description

    Delete a specific execution (error).

Parameters

    pid:   The process id - number - required
admin
stack delete_error_id 4
mentdb
1

stack delete_error_script <scriptName>

Description

    Delete all executions for a specific script (error).

Parameters

    scriptName:   The script name - string - required
admin
stack delete_error_script "division.post"
mentdb
10

stack reset_error_nbattempt_id <pid>

Description

    Reset the number of attempt (error).

Parameters

    pid:   The process id - number - required
admin
stack reset_error_nbattempt_id 4
mentdb
1

stack reset_error_nbattempt_script <scriptName>

Description

    Reset the number of attempt (error).

Parameters

    scriptName:   The script name - string - required
admin
stack reset_error_nbattempt_script "division.post"
mentdb
1

stack replay_error_id <pid>

Description

    Replay a specific execution (error).

Parameters

    pid:   The process id - number - required
admin
stack replay_error_id 4
mentdb
1

stack replay_error_script <scriptName>

Description

    Replay all executions for a specific script (error).

Parameters

    scriptName:   The script name - string - required
admin
stack replay_error_script "division.post"
mentdb
7

stack get <pid>

Description

    To show a specific execution (with variables).

Parameters

    pid:   The process id - number - required
admin
stack get 4
mentdb
{ "lastattempt": "2018-01-04 10:39:17.0", "dtcreate": "2018-01-04 10:32:07.0", "nbattempt": "1", "dtclosed": null, "dtexe": "2018-01-04 10:32:07.0", "pid": "17", "login": "admin", "script": "addition.post", "dterror": "2018-01-04 10:39:17.0", "nbmaxattempt": "1", "lasterrormsg": "\nline 1 \u003e\u003e\u003e addition.post [v1] 12 [v2] 19 \nline 2 \u003e\u003e\u003e exception 1; \"\\\"your message ...\\\";\" ; 1: your message ..." }
Description

    To search an execution process

Parameters

    tableType:   The table type (wait|running|closed|error) - string - required
    script:   The script (can be null) - string - required
    dtType:   The date type (exe|closed|error|create|lastattempt) - string - required
    dtMin:   The min date - string - required
    dtMax:   The max date - string - required
    dtOrder:   The order (ASC|DESC) - string - required
    page:   The page - number - required
    nbByPage:   The number of line by page - number - required
admin
stack search "error" null "exe" (date datedifft (concat (date sysdate) " 00:00:00") "DAY" 10) (concat (date sysdate) " 23:59:59") ASC 1 5;
mentdb
{"column_types":["STRING","STRING","STRING","STRING","LONG","LONG","STRING","STRING","STRING","STRING","STRING"],"data":[],"columns":["pid","script","dtcreate","lastattempt","nbattempt","nbmaxattempt","dtexe","login","lasterrormsg","dtclosed","dterror"],"title":"stack"}
    Home  >  MQL Functions
MentDB © 2012 - 2019