Re: [boost] [relational] Relational Model Library

From: Calum Grant (calum_at_[hidden])
Date: 2005-10-04 13:05:51

> Yes. I was only wondering if it could be possible to map (at 
> compile time) a sql string like select name from people where 
> name ="Reece" ---> select(people,
> col<person_name>() == "Reece");
> so that the "library user" specifies standard sql syntax (I 
> am interested in using RML but am not an expert!)

One could certainly map the other way, i.e. generate a SQL string from a
C++ expression. So one could implement a function that could transform a
RML expression to a SQL string, that could be passed to a database.  The
question is whether a C++-based syntax would be preferable to a
string-based syntax.

> On 10/4/05, Pavel Vozenilek <pavel_vozenilek_at_[hidden]> wrote:
> >
> >
> > "Jose" wrote:
> >
> > > One idea that could make the syntax issues more palatable is to 
> > > incorporate some ideas from the soci.sf.net <http://soci.sf.net> 
> > > <http://soci.sf.net>
> > library
> > >
> > > http://lists.boost.org/Archives/boost/2005/10/94680.php
> > >
> > > I have not given thought to how easy it would be to implement it, 
> > > but
> > the
> > > idea is that the queries are valid sql queries and then the soci 
> > > layer translates those to the more arcane syntax/es. 
> Simplifying and 
> > > unifying the syntax should be a good thing !
> > >
> > SOCI library produces string which is passed down
> > to SQL engine for interpretation. This approach is very 
> different from 
> > what RML does.
> >
> > /Pavel
> >
> >
> >
> >
> > _______________________________________________
> > Unsubscribe & other changes: 
> > http://lists.boost.org/mailman/listinfo.cgi/boost
> >
> _______________________________________________
> Unsubscribe & other changes: 
> http://lists.boost.org/mailman/listinfo.cgi/bo> ost
>