MentDB, The digital brain.  About us Home

Back / Mentalese Query Language

1108f - MQL v_2.0.8

Application Manager
AppVirtual host
Service Oriented Architecture
AcceleratorScriptUserGroup
Data transformation
MQL SyntaxData TypeStatementOperatorDateMathStringTypeConstant
Extract and Load
CSVHTMLJSONXMLFile WatcherFileAtomExternal REST APIExternal SOAP APICompressSQLCMTunnelMailFTPFTPSSFTPCIFSSSHExcelExcelxMSWordMSWordxPDFSCRUD
Enterprise Service Bus
StackJob
Analytics
Predictive analysisData quality
Artificial Intelligence
Machine LearningDeep LearningBot
NoSQL Database
SequenceNodeTransactionFile SystemMetricEnvironment variableSessionParameterLogOSServer

App
app createapp showapp is_granted_aapp is_granted_saapp existapp deleteapp webserver restartapp menuapp menu show_app_obj_result_alert_app_obj_bootstrap_col_app_obj_bootstrap_button_app_obj_kpi_app_obj_sparkline_bar_app_obj_sparkline_line_app_obj_sparkline_tristate_app_obj_sparkline_discrete_app_obj_sparkline_bullet_app_obj_sparkline_pie_app_obj_sparkline_box_app_obj_chartjs_bar_vertical_app_obj_chartjs_bar_horizontal_app_obj_chartjs_bar_vertical_stacked_app_obj_chartjs_bar_horizontal_stacked_app_obj_chartjs_doughnut_app_obj_chartjs_pie_app_obj_chartjs_polar_app_obj_chartjs_radar_app_obj_chartjs_line_basic_app_obj_chartjs_line_xy_basic_app_obj_chartjs_line_basic_fill_app_obj_chartjs_line_stepped_before_app_obj_chartjs_line_stepped_after_app_obj_chartjs_line_courbe_app_obj_chartjs_line_courbe_fill_app_obj_chartjs_line_point_app_obj_chartjs_time_basic_month_app_obj_chartjs_time_basic_day_app_obj_chartjs_time_basic_hour_app_obj_chartjs_time_basic_minute_app_obj_gauge_meter_app_obj_progress_bar_app_obj_form_app_obj_form_control_textbox_text_app_obj_form_control_textbox_range_app_obj_form_control_textbox_number_app_obj_form_control_textbox_mail_app_obj_form_control_textbox_tel_app_obj_form_control_textbox_time_app_obj_form_control_textbox_date_fr_app_obj_form_control_textbox_date_en_app_obj_form_control_textbox_datetime_fr_app_obj_form_control_textbox_datetime_en_app_obj_form_control_textbox_color_app_obj_form_control_textbox_password_app_obj_form_control_textbox_file_app_obj_form_control_textarea_app_obj_form_control_select_mono_app_obj_form_control_select_multiple_app_obj_form_control_radio_line_app_obj_form_control_radio_inline_app_obj_form_control_checkbox_line_app_obj_form_control_checkbox_inline_app_obj_form_control_hidden
Virtual host
app vhost addapp vhost showapp vhost existapp vhost delete
Accelerator
accelerator count mqlaccelerator count scriptaccelerator countaccelerator showaccelerator reset
Script
script create script create|insert|addscript updatescript set delayscript getscript generate createscript generate updatescript copyscript copy allscript renamescript rename allscript existscript showscript show ghostscript export_allscript export_groupscript import_groupscript get_allexecutecallincludescript is grantedscript generate urlscript generate delayscript generate executescript generate stackscript generate callscript generate includescript generate sub_includescript show groupsscript show usersscript deletescript delete all
User
user create user create|insert|adduser check passworduser force create user force create|insert|adduser existuser secret_keyuser set passworduser showuser show groupsuser show scriptsuser disable
Group
group add group create|insert|addgroup existgroup grant usergroup grant scriptgroup is granted usergroup is granted scriptgroup getgroup get usergroup get scriptgroup showgroup ungrant usergroup ungrant scriptgroup remove
MQL Syntax
category1 categoryN action param1 paramN
Data Type
numericstringnull[_n_][_r_]variablebooleanjsoncommenterror
Statement
evalparallelifif forcecaseswitchforwhilerepeatbreakexceptiontry
Operator
+bi+-bi-*bi*/bi/andorxornotis nullis not nullis null or emptyis emptyis not emptyequalnot equal==!=>>=<<=
Date
date adddate addtdate current_msdate current_nsdate curdatedate current_datedate current_timedate current_timestampdate curtimedate curtimestampdate dateadddate dateaddtdate datediffdate datedifftdate ts_to_longdate dt_to_longdate day_of_monthdate day_of_weekdate day_of_yeardate daynamedate diffdate difftdate full_systimestampdate hourdate is_valid_datedate is_valid_datedate is_valid_timedate is_valid_timestampdate is_valid_timestampdate formatdate minutedate monthdate monthnamedate nb_daydate secondedate sysdatedate systimedate systimestampdate nowdate systimestamp_mindate timedate year
Math
math absmath acosmath asinmath atanmath atan2math avgmath bit_andmath bit_ormath bit_xormath cbrtmath ceilmath ceilingmath cosmath coshmath cotmath decimal_formatmath deg_to_radmath emath expmath expm1math floormath hypotmath logmath log10math log1pmath maxmath minmath modmath pimath powmath powermath rad_to_degmath randommath rintmath roundmath signmath signummath sinmath sinhmath sqrtmath tanmath tanhmath ulp
String
string asciistring binstring bit_lengthstring charstring char_lengthstring char_to_intconcatstring csv_valuestring sentence_distancestring sentences_distancestring levenshtein_distancestring md5string countstring encode_b64string decode_b64string del_char_before_each_linestring ends_withstring first_letter_upperstring first_letterstring generate_random_strstring hexstring hex_to_intstring hex_to_strstring indentstring instrstring instrstring int_to_charstring int_to_hexstring int_to_octstring is_letterstring is_alpha_num_udsstring is_alpha_numstring is_number_charstring itrimstring lcasestring leftstring lengthstring likestring locatestring locatestring lowerstring lpadstring lrtrimstring lrtrim0string ltrimstring matchesstring midstring midstring not_likestring not_regexpstring octstring oct_to_intstring positionstring positionstring regexpstring repeatstring repeat_insert_strstring replacestring reversestring rightstring rpadstring rtrimstring spacestring splitstring split_mqlstring split_sentencestring starts_withstring starts_with_orstring str_to_hexstring strcmpstring strposstring strposstring sublrcharstring substrstring substrstring substringstring substringstring to_stringstring encodestring empty_if_nullstring null_if_emptystring trimstring txtstring txt2string ucasestring unhexstring upperstring zerotype is_matches_regex
Type
type is_booltype is_enumtype is_chartype is_datetype is_decimaltype is_emailtype is_hourtype is_timetype is_hour_without_sectype is_integertype is_numbertype is_bytetype is_small_inttype is_medium_inttype is_inttype is_big_inttype is_floattype is_doubletype is_timestamptype is_valid_datetype is_valid_datetype is_valid_timetype is_valid_timestamptype is_valid_timestamptype is_varchar
Constant
constant math_four_piconstant math_half_piconstant math_piconstant math_pi_squareconstant math_two_piconstant physics_a0constant physics_amuconstant physics_bohr_magnetonconstant physics_cconstant physics_c_squareconstant physics_econstant physics_ehconstant physics_fconstant physics_fine_structureconstant physics_gconstant physics_g0constant physics_kconstant physics_lpconstant physics_m_deuteronconstant physics_m_electronconstant physics_m_muonconstant physics_m_neutronconstant physics_m_protonconstant physics_magn_flux_quantumconstant physics_mpconstant physics_nconstant physics_newtonian_gconstant physics_nuclear_magnetonconstant physics_perm_vac_electricconstant physics_perm_vac_magneticconstant physics_planckconstant physics_planck_over_two_piconstant physics_rconstant physics_rinfconstant physics_stefan_boltzmannconstant physics_tpconstant physics_z0
CSV
csv parse
HTML
html load_from_strhtml load_from_urlhtml closehtml close_allhtml showhtml existhtml elementhtml parsejson parse_objjson parse_array
JSON
json loadjson showjson load processjson load selectjson load by refjson iobjectjson countjson selectjson is objectjson is arrayjson existjson docjson fieldsjson iarrayjson iarrayjson uarrayjson uobjectjson darrayjson dobjectjson unloadjson unload_all
XML
xml loadxml showxml docxml existxml countxml select nodexml select textxml select attributexml xpathxml fieldsxml itextxml inodexml utextxml iattributexml dattributexml dnodexml unloadxml unload_allxml escape_10xml escape_11
File Watcher
file_watcher startfile_watcher killfile_watcher existfile_watcher show
File
file createfile appendfile existfile is_directoryfile loadfile count_line dirfile count_linesfile meta_datafile cur_abs_dirfile cur_canonical_dirfile pwdfile sizefile last_modifiedfile mkdirfile deletefile copy_dirfile copy_filefile copy_formatfile inifile ini_strfile dir_listfile dir_list_regexfile b64_readfile b64_writefile writer_openfile writer_existfile writer_showfile writer_add_linefile writer_add_bytesfile writer_flushfile writer_closefile writer_closeallfile reader_openfile reader_existfile reader_showfile reader_get_linefile reader_get_bytesfile reader_closefile reader_closeall
Atom
atom before_excludatom before_includatom countatom count_distinctatom count_lrtrimatom count_lrtrim_distinctatom distinctatom distinct_lrtrimatom distinct_lrtrim_1sbeforeatom findatom find_lrtrimatom getatom get_firstatom get_first_lrtrimatom get_lastatom get_last_lrtrimatom get_lrtrimatom lrtrimatom positionatom position_lrtrimatom size
External REST API
rest httprest http_json_postrest httpsrest https_json_post
External SOAP API
soap httpsoap https
Compress
compress zipcompress unzipcompress tarcompress untarcompress tarGzcompress untarGzcompress tarBz2compress untarBz2compress jarcompress unjarcompress gzcompress ungzcompress bz2compress unbz2
SQL
sql connectsql showsql auto_commitsql set_timeoutsql valuesql rowsql col_distinctsql to jsonsql to xmlsql to htmlsql to excelsql to excelxsql to pdfsql to csvsql to csv_filesql dmlsql parsesql commitsql rollbacksql disconnectsql disconnect allsql encodesql show tablessql selectsql show datasql show descsql show activity
CM
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 showcm show_objcm getcm generate_updatecm existcm remove
Tunnel
tunnel connecttunnel execute_hottunnel executetunnel disconnecttunnel disconnect allmqlmql encode
Mail
mail download pop3mail download imapmail sendmail process statusmail process startmail process stopmail process_limitmail count_loadedmail count_allmail count_errormail min_error_datemail showmail show_errormail get_bodymail get_errormail replay_error_idmail replay_error_cmmail replay_error_allmail delete_error_idmail delete_error_cmmail delete_error_all
FTP
ftp set timeoutftp connectftp set typeftp active compressionftp activeftp passiveftp cdftp pwdftp mkdirftp lsftp renameftp putftp getftp rm fileftp rm dirftp disconnectftp disconnect all
FTPS
ftps connectftps parse pbszftps exec protftps activeftps passiveftps set typeftps cdftps pwdftps mkdirftps lsftps ls dirsftps renameftps putftps getftps rmftps rm dirftps disconnectftps disconnect all
SFTP
sftp connectsftp cdsftp lcdsftp pwdsftp lpwdsftp mkdirsftp lssftp renamesftp homesftp versionsftp putsftp getsftp rmsftp rm dirsftp disconnectsftp disconnect all
CIFS
cifs mkdircifs rmcifs lscifs renamecifs getcifs put
SSH
ssh connectssh execute_1_cmdssh execute_n_cmdssh scp fromssh scp tossh disconnectssh disconnect all
Excel
excel loadexcel load emptyexcel showexcel saveexcel existexcel sheet addexcel sheet deleteexcel sheet max_rowexcel sheet showexcel cell getexcel cell evalexcel cell refexcel cell setexcel cell formatexcel closeexcel close_allexcel build_in_format
Excelx
excelx loadexcelx load emptyexcelx showexcelx saveexcelx existexcelx sheet addexcelx sheet deleteexcelx sheet max_rowexcelx sheet showexcelx cell getexcelx cell evalexcelx cell refexcelx cell setexcelx cell formatexcelx closeexcelx close_all
MSWord
msword replace
MSWordx
mswordx replace
PDF
pdf from html
SCRUD
scrud selectscrud exportscrud createscrud parsescrud db_to_dbscrud csv_to_dbscrud insertscrud updatescrud mergescrud delete
Stack
stackstack process statusstack process startstack process stopstack process_limitstack count_waitstack count_runningstack count_closedstack count_errorstack delete_wait_idstack delete_wait_scriptstack delete_closed_idstack delete_closed_scriptstack delete_error_idstack delete_error_scriptstack reset_error_nbattempt_idstack reset_error_nbattempt_scriptstack replay_error_idstack replay_error_scriptstack getstack search
Job
job helpjob add job create|insert|addjob showjob show activatejob existjob pausejob resumejob existjob generate updatejob updatejob removejob scheduler stopjob scheduler startjob scheduler restartjob scheduler status
Predictive analysis
pa xy_scatterpa xy_scatterpa rl loadpa rl load_from_jsonpa rl load_emptypa rl existpa rl showpa rl add_datapa rl slopepa rl interceptpa rl predictpa rl intercept_std_errpa rl mean_square_errorpa rl countpa rl rpa rl sum_squarespa rl r_squarepa rl significancepa rl slope_confidence_intervalpa rl slope_std_errpa rl sum_squared_errorspa rl total_sum_squarespa rl x_sum_squarespa rl slope_confidence_intervalpa rl closepa rl close_allpa rm loadpa rm load_from_jsonpa rm set_no_interceptpa rm calculate_adjusted_r_squaredpa rm calculate_residual_sum_of_squarespa rm calculate_r_squaredpa rm calculate_total_sum_of_squarespa rm estimate_error_variancepa rm estimate_regressand_variancepa rm estimate_regression_standard_errorpa rm estimate_regression_parameters_variancepa rm estimate_residualspa rm estimate_regression_parameters_standard_errorspa rm estimate_regression_parameterspa rm predictpa rm existpa rm showpa rm closepa rm close_all
Data quality
dq algorithm showdq algorithm setdq algorithm existdq algorithm getdq algorithm removedq generatedq analysedq analyse show
Machine Learning
ml cluster xy_scatterml cluster loadml cluster load_from_jsonml cluster existml cluster showml cluster nbml cluster nb_pointml cluster pointsml cluster point_getml cluster point_deleteml cluster point_addml cluster point_updateml cluster distanceml cluster closeml cluster close_allml h_node load_from_jsonml h_node add_problemml h_node predictml h_node existml h_node exist_problemml h_node showml h_node show_problemml h_node close_problemml h_node closeml h_node close_all
Deep Learning
dl n_bayesian showdl n_bayesian existdl n_bayesian create_modeldl n_bayesian loaddl n_bayesian predictdl n_bayesian deletedl bayesian showdl bayesian existdl bayesian createdl bayesian add_sentencedl bayesian initdl bayesian predictdl bayesian deletedl csv execute_configdl csv load_networkdl csv predictdl img step1 create_trainingdl img step2 add_imagedl img step3 create_hidden_layerdl img step4 create_or_load_networkdl img step5 train_networkdl img step6 predictdl img step7 close_filedl img execute_configdl img load_networkdl img predict
Bot
bot showbot createbot removebot existbot aiml setbot executebot aiml remove
Sequence
sequence showsequence get currentsequence add sequence create|insert|addsequence existsequence incrementsequence updatesequence generate updatesequence remove
Node
node create node create|insert|addnode existnode iobjectnode shownode show detailednode countnode fieldsnode iarraynode iarraynode is arraynode is objectnode selectnode uarraynode uobjectnode darraynode dobject
Transaction
commitrollbacktransaction logsauto commit setauto commit
File System
fs index sizefs data sizefs index calcul posfs index blockfs index countfs data blockfs data recordfs cache sizefs lock sizefs unused data blockfs unused nb blockfs unused last block
Metric
metric sessionsmetric index filesmetric data filesmetric systemmetric count cmdmetric count sessionmetric cmdmetric cpumetric current cpu jvmmetric current cpu systemmetric current free memmetric current free swap memmetric current mem jvmmetric current used memmetric current used swap memmetric datemetric file system rootsmetric java vendormetric java versionmetric memmetric sessmetric sessionmetric system architecturemetric system namemetric system nb processormetric system versionmetric total memmetric total swap mem
Environment variable
env set varconcat_varenv incr varenv decr varenv get varenv exist varenv del varenv show
Session

WS Session

@chat@cmdid@count sessions@sessions@sid

DB Session

byecmdidcount sessionsexithelpquitsessionssidwho
Parameter
parameter add parameter create|insert|addparameter mergeparameter existparameter get value get_paramparameter get locked_dmlparameter lock_dmlparameter removeparameter showparameter unlock_dmlparameter updateparameter lock_if_nullparameter generate updateparameter generate merge
Log
log tracelog writelog showlog current idlog retention daylog removelog archive sizelog archive pathlog resetlog searchlog show_time
OS
os versionos archos nameos typeos hostnameos user_timezoneos user_nameos user_langos user_homeos user_diros execute
Server
idai firstnameai lastnamename ai nameshutdownstopwaitversionexceeded sessionsreset exceeded sessions@exceeded sessions@reset exceeded sessionssrc countfunction countrefresh adminrefresh develrefresh configin editorin clipboardin out_editorin activityin scatterconfig reloadkillkill_process




© 2012 - 2019 - Innov-AI.