Skip to content

master/mongosql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

42 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

README

This is the SQL wrapper for MongoDB for Erlang. It mimics interface and behavior of MySQL Native Erlang driver.

Bitdeli Badge

INSTALL

Download and compile MongoSQL and eMongo driver

$ git clone git://github.com/master/emongo.git emongo
$ git clone git://github.com/master/mongosql.git mongosql
$ cd emongo
$ make
$ cd ../mongosql
$ make
$ cd ..

USAGE

$ erl -pa emongo/ebin mongosql/ebin

> application:start(emongo).
> {ok, Pool} = mongosql_conn:start([{"127.0.0.1", 27017}], "test1").
> mongosql_conn:fetch(Pool, "insert into tbl1 col1, col2 values ('string', 1);", false).
{updated,1}
> mongosql_conn:fetch(Pool, "select count(*) from tbl1;", false). 
{selected,["count(*)"],[{"1"}]}
> mongosql_conn:fetch(Pool, "select * from tbl1;", false).
{selected,["col1","col2"],[["string",1]]}
> mongosql_conn:fetch(Pool, "delete from tbl1 where col2 = 1;", false).  
{updated,1}
> mongosql_conn:fetch(Pool, "select count(*) from tbl1;", false).        
{selected,["count(*)"],[{"0"}]}
> mongosql_conn:stop(Pool).

About

MongoDB SQL wrapper

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages