sql::translator::producer::sybase(3pm) [debian man page]

SQL::Translator::Producer::Sybase(3pm)			User Contributed Perl Documentation		    SQL::Translator::Producer::Sybase(3pm)

NAME

       SQL::Translator::Producer::Sybase - Sybase producer for SQL::Translator

SYNOPSIS

	 use SQL::Translator;

	 my $t = SQL::Translator->new( parser => '...', producer => 'Sybase' );
	 $t->translate;

DESCRIPTION

       This module will produce text output of the schema suitable for Sybase.

Sybase Create Table Syntax
	 CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (
	     { column_name data_type [ DEFAULT default_expr ] [ column_constraint [, ... ] ]
	     | table_constraint }  [, ... ]
	 )
	 [ INHERITS ( parent_table [, ... ] ) ]
	 [ WITH OIDS | WITHOUT OIDS ]

       where column_constraint is:

	 [ CONSTRAINT constraint_name ]
	 { NOT NULL | NULL | UNIQUE | PRIMARY KEY |
	   CHECK (expression) |
	   REFERENCES reftable [ ( refcolumn ) ] [ MATCH FULL | MATCH PARTIAL ]
	     [ ON DELETE action ] [ ON UPDATE action ] }
	 [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]

       and table_constraint is:

	 [ CONSTRAINT constraint_name ]
	 { UNIQUE ( column_name [, ... ] ) |
	   PRIMARY KEY ( column_name [, ... ] ) |
	   CHECK ( expression ) |
	   FOREIGN KEY ( column_name [, ... ] ) REFERENCES reftable [ ( refcolumn [, ... ] ) ]
	     [ MATCH FULL | MATCH PARTIAL ] [ ON DELETE action ] [ ON UPDATE action ] }
	 [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]

Create Index Syntax
	 CREATE [ UNIQUE ] INDEX index_name ON table
	     [ USING acc_method ] ( column [ ops_name ] [, ...] )
	     [ WHERE predicate ]
	 CREATE [ UNIQUE ] INDEX index_name ON table
	     [ USING acc_method ] ( func_name( column [, ... ]) [ ops_name ] )
	     [ WHERE predicate ]

SEE ALSO

       SQL::Translator.

AUTHORS

       Sam Angiuoli <angiuoli@users.sourceforge.net>, Paul Harrington <harringp@deshaw.com>, Ken Youens-Clark <kclark@cpan.org>.

perl v5.14.2							    2012-01-18				    SQL::Translator::Producer::Sybase(3pm)

SQL::Translator::Producer::HTML(3pm)			User Contributed Perl Documentation		      SQL::Translator::Producer::HTML(3pm)

NAME

       SQL::Translator::Producer::HTML - HTML producer for SQL::Translator

SYNOPSIS

	 use SQL::Translator::Producer::HTML;

DESCRIPTION

       Creates an HTML document describing the tables.

       The HTML produced is composed of a number of tables:

       Links
	   A link table sits at the top of the output, and contains anchored links to elements in the rest of the document.

	   If the nolinktable producer arg is present, then this table is not produced.

       Tables
	   Each table in the schema has its own HTML table.  The top row is a row of <th> elements, with a class of FieldHeader; these elements
	   are Field Name, Data Type, Size, Default Value, Other and Foreign Key.  Each successive row describes one field in the table, and has a
	   class of FieldCell$item, where $item id corresponds to the label of the column.  For example:

	       <tr>
		   <td class="FieldCellName"><a name="random-id">id</a></td>
		   <td class="FieldCellType">int</td>
		   <td class="FieldCellSize">11</td>
		   <td class="FieldCellDefault"></td>
		   <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td>
		   <td class="FieldCellFK"></td>
	       </tr>

	       <tr>
		   <td class="FieldCellName"><a name="random-foo">foo</a></td>
		   <td class="FieldCellType">varchar</td>
		   <td class="FieldCellSize">255</td>
		   <td class="FieldCellDefault"></td>
		   <td class="FieldCellOther">NOT NULL</td>
		   <td class="FieldCellFK"></td>
	       </tr>

	       <tr>
		   <td class="FieldCellName"><a name="random-updated">updated</a></td>
		   <td class="FieldCellType">timestamp</td>
		   <td class="FieldCellSize">0</td>
		   <td class="FieldCellDefault"></td>
		   <td class="FieldCellOther"></td>
		   <td class="FieldCellFK"></td>
	       </tr>

       Unless the nowrap producer arg is present, the HTML will be enclosed in a basic HTML header and footer.

       If the pretty producer arg is present, the generated HTML will be nicely spaced and human-readable.  Otherwise, it will have very little
       insignificant whitespace and be generally smaller.

AUTHORS

       Ken Youens-Clark <kclark@cpan.org>, Darren Chamberlain <darren@cpan.org>.

perl v5.14.2							    2012-01-18				      SQL::Translator::Producer::HTML(3pm)