Boost logo

Boost :

Subject: Re: [boost] Boost.SQL?
From: Roland Bock (rbock_at_[hidden])
Date: 2010-09-15 07:02:56

On 09/15/2010 12:31 PM, Daniel Pfeifer wrote:
> A while back, I did some experiments with prepared statements and
> boost::function (see
> Have a look at the mysql example. As I recall, it did work.
> I currently lack the time to work further on this, but if you
> concentrate on string generation (which I did not), there might be some
> interesting combinations.
> Something like this would be cool:
> . function<void(int, string, gregorian::date)> insert
> . = sql::bind(INSERT> INTO> users(id, name, registered),
> . VALUES(int_, string_, date_));
> . insert(1003, "Bob", gregorian::day_clock::local_day());
> cheers, Daniel

I am aiming at a more verbatim syntax, like

typedef my_table<> t;

sql::insert<t>(t::id(1003), t::name("Bob"),

or (if for instance date could be NULL or had a default value), this
should also work:

sql::insert<t>(t::name("Bob"), t::id(1003));

Thus, the order of arguments is irrelevant, their meaning is
self-explanatory (similar to Boost.Parameter), and some arguments are
not required if the table definition says that they are not required.

Not sure how far I get, but it is certainly possible :-)

How did you intend to maintain your table definitions (keep them in sync
with the actual tables of the database)?



Boost list run by bdawes at, gregod at, cpdaniel at, john at