348fa416e8
Major Changes: - Set up SQLx database connection and migration system - Create complete initial database schema with all tables - Rename 'auction' to 'listing' throughout codebase for better terminology - Update bot commands: /newauction -> /newlisting, /myauctions -> /mylistings - Update all database tables: auctions -> listings, auction_medias -> listing_medias - Update foreign key relationships and indexes - Add automatic database migration on startup - Update documentation and README - Complete backlog tasks: task-001, task-002, task-010 The bot now has a solid database foundation ready for implementing core business logic. All tests pass and code compiles successfully.
1.2 KiB
1.2 KiB
id, title, status, assignee, created_date, updated_date, labels, dependencies
| id | title | status | assignee | created_date | updated_date | labels | dependencies |
|---|---|---|---|---|---|---|---|
| task-005 | Implement listing database operations | To Do | 2025-08-27 18:31 | 2025-08-27 19:21 |
Description
Create database operations for listing management including creation, retrieval, updates, and media handling. Support all four listing types: standard, multi-slot, fixed-price, and blind listings.
Acceptance Criteria
- #1 Auction creation function supports all four auction types
- #2 Auction retrieval by ID and by seller functions are implemented
- #3 Auction update functions (status, end time, etc.) are implemented
- #4 Active auctions listing with pagination is implemented
- #5 Auction media attachment functions are implemented
- #6 Auction search and filtering functionality is implemented
- #7 Listing creation function supports all four listing types
- #8 Listing retrieval by ID and by seller functions are implemented
- #9 Listing update functions (status, end time, etc.) are implemented
- #10 Active listings listing with pagination is implemented
- #11 Listing media attachment functions are implemented
- #12 Listing search and filtering functionality is implemented