Skip to content

Add SQLite JSON support and functions #34

@anitnilay20

Description

@anitnilay20

Description

Implement SQLite JSON1 extension support with JSON functions and operations.

Requirements

  • JSON1 extension integration
  • JSON path expressions
  • JSON modification functions
  • JSON aggregation functions
  • Type-safe JSON operations
  • Write comprehensive tests

Acceptance Criteria

  • Complete JSON1 extension support
  • JSON path query capabilities
  • JSON modification operations
  • Type-safe JSON handling

Files to create

  • beatrix_core/src/relational/json/sqlite.rs

Example Usage

#[derive(RelationalModel)]
struct User {
    id: i32,
    metadata: Json<UserMetadata>,
}

let users = User::select()
    .where_clause(json_extract(User::metadata(), "$.role").eq("admin"))
    .fetch_all(&db).await?;

Metadata

Metadata

Assignees

No one assigned

    Labels

    coreCore ORM functionalitysqliteSQLite database support

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions