DbFramework::ForeignKey - Foreign Key class
use DbFramework::ForeignKey; $fk = new DbFramework::ForeignKey($name,\@attributes,$primary); $pk = $fk->references($primary); $sql = $fk->as_sql; $html = $fk->as_html_form_field(\%values); $s = $fk->sql_where;
The DbFramework::ForeignKey class implements foreign keys for a table.
Returns a new DbFramework::ForeignKey object.
$name is the name of the foreign key. @attributes is a list of DbFramework::Attribute objects from a single DbFramework::Table object which make up the key. $primary is the DbFramework::Primary object which the foreign key references.
$primary should be a DbFramework::PrimaryKey object. If supplied it sets the primary key referenced by this foreign key. Returns the DbFramework::PrimaryKey object referenced by this foreign key.
Returns an HTML selection box containing values and labels from the primary key columns in the related table. %values is a hash whose keys are the attribute names of the foreign key and whose values indicate the item in the selection box which should be selected by default. See "html_select_field()" in DbFramework::PrimaryKey.
Returns a string containing SQL 'WHERE' condition(s) to join the foreign key against the primary key of the related table.
Paul Sharpe <email@example.com>
Copyright (c) 1997,1998,1999 Paul Sharpe. England. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.