Data store

This module adds transactionalized data persistence to your application as part of your routes, backed up by different database systems.

In Primate, the term store represents tables in classic RDBMS (such as PostgreSQL) or collections in NoSQL databases (such as MongoDB). Stores are described by a schema. A single row or entity in a database is a record, and a single property of such a record is a field. The underlying database system of a given store is referred to as driver.

`store` # aggregation of similar entities
├─ described by `schema` # entity structure
├─ contains `record` # single entity
│  └─ has `field` # single property
└─ backed up by `driver` # underlying database system

Quick start

Install

npm install @primate/store

Load

Import and initialize the module in your configuration.

import store from "@primate/store";

export default {
  modules: [
    store(),
  ],
};

By default the module uses an in-memory driver which keeps the data only as long as the application runs. Alternatively you can use the JSON file driver which persists onto a file.

import store from "@primate/store";
import json from "@primate/store/json";

export default {
  modules: [
    store({
      driver: json({
        database: "/tmp/db.json",
      }),
    }),
  ],
};

Use

Create the different stores for your application and their fields in the stores directory. A field consists of a name and a type, denoting the range of values this field may hold. We here define a User store representing a user of our application.

import primary from "@primate/schema/primary";
import email from "@primate/schema/email";
import date from "@primate/schema/date";
import string from "@primate/schema/string";
import u8 from "@primate/schema/u8";

export default {
  id: primary,
  name: string,
  age: u8,
  email,
  created: date,
};

Adding that store definition to stores makes the User store available to every route.

export default {
  get(request) {
    const { User } = request.store;
    return User.find();
  },
};

Assuming we have data in the user store, requesting the route /user/all will return a JSON array of users.

Defining stores

Unless you configure this module elsewise, all store definitions are loaded from the stores directory. Store files must start with a capital letter; any other JavaScript files will be ignored. You may arbitrarily nest store files using directories, creating namespaces: stores/Comment.js and stores/post/Comment.js describe different stores. Directories must start with a lowercase letter and will be otherwise ignored.

// this store will be available as `request.store.Comment` in routes
import primary from "@primate/schema/primary";
import string from "@primate/schema/string";

export default {
  id: primary,
  text: string,
};

// this store will be available as `request.store.post.Comment` in routes
import primary from "@primate/schema/primary";
import string from "@primate/schema/string";

export default {
  id: primary,
  text: string,
};

Schema

A store's default export is its schema, containing its field names and types. The objects you use for types will be automatically mapped by the driver into the appropriate database types.

import array from "@primate/schema/array";
import primary from "@primate/schema/primary";
import string from "@primate/schema/string";
import u8 from "@primate/schema/u8";

export default {
  id: primary,
  name: string.between(0, 20),
  age: u8.range(0, 120),
  hobbies: array.of(string),
};

Types are not only used for mapping to database fields, but also for validating data before saving it. One of the store actions you can use in routes is validate, which allows you to check that a record is valid before saving it. Normally though, you wouldn't call validate directly but have insert or update call it for you.

import redirect from "primate/handler/redirect";

export default {
  post(request) {
    // prepare a user, normally this data would come from a form
    const user = {
      name: "Donald",
      age: 32,
      hobbies: ["Fishing"],
    };

    // get the User store
    const { User } = request.store;

    // save if valid
    try {
      const { id } = await User.insert(user);
      return redirect(`/user/${id}`);
    } catch (error) {
      // return validation errors as JSON to the client
      return error.errors;
    }
  }
}

In addition to using type functions, Primate supports using an object with a validate function property for validation.

import array from "@primate/schema/array";
import primary from "@primate/schema/primary";
import u8 from "@primate/schema/u8";

const between = ({ length }, min, max) => length >= min && length <= max;

export default {
  id: primary,
  name: {
    validate(value) {
      if (typeof value === "string" && between(value, 2, 20)) {
        return value;
      }
      throw new Error(`${value} must be 2 to 20 characters in length`);
    }
    base: "string",
  },
  age: u8.range(0, 120),
  hobbies: array.of(string),
};

When trying to validate the name field, Primate will run the validate function to determine if the field has passed validation. In case of failure, it would stop the execution of the route function with the given error. For saving this field into the database, it will use the driver's base type "string".

Strict

By default, fields aren't required to be non-empty (undefined or null) to save a new record into the store. If you wish to strictly enforce all fields to be non-empty, export mode = "strict".

import primary from "@primate/schema/primary";
import string from "@primate/schema/string";

export const mode = "strict";

export default {
  id: primary,
  text: string,
};

You can also globally enforce strictness for all stores by configuring this module with mode: "strict".

import store from "@primate/store";

export default {
  modules: [
    store({
      mode: "strict",
    }),
  ],
};

In that case, you can opt-out on individual store level by exporting mode = "loose".

import primary from "@primate/schema/primary";
import string from "@primate/schema/string";

export const mode = "loose";

export default {
  id: primary,
  text: string,
};

Name

The filenames you give to store files affect to which underlying store they are mapped. stores/Comment.js will be mapped to comment, while stores/Post/Comment.js will be mapped to post_comment. You can override this behavior by exporting a name, allowing you to map several store files to the same database store.

import primary from "@primate/schema/primary";
import string from "@primate/schema/string";

// would use `post_comment` if not overriden
export const name = "comment";

export default {
  id: primary,
  text: string,
};

Driver

Unless specified elsewise, stores use the driver specified when loading the module (which defaults to the in-memory driver). A store can override this default by exporting a driver.

import mongodb from "@primate/mongodb";
import primary from "@primate/schema/primary";
import string from "@primate/schema/string";

export const driver = mongodb();

export default {
  id: primary,
  text: string,
};

If you need to share the same alternative driver across several stores, we recommend initializing it in a separate file (lowercase-first files in the stores directory are ignored by Primate).

import mongodb from "@primate/mongodb";

export default mongodb();

You can then import and reexport the driver as needed across files.

import primary from "@primate/schema/primary";
import string from "@primate/schema/string";

export { default as driver } from "./mongodb.js";

export default {
  id: primary,
  title: string,
  text: string
};

import primary from "@primate/schema/primary";
import string from "@primate/schema/string";

export { default as driver } from "./mongodb.js";

export default {
  id: primary,
  text: string,
};

Ambiguous

Many database systems rely on the existence of a primary id field for indexing. This module, too, uses the primary field automatically for a store's get operation. If you create a store without a primary key, Primate will complain.

import string from "@primate/schema/string";

export default {
  text: string,
};

If you run your app with a store thus configured, Primate will show a MissingPrimaryKey warning.

If this ambiguity is intentional, export ambiguous = true in your store.

import string from "@primate/schema/string";

export const ambiguous = true;

export default {
  text: string,
};

Store actions

If the default store actions get, count, find, exists, insert, update, save, delete aren't powerful enough for you, you can access the underlying driver and the store itself to create your own actions. To do so, export actions as an object containing individual, additional actions.

import array from "@primate/schema/array";
import primary from "@primate/schema/primary";
import string from "@primate/schema/string";
import u8 from "@primate/schema/u8";

export const actions = store => {
  return {
    findByHobbies(hobbies) {
      return store.find({ hobbies });
    },
  };
};

export default {
  id: primary,
  name: string.between(0, 20),
  age: u8.range(0, 120),
  hobbies: array.of(string),
};

The first argument of the function that actions returns, client, represents a client of the underlying driver package itself. For example, if you're using the SQLite driver, which uses the better-sqlite3 package, you'd be getting a client that's been initialized using the following code:

import Database from "better-sqlite3";
const client = new Database(filename);

Where filename is the filename property you supplied when initializing the SQLite driver module.

While using the underlying driver directly can be useful in specialized cases, most of the time you would want to stick to the Primate store action primitives. The second argument of the actions function, store, gives you access to all base actions of the Primate store that you can otherwise use in your routes, allowing you to create tailored actions.

Thus defined, the findByHobbies action will be available at request.store.user.findByHobbies, in all routes.

Configuration options

directory

Default "stores"

The directory where stores are located. If specified as a relative path, will be relative to project root.

driver

Default memory (volatile in-memory driver)

The database driver used to persist data. This module also exports json as a non-volatile alternative driver which stores its data in a JSON file. Other supported DMBSs are MongoDB,PostgreSQL, MySQL and SQLite.

mode

Default "loose"

Whether all store fields must be non-empty before saving. In many cases, you want some values to be nullable. Setting this to "strict" forbids any store from saving empty values to the database, unless it has overridden that value by using export const mode = "strict";.

In addition, loose allows you to save to fields that haven't been explicitly declared in your store definition. This is particulary useful for NoSQL databases that do not have a rigid schema, where you want to enforce types on some fields and accept anything in others.

Resources

• Repository
• Error list