1 package DBIx::Class::CDBICompat::ImaDBI;
5 use DBIx::ContextualFetch;
7 use base qw/DBIx::Class/;
9 __PACKAGE__->mk_classdata('_transform_sql_handler_order'
10 => [ qw/TABLE ESSENTIAL JOIN/ ] );
12 __PACKAGE__->mk_classdata('_transform_sql_handlers' =>
16 my ($self, $class, $data) = @_;
17 return $class->_table_name unless $data;
18 my ($f_class, $alias) = split(/=/, $data);
20 $self->{_classes}{$alias} = $f_class;
21 return $f_class->_table_name." ${alias}";
25 my ($self, $class, $data) = @_;
26 return join(' ', $class->columns('Essential')) unless $data;
27 return join(' ', $self->{_classes}{$data}->columns('Essential'));
31 my ($self, $class, $data) = @_;
32 my ($from, $to) = split(/ /, $data);
33 my ($from_class, $to_class) = @{$self->{_classes}}{$from, $to};
34 my ($rel_obj) = grep { $_->{class} && $_->{class} eq $to_class }
35 values %{ $from_class->_relationships };
37 ($from, $to) = ($to, $from);
38 ($from_class, $to_class) = ($to_class, $from_class);
39 ($rel_obj) = grep { $_->{class} && $_->{class} eq $to_class }
40 values %{ $from_class->_relationships };
42 $self->throw( "No relationship to JOIN from ${from_class} to ${to_class}" )
46 _aliases => { self => $from, foreign => $to },
49 my $join = $from_class->storage->sql_maker->_join_condition(
50 $from_class->resolve_condition($rel_obj->{cond}, $attrs) );
57 return $_[0]->storage->dbh;
61 my ($class, @info) = @_;
62 $info[3] = { %{ $info[3] || {}} };
63 $info[3]->{RootClass} = 'DBIx::ContextualFetch';
64 return $class->next::method(@info);
68 return $_[0]->storage->dbh->{Driver}->{Name};
72 my ($class, $name, $sql) = @_;
73 my $table = $class->_table_name;
74 #$sql =~ s/__TABLE__/$table/;
76 *{"${class}::sql_${name}"} =
80 return $class->storage->sth($class->transform_sql($sql, @_));
82 if ($sql =~ /select/i) {
83 my $meth = "sql_${name}";
84 *{"${class}::search_${name}"} =
86 my ($class, @args) = @_;
87 my $sth = $class->$meth;
89 return $class->sth_to_objects($sth);
95 my ($class, $sth) = @_;
96 my @cols = $class->_select_columns;
98 while (my @row = $sth->fetchrow_array) {
99 push(@ret, $class->_row_to_object(\@cols,\@row));
105 my ($class, $sql, @args) = @_;
106 my $table = $class->_table_name;
108 foreach my $key (@{$class->_transform_sql_handler_order}) {
109 my $h = $class->_transform_sql_handlers->{$key};
110 $sql =~ s/__$key(?:\(([^\)]+)\))?__/$h->($attrs, $class, $1)/eg;
113 return sprintf($sql, @args);
116 package DBIx::ContextualFetch::st;
118 no warnings 'redefine';
120 sub _untaint_execute {
122 my $old_value = $sth->{Taint};
126 no warnings 'uninitialized';
127 $ret = $sth->SUPER::execute(@_);
129 $sth->{Taint} = $old_value;