Skip to content

count ​

Call Model.count(filter) to count model records matching a filter. The result is Promise<Result<u64, DbError>>; await it before using the Result.

Pass an empty object, Model.count({}), to count every record in the model table.

Example ​

tyrus
import { DbError } from "tyrus:db";
import { User } from "./models/User";

async function countActiveUsers(): Promise<Result<u64, DbError>> {
    const data = await User.count({ active: true }) onfail {
        return Err(data);
    };
    return Ok(data);
}

async function countAllUsers(): Promise<Result<u64, DbError>> {
    const data = await User.count({}) onfail {
        return Err(data);
    };
    return Ok(data);
}