IF exists( select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='myTable' and COLUMN_NAME='columnToDrop') | |
BEGIN | |
ALTER TABLE myTable drop COLUMN columnToDrop | |
END |
private void ClearDb(IGraphClient client) | |
{ | |
client.Cypher | |
.Match("(n)") | |
.DetachDelete("n") | |
.ExecuteWithoutResults(); | |
} |
Here is an example of importing distinct data from a CSV file, and creating relationships using that data.
This method is more efficient than just using MERGE. It never tries to match any duplicates from the csv file as they are filtered out beforehand. It still uses MERGE to ensure that duplicate nodes are not created, but in this situation this would only be required if the csv file was loaded more than once.
This gist was prompted by Nigel Small’s tweet of a query to generate a unique id for a node (and is posted here with his agreement). It inspired me to think about how it could be used in a full example, unrestricted by Twitter’s 140 characters. I have also looked at how we could generate different sets of unique ids for different labels.
Auto-incrementing #Neo4j counter
MERGE (x:Counter {name:'foo'})
ON CREATE SET x.count = 0
ON MATCH SET x.count = x.count + 1
RETURN x.count
— Nigel Small (@technige) December 16, 2013