public void CanParseComplexObject3()
{
var result = new KibanaParser().ConvertQueryParameterValueToJson("!((meta:(controlledBy:'a',index:'b',value:true)))");
Assert.AreEqual(@"[{""meta"":{""controlledBy"":""a"",""index"":""b"",""value"":""true""}}]",
result);
}
public void CanParseUrlToElasticsearchQuery()
{
var result = new KibanaParser().ConvertUrlToElasticsearchQueryString(
"https://example.com/app/kibana#/discover?_g=(refreshInterval:(pause:!t,value:0),time:(from:now-15m,mode:quick,to:now))&_a=(columns:!(_source),index:d9e4bde0-40d1-11e9-a719-3df4f8d2c5eb,interval:auto,query:(language:kuery,query:''),sort:!(createdUtc,desc))", "stuff");
JsonConvert.DeserializeObject(result);
}
static void Main(string[] args)
{
var kibanaUrl = File.ReadAllText("KibanaUrl.txt");
var parser = new KibanaParser();
var elasticsearchQuery = parser.ConvertUrlToElasticsearchQueryString(kibanaUrl, "order_date");
Console.WriteLine(elasticsearchQuery);
File.WriteAllText("ElasticsearchQuery.txt", elasticsearchQuery);
Console.ReadLine();
}
public void CanParseComplexObject2()
{
var result = new KibanaParser().ConvertQueryParameterValueToJson(
@"(description:'',filters:!(('$state':(store:appState),geo_bounding_box:(ignore_unmapped:!t,location:(bottom_right:(lat:55.42901345240742,lon:13.194580078125002),top_left:(lat:56.435166753146135,lon:9.036254882812502))),meta:(alias:!n,disabled:!f,index:'14746b80-3f48-11e9-8d2e-3f08e16da335',key:location,negate:!f,params:(bottom_right:(lat:55.42901345240742,lon:13.194580078125002),top_left:(lat:56.435166753146135,lon:9.036254882812502)),type:geo_bounding_box,value:'{
""lat"": 56.435166753146135,
""lon"": 9.036254882812502
}
to {
""lat"": 55.42901345240742,
""lon"": 13.194580078125002
}')),('$state':(store:appState),meta:(alias:!n,controlledBy:'1551791720117',disabled:!f,index:'14746b80-3f48-11e9-8d2e-3f08e16da335',key:plusUser,negate:!f,params:(query:!t,type:phrase),type:phrase,value:true),query:(match:(plusUser:(query:!t,type:phrase)))),('$state':(store:appState),meta:(alias:!n,disabled:!f,index:'14746b80-3f48-11e9-8d2e-3f08e16da335',key:zipCode,negate:!f,params:(query:'2300',type:phrase),type:phrase,value:'2300'),query:(match:(zipCode:(query:'2300',type:phrase)))),('$state':(store:appState),meta:(alias:!n,controlledBy:'1551791836779',disabled:!f,index:'14746b80-3f48-11e9-8d2e-3f08e16da335',key:foo,negate:!f,params:!('2.36','2.20.3'),type:phrases,value:'2.36, 2.20.3'),query:(bool:(minimum_should_match:1,should:!((match_phrase:(foo:'2.36')),(match_phrase:(foo:'2.20.3'))))))),fullScreenMode:!f,options:(darkTheme:!f,hidePanelTitles:!f,useMargins:!t),panels:!((embeddableConfig:(mapCenter:!(55.785840337419124,10.906677246093752),mapZoom:8),gridData:(h:21,i:'1',w:40,x:0,y:0),id:'0fa4d020-3f4a-11e9-8d2e-3f08e16da335',panelIndex:'1',type:visualization,version:'6.6.1'),(embeddableConfig:(),gridData:(h:12,i:'2',w:10,x:21,y:21),id:'8745c590-3f49-11e9-8d2e-3f08e16da335',panelIndex:'2',type:visualization,version:'6.6.1'),(embeddableConfig:(),gridData:(h:10,i:'3',w:8,x:21,y:33),id:'6d19ca40-3f49-11e9-8d2e-3f08e16da335',panelIndex:'3',type:visualization,version:'6.6.1'),(embeddableConfig:(),gridData:(h:22,i:'4',w:28,x:0,y:43),id:'28311aa0-3f49-11e9-8d2e-3f08e16da335',panelIndex:'4',type:visualization,version:'6.6.1'),(embeddableConfig:(),gridData:(h:22,i:'5',w:21,x:0,y:21),id:eac48160-3f49-11e9-8d2e-3f08e16da335,panelIndex:'5',type:visualization,version:'6.6.1')),query:(language:kuery,query:''),timeRestore:!f,title:Users,viewMode:view)");
JsonConvert.DeserializeObject(result);
}
public void CanParseComplexObject6()
{
var result = new KibanaParser().ConvertUrlToElasticsearchQueryString("http://localhost:5601/app/kibana#/dashboard/722b74f0-b882-11e8-a6d9-e546fe2bba5f?_g=(refreshInterval:(pause:!f,value:900000),time:(from:'2019-03-15T07:23:58.721Z',mode:absolute,to:'2019-03-18T10:43:28.880Z'))&_a=(description:'Analyze%20mock%20eCommerce%20orders%20and%20revenue',filters:!(('$state':(store:appState),meta:(alias:!n,controlledBy:'1536977437774',disabled:!f,index:ff959d40-b880-11e8-a6d9-e546fe2bba5f,key:manufacturer.keyword,negate:!f,params:!(Angeldale,'Champion%20Arts'),type:phrases,value:'Angeldale,%20Champion%20Arts'),query:(bool:(minimum_should_match:1,should:!((match_phrase:(manufacturer.keyword:Angeldale)),(match_phrase:(manufacturer.keyword:'Champion%20Arts')))))),('$state':(store:appState),meta:(alias:!n,disabled:!f,index:ff959d40-b880-11e8-a6d9-e546fe2bba5f,key:customer_gender,negate:!f,params:(query:MALE,type:phrase),type:phrase,value:MALE),query:(match:(customer_gender:(query:MALE,type:phrase)))),('$state':(store:appState),meta:(alias:!n,disabled:!f,index:ff959d40-b880-11e8-a6d9-e546fe2bba5f,key:geoip.country_iso_code,negate:!f,params:(query:FR,type:phrase),type:phrase,value:FR),query:(match:(geoip.country_iso_code:(query:FR,type:phrase))))),fullScreenMode:!f,options:(darkTheme:!f,hidePanelTitles:!f,useMargins:!t),panels:!((embeddableConfig:(vis:(colors:('Men!'s%20Accessories':%2382B5D8,'Men!'s%20Clothing':%23F9BA8F,'Men!'s%20Shoes':%23F29191,'Women!'s%20Accessories':%23F4D598,'Women!'s%20Clothing':%2370DBED,'Women!'s%20Shoes':%23B7DBAB))),gridData:(h:10,i:'1',w:36,x:12,y:18),id:'37cc8650-b882-11e8-a6d9-e546fe2bba5f',panelIndex:'1',type:visualization,version:'7.0.0-alpha1'),(embeddableConfig:(vis:(colors:(FEMALE:%236ED0E0,MALE:%23447EBC),legendOpen:!f)),gridData:(h:11,i:'2',w:12,x:12,y:7),id:ed8436b0-b88b-11e8-a6d9-e546fe2bba5f,panelIndex:'2',type:visualization,version:'7.0.0-alpha1'),(embeddableConfig:(),gridData:(h:7,i:'3',w:18,x:0,y:0),id:'09ffee60-b88c-11e8-a6d9-e546fe2bba5f',panelIndex:'3',type:visualization,version:'7.0.0-alpha1'),(embeddableConfig:(),gridData:(h:7,i:'4',w:30,x:18,y:0),id:'1c389590-b88d-11e8-a6d9-e546fe2bba5f',panelIndex:'4',type:visualization,version:'7.0.0-alpha1'),(embeddableConfig:(),gridData:(h:11,i:'5',w:48,x:0,y:28),id:'45e07720-b890-11e8-a6d9-e546fe2bba5f',panelIndex:'5',type:visualization,version:'7.0.0-alpha1'),(embeddableConfig:(),gridData:(h:10,i:'6',w:12,x:0,y:18),id:'10f1a240-b891-11e8-a6d9-e546fe2bba5f',panelIndex:'6',type:visualization,version:'7.0.0-alpha1'),(embeddableConfig:(),gridData:(h:11,i:'7',w:12,x:0,y:7),id:b80e6540-b891-11e8-a6d9-e546fe2bba5f,panelIndex:'7',type:visualization,version:'7.0.0-alpha1'),(embeddableConfig:(vis:(colors:('0%20-%2050':%23E24D42,'50%20-%2075':%23EAB839,'75%20-%20100':%237EB26D),defaultColors:('0%20-%2050':'rgb(165,0,38)','50%20-%2075':'rgb(255,255,190)','75%20-%20100':'rgb(0,104,55)'),legendOpen:!f)),gridData:(h:11,i:'8',w:12,x:24,y:7),id:'4b3ec120-b892-11e8-a6d9-e546fe2bba5f',panelIndex:'8',type:visualization,version:'7.0.0-alpha1'),(embeddableConfig:(vis:(colors:('0%20-%202':%23E24D42,'2%20-%203':%23F2C96D,'3%20-%204':%239AC48A),defaultColors:('0%20-%202':'rgb(165,0,38)','2%20-%203':'rgb(255,255,190)','3%20-%204':'rgb(0,104,55)'),legendOpen:!f)),gridData:(h:11,i:'9',w:12,x:36,y:7),id:'9ca7aa90-b892-11e8-a6d9-e546fe2bba5f',panelIndex:'9',type:visualization,version:'7.0.0-alpha1'),(embeddableConfig:(),gridData:(h:18,i:'10',w:48,x:0,y:54),id:'3ba638e0-b894-11e8-a6d9-e546fe2bba5f',panelIndex:'10',type:search,version:'7.0.0-alpha1'),(embeddableConfig:(mapCenter:!(44.29024884874176,0.2977304999999975),mapZoom:2),gridData:(h:15,i:'11',w:24,x:0,y:39),id:'9c6f83f0-bb4d-11e8-9c84-77068524bcab',panelIndex:'11',type:visualization,version:'7.0.0-alpha1'),(embeddableConfig:(),gridData:(h:15,i:'12',w:24,x:24,y:39),id:b72dd430-bb4d-11e8-9c84-77068524bcab,panelIndex:'12',type:visualization,version:'7.0.0-alpha1')),query:(language:lucene,query:''),timeRestore:!t,title:'%5BeCommerce%5D%20Revenue%20Dashboard',viewMode:view)", "stuff");
JsonConvert.DeserializeObject(result);
}
public void CanParseComplexObject9()
{
var result = new KibanaParser().ConvertUrlToElasticsearchQueryString("http://*****:*****@example.com'),type:phrase),query:(match:(email:(query:'*****@*****.**',type:phrase))))),index:aec561e0-1511-11ea-a5d4-651ed6b2498e,interval:auto,query:(language:kuery,query:''),sort:!(!(createdUtc,desc)))", "stuff");
JsonConvert.DeserializeObject(result);
}
public void CanParseComplexObject7()
{
var result = new KibanaParser().ConvertUrlToElasticsearchQueryString("http://localhost:5601/app/kibana#/discover?_g=(refreshInterval:(pause:!t,value:0),time:(from:now-15y,mode:relative,to:now))&_a=(columns:!(_source),filters:!(('$state':(store:appState),meta:(alias:!n,disabled:!f,index:'14746b80-3f48-11e9-8d2e-3f08e16da335',key:country,negate:!f,params:(query:DK,type:phrase),type:phrase,value:DK),query:(match:(country:(query:DK,type:phrase)))),('$state':(store:appState),meta:(alias:!n,disabled:!f,index:'14746b80-3f48-11e9-8d2e-3f08e16da335',key:zipCode,negate:!t,params:!('8000','8000%20','8600','8600%20','3650','3650%20','8530','8530%20'),type:phrases,value:'8000,%208000%20,%208600,%208600%20,%203650,%203650%20,%208530,%208530%20'),query:(bool:(minimum_should_match:1,should:!((match_phrase:(zipCode:'8000')),(match_phrase:(zipCode:'8000%20')),(match_phrase:(zipCode:'8600')),(match_phrase:(zipCode:'8600%20')),(match_phrase:(zipCode:'3650')),(match_phrase:(zipCode:'3650%20')),(match_phrase:(zipCode:'8530')),(match_phrase:(zipCode:'8530%20')))))),('$state':(store:appState),meta:(alias:!n,disabled:!f,index:'14746b80-3f48-11e9-8d2e-3f08e16da335',key:lastSessionUtc,negate:!f,params:(gte:'2019-01-01',lt:'2019-04-10'),type:range,value:'January%201st%202019,%2000:00:00.000%20to%20April%2010th%202019,%2000:00:00.000'),range:(lastSessionUtc:(gte:'2019-01-01',lt:'2019-04-10')))),index:'14746b80-3f48-11e9-8d2e-3f08e16da335',interval:auto,query:(language:lucene,query:''),sort:!(createdUtc,desc))", "stuff");
JsonConvert.DeserializeObject(result);
}
public void CanParseComplexObject5()
{
var result = new KibanaParser().ConvertUrlToElasticsearchQueryString("http://localhost:5601/app/kibana#/dashboard/722b74f0-b882-11e8-a6d9-e546fe2bba5f?_a=(defaultColors:('0%20-%2050':'rgb(165,0,38)'))", "stuff");
JsonConvert.DeserializeObject(result);
}
public void CanParseComplexObject4()
{
var result = new KibanaParser().ConvertUrlToElasticsearchQueryString("https://example.com/s/example/app/kibana#/dashboard/c4bfe170-3f4a-11e9-8d2e-3f08e16da335?_g=(refreshInterval:(pause:!t,value:0),time:(from:now-15y,mode:relative,to:now))&_a=(description:'',filters:!(('$state':(store:appState),meta:(alias:!n,controlledBy:'1551791836779',disabled:!f,index:'14746b80-3f48-11e9-8d2e-3f08e16da335',key:foo,negate:!f,params:!('2.11','2.12'),type:phrases,value:'2.11,%202.12'),query:(bool:(minimum_should_match:1,should:!((match_phrase:(foo:'2.11')),(match_phrase:(foo:'2.12')))))),('$state':(store:appState),meta:(alias:!n,disabled:!f,index:'14746b80-3f48-11e9-8d2e-3f08e16da335',key:zipCode,negate:!f,params:(query:'2800',type:phrase),type:phrase,value:'2800'),query:(match:(zipCode:(query:'2800',type:phrase)))),('$state':(store:appState),geo_bounding_box:(ignore_unmapped:!t,location:(bottom_right:(lat:55.038942152086975,lon:13.447265625000002),top_left:(lat:56.27834077728165,lon:10.667724609375002))),meta:(alias:!n,disabled:!f,index:'14746b80-3f48-11e9-8d2e-3f08e16da335',key:location,negate:!f,params:(bottom_right:(lat:55.038942152086975,lon:13.447265625000002),top_left:(lat:56.27834077728165,lon:10.667724609375002)),type:geo_bounding_box,value:'%7B%0A%20%20%22lat%22:%2056.27834077728165,%0A%20%20%22lon%22:%2010.667724609375002%0A%7D%20to%20%7B%0A%20%20%22lat%22:%2055.038942152086975,%0A%20%20%22lon%22:%2013.447265625000002%0A%7D')),('$state':(store:appState),meta:(alias:!n,controlledBy:'1551792106984',disabled:!f,index:'14746b80-3f48-11e9-8d2e-3f08e16da335',key:favoriteItemsCount,negate:!f,params:(gte:1204,lte:3611),type:range,value:'1,204%20to%203,611'),range:(favoriteItemsCount:(gte:1204,lte:3611))),('$state':(store:appState),meta:(alias:!n,controlledBy:'1551964815147',disabled:!f,index:'14746b80-3f48-11e9-8d2e-3f08e16da335',key:contactPhoneNumber,negate:!f,params:!('00000000','12345678'),type:phrases,value:'00000000,%2012345678'),query:(bool:(minimum_should_match:1,should:!((match_phrase:(contactPhoneNumber:'00000000')),(match_phrase:(contactPhoneNumber:'12345678'))))))),fullScreenMode:!f,options:(darkTheme:!f,hidePanelTitles:!f,useMargins:!t),panels:!((embeddableConfig:(mapCenter:!(55.96765007530668,10.1129150390625),mapZoom:7),gridData:(h:21,i:'1',w:40,x:0,y:0),id:'0fa4d020-3f4a-11e9-8d2e-3f08e16da335',panelIndex:'1',type:visualization,version:'6.6.1'),(embeddableConfig:(),gridData:(h:15,i:'2',w:19,x:21,y:21),id:'8745c590-3f49-11e9-8d2e-3f08e16da335',panelIndex:'2',type:visualization,version:'6.6.1'),(embeddableConfig:(),gridData:(h:9,i:'3',w:9,x:21,y:36),id:'6d19ca40-3f49-11e9-8d2e-3f08e16da335',panelIndex:'3',type:visualization,version:'6.6.1'),(embeddableConfig:(),gridData:(h:21,i:'4',w:40,x:0,y:45),id:'28311aa0-3f49-11e9-8d2e-3f08e16da335',panelIndex:'4',type:visualization,version:'6.6.1'),(embeddableConfig:(),gridData:(h:24,i:'5',w:21,x:0,y:21),id:eac48160-3f49-11e9-8d2e-3f08e16da335,panelIndex:'5',type:visualization,version:'6.6.1'),(embeddableConfig:(),gridData:(h:9,i:'6',w:10,x:30,y:36),id:'811a01b0-4703-11e9-8d2e-3f08e16da335',panelIndex:'6',type:visualization,version:'6.6.1')),query:(language:kuery,query:''),timeRestore:!t,title:Users,viewMode:view)", "stuff");
JsonConvert.DeserializeObject(result);
}
