InstantCRUD ( Create Retrieve Update Delete)

Summary:

* a command line tool for generating the application files * command line parameters for: application name, dsn, database user and password * CRUD for all found database tables

See Catalyst::Example::InstantCRUD at CPAN: http://search.cpan.org/author/ZBY/Catalyst-Example-InstantCRUD-v0.0.10/lib/Catalyst/Example/InstantCRUD.pm

instantcrud.pl -name=My::App -dsn='dbi:Pg:dbname=CE' -user=zby -password='pass'

The instantcrud.pl executable creates a skeleton CRUD application in current directory. The parameters are: name of the application and database connection details.

An Endorsement:

Very nice, I installed apachefriends and then installed this, and by running

instantcrud.pl -name=App -dsn='dbi:mysql:dbname=test'

I had a catalyst skeleton application with create-retrieve-update-delete for the tables in the "test" database which is installed automatically by apachefriends. (http://www.apachefriends.org)

Other Comments:

  • learn from rails - a distribution which lets you create an application with strong, non-auto-generated CRUD support (paging, sorting, optional auth, form validation *with good reporting*, that is easy to append to), automatic schema stuff, a pretty output (somewhat like rails default allows you), and then to "freeze" this app into a real catalyst app (generate real text files for the runtime-created components) when the user is ready to take responsibility (a start to that might be:
  • http://lists.rawmode.org/pipermail/catalyst/2005-November/002830.html). Also likes config files over config code (xml or YAML, auto detected).
  • see also http://dev.catalyst.perl.org/repos/Catalyst/trunk/Catalyst-LayerCake/