1 package CPANPLUS::Internals::Source::SQLite::Tie;
8 use CPANPLUS::Module::Fake;
9 use CPANPLUS::Module::Author::Fake;
10 use CPANPLUS::Internals::Constants;
13 use Params::Check qw[check];
14 use Module::Load::Conditional qw[can_load];
15 use Locale::Maketext::Simple Class => 'CPANPLUS', Style => 'gettext';
19 $Data::Dumper::Indent = 1;
23 push @ISA, 'Tie::StdHash';
31 dbh => { required => 1 },
32 table => { required => 1 },
33 key => { required => 1 },
34 cb => { required => 1 },
35 offset => { default => 0 },
38 my $args = check( $tmpl, \%hash ) or return;
39 my $obj = bless { %$args, store => {} } , $class;
46 my $key = shift or return;
47 my $dbh = $self->{dbh};
49 my $table = $self->{table};
52 ### did we look this one up before?
53 if( my $obj = $self->{store}->{$key} ) {
57 my $res = $dbh->query(
58 "SELECT * from $table where $self->{key} = ?", $key
64 my $href = $res->hash;
66 ### get rid of the primary key
70 return unless keys %$href;
72 ### expand author if needed
73 ### XXX no longer generic :(
74 if( $table eq 'module' ) {
75 $href->{author} = $cb->author_tree( $href->{author } ) or return;
79 module => 'CPANPLUS::Module',
80 author => 'CPANPLUS::Module::Author',
83 my $obj = $self->{store}->{$key} = $class->new( %$href, _id => $cb->_id );
93 $self->{store}->{$key} = $val;
100 my $dbh = $self->{'dbh'};
102 my $res = $dbh->query(
103 "select $self->{key} from $self->{table} order by $self->{key} limit 1"
108 my $key = $res->flat->[0];
115 my $dbh = $self->{'dbh'};
117 my $res = $dbh->query(
118 "select $self->{key} from $self->{table} ".
119 "order by $self->{key} limit 1 offset $self->{offset}"
124 my $key = $res->flat->[0];
125 my $val = $self->FETCH( $key );
127 ### use each() semantics
128 return wantarray ? ( $key, $val ) : $key;
131 sub EXISTS { !!$_[0]->FETCH( $_[1] ) }
135 my $dbh = $self->{'dbh'};
137 my $res = $dbh->query( "select count(*) from $self->{table}" );
142 ### intentionally left blank