MAN page from Old RedHat 7.X perl-SQL-Schema-0.31-8.i386.rpm

SQL::Schema

Section: User Contributed Perl Documentation (3)
Updated: perl v5.6.0
Index

NAME

SQL::Schema - Convert a data dictionary into SQL statements

SYNOPSIS

  use DBI;

  my $dbh = DBI->connect(...);

  use SQL::Schema;

  my $schema = SQL::Schema->new($dbh);

  my $sql = $schema->string;  print $sql;

  print "$schema";

WARNING

This is alpha software.It currently works with Oracle databases only.The name of the module might be changed in futurereleases as well as its interface.

If somebody is modifying the datase schema during the life timeof an `SQL::Schema' object, the object will probably fail and / orproduce wrong information.

DESCRIPTION

`SQL::Schema' is a class for objects representing a database schema.The methods of an instanciated object do allow to access the informationwithin a database's data dictionary and to represent them as SQLcreate statements and the like using the proper SQL dialect.

Constructor

  $schema = SQL::Schema->new($dbh);

The new method instanciates a schema object. The only argumentrequired is a database handle, which has to offer the same API asdescribed within DBI(3).

Methods

  $sql = $schema->string;

Returns an SQL string containing several statements at once.This string contains all the SQL statements to create the databaseschema.

This method is overloaded with the string operator. So the followingtwo lines are equivalent:

  $sql = $schema->string;  $sql = "$schema";

AUTHOR AND COPYRIGHT

  SQL::Schema is Copyright (C) 2000, Torsten Hentschel                                     Windmuehlenweg 47                                     44141 Dortmund                                     Germany

                                     Email: toddAATTbayleys.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.

This document was created byman2html,using the manual pages.