New feature?: Bind a bean to an Insert or Update query

[jsnoriegam]

I know this is not a ORM and that's what is good about this project, but just as you can map a bean from a select result, i think it would be good to bind a bean to an update or insert query...

Something like .createQuery("UPDATE clients SET date = :date, name = :name, regn = :regn, active = :active WHERE id = :id").bind(client).executeUpdate();

bindig all the attributes of client as paramaters (Asuming client has id, date, name, regn, active attributes).

I know it can be done, but i don't know if this goes against what you are aiming for with this project.

Tell me what you think.

Thanks.

[aaberg]

Hi jsnoriegam,

I have had these thoughts myself. The only reason I haven't implemented it, is because I haven't had the time, and no one (before you) have asked for it.

If you feel like implementing it, you are more than welcome :) Otherwise I will put it in the todo list for one of the next versions.

[jsnoriegam]

This is a draft implementation but it works for me:
https://github.com/jsnoriegam/sql2o/blob/master/src/main/java/org/sql2o/Query.java#L206
Right now it works only with lowercase params...

[aaberg]

Nice :)
Could you write a unittest? Then I will merge it into the official repo.

[jsnoriegam]

Unit test ready, and a few corrections to the new bind method.

[aaberg]

Merged into master.

Thanks a lot :)