Console Query Tool

, _(*1)

Application is a simple MongoDB client which works in console end executes SQL statement as native mongo queries., _(*2)

Requirements

php 5.6 or greater
php-mongodb extension
unix compatible platform

Installation

composer requires mev/console-query-tool

Usage

php bin/app.php <command> <options> <query>

Available commands:, _(*3)

query:execute - Execute SQL query

Available options:, _(*4)

--host[=HOST]     MongoDB server host [default: "localhost"]
--port[=PORT]     MongoDB server port [default: 27017]
--db=DB           MongoDB database
-h, --help        Display a help message

Example, _(*5)

php bin/app.php query:execute --db=test "SELECT price, name FROM books WHERE price >=5"

Supported statements:, _(*6)

SELECT (without subqueries)
WHERE
LIMIT
ORDER BY

Supported compare operators:, _(*7)

= - equal
<> - not equal
< - less than
> - greater than
>= - greater than or equal
<= - less than or equal

Supported logical operators:, _(*8)

AND
OR

06/12 2016

dev-master

9999999-dev

Console tool wich provide unified interface different database drivers

Sources Download

GPL-2.0

The Requires

The Development Requires

phpunit/phpunit ^5.7

project console-query-tool

Console tool wich provide unified interface different database drivers

mev/console-query-tool

The README.md