view release on metacpan or  search on metacpan

lib/DBIO/MySQL/Storage.pm  view on Meta::CPAN

=head2 connect_call_set_zero_date_permissive

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

Strips C<NO_ZERO_DATE> and C<NO_ZERO_IN_DATE> from the session C<sql_mode>
so C<0000-00-00> can be written under MySQL 8 strict mode. Installed as an
C<on_connect_call> it re-runs on every (re)connect, so the session actually
issuing the writes -- not merely the connection alive at deploy time --
carries the relaxed mode. This is the seam L</deploy_setup> delegates to.

=head2 deployment_statements

Overrides the base implementation to automatically pass C<mysql_version> to
the SQL::Translator producer args when deploying a schema, so that generated
DDL is compatible with the connected server version.

=head2 is_replicating