2.1.0 • Published 5 years ago
fb_queryexcel v2.1.0
#FB_QUERYEXCEL
Fast, optimal package to query data from firebase into a csv format for download using node.
var fbqueryexcel = require('fb_queryexcel');
var firebase = require('firebase');
const express = require('express');
const app = new express();
var config = {
"databaseURL": "https://yourdatabaseurl.firebaseio.com/",
};
firebase.initializeApp(config);
var ref = firebase.database().ref("urlstring");
app.get('/', function (req, res) {
fbqueryexcel.convert(ref,attrib,seaparam,res);
})
Installation
This is a Node.js module available through the npm registry.
Before installing, download and install Node.js. Node.js 0.10 or higher is required.
Installation is done using the
npm install
command:
$ npm install fb_queryexcel
Features
- Query data from Firebase Database
- Data sent as a download attachment in CSV format(excel)
- Validates search,query parameters
Function Parameters
convert(ref, attrib, seaparam, response)
ref => Firebase Database Reference
attrib =>
- '*' => all attributes
- '-',att1,att2,... => all attributes except att1,att2 and so on
- att1,att2,... => attributes att1,att2 and so on are selected
seaparam =>
- [attrib,operator,limit1,limit2]
- attrib is the name of the attribute for which condition is specified
- operator can be >,<,>=,<=,==,!=
- limit1 is the object to be compared with
- if operator is <>, then limit1> obj >limit2
response =>
- response object generated by express framework
##Examples
//example to get complete data as a csv(excel) file
app.get('/', function (req, res) {
attrib = '*'
seaparam = []
fbqueryexcel.convert(ref,attrib,seaparam,res);
})
//example to query data with few attributes removed and a constraint on one parameter(let's say num)
app.get('/', function(req, res)
{
attrib = ['-','phonenum','email']//we dont want phonenum and email attributes
seaparam = [['rank','<>',2,10]]
fbqueryexcel.convert(ref,attrib,seaparam,res);
//returns objects with rank between 2 and 10 with phonenum and email attributes removed
})
//example to query few attributes and constraints on 3 parameters
app.get('/', function(req, res)
{
attrib = ['name','rollno','rank','college']
seaparam = [['rank','>=',5], ['college','==','ABC'], ['name','!=','xyz']]
fbqueryexcel.convert(ref,attrib,seaparam,res);
})