Skip to content

Create items database materialized view #91

@rak3rman

Description

@rak3rman

Description

Create a new materialized database view for items using Drizzle. This new view does NOT have to include any new attributes quite yet, it should return the items schema exactly. https://orm.drizzle.team/docs/views

  • Create items_extended materialized database view in src/schema.ts
  • Refresh materialized view in item and outfit POST, PUT, and DELETE requests
  • Research if it makes sense to add additional materialized attributes with Postgres

Acceptance Criteria

Generated by Zenhub AI

  • Scenario: Create items_extended materialized database view
  • Given the items_extended materialized database view is created in src/schema.ts
  • When the item and outfit POST, PUT, and DELETE requests are executed
  • Then the items materialized view should be refreshed and used in the requests (if applicable, likely not)
  • When item and outfit GET (read ops) requests are executed
  • Then the items materialized view should be queried against and returned

Metadata

Metadata

Assignees

No one assigned

    Labels

    backendRelated to the hono backendhelp wantedExtra attention is needed

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions