AndreFerreira5/starranja
1
0
Fork 0
Code Issues 3 Pull requests Projects Releases Packages Wiki Activity Actions

[Invoices] - Create Database Interface File and Structure #116

New issue
Closed
opened 2025-11-05 20:33:58 +00:00 by duarteneves5 · 0 comments
duarteneves5 commented 2025-11-05 20:33:58 +00:00 (Migrated from github.com)
Copy link

Create the file that will hold all database interactions for the invoices collection. This isolates our database logic from the API endpoints.

Tasks:

  • Create a new file (e.g., repositories/invoice_repo.py or services/invoice_service.py).
  • Define the class (e.g., InvoiceRepository).
  • Add placeholder/empty async methods for CRUD operations:
    • create_invoice(invoice_data: InvoiceCreate) -> Invoice
    • get_invoice_by_id(invoice_id: ObjectId) -> Invoice | None
    • get_invoices_by_client_id(client_id: ObjectId) -> list[Invoice]
    • get_invoices_by_workOrder_id(workOrder_id: ObjectId) -> list[Invoice]
    • update_invoice(invoice_id: ObjectId, update_data: InvoiceUpdate) -> Invoice | None
    • delete_invoice(invoice_id: ObjectId) -> bool
Create the file that will hold all database interactions for the `invoices` collection. This isolates our database logic from the API endpoints. **Tasks:** - [ ] Create a new file (e.g., `repositories/invoice_repo.py` or `services/invoice_service.py`). - [ ] Define the class (e.g., `InvoiceRepository`). - [ ] Add placeholder/empty `async` methods for CRUD operations: - `create_invoice(invoice_data: InvoiceCreate) -> Invoice` - `get_invoice_by_id(invoice_id: ObjectId) -> Invoice | None` - `get_invoices_by_client_id(client_id: ObjectId) -> list[Invoice]` - `get_invoices_by_workOrder_id(workOrder_id: ObjectId) -> list[Invoice]` - `update_invoice(invoice_id: ObjectId, update_data: InvoiceUpdate) -> Invoice | None` - `delete_invoice(invoice_id: ObjectId) -> bool`
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
routes-invoices
No results found.
Labels
Clear labels   
CI/CD

   
MongoDB

   
PostgreSQL

   
api

   
authentication

   
bug

Something isn't working

  
documentation

Improvements or additions to documentation

  
duplicate

This issue or pull request already exists

  
enhancement

New feature or request

  
example issue

issue that aims to show how to create issues

  
fix

   
good first issue

Good for newcomers

  
help wanted

Extra attention is needed

  
high-level requirement

   
infrastructure

   
invalid

This doesn't seem right

  
low-level requirement

   
medium-level requirement

   
question

Further information is requested

  
security

   
test

   
wontfix

This will not be worked on

No labels
CI/CD
MongoDB
PostgreSQL
api
authentication
bug
documentation
duplicate
enhancement
example issue
fix
good first issue
help wanted
high-level requirement
infrastructure
invalid
low-level requirement
medium-level requirement
question
security
test
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
AndreFerreira5/starranja#116
No description provided.