mitchjacksontech/dbix-class-schema-pgsettimezone

Set connection session timezone for DBIx::Class

NAME

DBIx::Class::Schema::PgSetTimezone

SYNOPSIS

# Define your Schema class
package MyApp::Schema;
use base qw/DBIx::Class::Schema::PgSetTimezone/;

__PACKAGE__->load_classes(qw/Arthur Ford Zaphod/);

# Initialize the schema
# (Only hashref connect_info style supported)
$schema = MyApp::Schema->connection({
  dsn => 'dbi:Pg:database=myapp',
  user => undef,
  pass => undef,
  auto_commit => 1,
  raise_error => 1,
)};

# Set time zone for the connection. SQL will be executed immediately,
# and on any further connect/reconnects
$schema->timezone('America/Chicago');

DESCRIPTION

Component for DBIx::Class::Schema

Set the connection time_zone in a way that persists within connection managers like DBIx::Connection and Catalyst::Model::DBIC::Schema

About Schema->connection() parameters

Schema->connection() supports several formats of parameter list

This module only supports a hashref parameter list, as in the synopsis

METHODS

timezone TIME_ZONE

Read or set the time zone string

METHODS Overload

connection %connect_info

Overload "connection" in DBIx::Class::Schema

Inserts a callback into "on_connect_call" in DBIx::Class::Storage::DBI

Use of this module requires using only the hashref style of connect_info arguments. Other connect_info formats are not supported. See "connect_info" in DBIx::Class::Storage::DBI

INTERNAL SUBS

__dbh_do_set_timezone $storage, $timezone

Execute sql statement to set session time zone

SEE ALSO

DBIx::Class::Schema, DBIx::Connection, Catalyst::Model::DBIC::Schema

COPYRIGHT

(c) 2019 Mitch Jackson [email protected] under the perl5 license