| 1 | package DBIx::HoldMyPlace; | ||
| 2 | |||
| 3 | |||
| 4 | BEGIN { # TODO | ||
| 5 | unless ( caller(2) ) { # Modulino for development | ||
| 6 | exec q(cd ../..; prove ./t/); #run prove from dist root | ||
| 7 | } | ||
| 8 | } | ||
| 9 | |||
| 10 | use warnings; | ||
| 11 | use strict; | ||
| 12 | use Carp; | ||
| 13 | use PadWalker qw/closed_over peek_sub set_closed_over/; | ||
| 14 | use Data::Dump qw/pp/; | ||
| 15 | |||
| 16 | |||
| 17 | use version; | ||
| 18 | #BEGIN { | ||
| 19 | #use Exporter (); | ||
| 20 | use vars qw($VERSION @ISA @EXPORT @EXPORT_OK %EXPORT_TAGS); | ||
| 21 | $VERSION = qv('0.04.0'); | ||
| 22 | @ISA = qw(Exporter); | ||
| 23 | #Give a hoot don't pollute, do not export more than needed by default | ||
| 24 | @EXPORT = qw(hmp); | ||
| 25 | @EXPORT_OK = qw(); | ||
| 26 | %EXPORT_TAGS = (); | ||
| 27 | #} | ||
| 28 | |||
| 29 | |||
| 30 | # Module implementation here | ||
| 31 | |||
| 32 | |||
| 33 | sub import { | ||
| 34 | patch_dbi_connect(); | ||
| 35 | #warn pp \@_; | ||
| 36 | DBIx::HoldMyPlace->export_to_level(1, @_); | ||
| 37 | } | ||
| 38 | |||
| 39 | our @ref_list; # TODO better lexical closure var plus getter-sub | ||
| 40 | |||
| 41 | sub hmp (&) { | ||
| 42 | #die "called"; | ||
| 43 | my $DBG = 0; | ||
| 44 | |||
| 45 | my $lambda = shift; | ||
| 46 | my $h_vars = closed_over($lambda); | ||
| 47 | warn "CLOSED OVER", pp $h_vars if $DBG; | ||
| 48 | |||
| 49 | #warn $h_vars->{'$x'}; | ||
| 50 | |||
| 51 | # bless_scalar(${$h_vars->{'$x'}}); | ||
| 52 | #TEST::bless_scalar(${$h_vars->{'$y'}}); | ||
| 53 | |||
| 54 | while ( my ($val,$ref) = each %$h_vars) { | ||
| 55 | #my ($val,$ref) = ( ${$h_vars->{'$x'}}, $h_vars->{'$x'}); | ||
| 56 | warn "patch: ",$val if $DBG; | ||
| 57 | my $obj= ( | ||
| 58 | bless { | ||
| 59 | #val=>$val, | ||
| 60 | val => '?', | ||
| 61 | ref => $ref | ||
| 62 | } | ||
| 63 | , "DBIx::HoldMyPlace::Placeholder::Overload" | ||
| 64 | ); | ||
| 65 | $h_vars->{$val} = \$obj; | ||
| 66 | } | ||
| 67 | |||
| 68 | set_closed_over $lambda, $h_vars; | ||
| 69 | |||
| 70 | #warn ${$h_vars->{'$x'}}->{ref}; | ||
| 71 | |||
| 72 | #warn pp $h_vars; | ||
| 73 | |||
| 74 | #warn pp "$h_vars->{'$x'}"; | ||
| 75 | |||
| 76 | @DBIx::HoldMyPlace::Placeholder::Overload::ref_list = (); | ||
| 77 | my $string = $lambda->(); | ||
| 78 | my @refs = @DBIx::HoldMyPlace::Placeholder::Overload::ref_list; | ||
| 79 | #$h_vars->{'$x'} = \"X"; | ||
| 80 | #warn $h_vars->{'$x'}; | ||
| 81 | |||
| 82 | return [$string, \@refs]; | ||
| 83 | |||
| 84 | } | ||
| 85 | |||
| 86 | |||
| 87 | |||
| 88 | { | ||
| 89 | my $old_connect; | ||
| 90 | |||
| 91 | sub new_connect { | ||
| 92 | #Test::More::diag("TST CALLED"); | ||
| 93 | #warn "XXXX"; | ||
| 94 | |||
| 95 | my $dbh = $old_connect->(@_); | ||
| 96 | |||
| 97 | my $callbacks = | ||
| 98 | { | ||
| 99 | prepare => \&DBIx::HoldMyPlace::Callbacks::prepare, | ||
| 100 | ChildCallbacks => { | ||
| 101 | execute => \&DBIx::HoldMyPlace::ChildCallbacks::execute, | ||
| 102 | }, | ||
| 103 | } | ||
| 104 | ; | ||
| 105 | |||
| 106 | $dbh->{Callbacks} //= $callbacks; | ||
| 107 | |||
| 108 | #### TODO!!! Don't overwrite previous Callbacks | ||
| 109 | return $dbh; | ||
| 110 | |||
| 111 | } | ||
| 112 | |||
| 113 | sub patch_dbi_connect { | ||
| 114 | #### TODO check if DBI already loaded | ||
| 115 | $old_connect = \&DBI::connect; | ||
| 116 | |||
| 117 | |||
| 118 | no warnings 'redefine'; | ||
| 119 | *DBI::connect = \&new_connect | ||
| 120 | } | ||
| 121 | } | ||
| 122 | |||
| 123 | |||
| 124 | package DBIx::HoldMyPlace::Placeholder::Overload; | ||
| 125 | # use PadWalker qw/closed_over peek_sub set_closed_over/; | ||
| 126 | use Data::Dump qw/pp/; | ||
| 127 | |||
| 128 | our @ref_list; | ||
| 129 | |||
| 130 | use overload | ||
| 131 | '""' => sub { # stringification | ||
| 132 | #warn 'OL:"": ',pp \@_; | ||
| 133 | my ($l,$r,$f) = @_; | ||
| 134 | push @ref_list, $l; # keep object | ||
| 135 | |||
| 136 | $l->{val}; # return replacement like '?' | ||
| 137 | }; | ||
| 138 | ; | ||
| 139 | |||
| 140 | |||
| 141 | |||
| 142 | |||
| 143 | package DBIx::HoldMyPlace::Callbacks; | ||
| 144 | |||
| 145 | use Data::Dump qw/pp/; | ||
| 146 | use Scalar::Util qw/blessed/; | ||
| 147 | |||
| 148 | our $TEST; | ||
| 149 | our $DBG; | ||
| 150 | |||
| 151 | sub prepare { | ||
| 152 | my $DBG = 1; | ||
| 153 | #return; | ||
| 154 | my ( $obj, $query ) = \(@_) ; | ||
| 155 | my $meth = $_; | ||
| 156 | |||
| 157 | return unless blessed $$query; | ||
| 158 | warn "CB \U$meth: ",pp \@_ if $DBG ; | ||
| 159 | |||
| 160 | my $statement = $$query->{Statement}; | ||
| 161 | # tie $statement ,"HMP_TIE"; | ||
| 162 | |||
| 163 | # if (blessed $$query eq "HMP") { | ||
| 164 | # $$query = $statement; | ||
| 165 | # #$$obj->{private_HMP} = ["dummy"]; #$$query; | ||
| 166 | # $$obj->{Callbacks}{ChildCallbacks}{private_HMP} = $$query; | ||
| 167 | # } | ||
| 168 | |||
| 169 | return; # OK | ||
| 170 | |||
| 171 | } | ||
| 172 | |||
| 173 | |||
| 174 | |||
| 175 | |||
| 176 | package DBIx::HoldMyPlace::ChildCallbacks; | ||
| 177 | |||
| 178 | use Data::Dump qw/pp/; | ||
| 179 | use Scalar::Util qw/blessed/; | ||
| 180 | |||
| 181 | our $TEST; | ||
| 182 | our $DBG; | ||
| 183 | |||
| 184 | sub execute { | ||
| 185 | my $DBG = 0; | ||
| 186 | |||
| 187 | my $handle = $_[0] ; | ||
| 188 | #my @args = @_; | ||
| 189 | my $meth = $_; | ||
| 190 | |||
| 191 | my $hmp = $handle->{Statement}; | ||
| 192 | |||
| 193 | warn "CB \U$meth: ",pp [\@_] | ||
| 194 | if $DBG; | ||
| 195 | |||
| 196 | return | ||
| 197 | unless (blessed($handle->{Statement}) //"") eq "HMP"; | ||
| 198 | #unless exists $handle->{Callbacks}{private_HMP}; | ||
| 199 | |||
| 200 | |||
| 201 | |||
| 202 | |||
| 203 | warn pp $hmp; | ||
| 204 | |||
| 205 | #$handle->{Statement} = $hmp->{Statement}; | ||
| 206 | #@_ = @{ $hmp->{bind_vars} }; | ||
| 207 | |||
| 208 | # by value | ||
| 209 | $handle->bind_param(1, ${ $hmp->{bind_vars}[0] } ); | ||
| 210 | $handle->bind_param(2, ${ $hmp->{bind_vars}[1] } ); | ||
| 211 | |||
| 212 | # bidirectional for stored procedures | ||
| 213 | # $handle->bind_param_inout(1, $hmp->{bind_vars}[0],10000 ); | ||
| 214 | # not implemented in mysql | ||
| 215 | |||
| 216 | #$_[1] = "Rolf"; # HACK | ||
| 217 | |||
| 218 | |||
| 219 | #warn "CB \U$meth: ",pp [\@_] | ||
| 220 | # if $DBG; | ||
| 221 | |||
| 222 | return; # OK | ||
| 223 | } | ||
| 224 | |||
| 225 | |||
| 226 | |||
| 227 | 1; # Magic true value required at end of module | ||
| 228 | __END__ |