mysql::diff::table(3pm) [debian man page]

MySQL::Diff::Table(3pm) 				User Contributed Perl Documentation				   MySQL::Diff::Table(3pm)

NAME

       MySQL::Diff::Table - Table Definition Class

SYNOPSIS

	 use MySQL::Diff::Table

	 my $db = MySQL::Diff::Database->new(%options);
	 my $def	   = $db->def();
	 my $name	   = $db->name();
	 my $field	   = $db->field();
	 my $fields	   = $db->fields();		   # %$fields
	 my $primary_key   = $db->primary_key();
	 my $indices	   = $db->indices();		   # %$indices
	 my $options	   = $db->options();

	 my $isfield	   = $db->isa_field($field);
	 my $isprimary	   = $db->isa_primary($field);
	 my $isindex	   = $db->isa_index($field);
	 my $isunique	   = $db->is_unique($field);
	 my $isfulltext    = $db->is_fulltext($field);

DESCRIPTION

       Parses a table definition into component parts.

METHODS

   Constructor
       new( %options )
	   Instantiate the objects, providing the command line options for database access and process requirements.

   Public Methods
       Fuller documentation will appear here in time :)

       o   def

	   Returns the table definition as a string.

       o   name

	   Returns the name of the current table.

       o   field

	   Returns the current field definition of the given field.

       o   fields

	   Returns an array reference to a list of fields.

       o   primary_key

	   Returns a hash reference to fields used as primary key fields.

       o   indices

	   Returns a hash reference to fields used as index fields.

       o   options

	   Returns the additional options added to the table definition.

       o   isa_field

	   Returns 1 if given field is used in the current table definition, otherwise returns 0.

       o   isa_primary

	   Returns 1 if given field is defined as a primary key, otherwise returns 0.

       o   isa_index

	   Returns 1 if given field is used as an index field, otherwise returns 0.

       o   is_unique

	   Returns 1 if given field is used as unique index field, otherwise returns 0.

       o   is_fulltext

	   Returns 1 if given field is used as fulltext index field, otherwise returns 0.

COPYRIGHT AND LICENSE

       Copyright (c) 2000-2011 Adam Spiers. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

SEE ALSO

       mysqldiff, MySQL::Diff, MySQL::Diff::Database, MySQL::Diff::Utils

AUTHOR

       Adam Spiers <mysqldiff@adamspiers.org>

perl v5.14.2							    2012-04-06						   MySQL::Diff::Table(3pm)

Check Out this Related Man Page

SQL::Translator::Filter::Globals(3pm)			User Contributed Perl Documentation		     SQL::Translator::Filter::Globals(3pm)

NAME

       SQL::Translator::Filter::Globals - Add global fields and indices to all tables.

SYNOPSIS

	 # e.g. Add timestamp field to all tables.
	 use SQL::Translator;

	 my $sqlt = SQL::Translator->new(
	     from => 'MySQL',
	     to   => 'MySQL',
	     filters => [
	       Globals => {
		   fields => [
		       {
			   name => 'modified'
			   data_type => 'TIMESTAMP'
		       }
		   ],
		   indices => [
		       {
			   fields => 'modifed',
		       },
		   ]
		   constraints => [
		       {
		       }
		   ]
	       },
	     ],
	 ) || die "SQLFairy error : ".SQL::Translator->error;
	 my $sql = $sqlt->translate || die "SQLFairy error : ".$sqlt->error;

DESCRIPTION

       Adds global fields, indices and constraints to all tables in the schema.  The globals to add can either be defined in the filter args or
       using a _GLOBAL_ table (see below).

       If a table already contains a field with the same name as a global then it is skipped for that table.

   The _GLOBAL_ Table
       An alternative to using the args is to add a table called "_GLOBAL_" to the schema and then just use the filter. Any fields and indices
       defined on this table will be added to all the tables in the schema and the _GLOBAL_ table removed.

       The name of the global can be changed using a "global_table" arg to the filter.

SEE ALSO

       perl(1), SQL::Translator

BUGS

       Will generate duplicate indices if an index already exists on a table the same as one added globally.

       Will generate duplicate constraints if a constraint already exists on a table the same as one added globally.

TODO

       Some extra data values that can be used to control the global addition. e.g.  'skip_global'.

AUTHOR

       Mark Addison <grommit@users.sourceforge.net>

perl v5.14.2							    2012-01-18				     SQL::Translator::Filter::Globals(3pm)

Linux and UNIX Man Pages

mysql::diff::table(3pm) [debian man page]

Check Out this Related Man Page