firebase-query-gator

Fire Query Gator

This module provides simple API for querying Firebase Realtime Database.

Table of contents

• General info
• Performance Notice
• Features
• Module Documentation
  • Initialization
  • Output Specification
  • Single column where query with pagination
  • Single column orderby query with pagination
  • Multi column query
• Contact

General info

This is a user and developer friendly facade for Firebase Realtime Database standard queries. It does as much as possible to utilize built in firebase queries mechanisms, however due to their limitations some heuristics are used in order to provide simple API for developer.

Performance Notice

⚠️ Queries Response Time: Althought as much as possible processing is delegated to the firebase backend some operations will require full read of the database. Please also remember that You should add indexes on columns that you plan to use in your queries.

Features

• Single column where query with sorting and pagination
• Multi column where query with sorting and pagination (order by is on different column than where)

Module Documentation

Initialization

const q = require('firebase-query-gator');
// tell on which database queries should perform
var db = admin.database();
q.init(db);
// from now on one can issue queries
// ...

Output Specification

Object {d: data, m: metadata} is returned for each of the execute() calls. Please see below for detailed specification of each field

Kind	Parameter	Type	Description
Output	d	array	Result records array
Output	d[i].v	object	Actual data object returned as i-th record
Output	d[i].k	object	Actual database key returned for i-th record
Output	m.s	integer	Size of result records array
Output	m.n	string	Next page starting element (to be used with start() function )

Single column where query with pagination

Performs query using the same column/property for filering

var reference = 'course/students'; // from where we make the search
var column = 'nationality';
 
// create query
var query = q.query(reference); 
// narrow only to certain nationality
query = query.where(column, 'Cuban');
 
// get 10 elements starting from START_ELEMENT
query = query.limit(10).start(START_ELEMNT);
 
query.execute().then(result=>{
    // when resolves then operation was success
    // see operations documentation for details    
    var records = result.d;
    var ithRecord = records[i];
    var ithValue = ithRecord.v;
    var ithVKey = ithRecord.k;
 
    var dataLength = result.m.s;
});

Single column orderby query with pagination

Performs query using the same column/property for sorting

var reference = 'course/students'; // from where we make the search
var column = 'nationality';
 
// create query
var query = q.query(reference); 
// order by nationality
query = query.orderBy(column,query.DIRECTION.DESC);            
// get 10 elements starting from START_ELEMENT
query = query.limit(10).start(START_ELEMNT);
 
query.execute().then(result=>{
    // when resolves then operation was success
    // see operations documentation for details    
    var data = result.d;
    var dataLength = result.m.s;
});

Multi column query

Performs query using the different columns/properties for sorting and filering

var reference = 'course/students'; // from where we make the search
 
// create query
var query = q.query(reference); 
var columnSort = 'age';
var columnWhere = 'city';
// sort students by age
query = query.orderBy(columnSort,query.DIRECTION.ASC);
 
// get only students from Warsaw
query = query.where(columnWhere, 'Warsaw');
 
// get 10 elements
query = query.limit(10).start(START_ELEMNT);
 
query.execute().then(result=>{
    // when resolves then operation was success
    // see operations documentation for details    
    var data = result.d;
    var dataLength = result.m.s;
});

Contact

Created by maciej.grula@xcft