Query builder library for typescript

Type validations

2024-02-13_08-46-12.mp4

Usage

import {Olmos} from "olmos"
import {connection} from "db.ts"

interface PersonaSchema {
    nombre: string,
    cedula: string,
    cod_cargo: number
}

interface CargoSchema {
    cod_cargo: number,
    id_depto: string
    nombre: string
}

const personaModel = Olmos.new<PersonaSchema, "Personas">("Personas", connection);

const cargo = Olmos.new<CargoSchema, "Cargos">("Cargos", sql);

const res = await Persona.model.getOne({}, ["nombre", "cedula"]);
//res.nombre
//res.cedula

const personasCargo = Persona.model.innerJoin(cargo, {
    "Personas.cod_cargo": "Cargos.cod_cargo",
});
const res1 = personasCargo.getOne({"Personas.cedula": 123});

Motivation