public async Task FilterOrder()
{
var q = Arango.Query <Project>("test")
.Where(x => (x.Name == "Project A" || x.Name == "Project B") && x.Budget <= 0);
Assert.Equal("FOR `x` IN `Project` FILTER ( ( ( `x`.`Name` == @P1 ) OR ( `x`.`Name` == @P2 ) ) AND ( `x`.`Budget` <= @P3 ) ) RETURN `x`", q.ToAql().aql.Trim());
}
public async Task SingleOrDefault()
{
var p = await Arango.Query <Project>("test")
.SingleOrDefaultAsync(x => x.Name == "Project A");
Assert.Equal("Project A", p.Name);
}
public async Task SingleException()
{
await Assert.ThrowsAsync <InvalidOperationException>(async() =>
{
await Arango.Query <Project>("test")
.SingleAsync(x => x.Name == "Nope");
});
}
public async Task MultiFilter()
{
var q = Arango.Query <Project>("test")
.Where(x => x.Name == "Project A")
.OrderBy(x => x.Name)
.Where(x => x.Name == "Project B")
.OrderByDescending(x => x.Name)
.Skip(0).Take(1);
Assert.Equal("FOR `x` IN `Project` FILTER ( `x`.`Name` == @P1 ) SORT `x`.`Name` ASC FILTER ( `x`.`Name` == @P2 ) SORT `x`.`Name` DESC LIMIT @P3 , @P4 RETURN `x`", q.ToAql().aql.Trim());
}
public async Task Let()
{
var q =
from p in Arango.Query <Project>("test")
let clients = (from c in Arango.Query <Client>() select c.Key)
select new { p.Name, Clients = Aql.As <string[]>(clients) };
_output.WriteLine(q.ToAql().aql);
_output.WriteLine("");
_output.WriteLine(JsonConvert.SerializeObject(await q.ToListAsync(), Formatting.Indented));
}
public async Task Ternary()
{
var q = Arango.Query <Project>("test")
.Select(x => new
{
x.Key,
Name = x.Name == "Test" ? "-" : x.Name
});
_output.WriteLine(q.ToAql().aql);
_output.WriteLine("");
//_output.WriteLine(JsonConvert.SerializeObject(await q.ToListAsync(), Formatting.Indented));
}
public async Task MathAbs()
{
var q = Arango.Query <Project>("test")
.Select(x => new
{
x.Key,
Budget = Math.Abs(x.Budget)
});
_output.WriteLine(q.ToAql().aql);
_output.WriteLine("");
//_output.WriteLine(JsonConvert.SerializeObject(await q.ToListAsync(), Formatting.Indented));
}
public async Task GroupBy()
{
var q = Arango.Query <Project>("test")
.GroupBy(y => y.ParentKey)
.Select(x => new
{
Parent = x.Key,
Max = x.Max(y => y.Budget)
});
_output.WriteLine(q.ToAql().aql);
_output.WriteLine("");
//_output.WriteLine(JsonConvert.SerializeObject(await q.ToListAsync(), Formatting.Indented));
}
public async Task Update()
{
var q = Arango.Query <Project>("test")
.Where(x => x.Name == "Project A")
.Update(x => new
{
x.Key,
Name = Aql.Concat(x.Name, "2")
}, x => x.Key);
_output.WriteLine(q.ToAql().aql);
_output.WriteLine("");
_output.WriteLine(JsonConvert.SerializeObject(await q.ToListAsync(), Formatting.Indented));
}
public async Task SelectDocument()
{
var q = Arango.Query <Project>("test")
.Where(x => x.Name == "Project A")
.Select(x => new
{
x.Key,
x.Name,
ClientName = Aql.Document <Client>("Client", x.ClientKey).Name
});
_output.WriteLine(q.ToAql().aql);
_output.WriteLine("");
_output.WriteLine(JsonConvert.SerializeObject(await q.ToListAsync(), Formatting.Indented));
}
public async Task ListContains()
{
var list = new List <string> {
"CA", "CB"
}.ToArray();
//var q = Arango.Query<Project>("test")
// .Where(x => list.Contains(x.ClientKey));
var q = Arango.Query <Project>("test")
.Where(x => Aql.Position(list, x.ClientKey));
_output.WriteLine(q.ToAql().aql);
_output.WriteLine("");
_output.WriteLine(JsonConvert.SerializeObject(await q.ToListAsync(), Formatting.Indented));
}