Database Package

This package provides database operations for the Shelley AI coding agent using SQLite and sqlc.

Architecture

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)

Testing

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

Code Generation

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