INNOV-AI

Innovation and Research from Réunion Island, France

Back   Home

Generate a MQL query to update a MentDB Weak connection @ CONNECT - Connections @ MentDB Weak

> Start the server
> (or start the server for the first time (embedded mode - H2 Database))
> (or start the server for the first time (remote mode - MySQL 8 Database))
> Open the MentDB Weak Editor

Click on 'CONNECT' tab, open 'MentDB', right click on 'demo_cm_mentdb' and select 'Generate update'

MQL INPUT
json load "tmpCm" "{}";
json iobject "tmpCm" / "subTunnels" "

tunnel execute_hot \"tunnelId1\" {cm get \"demo_cm_mentdb\";} (mql {
	tunnel execute_hot \"tunnelId2\" {cm get \"demo_cm_mentdb\";} (mql {
	
		[MQL_TO_REPLACE]
		
	});
});

" STR;
json iobject "tmpCm" / "hostname" "localhost" STR;
json iobject "tmpCm" / "password" "pwd" STR;
json iobject "tmpCm" / "port" "9998" STR;
json iobject "tmpCm" / "readTimeout" "30000" STR;
json iobject "tmpCm" / "connectTimeout" "10000" STR;
json iobject "tmpCm" / "k" "demo_cm_mentdb" STR;
json iobject "tmpCm" / "type" "mentdb" STR;
json iobject "tmpCm" / "user" "admin" STR;
json iobject "tmpCm" / "mql_users" "[
  \"admin\"
]" STR;
json iobject "tmpCm" / "key" "pwd" STR;
cm set "demo_cm_mentdb" {json doc "tmpCm"};
MQL OUTPUT
"1"
start: 2026-01-17   end: 2026-01-31   v_start: 400   v_end: