pyproject.toml

[project]
name = "OcotilloAPI"
version = "1.2.0"
description = "FastAPI backend and CLI for managing Ocotillo groundwater locations, wells, assets, and bulk water-level data transfers."
readme = "README.md"
requires-python = ">=3.13"
dependencies = [
  "aiofiles==24.1.0",
  "aiohappyeyeballs==2.7.1",
  "aiohttp==3.14.3",
  "aiosignal==1.4.0",
  "aiosqlite==0.22.1",
  "alembic==1.19.1",
  "annotated-types==0.8.0",
  "anyio==4.14.2",
  "apitally[fastapi]==0.25.1",
  "asgiref==3.12.1",
  "asn1crypto==1.5.1",
  "asyncpg==0.31.0",
  "attrs==26.1.0",
  "authlib==1.7.2",
  "bcrypt==4.3.0",
  "cachetools==7.1.7",
  "certifi==2026.7.22",
  "cffi==2.1.1",
  "charset-normalizer==3.5.0",
  "click==8.4.2",
  "cloud-sql-python-connector==1.21.0",
  "cryptography==50.0.0",
  "dnspython==2.8.0",
  "dotenv==0.9.9",
  "email-validator==2.3.0",
  "fastapi==0.141.1",
  "fastapi-pagination==0.15.16",
  "frozenlist==1.8.0",
  "geoalchemy2==0.20.0",
  "google-api-core==2.34.0",
  "google-auth==2.56.3",
  "google-cloud-core==2.6.1",
  "google-cloud-storage==3.13.1",
  "google-crc32c==1.8.0",
  "google-resumable-media==2.10.1",
  "googleapis-common-protos==1.75.1",
  "greenlet==3.5.5",
  "gunicorn==26.0.0",
  "h11==0.16.0",
  "httpcore==1.0.9",
  "httpx==0.28.1",
  "idna==3.18",
  "iniconfig==2.3.0",
  "jinja2==3.1.6",
  "mako==1.4.1",
  "markupsafe==3.0.3",
  "multidict==6.7.1",
  "numpy==2.5.2",
  "packaging==26.3",
  "pandas==2.3.2",
  "pandas-stubs~=2.3.2",
  "pg8000==1.31.5",
  "phonenumbers==9.0.37",
  "pillow==12.3.0",
  "pluggy==1.6.0",
  "propcache==0.5.2",
  "proto-plus==1.28.3",
  "protobuf==6.33.5",
  "psycopg2-binary>=2.9.12",
  "pyasn1==0.6.4",
  "pyasn1-modules==0.4.2",
  "pycparser==3.0",
  "pydantic==2.12.5",
  "pydantic-core==2.41.5",
  "pygments==2.20.0",
  "pyjwt==2.13.0",
  "pygeoapi==0.24.0",
  "pyproj==3.7.2",
  "pyshp==2.3.1",
  "python-dateutil==2.9.0.post0",
  "python-jose>=3.5.0",
  "python-multipart==0.0.32",
  "pytz==2026.3.post1",
  "requests==2.34.2",
  "rsa==4.9.1",
  "scramp==1.4.17",
  "sentry-sdk[fastapi]==2.68.0",
  "shapely==2.1.2",
  "six==1.17.0",
  "sniffio==1.3.1",
  "sqlalchemy==2.0.52",
  "sqlalchemy-continuum==1.7.0",
  "sqlalchemy-searchable==2.1.0",
  "sqlalchemy-utils==0.42.1",
  "sqlparse>=0.6.0",
  "starlette==1.6.0",
  "typer==0.27.1",
  "typing-extensions==4.16.0",
  "typing-inspection==0.4.4",
  "tzdata==2026.3",
  "urllib3==2.7.0",
  "utm==0.9.0",
  "uvicorn==0.52.3",
  "yarl==1.24.5",
  "pymssql>=2.3.13",
]

[tool.uv]
package = true

[tool.setuptools]
packages = [
  "alembic",
  "automated_ingestion",
  "automated_ingestion.defs",
  "automated_ingestion.defs.assets",
  "automated_ingestion.defs.jobs",
  "automated_ingestion.ocotillo",
  "automated_ingestion.shared",
  "automated_ingestion.sources",
  "automated_ingestion.sources.san_acacia",
  "cli",
  "core",
  "data_migrations",
  "db",
  "domain",
  "schemas",
  "services",
  "transfers",
]

# Entry point for the `ocotillo-automated-ingestion` Dagster+ code location.
# `dagster dev` and the Dagster+ agent both read this.
[tool.dagster]
module_name = "automated_ingestion.defs.definitions"

# Required by the `dg` CLI, which refuses to run outside a directory it
# recognises as a project. `dagster_cloud.yaml` names the entry point
# explicitly, so this does not affect what the deployed code location loads --
# it only lets `dg plus` manage environment variables from this checkout.
[tool.dg]
directory_type = "project"

[tool.dg.project]
root_module = "automated_ingestion"


# Bare `--cov` measures every imported module, which pulls the whole virtualenv
# into the report. Scope it to first-party code instead. Keep this a single
# source root -- listing each package separately makes coverage treat every
# entry as its own root, so `api/wells.py` is reported as `wells.py` and
# collides with same-named modules in db/, schemas/, and services/.
[tool.coverage.run]
source = ["."]
relative_files = true
omit = [
  ".venv/*",
  "alembic/*",
  "automated_ingestion/tests/*",
  "docker/*",
  "features/*",
  "geoserver_iac/*",
  "scripts/*",
  "tests/*",
  # Legacy AMPAPI migration scripts. Run by hand against SQL Server, not
  # exercised by the suite, and large enough to dominate the total.
  "transfers/*",
]

[tool.coverage.report]
show_missing = true

[project.scripts]
oco = "cli.cli:cli"

[tool.alembic]

# path to migration scripts.
# this is typically a path given in POSIX (e.g. forward slashes)
# format, relative to the token %(here)s which refers to the location of this
# ini file
script_location = "%(here)s/alembic"

# template used to generate migration file names; The default value is %%(rev)s_%%(slug)s
# Uncomment the line below if you want the files to be prepended with date and time
# see https://alembic.sqlalchemy.org/en/latest/tutorial.html#editing-the-ini-file
# for all available tokens
# file_template = "%%(year)d_%%(month).2d_%%(day).2d_%%(hour).2d%%(minute).2d-%%(rev)s_%%(slug)s"

# additional paths to be prepended to sys.path. defaults to the current working directory.
prepend_sys_path = ["."]

[dependency-groups]
dev = [
  "behave>=1.3.3",
  "black>=26.5.1",
  "faker>=25.0.0",
  "flake8>=7.3.0",
  "pre-commit>=4.6.2",
  "pyhamcrest>=2.0.3",
  "pytest>=9.1.1",
  "pytest-cov>=6.2.1",
  "python-dotenv>=1.1.1",
  "requests>=2.34.2",
]
# CLI-only dependencies (chemistry ingestion / Google Drive sync). These are
# imported lazily by `oco` commands and are not needed by the API runtime, so
# they are excluded from the production requirements export (`uv export
# --no-dev`). CI installs them explicitly with `uv sync --group cli`.
cli = [
  "openpyxl==3.1.5",
  "google-api-python-client==2.198.0",
]
# Dagster+ code location dependencies. The API runtime never imports
# `automated_ingestion`, so keeping these out of `dependencies` stops dagster
# and its transitive tree from shipping in the API image. CI and the Dagster+
# build install them explicitly with `uv sync --group ingestion`.
ingestion = [
  "dagster>=1.13.18",
  "dagster-cloud>=1.13.18",
  "dlt[filesystem,gs]>=1.30.0",
  "gcsfs>=2026.8.0",
  "pyarrow>=25.0.1",
]

# timezone to use when rendering the date within the migration file
# as well as the filename.
# If specified, requires the python>=3.9 or backports.zoneinfo library and tzdata library.
# Any required deps can installed by adding `alembic[tz]` to the pip requirements
# string value is passed to ZoneInfo()
# leave blank for localtime
# timezone =

# max length of characters to apply to the "slug" field
# truncate_slug_length = 40

# set to 'true' to run the environment during
# the 'revision' command, regardless of autogenerate
# revision_environment = false

# set to 'true' to allow .pyc and .pyo files without
# a source .py file to be detected as revisions in the
# versions/ directory
# sourceless = false

# version location specification; This defaults
# to <script_location>/versions.  When using multiple version
# directories, initial revisions must be specified with --version-path.
# version_locations = [
#    "%(here)s/alembic/versions",
#    "%(here)s/foo/bar"
# ]


# set to 'true' to search source files recursively
# in each "version_locations" directory
# new in Alembic version 1.10
# recursive_version_locations = false

# the output encoding used when revision files
# are written from script.py.mako
# output_encoding = "utf-8"

# This section defines scripts or Python functions that are run
# on newly generated revision scripts.  See the documentation for further
# detail and examples
# [[tool.alembic.post_write_hooks]]
# format using "black" - use the console_scripts runner,
# against the "black" entrypoint
# name = "black"
# type = "console_scripts"
# entrypoint = "black"
# options = "-l 79 REVISION_SCRIPT_FILENAME"
#
# [[tool.alembic.post_write_hooks]]
# lint with attempts to fix using "ruff" - use the exec runner,
# execute a binary
# name = "ruff"
# type = "exec"
# executable = "%(here)s/.venv/bin/ruff"
# options = "check --fix REVISION_SCRIPT_FILENAME"