1 package DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server;
7 DBIx::Class::Storage::DBI::Sybase
8 DBIx::Class::Storage::DBI::MSSQL
11 use Carp::Clan qw/^DBIx::Class/;
13 __PACKAGE__->datetime_parser_type(
14 'DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server::DateTime::Format'
19 my $dbh = $self->_get_dbh;
21 return if ref $self ne __PACKAGE__;
22 if (not $self->_use_typeless_placeholders) {
24 DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server::NoBindVars;
26 'DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server::NoBindVars';
31 sub _run_connection_actions {
34 # LongReadLen doesn't work with MSSQL through DBD::Sybase, and the default is
35 # huge on some versions of SQL server and can cause memory problems, so we
36 # fix it up here (see ::DBI::Sybase.pm)
39 $self->next::method(@_);
45 $self->_get_dbh->do('BEGIN TRAN');
51 or $self->throw_exception('cannot COMMIT on a disconnected handle');
58 or $self->throw_exception('cannot ROLLBACK on a disconnected handle');
62 sub _get_server_version {
65 my $product_version = $self->_get_dbh->selectrow_hashref('master.dbo.xp_msver ProductVersion');
67 if ((my $version = $product_version->{Character_Value}) =~ /^(\d+)\./) {
71 $self->throw_exception(
72 "MSSQL Version Retrieval Failed, Your ProductVersion's Character_Value is missing or malformed!"
77 =head2 connect_call_datetime_setup
81 on_connect_call => 'datetime_setup'
83 In L<connect_info|DBIx::Class::Storage::DBI/connect_info> to set:
85 $dbh->syb_date_fmt('ISO_strict'); # output fmt: 2004-08-21T14:36:48.080Z
87 On connection for use with L<DBIx::Class::InflateColumn::DateTime>
89 This works for both C<DATETIME> and C<SMALLDATETIME> columns, although
90 C<SMALLDATETIME> columns only have minute precision.
95 my $old_dbd_warned = 0;
97 sub connect_call_datetime_setup {
99 my $dbh = $self->_get_dbh;
101 if ($dbh->can('syb_date_fmt')) {
102 # amazingly, this works with FreeTDS
103 $dbh->syb_date_fmt('ISO_strict');
104 } elsif (not $old_dbd_warned) {
105 carp "Your DBD::Sybase is too old to support ".
106 "DBIx::Class::InflateColumn::DateTime, please upgrade!";
113 package # hide from PAUSE
114 DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server::DateTime::Format;
116 my $datetime_parse_format = '%Y-%m-%dT%H:%M:%S.%3NZ';
117 my $datetime_format_format = '%Y-%m-%d %H:%M:%S.%3N'; # %F %T
119 my ($datetime_parser, $datetime_formatter);
123 require DateTime::Format::Strptime;
124 $datetime_parser ||= DateTime::Format::Strptime->new(
125 pattern => $datetime_parse_format,
128 return $datetime_parser->parse_datetime(shift);
131 sub format_datetime {
133 require DateTime::Format::Strptime;
134 $datetime_formatter ||= DateTime::Format::Strptime->new(
135 pattern => $datetime_format_format,
138 return $datetime_formatter->format_datetime(shift);
145 DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server - Support for Microsoft
146 SQL Server via DBD::Sybase
150 This subclass supports MSSQL server connections via L<DBD::Sybase>.
154 This driver tries to determine whether your version of L<DBD::Sybase> and
155 supporting libraries (usually FreeTDS) support using placeholders, if not the
156 storage will be reblessed to
157 L<DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server::NoBindVars>.
159 The MSSQL specific functionality is provided by
160 L<DBIx::Class::Storage::DBI::MSSQL>.
164 See L<DBIx::Class/CONTRIBUTORS>.
168 You may distribute this code under the same terms as Perl itself.