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

FreeBSD Manual Pages

  
 
  

home | help
DBIx::Class::Storage::User:Contributed PerlDBIx::Class::Storage::DBI::mysql(3)

NAME
       DBIx::Class::Storage::DBI::mysql	- Storage::DBI class implementing
       MySQL specifics

SYNOPSIS
       Storage::DBI autodetects	the underlying MySQL database, and re-blesses
       the $storage object into	this class.

	 my $schema = MyApp::Schema->connect( $dsn, $user, $pass, { on_connect_call => 'set_strict_mode' } );

DESCRIPTION
       This class implements MySQL specific bits of DBIx::Class::Storage::DBI,
       like AutoIncrement column support and savepoints. Also it augments the
       SQL maker to support the	MySQL-specific "STRAIGHT_JOIN" join type,
       which you can use by specifying "join_type => 'straight'" in the
       relationship attributes

       It also provides	a one-stop on-connect macro "set_strict_mode" which
       sets session variables such that	MySQL behaves more predictably as far
       as the SQL standard is concerned.

STORAGE	OPTIONS
   set_strict_mode
       Enables session-wide strict options upon	connecting. Equivalent to:

	 ->connect ( ... , {
	   on_connect_do => [
	     q|SET SQL_MODE = CONCAT('ANSI,TRADITIONAL,ONLY_FULL_GROUP_BY,', @@sql_mode)|,
	     q|SET SQL_AUTO_IS_NULL = 0|,
	   ]
	 });

FURTHER	QUESTIONS?
       Check the list of additional DBIC resources.

COPYRIGHT AND LICENSE
       This module is free software copyright by the DBIx::Class (DBIC)
       authors.	You can	redistribute it	and/or modify it under the same	terms
       as the DBIx::Class library.

perl v5.32.0			  2020-03-2DBIx::Class::Storage::DBI::mysql(3)

NAME | SYNOPSIS | DESCRIPTION | STORAGE OPTIONS | FURTHER QUESTIONS? | COPYRIGHT AND LICENSE

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

home | help