One Hat Cyber Team

Edit File: mysqlPlugin.72fb44411afd8165d201.js

"use strict";(self.webpackChunkgrafana=self.webpackChunkgrafana||[]).push([[6918],{18715:(me,O,s)=>{s.r(O),s.d(O,{plugin:()=>Ee});var v=s(40187),c=s(71928),P=s(32196),t=s(96540),G=s(40845);function B(){const e=(0,G.of)(F);return t.createElement("div",null,t.createElement("h2",null,"MySQL cheat sheet"),"Time series:",t.createElement("ul",{className:e.ulPadding},t.createElement("li",null,"return column named time or time_sec (in UTC), as a unix time stamp or any sql native date data type. You can use the macros below."),t.createElement("li",null,"return column(s) with numeric datatype as values")),"Optional:",t.createElement("ul",{className:e.ulPadding},t.createElement("li",null,"return column named ",t.createElement("i",null,"metric")," to represent the series name."),t.createElement("li",null,"If multiple value columns are returned the metric column is used as prefix."),t.createElement("li",null,"If no column named metric is found the column name of the value column is used as series name")),t.createElement("p",null,"Resultsets of time series queries need to be sorted by time."),"Table:",t.createElement("ul",{className:e.ulPadding},t.createElement("li",null,"return any set of columns")),"Macros:",t.createElement("ul",{className:e.ulPadding},t.createElement("li",null,"$__time(column) -> UNIX_TIMESTAMP(column) as time_sec"),t.createElement("li",null,"$__timeEpoch(column) -> UNIX_TIMESTAMP(column) as time_sec"),t.createElement("li",null,"$__timeFilter(column) -> column BETWEEN FROM_UNIXTIME(1492750877) AND FROM_UNIXTIME(1492750877)"),t.createElement("li",null,"$__unixEpochFilter(column) -> time_unix_epoch > 1492750877 AND time_unix_epoch < 1492750877"),t.createElement("li",null,"$__unixEpochNanoFilter(column) -> column >= 1494410783152415214 AND column <= 1494497183142514872"),t.createElement("li",null,"$__timeGroup(column,'5m'[, fillvalue]) -> cast(cast(UNIX_TIMESTAMP(column)/(300) as signed)*300 as signed) by setting fillvalue grafana will fill in missing values according to the interval fillvalue can be either a literal value, NULL or previous; previous will fill in the previous seen value or NULL if none has been seen yet"),t.createElement("li",null,`$__timeGroupAlias(column,'5m') -> cast(cast(UNIX_TIMESTAMP(column)/(300) as signed)*300 as signed) AS "time"`),t.createElement("li",null,"$__unixEpochGroup(column,'5m') -> column DIV 300 * 300"),t.createElement("li",null,`$__unixEpochGroupAlias(column,'5m') -> column DIV 300 * 300 AS "time"`)),t.createElement("p",null,"Example of group by and order by with $__timeGroup:"),t.createElement("pre",null,t.createElement("code",null,"$__timeGroupAlias(timestamp_col, '1h'), sum(value_double) as value",t.createElement("br",null),"FROM yourtable",t.createElement("br",null),"GROUP BY 1",t.createElement("br",null),"ORDER BY 1",t.createElement("br",null))),"Or build your own conditionals using these macros which just return the values:",t.createElement("ul",{className:e.ulPadding},t.createElement("li",null,"$__timeFrom() -> FROM_UNIXTIME(1492750877)"),t.createElement("li",null,"$__timeTo() -> FROM_UNIXTIME(1492750877)"),t.createElement("li",null,"$__unixEpochFrom() -> 1492750877"),t.createElement("li",null,"$__unixEpochTo() -> 1492750877"),t.createElement("li",null,"$__unixEpochNanoFrom() -> 1494410783152415214"),t.createElement("li",null,"$__unixEpochNanoTo() -> 1494497183142514872")))}function F(e){return{ulPadding:(0,P.css)({margin:e.spacing(1,0),paddingLeft:e.spacing(5)})}}var i=s(98765);function w(e){const n=[];for(const a of e){let l="text";switch(a.type?.toUpperCase()){case"BOOLEAN":case"BOOL":{l="boolean";break}case"BYTES":case"VARCHAR":{l="text";break}case"FLOAT":case"FLOAT64":case"INT":case"INTEGER":case"INT64":case"NUMERIC":case"BIGNUMERIC":{l="number";break}case"DATE":{l="date";break}case"DATETIME":{l="datetime";break}case"TIME":{l="time";break}case"TIMESTAMP":{l="datetime";break}case"GEOGRAPHY":{l="text";break}default:break}n.push({...a,raqbFieldType:l,icon:Y(a.type.toUpperCase())})}return n}function Y(e){switch(e){case"TIME":case"DATETIME":case"TIMESTAMP":return"clock-nine";case"BOOLEAN":return"toggle-off";case"INTEGER":case"FLOAT":case"FLOAT64":case"INT":case"SMALLINT":case"BIGINT":case"TINYINT":case"BYTEINT":case"INT64":case"NUMERIC":case"DECIMAL":return"calculator-alt";case"CHAR":case"VARCHAR":case"STRING":case"BYTES":case"TEXT":case"TINYTEXT":case"MEDIUMTEXT":case"LONGTEXT":return"text";case"GEOGRAPHY":return"map";default:return}}var H=s(2543);function W({sql:e,dataset:n,table:a}){let l="";if(!e||!(0,c.YW)(e.columns))return l;if(l+=(0,c.oF)(e.columns),n&&a&&(l+=`FROM ${n}.${a} `),e.whereString&&(l+=`WHERE ${e.whereString} `),e.groupBy?.[0]?.property.name){const o=e.groupBy.map(r=>r.property.name).filter(r=>!(0,H.isEmpty)(r));l+=`GROUP BY ${o.join(", ")} `}return e.orderBy?.property.name&&(l+=`ORDER BY ${e.orderBy.property.name} `),e.orderBy?.property.name&&e.orderByDirection&&(l+=`${e.orderByDirection} `),e.limit!==void 0&&e.limit>=0&&(l+=`LIMIT ${e.limit} `),l}function h(e){return V(e)?e:`\`${e}\``}function V(e){const n=/^[a-zA-Z_][a-zA-Z0-9_$]*$/g.test(e);return!$.includes(e.toUpperCase())&&n}function x(e){return e[0]==='"'&&e[e.length-1]==='"'?e.substring(1,e.length-1).replace(/""/g,'"'):e[0]==="`"&&e[e.length-1]==="`"?e.substring(1,e.length-1):e}function g(e){return"'"+e.replace(/'/g,"''")+"'"}const $=["ACCESSIBLE","ADD","ALL","ALTER","ANALYZE","AND","AS","ASC","ASENSITIVE","BEFORE","BETWEEN","BIGINT","BINARY","BLOB","BOTH","BY","CALL","CASCADE","CASE","CHANGE","CHAR","CHARACTER","CHECK","COLLATE","COLUMN","CONDITION","CONSTRAINT","CONTINUE","CONVERT","CREATE","CROSS","CUBE","CUME_DIST","CURRENT_DATE","CURRENT_TIME","CURRENT_TIMESTAMP","CURRENT_USER","CURSOR","DATABASE","DATABASES","DAY_HOUR","DAY_MICROSECOND","DAY_MINUTE","DAY_SECOND","DEC","DECIMAL","DECLARE","DEFAULT","DELAYED","DELETE","DENSE_RANK","DESC","DESCRIBE","DETERMINISTIC","DISTINCT","DISTINCTROW","DIV","DOUBLE","DROP","DUAL","EACH","ELSE","ELSEIF","EMPTY","ENCLOSED","ESCAPED","EXCEPT","EXISTS","EXIT","EXPLAIN","FALSE","FETCH","FIRST_VALUE","FLOAT","FLOAT4","FLOAT8","FOR","FORCE","FOREIGN","FROM","FULLTEXT","FUNCTION","GENERATED","GET","GRANT","GROUP","GROUPING","GROUPS","HAVING","HIGH_PRIORITY","HOUR_MICROSECOND","HOUR_MINUTE","HOUR_SECOND","IF","IGNORE","IN","INDEX","INFILE","INNER","INOUT","INSENSITIVE","INSERT","INT","INT1","INT2","INT3","INT4","INT8","INTEGER","INTERSECT","INTERVAL","INTO","IO_AFTER_GTIDS","IO_BEFORE_GTIDS","IS","ITERATE","JOIN","JSON_TABLE","KEY","KEYS","KILL","LAG","LAST_VALUE","LATERAL","LEAD","LEADING","LEAVE","LEFT","LIKE","LIMIT","LINEAR","LINES","LOAD","LOCALTIME","LOCALTIMESTAMP","LOCK","LONG","LONGBLOB","LONGTEXT","LOOP","LOW_PRIORITY","MASTER_BIND","MASTER_SSL_VERIFY_SERVER_CERT","MATCH","MAXVALUE","MEDIUMBLOB","MEDIUMINT","MEDIUMTEXT","MIDDLEINT","MINUTE_MICROSECOND","MINUTE_SECOND","MOD","MODIFIES","NATURAL","NOT","NO_WRITE_TO_BINLOG","NTH_VALUE","NTILE","NULL","NUMERIC","OF","ON","OPTIMIZE","OPTIMIZER_COSTS","OPTION","OPTIONALLY","OR","ORDER","OUT","OUTER","OUTFILE","OVER","PARTITION","PERCENT_RANK","PRECISION","PRIMARY","PROCEDURE","PURGE","RANGE","RANK","READ","READS","READ_WRITE","REAL","RECURSIVE","REFERENCES","REGEXP","RELEASE","RENAME","REPEAT","REPLACE","REQUIRE","RESIGNAL","RESTRICT","RETURN","REVOKE","RIGHT","RLIKE","ROW","ROWS","ROW_NUMBER","SCHEMA","SCHEMAS","SECOND_MICROSECOND","SELECT","SENSITIVE","SEPARATOR","SET","SHOW","SIGNAL","SMALLINT","SPATIAL","SPECIFIC","SQL","SQLEXCEPTION","SQLSTATE","SQLWARNING","SQL_BIG_RESULT","SQL_CALC_FOUND_ROWS","SQL_SMALL_RESULT","SSL","STARTING","STORED","STRAIGHT_JOIN","SYSTEM","TABLE","TERMINATED","THEN","TINYBLOB","TINYINT","TINYTEXT","TO","TRAILING","TRIGGER","TRUE","UNDO","UNION","UNIQUE","UNLOCK","UNSIGNED","UPDATE","USAGE","USE","USING","UTC_DATE","UTC_TIME","UTC_TIMESTAMP","VALUES","VARBINARY","VARCHAR","VARCHARACTER","VARYING","VIRTUAL","WHEN","WHERE","WHILE","WINDOW","WITH","WRITE","XOR","YEAR_MONTH","ZEROFILL"];function Q(e){return`SELECT table_name FROM information_schema.tables WHERE table_schema = ${e!==void 0?T(e):"database()"} ORDER BY table_name`}function X(){return"SELECT DISTINCT TABLE_SCHEMA from information_schema.TABLES where TABLE_TYPE != 'SYSTEM VIEW' ORDER BY TABLE_SCHEMA"}function K(e,n){let a="SELECT column_name, data_type FROM information_schema.columns WHERE ";return a+=k(e,n),a+=" ORDER BY column_name",a}function k(e,n){let a="";if(e.includes(".")){const l=e.split(".");return a="table_schema = "+T(l[0]),a+=" AND table_name = "+T(l[1]),a}else return a=`table_schema = ${n!==void 0?T(n):"database()"} AND table_name = `+T(e),a}function T(e){return g(x(e))}var z=s(33125);const j=({getMeta:e})=>(n,a)=>({...a&&(0,z.N)(n,a),customStatementPlacement:_,customSuggestionKinds:Z(e)}),D={afterDatabase:"afterDatabase"},J={tablesWithinDatabase:"tablesWithinDatabase"},N="FROM",_=()=>[{id:D.afterDatabase,resolve:(e,n,a)=>!!(e?.is(i.ks.Delimiter,".")&&n?.value===N&&(a?.is(i.ks.IdentifierQuote)||a?.isIdentifier())&&e?.getPreviousUntil(i.ks.Keyword,[i.ks.IdentifierQuote],N)?.filter(l=>l.isIdentifier()).length===1)}],Z=e=>()=>[{id:i.ng.Tables,overrideDefault:!0,suggestionsResolver:async n=>{const a=C(n.currentToken);return(await e({schema:a})).map(f(n))}},{id:i.ng.Columns,overrideDefault:!0,suggestionsResolver:async n=>{const a=te(n.currentToken),l=C(a),o=q(a);return!l||!o?[]:(await e({schema:l,table:o})).map(f(n))}},{id:J.tablesWithinDatabase,applyTo:[D.afterDatabase],suggestionsResolver:async n=>{const a=C(n.currentToken);return(await e({schema:a})).map(f(n))}}];function f(e){return function(n){return{label:n.name,insertText:n.completion??n.name,command:{id:"editor.action.triggerSuggest",title:""},kind:i.Io.Field,sortText:i.mY.High,range:{...e.range,startColumn:e.range.endColumn,endColumn:e.range.endColumn}}}}function C(e){if(e?.isIdentifier()&&e.value[e.value.length-1]!==".")return e.value;if(e?.is(i.ks.Delimiter,"."))return e.getPreviousOfType(i.ks.Identifier)?.value;if(e?.is(i.ks.IdentifierQuote))return e.getPreviousOfType(i.ks.Identifier)?.value||e.getNextOfType(i.ks.Identifier)?.value}function q(e){return e?.getNextOfType(i.ks.Identifier)?.value}const ee=e=>(e?.getPreviousOfType(i.ks.Keyword,"SELECT")??null)?.getNextOfType(i.ks.Keyword,N),te=e=>{const a=ee(e)?.getNextOfType(i.ks.Identifier);return a?.isKeyword()&&a.next?.is(i.ks.Parenthesis,"(")?null:a};class ne extends c.oK{constructor(n){super(n),this.instanceSettings=n}getQueryModel(){return{quoteLiteral:g}}getSqlLanguageDefinition(){if(this.sqlLanguageDefinition!==void 0)return this.sqlLanguageDefinition;const n={getMeta:a=>this.fetchMeta(a)};return this.sqlLanguageDefinition={id:"mysql",completionProvider:j(n),formatter:c.se},this.sqlLanguageDefinition}async fetchDatasets(){return(await this.runSql(X(),{refId:"datasets"})).map(a=>h(a[0]))}async fetchTables(n){return(await this.runSql(Q(n),{refId:"tables"})).map(l=>h(l[0]))}async fetchFields(n){if(!n.dataset||!n.table)return[];const a=K(n.table,n.dataset),o=(await this.runSql(a,{refId:"fields"})).map(r=>({name:r[0],text:r[0],value:h(r[0]),type:r[1],label:r[0]}));return w(o)}async fetchMeta(n){const a=this.instanceSettings.jsonData.database;return!n?.schema&&a?(await this.fetchTables(a)).map(o=>({name:o,completion:`${a}.${o}`,kind:i.Io.Class})):!n?.schema&&!a?(await this.fetchDatasets()).map(o=>({name:o,completion:`${o}.`,kind:i.Io.Module})):!n?.table&&(!a||n?.schema)?(await this.fetchTables(n?.schema)).map(o=>({name:o,completion:o,kind:i.Io.Class})):n?.table&&n.schema?(await this.fetchFields({dataset:n.schema,table:n.table})).map(o=>({name:o.name,completion:o.value,kind:i.Io.Field})):[]}getDB(){return this.db!==void 0?this.db:{datasets:()=>this.fetchDatasets(),tables:n=>this.fetchTables(n),fields:n=>this.fetchFields(n),validateQuery:(n,a)=>Promise.resolve({query:n,error:"",isError:!1,isValid:!0}),dsID:()=>this.id,toRawSql:W,functions:()=>["VARIANCE","STDDEV"],getEditorLanguageDefinition:()=>this.getSqlLanguageDefinition()}}}var m=s(22391),ae=s(68704),R=s(91062),le=s(29020),p=s(46819),se=s(32264),re=s(82762),E=s(88575),d=s(10354),ie=s(9226),A=s(15292),b=s(60029),M=s(56034),y=s(14578),oe=s(17081);const ce=e=>{const[n,a]=(0,t.useState)(!0),{options:l,onOptionsChange:o}=e,r=l.jsonData;(0,c.nj)(e);const ue=()=>{(0,m.QP)(e,"password")},U=I=>L=>{o({...l,[I]:L.currentTarget.value})},S=I=>L=>{(0,m.lO)(e,I,L.currentTarget.checked)},u=40;return t.createElement(t.Fragment,null,t.createElement(ae.I,{dataSourceName:"MySQL",docsLink:"https://grafana.com/docs/grafana/latest/datasources/mysql/",hasRequiredFields:!0}),t.createElement(c.cG,null),t.createElement(re.S,{collapsible:!0,label:"User Permission",isOpen:n,onToggle:()=>a(I=>!I)},"The database user should only be granted SELECT permissions on the specified database & tables you want to query. ",t.createElement("br",null),"Grafana does not validate that queries are safe so queries can contain any SQL statement. For example, statements like ",t.createElement("code",null,"USE otherdb;")," and ",t.createElement("code",null,"DROP TABLE user;")," would be executed. ",t.createElement("br",null),"To protect against this we ",t.createElement("strong",null,"Highly")," recommend you create a specific MySQL user with restricted permissions. Check out the docs for more information."),t.createElement(c.cG,null),t.createElement(R.A,{title:"Connection"},t.createElement(E.D,{label:"Host URL",required:!0},t.createElement(d.p,{width:u,name:"host",type:"text",value:l.url||"",placeholder:"localhost:3306",onChange:U("url")})),t.createElement(E.D,{label:"Database name"},t.createElement(d.p,{width:u,name:"database",value:r.database||"",placeholder:"Database",onChange:(0,m.PG)(e,"database")}))),t.createElement(c.cG,null),t.createElement(R.A,{title:"Authentication"},t.createElement(E.D,{label:"Username",required:!0},t.createElement(d.p,{width:u,value:l.user||"",placeholder:"Username",onChange:U("user")})),t.createElement(E.D,{label:"Password"},t.createElement(ie.L4,{width:u,placeholder:"Password",isConfigured:l.secureJsonFields&&l.secureJsonFields.password,onReset:ue,onBlur:(0,m.mn)(e,"password")})),t.createElement(E.D,{label:"Use TLS Client Auth",description:"Enables TLS authentication using client cert configured in secure json data."},t.createElement(A.d,{onChange:S("tlsAuth"),value:r.tlsAuth||!1})),t.createElement(E.D,{label:"With CA Cert",description:"Needed for verifying self-signed TLS Certs."},t.createElement(A.d,{onChange:S("tlsAuthWithCACert"),value:r.tlsAuthWithCACert||!1})),t.createElement(E.D,{label:"Skip TLS Verification",description:"When enabled, skips verification of the MySQL server's TLS certificate chain and host name."},t.createElement(A.d,{onChange:S("tlsSkipVerify"),value:r.tlsSkipVerify||!1})),t.createElement(E.D,{label:"Allow Cleartext Passwords",description:"Allows using the cleartext client side plugin if required by an account."},t.createElement(A.d,{onChange:S("allowCleartextPasswords"),value:r.allowCleartextPasswords||!1}))),r.tlsAuth||r.tlsAuthWithCACert?t.createElement(t.Fragment,null,t.createElement(c.cG,null),t.createElement(R.A,{title:"TLS/SSL Auth Details"},r.tlsAuth||r.tlsAuthWithCACert?t.createElement(c.X3,{showCACert:r.tlsAuthWithCACert,showKeyPair:r.tlsAuth,editorProps:e,labelWidth:u}):null)):null,t.createElement(c.cG,null),t.createElement(R.A,{title:"Additional settings",isCollapsible:!0},t.createElement(le.I,{title:"MySQL Options"},t.createElement(E.D,{label:t.createElement(b.J,null,t.createElement(p.B,{gap:.5},t.createElement("span",null,"Session timezone"),t.createElement(M.m,{content:t.createElement("span",null,"Specify the timezone used in the database session, such as ",t.createElement("code",null,"Europe/Berlin")," or",t.createElement("code",null,"+02:00"),". Required if the timezone of the database (or the host of the database) is set to something other than UTC. Set this to ",t.createElement("code",null,"+00:00")," so Grafana can handle times properly. Set the value used in the session with ",t.createElement("code",null,"SET time_zone='...'"),". If you leave this field empty, the timezone will not be updated. You can find more information in the MySQL documentation.")},t.createElement(y.I,{name:"info-circle",size:"sm"}))))},t.createElement(d.p,{width:u,value:r.timezone||"",onChange:(0,m.PG)(e,"timezone"),placeholder:"Europe/Berlin or +02:00"})),t.createElement(E.D,{label:t.createElement(b.J,null,t.createElement(p.B,{gap:.5},t.createElement("span",null,"Min time interval"),t.createElement(M.m,{content:t.createElement("span",null,"A lower limit for the auto group by time interval. Recommended to be set to write frequency, for example",t.createElement("code",null,"1m")," if your data is written every minute.")},t.createElement(y.I,{name:"info-circle",size:"sm"})))),description:"A lower limit for the auto group by time interval. Recommended to be set to write frequency, for example 1m if your data is written every minute."},t.createElement(d.p,{width:u,placeholder:"1m",value:r.timeInterval||"",onChange:(0,m.PG)(e,"timeInterval")}))),t.createElement(c.jN,{options:l,onOptionsChange:o}),se.$.secureSocksDSProxyEnabled&&t.createElement(oe.Y,{options:l,onOptionsChange:o})))},Ee=new v.tD(ne).setQueryEditor(c.e_).setQueryEditorHelp(B).setConfigEditor(ce)}}]);

//# sourceMappingURL=mysqlPlugin.72fb44411afd8165d201.js.map