Struct DcsTemplateRow 

pub struct DcsTemplateRow {
    pub id: i64,
    pub origin: TemplateOrigin,
    pub template: DcsTemplate,
    pub created_at: DateTime<Utc>,
    pub updated_at: DateTime<Utc>,
}

One row of dcs_templates: a DcsTemplate plus the database bookkeeping fields that don’t belong on the pure domain type itself.

Fields

id: i64

origin: TemplateOrigin

template: DcsTemplate

created_at: DateTime<Utc>

updated_at: DateTime<Utc>

Implementations

impl DcsTemplateRow

pub async fn insert( pool: &SqlitePool, template: &DcsTemplate, origin: TemplateOrigin, now: DateTime<Utc>, ) -> DbResult<DcsTemplateRow>

Inserts template, returning the persisted row (with its assigned id). now is used for both created_at and updated_at; the caller supplies it rather than this function reading the clock, keeping “who reads the clock” consistent with the rest of bhtune’s architecture (see bhtune_core’s crate docs).

pub async fn get(pool: &SqlitePool, id: i64) -> DbResult<Option<DcsTemplateRow>>

Fetches one row by id, or None if it doesn’t exist.

pub async fn get_by_name( pool: &SqlitePool, name: &str, ) -> DbResult<Option<DcsTemplateRow>>

Fetches one row by its (unique) name, or None if it doesn’t exist. Used by crate::seed::seed_templates to find any existing row before deciding whether to insert or update.

pub async fn list(pool: &SqlitePool) -> DbResult<Vec<DcsTemplateRow>>

Lists every row, ordered by name, for the loop-editor’s template picker.

pub async fn update( pool: &SqlitePool, id: i64, template: &DcsTemplate, now: DateTime<Utc>, ) -> DbResult<DcsTemplateRow>

Overwrites every template field of the row at id with template’s, bumping updated_at to now. Deliberately does not touch name (the match key callers already looked the row up by) or origin (ownership of a row never changes after creation) — only Self::insert sets those.

pub async fn delete(pool: &SqlitePool, id: i64) -> DbResult<bool>

Deletes the row at id. Returns Ok(true) if a row existed and was removed, Ok(false) if no row with that id existed (not an error – deciding whether “nothing to delete” should itself be an error is the caller’s call; bhtune-cli’s template delete already resolves id from a name via Self::get_by_name and produces its own “no template named” error before ever calling this).

Fails with DbError::TemplateInUse if loops.dcs_template_id’s ON DELETE RESTRICT foreign key rejects the delete because a saved loop still references this template. Classified as “any database-level error on this specific statement”, rather than solely sqlx’s DatabaseError::is_foreign_key_violation() – confirmed empirically that SQLite’s C implementation reports an immediate RESTRICT violation like this one under the extended result code SQLITE_CONSTRAINT_TRIGGER (its FK-action enforcement runs through the same internal machinery as a trigger body), not SQLITE_CONSTRAINT_FOREIGNKEY – the latter is what sqlx-sqlite maps to is_foreign_key_violation(), and it’s only what a deferred FK check reports at commit time, which this crate never uses. This is safe to broaden to “any database error” specifically because dcs_templates has exactly one foreign key pointing at it (loops.dcs_template_id), no triggers exist anywhere in the schema, and a bare DELETE can’t violate this table’s own CHECK constraints (they all apply to column values, which a delete-by-id never touches) – so a database-level failure of this exact statement structurally has only one possible cause.

Trait Implementations

impl Clone for DcsTemplateRow

fn clone(&self) -> DcsTemplateRow

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for DcsTemplateRow

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl PartialEq for DcsTemplateRow

fn eq(&self, other: &DcsTemplateRow) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl StructuralPartialEq for DcsTemplateRow