Accession - CharlesBenjaminHaag/GRINext-Business-Component GitHub Wiki

Sequence: OnDelete

Diagram

---
Proposed BusinessLogic
---
sequenceDiagram
     actor User
    User->>Accession: Delete
    activate Inventory
    Accession->>Inventory: Find(accession_id)
    Inventory->>DB: Select(inventory_id)
    alt exists
    Inventory-->>Accession: Inventory
    Accession->>Inventory: Delete(inventory_id)
    Inventory->>DB: Delete(inventory_id)
    end   
    deactivate Inventory

SQL

1. select form_type_code, inventory_id from inventory where accession_id = :accessionid
2. delete from inventory where inventory_id = :inventoryid

Sequence: OnInsertOrUpdate

Diagram

sequenceDiagram
     
    actor User
    User->>Accession: Insert or Update
    activate Species
    Accession->>Species: Find(taxonomy_species_id)
    Species->>DB: Select(taxonomy_species_id)
    alt exists
    Species-->>Accession: Species
    Accession->>AccessionInvAnnocation: Create(taxonomy_species_id, 'RECEIVED')
    end   
    deactivate Species