public void Query()
{
var loadOptions = DxLoad(key =>
{
var r = key switch
{
"take" => "100",
"requireTotalCount" => "true",
"sort" => "%5B%7B%22selector%22:%22start%22,%22desc%22:true%7D%5D",
"filter" => "%5B%5B%5D,%22and%22,%5B%22!%22,%5B%5B%22userKey%22,%22=%22,%2255770a6d-4dd7-42cf-9db5-aaff00d106d7%22%5D,%22or%22,%5B%22userKey%22,%22=%22,%2240ecb6b1-26cd-44e0-88df-a9457f4ade9c%22%5D%5D%5D%5D",
"totalSummary" => "%5B%7B%22selector%22:%22duration%22,%22summaryType%22:%22sum%22%7D,%7B%22selector%22:%22revenue%22,%22summaryType%22:%22sum%22%7D%5D",
_ => null
};
return(key != null ? WebUtility.UrlDecode(r) : null);
});
var at = new ArangoTransform(loadOptions, new ArangoTransformSettings
{
ExtractFilters = new Dictionary <string, ArangoFilterTransform>
{
["UserKey"] = new ArangoFilterTransform
{
IteratorVar = "z",
Collection = "AUser",
Property = "_key"
}
}
});
Assert.True(at.Transform(out _));
Assert.Equal("(true && !((false || false)))", at.FilterExpression);
}
public void LookupTest()
{
var at = new ArangoTransform(new DataSourceLoadOptionsBase
{
Take = 20,
Filter = JArray.Parse(@"[[""name"",""contains"",""STP""],[""name"",""contains"",""mittelwort""],[""name"",""contains"",""letzteswort""]]")
}, new ArangoTransformSettings());
Assert.True(at.Transform(out _));
Assert.Equal("(LOWER(x.Name) LIKE @P1 && LOWER(x.Name) LIKE @P2 && LOWER(x.Name) LIKE @P3)", at.FilterExpression);
}
public void ContainsArrayTest()
{
var at = new ArangoTransform(new DataSourceLoadOptionsBase
{
Take = 20,
RequireTotalCount = false,
Filter = JArray.Parse(
@"[""categoryKeys"",""acontains"",""d9d48fe3-03dc-e611-80dd-0050568a3ed2""]")
}, new ArangoTransformSettings());
Assert.True(at.Transform(out _));
Assert.Equal("CONTAINS(LOWER(x.CategoryKeys), @P1)", at.FilterExpression);
}
public void InArrayTest()
{
var at = new ArangoTransform(new DataSourceLoadOptionsBase
{
Take = 20,
RequireTotalCount = false,
Filter = JArray.Parse(
@"[[""categoryKeys"",""in"",""d9d48fe3-03dc-e611-80dd-0050568a3ed2""],""or"",[""categoryKeys"",""in"",""ad22d4ec-03dc-e611-80dd-0050568a3ed2""]]")
}, new ArangoTransformSettings());
Assert.True(at.Transform(out _));
Assert.Equal("(@P1 IN x.CategoryKeys || @P2 IN x.CategoryKeys)", at.FilterExpression);
}
public void StringTypeTest()
{
var at = new ArangoTransform(new DataSourceLoadOptionsBase
{
Take = 20,
Filter = JArray.Parse(@"[[""name"",""contains"",""bad""],[""name"",""contains"",""""]]")
}, new ArangoTransformSettings());
Assert.True(at.Transform(out _));
var parameter = at.Parameter
.Select(x => $"{x.Key}: {x.Value} [{x.Value?.GetType()}]")
.ToList();
Assert.Equal("(LOWER(x.Name) LIKE @P1 && LOWER(x.Name) LIKE @P2)", at.FilterExpression);
_output.WriteLine(JsonConvert.SerializeObject(parameter, Formatting.Indented));
}
public void BoolTypeTest()
{
var at = new ArangoTransform(new DataSourceLoadOptionsBase
{
Take = 20,
Filter = JArray.Parse(@"[[""name"",""=="",true],[""name"",""<>"", false]]")
}, new ArangoTransformSettings());
Assert.True(at.Transform(out _));
var parameter = at.Parameter
.Select(x => $"{x.Key}: {x.Value} [{x.Value?.GetType()}]")
.ToList();
Assert.Equal("(x.Name == @P1 && x.Name != @P2)", at.FilterExpression);
_output.WriteLine(JsonConvert.SerializeObject(parameter, Formatting.Indented));
}
public void NumberTypeTest()
{
var at = new ArangoTransform(new DataSourceLoadOptionsBase
{
Take = 20,
Filter = JArray.Parse(@"[[""duration"","">"",8],""and"",[""duration"","">"",8.5]]")
}, new ArangoTransformSettings());
Assert.True(at.Transform(out _));
var parameter = at.Parameter
.Select(x => $"{x.Key}: {x.Value} [{x.Value?.GetType()}]")
.ToList();
Assert.Equal("(x.Duration > @P1 && x.Duration > @P2)", at.FilterExpression);
_output.WriteLine(JsonConvert.SerializeObject(parameter, Formatting.Indented));
}
public void DateTimeTest()
{
var at = new ArangoTransform(new DataSourceLoadOptionsBase
{
Take = 20,
Filter = JArray.Parse(
@"[[],""and"",[[""start"","">="",""2020-03-10T23:00:00.000Z""],""and"",[""start"",""<"",""2020-03-11T23:00:00.000Z""]]]")
}, new ArangoTransformSettings());
Assert.True(at.Transform(out _));
var parameter = at.Parameter
.Select(x => $"{x.Key}: {x.Value} [{x.Value?.GetType()}]")
.ToList();
Assert.Equal("(true && (x.Start >= @P1 && x.Start < @P2))", at.FilterExpression);
_output.WriteLine(JsonConvert.SerializeObject(parameter, Formatting.Indented));
}
public void NullTypeTest()
{
var at = new ArangoTransform(new DataSourceLoadOptionsBase
{
Take = 20,
Filter = JArray.Parse(@"[""parentKey"",""="",null]")
}, new ArangoTransformSettings());
Assert.True(at.Transform(out _));
var parameter = at.Parameter
.Select(x => $"{x.Key}: {x.Value} [{x.Value?.GetType()}]")
.ToList();
Assert.Equal("x.ParentKey == @P1", at.FilterExpression);
_output.WriteLine(JsonConvert.SerializeObject(parameter, Formatting.Indented));
}
public void NegateExpression2()
{
var loadOptions = DxLoad(key =>
{
if (key == "filter")
{
return(WebUtility.UrlDecode(
@"%5B%22!%22,%5B%5B%22type%22,%22=%22,null%5D,%22or%22,%5B%22type%22,%22=%22,1%5D%5D%5D"));
}
return(null);
});
var at = new ArangoTransform(loadOptions, new ArangoTransformSettings());
Assert.True(at.Transform(out _));
Assert.Equal("!((x.Type == @P1 || x.Type == @P2))", at.FilterExpression);
}
public void StringNumberTypeTest()
{
var at = new ArangoTransform(new DataSourceLoadOptionsBase
{
Take = 20,
Filter = new List <string>
{
"data.invoiceNumber", "startswith", "1234"
}
}, new ArangoTransformSettings());
Assert.True(at.Transform(out _));
var parameter = at.Parameter
.Select(x => $"{x.Key}: {x.Value} [{x.Value?.GetType()}]")
.ToList();
Assert.Equal("LOWER(x.Data.InvoiceNumber) LIKE @P1", at.FilterExpression);
_output.WriteLine(JsonConvert.SerializeObject(parameter, Formatting.Indented));
}
public void NegateExpression()
{
var at = new ArangoTransform(new DataSourceLoadOptionsBase
{
Take = 20,
RequireTotalCount = true,
Sort = new[]
{
new SortingInfo
{
Selector = "start",
Desc = true
}
},
Filter = JArray.Parse(@"[[], ""and"", [""!"", [""scope"", ""=="", ""plan""]]]")
}, new ArangoTransformSettings());
Assert.True(at.Transform(out _));
Assert.Equal("(true && !(x.Scope == @P1))", at.FilterExpression);
}
public void ExtractFilters()
{
var at = new ArangoTransform(new DataSourceLoadOptionsBase
{
Take = 20,
RequireTotalCount = false,
Filter = JArray.Parse(
@"[[""categoryKeys"",""in"",""d9d48fe3-03dc-e611-80dd-0050568a3ed2""],""or"",[""categoryKeys"",""in"",""ad22d4ec-03dc-e611-80dd-0050568a3ed2""]]")
}, new ArangoTransformSettings
{
ExtractFilters = new Dictionary <string, ArangoFilterTransform>
{
["CategoryKeys"] = new ArangoFilterTransform
{
IteratorVar = "z",
Collection = "Project",
Property = "CategoryKeys"
}
}
});
Assert.True(at.Transform(out _));
Assert.Equal("(true || true)", at.FilterExpression);
}
public void GroupLookups()
{
var at = new ArangoTransform(new DataSourceLoadOptionsBase
{
Sort = new[]
{
new SortingInfo
{
Selector = "start",
Desc = true
}
},
Group = new[]
{
new GroupingInfo
{
Selector = "projectKey",
Desc = false,
IsExpanded = false
}
},
TotalSummary = new[]
{
new SummaryInfo
{
Selector = "duration",
SummaryType = "sum"
},
new SummaryInfo
{
Selector = "revenue",
SummaryType = "sum"
}
},
GroupSummary = new[]
{
new SummaryInfo
{
Selector = "duration",
SummaryType = "sum"
},
new SummaryInfo
{
Selector = "duration",
SummaryType = "sum"
},
new SummaryInfo
{
Selector = "revenue",
SummaryType = "sum"
}
}
}, new ArangoTransformSettings
{
GroupLookups = new Dictionary <string, string>
{
["ProjectKey"] = "DOCUMENT(AProject, ProjectKey).Name",
["UserKey"] = "DOCUMENT(AUser, UserKey).Name"
}
});
Assert.True(at.Transform(out _));
Assert.Equal(@"COLLECT
ProjectKey = x.ProjectKey
AGGREGATE
TotalCount = LENGTH(1), SUMDuration = SUM(x.Duration), SUMRevenue = SUM(x.Revenue)
SORT ProjectKey ASC
RETURN {
TotalCount, ProjectKey, ProjectKey_DV: DOCUMENT(AProject, ProjectKey).Name, SUMDuration, SUMRevenue
}
", at.AggregateExpression);
}