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 http://github.com/purpleKarrot/async-db).
>
> Have a look at the mysql example. As I recall, it did work.
> http://github.com/purpleKarrot/async-db/blob/master/examples/mysql.cpp
>
> 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
>
Nice!
I am aiming at a more verbatim syntax, like
typedef my_table<> t;
sql::insert<t>(t::id(1003), t::name("Bob"),
t::date(gregorian::day_clock::local_day());
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)?
Regards,
Roland