Package Exports

redbean-sql

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (redbean-sql) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

RedBeanNode

(Early Development)

RedBeanNode is an easy to use ORM tool for Node.js, strongly inspired by RedBeanPHP.

!!!WARNING!!! redbean-sql is last (0.0.20) version of redbean-node with bug fixes

Original: https://www.npmjs.com/package/redbean-node

Automatically creates tables and columns as you go
No configuration, just fire and forget
Ported RedBeanPHP's main features and api design
Build on top of knex.js
Supports JavaScript & TypeScript
async/await or promise friendly

Supported Databases

MySQL / MariaDB
SQLite

Installation

npm install redbean-sql

Code Example

This is how you do CRUD in RedBeanNode:

const { R } = require("redbean-sql");

// Setup connection
R.setup();

(async () => {
  let post = R.dispense("post");
  post.text = "Hello World";

  // create or update
  let id = await R.store(post);

  // retrieve
  post = await R.load("post", id);

  console.log(post);

  // delete
  await R.trash(post);

  // close connection
  await R.close();
})();

This automatically generates the tables and columns... on-the-fly. It infers relations based on naming conventions.

New

Added getSlots(array)

/**
* @param {Array} array
*/
genSlots(array = []) {
    if (!Array.isArray(array)) return undefined
    var str = array.slice();
    return str.length ? str.fill("?").join() : ''
}

Fixed

Fixed relations

let car = db.R.dispense('car');
    car.brand = 'Brand';
    car.model = 'Model';
    car.year = 'Model';
    car.chat_keyword= 'KWD';
    try {await db.R.store(car);}catch (e) {console.log(e);}

    console.log("Creating usercar model");
    let usercar = db.R.dispense('usercar');
    usercar.added_date = db.R.isoDate();
    usercar.car = car; // Now this store correctly without any errors
    try {await db.R.store(usercar);}catch (e) {console.log(e);}