Schema patch


#1

As promised (if a bit late… uhh), here’s a patch to unify schema
creation from a single Perl data structure. There’s four attachments
here:

  • first, a patch to Makefile and bin/testdeps.pl
  • second, the new file bin/initdb, and
  • third, the new file etc/schema.pm, and
  • lastly, the new file etc/insert.mysql

You’ll also need the DBIx::DataSource and DBIx::DBSchema modules. If they
have not yet propogated to your favourite CPAN mirror, you can get them
at: http://420.am/dbix-datasource and http://420.am/dbix-dbschema
respectively.

The initdb.{mysql,Pg,Oracle} files have become just `initdb’, with the
database type passed as a parameter. The database password is no longer
passed on the the command line and is instead queried from the user.

The schema.{mysql,Pg,Oracle> files have become schema.pm'. The data inserts there were misplaced in there haven't found a new home yet.insert.mysql’ has the MySQL inserts for now.

MySQL appears to be working. Pg is no worse than before. :slight_smile: Oracle
might take some work.

meow
_ivan

schema-patch (1.28 KB)

initdb (1.73 KB)

insert.mysql (9.36 KB)

schema.pm (7.99 KB)