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

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)

Check Out this Related Man Page

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

NAME

       SQL::Translator::Producer::SQLServer - MS SQLServer producer for SQL::Translator

SYNOPSIS

	 use SQL::Translator;

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

DESCRIPTION

       This is currently a thin wrapper around the nextgen SQL::Translator::Generator::DDL::SQLServer DDL maker.

Extra Attributes
       field.list
	   List of values for an enum field.

TODO

	* !! Write some tests !!
	* Reserved words list needs updating to SQLServer.
	* Triggers, Procedures and Views DO NOT WORK

	   # Text of view is already a 'create view' statement so no need to
	   # be fancy
	   foreach ( $schema->get_views ) {
	       my $name = $_->name();
	       $output .= "

";
	       $output .= "--
-- View: $name
--

" unless $no_comments;
	       my $text = $_->sql();
	       $text =~ s/
//g;
	       $output .= "$text
GO
";
	   }

	   # Text of procedure already has the 'create procedure' stuff
	   # so there is no need to do anything fancy. However, we should
	   # think about doing fancy stuff with granting permissions and
	   # so on.
	   foreach ( $schema->get_procedures ) {
	       my $name = $_->name();
	       $output .= "

";
	       $output .= "--
-- Procedure: $name
--

" unless $no_comments;
	       my $text = $_->sql();
	     $text =~ s/
//g;
	       $output .= "$text
GO
";
	   }

SEE ALSO

       SQL::Translator

AUTHORS

       See the included AUTHORS file: http://search.cpan.org/dist/SQL-Translator/AUTHORS <http://search.cpan.org/dist/SQL-Translator/AUTHORS>

COPYRIGHT

       Copyright (c) 2012 the SQL::Translator "AUTHORS" as listed above.

LICENSE

       This code is free software and may be distributed under the same terms as Perl itself.

perl v5.14.2							    2012-05-10				 SQL::Translator::Producer::SQLServer(3pm)

Linux and UNIX Man Pages

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

Check Out this Related Man Page