Re: [boost] sqlpp11: SQL for C++

11 Nov 2013

      Hi,

2013/11/10 Roland Bock 
...
Hi,
over the last four or five years I developed several SQL libraries for
C++. With C++11 I was finally able to create an SQL library that meets
my own expectations and requirements. It is being used in production, I
recently put it on github, and I would really like to hear from you guys
whether this is something that could be interesting for you personally
or for boost?
https://github.com/rbock/sqlpp11
https://github.com/rbock/sqlpp11/wiki
That's almost what I was looking for :D

Thus far, I used SOCI with my query wrapper like below:

    BOOST_FUSION_DEFINE_STRUCT
    (
        (opti), user,
        (std::string, account)
        (std::string, pwd)
        (std::string, name)
        (unsigned, role)
    )

soci::session sql;
    query query_users(sql, "SELECT id, account, pwd,
name, role FROM user";

    for (auto&& user : query_users()) {...}
...
--------------
// selecting zero or more results, iterating over the results
for (const auto& row : db.run(
                        select(foo.name, foo.hasFun)
                        .from(foo)
                        .where(foo.id > 17 and foo.name.like("%bar%"))))
Is it possible to separate the placeholders of columns & tables? I feel it
redundant to say table.column if not ambiguous.
In case of more than one table, maybe table[column] is a good syntax for
that.

Does it support prepared statement?
Maybe another set of placeholders (_1, _2, ...) can be used to generate the
functor.

Also, it'll be great if it works with Fusion & Optional, etc...

{
...
if (row.name.is_null())
    std::cerr << "name will convert to empty string" << std::endl;
  std::string name = row.name;  // text fields are implicitly
                                   convertible to string
  bool hasFun = hasFun;         // bool fields are implicitly
                                   convertible to bool
}
Dynamic Select:
----------------
auto s = dynamic_select(db, tab.foo).dynamic_columns().from(tab);
if (userWantsBar)
  s.add_column(tab.bar);
for(const auto& row : run(s))
{
  std::cerr << "row.foo: " << row.foo;
  if (userWantsBar)
    std::cerr << "row.bar" << row.at("bar");
  std::cerr << std::endl;
};
Please let me know your questions/thoughts/suggestions/rants.
Contributions welcome, of course :-)
Regards,
Roland
_______________________________________________
Unsubscribe & other changes:
http://lists.boost.org/mailman/listinfo.cgi/boost

Re: [boost] sqlpp11: SQL for C++

TONGARI J