⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.72
Server IP:
41.128.143.86
Server:
Linux host.raqmix.cloud 6.8.0-1025-azure #30~22.04.1-Ubuntu SMP Wed Mar 12 15:28:20 UTC 2025 x86_64
Server Software:
Apache
PHP Version:
8.3.23
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
usr
/
share
/
grafana
/
public
/
build
/
View File Name :
postgresPlugin.f88c598bae2653ae177b.js.map
{"version":3,"file":"postgresPlugin.f88c598bae2653ae177b.js","mappings":"iLAMO,SAASA,GAAa,CAC3B,MAAMC,KAAS,MAAWC,CAAS,EAEnC,OACE,gBAAC,WACC,gBAAC,UAAG,wBAAsB,EAAK,eAE/B,gBAAC,MAAG,UAAWD,EAAO,WACpB,gBAAC,UAAG,uBACkB,gBAAC,SAAE,MAAI,EAAI,gCACjC,EACA,gBAAC,UAAG,kDAAgD,CACtD,EAAK,YAEL,gBAAC,MAAG,UAAWA,EAAO,WACpB,gBAAC,UAAG,uBACkB,gBAAC,SAAE,QAAM,EAAI,gCACnC,EACA,gBAAC,UAAG,6EAA2E,EAC/E,gBAAC,UAAG,+FAA6F,CACnG,EACA,gBAAC,SAAE,8DAA4D,EAAI,SAEnE,gBAAC,MAAG,UAAWA,EAAO,WACpB,gBAAC,UAAG,2BAAyB,CAC/B,EAAK,UAEL,gBAAC,MAAG,UAAWA,EAAO,WACpB,gBAAC,UAAG,qCAAgD,EACpD,gBAAC,UAAG,sDAAiE,EACrE,gBAAC,UAAG,2FAGJ,EACA,gBAAC,UAAG,6EAAoF,EACxF,gBAAC,UAAG,mGAEJ,EACA,gBAAC,UAAG,sTAIJ,EACA,gBAAC,UAAG,0FAGJ,EACA,gBAAC,UAAG,yDAAoE,EACxE,gBAAC,UAAG,wEAA6F,CACnG,EACA,gBAAC,SAAE,qDAAmD,EACtD,gBAAC,WACC,gBAAC,YAAK,iEACoE,gBAAC,SAAG,EAAE,iBAE9E,gBAAC,SAAG,EAAE,gBAEN,gBAAC,SAAG,EAAE,gBAEN,gBAAC,SAAG,CACN,CACF,EAAM,kFAEN,gBAAC,MAAG,UAAWA,EAAO,WACpB,gBAAC,UAAG,yCAAoD,EACxD,gBAAC,UAAG,uCAAkD,EACtD,gBAAC,UAAG,kCAAmC,EACvC,gBAAC,UAAG,gCAAiC,EACrC,gBAAC,UAAG,+CAAgD,EACpD,gBAAC,UAAG,6CAA8C,CACpD,CACF,CAEJ,CAEA,SAASC,EAAUC,EAAsB,CACvC,MAAO,CACL,aAAW,OAAI,CACb,OAAQA,EAAM,QAAQ,EAAG,CAAC,EAC1B,YAAaA,EAAM,QAAQ,CAAC,CAC9B,CAAC,CACH,CACF,C,eCjFA,MAAMC,EAAsD,CAAE,QAAS,UAAW,EAE3E,SAASC,EAAoBC,EAAmE,CACrG,OAAO,gBAAC,KAAc,CAAE,GAAGA,EAAO,iBAAAF,CAAA,CAAoC,CACxE,C,mLCTYG,GAAAA,IACVA,EAAA,QAAU,UACVA,EAAA,QAAU,UACVA,EAAA,SAAW,YACXA,EAAA,WAAa,cAJHA,IAAAA,GAAA,IAOAC,GAAAA,IACVA,EAAA,SAAW,YACXA,EAAA,YAAc,eAFJA,IAAAA,GAAA,I,4CCJL,MAAMC,CAA4C,CAKvD,YAAYC,EAAmBC,EAA2BC,EAAyB,CACjF,KAAK,UAAS,MAAmBF,GAAU,CAAE,MAAO,GAAI,CAAC,EACzD,KAAK,YAAcC,EACnB,KAAK,WAAaC,CACpB,CAEA,aAAc,CACZ,OAAO,KAAK,aAAa,QAAQ,KAAK,OAAO,OAAQ,KAAK,WAAY,KAAiB,SAAS,GAAK,EACvG,CAEA,aAAaC,EAAe,CAC1B,MAAO,IAAMA,EAAM,QAAQ,KAAM,IAAI,EAAI,GAC3C,CACF,CCvBO,SAASC,IAAa,CAC3B,MAAO,kEACT,CAEO,SAASC,IAAwB,CACtC,MAAO,mEACT,CAEO,SAASC,IAAa,CAC3B,MAAO;AAAA;AAAA;AAAA;AAAA;AAAA;AAAA;AAAA;AAAA;AAAA,YASGC,GAAsB,GAClC,CAEO,SAASC,GAAUC,EAAe,CAKvC,MAAO;AAAA;AAAA,sCAFe,IAAMA,EAAM,QAAQ,KAAM,IAAI,EAAI;AAAA,KAM1D,CAEA,SAASF,IAAwB,CAE/B,MAAO;AAAA;AAAA;AAAA;AAAA;AAAA;AAAA;AAAA;AAAA;AAAA;AAAA,YAWT,C,gBC/BO,MAAMG,GACX,CAAC,CAAE,WAAAC,EAAY,UAAAC,CAAU,IACzB,CAACC,EAAQC,KAAc,CACrB,GAAIA,MAAY,MAAiCD,EAAQC,CAAQ,EACjE,OAAQ,CACN,QAAS,SACA,MAAMF,EAAU,QAAQ,CAEnC,EACA,QAAS,CACP,QAAS,MAAOG,GACP,MAAMJ,EAAW,QAAQ,CAAE,MAAOI,GAAG,MAAO,MAAO,GAAI,CAAC,CAEnE,CACF,GAEK,eAAeC,GAAaC,EAAQC,EAAa,CACtD,MAAMC,EAAO,MAAMF,EAAG,OAAOC,CAAC,EAC9B,OAAIC,EAAK,OAAS,EACTA,EAAK,IAAKC,IACR,CAAE,KAAMA,EAAE,MAAO,KAAMA,EAAE,MAAO,YAAaA,EAAE,KAAM,EAC7D,EAEM,CAAC,CAEZ,CAEO,eAAeC,GAAYJ,EAAQ,CAExC,OADe,MAAMA,EAAG,SAAS,GAChB,CAAC,CACpB,C,eCxCO,SAASK,GAAeC,EAA+D,CAC5F,OAAQA,EAAM,CACZ,IAAK,UACH,MAAO,CAAE,cAAe,UAAW,KAAM,YAAa,EAExD,IAAK,MACL,IAAK,cACL,IAAK,YACL,IAAK,oBACL,IAAK,OACH,MAAO,CAAE,cAAe,OAAQ,KAAM,MAAO,EAE/C,IAAK,WACL,IAAK,UACL,IAAK,SACL,IAAK,UACL,IAAK,UACL,IAAK,OACL,IAAK,mBACL,IAAK,SACL,IAAK,YACL,IAAK,cACH,MAAO,CAAE,cAAe,SAAU,KAAM,gBAAiB,EAE3D,IAAK,OACH,MAAO,CAAE,cAAe,OAAQ,KAAM,YAAa,EAErD,IAAK,OACL,IAAK,sBACL,IAAK,yBACL,IAAK,WACH,MAAO,CAAE,cAAe,OAAQ,KAAM,YAAa,EAErD,IAAK,YACL,IAAK,2BACL,IAAK,8BACH,MAAO,CAAE,cAAe,WAAY,KAAM,YAAa,EAEzD,QACE,MAAO,CAAE,cAAe,OAAQ,KAAM,MAAO,CACjD,CACF,CAEO,SAASC,GAAS,CAAE,IAAAC,EAAK,MAAAhB,CAAM,EAAqB,CACzD,IAAIiB,EAAW,GAGf,GAAI,CAACD,GAAO,IAAC,MAAYA,EAAI,OAAO,EAClC,OAAOC,EAaT,GAVAA,MAAY,MAAmBD,EAAI,OAAO,EAEtChB,IACFiB,GAAY,QAAQjB,MAGlBgB,EAAI,cACNC,GAAY,SAASD,EAAI,gBAGvBA,EAAI,UAAU,CAAC,GAAG,SAAS,KAAM,CACnC,MAAME,EAAUF,EAAI,QAAQ,IAAKG,GAAMA,EAAE,SAAS,IAAI,EAAE,OAAQA,GAAM,IAAC,YAAQA,CAAC,CAAC,EACjFF,GAAY,YAAYC,EAAQ,KAAK,IAAI,KAG3C,OAAIF,EAAI,SAAS,SAAS,OACxBC,GAAY,YAAYD,EAAI,QAAQ,SAAS,SAG3CA,EAAI,SAAS,SAAS,MAAQA,EAAI,mBACpCC,GAAY,GAAGD,EAAI,qBAIjBA,EAAI,QAAU,QAAaA,EAAI,OAAS,IAC1CC,GAAY,SAASD,EAAI,UAEpBC,CACT,CCxEO,MAAMG,UAA2B,IAAc,CAGpD,YAAYC,EAA+D,CACzE,MAAMA,CAAgB,EAHxB,2BAAwD,MAIxD,CAEA,cAAc9B,EAAmBC,EAA2BC,EAA6C,CACvG,OAAO,IAAIH,EAAmBC,EAAQC,EAAaC,CAAU,CAC/D,CAEA,MAAM,YAA8B,CAElC,MAAM6B,GADQ,MAAM,KAAK,OAA4B3B,GAAW,CAAC,GAC3C,OAAO,SAAS,OAEtC,OAAK2B,EAIEA,EAAQ,CAAC,EAAE,SAAS,EAHlB,EAIX,CAEA,MAAM,uBAAqD,CAEzD,MAAMA,GADQ,MAAM,KAAK,OAA+B1B,GAAsB,CAAC,GACzD,OAAO,YAAY,OAEzC,GAAK0B,EAIL,OAAOA,EAAQ,CAAC,CAClB,CAEA,MAAM,aAAiC,CAErC,OADe,MAAM,KAAK,OAA4BzB,GAAW,EAAG,CAAE,MAAO,QAAS,CAAC,GACzE,OAAO,OAAO,OAAO,KAAK,GAAK,CAAC,CAChD,CAEA,yBAAyBW,EAA4B,CACnD,GAAI,KAAK,wBAA0B,OACjC,OAAO,KAAK,sBAGd,MAAMe,EAAO,CACX,WAAY,CAAE,QAAUC,GAAoBjB,GAAaC,EAAIgB,CAAK,CAAE,EACpE,UAAW,CAAE,QAAS,IAAMZ,GAAYJ,CAAE,CAAE,CAC9C,EACA,YAAK,sBAAwB,CAC3B,GAAI,QACJ,mBAAoBP,GAAyBsB,CAAI,EACjD,UAAW,IACb,EACO,KAAK,qBACd,CAEA,MAAM,YAAYC,EAAgD,CAChE,KAAM,CAAE,MAAAxB,CAAM,EAAIwB,EAClB,GAAIxB,IAAU,OAEZ,MAAO,CAAC,EAEV,MAAMyB,EAAS,MAAM,KAAK,OAAyC1B,GAAUC,CAAK,EAAG,CAAE,MAAO,SAAU,CAAC,EACnG0B,EAA+B,CAAC,EACtC,QAASC,EAAI,EAAGA,EAAIF,EAAO,OAAQE,IAAK,CACtC,MAAMC,EAASH,EAAO,OAAO,OAAO,OAAOE,CAAC,EACtCb,EAAOW,EAAO,OAAO,KAAK,OAAOE,CAAC,EACxCD,EAAO,KAAK,CAAE,MAAOE,EAAQ,MAAOA,EAAQ,KAAAd,EAAM,GAAGD,GAAeC,CAAI,CAAE,CAAC,EAE7E,OAAOY,CACT,CAEA,OAAY,CACV,OAAI,KAAK,KAAO,OACP,KAAK,GAGP,CACL,KAAM,IAAM,QAAQ,QAAQ,EAAI,EAChC,SAAU,IAAM,QAAQ,QAAQ,CAAC,CAAC,EAClC,OAAQ,IAAM,KAAK,YAAY,EAC/B,4BAA6B,IAAM,KAAK,yBAAyB,KAAK,EAAE,EACxE,OAAQ,MAAOF,GACRA,GAAO,MAGL,KAAK,YAAYA,CAAK,EAFpB,CAAC,EAIZ,cAAgBA,GACd,QAAQ,QAAQ,CAAE,QAAS,GAAO,QAAS,GAAM,MAAAA,EAAO,MAAO,GAAI,OAAQA,EAAM,MAAO,CAAC,EAC3F,KAAM,IAAM,KAAK,GACjB,SAAQ,GACR,OAAQ,UACS,MAAM,KAAK,YAAY,GACxB,IAAKlB,IAAO,CAAE,KAAMA,EAAG,WAAYA,CAAE,EAAE,CAEzD,CACF,CACF,CCtFO,SAASuB,GAAsB,CAAE,MAAA1C,EAAO,kBAAA2C,CAAkB,EAAY,CAC3E,KAAM,CAACC,EAAOC,CAAQ,KAAI,YAAS,EAAK,EAClC,CAAE,QAAAC,EAAS,gBAAAC,CAAgB,EAAI/C,KAErCgD,EAAA,GAAqB,IAAM,CACzB,MAAMxC,EAAa,SAAY,CAC7B,GAAKoC,EAUE,CACL,MAAMK,EAAa,QAAM,KAAiB,EAAE,IAAIH,EAAQ,IAAI,EAE5D,GAAIG,aAAsBhB,EAAoB,CAC5C,MAAMiB,EAAU,MAAMD,EAAW,WAAW,EACtCE,EAAgB,SAASD,EAAS,EAAE,EAGtCC,GAAiB,KAAO,CAACL,EAAQ,SAAS,aACjB,MAAMG,EAAW,sBAAsB,MAEhE,MAAqC,CAAE,QAAAH,EAAS,gBAAAC,CAAgB,EAAG,cAAe,EAAI,EAG1F,MAAMK,EAAQ,KAAK,MAAMD,EAAgB,GAAG,EACtCE,EAAQF,EAAgB,IAC9B,IAAIG,EAAO,OAAOF,CAAK,EACnBD,EAAgB,MAClBG,EAAO,OAAOF,CAAK,EAAI,IAAM,OAAOC,CAAK,GAEtCE,EAAiB,KAAMC,GAAMA,EAAE,QAAUL,CAAa,GACzDR,EAAmBc,GAAS,CAAC,GAAGA,EAAM,CAAE,MAAOH,EAAM,MAAOH,CAAc,CAAC,CAAC,GAE1EL,EAAQ,SAAS,kBAAoB,QAAaA,EAAQ,SAAS,kBAAoBK,OACzF,MAAqC,CAAE,QAAAL,EAAS,gBAAAC,CAAgB,EAAG,kBAAmBI,CAAa,OAlC7F,CAEV,MAAMZ,EAAS,QAAM,MAAc,EAAE,IACnC,oBAAoBO,EAAQ,KAC5BA,CACF,EAEAD,EAAS,EAAI,KAEb,MAA6B,CAAE,QAAAC,EAAS,gBAAAC,CAAgB,EAAG,UAAWR,EAAO,WAAW,OAAO,EA6BnG,EAEImB,GAAcZ,CAAO,GACvBtC,EAAW,CAEf,EAAG,CAACsC,EAASF,EAAOD,CAAiB,CAAC,CACxC,CAEA,SAASe,GAAcZ,EAA8D,CACnF,OACEA,EAAQ,KACRA,EAAQ,SAAS,UACjBA,EAAQ,OACPA,EAAQ,gBAAgB,UAAYA,EAAQ,kBAAkB,YAC9DA,EAAQ,SAAS,UAAY7C,EAAiB,SAC5C6C,EAAQ,SAAS,aAAeA,EAAQ,SAAS,YAAcA,EAAQ,SAAS,kBACnF,CAACA,EAAQ,SAAS,iBAClB,CAACA,EAAQ,QAEb,CCvDO,MAAMS,EAAmD,CAC9D,CAAE,MAAO,MAAO,MAAO,GAAI,EAC3B,CAAE,MAAO,MAAO,MAAO,GAAI,EAC3B,CAAE,MAAO,MAAO,MAAO,GAAI,EAC3B,CAAE,MAAO,MAAO,MAAO,GAAI,EAC3B,CAAE,MAAO,MAAO,MAAO,GAAI,EAC3B,CAAE,MAAO,MAAO,MAAO,GAAI,EAC3B,CAAE,MAAO,MAAO,MAAO,GAAI,EAC3B,CAAE,MAAO,KAAM,MAAO,GAAK,EAC3B,CAAE,MAAO,KAAM,MAAO,IAAK,EAC3B,CAAE,MAAO,KAAM,MAAO,IAAK,EAC3B,CAAE,MAAO,KAAM,MAAO,IAAK,EAC3B,CAAE,MAAO,KAAM,MAAO,IAAK,EAC3B,CAAE,MAAO,KAAM,MAAO,IAAK,CAC7B,EAEaI,GAAwB3D,GAA+E,CAClH,KAAM,CAAC4D,EAAgBjB,CAAiB,KAAI,YAASY,CAAgB,EAC/D,CAACM,EAAQC,CAAS,KAAI,YAAS,EAAI,EAEzCpB,GAAsB,CAAE,MAAA1C,EAAO,kBAAA2C,CAAkB,CAAC,KAClD,MAAyB3C,CAAK,EAE9B,KAAM,CAAE,QAAA8C,EAAS,gBAAAC,CAAgB,EAAI/C,EAC/B+D,EAAWjB,EAAQ,SAEnBkB,EAAkB,IAAM,IAC5B,MAAkChE,EAAO,UAAU,CACrD,EAEMiE,EAAqD,CACzD,CAAE,MAAOhE,EAAiB,QAAS,MAAO,SAAU,EACpD,CAAE,MAAOA,EAAiB,QAAS,MAAO,SAAU,EACpD,CAAE,MAAOA,EAAiB,SAAU,MAAO,WAAY,EACvD,CAAE,MAAOA,EAAiB,WAAY,MAAO,aAAc,CAC7D,EAEMiE,EAAyD,CAC7D,CAAE,MAAOhE,EAAmB,SAAU,MAAO,kBAAmB,EAChE,CAAE,MAAOA,EAAmB,YAAa,MAAO,qBAAsB,CACxE,EAEMiE,EAA4BC,GACxB7D,GAA2B,IACjC,MAAqCP,EAAOoE,EAAU7D,EAAM,KAAK,CACnE,EAGI8D,EAAwBC,GAA4C,IACxE,MAAqCtE,EAAO,cAAesE,EAAM,cAAc,OAAO,CACxF,EAEMC,EAAqBH,GACjBE,GAA4C,CAClDvB,EAAgB,CAAE,GAAGD,EAAc,CAACsB,CAAQ,EAAGE,EAAM,cAAc,KAAQ,CAAC,CAC9E,EAGIE,EAAa,GAEnB,OACE,gCACE,gBAACC,EAAA,GACC,eAAe,WACf,SAAS,gEACT,kBAAmB,GACrB,EAEA,gBAAC,KAAO,IAAC,EAET,gBAACC,EAAA,EAAQ,CAAC,YAAW,GAAC,MAAM,mBAAmB,OAAAb,EAAgB,SAAU,IAAMC,EAAWa,GAAM,CAACA,CAAC,GAAG,qHAE5F,gBAAC,SAAG,EAAE,0HAEG,gBAAC,YAAK,mBAAiB,EAAO,QAAK,gBAAC,YAAK,kBAAgB,EAAO,uBAAoB,gBAAC,SAAG,EAAE,8BAC/E,gBAAC,cAAO,QAAM,EAAS,wHAEpD,EAEA,gBAAC,KAAO,IAAC,EAET,gBAACC,EAAA,EAAa,CAAC,MAAM,cACnB,gBAACC,EAAA,EAAK,CAAC,MAAM,WAAW,SAAQ,IAC9B,gBAACC,EAAA,GACC,MAAON,EACP,KAAK,OACL,KAAK,OACL,MAAO1B,EAAQ,KAAO,GACtB,YAAY,iBACZ,SAAUyB,EAAkB,KAAK,EACnC,CACF,EAEA,gBAACM,EAAA,EAAK,CAAC,MAAM,gBAAgB,SAAQ,IACnC,gBAACC,EAAA,GACC,MAAON,EACP,KAAK,WACL,MAAOT,EAAS,UAAY,GAC5B,YAAY,WACZ,YAAU,MAAiC/D,EAAO,UAAU,EAC9D,CACF,CACF,EAEA,gBAAC,KAAO,IAAC,EAET,gBAAC4E,EAAA,EAAa,CAAC,MAAM,kBACnB,gBAACC,EAAA,EAAK,CAAC,MAAM,WAAW,SAAQ,IAC9B,gBAACC,EAAA,GACC,MAAON,EACP,MAAO1B,EAAQ,MAAQ,GACvB,YAAY,WACZ,SAAUyB,EAAkB,MAAM,EACpC,CACF,EAEA,gBAACM,EAAA,EAAK,CAAC,MAAM,WAAW,SAAQ,IAC9B,gBAACE,EAAA,IACC,MAAOP,EACP,YAAY,WACZ,aAAc1B,EAAQ,kBAAoBA,EAAQ,iBAAiB,SACnE,QAASkB,EACT,UAAQ,MAAuChE,EAAO,UAAU,EAClE,CACF,EAEA,gBAAC6E,EAAA,GACC,MACE,gBAACG,EAAA,EAAK,KACJ,gBAACC,EAAA,EAAK,CAAC,IAAK,IACV,gBAAC,YAAK,cAAY,EAClB,gBAACC,EAAA,GACC,QACE,gBAAC,YAAK,4HAGN,GAGF,gBAACC,EAAA,EAAI,CAAC,KAAK,cAAc,KAAK,IAAK,EACrC,CACF,CACF,GAGF,gBAACC,EAAA,IACC,QAASnB,EACT,MAAOF,EAAS,SAAW9D,EAAiB,WAC5C,SAAUkE,EAAyB,SAAS,EAC5C,MAAOK,CAAA,CACT,CACF,EAEC1B,EAAQ,SAAS,UAAY7C,EAAiB,QAC7C,gBAAC4E,EAAA,GACC,MACE,gBAACG,EAAA,EAAK,KACJ,gBAACC,EAAA,EAAK,CAAC,IAAK,IACV,gBAAC,YAAK,gBAAc,EACpB,gBAACC,EAAA,GACC,QACE,gBAAC,YAAK,8EACwE,IAC5E,gBAAC,SAAE,kBAAgB,EAAI,yNAGvB,gBAAC,SAAG,EACJ,gBAAC,SAAG,EAAE,aACI,gBAAC,SAAE,qBAAmB,EAAI,wQAItC,GAGF,gBAACC,EAAA,EAAI,CAAC,KAAK,cAAc,KAAK,IAAK,EACrC,CACF,CACF,GAGF,gBAACC,EAAA,IACC,QAASlB,EACT,MAAOH,EAAS,wBAA0B7D,EAAmB,SAC7D,SAAUiE,EAAyB,wBAAwB,EAC3D,MAAOK,CAAA,CACT,CACF,EACE,IACN,EAECT,EAAS,UAAY9D,EAAiB,QACrC,gCACE,gBAAC,KAAO,IAAC,EACT,gBAAC2E,EAAA,EAAa,CAAC,MAAM,wBAClBb,EAAS,yBAA2B7D,EAAmB,YACtD,gBAAC,MACC,WACE6D,EAAS,UAAY9D,EAAiB,UAAY8D,EAAS,UAAY9D,EAAiB,WAE1F,YAAaD,EACb,WAAYwE,CAAA,CACd,EAEA,gCACE,gBAACK,EAAA,GACC,MACE,gBAACG,EAAA,EAAK,KACJ,gBAACC,EAAA,EAAK,CAAC,IAAK,IACV,gBAAC,YAAK,0BAAwB,EAC9B,gBAACC,EAAA,GACC,QACE,gBAAC,YAAK,qGAGN,GAGF,gBAACC,EAAA,EAAI,CAAC,KAAK,cAAc,KAAK,IAAK,EACrC,CACF,CACF,GAGF,gBAACL,EAAA,GACC,MAAOf,EAAS,iBAAmB,GACnC,YAAU,MAAiC/D,EAAO,iBAAiB,EACnE,YAAY,yBACZ,MAAOwE,CAAA,CACT,CACF,EACA,gBAACK,EAAA,GACC,MACE,gBAACG,EAAA,EAAK,KACJ,gBAACC,EAAA,EAAK,CAAC,IAAK,IACV,gBAAC,YAAK,4BAA0B,EAChC,gBAACC,EAAA,GACC,QACE,gBAAC,YAAK,qKAGN,GAGF,gBAACC,EAAA,EAAI,CAAC,KAAK,cAAc,KAAK,IAAK,EACrC,CACF,CACF,GAGF,gBAACL,EAAA,GACC,MAAOf,EAAS,aAAe,GAC/B,YAAU,MAAiC/D,EAAO,aAAa,EAC/D,YAAY,2BACZ,MAAOwE,CAAA,CACT,CACF,EACA,gBAACK,EAAA,GACC,MACE,gBAACG,EAAA,EAAK,KACJ,gBAACC,EAAA,EAAK,CAAC,IAAK,IACV,gBAAC,YAAK,oBAAkB,EACxB,gBAACC,EAAA,GACC,QACE,gBAAC,YAAK,oIAEoC,gBAAC,SAAE,MAAI,EAAI,sDAErD,GAGF,gBAACC,EAAA,EAAI,CAAC,KAAK,cAAc,KAAK,IAAK,EACrC,CACF,CACF,GAGF,gBAACL,EAAA,GACC,MAAOf,EAAS,YAAc,GAC9B,YAAU,MAAiC/D,EAAO,YAAY,EAC9D,YAAY,0BACZ,MAAOwE,CAAA,CACT,CACF,CACF,CAEJ,CACF,EACE,KAEJ,gBAAC,KAAO,IAAC,EAET,gBAACI,EAAA,EAAa,CAAC,MAAM,sBAAsB,cAAa,IACtD,gBAACS,EAAA,EAAgB,CAAC,MAAM,sBACtB,gBAACR,EAAA,GACC,MACE,gBAACG,EAAA,EAAK,KACJ,gBAACC,EAAA,EAAK,CAAC,IAAK,IACV,gBAAC,YAAK,SAAO,EACb,gBAACC,EAAA,GACC,QACE,gBAAC,YAAK,mFAAiF,GAGzF,gBAACC,EAAA,EAAI,CAAC,KAAK,cAAc,KAAK,IAAK,EACrC,CACF,CACF,GAGF,gBAACC,EAAA,IACC,MAAOrB,EAAS,iBAAmB,IACnC,SAAUI,EAAyB,iBAAiB,EACpD,QAASP,EACT,MAAOY,CAAA,CACT,CACF,EACA,gBAACK,EAAA,GACC,MACE,gBAACG,EAAA,EAAK,KACJ,gBAACC,EAAA,EAAK,CAAC,IAAK,IACV,gBAAC,YAAK,mBAAiB,EACvB,gBAACC,EAAA,GACC,QACE,gBAAC,YAAK,2GAGJ,gBAAC,YAAK,IAAE,EAAO,wCACjB,GAGF,gBAACC,EAAA,EAAI,CAAC,KAAK,cAAc,KAAK,IAAK,EACrC,CACF,CACF,GAGF,gBAACL,EAAA,GACC,YAAY,KACZ,MAAOf,EAAS,cAAgB,GAChC,YAAU,MAAiC/D,EAAO,cAAc,EAChE,MAAOwE,CAAA,CACT,CACF,EACA,gBAACK,EAAA,GACC,MACE,gBAACG,EAAA,EAAK,KACJ,gBAACC,EAAA,EAAK,CAAC,IAAK,IACV,gBAAC,YAAK,aAAW,EACjB,gBAACC,EAAA,GACC,QACE,gBAAC,YAAK,sGAGJ,gBAAC,YAAK,aAAW,EAAO,WAAQ,gBAAC,YAAK,cAAY,EAAO,mFAE3D,GAGF,gBAACC,EAAA,EAAI,CAAC,KAAK,cAAc,KAAK,IAAK,EACrC,CACF,CACF,GAGF,gBAACG,EAAA,EAAM,CAAC,MAAOvB,EAAS,aAAe,GAAO,SAAUM,EAAsB,MAAOG,CAAA,CAAY,CACnG,CACF,EAEA,gBAAC,KAAgB,CAAC,QAAA1B,EAAkB,gBAAAC,CAAA,CAAkC,EAErEwC,EAAA,EAAO,2BACN,gBAACC,EAAA,EAAwB,CAAC,QAAA1C,EAAkB,gBAAAC,CAAA,CAAkC,CAElF,CACF,CAEJ,EC9Ya,GAAS,IAAI,KACxBd,CACF,EACG,eAAelC,CAAmB,EAClC,mBAAmBL,CAAU,EAC7B,gBAAgBiE,EAAoB,C,YCRvC8B,EAAO,QAAU,SAASC,EAAMC,EAAGC,EAAG,CACpC,GAAID,IAAMC,EAAG,MAAO,GAEpB,GAAID,GAAKC,GAAK,OAAOD,GAAK,UAAY,OAAOC,GAAK,SAAU,CAC1D,GAAID,EAAE,cAAgBC,EAAE,YAAa,MAAO,GAE5C,IAAIC,EAAQrD,EAAGsD,EACf,GAAI,MAAM,QAAQH,CAAC,EAAG,CAEpB,GADAE,EAASF,EAAE,OACPE,GAAUD,EAAE,OAAQ,MAAO,GAC/B,IAAKpD,EAAIqD,EAAQrD,MAAQ,GACvB,GAAI,CAACkD,EAAMC,EAAEnD,CAAC,EAAGoD,EAAEpD,CAAC,CAAC,EAAG,MAAO,GACjC,MAAO,GAKT,GAAImD,EAAE,cAAgB,OAAQ,OAAOA,EAAE,SAAWC,EAAE,QAAUD,EAAE,QAAUC,EAAE,MAC5E,GAAID,EAAE,UAAY,OAAO,UAAU,QAAS,OAAOA,EAAE,QAAQ,IAAMC,EAAE,QAAQ,EAC7E,GAAID,EAAE,WAAa,OAAO,UAAU,SAAU,OAAOA,EAAE,SAAS,IAAMC,EAAE,SAAS,EAIjF,GAFAE,EAAO,OAAO,KAAKH,CAAC,EACpBE,EAASC,EAAK,OACVD,IAAW,OAAO,KAAKD,CAAC,EAAE,OAAQ,MAAO,GAE7C,IAAKpD,EAAIqD,EAAQrD,MAAQ,GACvB,GAAI,CAAC,OAAO,UAAU,eAAe,KAAKoD,EAAGE,EAAKtD,CAAC,CAAC,EAAG,MAAO,GAEhE,IAAKA,EAAIqD,EAAQrD,MAAQ,GAAI,CAC3B,IAAIuD,EAAMD,EAAKtD,CAAC,EAEhB,GAAI,EAAAuD,IAAQ,UAAYJ,EAAE,WAOtB,CAACD,EAAMC,EAAEI,CAAG,EAAGH,EAAEG,CAAG,CAAC,EAAG,MAAO,GAGrC,MAAO,GAIT,OAAOJ,IAAIA,GAAKC,IAAIA,CACtB,C,kDCnDII,EAAc,SAAUC,EAAK,CAAE,OAAOA,IAAQ,OAAOA,CAAG,CAAG,EAC3DC,EAAyB,SAAUC,EAAQC,EAAMC,EAAW,CAY5D,IAAIC,KAAM,UAAO,MAAS,GACtB,CAACA,EAAI,SAAW,CAACD,EAAUD,EAAME,EAAI,OAAO,KAC5CA,EAAI,QAAUF,MAElB,aAAUD,EAAQG,EAAI,OAAO,CACjC,EACA,QAAeJ,E,wBCnBf,QAAe,ICCf,IAAI,EAAc,SAAUD,EAAK,CAAE,OAAOA,IAAQ,OAAOA,CAAG,CAAG,EAC3DjD,EAAuB,SAAUmD,EAAQC,EAAM,CAS/C,EAAuBD,EAAQC,EAAMG,CAAW,CACpD,EACA,QAAevD,C","sources":["webpack://grafana/./public/app/plugins/datasource/grafana-postgresql-datasource/CheatSheet.tsx","webpack://grafana/./public/app/plugins/datasource/grafana-postgresql-datasource/PostgresQueryEditor.tsx","webpack://grafana/./public/app/plugins/datasource/grafana-postgresql-datasource/types.ts","webpack://grafana/./public/app/plugins/datasource/grafana-postgresql-datasource/PostgresQueryModel.ts","webpack://grafana/./public/app/plugins/datasource/grafana-postgresql-datasource/postgresMetaQuery.ts","webpack://grafana/./public/app/plugins/datasource/grafana-postgresql-datasource/sqlCompletionProvider.ts","webpack://grafana/./public/app/plugins/datasource/grafana-postgresql-datasource/sqlUtil.ts","webpack://grafana/./public/app/plugins/datasource/grafana-postgresql-datasource/datasource.ts","webpack://grafana/./public/app/plugins/datasource/grafana-postgresql-datasource/configuration/useAutoDetectFeatures.ts","webpack://grafana/./public/app/plugins/datasource/grafana-postgresql-datasource/configuration/ConfigurationEditor.tsx","webpack://grafana/./public/app/plugins/datasource/grafana-postgresql-datasource/module.ts","webpack://grafana/./node_modules/fast-deep-equal/react.js","webpack://grafana/./node_modules/react-use/esm/useCustomCompareEffect.js","webpack://grafana/./node_modules/react-use/esm/misc/isDeepEqual.js","webpack://grafana/./node_modules/react-use/esm/useDeepCompareEffect.js"],"sourcesContent":["import { css } from '@emotion/css';\nimport React from 'react';\n\nimport { GrafanaTheme2 } from '@grafana/data';\nimport { useStyles2 } from '@grafana/ui';\n\nexport function CheatSheet() {\n const styles = useStyles2(getStyles);\n\n return (\n <div>\n <h2>PostgreSQL cheat sheet</h2>\n Time series:\n <ul className={styles.ulPadding}>\n <li>\n return column named <i>time</i> (UTC in seconds or timestamp)\n </li>\n <li>return column(s) with numeric datatype as values</li>\n </ul>\n Optional:\n <ul className={styles.ulPadding}>\n <li>\n return column named <i>metric</i> to represent the series name.\n </li>\n <li>If multiple value columns are returned the metric column is used as prefix.</li>\n <li>If no column named metric is found the column name of the value column is used as series name</li>\n </ul>\n <p>Resultsets of time series queries need to be sorted by time.</p>\n Table:\n <ul className={styles.ulPadding}>\n <li>return any set of columns</li>\n </ul>\n Macros:\n <ul className={styles.ulPadding}>\n <li>$__time(column) -> column as "time"</li>\n <li>$__timeEpoch -> extract(epoch from column) as "time"</li>\n <li>\n $__timeFilter(column) -> column BETWEEN '2017-04-21T05:01:17Z' AND\n '2017-04-21T05:01:17Z'\n </li>\n <li>$__unixEpochFilter(column) -> column >= 1492750877 AND column <= 1492750877</li>\n <li>\n $__unixEpochNanoFilter(column) -> column >= 1494410783152415214 AND column <= 1494497183142514872\n </li>\n <li>\n $__timeGroup(column,'5m'[, fillvalue]) -> (extract(epoch from column)/300)::bigint*300 by setting\n fillvalue grafana will fill in missing values according to the interval fillvalue can be either a literal\n value, NULL or previous; previous will fill in the previous seen value or NULL if none has been seen yet\n </li>\n <li>\n $__timeGroupAlias(column,'5m') -> (extract(epoch from column)/300)::bigint*300 AS\n "time"\n </li>\n <li>$__unixEpochGroup(column,'5m') -> floor(column/300)*300</li>\n <li>$__unixEpochGroupAlias(column,'5m') -> floor(column/300)*300 AS "time"</li>\n </ul>\n <p>Example of group by and order by with $__timeGroup:</p>\n <pre>\n <code>\n SELECT $__timeGroup(date_time_col, '1h'), sum(value) as value <br />\n FROM yourtable\n <br />\n GROUP BY time\n <br />\n ORDER BY time\n <br />\n </code>\n </pre>\n Or build your own conditionals using these macros which just return the values:\n <ul className={styles.ulPadding}>\n <li>$__timeFrom() -> '2017-04-21T05:01:17Z'</li>\n <li>$__timeTo() -> '2017-04-21T05:01:17Z'</li>\n <li>$__unixEpochFrom() -> 1492750877</li>\n <li>$__unixEpochTo() -> 1492750877</li>\n <li>$__unixEpochNanoFrom() -> 1494410783152415214</li>\n <li>$__unixEpochNanoTo() -> 1494497183142514872</li>\n </ul>\n </div>\n );\n}\n\nfunction getStyles(theme: GrafanaTheme2) {\n return {\n ulPadding: css({\n margin: theme.spacing(1, 0),\n paddingLeft: theme.spacing(5),\n }),\n };\n}\n","import React from 'react';\n\nimport { QueryEditorProps } from '@grafana/data';\nimport { SqlQueryEditor, SQLOptions, SQLQuery, QueryHeaderProps } from '@grafana/sql';\n\nimport { PostgresDatasource } from './datasource';\n\nconst queryHeaderProps: Pick<QueryHeaderProps, 'dialect'> = { dialect: 'postgres' };\n\nexport function PostgresQueryEditor(props: QueryEditorProps<PostgresDatasource, SQLQuery, SQLOptions>) {\n return <SqlQueryEditor {...props} queryHeaderProps={queryHeaderProps} />;\n}\n","import { SQLOptions } from '@grafana/sql';\n\nexport enum PostgresTLSModes {\n disable = 'disable',\n require = 'require',\n verifyCA = 'verify-ca',\n verifyFull = 'verify-full',\n}\n\nexport enum PostgresTLSMethods {\n filePath = 'file-path',\n fileContent = 'file-content',\n}\nexport interface PostgresOptions extends SQLOptions {\n tlsConfigurationMethod?: PostgresTLSMethods;\n sslmode?: PostgresTLSModes;\n sslRootCertFile?: string;\n sslCertFile?: string;\n sslKeyFile?: string;\n postgresVersion?: number;\n timescaledb?: boolean;\n enableSecureSocksProxy?: boolean;\n}\n\nexport interface SecureJsonData {\n password?: string;\n}\n","import { ScopedVars } from '@grafana/data';\nimport { TemplateSrv } from '@grafana/runtime';\nimport { VariableFormatID } from '@grafana/schema';\nimport { SQLQuery, SqlQueryModel, applyQueryDefaults } from '@grafana/sql';\n\nexport class PostgresQueryModel implements SqlQueryModel {\n target: SQLQuery;\n templateSrv?: TemplateSrv;\n scopedVars?: ScopedVars;\n\n constructor(target?: SQLQuery, templateSrv?: TemplateSrv, scopedVars?: ScopedVars) {\n this.target = applyQueryDefaults(target || { refId: 'A' });\n this.templateSrv = templateSrv;\n this.scopedVars = scopedVars;\n }\n\n interpolate() {\n return this.templateSrv?.replace(this.target.rawSql, this.scopedVars, VariableFormatID.SQLString) || '';\n }\n\n quoteLiteral(value: string) {\n return \"'\" + value.replace(/'/g, \"''\") + \"'\";\n }\n}\n","export function getVersion() {\n return \"SELECT current_setting('server_version_num')::int/100 as version\";\n}\n\nexport function getTimescaleDBVersion() {\n return \"SELECT extversion FROM pg_extension WHERE extname = 'timescaledb'\";\n}\n\nexport function showTables() {\n return `select quote_ident(table_name) as \"table\" from information_schema.tables\n where quote_ident(table_schema) not in ('information_schema',\n 'pg_catalog',\n '_timescaledb_cache',\n '_timescaledb_catalog',\n '_timescaledb_internal',\n '_timescaledb_config',\n 'timescaledb_information',\n 'timescaledb_experimental')\n and ${buildSchemaConstraint()}`;\n}\n\nexport function getSchema(table: string) {\n // we will put table-name between single-quotes, so we need to escape single-quotes\n // in the table-name\n const tableNamePart = \"'\" + table.replace(/'/g, \"''\") + \"'\";\n\n return `select quote_ident(column_name) as \"column\", data_type as \"type\"\n from information_schema.columns\n where quote_ident(table_name) = ${tableNamePart};\n `;\n}\n\nfunction buildSchemaConstraint() {\n // quote_ident protects hyphenated schemes\n return `\n quote_ident(table_schema) IN (\n SELECT\n CASE WHEN trim(s[i]) = '\"$user\"' THEN user ELSE trim(s[i]) END\n FROM\n generate_series(\n array_lower(string_to_array(current_setting('search_path'),','),1),\n array_upper(string_to_array(current_setting('search_path'),','),1)\n ) as i,\n string_to_array(current_setting('search_path'),',') s\n )`;\n}\n","import {\n ColumnDefinition,\n getStandardSQLCompletionProvider,\n LanguageCompletionProvider,\n TableDefinition,\n TableIdentifier,\n} from '@grafana/experimental';\nimport { DB, SQLQuery } from '@grafana/sql';\n\ninterface CompletionProviderGetterArgs {\n getColumns: React.MutableRefObject<(t: SQLQuery) => Promise<ColumnDefinition[]>>;\n getTables: React.MutableRefObject<(d?: string) => Promise<TableDefinition[]>>;\n}\n\nexport const getSqlCompletionProvider: (args: CompletionProviderGetterArgs) => LanguageCompletionProvider =\n ({ getColumns, getTables }) =>\n (monaco, language) => ({\n ...(language && getStandardSQLCompletionProvider(monaco, language)),\n tables: {\n resolve: async () => {\n return await getTables.current();\n },\n },\n columns: {\n resolve: async (t?: TableIdentifier) => {\n return await getColumns.current({ table: t?.table, refId: 'A' });\n },\n },\n });\n\nexport async function fetchColumns(db: DB, q: SQLQuery) {\n const cols = await db.fields(q);\n if (cols.length > 0) {\n return cols.map((c) => {\n return { name: c.value, type: c.value, description: c.value };\n });\n } else {\n return [];\n }\n}\n\nexport async function fetchTables(db: DB) {\n const tables = await db.lookup?.();\n return tables || [];\n}\n","import { isEmpty } from 'lodash';\n\nimport { createSelectClause, haveColumns, RAQBFieldTypes, SQLQuery } from '@grafana/sql';\n\nexport function getFieldConfig(type: string): { raqbFieldType: RAQBFieldTypes; icon: string } {\n switch (type) {\n case 'boolean': {\n return { raqbFieldType: 'boolean', icon: 'toggle-off' };\n }\n case 'bit':\n case 'bit varying':\n case 'character':\n case 'character varying':\n case 'text': {\n return { raqbFieldType: 'text', icon: 'text' };\n }\n case 'smallint':\n case 'integer':\n case 'bigint':\n case 'decimal':\n case 'numeric':\n case 'real':\n case 'double precision':\n case 'serial':\n case 'bigserial':\n case 'smallserial': {\n return { raqbFieldType: 'number', icon: 'calculator-alt' };\n }\n case 'date': {\n return { raqbFieldType: 'date', icon: 'clock-nine' };\n }\n case 'time':\n case 'time with time zone':\n case 'time without time zone':\n case 'interval': {\n return { raqbFieldType: 'time', icon: 'clock-nine' };\n }\n case 'timestamp':\n case 'timestamp with time zone':\n case 'timestamp without time zone': {\n return { raqbFieldType: 'datetime', icon: 'clock-nine' };\n }\n default:\n return { raqbFieldType: 'text', icon: 'text' };\n }\n}\n\nexport function toRawSql({ sql, table }: SQLQuery): string {\n let rawQuery = '';\n\n // Return early with empty string if there is no sql column\n if (!sql || !haveColumns(sql.columns)) {\n return rawQuery;\n }\n\n rawQuery += createSelectClause(sql.columns);\n\n if (table) {\n rawQuery += `FROM ${table} `;\n }\n\n if (sql.whereString) {\n rawQuery += `WHERE ${sql.whereString} `;\n }\n\n if (sql.groupBy?.[0]?.property.name) {\n const groupBy = sql.groupBy.map((g) => g.property.name).filter((g) => !isEmpty(g));\n rawQuery += `GROUP BY ${groupBy.join(', ')} `;\n }\n\n if (sql.orderBy?.property.name) {\n rawQuery += `ORDER BY ${sql.orderBy.property.name} `;\n }\n\n if (sql.orderBy?.property.name && sql.orderByDirection) {\n rawQuery += `${sql.orderByDirection} `;\n }\n\n // Altough LIMIT 0 doesn't make sense, it is still possible to have LIMIT 0\n if (sql.limit !== undefined && sql.limit >= 0) {\n rawQuery += `LIMIT ${sql.limit} `;\n }\n return rawQuery;\n}\n","import { DataSourceInstanceSettings, ScopedVars } from '@grafana/data';\nimport { LanguageDefinition } from '@grafana/experimental';\nimport { TemplateSrv } from '@grafana/runtime';\nimport { SqlDatasource, DB, SQLQuery, SQLSelectableValue, formatSQL } from '@grafana/sql';\n\nimport { PostgresQueryModel } from './PostgresQueryModel';\nimport { getSchema, getTimescaleDBVersion, getVersion, showTables } from './postgresMetaQuery';\nimport { fetchColumns, fetchTables, getSqlCompletionProvider } from './sqlCompletionProvider';\nimport { getFieldConfig, toRawSql } from './sqlUtil';\nimport { PostgresOptions } from './types';\n\nexport class PostgresDatasource extends SqlDatasource {\n sqlLanguageDefinition: LanguageDefinition | undefined = undefined;\n\n constructor(instanceSettings: DataSourceInstanceSettings<PostgresOptions>) {\n super(instanceSettings);\n }\n\n getQueryModel(target?: SQLQuery, templateSrv?: TemplateSrv, scopedVars?: ScopedVars): PostgresQueryModel {\n return new PostgresQueryModel(target, templateSrv, scopedVars);\n }\n\n async getVersion(): Promise<string> {\n const value = await this.runSql<{ version: number }>(getVersion());\n const results = value.fields.version?.values;\n\n if (!results) {\n return '';\n }\n\n return results[0].toString();\n }\n\n async getTimescaleDBVersion(): Promise<string | undefined> {\n const value = await this.runSql<{ extversion: string }>(getTimescaleDBVersion());\n const results = value.fields.extversion?.values;\n\n if (!results) {\n return undefined;\n }\n\n return results[0];\n }\n\n async fetchTables(): Promise<string[]> {\n const tables = await this.runSql<{ table: string[] }>(showTables(), { refId: 'tables' });\n return tables.fields.table?.values.flat() ?? [];\n }\n\n getSqlLanguageDefinition(db: DB): LanguageDefinition {\n if (this.sqlLanguageDefinition !== undefined) {\n return this.sqlLanguageDefinition;\n }\n\n const args = {\n getColumns: { current: (query: SQLQuery) => fetchColumns(db, query) },\n getTables: { current: () => fetchTables(db) },\n };\n this.sqlLanguageDefinition = {\n id: 'pgsql',\n completionProvider: getSqlCompletionProvider(args),\n formatter: formatSQL,\n };\n return this.sqlLanguageDefinition;\n }\n\n async fetchFields(query: SQLQuery): Promise<SQLSelectableValue[]> {\n const { table } = query;\n if (table === undefined) {\n // if no table-name, we are not able to query for fields\n return [];\n }\n const schema = await this.runSql<{ column: string; type: string }>(getSchema(table), { refId: 'columns' });\n const result: SQLSelectableValue[] = [];\n for (let i = 0; i < schema.length; i++) {\n const column = schema.fields.column.values[i];\n const type = schema.fields.type.values[i];\n result.push({ label: column, value: column, type, ...getFieldConfig(type) });\n }\n return result;\n }\n\n getDB(): DB {\n if (this.db !== undefined) {\n return this.db;\n }\n\n return {\n init: () => Promise.resolve(true),\n datasets: () => Promise.resolve([]),\n tables: () => this.fetchTables(),\n getEditorLanguageDefinition: () => this.getSqlLanguageDefinition(this.db),\n fields: async (query: SQLQuery) => {\n if (!query?.table) {\n return [];\n }\n return this.fetchFields(query);\n },\n validateQuery: (query) =>\n Promise.resolve({ isError: false, isValid: true, query, error: '', rawSql: query.rawSql }),\n dsID: () => this.id,\n toRawSql,\n lookup: async () => {\n const tables = await this.fetchTables();\n return tables.map((t) => ({ name: t, completion: t }));\n },\n };\n }\n}\n","import { Dispatch, SetStateAction, useState } from 'react';\nimport { useDeepCompareEffect } from 'react-use';\n\nimport {\n DataSourcePluginOptionsEditorProps,\n DataSourceSettings,\n SelectableValue,\n updateDatasourcePluginJsonDataOption,\n updateDatasourcePluginOption,\n} from '@grafana/data';\nimport { getBackendSrv, getDataSourceSrv } from '@grafana/runtime';\n\nimport { PostgresDatasource } from '../datasource';\nimport { PostgresOptions, PostgresTLSModes, SecureJsonData } from '../types';\n\nimport { postgresVersions } from './ConfigurationEditor';\n\ntype Options = {\n props: DataSourcePluginOptionsEditorProps<PostgresOptions, SecureJsonData>;\n setVersionOptions: Dispatch<SetStateAction<Array<SelectableValue<number>>>>;\n};\n\nexport function useAutoDetectFeatures({ props, setVersionOptions }: Options) {\n const [saved, setSaved] = useState(false);\n const { options, onOptionsChange } = props;\n\n useDeepCompareEffect(() => {\n const getVersion = async () => {\n if (!saved) {\n // We need to save the datasource before we can get the version so we can query the database with the options we have.\n const result = await getBackendSrv().put<{ datasource: DataSourceSettings }>(\n `/api/datasources/${options.id}`,\n options\n );\n\n setSaved(true);\n // This is needed or else we get an error when we try to save the datasource.\n updateDatasourcePluginOption({ options, onOptionsChange }, 'version', result.datasource.version);\n } else {\n const datasource = await getDataSourceSrv().get(options.name);\n\n if (datasource instanceof PostgresDatasource) {\n const version = await datasource.getVersion();\n const versionNumber = parseInt(version, 10);\n\n // timescaledb is only available for 9.6+\n if (versionNumber >= 906 && !options.jsonData.timescaledb) {\n const timescaledbVersion = await datasource.getTimescaleDBVersion();\n if (timescaledbVersion) {\n updateDatasourcePluginJsonDataOption({ options, onOptionsChange }, 'timescaledb', true);\n }\n }\n const major = Math.trunc(versionNumber / 100);\n const minor = versionNumber % 100;\n let name = String(major);\n if (versionNumber < 1000) {\n name = String(major) + '.' + String(minor);\n }\n if (!postgresVersions.find((p) => p.value === versionNumber)) {\n setVersionOptions((prev) => [...prev, { label: name, value: versionNumber }]);\n }\n if (options.jsonData.postgresVersion === undefined || options.jsonData.postgresVersion !== versionNumber) {\n updateDatasourcePluginJsonDataOption({ options, onOptionsChange }, 'postgresVersion', versionNumber);\n }\n }\n }\n };\n // This logic is only going to run when we create a new datasource\n if (isValidConfig(options)) {\n getVersion();\n }\n }, [options, saved, setVersionOptions]);\n}\n\nfunction isValidConfig(options: DataSourceSettings<PostgresOptions, SecureJsonData>) {\n return (\n options.url &&\n options.jsonData.database &&\n options.user &&\n (options.secureJsonData?.password || options.secureJsonFields?.password) &&\n (options.jsonData.sslmode === PostgresTLSModes.disable ||\n (options.jsonData.sslCertFile && options.jsonData.sslKeyFile && options.jsonData.sslRootCertFile)) &&\n !options.jsonData.postgresVersion &&\n !options.readOnly\n );\n}\n","import React, { SyntheticEvent, useState } from 'react';\n\nimport {\n DataSourcePluginOptionsEditorProps,\n onUpdateDatasourceJsonDataOption,\n onUpdateDatasourceSecureJsonDataOption,\n SelectableValue,\n updateDatasourcePluginJsonDataOption,\n updateDatasourcePluginResetOption,\n} from '@grafana/data';\nimport { ConfigSection, ConfigSubSection, DataSourceDescription, Stack } from '@grafana/experimental';\nimport { config } from '@grafana/runtime';\nimport { ConnectionLimits, Divider, TLSSecretsConfig, useMigrateDatabaseFields } from '@grafana/sql';\nimport {\n Input,\n Select,\n SecretInput,\n Field,\n Tooltip,\n Label,\n Icon,\n Switch,\n SecureSocksProxySettings,\n Collapse,\n} from '@grafana/ui';\n\nimport { PostgresOptions, PostgresTLSMethods, PostgresTLSModes, SecureJsonData } from '../types';\n\nimport { useAutoDetectFeatures } from './useAutoDetectFeatures';\n\nexport const postgresVersions: Array<SelectableValue<number>> = [\n { label: '9.0', value: 900 },\n { label: '9.1', value: 901 },\n { label: '9.2', value: 902 },\n { label: '9.3', value: 903 },\n { label: '9.4', value: 904 },\n { label: '9.5', value: 905 },\n { label: '9.6', value: 906 },\n { label: '10', value: 1000 },\n { label: '11', value: 1100 },\n { label: '12', value: 1200 },\n { label: '13', value: 1300 },\n { label: '14', value: 1400 },\n { label: '15', value: 1500 },\n];\n\nexport const PostgresConfigEditor = (props: DataSourcePluginOptionsEditorProps<PostgresOptions, SecureJsonData>) => {\n const [versionOptions, setVersionOptions] = useState(postgresVersions);\n const [isOpen, setIsOpen] = useState(true);\n\n useAutoDetectFeatures({ props, setVersionOptions });\n useMigrateDatabaseFields(props);\n\n const { options, onOptionsChange } = props;\n const jsonData = options.jsonData;\n\n const onResetPassword = () => {\n updateDatasourcePluginResetOption(props, 'password');\n };\n\n const tlsModes: Array<SelectableValue<PostgresTLSModes>> = [\n { value: PostgresTLSModes.disable, label: 'disable' },\n { value: PostgresTLSModes.require, label: 'require' },\n { value: PostgresTLSModes.verifyCA, label: 'verify-ca' },\n { value: PostgresTLSModes.verifyFull, label: 'verify-full' },\n ];\n\n const tlsMethods: Array<SelectableValue<PostgresTLSMethods>> = [\n { value: PostgresTLSMethods.filePath, label: 'File system path' },\n { value: PostgresTLSMethods.fileContent, label: 'Certificate content' },\n ];\n\n const onJSONDataOptionSelected = (property: keyof PostgresOptions) => {\n return (value: SelectableValue) => {\n updateDatasourcePluginJsonDataOption(props, property, value.value);\n };\n };\n\n const onTimeScaleDBChanged = (event: SyntheticEvent<HTMLInputElement>) => {\n updateDatasourcePluginJsonDataOption(props, 'timescaledb', event.currentTarget.checked);\n };\n\n const onDSOptionChanged = (property: keyof PostgresOptions) => {\n return (event: SyntheticEvent<HTMLInputElement>) => {\n onOptionsChange({ ...options, ...{ [property]: event.currentTarget.value } });\n };\n };\n\n const WIDTH_LONG = 40;\n\n return (\n <>\n <DataSourceDescription\n dataSourceName=\"Postgres\"\n docsLink=\"https://grafana.com/docs/grafana/latest/datasources/postgres/\"\n hasRequiredFields={true}\n />\n\n <Divider />\n\n <Collapse collapsible label=\"User Permissions\" isOpen={isOpen} onToggle={() => setIsOpen((x) => !x)}>\n The database user should only be granted SELECT permissions on the specified database & tables you want to\n query. <br />\n Grafana does not validate that queries are safe so queries can contain any SQL statement. For example,\n statements like <code>DELETE FROM user;</code> and <code>DROP TABLE user;</code> would be executed. <br />\n To protect against this we <strong>Highly</strong> recommend you create a specific PostgreSQL user with\n restricted permissions. Check out the docs for more information.\n </Collapse>\n\n <Divider />\n\n <ConfigSection title=\"Connection\">\n <Field label=\"Host URL\" required>\n <Input\n width={WIDTH_LONG}\n name=\"host\"\n type=\"text\"\n value={options.url || ''}\n placeholder=\"localhost:5432\"\n onChange={onDSOptionChanged('url')}\n />\n </Field>\n\n <Field label=\"Database name\" required>\n <Input\n width={WIDTH_LONG}\n name=\"database\"\n value={jsonData.database || ''}\n placeholder=\"Database\"\n onChange={onUpdateDatasourceJsonDataOption(props, 'database')}\n />\n </Field>\n </ConfigSection>\n\n <Divider />\n\n <ConfigSection title=\"Authentication\">\n <Field label=\"Username\" required>\n <Input\n width={WIDTH_LONG}\n value={options.user || ''}\n placeholder=\"Username\"\n onChange={onDSOptionChanged('user')}\n />\n </Field>\n\n <Field label=\"Password\" required>\n <SecretInput\n width={WIDTH_LONG}\n placeholder=\"Password\"\n isConfigured={options.secureJsonFields && options.secureJsonFields.password}\n onReset={onResetPassword}\n onBlur={onUpdateDatasourceSecureJsonDataOption(props, 'password')}\n />\n </Field>\n\n <Field\n label={\n <Label>\n <Stack gap={0.5}>\n <span>TLS/SSL Mode</span>\n <Tooltip\n content={\n <span>\n This option determines whether or with what priority a secure TLS/SSL TCP/IP connection will be\n negotiated with the server\n </span>\n }\n >\n <Icon name=\"info-circle\" size=\"sm\" />\n </Tooltip>\n </Stack>\n </Label>\n }\n >\n <Select\n options={tlsModes}\n value={jsonData.sslmode || PostgresTLSModes.verifyFull}\n onChange={onJSONDataOptionSelected('sslmode')}\n width={WIDTH_LONG}\n />\n </Field>\n\n {options.jsonData.sslmode !== PostgresTLSModes.disable ? (\n <Field\n label={\n <Label>\n <Stack gap={0.5}>\n <span>TLS/SSL Method</span>\n <Tooltip\n content={\n <span>\n This option determines how TLS/SSL certifications are configured. Selecting{' '}\n <i>File system path</i> will allow you to configure certificates by specifying paths to existing\n certificates on the local file system where Grafana is running. Be sure that the file is\n readable by the user executing the Grafana process.\n <br />\n <br />\n Selecting <i>Certificate content</i> will allow you to configure certificates by specifying its\n content. The content will be stored encrypted in Grafana's database. When connecting to the\n database the certificates will be written as files to Grafana's configured data path on the\n local file system.\n </span>\n }\n >\n <Icon name=\"info-circle\" size=\"sm\" />\n </Tooltip>\n </Stack>\n </Label>\n }\n >\n <Select\n options={tlsMethods}\n value={jsonData.tlsConfigurationMethod || PostgresTLSMethods.filePath}\n onChange={onJSONDataOptionSelected('tlsConfigurationMethod')}\n width={WIDTH_LONG}\n />\n </Field>\n ) : null}\n </ConfigSection>\n\n {jsonData.sslmode !== PostgresTLSModes.disable ? (\n <>\n <Divider />\n <ConfigSection title=\"TLS/SSL Auth Details\">\n {jsonData.tlsConfigurationMethod === PostgresTLSMethods.fileContent ? (\n <TLSSecretsConfig\n showCACert={\n jsonData.sslmode === PostgresTLSModes.verifyCA || jsonData.sslmode === PostgresTLSModes.verifyFull\n }\n editorProps={props}\n labelWidth={WIDTH_LONG}\n />\n ) : (\n <>\n <Field\n label={\n <Label>\n <Stack gap={0.5}>\n <span>TLS/SSL Root Certificate</span>\n <Tooltip\n content={\n <span>\n If the selected TLS/SSL mode requires a server root certificate, provide the path to the\n file here.\n </span>\n }\n >\n <Icon name=\"info-circle\" size=\"sm\" />\n </Tooltip>\n </Stack>\n </Label>\n }\n >\n <Input\n value={jsonData.sslRootCertFile || ''}\n onChange={onUpdateDatasourceJsonDataOption(props, 'sslRootCertFile')}\n placeholder=\"TLS/SSL root cert file\"\n width={WIDTH_LONG}\n />\n </Field>\n <Field\n label={\n <Label>\n <Stack gap={0.5}>\n <span>TLS/SSL Client Certificate</span>\n <Tooltip\n content={\n <span>\n To authenticate with an TLS/SSL client certificate, provide the path to the file here. Be\n sure that the file is readable by the user executing the grafana process.\n </span>\n }\n >\n <Icon name=\"info-circle\" size=\"sm\" />\n </Tooltip>\n </Stack>\n </Label>\n }\n >\n <Input\n value={jsonData.sslCertFile || ''}\n onChange={onUpdateDatasourceJsonDataOption(props, 'sslCertFile')}\n placeholder=\"TLS/SSL client cert file\"\n width={WIDTH_LONG}\n />\n </Field>\n <Field\n label={\n <Label>\n <Stack gap={0.5}>\n <span>TLS/SSL Client Key</span>\n <Tooltip\n content={\n <span>\n To authenticate with a client TLS/SSL certificate, provide the path to the corresponding\n key file here. Be sure that the file is <i>only</i> readable by the user executing the\n grafana process.\n </span>\n }\n >\n <Icon name=\"info-circle\" size=\"sm\" />\n </Tooltip>\n </Stack>\n </Label>\n }\n >\n <Input\n value={jsonData.sslKeyFile || ''}\n onChange={onUpdateDatasourceJsonDataOption(props, 'sslKeyFile')}\n placeholder=\"TLS/SSL client key file\"\n width={WIDTH_LONG}\n />\n </Field>\n </>\n )}\n </ConfigSection>\n </>\n ) : null}\n\n <Divider />\n\n <ConfigSection title=\"Additional settings\" isCollapsible>\n <ConfigSubSection title=\"PostgreSQL Options\">\n <Field\n label={\n <Label>\n <Stack gap={0.5}>\n <span>Version</span>\n <Tooltip\n content={\n <span>This option controls what functions are available in the PostgreSQL query builder</span>\n }\n >\n <Icon name=\"info-circle\" size=\"sm\" />\n </Tooltip>\n </Stack>\n </Label>\n }\n >\n <Select\n value={jsonData.postgresVersion || 903}\n onChange={onJSONDataOptionSelected('postgresVersion')}\n options={versionOptions}\n width={WIDTH_LONG}\n />\n </Field>\n <Field\n label={\n <Label>\n <Stack gap={0.5}>\n <span>Min time interval</span>\n <Tooltip\n content={\n <span>\n A lower limit for the auto group by time interval. Recommended to be set to write frequency, for\n example\n <code>1m</code> if your data is written every minute.\n </span>\n }\n >\n <Icon name=\"info-circle\" size=\"sm\" />\n </Tooltip>\n </Stack>\n </Label>\n }\n >\n <Input\n placeholder=\"1m\"\n value={jsonData.timeInterval || ''}\n onChange={onUpdateDatasourceJsonDataOption(props, 'timeInterval')}\n width={WIDTH_LONG}\n />\n </Field>\n <Field\n label={\n <Label>\n <Stack gap={0.5}>\n <span>TimescaleDB</span>\n <Tooltip\n content={\n <span>\n TimescaleDB is a time-series database built as a PostgreSQL extension. If enabled, Grafana will\n use\n <code>time_bucket</code> in the <code>$__timeGroup</code> macro and display TimescaleDB specific\n aggregate functions in the query builder.\n </span>\n }\n >\n <Icon name=\"info-circle\" size=\"sm\" />\n </Tooltip>\n </Stack>\n </Label>\n }\n >\n <Switch value={jsonData.timescaledb || false} onChange={onTimeScaleDBChanged} width={WIDTH_LONG} />\n </Field>\n </ConfigSubSection>\n\n <ConnectionLimits options={options} onOptionsChange={onOptionsChange} />\n\n {config.secureSocksDSProxyEnabled && (\n <SecureSocksProxySettings options={options} onOptionsChange={onOptionsChange} />\n )}\n </ConfigSection>\n </>\n );\n};\n","import { DataSourcePlugin } from '@grafana/data';\nimport { SQLQuery } from '@grafana/sql';\n\nimport { CheatSheet } from './CheatSheet';\nimport { PostgresQueryEditor } from './PostgresQueryEditor';\nimport { PostgresConfigEditor } from './configuration/ConfigurationEditor';\nimport { PostgresDatasource } from './datasource';\nimport { PostgresOptions, SecureJsonData } from './types';\n\nexport const plugin = new DataSourcePlugin<PostgresDatasource, SQLQuery, PostgresOptions, SecureJsonData>(\n PostgresDatasource\n)\n .setQueryEditor(PostgresQueryEditor)\n .setQueryEditorHelp(CheatSheet)\n .setConfigEditor(PostgresConfigEditor);\n","'use strict';\n\n// do not edit .js files directly - edit src/index.jst\n\n\n\nmodule.exports = function equal(a, b) {\n if (a === b) return true;\n\n if (a && b && typeof a == 'object' && typeof b == 'object') {\n if (a.constructor !== b.constructor) return false;\n\n var length, i, keys;\n if (Array.isArray(a)) {\n length = a.length;\n if (length != b.length) return false;\n for (i = length; i-- !== 0;)\n if (!equal(a[i], b[i])) return false;\n return true;\n }\n\n\n\n if (a.constructor === RegExp) return a.source === b.source && a.flags === b.flags;\n if (a.valueOf !== Object.prototype.valueOf) return a.valueOf() === b.valueOf();\n if (a.toString !== Object.prototype.toString) return a.toString() === b.toString();\n\n keys = Object.keys(a);\n length = keys.length;\n if (length !== Object.keys(b).length) return false;\n\n for (i = length; i-- !== 0;)\n if (!Object.prototype.hasOwnProperty.call(b, keys[i])) return false;\n\n for (i = length; i-- !== 0;) {\n var key = keys[i];\n\n if (key === '_owner' && a.$$typeof) {\n // React-specific: avoid traversing React elements' _owner.\n // _owner contains circular references\n // and is not needed when comparing the actual elements (and not their owners)\n continue;\n }\n\n if (!equal(a[key], b[key])) return false;\n }\n\n return true;\n }\n\n // true if both NaN, false otherwise\n return a!==a && b!==b;\n};\n","import { useEffect, useRef } from 'react';\nvar isPrimitive = function (val) { return val !== Object(val); };\nvar useCustomCompareEffect = function (effect, deps, depsEqual) {\n if (process.env.NODE_ENV !== 'production') {\n if (!(deps instanceof Array) || !deps.length) {\n console.warn('`useCustomCompareEffect` should not be used with no dependencies. Use React.useEffect instead.');\n }\n if (deps.every(isPrimitive)) {\n console.warn('`useCustomCompareEffect` should not be used with dependencies that are all primitive values. Use React.useEffect instead.');\n }\n if (typeof depsEqual !== 'function') {\n console.warn('`useCustomCompareEffect` should be used with depsEqual callback for comparing deps list');\n }\n }\n var ref = useRef(undefined);\n if (!ref.current || !depsEqual(deps, ref.current)) {\n ref.current = deps;\n }\n useEffect(effect, ref.current);\n};\nexport default useCustomCompareEffect;\n","import isDeepEqualReact from 'fast-deep-equal/react';\nexport default isDeepEqualReact;\n","import useCustomCompareEffect from './useCustomCompareEffect';\nimport isDeepEqual from './misc/isDeepEqual';\nvar isPrimitive = function (val) { return val !== Object(val); };\nvar useDeepCompareEffect = function (effect, deps) {\n if (process.env.NODE_ENV !== 'production') {\n if (!(deps instanceof Array) || !deps.length) {\n console.warn('`useDeepCompareEffect` should not be used with no dependencies. Use React.useEffect instead.');\n }\n if (deps.every(isPrimitive)) {\n console.warn('`useDeepCompareEffect` should not be used with dependencies that are all primitive values. Use React.useEffect instead.');\n }\n }\n useCustomCompareEffect(effect, deps, isDeepEqual);\n};\nexport default useDeepCompareEffect;\n"],"names":["CheatSheet","styles","getStyles","theme","queryHeaderProps","PostgresQueryEditor","props","PostgresTLSModes","PostgresTLSMethods","PostgresQueryModel","target","templateSrv","scopedVars","value","getVersion","getTimescaleDBVersion","showTables","buildSchemaConstraint","getSchema","table","getSqlCompletionProvider","getColumns","getTables","monaco","language","t","fetchColumns","db","q","cols","c","fetchTables","getFieldConfig","type","toRawSql","sql","rawQuery","groupBy","g","PostgresDatasource","instanceSettings","results","args","query","schema","result","i","column","useAutoDetectFeatures","setVersionOptions","saved","setSaved","options","onOptionsChange","useDeepCompareEffect","datasource","version","versionNumber","major","minor","name","postgresVersions","p","prev","isValidConfig","PostgresConfigEditor","versionOptions","isOpen","setIsOpen","jsonData","onResetPassword","tlsModes","tlsMethods","onJSONDataOptionSelected","property","onTimeScaleDBChanged","event","onDSOptionChanged","WIDTH_LONG","DataSourceDescription","Collapse","x","ConfigSection","Field","Input","SecretInput","Label","Stack","Tooltip","Icon","Select","ConfigSubSection","Switch","config","SecureSocksProxySettings","module","equal","a","b","length","keys","key","isPrimitive","val","useCustomCompareEffect","effect","deps","depsEqual","ref","isDeepEqual"],"sourceRoot":""}