[std.database] at compile time
dennis luehring
dl.soluz at gmx.net
Fri Oct 14 14:58:45 PDT 2011
> One approach would be to write a separate tool that connects to the
> database and writes out a representation of the schema to a source
> file. At compile time, the representation is statically imported, and
> used to verify the data model.
what about data/fields that don't comes out of the model?
for example:
select
name_length_add_1,
count(*) as counted
from
(
select
(len(p.firstname) + 1) as name_length_add_1,
p.*
from
persons as p
inner join members as m on p.firstname == m.firstname
) as blub
group by
name_length_add_1
how is the "counted" field or "name_length_add_1" staticaly verified?
people tend to think that sql is just simple table querying stuff - but
thats not, not in the real world
More information about the Digitalmars-d
mailing list