Skip to content

Add SQLite CRUD operations with optimizations #31

@anitnilay20

Description

@anitnilay20

Description

Implement INSERT, UPDATE, DELETE operations for SQLite with SQLite-specific optimizations.

Requirements

  • INSERT OR REPLACE/IGNORE support
  • Batch insert optimizations
  • UPSERT operations
  • SQLite constraint handling
  • Row ID handling
  • Write comprehensive tests

Acceptance Criteria

  • Full CRUD support for SQLite
  • SQLite-specific optimizations
  • Proper handling of ROWID
  • Batch operation support

Files to modify

  • beatrix_core/src/relational/insert.rs
  • beatrix_core/src/relational/update.rs
  • beatrix_core/src/relational/delete.rs

Example Usage

// SQLite UPSERT
User::insert()
    .values(user)
    .on_conflict_replace()
    .execute(&db).await?;

// Batch insert with transaction
User::insert()
    .values_batch(users)
    .execute(&db).await?;

Metadata

Metadata

Assignees

No one assigned

    Labels

    high-priorityHigh priority itemquery-builderQuery building functionalitysqliteSQLite database support

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions