public async Task <IHttpActionResult> GetAreaInfo(string id)
{
var g = new GremlinHelper();
string name;
var q = $"g.V().has('area', 'id', '{id}')";
var info = await g.getResultAsync(q);
var n = info["properties"].Where(x => x.Path == "properties.name").FirstOrDefault();
if (n != null)
{
name = n.Values()["value"].First().ToString();
}
q = $"g.V().has('area', 'id', '{id}').inE().outV()";
var infoes = await g.getResultsAsync(q);
foreach (var i in info)
{
}
return(Ok());
}
public async Task <IHttpActionResult> PostNewProperty(string id, keyValue info)
{
var g = new GremlinHelper();
string qry = $"g.V('{id}').property('{info.key.Replace("'", "''")}','{info.value.Replace("'", "''")}')";
await g.getResultAsync(qry);
return(Ok());
}
public async Task <IHttpActionResult> GetDBStats()
{
var grem = new GremlinHelper();
var vert = (await grem.getPassthroughResult("g.V().count()")).First();
var vertTypes = (await grem.getPassthroughResult("g.V().groupCount().by('label')")).First().ToString();
var edge = (await grem.getPassthroughResult("g.E().count()")).First();
var edgeTypes = (await grem.getPassthroughResult("g.E().groupCount().by('label')")).First().ToString();
return(Ok(new { edge, edgeTypes = processList(edgeTypes), vert, vertTypes = processList(vertTypes) }));
}
public async Task <IHttpActionResult> GetIDByNameAndParent(string name, string parent)
{
var grem = new GremlinHelper();
var persons = await grem.getIdByNameAndParentAsync(name, parent);
var result = new List <person>();
foreach (var p in persons)
{
result.Add(await getById(p));
}
return(Ok(new { results = result }));
}
public async Task <IHttpActionResult> GetIdByName(string name)
{
var grem = new GremlinHelper();
var persons = await grem.getIdsByNameAsync(name);
var results = new List <person>();
foreach (var p in persons)
{
results.Add(await getById(p));
}
return(Ok(new { results = results }));
}
public async Task <IHttpActionResult> PostAssignChild(string id, newChildInfo info)
{
var g = new GremlinHelper();
if (info == null || string.IsNullOrWhiteSpace(info.id) || (string.IsNullOrWhiteSpace(info.motherId) && string.IsNullOrWhiteSpace(info.fatherId)))
{
return(BadRequest());
}
var ncID = info.id;
// relate to parent
await g.getResultAsync($"g.V('{id}').addE('parent').to(g.V('{ncID}'))");
// now other parent
if (!string.IsNullOrWhiteSpace(info.motherId) && info.motherId != id)
{
await g.getResultAsync($"g.V('{info.motherId}').addE('parent').to(g.V('{ncID}'))");
}
else if (!string.IsNullOrWhiteSpace(info.fatherId) && info.fatherId != id)
{
await g.getResultAsync($"g.V('{info.fatherId}').addE('parent').to(g.V('{ncID}'))");
}
// add parent Edge type properties
if (!string.IsNullOrWhiteSpace(info.fatherId))
{
await g.getResultAsync($"g.V('{info.fatherId}').outE('parent').property('type', 'Father')");
}
if (!string.IsNullOrWhiteSpace(info.motherId))
{
await g.getResultAsync($"g.V('{info.motherId}').outE('parent').property('type', 'Mother')");
}
// save age on Edge
if (!string.IsNullOrWhiteSpace(info.fatherAge))
{
await g.getResultAsync($"g.V('{info.fatherId}').outE('parent').inV('{ncID}').property('age', '{info.fatherAge}')");
}
if (!string.IsNullOrWhiteSpace(info.motherAge))
{
await g.getResultAsync($"g.V('{info.motherId}').outE('parent').inV('{ncID}').property('age', '{info.motherAge}')");
}
return(Ok());
}
public async Task <IHttpActionResult> PostNewSpouse(string id, newSpouseInfo info)
{
var g = new GremlinHelper();
if (info == null || (string.IsNullOrWhiteSpace(info.name) && string.IsNullOrWhiteSpace(info.id)))
{
return(BadRequest());
}
var spID = "";
if (string.IsNullOrWhiteSpace(info.id))
{
// do the insert
var qry = $"g.addV('person').property('name', '{info.name.Replace("'","''")}')";
if (!string.IsNullOrWhiteSpace(info.gender))
{
qry += $".property('gender', '{info.gender}')";
}
var nc = await g.getResultAsync(qry);
// get iD from result
spID = (nc as JObject)["id"].ToString();
}
else
{
spID = info.id;
}
// relate to parent
await g.getResultAsync($"g.V('{id}').addE('married').to(g.V('{spID}'))");
if (info.children)
{
}
return(Ok());
}
public async Task <IHttpActionResult> PostNewArea(string id, newAreaInfo info)
{
var g = new GremlinHelper();
string areaId, q;
if (string.IsNullOrWhiteSpace(info.country))
{
q = $"g.V().has('area', 'name', '{info.area}')";
var area = await g.getResultAsync(q);
if (area == null)
{
q = $"g.addV('area').property('name', '{info.area}')";
areaId = (await g.getResultAsync(q))["id"].ToString();
}
else
{
areaId = area["id"].ToString();
}
}
else
{
var res = await g.createVertexEdgeVertextByName("area", info.area, "isIn", "country", info.country);
areaId = res.outId;
}
q = $"g.V'{id}').outE('lived').inV().has('area', 'id' '{areaId}')";
var isAlready = await g.getResultAsync(q);
if (isAlready == null)
{
q = $"g.V('{id}').addE('lived').to(g.V('{areaId}'))";
await g.getResultAsync(q);
}
return(Ok());
}
public async Task <IHttpActionResult> PostNewChild(string id, newChildInfo info)
{
var g = new GremlinHelper();
if (info == null)
{
return(BadRequest());
}
string ncID;
if (!string.IsNullOrWhiteSpace(info.name) && info.id == null)
{
// do the insert
var qry = $"g.addV('person').property('name', '{info.name}')";
if (!string.IsNullOrWhiteSpace(info.gender))
{
qry += $".property('gender', '{info.gender}')";
}
var nc = await g.getResultAsync(qry);
// get iD frmo result
ncID = (nc as JObject)["id"].ToString();
}
else
{
ncID = info.id;
}
// relate to parent
await g.getResultAsync($"g.V('{id}').addE('parent').to(g.V('{ncID}'))");
// now other parent
if (!string.IsNullOrWhiteSpace(info.motherId) && info.motherId != id)
{
await g.getResultAsync($"g.V('{info.motherId}').addE('parent').to(g.V('{ncID}'))");
}
else if (!string.IsNullOrWhiteSpace(info.fatherId) && info.fatherId != id)
{
await g.getResultAsync($"g.V('{info.fatherId}').addE('parent').to(g.V('{ncID}'))");
}
// add parent Edge type properties
if (!string.IsNullOrWhiteSpace(info.fatherId))
{
await g.getResultAsync($"g.V('{info.fatherId}').outE('parent').property('type', 'Father')");
}
if (!string.IsNullOrWhiteSpace(info.motherId))
{
await g.getResultAsync($"g.V('{info.motherId}').outE('parent').property('type', 'Mother')");
}
// save age on Edge
if (!string.IsNullOrWhiteSpace(info.fatherAge))
{
await g.getResultAsync($"g.V('{ncID}').inE('parent').has('type', 'Father').property('age', '{info.fatherAge}')");
}
if (!string.IsNullOrWhiteSpace(info.motherAge))
{
await g.getResultAsync($"g.V('{ncID}').inE('parent').has('type', 'Mother').property('age', '{info.motherAge}')");
}
return(Ok());
}
public async Task <IHttpActionResult> GetNameCheck(string name)
{
var g = new GremlinHelper();
string getEntries = $"g.V().has('person', 'name', '{name.Replace("'", "''")}')";
var entries = await g.getResultsAsync(getEntries);
if (!entries.Any())
{
return(Ok(new List <string>()));
}
var ret = new List <object>();
foreach (var entry in entries)
{
string id = (entry as JObject)["id"].ToString();
string upDown = $"g.V('{id}').as('o').bothE('parent').bothV().path().unfold().where(neq('o')).dedup()";
var results = await g.getResultsAsync(upDown);
string parents = "";
string children = "";
var v = new List <JObject>();
var e = new List <JObject>();
foreach (var r in results)
{
if ((r as JObject)["label"].ToString() == "person")
{
v.Add(r);
}
else
{
e.Add(r);
}
}
var vIn = e.Select(x => x["inV"].ToString()).ToList();
vIn.AddRange(e.Select(x => x["outV"].ToString()).ToList());
var rr = vIn.GroupBy(z => z.ToString()).Select(z => z.ToList()).OrderByDescending(z => z.Count()).FirstOrDefault();
var me = id;
foreach (var r in e.Where(z => z["outV"].ToString() == me))
{
var childId = r["inV"].ToString();
var child = v.Where(z => z["id"].ToString() == childId).First();
var childName = ((child as JObject)["properties"].Where(z => z.Path == "properties.name").First() as JToken).Values().First()["value"].ToString();
children += childName + ", ";
}
if (!string.IsNullOrWhiteSpace(children))
{
children = children.Substring(0, children.Length - 2);
}
foreach (var r in e.Where(z => z["inV"].ToString() == me))
{
var parentId = r["outV"].ToString();
var parent = v.Where(z => z["id"].ToString() == parentId).First();
var parentName = ((parent as JObject)["properties"].Where(z => z.Path == "properties.name").First() as JToken).Values().First()["value"].ToString();
parents += parentName + ", ";
}
if (!string.IsNullOrWhiteSpace(parents))
{
parents = parents.Substring(0, parents.Length - 2);
}
ret.Add(new { me, parents, children });
}
return(Ok(ret));
}
public async Task <person> getById(string id)
{
var grem = new GremlinHelper();
var qry = $"g.V('{id}')";
var info = await grem.getResultAsync(qry);
var person = new person()
{
id = id,
};
var n = info["properties"].Where(x => x.Path == "properties.name").FirstOrDefault();
if (n != null)
{
person.name = n.Values()["value"].First().ToString();
}
n = info["properties"].Where(x => x.Path == "properties.gender").FirstOrDefault();
if (n != null)
{
person.gender = n.Values()["value"].First().ToString();
}
person.properties = getProperties(info);
List <Task> tasks = new List <Task>();
tasks.Add(Task.Run(async() =>
{
// my spouse
qry = $"g.V('{id}').as('o').bothE('married').bothV().where(neq('o'))";
var infoes = await grem.getResultsAsync(qry);
foreach (var i in infoes)
{
var p = new person()
{
name = (i as JToken)["properties"].Where(x => x.Path == "properties.name").First().Values().First()["value"].ToString(),
id = (i as JObject)["id"].ToString()
};
n = (i as JToken)["properties"].Where(x => x.Path == "properties.gender").FirstOrDefault();
if (n != null)
{
p.gender = n.Values()["value"].First().ToString();
p.type = person.gender == "F" ? "Husband" : "Wife";
}
person.spouse.Add(p);
}
}));
tasks.Add(Task.Run(async() =>
{
// where I lived
qry = $"g.V('{id}').outE('lived').inV()";
var infoes = await grem.getResultsAsync(qry);
foreach (var i in infoes)
{
var vId = (i as JObject)["id"].ToString();
var name = (i as JToken)["properties"].Where(x => x.Path == "properties.name").First().Values().First()["value"].ToString();
person.livedIn.Add(new keyValue(vId, name));
}
}));
tasks.Add(Task.Run(async() =>
{
// my children
qry = $"g.V('{id}').outE('parent').inV()";
var infoes = await grem.getResultsAsync(qry);
var edges = await grem.getResultsAsync($"g.V('{id}').outE('parent')");
foreach (var i in infoes)
{
var c = new person()
{
name = (i as JToken)["properties"].Where(x => x.Path == "properties.name").First().Values().First()["value"].ToString(),
id = (i as JObject)["id"].ToString()
};
var g = (i as JToken)["properties"].Where(x => x.Path == "properties.gender").FirstOrDefault();
if (g != null)
{
c.gender = g.Values()["value"].First().ToString();
c.type = c.gender == "F" ? "Daughter" : "Son";
}
var child = edges.Where(x => (x as JObject)["inV"].ToString() == c.id).FirstOrDefault();
if (child != null)
{
var prop = (child as JObject).Children().FirstOrDefault(z => z.Path == "properties");
if (prop != null)
{
foreach (var t in prop.Values().Where(z => z.Path != "properties.type").ToList())
{
c.properties.Add(new keyValue((t as JProperty).Name, t.First().ToString()));
}
}
}
person.children.Add(c);
}
}));
tasks.Add(Task.Run(async() =>
{
// my parents
qry = $"g.V('{id}').inE('parent').outV()";
var infoes = await grem.getResultsAsync(qry);
var edges = await grem.getResultsAsync($"g.V('{id}').inE('parent')");
foreach (var i in infoes)
{
var p = new person()
{
name = (i as JToken)["properties"].Where(x => x.Path == "properties.name").First().Values().First()["value"].ToString(),
id = (i as JObject)["id"].ToString()
};
var par = edges.Where(x => (x as JObject)["outV"].ToString() == p.id).FirstOrDefault();
if (par != null)
{
var prop = (par as JObject).Children().FirstOrDefault(z => z.Path == "properties");
if (prop != null)
{
var t = prop.Values().FirstOrDefault(z => z.Path == "properties.type");
if (t != null)
{
p.type = t.First().ToString();
}
}
}
person.parents.Add(p);
}
}));
tasks.Add(Task.Run(async() =>
{
// my siblings
//qry = $"g.V('{id}').as('o').bothE('sibling').bothV().where(neq('o'))";
qry = $"g.V('{id}').as('o').inE('parent').outV().outE('parent').inV().where(neq('o')).dedup()";
var infoes = await grem.getResultsAsync(qry);
foreach (var i in infoes)
{
var sibId = (i as JObject)["id"].ToString();
if (sibId != id && !person.siblings.Any(x => x.id == id))
{
var s = new person()
{
name = (i as JToken)["properties"].Where(x => x.Path == "properties.name").First().Values().First()["value"].ToString(),
id = sibId
};
var g = (i as JToken)["properties"].Where(x => x.Path == "properties.gender").FirstOrDefault();
if (g != null)
{
if (g.Values()["value"].First().ToString() == "M")
{
s.type = "Brother";
}
else
{
s.type = "Sister";
}
}
person.siblings.Add(s);
}
}
}));
Task.WaitAll(tasks.ToArray());
return(person);
}
public async Task Bootstrap()
{
string adam;
string eve;
string cain;
string seth;
string abel;
string enosh;
string kenan;
var g = new GremlinHelper();
List <string> initialQueries = new List <string>
{
{ "g.V().drop()" },
{ "g.addV('person').property('name', 'Adam').property('gender', 'M')" },
{ "g.addV('person').property('name', 'Eve').property('gender', 'F')" },
{ "g.addV('person').property('name', 'Cain').property('gender', 'M')" },
{ "g.addV('person').property('name', 'Abel').property('gender', 'M')" },
{ "g.addV('person').property('name', 'Seth').property('gender', 'M')" },
{ "g.addV('person').property('name', 'Enosh').property('gender', 'M')" },
{ "g.addV('person').property('name', 'Kenan').property('gender', 'M')" }
};
foreach (var q in initialQueries)
{
await g.getResultAsync(q);
}
adam = (await g.getIdsByNameAsync("Adam"))[0];
eve = (await g.getIdsByNameAsync("Eve"))[0];
cain = (await g.getIdsByNameAsync("Cain"))[0];
seth = (await g.getIdsByNameAsync("Seth"))[0];
abel = (await g.getIdsByNameAsync("Abel"))[0];
enosh = (await g.getIdsByNameAsync("Enosh"))[0];
kenan = (await g.getIdsByNameAsync("Kenan"))[0];
await g.getResultAsync($"g.V('{adam}').addE('married').to(g.V('{eve}'))");
await g.getResultAsync($"g.V('{eve}').addE('parent').to(g.V('{cain}'))");
await g.getResultAsync($"g.V('{eve}').addE('parent').to(g.V('{abel}'))");
await g.getResultAsync($"g.V('{eve}').addE('parent').to(g.V('{seth}'))");
await g.getResultAsync($"g.V('{adam}').addE('parent').to(g.V('{cain}'))");
await g.getResultAsync($"g.V('{adam}').addE('parent').to(g.V('{abel}'))");
await g.getResultAsync($"g.V('{adam}').addE('parent').to(g.V('{seth}'))");
// only 1 child, so can update entire path for seth
await g.getResultAsync($"g.V('{seth}').addE('parent').to(g.V('{enosh}'))");
await g.getResultAsync($"g.V('{seth}').outE('parent').property('type', 'Father').property('age', 105)");
await g.getResultAsync($"g.V('{enosh}').addE('parent').to(g.V('{kenan}'))");
await g.getResultAsync($"g.V('{kenan}').inE('parent').has('type', 'Father').property('age', 90)");
// where as multiple children, and we want to update only Seth -> parent.fathe
await g.getResultAsync($"g.V('{seth}').inE('parent').has('type', 'Father').property('age', 130)");
// Adam -> parent -> Seth path
// await g.getResultAsync($"g.V('{adam}').outE('parent').inV().has('person', 'name', 'Seth').as('s').inE().has('type', 'Father').property('age', 130)");
await g.getResultAsync($"g.V('{eve}').outE('parent').property('type', 'Mother')");
await g.getResultAsync($"g.V('{adam}').outE('parent').property('type', 'Father')");
}
