Hi all (and especially Brandon Black),
Jeff Zucker (jZed), here (author/maintainer of DBD::CSV, DBD::AnyData,
SQL::Statement and various other DBI related modules). I wanted a DBIC
loader that would work with the DBDs that do not store metadata (other
than column names) so I wrote a little wrapper around SQL::Translator
and DBIx::Class::File that will parse DDL on the fly, create DBIC schema
classes in memory (and optionally to file).
In addition to serving as a loader for DBD::CSV etc. this wrapper
supports file-less prototyping of schemas for any DBD. You can just
feed it SQL statements (DDL and optionally also DML) to create and
populate a test schema and begin using DBIx::Class on it directly
without creating any module files (and if you use temp tables, without
any db footprint either).
The module and a working sample script can be found at
http://www.perlmonks.org/?node_id=623778
Castaway tells me that Matt suggested this should be named something
like DBIx::Class::Schema::Loader::SQL. Should I release this as a
separate module or (as I'd prefer) just submit it as a patch to
DBIx::Class::Schema::Loader? If the latter, what version should I patch
against?
P.S. It won't work with DBD::CSV etc. yet, I need to release the next
version of SQL::Statement for that.
--
Jeff
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/dbix-class@lists.rawmode.org/
