[odb-users] How to retrieve schema name ?

[David Sarrut]

many thanks Per, I did as suggested, and it works.

thanks again
David

On Thu, Mar 19, 2015 at 11:45 AM, Per Edin <info at peredin.com> wrote:

> Ah! I see. I'm sure native views can help you with that, untested
> example from the top of my head:
>
> #pragma db view query("SELECT name FROM schema_version GROUP BY name")
> struct schema_name
> {
>   std::string name;
> };
>
> odb::result< schema_name > r(db.query< schema_name >());
>
> Section 10.6 Native Views of the ODB manual should provide more details. :)
>
> /Per
>
>
> On Thu, Mar 19, 2015 at 11:20 AM, David Sarrut
> <David.Sarrut at creatis.insa-lyon.fr> wrote:
> >
> > yes Per, sure ! Sorry I was not enough precise: I need to do this query
> > within odb, in C++.
> >
> > I usually use things such as :
> > typedef odb::query<person> query;
> > typedef odb::result<person> result;
> > etc ...
> >
> > but I need to know the type of this schema_version table to do that. Or
> > maybe with native SQL query ? but in this case, it is not clear for me
> how
> > to get the result.
> >
> > thanks,
> > David
> >
> >
> > On Thu, Mar 19, 2015 at 11:09 AM, Per Edin <info at peredin.com> wrote:
> >>
> >> Hi David!
> >>
> >> Maybe I have misunderstood your problem, but wouldn't a simple
> >>
> >> SELECT name FROM schema_version GROUP BY name
> >>
> >> work? To get all unique schema names in any database.
> >>
> >> /Per
> >>
> >> On Thu, Mar 19, 2015 at 10:55 AM, David Sarrut
> >> <David.Sarrut at creatis.insa-lyon.fr> wrote:
> >> > Hello,
> >> >
> >> > when create a db with a schema name, there is an additional table
> >> > "schema_version" that is created. When reading a database, say from a
> >> > file
> >> > with sqlite, is there a way to access this table content and retrieve
> >> > the
> >> > value for the name ?
> >> >
> >> > thanks,
> >> > David
> >> >
> >> > --
> >> > David Sarrut, Phd
> >> > Directeur de recherche CNRS
> >> > CREATIS, UMR CNRS 5220, Inserm U 1044
> >> > Centre de lutte contre le cancer Léon Bérard
> >> > 28 rue Laënnec, 69373 Lyon cedex 08
> >> > Tel : 04 78 78 51 51 / 06 74 72 05 42
> >> > http://www.creatis.insa-lyon.fr/~dsarrut
> >> > _________________________________
> >> >  "2 + 2 = 5,  for extremely large values of 2"
> >> > _________________________________
> >
> >
> >
> >
> > --
> > David Sarrut, Phd
> > Directeur de recherche CNRS
> > CREATIS, UMR CNRS 5220, Inserm U 1044
> > Centre de lutte contre le cancer Léon Bérard
> > 28 rue Laënnec, 69373 Lyon cedex 08
> > Tel : 04 78 78 51 51 / 06 74 72 05 42
> > http://www.creatis.insa-lyon.fr/~dsarrut
> > _________________________________
> >  "2 + 2 = 5,  for extremely large values of 2"
> > _________________________________
>



-- 
David Sarrut, Phd
Directeur de recherche CNRS
CREATIS, UMR CNRS 5220, Inserm U 1044
Centre de lutte contre le cancer Léon Bérard
28 rue Laënnec, 69373 Lyon cedex 08
Tel : 04 78 78 51 51 / 06 74 72 05 42
http://www.creatis.insa-lyon.fr/~dsarrut
_________________________________
 "2 + 2 = 5,  for extremely large values of 2"
_________________________________