Skip to content

Readable query Interface for Local and Remote storage providers

License

Notifications You must be signed in to change notification settings

fast-platform/fast-fluent

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

29 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

FLUENT

A JS library that gives a readable query builder. It takes care of the heavy work for you to enjoy quering your services. Fluent works for both Local and Remote Storage/API providers

Installing

To install this package in your project, you can use the following command within your terminal.

npm install --save fast-fluent

Config

Fluent offers a handy configuration method that will get you up and running in seconds.

import {Fluent} from 'fast-fluent';

Fluent.config(
		    {
          REMOTE_CONNECTORS: [{}],
          LOCAL_CONNECTORS: [{}],
          MERGE_CONNECTORS: [{}]
        }
    );

Connectors

All Fluent connectors are independent libraries, so you will need to download them separetly.

Here is an example of a REMOTE connector using fluent-formio

import formio from 'fluent-formio'
{
    name: 'formio',
    baseUrl: 'https://ydrahgggqviwquft.form.io/',
    connector: formio
}

You can use as many connectors as you like. All available connectors are listed bellow.

REMOTE

Remote connectors give you access to API's or Databases, such as MongoDB, Formio

Provider Library
Formio fluent-formio

LOCAL

Local connectors give you access to in Browser/Memory DB's such as LokiJs, IndexedDB, LocalStorage

Provider Library
LockiJS fluent-loki

MERGE

Merge connectors will pull from both Local and Remote storage providers and will merge results to give you access to all your data from one call

Provider Library
Loki-Formio fluent-loki-formio

Your first Model

To start using Fluent your will need to create a Fluent Model. Every Fluent Model is a @stampit, so you can further compose it as you like. If you only defined one connector it will be used as default, so no need to configure your models

const Mymodel = Fluent.model({
  properties: {
    name: 'Mymodel',
  }
})

In case you defined multiple connectors, your model will need to choose where to get its data from

const Mymodel = Fluent.model({
  properties: {
    name: 'Mymodel',
    config: {
      remote: {
        connector: 'formio'
      },
      local: {
        connector: 'loki'
      }
    }
  }
})

Onother way of defining a connector as default when using multiple connectors, is to set it on the Fluent.config

import {Fluent} from 'fast-fluent';
import formio from 'fluent-formio'

Fluent.config(
		    {
          REMOTE_CONNECTORS: [{
              default: true,
              name: 'formio',
              baseUrl: 'https://ydrahgggqviwquft.form.io/',
              connector: formio
          }, {...}, {...}],
        }
    );

Using a Fluent Model

Remote, Local or Merge?

Every Fluent Model can pull/push data from those 3 sources. All Fluent methods are ASYNC functions be patient and AWAIT for them ;)

const Mymodel = Fluent.model({
  properties: {
    name: 'Mymodel',
  }
})()

// Option 1
let model = await Mymodel.remote()
// Option 2
let model = await Mymodel.local()
// Option 3
let model = await Mymodel.merge()

After deciding where to pull/push the data from you will have access to quite a few helpful methods

Basic CRUD methods

Creating

const Mymodel = Fluent.model({
  properties: {
    name: 'Mymodel',
  }
})()
const myObj = { foo : "bar", pin: "pon"}
const myArrayOfObjs = [{ foo : "bar", pin: "pon"}, { foo : "bar", pin: "pon"}]
// Single insert example
let inserted = await Mymodel.remote().insert(myObj)

// Multiple insert example
let inserted = await Mymodel.remote().insert(myArrayOfObjs)

Updating

All Fluent models identify records by de _id identifier. To update a record you MUST give it the _id

const Mymodel = Fluent.model({
  properties: {
    name: 'Mymodel',
  }
})()
// Single insert example
let updated = await Mymodel.remote().update({_id : 'abcdefghjklmnopqrsuvwxyz', myNewData: 'SomeNewData' })

Deleting

To remove a records you must provide its ID

const Mymodel = Fluent.model({
  properties: {
    name: 'Mymodel',
  }
})()
// Single insert example
let updated = await Mymodel.remote().remove('abcdefghjklmnopqrsuvwxyz')

Reading - Query Builder

Here is where we start having fun with Fluent. Fluent offers a powerful QueryBuilder HEAVILY inspired in Laravel (Thanks Taylor Otwell!!)

Get all Objects (rows)

const Users = Fluent.model({
  properties: {
    name: 'Users',
  }
})()
// Single insert example
let users = await Users.remote().get()

Unlike Laravel, Fluent get() Method returns and Array with the requested Objects, ready for you to use.

 users.forEach(user => console.log(user.name))

Get a single Object (row)

const Users = Fluent.model({
  properties: {
    name: 'Users',
  }
})()
// Single insert example
let user = await Users.remote().first()

In this case Fluent will return a single Object

 user.name

Get a list of Column Values

const Users = Fluent.model({
  properties: {
    name: 'Users',
  }
})()
// Single insert example
let names = await Users.remote().pluck('name')

Select

const Users = Fluent.model({
  properties: {
    name: 'Users',
  }
})()
// Single insert example
let users = await Users.remote().select('name', 'last_name as lastName').get()

// Its also possible to pass it as an Array
let users = await Users.remote().select(['name', 'last_name as lastName']).get()

Ordering, Grouping, Limit & Offset

orderBy

const Users = Fluent.model({
  properties: {
    name: 'Users',
  }
})()
// Single insert example
let users = await Users.remote().select('name', 'last_name as lastName').orderBy('lastName', 'asc')get()

skip / take

const Users = Fluent.model({
  properties: {
    name: 'Users',
  }
})()
// Single insert example
let users = await Users.remote().select('name')
            .skip(10)
            .take(10)
            .get()

Is the same as

const Users = Fluent.model({
  properties: {
    name: 'Users',
  }
})()
// Single insert example
let users = await Users.remote().select('name')
            .offset(10)
            .limit(10)
            .get()

Collections

To further operate your data, you can turn your results into Collections (Yes, Thanks again Taylor!) Just make sure to call the collect method instead of the get()

const Users = Fluent.model({
  properties: {
    name: 'Users',
  }
})()
// Single insert example
let users = await Users.remote()
            .limit(10)
            .collect()

You can also turn any array into a Fluent Collection by using the collect method

let users = [{name: 'John', age: 20}, {name: 'Michael', age: 40}]
// Single insert example
let users = Fluent.collect(users)

Now with the collection on hand, you can use the following operators

average

Alias for avg()

users.average('age')

// 30

avg

users.avg('age')

// 30

Chunk

Chunk will just get all results and then separate them in smaller Arrays.

users.chunk(1)

// [[{name: 'John', age: 20}],[{name: 'Michael', age: 40}]]

Collapse

let collection = Fluent.collect(users.chunk(1));
collection.collapse()
// [{name: 'John', age: 20}, {name: 'Michael', age: 40}]

About

Readable query Interface for Local and Remote storage providers

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published