npm package discovery and stats viewer.

Discover Tips

  • General search

    [free text search, go nuts!]

  • Package details

    pkg:[package-name]

  • User packages

    @[username]

Sponsor

Optimize Toolset

I’ve always been into building performant and accessible sites, but lately I’ve been taking it extremely seriously. So much so that I’ve been building a tool to help me optimize and monitor the sites that I build to make sure that I’m making an attempt to offer the best experience to those who visit them. If you’re into performant, accessible and SEO friendly sites, you might like it too! You can check it out at Optimize Toolset.

About

Hi, 👋, I’m Ryan Hefner  and I built this site for me, and you! The goal of this site was to provide an easy way for me to check the stats on my npm packages, both for prioritizing issues and updates, and to give me a little kick in the pants to keep up on stuff.

As I was building it, I realized that I was actually using the tool to build the tool, and figured I might as well put this out there and hopefully others will find it to be a fast and useful way to search and browse npm packages as I have.

If you’re interested in other things I’m working on, follow me on Twitter or check out the open source projects I’ve been publishing on GitHub.

I am also working on a Twitter bot for this site to tweet the most popular, newest, random packages from npm. Please follow that account now and it will start sending out packages soon–ish.

Open Software & Tools

This site wouldn’t be possible without the immense generosity and tireless efforts from the people who make contributions to the world and share their work via open source initiatives. Thank you 🙏

© 2024 – Pkg Stats / Ryan Hefner

bs-crud-functors

v7.1.2

Published

ReasonML model and query generator for CRUD actions

Downloads

10

Readme

NPM pipeline status coverage report

bs-crud-functors

ReasonML model and query generator for CRUD actions based upon bs-sql-common and bs-sql-composer.

Why?

This is a SQL wrapper that provides many convenience features and a "light" ORM interface that uses plain SQL as the underlying language. Currently it is only compatible with the [bs-mysql2] client.

How do I install it?

Inside of a BuckleScript project:

yarn add @glennsl/bs-json bs-crud-functors bs-mysql2 bs-node-debug bs-sql-common bs-sql-composer

Then add @glennsl/bs-json, bs-crud-functors, bs-mysql2, bs-node-debug, bs-sql-common and bs-sql-composer to your bs-dependencies in bsconfig.json:

{
  "bs-dependencies": [
    "@glennsl/bs-json",
    "bs-crud-functors",
    "bs-mysql2",
    "bs-node-debug",
    "bs-sql-common",
    "bs-sql-composer"
  ]
}

How do I use it?

General Usage

The way you should access modules in CrudFunctors is as follows:

CrudFunctors.<Module>

Of course you can always directly call the internal files, namespaced with CrudFunctors_, but that is not recommended since these files are implementation details.

Using the Factory Model.

Below are the requirements necessary to use the FactoryModel. Each requirement is documented with examples below. The requirements include: creating the connection, creating the config, and creating the model.

Creating the Connection

module Sql = SqlCommon.Make_sql(MySql2);
module CrudFunctorImpl = CrudFunctor.Make(Sql)

let conn = Sql.connect(
  ~host="127.0.0.1",
  ~port=3306,
  ~user="root",
  ~database="example",
  ()
);

Creating the Config

Creating the Config is quite simple, below is a brief explanation for each field in the Config:

  • t: the record type that will be mapped to
  • table: the name of the database table
  • decoder: a function to map the query response to t
  • base: the base query for the model, try to keep this as thin as possible (i.e. minimal where clauses, etc.)
let table = "animal";

type animal = {
  id: int,
  type_: string,
  deleted: int,
};

module Config = {
  type t = animal;
  let table = table;
  let decoder = json =>
    Json.Decode.{
      id: field("id", int, json),
      type_: field("type_", string, json),
      deleted: field("deleted", int, json),
    };
  let base =
    SqlComposer.Select.(
      select
      |> field({j|$table.`id`|j})
      |> field({j|$table.`type_`|j})
      |> field({j|$table.`deleted`|j})
      |> order_by(`Desc({j|$table.`id`|j}))
    );
};

Creating the Model

Creating the model is quite simple once the Config is setup:

module Model = CrudFunctorImpl.Model.Make(Config);

Usage Examples

Below are a few examples on how to use the model, refer to the documentation below for the full list of functions/methods:

Model.Create.one(
  type_ => Json.Encode.([ ("type_", string @@ type_) ] |. object_),
  "my cat",
  conn
)
|. Future.mapOk(maybeCat =>
  switch(maybeCat) {
  | Some(cat) => Js.log2("Your New Cat: ", cat)
  | None => Js.log("Oh the noes, we lost your cat")
  }
)
|. Future.flatMapError(error => Js.Console.error(error))
|. ignore;

Model.Read.where(
  (base) => base |. SqlComposer.Select.where({j|AND $table.type_ = ?|j}),
  Json.Encode.([| string @@ "cat" |]),
  conn
)
|. Future.mapOk(cats => Js.log2("Your Cats:", cats))
|. Future.flatMapError(error => Js.Console.error(error))
|. ignore;

Creating an ID can be a pain-point, but it's abstracted away to ensure proper handling and formatting.

let id  = 42 |. Json.Encode.int |. string_of_int |. CrudFunctorImpl.Id.fromJson;
Model.Read.one_by_id(id, db)
|. Future.mapOk(maybeCat =>
  switch(maybeCat) {
  | Some(cat) => Js.log2("Your Cat: ", cat)
  | None => Js.log("Oh the noes, we couldn't find your cat")
  }
)
|. Future.flatMapError(error => Js.Console.error(error))
|. ignore;

Note: you will notice that some methods will return Result.Ok(None), this means that the row(s) were altered successfully but when an attempt to fetch the same row(s) was made the operation failed; this is because the Model's base query filters out the row(s) after update.

What's missing?

Everything not checked...

  • [ ] Query Interface
    • [x] (raw) Raw SQL query
    • [ ] (rawInsert) Raw SQL insert
    • [ ] (rawUpdate) Raw SQL update
    • [x] INSERT
      • [x] (insertOne) basic wrapper
      • [x] (insertBatch) basic wrapper
    • [ ] UPDATE
      • [x] (updateOneById) Basic wrapper using the id column - must fit PrimaryId interface
      • [ ] (updateWhereParams) with the ObjectHash interface
      • [x] (incrementOneById) increment an integer column using the id column - must fit the Counter and PrimaryId interfaces
    • [x] DELETE
      • [x] (deleteBy) using a custom where clause
      • [x] (deleteOneById) - must fit the PrimaryId interface
    • [x] Archive
      • [x] (deactivateOneById) Deactivate a row using the id column - must fit the Activated and PrimaryId interfaces
      • [x] (archiveOneById) Soft DELETE a row using the id column - must fit the Archive interface
      • [x] (archiveCompoundBy) Soft Compound DELETE using a custom where clause - must fit the ArchiveCompound interface
      • [x] (archiveCompoundOneById) Soft Compound DELETE a row using the id column - must fit the ArchiveCompound and PrimaryId interfaces
    • [ ] SELECT
      • [ ] Transforms
        • [ ] JSON column parse
        • [ ] Nest dot notation transform
        • [ ] Null out nested objects
      • [x] (get) using the Compositional SQL DSL
      • [x] (getByIdList) using the id column - must fit PrimaryId interface
      • [x] (getOneBy) with custom where clause
      • [x] (getOneById) using the id column - must fit PrimaryId interface
      • [x] (getWhere) using a custom where clause
      • [ ] (getWhereParams) using the ObjectHash interface
  • [ ] Model
    • [x] Compositional SQL DSL
    • [x] Model Creation DSL
    • [x] Query interface
      • [ ] INSERT
        • [x] (insertOne)
        • [x] (insertBatch)
        • [ ] Pre-Create intercept
        • [ ] Post-Create intercept
      • [ ] UPDATE
        • [x] (updateOneById) using the id column - must fit PrimaryId interface
        • [x] (incrementOneById) increment an integer column using the id column - must fit the Counter and PrimaryId interfaces
        • [ ] Pre-Update intercept
        • [ ] Post-Update intercept
      • [x] DELETE
        • [x] (deleteBy) using a custom where clause
        • [x] (deleteOneById) - must fit the PrimaryId interface
      • [x] Archive
        • [x] (deactivateOneById) Deactivate a row using the id column - must fit the Activated and PrimaryId interfaces
        • [x] (archiveOneById) Soft DELETE a row using the id column - must fit the Archive interface
        • [x] (archiveCompoundBy) Soft Compound DELETE using a custom where clause - must fit the ArchiveCompound interface
        • [x] (archiveCompoundOneById) Soft Compound DELETE a row using the id column - must fit the ArchiveCompound and PrimaryId interfaces
      • [ ] SELECT
        • [ ] Transforms - (Dependent upon Query Interface implementation)
        • [x] (get) using the Compositional SQL DSL
        • [x] (getByIdList) using the id column - must fit PrimaryId interface
        • [x] (getOneBy) with custom where clause
        • [x] (getOneById) using the id column - must fit PrimaryId interface
        • [x] (getWhere) using a custom where clause
        • [ ] (getWhereParams) using the ObjectHash interface
  • [ ] Search - This needs some re-design to better fit ReasonML language semantics.
  • [ ] Utilities
    • [ ] TIMESTAMP conversion
    • [ ] ObjectHash interface interpolation
    • [ ] Caching