Meta::Db::Constraint - a single multi-field constraint object.

Meta documentation Contained in the Meta distribution.

Index

Code Index:

NAME

Top

Meta::Db::Constraint - a single multi-field constraint object.

COPYRIGHT

Top

Copyright (C) 2001, 2002 Mark Veltzer; All rights reserved.

LICENSE

Top

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111, USA.

DETAILS

Top

	MANIFEST: Constraint.pm
	PROJECT: meta
	VERSION: 0.05

SYNOPSIS

Top

	package foo;
	use Meta::Db::Constraint qw();
	my($object)=Meta::Db::Constraint->new();
	my($result)=$object->method();

DESCRIPTION

Top

This class represents a single, multi-field, constraint on an RDBMS. This could be a UNIQUE or FULLTEXT constraint currently.

FUNCTIONS

Top

	BEGIN()
	getsql_create($$$)
	getsql_comma($$$)
	TEST($)

FUNCTION DOCUMENTATION

Top

BEGIN()

This method creates accesor methods for the following attributes: name - name of this constraint. description - description of this constraint.

getsql_create($$$)

This method will create a set of SQL statements to create this type of constraint within the RDMBS. Note that not all RDBMS systems support all constraint types.

getsql_comma($$)

This method will return an SQL snipplet which has all the fields involved with commas in between.

TEST($)

Test suite for this object.

SUPER CLASSES

Top

Meta::Ds::Ohash(3), Meta::Ds::Connected(3)

BUGS

Top

None.

AUTHOR

Top

	Name: Mark Veltzer
	Email: mailto:veltzer@cpan.org
	WWW: http://www.veltzer.org
	CPAN id: VELTZER

HISTORY

Top

	0.00 MV dbman package creation
	0.01 MV more thumbnail issues
	0.02 MV website construction
	0.03 MV web site automation
	0.04 MV SEE ALSO section fix
	0.05 MV md5 issues

SEE ALSO

Top

Meta::Ds::Connected(3), Meta::Ds::Ohash(3), strict(3)

TODO

Top

Nothing.

Meta documentation Contained in the Meta distribution. 
#!/bin/echo This is a perl module and should not be run

package Meta::Db::Constraint;

use strict qw(vars refs subs);
use Meta::Ds::Ohash qw();
use Meta::Ds::Connected qw();

our($VERSION,@ISA);
$VERSION="0.05";
@ISA=qw(Meta::Ds::Ohash Meta::Ds::Connected);

#sub BEGIN();
#sub getsql_create($$$);
#sub getsql_comma($$$);
#sub TEST($);

#__DATA__

sub BEGIN() {
	Class::MethodMaker->get_set(
		-java=>"_name",
		-java=>"_description",
		-java=>"_type",
	);
}

sub getsql_create($$$) {
	my($self,$stats,$info)=@_;
	if($self->get_type() eq "unique") {
		my($table)=$self->get_container()->get_container()->getsql_name($info);
		my($stat)=Meta::Sql::Stat->new();
		$stat->set_text("ALTER TABLE ".$table."ADD UNIQUE ".$self->getsql_comma($info));
		$stats->push($stat);
	}
	if($self->get_type() eq "fulltext") {
		my($table)=$self->get_container()->get_container()->getsql_name($info);
		#fulltext supported only on MySQL
		if($info->is_mysql()) {
			my($stat)=Meta::Sql::Stat->new();
			$stat->set_text("ALTER TABLE ".$table."ADD FULLTEXT ".$self->getsql_comma($info));
			$stats->push($stat);
		}
	}
	if($self->get_type() eq "primary") {
		my($table)=$self->get_container()->get_container()->getsql_name($info);
		my($stat)=Meta::Sql::Stat->new();
		$stat->set_text("ALTER TABLE ".$table."ADD PRIMARY KEY ".$self->getsql_comma($info));
		$stats->push($stat);
	}
}

sub getsql_comma($$) {
	my($self,$info)=@_;
	my(@arra);
	for(my($i)=0;$i<$self->size();$i++) {
		my($curr)=$self->elem($i);
		push(@arra,$curr);
	}
	return("(".join(",",@arra).")");
}

sub TEST($) {
	my($context)=@_;
	return(1);
}

1;

__END__