alzabo::sqlmaker::mysql(3pm) [debian man page]

Alzabo::SQLMaker::MySQL(3pm)				User Contributed Perl Documentation			      Alzabo::SQLMaker::MySQL(3pm)

NAME

       Alzabo::SQLMaker::MySQL - Alzabo SQL making class for MySQL

SYNOPSIS

	 use Alzabo::SQLMaker;

	 my $sql = Alzabo::SQLMaker->new( sql => 'MySQL' );

DESCRIPTION

       This class implementes MySQL-specific SQL creation.  MySQL does not allow subselects.  Any attempt to use a subselect (by passing an "Alz-
       abo::SQMaker" object in as parameter to a method) will result in an "Alzabo::Exception::SQL" error.

METHODS

       Almost all of the functionality inherited from Alzabo::SQLMaker is used as is.  The only overridden methods are "limit()" and
       "get_limit()", as MySQL does allow for a "LIMIT" clause in its SQL.

EXPORTED SQL FUNCTIONS

       SQL may be imported by name or by tags.	They take arguments as documented in the MySQL documentation (version 3.23.39).  The functions
       (organized by tag) are:

       :math

	PI
	RAND
	MOD
	ROUND
	POW
	POWER
	ATAN2
	ABS
	SIGN
	FLOOR
	CEILING
	EXP
	LOG
	LOG10
	SQRT
	COS
	SIN
	TAN
	ACOS
	ASIN
	ATAN
	COT
	DEGREES
	RADIANS
	TRUNCATE

       :string

	CHAR
	POSITION
	INSTR
	LEFT
	RIGHT
	FIND_IN_SET
	REPEAT
	LEAST
	GREATEST
	CONCAT
	ELT
	FIELD
	MAKE_SET
	LOCATE
	SUBSTRING
	CONV
	LPAD
	RPAD
	MID
	SUBSTRING_INDEX
	REPLACE
	CONCAT_WS
	EXPORT_SET
	INSERT
	ASCII
	ORD
	BIN
	OCT
	HEX
	LENGTH
	OCTET_LENGTH
	CHAR_LENGTH
	CHARACTER_LENGTH
	TRIM
	LTRIM
	RTRIM
	SOUNDEX
	SPACE
	REVERSE
	LCASE
	LOWER
	UCASE
	UPPER

       :datetime

	CURDATE
	CURRENT_DATE
	CURTIME
	CURRENT_TIME
	NOW
	SYSDATE
	CURRENT_TIMESTAMP
	UNIX_TIMESTAMP
	WEEK
	PERIOD_ADD
	PERIOD_DIFF
	DATE_ADD
	DATE_SUB
	ADDDATE
	SUBDATE
	DATE_FORMAT
	TIME_FORMAT
	FROM_UNIXTIME
	DAYOFWEEK
	WEEKDAY
	DAYOFYEAR
	MONTH
	DAYNAME
	MONTHNAME
	QUARTER
	YEAR
	YEARWEEK
	HOUR
	MINUTE
	SECOND
	TO_DAYS
	FROM_DAYS
	SEC_TO_TIME
	TIME_TO_SEC

       :aggregate

       These are functions which operate on an aggregate set of values all at once.

	COUNT
	AVG
	MIN
	MAX
	SUM
	STD
	STDDEV

       :system

       These are functions which return information about the MySQL server.

	DATABASE
	USER
	SYSTEM_USER
	SESSION_USER
	VERSION
	CONNECTION_ID
	LAST_INSERT_ID
	GET_LOCK
	RELEASE_LOCK
	BENCHMARK
	MASTER_POS_WAIT

       :control

       These are flow control functions:

	IFNULL
	NULLIF
	IF

       :misc

       These are functions which don't fit into any other categories.

	ENCRYPT
	ENCODE
	DECODE
	FORMAT
	INET_NTOA
	INET_ATON
	BIT_OR
	BIT_AND
	PASSWORD
	MD5
	LOAD_FILE

       :fulltext

       These are functions related to MySQL's fulltext searching capabilities.

	MATCH
	AGAINST
	IN_BOOLEAN_MODE

       NOTE: In MySQL 4.0 and greater, it is possible to say that a search is in boolean mode in order to change how MySQL handles the argument
       given to AGAINST.  This will not work with earlier versions.

       :common

       These are functions from other groups that are most commonly used.

	NOW
	COUNT
	AVG
	MIN
	MAX
	SUM
	DISTINCT

AUTHOR

       Dave Rolsky, <dave@urth.org>

perl v5.8.8							    2007-12-23					      Alzabo::SQLMaker::MySQL(3pm)

Check Out this Related Man Page

Alzabo::Schema(3pm)					User Contributed Perl Documentation				       Alzabo::Schema(3pm)

NAME

       Alzabo::Schema - Schema objects

SYNOPSIS

	 use base qw(Alzabo::Schema);

DESCRIPTION

       This is the base class for schema objects..

METHODS

       name

       Returns a string containing the name of the schema.

       table ($name)

       Returns an "Alzabo::Table" object representing the specified table.

       An "Alzabo::Exception::Params" exception is throws if the schema does not contain the table.

       tables (@optional_list)

       If no arguments are given, this method returns a list of all "Alzabo::Table" objects in the schema, or in a scalar context the number of
       such tables.  If one or more arguments are given, returns a list of table objects with those names, in the same order given (or the number
       of such tables in a scalar context, but this isn't terribly useful).

       An "Alzabo::Exception::Params" exception is throws if the schema does not contain one or more of the specified tables.

       has_table ($name)

       Returns a boolean value indicating whether the table exists in the schema.

       begin_work

       Starts a transaction.  Calls to this function may be nested and it will be handled properly.

       rollback

       Rollback a transaction.

       commit

       Finishes a transaction with a commit.  If you make multiple calls to "begin_work()", make sure to call this method the same number of
       times.

       run_in_transaction ( sub { code... } )

       This method takes a subroutine reference and wraps it in a transaction.

       It will preserve the context of the caller and returns whatever the wrapped code would have returned.

       driver

       Returns the "Alzabo::Driver" object for the schema.

       rules

       Returns the "Alzabo::RDBMSRules" object for the schema.

       sqlmaker

       Returns the "Alzabo::SQLMaker" object for the schema.

AUTHOR

       Dave Rolsky, <autarch@urth.org>

perl v5.8.8							    2007-12-23						       Alzabo::Schema(3pm)

Linux and UNIX Man Pages

alzabo::sqlmaker::mysql(3pm) [debian man page]

Check Out this Related Man Page