Skip to content

[FEAT-API]: Create Hydrograph Manipulation table and handlers for basic input #603

@martyheynbah

Description

@martyheynbah

Create the Hydrograph Manipulation table and add foreign keys to existing tables. Below are possible columns, constraints. and relationships, please confirm all with @trietmnj:

  • hydrograph manipulation columns
    • file_type: enum ('water_level', 'wave')
    • filename: string
    • name: string not null
    • description: string
    • start_date: date
    • end_date: date
    • tides: float
    • depth_limiations: float
    • alpha: float
    • beta: float
    • reach: foreign _key
    • savepoint: foreign_key
  • each savepoint will need 2 h5 attached. 1 water level h5 file and 1 waves h5 file
  • @trietmnj what output data from the hydrograph run will we need to store. Based off this we can think about if this is stored in this table or a separate table

Create handlers to:

  • GET list all hydrographs
  • POST create hydrographs
  • PUT update hydrographs
  • DELETE remove hydrographs

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions