On 01/11/2012 03:06 PM, Mateusz Loskot wrote:
On 11 January 2012 12:29, Roland Bock <rbock@eudoxos.de> wrote:
On 01/10/2012 04:11 PM, Artyom Beilis wrote:
- CppDB Sql Connectivity Taking an example from your documentation:
cppdb::statement <http://cppcms.sourceforge.net/sql/cppdb/classcppdb_1_1statement.html> st=sql.prepare("DELETE FROM users WHERE age<? AND role<>?"); st.bind <http://cppcms.sourceforge.net/sql/cppdb/classcppdb_1_1statement.html#add4e469140ddd77aadc5d6c8cfb8ba11>(1,13); st.bind <http://cppcms.sourceforge.net/sql/cppdb/classcppdb_1_1statement.html#add4e469140ddd77aadc5d6c8cfb8ba11>(2,"moderator");
In our company we have combination of code generator and template library which allows to do the following
TabUsers tab; tab.remove(tab.age<13 and role!="moderator");
The compiler can then ensure correct names for tables and columns, typesafety and correct syntax. This makes database programming much easier because there is much less room for stupid mistakes. Sounds similar to http://www.codesynthesis.com/products/odb/
Best regards, Thanks for the link!
As far as I can tell from a few minutes of reading, their approach uses the same idea, but starts from C++ classes, where we start from SQL table definitions. I wonder how changes in the data model look like (e.g. adding a new column)? We can migrate the database, dump the new table structure and generate the code. I'll keep on reading! Thanks again! Regards, Roland