How can I use multiple databases in Total.js with help of SQL Agent?

Thu Feb 23 2017 13:07:36 GMT+0100 (Central European Standard Time), Peter Širka

How can I use multiple databases in Total.js with help of SQL Agent?

SQL Agent is a simple Node.js module for working with RDBMS and NoSQL databases. It supports PostgreSQL, MySQL, SQL Server and MongoDB.


  • supports mixing of RDMBS with NoSQL

Create a definition file e.g. database.js:

const databases = {};

databases.helpdesk = require('sqlagent/pg').connect('connetion-string-to-postgresql');
databases.eshop = require('sqlagent/mysql').connect('connetion-string-to-mysql');
databases.monitor = require('sqlagent/mongodb').connect('connetion-string-to-mongodb');

F.database = function(name) {
    // returns SQL Agent instance
    return databases[name]();
};

Usage in code:

var helpdesk = DB('helpdesk');
helpdesk.select('tbl_user').take(5);
helpdesk.exec(console.log);

var eshop = DB('eshop');
eshop.select('tbl_user').take(5);
eshop.exec(console.log);

var monitor = DB('monitor');
monitor.select('users').take(5);
monitor.exec(console.log);

Tags

Follow us

Latest blogs
Flow v6 is here!
Thu Mar 07 2019 11:53:54 GMT+0100 (Central European Standard Time)
A critical security fix
Wed Feb 13 2019 22:15:39 GMT+0100 (Central European Standard Time)
New release: Total.js v3.2
Wed Feb 13 2019 22:14:39 GMT+0100 (Central European Standard Time)
Total.js Wiki v2
Fri Jan 04 2019 22:15:01 GMT+0100 (Central European Standard Time)
Total Year 2018
Thu Jan 03 2019 21:14:00 GMT+0100 (Central European Standard Time)

Latest comments
Nice tip
Mauro Junior
Thu Sep 20 2018 21:41:02 GMT+0200 (Central European Summer Time)
Not only for Total.js. You can communicate with different websocket servers.
Peter Širka
Mon Apr 23 2018 20:08:20 GMT+0200 (Central European Summer Time)
Marko: you need to create a buffer with this codepage and write byte-to-byte string. I recommend ...
Peter Širka
Mon Apr 23 2018 20:06:21 GMT+0200 (Central European Summer Time)
Is WEBSOCKETCLIENT only for internal ws connections between totaljs apps?
Stelios Stephanua
Fri Mar 16 2018 06:04:22 GMT+0100 (Central European Standard Time)
Total.js is amazing! ;)
Leonardo Hessel
Tue Dec 19 2017 19:51:15 GMT+0100 (Central European Standard Time)

Pixabay


Read more

Flow v6 is here!

News: We have released a new version of Flow. This version brings great new features and UI improvements.

Thu Mar 07 2019 11:53:54 GMT+0100 (Central European Standard Time)
A critical security fix

News: We were notified about the critical security bug in Total.js framework. Read a prevention.

Wed Feb 13 2019 22:15:39 GMT+0100 (Central European Standard Time)
New release: Total.js v3.2

News: This new release brings a critical security fix and small new improvements. Update Total.js now.

Wed Feb 13 2019 22:14:39 GMT+0100 (Central European Standard Time)
Total.js Wiki v2

Products: I have released a new version of Total.js Wiki. New version brings new improvements.

Fri Jan 04 2019 22:15:01 GMT+0100 (Central European Standard Time)
Total Year 2018

Business: Last year was perfect for Total.js platform. Total.js platform grows up and it has great results.

Thu Jan 03 2019 21:14:00 GMT+0100 (Central European Standard Time)
Total.js Code Editor v1

Products: Try our real-time collaboration tool for Total Developers. Code Editor offers great features for development.

Fri Dec 07 2018 22:55:13 GMT+0100 (Central European Standard Time)