node-dao

Node-Dao - Simple MongoDb-like interface to MySql, PostgreSql, SqlLite and Mongo databases

look like this:

var rsa = await daoConnection.find({}).limit(2).sort({ name: 1 }).toArray();

find method samples:

find({value: {$gte: 25}})

find({value: {$ne: 4}})

find({age: {$gt: 20, $lt:10}})

find({age: {$gt: 20, $lt:10}})

find({age: {$gt: 20}, name: {$eq: “jenny”}});

so, dao request

find({name: {$eq: “john”}}).limit(1).sort({time: -1}).limit(1).toArray();

will be translated for MySQL like that

SELECT * FROM messages WHERE name = “john” ORDER BY name DESC LIMIT 1 OFFSET 1;

If you call count() instread toArray() then the request will be generated as:

SELECT count(*) FROM messages WHERE name = “john” LIMIT 1 OFFSET 1;