To use a database with a custom name, I need to edit neo4j.conf and set initial.dbms.default_database<\/p>\n
Then create a Docker container \u2013 I am mapping \/data to an external directory to persist my data and \/var\/lib\/neo4j\/conf to an external directory to persist configuration<\/p>\n docker run -dit --name neo4j --publish=7474:7474 --publish=7687:7687 --env=NEO4J_AUTH=none --volume=\/docker\/neo4j\/data:\/data --volume=\/docker\/neo4j\/conf:\/var\/lib\/neo4j\/conf neo4j<\/tt><\/p>\n Listing the databases using \u201cshow databases\u201d will show my custom database name<\/p>\n Switch to our database with the \u201c:use\u201d instruction<\/p>\n CREATE (:PLANTS {name: ‘Black Krim’, year: 1856, color: ‘deep red’, flavor: ‘sweet’, notes: ‘Heirloom seedstock’})<\/p>\n Note: <\/em>After I started using my data, I realized that \u201cPLANTS\u201d is a silly label to use since they will all<\/em> be plants. I recreated all of my data with nodes labeled \u201cTOMATO\u201d so I can also track peppers, daffodils, and any other plants we start hybridizing.<\/p>\n Load of all records:<\/p>\n The search starts with the verb \u201cMATCH\u201d. In parenthesis, we add the matching rule. This begins with an object name variable \u2013 you can have anonymous nodes (no variable names assigned) by omitting this string and just typing the colon. This is followed by the label that we want to match \u2013 basically the type of node we are looking for. Then, in curly braces, a filter \u2013 in this case, I am looking for nodes where the \u201cname\u201d field has the value \u201cBlack Krim\u201d. Finally, there\u2019s a return statement that indicates that we want to output the matched results.<\/p>\n You can include relationships<\/em> in the query \u2013 parenthesis around nodes and square brackets around relationships.<\/p>\n (placeholdername:nodes)-[:RELATIONSHIP_CONNECTION_TYPE]->(anotherplaceholdername:otherNodes)<\/tt><\/p>\n This is what makes graph databases interesting for tracking hybridization \u2013 we can easily produce the lineage of the plants we develop.<\/p>\n Deleting a record is used in conjunction with match — use the DELETE verb on the collections of objects returned into your variable name. Here, the variable is ‘x’:<\/p>\n When deleting a record, you can include relationship matches:<\/p>\n To create a relationship, we first need to match two objects \u2013 here I am finding a plant named PLANT0 and all of the \u201cheirloom seedstock\u201d plants to which I assigned year 1900 \u2013 and create parent\/child relationships. Since there is both a male and female parent, that is included in the relationship name:<\/p>\n You can create records and relationships in a single command, too:<\/p>\n When you match records, you will also get their relationships:<\/p>\n![\"\"](\"https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2023\/08\/neo4j-image1.png\")
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\nCreate single nodes<\/h2>\n
<\/a><\/p>\nCREATE(:TOMATO {flavor: \"air\",notes: \"hypothetical\",color: \"invisible\",year: \"1\",name: \"PLANT0\"});\r\nCREATE(:TOMATO {flavor: \"acidic\",notes: \"Heirloom seedstock\",color: \"purple\",year: 1890,name: \"Cherokee Purple\"});\r\nCREATE(:TOMATO {flavor: \"sweet\",notes: \"Heirloom seedstock\",color: \"bright red\",name: \"Whittemore\"});\r\nCREATE(:TOMATO {flavor: \"sweet\",notes: \"Heirloom seedstock\",color: \"deep red\",year: 1856,name: \"Black Krim\"});\r\nCREATE(:TOMATO {name: 'Kellogg', color: 'bright red', flavor: 'sweet', year: '1900', notes: 'beautiful and tasty'});\r\nCREATE(:TOMATO {name: 'Brandywine', color: 'bright red', flavor: 'sweet', year: '1900', notes: 'very tasty'});\r\nCREATE(:TOMATO {name: 'Japanese Trifele Black', color: 'dark purple red', flavor: 'sweet', year: '1900', notes: 'nice acidic flavor'});\r\nCREATE(:TOMATO {name: 'Sweet Apertif', color: 'bright red', flavor: 'sweet', year: '1900', notes: 'cherry'});\r\nCREATE(:TOMATO {name: 'Eva Purple', color: 'dark purple red', flavor: 'sweet', year: '1900', notes: 'did not grow well'});\r\nCREATE(:TOMATO {name: 'Mortgage Lifter', color: 'bright red', flavor: 'sweet', year: '1900', notes: 'huge but lacking flavor and lots of bad spots'});\r\nCREATE(:TOMATO {flavor: \"sweet\",notes: \"\",color: \"deep red\",year: \"2021\",name: \"Tomato0000001\"});\r\nCREATE(:TOMATO {flavor: \"bland\",notes: \"small tomatoes with little flavor\",color: \"red\",year: \"2021\",name: \"Tomato0000002\"});\r\nCREATE(:TOMATO {flavor: \"watery\",notes: \"not much acid\",color: \"pinkish\",year: \"2022\",name: \"Tomato0000003\"});\r\nCREATE(:TOMATO {flavor: \"sweet\",notes: \"sweet, slightly acidic\",color: \"red\",year: \"2022\",name: \"Tomato0000004\"}) ;\r\nCREATE (:TOMATO {name: 'Tomato0000005', color: 'bright red', flavor: 'sweet', year: '2022', notes: 'amazing'});\r\nCREATE (:TOMATO {name: 'Tomato0000006', color: 'bright red', flavor: 'sweet', year: '2023', notes: 'beautiful and tasty but no bigger than parent'});\r\nCREATE (:TOMATO {name: 'Tomato0000007', color: 'bright red', flavor: 'sweet', year: '2023', notes: 'beautiful and tasty but no bigger than parent'});\r\nCREATE (:TOMATO {name: 'Tomato0000008', color: 'bright red', flavor: 'sweet', year: '2023', notes: 'beautiful and tasty, slightly larger than parent'});<\/pre>\nShow records with MATCH<\/h2>\n
<\/a><\/p>\nDeleting a record<\/h2>\n
MATCH (x:PLANTS{name: 'Black Krim'})\r\nDELETE x<\/pre>\nDeleting a record and relationships by ID<\/h2>\n
MATCH (p:PLANTS) where ID(p)=1\r\nOPTIONAL MATCH (p)-[r]-()\r\nDELETE r,p<\/pre>\n
Create a relationship<\/h2>\n
MATCH (a:TOMATO), (b:TOMATO)\r\nWHERE a.name = 'PLANT0' AND b.year = '1900'\r\nCREATE (a)-[r:PARENT_M]->(b)\r\n\r\nMATCH (a:TOMATO), (b:TOMATO)\r\nWHERE a.name = 'PLANT0' AND b.year = '1900'\r\nCREATE (a)-[r:PARENT_F]->(b)<\/pre>\n
Create records with parent\/child relationships<\/h2>\n
CREATE p = (:PLANTS {name: 'Black Krim', year: 1856, color: 'deep red', flavor: 'sweet', notes: 'Heirloom seedstock'})-[:PARENT_M]->(:PLANTS {name: 'Tomato0000001', color: 'deep red', flavor: 'sweet', year: '2023', notes: ''})<-[:PARENT_F]-(:PLANTS {name: 'Cherokee Purple', color: 'purple', flavor: 'acidic', year: 1890, notes: 'Heirloom seedstock'})\r\n\r\nRETURN p<\/pre>\n<\/a><\/h2>\nViewing Records with Relationships<\/h2>\n