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
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
|
package DBIx::DBSchema::DBD::Sybase;
use strict;
use vars qw($VERSION @ISA %typemap);
use DBIx::DBSchema::DBD;
$VERSION = '0.04';
@ISA = qw(DBIx::DBSchema::DBD);
%typemap = (
# 'empty' => 'empty'
);
=head1 NAME
DBIx::DBSchema::DBD::Sybase - Sybase database driver for DBIx::DBSchema
=head1 SYNOPSIS
use DBI;
use DBIx::DBSchema;
$dbh = DBI->connect('dbi:Sybase:dbname=database', 'user', 'pass');
$schema = new_native DBIx::DBSchema $dbh;
=head1 DESCRIPTION
This module implements a Sybase driver for DBIx::DBSchema.
=cut
sub columns {
my($proto, $dbh, $table) = @_;
my $sth = $dbh->prepare("sp_columns \@table_name=$table")
or die $dbh->errstr;
$sth->execute or die $sth->errstr;
my @cols = map {
[
$_->{'column_name'},
$_->{'type_name'},
($_->{'nullable'} ? 1 : ''),
$_->{'length'},
'', #default
'' #local
]
} @{ $sth->fetchall_arrayref({}) };
$sth->finish;
@cols;
}
sub primary_key {
return("StubbedPrimaryKey");
}
sub unique {
my($proto, $dbh, $table) = @_;
my $gratuitous = { map { $_ => [ $proto->_index_fields($dbh, $table, $_ ) ] }
grep { $proto->_is_unique($dbh, $_ ) }
$proto->_all_indices($dbh, $table)
};
}
sub index {
my($proto, $dbh, $table) = @_;
my $gratuitous = { map { $_ => [ $proto->_index_fields($dbh, $table, $_ ) ] }
grep { ! $proto->_is_unique($dbh, $_ ) }
$proto->_all_indices($dbh, $table)
};
}
sub _all_indices {
my($proto, $dbh, $table) = @_;
my $sth = $dbh->prepare_cached(<<END) or die $dbh->errstr;
SELECT name
FROM sysindexes
WHERE id = object_id('$table') and indid between 1 and 254
END
$sth->execute or die $sth->errstr;
my @indices = map { $_->[0] } @{ $sth->fetchall_arrayref() };
$sth->finish;
$sth = undef;
@indices;
}
sub _index_fields {
my($proto, $dbh, $table, $index) = @_;
my @keys;
my ($indid) = $dbh->selectrow_array("select indid from sysindexes where id = object_id('$table') and name = '$index'");
for (1..30) {
push @keys, $dbh->selectrow_array("select index_col('$table', $indid, $_)") || ();
}
return @keys;
}
sub _is_unique {
my($proto, $dbh, $table, $index) = @_;
my ($isunique) = $dbh->selectrow_array("select status & 2 from sysindexes where id = object_id('$table') and name = '$index'");
return $isunique;
}
sub tables {
my($proto, $dbh) = @_;
my $sth = $dbh->prepare("sp_tables NULL, NULL, NULL, \"'TABLE'\"");
$sth->execute
or die $dbh->errstr;
$proto->SUPER::tables($dbh, $sth);
}
=head1 AUTHOR
Charles Shapiro <charles.shapiro@numethods.com>
(courtesy of Ivan Kohler <ivan-dbix-dbschema@420.am>)
Mitchell Friedman <mitchell.friedman@numethods.com>
Bernd Dulfer <bernd@widd.de>
Nathan Anderson <http://1id.com/=nathan.anderson>
=head1 COPYRIGHT
Copyright (c) 2001 Charles Shapiro, Mitchell J. Friedman
Copyright (c) 2001 nuMethods LLC.
All rights reserved.
This program is free software; you can redistribute it and/or modify it under
the same terms as Perl itself.
=head1 BUGS
Yes.
The B<primary_key> method does not yet work.
=head1 SEE ALSO
L<DBIx::DBSchema>, L<DBIx::DBSchema::DBD>, L<DBI>, L<DBI::DBD>
=cut
1;
|
