[std.database] at compile time

[Justin Whear]

Graham Fawcett wrote:
>> 
>> But you still won't be able to verify the columns to the actual database
>> scheme?
> 
> 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.
> 
> If we had preprocessor support, the tool could be run as such,
> checking the model just before passing the source to the compiler.
> 
> Graham

This is actually possible now. I wrote a little CTFE parser for CREATE 
TABLE... statements, used mysql to dump a db, then used import() to include 
the dump and parse it at compile-time. I was actually using it to generate 
classes which mapped to the contents of each table (i.e. a "things" table 
would result in a "Thing" class which mapped the fields as properties). 
Obviously you need to keep the db dump up to date via an external tool.