vert-x / mod-mysql-postgresql

Vert.x 2.x is deprecated - use instead
http://vertx.io/docs/vertx-mysql-postgresql-client/java/
Apache License 2.0
49 stars 17 forks source link

WHERE and other features for SELECT, INSERT, etc. #1

Open Narigo opened 11 years ago

Narigo commented 11 years ago

Right now, the SELECT and INSERT commands can only construct very simple SQL statements, since we couldn't find a nice library that produces SQL from JSON. Writing our own would be quite complex - if someone knows a good library or wants to volunteer on writing a nicer version, please add pull requests :)

rowanseymour commented 10 years ago

Would be very useful to hear what workarounds people are using until this feature is implemented

Narigo commented 10 years ago

You can always use the "raw" command and write the queries you need. Am 16.05.2014 08:28 schrieb "Rowan Seymour" notifications@github.com:

Would be very useful to hear what workarounds people are using until this feature is implemented

— Reply to this email directly or view it on GitHubhttps://github.com/vert-x/mod-mysql-postgresql/issues/1#issuecomment-43301163 .

rowanseymour commented 10 years ago

Yes sorry I did find that but hadn't found a good open source library for simple SQL generation (so I don't have to worry about injection). Have it working nicely with "prepared" now and this https://gist.github.com/agentgt/3650165