Innov-AI     Services     Supporters     Contact     About    
CM

Here you can manage connections.

cm set mentdbcm set as400cm set db2cm set derby_embeddedcm set derby_servercm set firebirdcm set h2_embeddedcm set h2_servercm set hsql_embeddedcm set hsql_servercm set mysqlcm set oraclecm set postgresqlcm set sqlservercm set filecm set ftpcm set ftpscm set sftpcm set sshcm set cifscm set smtpcm set pop3cm set imapcm show_scrudcm showcm show_objcm getcm generate_updatecm existcm remove

cm set mentdb <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_mentdb" {execute "mentdb.remote.config.get"
	"[hostname]" "localhost"
	"[port]" "9998"
	"[key]" "pwd"
	"[user]" "admin"
	"[password]" "pwd"
	"[connectTimeout]" "10000"
	"[readTimeout]" "30000"
	"[subTunnels]" (mql {

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

})
;};
mentdb
1

cm set as400 <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_as400" {execute "db.as400.config.get"
	"[hostname]" "localhost"
	"[port]" "8471"
	"[database]" "test_db"
	"[user]" "bob"
	"[password]" "pwd"
;};
mentdb
1

cm set db2 <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_db2" {execute "db.db2.config.get"
	"[hostname]" "localhost"
	"[port]" "50000"
	"[database]" "test_db"
	"[user]" "db2admin"
	"[password]" "pwd"
;};
mentdb
1

cm set derby_embedded <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_derby_embedded" {execute "db.derby.embedded.config.get"
	"[database]" "test_db"
	"[user]" "sa"
	"[password]" "sa"
;};
mentdb
1

cm set derby_server <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_derby_server" {execute "db.derby.server.config.get"
	"[hostname]" "localhost, 127.0.0.1"
	"[port]" "1527"
	"[database]" "test_db"
	"[user]" "sa"
	"[password]" "sa"
;};
mentdb
1

cm set firebird <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_firebird" {execute "db.firebird.config.get"
	"[hostname]" "localhost"
	"[port]" "3050"
	"[database]" "test_db"
	"[user]" "SYSDBA"
	"[password]" "masterkey"
;};
mentdb
1

cm set h2_embedded <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_h2_embedded" {execute "db.h2.embedded.config.get"
	"[database]" "dir/test_db"
	"[user]" "sa"
	"[password]" "sa"
;};
mentdb
1

cm set h2_server <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_h2_server" {execute "db.h2.server.config.get"
	"[hostname]" "localhost, 127.0.0.1"
	"[port]" "9091"
	"[database]" "test_db"
	"[user]" "sa"
	"[password]" "sa"
;};
mentdb
1

cm set hsql_embedded <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_hsql_embedded" {execute "db.hsql.embedded.config.get"
	"[database]" "test_db"
	"[user]" "SA"
	"[password]" "SA"
;};
mentdb
1

cm set hsql_server <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_hsql_server" {execute "db.hsql.server.config.get"
	"[hostname]" "localhost, 127.0.0.1"
	"[port]" "9001"
	"[database]" "test_db"
	"[user]" "SA"
	"[password]" "SA"
;};
mentdb
1

cm set mysql <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_mysql" {execute "db.mysql.config.get"
	"[hostname]" "localhost"
	"[port]" "3306"
	"[database]" "test_db"
	"[user]" "bob"
	"[password]" "pwd"
;};
mentdb
1

cm set oracle <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_oracle" {execute "db.oracle.config.get"
	"[hostname]" "localhost"
	"[port]" "1521"
	"[database]" "xe"
	"[user]" "sys"
	"[password]" "pwd"
;};
mentdb
1

cm set postgresql <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_postgresql" {execute "db.postgresql.config.get"
	"[hostname]" "localhost"
	"[port]" "5432"
	"[database]" "test_db"
	"[user]" "postgres"
	"[password]" "pwd"
;};
mentdb
1

cm set sqlserver <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_sqlserver" {execute "db.sqlserver.config.get"
	"[hostname]" "localhost"
	"[port]" "1195"
	"[user]" "sa"
	"[password]" "pwd"
;};
mentdb
1

cm set file <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_file" {execute "file.local.config.get"
	"[dir]" "/Users/jimmitry/Desktop"
;};
mentdb
1

cm set ftp <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_ftp" {execute "file.remote.ftp.config.get"
	"[hostname]" "localhost"
	"[port]" "21"
	"[user]" "bob"
	"[password]" "pwd"
;};
mentdb
1

cm set ftps <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_ftps" {execute "file.remote.ftps.config.get"
	"[hostname]" "localhost"
	"[port]" "21"
	"[user]" "bob"
	"[password]" "pwd"
	"[protocol]" "TLS"
	"[isImplicit]" false
	"[connectTimeout]" 10000
	"[dataTimeout]" 30000
	"[keepAliveTimeout]" 300
;};
mentdb
1

cm set sftp <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_sftp" {execute "file.remote.sftp.config.get"
	"[hostname]" "localhost"
	"[port]" "22"
	"[user]" "bob"
	"[password]" "pwd"
	"[connectTimeout]" 10000
	"[dataTimeout]" 30000
;};
mentdb
1

cm set ssh <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_ssh" {execute "file.remote.ssh.config.get"
	"[hostname]" "localhost"
	"[port]" "22"
	"[user]" "bob"
	"[password]" "pwd"
	"[connectTimeout]" 10000
;};
mentdb
1

cm set cifs <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_cifs" {execute "file.remote.cifs.config.get"
	"[hostname]" "192.168.220.130"
	"[port]" "445"
	"[domain]" "domain"
	"[user]" "bob"
	"[password]" "pwd"
	"[connectTimeout]" "10000"
	"[readTimeout]" "30000"
;};
mentdb
1

cm set smtp <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_smtp" {execute "mail.smtp.config.get"
	"[hostname]" "smtp.gmail.com"
	"[port]" "465"
	"[sender]" "your-account@gmail.com"
	"[user]" "your-account@gmail.com"
	"[password]" "pwd"
	"[authentication]" true
	"[tls]" true
	"[connectTimeout]" "10000"
	"[sessionTimeout]" "60000"
;};
mentdb
1

cm set pop3 <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_pop3" {execute "mail.pop3.config.get"
	"[hostname]" "pop.gmail.com"
	"[port]" "995"
	"[user]" "your-account@gmail.com"
	"[password]" "pwd"
	"[tls]" false
	"[ssl]" true
	"[connectTimeout]" "10000"
	"[sessionTimeout]" "60000"
;};
mentdb
1

cm set imap <key> <object>

Description

    Set a connection

Parameters

    key:   The key - string - required
    object:   The JSON object - string - required
admin
cm set "demo_cm_imap" {execute "mail.imap.config.get"
	"[hostname]" "imap.gmail.com"
	"[port]" "993"
	"[user]" "your-account@gmail.com"
	"[password]" "pwd"
	"[auth]" false
	"[tls]" false
	"[ssl]" true
	"[connectTimeout]" "10000"
	"[sessionTimeout]" "60000"
;};
mentdb
1

cm show_scrud

Description

    Show all database connections for scrud operation (only MySQL or H2)

admin
cm show_scrud;
mentdb
[<br>  "MENTDB"<br>]

cm show <type>

Description

    Show all connections

Parameters

    type:   The connection type (db|file|cifs|ftp|ftps|sftp|ssh|imap|pop3|smtp|mentdb) - string - not required
admin
cm show;
mentdb
[<br>  "demo_cm_as400",<br>  "demo_cm_cifs",<br>  "demo_cm_db2",<br>  "demo_cm_derby_embedded",<br>  "demo_cm_derby_server",<br>  "demo_cm_file",<br>  "demo_cm_firebird",<br>  "demo_cm_ftp",<br>  "demo_cm_ftps",<br>  "demo_cm_h2_embedded",<br>  "demo_cm_h2_server",<br>  "demo_cm_hsql_embedded",<br>  "demo_cm_hsql_server",<br>  "demo_cm_imap",<br>  "demo_cm_mentdb",<br>  "demo_cm_mysql",<br>  "demo_cm_oracle",<br>  "demo_cm_pop3",<br>  "demo_cm_postgresql",<br>  "demo_cm_sftp",<br>  "demo_cm_smtp",<br>  "demo_cm_ssh"<br>]

cm show_obj <type>

Description

    Show all connections into a JSON object

Parameters

    type:   The connection type (db|file|cifs|ftp|ftps|sftp|ssh|imap|pop3|smtp|mentdb) - string - not required
admin
cm show_obj;
mentdb
{<br>  "demo_cm_as400":0,<br>  "demo_cm_cifs":0,<br>  "demo_cm_db2":0,<br>  "demo_cm_derby_embedded":0,<br>  "demo_cm_derby_server":0,<br>  "demo_cm_file":0,<br>  "demo_cm_firebird":0,<br>  "demo_cm_ftp":0,<br>  "demo_cm_ftps":0,<br>  "demo_cm_h2_embedded":0,<br>  "demo_cm_h2_server":0,<br>  "demo_cm_hsql_embedded":0,<br>  "demo_cm_hsql_server":0,<br>  "demo_cm_imap":0,<br>  "demo_cm_mentdb":0,<br>  "demo_cm_mysql":0,<br>  "demo_cm_oracle":0,<br>  "demo_cm_pop3":0,<br>  "demo_cm_postgresql":0,<br>  "demo_cm_sftp":0,<br>  "demo_cm_smtp":0,<br>  "demo_cm_ssh":0<br>}

cm get <key>

Description

    Get a connection

Parameters

    key:   The key - string - required
admin
cm get "demo_cm_mysql";
mentdb
{<br>  "driver": "com.mysql.cj.jdbc.Driver",<br>  "defaultSchema": "test_db",<br>  "subType": "MySQL",<br>  "loginTimeout": "10000",<br>  "jdbc": "jdbc:mysql://localhost:3306/test_db",<br>  "type": "db",<br>  "properties": {<br>    "password": "pwd",<br>    "allowMultiQueries": "true",<br>    "user": "bob"<br>  }<br>}

cm generate_update <key>

Description

    Update a connection

Parameters

    key:   The key - string - required
admin
cm generate_update "demo_cm_mysql";
mentdb
json load "tmpCm" (cm get "demo_cm_mysql");<br>json uobject "tmpCm" / "driver" "com.mysql.cj.jdbc.Driver" STR;<br>json uobject "tmpCm" / "defaultSchema" "test_db" STR;<br>json uobject "tmpCm" / "subType" "MySQL" STR;<br>json uobject "tmpCm" / "loginTimeout" "10000" STR;<br>json uobject "tmpCm" / "jdbc" "jdbc:mysql://localhost:3306/test_db" STR;<br>json uobject "tmpCm" / "type" "db" STR;<br>json uobject "tmpCm" /properties "password" "pwd" STR;<br>json uobject "tmpCm" /properties "allowMultiQueries" "true" STR;<br>json uobject "tmpCm" /properties "user" "bob" STR;<br>cm set "demo_cm_mysql" {json doc "tmpCm"};

cm exist <key> <type>

Description

    Check if a connection id already exist

Parameters

    key:   The key - string - required
    type:   The connection type (db|file|cifs|ftp|ftps|sftp|ssh|imap|pop3|smtp|mentdb) - string - not required
admin
cm exist "demo_cm_mysql"
mentdb
1

cm remove <key>

Description

    Remove a connection

Parameters

    key:   The key - string - required
admin
cm remove "demo_cm_mysql";
mentdb
1




© 2012 - 2023