[Tracker] Feature Roadmap

[zenlex]

Routes:

• Proposals
• Drafts
• Votes

Services:

• Proposals
• Drafts
• Votes

Database:

• Proposals
• Drafts
• Votes

Tests:

• Proposals
• Drafts
• Votes

Validators:

• Proposals
• Drafts
• Votes

General:

• Containerization
• Deployment CI
• Documentation
• Connect/Test with UI

[zenlex]

I added a services section. To make this easier for multiple hands to work on I propose we abstract the database ops to a service layer so the routes can get built calling the service API without worrying about the underlying DB queries and the services can just be responsible for the queries.

[zenlex]

I'm fine with sql.unsafe`` queries as desired for now. If anyone wants to add query validation, check the slonik docs, but the basics are:

• add zod object for the database type (TypeScript can infer the type from this, so don't make a separate TS type)
• add runtime interceptor (default implementation from slonik docs should be fine) which will automatically validate query results with sql.type([zod type])...

[zenlex]

Proposals needs a tiny bit of updating and then it's ready for QA

• refactor update to use zod partial
• match validators to updated api schema

[zenlex]

just need to wrap up #50 added to the voting service/router and then finish testing/debugging.