NAME
DBIx::DBSchema::ForeignKey - Foreign key objects
SYNOPSIS
use DBIx::DBSchema::ForeignKey;
$foreign_key = new DBIx::DBSchema::ForeignKey (
{ 'columns' => [ 'column_name' ],
'table' => 'foreign_table',
}
);
$foreign_key = new DBIx::DBSchema::ForeignKey (
{
'constraint' => 'constraint_name',
'columns' => [ 'column_name', 'column2' ],
'table' => 'foreign_table',
'references' => [ 'foreign_column', 'foreign_column2' ],
'match' => 'MATCH FULL', # or MATCH SIMPLE
'on_delete' => 'NO ACTION', # on clauses: NO ACTION / RESTRICT /
'on_update' => 'RESTRICT', # CASCADE / SET NULL / SET DEFAULT
}
);
DESCRIPTION
DBIx::DBSchema::ForeignKey objects represent a foreign key.
METHODS
- new HASHREF | OPTION, VALUE, ...
-
Creates a new DBIx::DBschema::ForeignKey object.
Accepts either a hashref or a list of options and values.
Options are:
- constraint [ CONSTRAINT_NAME ]
-
Returns or sets the constraint name
- table [ TABLE_NAME ]
-
Returns or sets the foreign table name
- columns [ LISTREF ]
-
Returns or sets the columns.
- columns_sql
-
Returns a comma-joined list of columns, suitable for an SQL statement.
- references [ LISTREF ]
-
Returns or sets the referenced columns.
- references_sql
-
Returns a comma-joined list of referenced columns, suitable for an SQL statement.
- match [ TABLE_NAME ]
-
Returns or sets the MATCH clause
- on_delete [ ACTION ]
-
Returns or sets the ON DELETE clause
- on_update [ ACTION ]
-
Returns or sets the ON UPDATE clause
- sql_foreign_key
-
Returns an SQL FOREIGN KEY statement.
- cmp OTHER_INDEX_OBJECT
-
Compares this object to another supplied object. Returns true if they are have the same table, columns and references.
AUTHOR
Ivan Kohler <ivan-dbix-dbschema@420.am>
Copyright (c) 2013 Freeside Internet Services, Inc. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
BUGS
Should give in and Mo or Moo.