Socket
Socket
Sign inDemoInstall

redentities

Package Overview
Dependencies
164
Maintainers
1
Versions
13
Alerts
File Explorer

Advanced tools

Install Socket

Detect and block malicious and high-risk dependencies

Install

redentities

Simple & fast object-mapper & query builder, MySql, Sqlite AWS RDS mysql based databases supported


Version published
Maintainers
1
Weekly downloads
2

Weekly downloads

Readme

Source

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.

FAQs

Last updated on 03 Mar 2022

Did you know?

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install

Related posts

SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc