paleobot / pbot-dev

Codebase and initial design documents for pbot client
MIT License
2 stars 2 forks source link

Delete Nodes Collection #152

Closed clairecleveland closed 12 months ago

clairecleveland commented 1 year ago

Database clean up for Hack-A-Thon. Please follow steps below so that Doug can "cleanse" the database prior to the Hack-A-Thon. Perhaps a week before?

Anything nodes that will be used as an example for testing PBot or the PBot Hack-A-Thon, etc. should include the word "test" in the name.

Please indicate all nodes that are no longer in use and should be deleted from PBot with the word "DELETE" in the name. This way Doug can easily search for all nodes to be deleted.

Additional nodes that should be deleted, but can not be edited:

aazaff commented 1 year ago

URGENT to discuss for Tuesday 7/25 meeting.

For maximum safety we would like to save ALL nodes (and associated relations) of the following types:

  1. SCHEMA
  2. CHARACTER
  3. STATE
  4. PERSON
  5. REFERENCE

We would like to delete ALL of the following nodes prior to the meeting.

  1. Specimen/_Specimen
  2. Collection/_Collection
  3. Image/_Image
  4. Comment/_Comment
  5. Synonym/_Synonym
  6. CharacterInstance/_CharacterInstance
  7. Description/_Description
  8. OTU/_OTU

Once these deletes have happened. The pbot team can re-enter relevant examples.

NoisyFlowers commented 12 months ago

This is done.

I also deleted all image files.

Precleanup db dump is in /var/lib/neo4j/import/pbot-1690919730694-preCleanup.cypher

Postcleanup db dump is in /var/lib/neo4j/import/pbot-1690922067127-Clean.cypher