coulomb/markitect-main
2
0
Fork 0
Code Issues 60 Pull Requests Actions 1 Projects 12 Releases 1 Wiki Activity

Database Query CLI Interface #14

New Issue
Closed
opened 2025-09-24 21:30:57 +00:00 by tegwick · 0 comments
tegwick commented 2025-09-24 21:30:57 +00:00
Owner
Copy Link

UseCase: The user can query the SQLite database directly through CLI for metadata operations and analysis.

Commands to implement:

  • markitect query <sql> - Execute SQL query against database
  • markitect schema - Show database schema and table structure
  • markitect metadata <file> - Display file metadata and front matter

Technical Requirements:

  • Provide safe SQL query interface with read-only access
  • Support multiple output formats (table, JSON, YAML)
  • Include common query templates and examples
  • Integrate with existing DatabaseManager functionality

Acceptance Criteria:

  • SQL query interface with safety constraints
  • Schema inspection commands
  • Metadata display functionality
  • Multiple output format support
  • Query templates and examples
  • Comprehensive test coverage

Core USP: "Relational Document Metadata" - Make database queryable
Dependencies: Issue #12 (CLI Entry Point)
Priority: High

UseCase: The user can query the SQLite database directly through CLI for metadata operations and analysis. Commands to implement: - `markitect query <sql>` - Execute SQL query against database - `markitect schema` - Show database schema and table structure - `markitect metadata <file>` - Display file metadata and front matter Technical Requirements: - Provide safe SQL query interface with read-only access - Support multiple output formats (table, JSON, YAML) - Include common query templates and examples - Integrate with existing DatabaseManager functionality Acceptance Criteria: - [ ] SQL query interface with safety constraints - [ ] Schema inspection commands - [ ] Metadata display functionality - [ ] Multiple output format support - [ ] Query templates and examples - [ ] Comprehensive test coverage Core USP: "Relational Document Metadata" - Make database queryable Dependencies: Issue #12 (CLI Entry Point) Priority: High
tegwick added this to the CLI Implementation milestone 2025-09-24 21:47:12 +00:00
tegwick added this to the Getting started project 2025-09-24 22:00:19 +00:00
tegwick moved this to Todo in Getting started on 2025-09-24 22:02:58 +00:00
tegwick moved this to Active in Getting started on 2025-09-24 22:04:41 +00:00
tegwick moved this to Todo in Getting started on 2025-09-24 22:05:11 +00:00
tegwick moved this to Active in Getting started on 2025-09-25 01:15:58 +00:00
tegwick moved this to Review in Getting started on 2025-09-25 01:33:09 +00:00
tegwick added the status:done label 2025-09-25 11:35:10 +00:00
tegwick moved this to Done in Getting started on 2025-09-25 11:37:01 +00:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
priority:critical
Critical priority issue
 priority:high
High priority issue
 priority:low
Low priority issue
 priority:medium
Medium priority issue
 status:active
Issues currently being worked on
 status:blocked
Issues blocked by dependencies
 status:done
Completed issues
 status:review
Issues under review
 status:todo
Issues ready to be worked on
 type:bug
Bug report
 type:documentation
Documentation update
 type:enhancement
Enhancement to existing feature
 type:feature
New feature request
 wish
Feature wishlist item - idea to be discussed and refined
 wish/archived
Archived or rejected wishlist item
 wish/discussion
Wishlist item currently being discussed and refined
 wish/draft
Wishlist item with initial draft specification
 wish/ready
Wishlist item ready to become a regular issue
No Label status:done
Milestone
No items
No Milestone CLI Implementation
Projects
Clear projects
No project Getting started
Assignees
Clear assignees
bubble-reader tegwick
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: coulomb/markitect-main#14
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?