public T Update <T>(
T entity,
string uuid,
bool fetchResult = false) where T : EntityBase, new()
{
if (entity == null)
{
throw new ArgumentNullException("entity");
}
if (string.IsNullOrWhiteSpace(uuid))
{
throw new ArgumentNullException("uuid");
}
//entity.uuid = uuid;
dynamic properties = entity.AsUpdateClause(TAG);
dynamic clause = properties.clause;
IDictionary <string, object> parameters = properties.parameters;
var query = new StringFormatter(QueryTemplates.TEMPLATE_UPDATE);
query.Add("@label", entity.Label);
query.Add("@Uuid", uuid);
query.Add("@clause", clause);
query.Add("@return", fetchResult ? string.Format("RETURN {0}", TAG) : string.Empty);
IStatementResult result = ExecuteQuery(query.ToString(), parameters);
return(result.Map <T>());
}
public bool MergeRelationship(
string uuidFrom,
string uuidTo,
RelationshipAttribute relationshipAttribute)
{
if (string.IsNullOrWhiteSpace(uuidFrom))
{
throw new ArgumentNullException("uuidFrom");
}
if (string.IsNullOrWhiteSpace(uuidTo))
{
throw new ArgumentNullException("uuidTo");
}
if (relationshipAttribute == null)
{
throw new ArgumentNullException("relationshipAttribute");
}
var query = new StringFormatter(QueryTemplates.TEMPLATE_MERGE_RELATIONSHIP);
query.Add("@uuidFrom", uuidFrom);
query.Add("@uuidTo", uuidTo);
query.Add("@fromPartDirection", relationshipAttribute.Direction == DIRECTION.INCOMING ? "<-" : "-");
query.Add("@toPartDirection", relationshipAttribute.Direction == DIRECTION.INCOMING ? "-" : "->");
query.Add("@relationshipName", relationshipAttribute.Name);
IStatementResult result = ExecuteQuery(query.ToString());
return(result.Any());
}
public bool DropRelationshipBetweenTwoNodes(
string uuidIncoming,
string uuidOutgoing,
RelationshipAttribute relationshipAttribute)
{
if (string.IsNullOrWhiteSpace(uuidIncoming))
{
throw new ArgumentNullException("uuidIncoming");
}
if (string.IsNullOrWhiteSpace(uuidOutgoing))
{
throw new ArgumentNullException("uuidOutgoing");
}
if (relationshipAttribute == null)
{
throw new ArgumentNullException("relationshipAttribute");
}
var query = new StringFormatter(QueryTemplates.TEMPLATE_DROP_RELATIONSHIPBETWEENTWONODES);
query.Add("@uuidIncoming", uuidIncoming);
query.Add("@uuidOutgoing", uuidOutgoing);
query.Add("@fromPartDirection", relationshipAttribute.Direction == DIRECTION.INCOMING ? "<-" : "-");
query.Add("@toPartDirection", relationshipAttribute.Direction == DIRECTION.INCOMING ? "-" : "->");
query.Add("@relationshipName", relationshipAttribute.Name);
IStatementResult result = ExecuteQuery(query.ToString());
return(result.Summary.Counters.RelationshipsDeleted > 0);
}
public bool Drop <T>(string uuid) where T : EntityBase, new()
{
if (string.IsNullOrWhiteSpace(uuid))
{
throw new ArgumentNullException("uuid");
}
var query = new StringFormatter(QueryTemplates.TEMPLATE_DROP);
query.Add("@label", new T().Label);
query.Add("@Uuid", uuid);
IStatementResult result = ExecuteQuery(query.ToString());
return(result.Summary.Counters.NodesDeleted == 1);
}
public T Delete <T>(string uuid) where T : EntityBase, new()
{
if (string.IsNullOrWhiteSpace(uuid))
{
throw new ArgumentNullException("uuid");
}
T model = new T();
var query = new StringFormatter(QueryTemplates.TEMPLATE_DELETE);
query.Add("@label", model.Label);
query.Add("@Uuid", uuid);
query.Add("@updatedAt", DateTime.UtcNow.ToTimeStamp());
IStatementResult result = ExecuteQuery(query.ToString());
return(result.Map <T>());
}
public int DropByProperties <T>(Dictionary <string, object> props) where T : EntityBase, new()
{
if (props == null || !props.Any())
{
throw new ArgumentNullException("props");
}
dynamic properties = props.AsQueryClause();
dynamic clause = properties.clause;
Dictionary <string, object> parameters = properties.parameters;
var query = new StringFormatter(QueryTemplates.TEMPLATE_DROP_BY_PROPERTIES);
query.Add("@label", new T().Label);
query.Add("@clause", clause);
IStatementResult result = ExecuteQuery(query.ToString(), parameters);
return(result.Summary.Counters.NodesDeleted);
}
public IList <T> GetByProperty <T>(
string propertyName,
object propertValue) where T : EntityBase, new()
{
if (string.IsNullOrWhiteSpace(propertyName))
{
throw new ArgumentNullException("propertyName");
}
if (propertValue == null)
{
throw new ArgumentNullException("propertValue");
}
var entites = new Lazy <List <T> >();
var query = new StringFormatter(QueryTemplates.TEMPLATE_GET_BY_PROPERTY);
query.Add("@label", new T().Label);
query.Add("@property", propertyName);
query.Add("@result", TAG);
query.Add("@relatedNode", string.Empty);
query.Add("@relationship", string.Empty);
IStatementResult result = ExecuteQuery(query.ToString(), new { value = propertValue });
foreach (IRecord record in result)
{
var node = record[0].As <INode>().Properties;
var relatedNodes = FetchRelatedNode <T>(node["Uuid"].ToString());
var nodes = node.Concat(relatedNodes).ToDictionary(x => x.Key, x => x.Value);
T nodeObject = nodes.Map <T>();
entites.Value.Add(nodeObject);
}
return(entites.Value);
}
public T GetByUuidWithRelatedNodes <T>(string uuid) where T : EntityBase, new()
{
if (string.IsNullOrWhiteSpace(uuid))
{
throw new ArgumentNullException("uuid");
}
var query = new StringFormatter(QueryTemplates.TEMPLATE_GET_BY_PROPERTY);
query.Add("@label", new T().Label);
query.Add("@property", "Uuid");
query.Add("@result", TAG);
query.Add("@relatedNode", string.Empty);
query.Add("@relationship", string.Empty);
IStatementResult result = ExecuteQuery(query.ToString(), new { value = uuid });
IReadOnlyDictionary <string, object> node = result.FirstOrDefault()?[0].As <INode>().Properties;
if (node == null)
{
return(default);
public IList <T> GetByProperties <T>(Dictionary <string, object> entity)
where T : EntityBase, new()
{
if (entity == null)
{
throw new ArgumentNullException("entity");
}
dynamic properties = entity.AsQueryClause();
dynamic clause = properties.clause;
Dictionary <string, object> parameters = properties.parameters;
var entites = new Lazy <List <T> >();
var query = new StringFormatter(QueryTemplates.TEMPLATE_GET_BY_PROPERTIES);
query.Add("@label", new T().Label);
query.Add("@clause", clause);
query.Add("@result", TAG);
query.Add("@relatedNode", string.Empty);
query.Add("@relationship", string.Empty);
IStatementResult result = ExecuteQuery(query.ToString(), parameters);
foreach (IRecord record in result)
{
var node = record[0].As <INode>().Properties;
var relatedNodes = FetchRelatedNode <T>(node["Uuid"].ToString());
var nodes = node.Concat(relatedNodes).ToDictionary(x => x.Key, x => x.Value);
T nodeObject = Mapper.Map <T>(nodes);
entites.Value.Add(nodeObject);
}
return(entites.Value);
}
public override string ToString()
{
if (Data == null || _formatString.Length == 0)
{
return(Name);
}
var result = new StringFormatter($"{Name} {_formatString}");
foreach (var argument in _arguments.Values)
{
result.Add(argument.Name, argument.Format(Data, Position));
}
return(result.ToString());
}
public bool CreateRelationship(
string uuidFrom,
string uuidTo,
RelationshipAttribute relationshipAttribute,
Dictionary <string, object> props = null)
{
if (string.IsNullOrWhiteSpace(uuidFrom))
{
throw new ArgumentNullException("uuidFrom");
}
if (string.IsNullOrWhiteSpace(uuidTo))
{
throw new ArgumentNullException("uuidTo");
}
if (relationshipAttribute == null)
{
throw new ArgumentNullException("relationshipAttribute");
}
var query = new StringFormatter(QueryTemplates.TEMPLATE_CREATE_RELATIONSHIP);
query.Add("@uuidFrom", uuidFrom);
query.Add("@uuidTo", uuidTo);
query.Add("@fromPartDirection", relationshipAttribute.Direction == DIRECTION.INCOMING ? "<-" : "-");
query.Add("@toPartDirection", relationshipAttribute.Direction == DIRECTION.INCOMING ? "-" : "->");
query.Add("@relationshipName", relationshipAttribute.Name);
IStatementResult result;
if (props != null)
{
dynamic properties = props.AsQueryClause();
dynamic clause = properties.clause;
IDictionary <string, object> parameters = properties.parameters;
query.Add("@clause", $"{{{clause}}}");
result = ExecuteQuery(query.ToString(), parameters);
}
else
{
query.Add("@clause", string.Empty);
result = ExecuteQuery(query.ToString());
}
return(result.Summary.Counters.RelationshipsCreated > 0);
}
public T Merge <T>(
T entityOnCreate,
T entityOnUpdate,
string where) where T : EntityBase, new()
{
if (entityOnCreate == null)
{
throw new ArgumentNullException("entityOnCreate");
}
if (entityOnUpdate == null)
{
throw new ArgumentNullException("entityOnUpdate");
}
bool firstNode = true;
var setCaluseOnCreate = new Lazy <StringBuilder>();
var setCaluseOnUpdate = new Lazy <StringBuilder>();
var formattedSetClauseOnCreate = new StringFormatter("");
var formattedSetClauseOnUpdate = new StringFormatter("");
foreach (PropertyInfo prop in entityOnCreate.GetType().GetProperties(BindingFlags.Public | BindingFlags.Instance))
{
if (prop.GetCustomAttribute(typeof(NotMappedAttribute), true) != null ||
prop.GetCustomAttribute(typeof(RelationshipAttribute), true) != null)
{
continue;
}
if (prop.Name.Equals("Uuid", StringComparison.CurrentCultureIgnoreCase))
{
continue;
}
object value = prop.GetValue(entityOnCreate, null);
string prefixAndPostfix = (value is string) ? "\"" : string.Empty;
formattedSetClauseOnCreate.Add(BIND_MARKER + prop.Name + BIND_MARKER, prefixAndPostfix + (value ?? "null") + prefixAndPostfix);
if (firstNode)
{
firstNode = false;
}
else
{
setCaluseOnCreate.Value.Append(",");
}
setCaluseOnCreate.Value.Append(string.Format("n.{0}={1}{0}{1}", prop.Name, BIND_MARKER));
}
firstNode = true;
foreach (PropertyInfo prop in entityOnUpdate.GetType().GetProperties(BindingFlags.Public | BindingFlags.Instance))
{
if (prop.GetCustomAttribute(typeof(NotMappedAttribute), true) != null ||
prop.GetCustomAttribute(typeof(RelationshipAttribute), true) != null)
{
continue;
}
if (prop.Name.Equals("Uuid", StringComparison.CurrentCultureIgnoreCase))
{
continue;
}
object value = prop.GetValue(entityOnUpdate, null);
string prefixAndPostfix = (value is string) ? "\"" : string.Empty;
formattedSetClauseOnUpdate.Add(BIND_MARKER + prop.Name + BIND_MARKER, prefixAndPostfix + (value ?? "null") + prefixAndPostfix);
if (firstNode)
{
firstNode = false;
}
else
{
setCaluseOnUpdate.Value.Append(",");
}
setCaluseOnUpdate.Value.Append(string.Format("n.{0}={1}{0}{1}", prop.Name, BIND_MARKER));
}
string uuid = StripHyphens ? Guid.NewGuid().ToString("N") : Guid.NewGuid().ToString();
formattedSetClauseOnCreate.Add(string.Format("{0}Uuid{0}", BIND_MARKER), "\"" + uuid + "\"");
setCaluseOnCreate.Value.Append(firstNode ? string.Format("n.Uuid={0}Uuid{0}", BIND_MARKER) : string.Format(",n.Uuid={0}Uuid{0}", BIND_MARKER));
formattedSetClauseOnCreate.Str = setCaluseOnCreate.Value.ToString();
formattedSetClauseOnUpdate.Str = setCaluseOnUpdate.Value.ToString();
var query = new StringFormatter(QueryTemplates.TEMPLATE_MERGE);
query.Add("@node", entityOnCreate.Label);
query.Add("@on_create_clause", string.Format("ON CREATE SET {0}", formattedSetClauseOnCreate.ToString()));
query.Add("@on_match_clause", string.Format("ON MATCH SET {0}", formattedSetClauseOnUpdate.ToString()));
query.Add("@conditions", where);
IStatementResult statementResult = ExecuteQuery(query.ToString());
return(statementResult.Map <T>());
}
public T Add <T>(T entity) where T : EntityBase, new()
{
if (entity == null)
{
throw new ArgumentNullException("entity");
}
StringFormatter match = null;
string clause = null;
bool firstNode = true;
bool hasRelationship = false;
var parameters = new Lazy <Dictionary <string, object> >();
var conditions = new Lazy <StringBuilder>();
foreach (PropertyInfo prop in entity.GetType().GetProperties(BindingFlags.Public | BindingFlags.Instance))
{
if (prop.GetCustomAttribute(typeof(NotMappedAttribute), true) != null ||
prop.GetCustomAttribute(typeof(RelationshipAttribute), true) != null)
{
continue;
}
if (prop.Name.Equals("Uuid", StringComparison.CurrentCultureIgnoreCase))
{
continue;
}
parameters.Value[prop.Name] = prop.GetValue(entity, null);
if (firstNode)
{
firstNode = false;
}
else
{
conditions.Value.Append(",");
}
conditions.Value.Append(string.Format("{0}:${0}", prop.Name));
}
string uuid = StripHyphens ? Guid.NewGuid().ToString("N") : Guid.NewGuid().ToString();
parameters.Value["Uuid"] = uuid;
conditions.Value.Append(firstNode ? "Uuid:$Uuid" : ",Uuid:$Uuid");
var query = new StringFormatter(QueryTemplates.TEMPLATE_CREATE);
query.Add("@match", hasRelationship ? match.ToString() : string.Empty);
query.Add("@node", entity.Label);
query.Add("@conditions", conditions.Value.ToString());
query.Add("@clause", hasRelationship ? clause : string.Empty);
IStatementResult result = ExecuteQuery(query.ToString(), parameters.Value);
if (result.Summary.Counters.NodesCreated == 0)
{
throw new Exception("Node creation error!");
}
return(result.Map <T>());
}
private IDictionary <string, object> FetchRelatedNode <T>(string uuid)
where T : EntityBase, new()
{
if (string.IsNullOrWhiteSpace(uuid))
{
throw new ArgumentNullException("uuid");
}
var query = new StringFormatter(QueryTemplates.TEMPLATE_GET_BY_PROPERTIES);
query.Add("@label", new T().Label);
query.Add("@clause", "Uuid:$Uuid");
query.Add("@result", TAG);
query.Add("@relatedNode", string.Empty);
query.Add("@relationship", string.Empty);
var nodes = new Lazy <Dictionary <string, object> >();
foreach (PropertyInfo prop in typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance))
{
if (prop.GetCustomAttribute(typeof(NotMappedAttribute), true) != null)
{
continue;
}
RelationshipAttribute relationshipAttribute = (RelationshipAttribute)prop.GetCustomAttributes(typeof(RelationshipAttribute), true).FirstOrDefault();
if (relationshipAttribute != null)
{
string labelName;
if (prop.PropertyType.GetInterfaces().Contains(typeof(IEnumerable)))
{
labelName = (Activator.CreateInstance(prop.PropertyType.GetGenericArguments()[0], null) as EntityBase).Label;
}
else
{
labelName = (Activator.CreateInstance(prop.PropertyType, null) as EntityBase).Label;
}
string parameterRelatedNode = string.Format(@"(rNode:{0}{{IsDeleted:false}})", labelName);
string parameterRelationship = string.Format(
@"{0}[r:{1}]{2}",
relationshipAttribute.Direction == DIRECTION.INCOMING ? "<-" : "-",
relationshipAttribute.Name,
relationshipAttribute.Direction == DIRECTION.INCOMING ? "-" : "->");
query.Remove("@result");
query.Remove("@relatedNode");
query.Remove("@relationship");
query.Add("@relatedNode", parameterRelatedNode);
query.Add("@relationship", parameterRelationship);
query.Add("@result", "rNode");
IStatementResult resultRelatedNode = ExecuteQuery(query.ToString(), new { Uuid = uuid });
if (prop.PropertyType.GetInterfaces().Contains(typeof(IEnumerable)))
{
var relatedNodes = new Lazy <List <IReadOnlyDictionary <string, object> > >();
foreach (IRecord record in resultRelatedNode)
{
IReadOnlyDictionary <string, object> node = record[0].As <INode>().Properties;
relatedNodes.Value.Add(node);
}
if (relatedNodes.IsValueCreated)
{
nodes.Value.Add(prop.Name, relatedNodes.Value);
}
}
else
{
IReadOnlyDictionary <string, object> relatedNode = resultRelatedNode.FirstOrDefault()?[0].As <INode>().Properties;
if (relatedNode != null)
{
nodes.Value.Add(prop.Name, relatedNode);
}
}
}
}
return(nodes.Value);
}