1DBIx::Class::Storage::DUBsIe:r:mCyosnqtlr(i3b)uted PerlDDBoIcxu:m:eCnltaastsi:o:nStorage::DBI::mysql(3)
2
3
4

NAME

6       DBIx::Class::Storage::DBI::mysql - Storage::DBI class implementing
7       MySQL specifics
8

SYNOPSIS

10       Storage::DBI autodetects the underlying MySQL database, and re-blesses
11       the $storage object into this class.
12
13         my $schema = MyApp::Schema->connect( $dsn, $user, $pass, { on_connect_call => 'set_strict_mode' } );
14

DESCRIPTION

16       This class implements MySQL specific bits of DBIx::Class::Storage::DBI,
17       like AutoIncrement column support and savepoints. Also it augments the
18       SQL maker to support the MySQL-specific "STRAIGHT_JOIN" join type,
19       which you can use by specifying "join_type => 'straight'" in the
20       relationship attributes
21
22       It also provides a one-stop on-connect macro "set_strict_mode" which
23       sets session variables such that MySQL behaves more predictably as far
24       as the SQL standard is concerned.
25

STORAGE OPTIONS

27   set_strict_mode
28       Enables session-wide strict options upon connecting. Equivalent to:
29
30         ->connect ( ... , {
31           on_connect_do => [
32             q|SET SQL_MODE = CONCAT('ANSI,TRADITIONAL,ONLY_FULL_GROUP_BY,', @@sql_mode)|,
33             q|SET SQL_AUTO_IS_NULL = 0|,
34           ]
35         });
36

FURTHER QUESTIONS?

38       Check the list of additional DBIC resources.
39
41       This module is free software copyright by the DBIx::Class (DBIC)
42       authors. You can redistribute it and/or modify it under the same terms
43       as the DBIx::Class library.
44
45
46
47perl v5.36.0                      2023-01-20DBIx::Class::Storage::DBI::mysql(3)
Impressum