supports PostgreSQL, MySQL, Total.js TextDB and part of MongoDB
Initialization
installation $ npm install dbms
install MySQL: $ npm install mysql2
install PostgreSQL: $ npm install pg
install MongoDB: $ npm install mongodb
constdbms=require('dbms');dbms.init([alias],connection_string);// @alias {String} Optional, alias for connection string (default: 'default')// @connection_string {String} A connection string to DB// PostgreSQLdbms.init('postgresql://user:pass@localhost:5432/dbname');dbms.init('mypg','postgresql://user:pass@localhost:5432/dbname');// with a name for more DB engines// MySQL & Maria DBdbms.init('mysql://user:pass@localhost:3306/dbname');dbms.init('mysql','mysql://user:pass@localhost:3306/dbname');// with a name for more DB engines// Total.js NoSQL embeddeddbms.init('nosql');dbms.init('mynosql','nosql');// with a name for more DB engines// Total.js Tabledbms.init('table');dbms.init('mytable','nosql');// with a name for more DB engines
Usage
// Is a global methodvardb=DBMS();// Finds records// A response: Array// returns QueryBuilderdb.find('collection_table_name');db.find('mypg/collection_table_name');db.find('mynosql/collection_table_name');db.find('mytable/collection_table_name');// Finds the one record// A response: Object// returns QueryBuilderdb.one('collection_table_name');db.one('mypg/collection_table_name');db.one('mynosql/collection_table_name');db.one('mytable/collection_table_name');// Inserts a new record// A response: Number// returns QueryBuilderdb.insert('collection_table_name',document,[unique]);db.insert('mypg/collection_table_name',document,[unique]);db.insert('mynosql/collection_table_name',document,[unique]);db.insert('mytable/collection_table_name',document,[unique]);