readme update

Zwergal · Zwergal · commit fa731f56b896 · 2013-12-03T16:18:11.000+01:00
mysql transaction now work
diff --git a/README.md b/README.md
@@ -104,8 +104,6 @@ Creates a prepared statement and lets you fill the `?` with values.
 
 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.
 
-Be aware: This is only tested and working with PostgreSQL currently.
-
     {
       "action" : "transaction",
       "statements" : [
@@ -117,12 +115,12 @@ Be aware: This is only tested and working with PostgreSQL currently.
         },
         {
           "action" : "raw",
-          "command" : "UPDATE account SET balance=balance+? WHERE name=?",
+          "command" : "UPDATE account SET balance=balance+1 WHERE name='Mr. Test'",
         },
         {
-          "action" : "select",
-          "table" : "account",
-          "fields" : ["balance"]
+          "action" : "prepared",
+          "statement" : "UPDATE account SET balance=balance+? WHERE name=?",
+          "values" : [25, 'Mr. Test']
         }
       ]
     }
diff --git a/src/test/scala/io/vertx/asyncsql/test/mysql/MySqlTest.scala b/src/test/scala/io/vertx/asyncsql/test/mysql/MySqlTest.scala
@@ -51,9 +51,8 @@ CREATE TABLE """ + tableName + """ (
   @Test
   override def preparedSelect(): Unit = super.preparedSelect()
   @Test
+  override def transaction(): Unit = super.transaction()
+  @Test
   override def transactionWithPreparedStatement(): Unit = super.transactionWithPreparedStatement()
-  //  @Ignore("not working currently")
-  //  @Test
-  //  override def transaction(): Unit = super.transaction()
 
 }

Original file line number	Diff line number	Diff line change
@@ -104,8 +104,6 @@ Creates a prepared statement and lets you fill the `?` with values.
`104`	`104`
`105`	`105`	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.
`106`	`106`
`107`		`-Be aware: This is only tested and working with PostgreSQL currently.`
`108`		`-`
`109`	`107`	`{`
`110`	`108`	`"action" : "transaction",`
`111`	`109`	`"statements" : [`
`@@ -117,12 +115,12 @@ Be aware: This is only tested and working with PostgreSQL currently.`
`117`	`115`	`},`
`118`	`116`	`{`
`119`	`117`	`"action" : "raw",`
`120`		`- "command" : "UPDATE account SET balance=balance+? WHERE name=?",`
	`118`	`+ "command" : "UPDATE account SET balance=balance+1 WHERE name='Mr. Test'",`
`121`	`119`	`},`
`122`	`120`	`{`
`123`		`- "action" : "select",`
`124`		`- "table" : "account",`
`125`		`- "fields" : ["balance"]`
	`121`	`+ "action" : "prepared",`
	`122`	`+ "statement" : "UPDATE account SET balance=balance+? WHERE name=?",`
	`123`	`+ "values" : [25, 'Mr. Test']`
`126`	`124`	`}`
`127`	`125`	`]`
`128`	`126`	`}`