On 09/15/2010 03:43 PM, Maciej Sobczak wrote:
Hi,
On 9/15/2010 1:46 PM, Roland Bock wrote:
OK, taking the first example from the SOCI project page:
sql<< "select name, salary from persons where id ="<< id, into(name), into(salary); [...]
This is nice, but still requires attention where the compiler could help, if the table definition was known. Here is what it would look like in my version (assuming that I manage the transition to boost proto): [...]
Maybe it would make sense to add such a layer as an option to SOCI?
In all example programs SOCI takes the string as the query, but in fact it can be anything that is "streamable". This makes it possible to add any imaginable layer that will ultimately end up as an object that will produce the intended text query when streamed out. That is:
sql << HERE-YOUR.SMART%STATIC|QUERY&MAKING*ENGINE, into(name), into(salary); I guess I could also wrap this
rowset<row> rs = (sql.prepare<< "select id, firstname, lastname, gender from person"); into something that immediately returns vector<smart_row> (or boost::range, as proposed by Mathias). Since the "smart&static" engine knows what it asks for, it can assign row[0] to smart_row.id, row[1] to smart_row.firstname , etc. The rowset and its iterators are rather similar to the stuff from libpqxx which I currently use... I'll have a closer look at the interface documentation, soon (struggling with my first steps with Boost::Proto for the moment). Regards, Roland