1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
|
package DBIx::Class::Schema::Loader::DBI::Sybase::Common;
use strict;
use warnings;
use base 'DBIx::Class::Schema::Loader::DBI';
use Carp::Clan qw/^DBIx::Class/;
use Class::C3;
our $VERSION = '0.07000';
=head1 NAME
DBIx::Class::Schema::Loader::DBI::Sybase::Common - Common methods for Sybase
and MSSQL
=head1 DESCRIPTION
See L<DBIx::Class::Schema::Loader> and L<DBIx::Class::Schema::Loader::Base>.
=cut
# DBD::Sybase doesn't implement get_info properly
sub _build_quoter { '"' }
sub _build_namesep { '.' }
sub _setup {
my $self = shift;
$self->next::method(@_);
$self->schema->storage->sql_maker->quote_char([qw/[ ]/]);
$self->schema->storage->sql_maker->name_sep('.');
$self->{db_schema} ||= $self->_build_db_schema;
}
sub _build_db_schema {
my $self = shift;
my $dbh = $self->schema->storage->dbh;
local $dbh->{FetchHashKeyName} = 'NAME_lc';
my $test_table = "_loader_test_$$";
my $db_schema = 'dbo'; # default
eval {
$dbh->do("create table $test_table (id integer)");
my $sth = $dbh->prepare('sp_tables');
$sth->execute;
while (my $row = $sth->fetchrow_hashref) {
next unless $row->{table_name} eq $test_table;
$db_schema = $row->{table_owner};
last;
}
$sth->finish;
$dbh->do("drop table $test_table");
};
my $exception = $@;
eval { $dbh->do("drop table $test_table") };
carp "Could not determine db_schema, defaulting to $db_schema : $exception"
if $exception;
return $db_schema;
}
# remove 'IDENTITY' from column data_type
sub _columns_info_for {
my $self = shift;
my $result = $self->next::method(@_);
foreach my $col (keys %$result) {
$result->{$col}->{data_type} =~ s/\s* identity \s*//ix;
}
return $result;
}
=head1 SEE ALSO
L<DBIx::Class::Schema::Loader::DBI::Sybase>,
L<DBIx::Class::Schema::Loader::DBI::MSSQL>,
L<DBIx::Class::Schema::Loader::DBI::ODBC::Microsoft_SQL_Server>,
L<DBIx::Class::Schema::Loader::DBI::Sybase::Microsoft_SQL_Server>,
L<DBIx::Class::Schema::Loader::DBI>
L<DBIx::Class::Schema::Loader>, L<DBIx::Class::Schema::Loader::Base>,
=head1 AUTHOR
See L<DBIx::Class::Schema::Loader/AUTHOR> and L<DBIx::Class::Schema::Loader/CONTRIBUTORS>.
=head1 LICENSE
This library is free software; you can redistribute it and/or modify it under
the same terms as Perl itself.
=cut
1;
|
