Advanced features of EspressoDB

EspressoDB provides certain features which help navigating complex table relations. In this section we present

1. how consistency checks can be implemented to make it difficult to insert inconsistent data and

2. how tables can be written such that one can easily extend future scenarios.

Contents:

• Consistency checks
  • TL;DR
  • The need for checks
  • The basic idea
  • Disable checks
  • Raised exceptions
  • Many-to-many checks
• Pre-save functionality
  • TL;DR
  • Implementing a code version storage
• Automated cross-checks
  • Updating default behavior
• More complicated tables
  • In which scenario are they helpful
  • Implementation of common base
    • The implementation
    • Underlaying tables
      • hamiltonian_hamiltonian
      • hamiltonian_contact
      • hamiltonian_coulomb
      • hamiltonian_eigenvalue
    • Unique constraints
      • hamiltonian_hamiltonian
      • hamiltonian_contact
    • Queries and member access