pacificclimate/pycds

Issues

• Individual migration tests define `sesh_with_large_data` but never use it

  #201 opened 8 months ago by rod-glover
  0

• Document table columns better

  #200 opened 8 months ago by rod-glover
  1

• Remove History.lat and History.lon

  #199 opened 8 months ago by jameshiebert
  1

• Add behavioural tests for database functions

  #198 opened 8 months ago by rod-glover
  0

• Add missing per-migration smoke tests?

  #196 opened 8 months ago by rod-glover
  0

• Query for materialized view `collapsed_vars_mv` is likely wrong

  #180 opened 8 months ago by rod-glover
  10

• Adding .devcontainer for local development & codespaces support

  #192 opened 8 months ago by Nospamas
  0

• Add constraints disallowing newlines in all text columns of meta_vars

  #188 opened 9 months ago by rod-glover
  0

• Enforce valid-identifier syntax on `meta_vars.net_var_name`

  #183 opened a year ago by rod-glover
  0

• Problem with test data variables OR with variable_tags

  #189 opened 9 months ago by rod-glover
  0

• Document `variable_tags`

  #187 opened 10 months ago by rod-glover
  0

• Add documentation and possibly utilities for database migration in tests for clients of pycds

  #186 opened 10 months ago by rod-glover
  0

• Function `getstationvariabletable` uses incorrect method to discriminate climatological variables

  #184 opened a year ago by rod-glover
  0

• Drop refresh SPs for old-style manual matviews that have been replaced with native matviews

  #145 opened 2 years ago by rod-glover
  2

• Convert `obs_count_per_month_history_mv` to native matview

  #181 opened a year ago by rod-glover
  0

• Convert `collapsed_vars_mv` to native matview

  #178 opened a year ago by rod-glover
  0

• Convert `station_obs_stats_mv` to native matview

  #176 opened a year ago by rod-glover
  0

• Update query used for crmp.climo_obs_count_mv

  #159 opened a year ago by rod-glover
  2

• Refactor SQLAlchemy and Alembic extensions for improved understandability and maintainability

  #169 opened a year ago by rod-glover
  1

• Rearrange Database maintenance documentation for usability

  #172 opened a year ago by rod-glover
  0

• Convert `climo_obs_count_mv` to native matview

  #165 opened a year ago by rod-glover
  0

• Upgrade to SQLAlchemy 2

  #173 opened a year ago by rod-glover
  0

• Refactor Alembic extensions for readability/maintainability

  #166 opened a year ago by rod-glover
  0

• Add function variable_tags

  #161 opened a year ago by rod-glover
  0

• Don't use `*` version specs for dependencies

  #162 opened a year ago by rod-glover
  1

• Loosen SQLAlchemy-related version requirements

  #160 opened a year ago by rod-glover
  0

• Migrate some "external" manual matviews to pycds-managed native matviews

  #115 opened a year ago by rod-glover
  1

• Add scripts to installation

  #155 opened a year ago by rod-glover
  0

• Add monthly, daily, and hourly views in use by CAM

  #156 opened a year ago by rod-glover
  0

• Transient failures in CI tests

  #149 opened a year ago by rod-glover
  2

• Use Poetry as package dependency manager

  #153 opened a year ago by rod-glover
  0

• Convert to pyproject.toml

  #151 opened 2 years ago by rod-glover
  0

• Fix script manage-views

  #146 opened 2 years ago by rod-glover
  3

• Use keepalives

  #147 opened 2 years ago by rod-glover
  1

• Remove redundancy from tests

  #118 opened 2 years ago by rod-glover
  1

• alembic --autogenerate creates unnecessary foreign key insertions

  #134 opened 2 years ago by rod-glover
  2

• ORM class CrmpNetworkGeoserver has wrong PK

  #136 opened 2 years ago by rod-glover
  0

• ORM declares tables obs_raw_native_flags and obs_raw_pcic_flags with nullable PK cols

  #135 opened 2 years ago by rod-glover
  0

• Replace plpythonu with plpython3u

  #124 opened 2 years ago by jameshiebert
  2

• Update testing to PG 10

  #137 opened 2 years ago by rod-glover
  1

• Should table time_bounds / class TimeBound exist?

  #133 opened 2 years ago by rod-glover
  0

• Release descriptions are confusing

  #122 opened 2 years ago by rod-glover
  0

• Add server default for meta_station.publish in migration to rev 879f0efa125f

  #129 opened 2 years ago by rod-glover
  0

• Must have superuser priv to create extension citext

  #126 opened 2 years ago by rod-glover
  0

• Add a "publish" flag to the station table

  #105 opened 3 years ago by jameshiebert
  0

• Migration: Move StationObservationStats PK constraint to history_id

  #120 opened 3 years ago by rod-glover
  2

• Add sqlalchemy-citext to install dependencies in setup.py

  #116 opened 3 years ago by rod-glover
  1

• StationObservationStats has incorrect primary key

  #113 opened 3 years ago by rod-glover
  1

• Refactor tests

  #110 opened 3 years ago by rod-glover
  3

• Replace `pip` with `pipenv`

  #102 opened 3 years ago by nikola-rados
  0