Universal Query
An pure javascript query builder for various databases.
Currently supported:
- MySQL
- MongoDB
The API
The API is for all the query builders the same.
This is done so you can easily change the database type, and the queries work like normal.
Although keep the database limitations in mind.
Documentation
All example can be used in MySQL and MongoDB only by changing the getType value. Supported values are:
- mysql
- mongo
Building a simple mysql select query.
var universal_query = ; var mysql = universal_query;var sql = mysql;// SELECT * FROM `foo`;
A more advanced select query
var universal_query = ; var mysql = universal_query;var sql = mysql;// SELECT * FROM `foo` AS `bar` WHERE `bar`.`foo_bar` = 1;
An insert query
var universal_query = ; var mysql = universal_query;var sql = mysql;// INSERT INTO `foo` (`foo`) VALUES ('bar');
An update query
var universal_query = ; var mysql = universal_query;var sql = mysql;// UPDATE `foo` SET `foo`='bar' WHERE `foo`.`foo_bar` = 1;