1 package DBIx::Class::CDBICompat::ImaDBI;
5 use DBIx::ContextualFetch;
8 use base qw/Class::Data::Inheritable/;
10 __PACKAGE__->mk_classdata('_transform_sql_handler_order'
11 => [ qw/TABLE ESSENTIAL JOIN/ ] );
13 __PACKAGE__->mk_classdata('_transform_sql_handlers' =>
17 my ($self, $class, $data) = @_;
18 return $class->_table_name unless $data;
19 my ($f_class, $alias) = split(/=/, $data);
21 $self->{_classes}{$alias} = $f_class;
22 return $f_class->_table_name." ${alias}";
26 my ($self, $class, $data) = @_;
27 return join(' ', $class->columns('Essential')) unless $data;
28 return join(' ', $self->{_classes}{$data}->columns('Essential'));
32 my ($self, $class, $data) = @_;
33 my ($from, $to) = split(/ /, $data);
34 my ($from_class, $to_class) = @{$self->{_classes}}{$from, $to};
35 my ($rel_obj) = grep { $_->{class} && $_->{class} eq $to_class }
36 values %{ $from_class->_relationships };
38 ($from, $to) = ($to, $from);
39 ($from_class, $to_class) = ($to_class, $from_class);
40 ($rel_obj) = grep { $_->{class} && $_->{class} eq $to_class }
41 values %{ $from_class->_relationships };
43 $self->throw( "No relationship to JOIN from ${from_class} to ${to_class}" )
47 _aliases => { self => $from, foreign => $to },
50 my $join = $from_class->storage->sql_maker->where(
51 $from_class->resolve_condition($rel_obj->{cond}, $attrs) );
52 $join =~ s/^\s*WHERE//i;
59 return $_[0]->storage->dbh;
63 my ($class, @info) = @_;
64 $info[3] = { %{ $info[3] || {}} };
65 $info[3]->{RootClass} = 'DBIx::ContextualFetch';
66 return $class->NEXT::connection(@info);
70 return $_[0]->storage->dbh->{Driver}->{Name};
74 my ($class, $name, $sql) = @_;
75 my $table = $class->_table_name;
76 #$sql =~ s/__TABLE__/$table/;
78 *{"${class}::sql_${name}"} =
82 return $class->storage->sth($class->transform_sql($sql, @_));
84 if ($sql =~ /select/i) {
85 my $meth = "sql_${name}";
86 *{"${class}::search_${name}"} =
88 my ($class, @args) = @_;
89 my $sth = $class->$meth;
91 return $class->sth_to_objects($sth);
97 my ($class, $sth) = @_;
98 my @cols = $class->_select_columns;
100 while (my @row = $sth->fetchrow_array) {
101 push(@ret, $class->_row_to_object(\@cols,\@row));
107 my ($class, $sql, @args) = @_;
108 my $table = $class->_table_name;
110 foreach my $key (@{$class->_transform_sql_handler_order}) {
111 my $h = $class->_transform_sql_handlers->{$key};
112 $sql =~ s/__$key(?:\(([^\)]+)\))?__/$h->($attrs, $class, $1)/eg;
115 return sprintf($sql, @args);
118 package DBIx::ContextualFetch::st;
120 no warnings 'redefine';
122 sub _untaint_execute {
124 my $old_value = $sth->{Taint};
128 no warnings 'uninitialized';
129 $ret = $sth->SUPER::execute(@_);
131 $sth->{Taint} = $old_value;