RecordRepository

Repository for managing record data persistence and retrieval operations

Overview

The RecordRepository class handles all database operations for Record entities. It provides methods for creating, reading, updating, and soft-deleting records in the SQLite database.

Location: src/infraestructure/repositories/RecordRepository.ts

Methods

create

Creates a new record in the database.

async create(record: Record): Promise<void>

record · Record · required

The record object to create

return · Promise<void>

Resolves when the record is successfully created

Database Interaction:

INSERT INTO records (
  id, title, subtitle, metadata, type, userId, createdAt, updatedAt, isDeleted
)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

---

findAll

Retrieves all non-deleted records from the database.

async findAll(): Promise<Record[]>

return · Promise<Record[]>

Array of all active (non-deleted) records. The isDeleted field is converted from numeric (0/1) to boolean.

Database Interaction:

SELECT * FROM records WHERE isDeleted = 0

Note: This method automatically filters out soft-deleted records and converts the isDeleted field from integer to boolean.

---

update

Updates an existing record in the database.

async update(record: Record): Promise<void>

record · Record · required

The record object with updated values. The id field is used to identify which record to update.

return · Promise<void>

Resolves when the record is successfully updated

Database Interaction:

UPDATE records SET
  title = ?,
  subtitle = ?,
  metadata = ?,
  type = ?,
  userId = ?,
  updatedAt = ?
WHERE id = ?

Note: The createdAt and isDeleted fields are not updated by this method.

---

softDelete

Marks a record as deleted without removing it from the database.

async softDelete(id: string): Promise<void>

id · string · required

The unique identifier of the record to soft delete

return · Promise<void>

Resolves when the record is successfully marked as deleted

Database Interaction:

UPDATE records SET isDeleted = 1 WHERE id = ?

Note: Soft-deleted records are excluded from findAll() results but remain in the database for potential recovery or audit purposes.

---

Usage Example

import { RecordRepository } from './infraestructure/repositories/RecordRepository';
import { Record } from './domain/entities/Record';

const recordRepo = new RecordRepository();

// Create a new record
const newRecord: Record = {
  id: 'rec_123',
  title: 'My Record',
  subtitle: 'A sample record',
  metadata: JSON.stringify({ key: 'value' }),
  type: 'standard',
  userId: 'user_456',
  createdAt: new Date().toISOString(),
  updatedAt: new Date().toISOString(),
  isDeleted: false
};

await recordRepo.create(newRecord);

// Get all records
const records = await recordRepo.findAll();

// Update a record
newRecord.title = 'Updated Title';
newRecord.updatedAt = new Date().toISOString();
await recordRepo.update(newRecord);

// Soft delete a record
await recordRepo.softDelete('rec_123');

Database Schema

The repository interacts with the records table with the following structure:

Column	Type	Constraints
id	TEXT	PRIMARY KEY
title	TEXT	NOT NULL
subtitle	TEXT	NULLABLE
metadata	TEXT	NULLABLE
type	TEXT	NOT NULL
userId	TEXT	NULLABLE
createdAt	TEXT	NOT NULL
updatedAt	TEXT	NOT NULL
isDeleted	INTEGER	NOT NULL (0 or 1)

Related

• Record Entity
• Database Configuration