This package provides database operations for the Shelley AI coding agent using SQLite and sqlc.
The database contains two main entities:
- Conversations: Represent individual chat sessions with the AI agent
- Messages: Individual messages within conversations (user, agent, or tool messages)
Run tests with:
go test -v ./db/...The tests use in-memory SQLite databases and cover all major operations including:
- CRUD operations for conversations and messages
- Pagination and search functionality
- JSON data marshalling/unmarshalling
- Foreign key constraints
- Transaction handling
This package uses sqlc to generate type-safe Go code from SQL queries.
To regenerate code after modifying SQL:
go run github.com/sqlc-dev/sqlc/cmd/sqlc generate