red
redentities
npm i redentities
red

redentities

Object Mapper for data repositories

by Mantra Framework

2.2.4 (see all)License:ISCTypeScript:Not FoundCategories:Vanilla JavaScript MySQL Query Builder, Vanilla JavaScript SQLite Query Builder
npm i redentities
Readme

Red Entities

RedEntities logo

(Logo attribution)

JavaScript Style Guide License

What it is?

Red Entities is a simple but flexible and fast object-mapper & sql query builder.

This is a subproject of Mantra Framework you can use freely in your own projects.

Red Entities is focused on minimal typing when accesing data and the definition of database models using schemes (simple json objects).

A model is defined in a json object, called schema.

Data access (inserts, selects, removes and updates), are done by selectors for a fast an simple writing of the sentences.

Database engines supported

Tested with:

  • PostgreSQL 8.x
  • Mysql 5.x
  • Mysql 8.x
  • Amazon Aurora
  • AWS RDS databases based on Mysql
  • Sqlite3
  • (future integration of Redis, MariaDB, Sql Server, Sql Azure Tables, DynamoDB, etc.)

Thus, has been fully tested with:

  • Node.js 10.x
  • Node.js 12.x
  • Node.js 13.x
  • Node.js 14.x
  • Node.js 15.x
  • Node.js 16.x
  • Node.js 17.x

Install

$ npm i redentities --save

Test

Change database configuration providers in file located at:

/test/providersconfig.json

Testing will create many databases and tables.

Then, just run (mocha required):

$ npm run testmysql
$ npm run testsqlite
$ npm run testpostgresql

Basic sample

As a basic introduction, consider this self-explained schema:

const sampleSchema = {
    entities: [
        {
            name : "users",
            fields: [
                { name : "mail", type : "string" },
                { name : "password", type : "string" },
                { name : "created", type : "datetime"}
            ],
            indexes: [ ["mail"], ["created"] ]
        }
    ]
}

Load this schema in an Red Entities object with:

const RedEntities = require("redentities")({
    provider: "mysql",
    host: "localhost",
    user: "myuser",
    password: "mypassword"
});

Create the schema in database with:

await RedEntities.Entities(sampleSchema).CreateSchema();

From now on, you can use Red Entities powers with fast sentences like this:

const db = await RedEntities.Entities(sampleSchema);

const newUserId = await db.users.I().V( { 
    mail: "re@redentities.com",
    password: "12345" ).R();

Retrieve an entity with simple sentences like:

const userEntity = await db.users.S().SingleById(userId);

Documentation

Demos

You can find some demos at /demos folders.

To run them, just

node /demos/<demo name.js>

01-inserts-sample : Insert and retrieve basic values 02-insert-and-iterate : Insert a bulk of values and iterates over them 03-insert-and-deleteall : Insert a bulk of values and removed them 04-json-type : Insert a bulk of json objects and retrieve them

Credits

RedEntities has been fully written by Rafael Gómez Blanes

Professional site at Rafablanes.com

Have a look to my books at Rafa G. Blanes books

License

Licensed under MIT terms.

Copyright (c) 2019-2021:

Contact an support

You can contact us by GitHub, accesing Mantra web site or at support@mantrajs.com.

Downloads/wk

35

GitHub Stars

0

LAST COMMIT

1mo ago

MAINTAINERS

1

CONTRIBUTORS

2

OPEN ISSUES

0

OPEN PRs

0
VersionTagPublished
2.2.4
latest
3mos ago
No tutorials found
Add a tutorial