This Vert.x module uses the https://github.com/mauricio/postgresql-async drivers to support a fully async module for MySQL and PostgreSQL.

* Vert.x 2.1+ (with Scala language module v1.1.0+)

* A working PostgreSQL or MySQL server

* For testing PostgreSQL: A `testdb` database on a local PostgreSQL install and a user called `vertx`

* For testing MySQL: A `testdb` database on a local MySQL install and a user called `root`

Depending on your Scala version, you should download the specific version. If you're using Scala 2.10.x:

If you're using Scala in your own project and want to use Scala 2.11, you can change `lang-scala_2.10` to `lang-scala_2.11`.

{

"address" : <event-bus-addres-to-listen-on>,

* `database` - The name of the database you want to connect to. Defaults to `testdb`.

All commands are relatively similar. Use JSON with the `action` field and add the needed parameters for each command.

There are only a few commands available currently, but in theory you should be able to invoke any command on the database with the `raw` action.

The module will reply to all requests. In the message, there will be either a `"status" : "ok"` or a `"status" : "error"`. If the request could be processed without problems, it will result in an "ok" status. See an example here:

"message" : "column \"ager\" does not exist"

}

Use this action to insert new rows into a table. You need to specify a table, the fields to insert and an array of rows to insert. The rows itself are an array of values.

]

}

The `select` action creates a `SELECT` statement to get a projection from a table. You can filter the columns by providing a `fields` array. If you omit the `fields` array, it selects every column available in the table.

"fields" : ["name", "email", "is_male", "age", "money", "wedding_date"], // Optional

}

Creates a prepared statement and lets you fill the `?` with values.

"values" : ["Mr. Test", 15]

}

Use this action to send arbitrary commands to the database. You should be able to submit any query or insertion with this command.

"command" : "DROP TABLE some_test;"

}

These commands let you begin a transaction and send an arbitrary number of statements within the started transaction. You can then commit or rollback the transaction.

Nested transactions are not possible until now!

Remember to reply to the messages after you send the `begin` command. Look in the docs how this works (e.g. for Java: [http://vertx.io/core_manual_java.html#replying-to-messages](http://vertx.io/core_manual_java.html#replying-to-messages)).

With replying to the messages, the module is able to send all statements within the same transaction. If you don't reply within the `timeoutTransaction` interval, the transaction will automatically fail and rollback.

This command starts a transaction. You get an Ok message back to which you can then reply with more statements.

{

"action" : "begin"

}

To commit a transaction you have to send the `commit` command.

{

"action" : "commit"

}

To rollback a transaction you have to send the `rollback` command.

{

"action" : "rollback"

}

Here is a small example on how a transaction works.

"status" : "ok"

}

Takes several statements and wraps them into a single transaction for the server to process. Use `statement : [...actions...]` to create such a transaction. Only `select`, `insert` and `raw` commands are allowed right now.

]

}

You can always use `raw` to do anything on the database. If the statement is a query, it will return its results just like a `select`.