[sqlfairy-developers] SQL::Translator::Producer::Validate

[Cahill, E. <ec...@co...>]

I have a vision of creating modules like

=20

SQL::Translator::Producer::Validate::CGIExValidate

=20

which would take a parsed schema and convert it to a CGI::Ex::Validate
hash.  There are also other Validation methods out there, but I think
CGI::Ex::Validate to be the best and if nothing else, the one I know the
best :)  The framework would be expandable to other validation schemes,
like SQL::Translator::Producer::Validate::OtherScheme.

=20

Having this glue layer would allow for pretty well free, database-driven
validation.  I know it couldn't really be perfect for every set of
tables, but for simple one form -> one table type stuff, I think it
could work well.  CGI::Ex::Validate is used heavily in my CGI::Path
stuff.  I think it rather slick.

=20

Add in a little Cache::Memcached, which can do thousands of gets per
second, and you start to get a pretty slick/speedy validation framework,
and it would all start with the schema.

=20

Thoughts?  Anyone done anything similar?

=20

Thanks,

Earl