• Sqltomongo is a CLI (command line interface) to work with MongoDB much easier.
• Sqltomongo translates SQL (Structured Query Language) queries to MongoDB queries.
• Sqltomongo uses the builtin MongoDB module.

Download from github repository:

https://github.com/AndrewMishchenko/sqltomongo 

or (if you have already installed git) just do:

git clone https://github.com/AndrewMishchenko/sqltomongo.git

Go to the downloaded repository

cd sqltomongo/

and type:

sudo pip3 install .

After installation type:

sqltomongo

in the shell and you will see something like:

Sqltomongo shell version v0.1 >

It is assumed that you have installed and started MongoDB.

When you run sqltomongo without any arguments, the sqltomongo shell will attempt to connect to the MongoDB instance running on the localhost interface on port 27017. To specify a different database, host or port number, as well as other options you must type:

sqltomongo database_name host port

For example, if you want to run “test” database with the standart localhost (127.0.0.1) and standart port (27017) you must type:

sqltomongo test

or if you want to run “test” database with 127.0.0.1 host and 27017 port you must type:

sqltomongo test 127.0.0.1 27017

To specify the database – use ‘use’ method in the sqltomongo shell. For example:

use test

and it will switch to test database. If you want to display the database you are using, just type:

db

in the sqltomongo shell and you will see the name of the using database.

To authenticate in the database you are using just type:

auth (user, passwd)

in the sqltomongo shell and you will see 1 if ok and 0 if authentication failed.

The structure of the SQL should be as follows:

[SELECT *] [FROM ] [WHERE *] [ORDER BY [ASC | DESC]] [SKIP ] [LIMIT ]

Projections form - *, field, field.subfield, field.*. Where "field.*" is the mongo db aggregations.

Support condition for operations “=, <>,>,>=, <, <=”. Also include the standard logical operations like AND, OR to combine Conditions.

Does not support the subqueries.