SQL::Schema::Package - A package stored within the database


SQL::Schema::Package - A package stored within the database


  my $package = SQL::Schema::Package->new(%attr);
  my $sql = $package->create_statement;
  print $sql;
  print "$package";


SQL::Schema::Package is a class for objects representing a package stored within the database. The methods of an instanciated object do allow to access the information within a database's data dictionary and to represent them as SQL create statements and the like using the proper SQL dialect.


  $package = SQL::Schema::Package->new(%attr);

The new method instanciates a package object. The object is an in memory representation of a (possible) database package. The attributes are given as key value pairs by the hash %attr. Possible keys are:

  key               required?   value description
  name              yes         the name of the package
                                without preceeding schema name
  text              yes         the concatenation of all the text lines
                                forming the package's source code

As a package is basically a piece of source stored within the database, this class inherits all methods from SQL::Schema::Source. So please have a look at the new method describet at the SQL::Schema::Source(3) manpage. Though the new method here overwrites the new method there, it calls the super class's new method with just the key value pair for the source's type added.

  $package = SQL::Schema::Package->select($dbh,$name);

The select method fetches the attributes required by new from the database and returns the package object. (It calls new internally.)

If the package with the name $name could not be found within the database, the method returns undef.

The method's arguments are as follows:

A database handle as defined by DBI(3).

The name of the package without preceeding schema name.


The following attribute methods do exist:

  $type = $package->type;

The method type always returns the string ``package''. This package inherits all the other methods from SQL::Schema::Source as a database package basically is a special kind of source within the database. For more information, please have a look at the SQL::Schema::Source(3) manpage.


  SQL::Schema::Package is Copyright (C) 2000,
    Torsten Hentschel
    Windmuehlenweg 47
    44141 Dortmund
    Email: todd@bayleys.ping.de
  All rights reserved.
  You may distribute this package under the terms of either the GNU
  General Public License or the Artistic License, as specified in the
  Perl README file.


DBI(3), the SQL::Schema(3) manpage, the SQL::Schema::Source(3) manpage

 SQL::Schema::Package - A package stored within the database