Skip to content

db

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

db

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
README.md
README.md
 
 
__init__.py
__init__.py
 
 
analysis_method.py
analysis_method.py
 
 
aquifer_system.py
aquifer_system.py
 
 
aquifer_type.py
aquifer_type.py
 
 
asset.py
asset.py
 
 
base.py
base.py
 
 
chemistry_views.py
chemistry_views.py
 
 
collabnet.py
collabnet.py
 
 
contact.py
contact.py
 
 
data_provenance.py
data_provenance.py
 
 
deployment.py
deployment.py
 
 
engine.py
engine.py
 
 
field.py
field.py
 
 
geochronology.py
geochronology.py
 
 
geologic_formation.py
geologic_formation.py
 
 
geothermal.py
geothermal.py
 
 
group.py
group.py
 
 
initialization.py
initialization.py
 
 
lexicon.py
lexicon.py
 
 
location.py
location.py
 
 
measuring_point_history.py
measuring_point_history.py
 
 
ngwmn_views.py
ngwmn_views.py
 
 
nma_legacy.py
nma_legacy.py
 
 
nmw_legacy.py
nmw_legacy.py
 
 
notes.py
notes.py
 
 
observation.py
observation.py
 
 
parameter.py
parameter.py
 
 
permission.py
permission.py
 
 
permission_history.py
permission_history.py
 
 
publication.py
publication.py
 
 
regulatory_limit.py
regulatory_limit.py
 
 
sample.py
sample.py
 
 
sensor.py
sensor.py
 
 
status_history.py
status_history.py
 
 
thing.py
thing.py
 
 
thing_aquifer_association.py
thing_aquifer_association.py
 
 
thing_geologic_formation_association.py
thing_geologic_formation_association.py
 
 
transducer.py
transducer.py
 
 

README.md

DB

This directory contains SQLAlchemy models, engine/session setup, and database initialization helpers.

Key files

  • db/base.py: shared ORM base mixins and common fields
  • db/engine.py: engine/session configuration
  • db/initialization.py: schema/bootstrap utilities

Schema changes

  • Use Alembic migrations under alembic/versions/ for all DDL changes.
  • Keep model nullability/defaults aligned with migrations.
  • Prefer idempotent data migrations and safe re-runs.

Local usage

source .venv/bin/activate
alembic upgrade head