Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
SQL::Maker::SelectSet(User Contributed Perl DocumentatSQL::Maker::SelectSet(3)

NAME
       SQL::Maker::SelectSet - provides	set functions

SYNOPSIS
	   use SQL::Maker::SelectSet qw(union_all except);
	   my $s1 = SQL::Maker::Select ->new()
				       ->add_select('foo')
				       ->add_from('t1');
	   my $s2 = SQL::Maker::Select ->new()
				       ->add_select('bar')
				       ->add_from('t2');
	   union_all( $s1, $s2 )->as_sql;
	   # =>
	   #  SQL::Maker::SelectSet->new_set(
	   #	  operator => 'UNION ALL',
	   #	  new_line => $s1->new_line
	   #  )->add_statement($s1)
	   #   ->add_statement($s2)
	   #   ->as_sql;
	   # =>	"SELECT	foo FROM t1 UNION ALL SELECT bar FROM t2"
	   except( $s1,	$s2 )->as_sql;
	   # =>	SQL::Maker::SelectSet->new_set(	operator => 'EXCEPT', new_line => $s1->new_line	)
	   #	 ->add_statement( $s1 )
	   #	 ->add_statement( $s2 )
	   #	 ->as_sql;
	   # =>	"SELECT	foo FROM t1 EXCEPT SELECT bar FROM t2"

DESCRIPTION
       This module provides some set functions which return a
       SQL::Maker::SelectSet object inherited from SQL::Maker::Select.

FUNCTION
       "union($select :SQL::Maker::Select | $set :SQL::Maker::SelectSet) :
       SQL::Maker::SelectSet"
	   Tow statements are combined by "UNION".

       "union_all($select :SQL::Maker::Select |	$set :SQL::Maker::SelectSet) :
       SQL::Maker::SelectSet"
	   Tow statements are combined by "UNION ALL".

       "intersect($select :SQL::Maker::Select |	$set :SQL::Maker::SelectSet) :
       SQL::Maker::SelectSet"
	   Tow statements are combined by "INTERSECT".

       "intersect_all($select :SQL::Maker::Select | $set
       :SQL::Maker::SelectSet) : SQL::Maker::SelectSet"
	   Tow statements are combined by "INTERSECT ALL".

       "except($select :SQL::Maker::Select | $set :SQL::Maker::SelectSet) :
       SQL::Maker::SelectSet"
	   Tow statements are combined by "EXCEPT".

       "except($select :SQL::Maker::Select | $set :SQL::Maker::SelectSet) :
       SQL::Maker::SelectSet"
	   Tow statements are combined by "EXCEPT ALL".

Class Method
       my $stmt	= SQL::Maker::SelectSet->new( %args )
	   $opretaor is	a set operator (ex. "UNION").  $one and	$another are
	   SQL::Maker::Select object or	SQL::Maker::SelectSet object.  It
	   returns a SQL::Maker::SelectSet object.

	   The parameters are:

	   $new_line
	       Default values is "\n".

	   $operator : Str
	       The operator. This parameter is required.

Instance Methods
       "my $sql	= $set->as_sql() : Str"
	   Returns a new select	statement.

       "my @binds = $set->bind() : Array[Str]"
	   Returns bind	variables.

       "$set->add_statement($stmt : $stmt->can('as_sql')) :
       SQL::Maker::SelectSet"
	   This	method adds new	statement object. $stmt	must provides 'as_sql'
	   method.

	   Return Value	is the $set itself.

SEE ALSO
       SQL::Maker::Select

perl v5.32.0			  2014-12-22	      SQL::Maker::SelectSet(3)

NAME | SYNOPSIS | DESCRIPTION | FUNCTION | Class Method | Instance Methods | SEE ALSO

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=SQL::Maker::SelectSet&sektion=3&manpath=FreeBSD+12.2-RELEASE+and+Ports>

home | help