lib/A3C/SQL.pm

package A3C::SQL;

use strict;
use warnings;

use base qw(Jifty::Object Class::Accessor::Fast);
__PACKAGE__->mk_accessors( qw(query arguments dbh encoding) );

use Data::Dump qw/dump/;

=head1 NAME

A3C::SQL

=head1 DESCRIPTION

Issue SQL queries

=head1 METHODS

=head2 new

  my $sql = A3C::SQL->new({ query => 'select now()' });

As a alternative, if you don't want to use Jifty's database handle,
specify it like this:

  my $sql = A3C::SQL->new({
        query => 'select now()',
        dbh => $my_dbh,
        encoding => 'UTF-8',
  });

=head2 sth

Execute query and return statement handle. Ususally you don't have to call this manually.

=cut

sub sth {
        my $self = shift;
        if ( ! $self->{_sth} ) {
                my $dbh = $self->dbh || Jifty->handle->dbh;
                my $sth = $dbh->prepare( $self->query ) or $dbh->errstr;
                if ( $self->arguments ) {
                        Jifty->log->debug( $self->sql . ' arguments: ' . dump( $self->arguments ) );
                        $sth->execute( $self->arguments ) or die $dbh->errstr;
                } else {
                        $sth->execute or die $dbh->errstr;
                }
                $self->{_sth} = $sth;
        }

        return $self->{_sth};
}

=head2 next

  while ( my $row = $sql->next ) {
        print $row->now;
  }

=cut

sub next {
        my $self = shift;
        my $row = $self->sth->fetchrow_hashref;
        return unless defined $row;
        return A3C::SQL::row->new( $row, $self->encoding );
}

=head2 count

  print $sql->count;

=cut

sub count {
        my $self = shift;
        return $self->sth->rows;
}

=head1 HELPERS

This helpers are accessor to L<DBI>

=head2 _column_names

  my @columns = $sql->_column_names;

=cut

sub _column_names {
        my $self = shift;
        return @{ $self->sth->{NAME} };
}

package A3C::SQL::row;

use Encode qw/decode/;
use Data::Dump qw/dump/;
use base qw/Jifty::Object/;

our $AUTOLOAD;

sub new {
        my $that  = shift;
        my $class = ref($that) || $that;
        my $self = shift;
        bless $self, $class;
        $self->{__encoding} = shift || 'UTF-8';
        return $self;
}  

sub AUTOLOAD {
        my $self = shift;
        my $type = ref($self) or die "$self is not an object";
        my $name = $AUTOLOAD;
        $name =~ s/.*://;
        Jifty->log->error("SQL: $name doesn't exist") unless defined($self->{$name});
        return decode( $self->{__encoding}, $self->{$name} );
}

sub DESTROY {}

1;
1	dpavlin	78	package A3C::SQL;
2
3			use strict;
4			use warnings;
5
6	dpavlin	145	use base qw(Jifty::Object Class::Accessor::Fast);
7	dpavlin	162	__PACKAGE__->mk_accessors( qw(query arguments dbh encoding) );
8	dpavlin	145
9			use Data::Dump qw/dump/;
10
11	dpavlin	78	=head1 NAME
12
13			A3C::SQL
14
15			=head1 DESCRIPTION
16
17			Issue SQL queries
18
19			=head1 METHODS
20
21			=head2 new
22
23			my $sql = A3C::SQL->new({ query => 'select now()' });
24
25	dpavlin	145	As a alternative, if you don't want to use Jifty's database handle,
26			specify it like this:
27	dpavlin	78
28	dpavlin	145	my $sql = A3C::SQL->new({
29			query => 'select now()',
30			dbh => $my_dbh,
31	dpavlin	162	encoding => 'UTF-8',
32	dpavlin	145	});
33	dpavlin	78
34			=head2 sth
35
36			Execute query and return statement handle. Ususally you don't have to call this manually.
37
38			=cut
39
40			sub sth {
41			my $self = shift;
42			if ( ! $self->{_sth} ) {
43	dpavlin	145	my $dbh = $self->dbh \|\| Jifty->handle->dbh;
44	dpavlin	78	my $sth = $dbh->prepare( $self->query ) or $dbh->errstr;
45			if ( $self->arguments ) {
46			Jifty->log->debug( $self->sql . ' arguments: ' . dump( $self->arguments ) );
47	dpavlin	160	$sth->execute( $self->arguments ) or die $dbh->errstr;
48	dpavlin	78	} else {
49	dpavlin	160	$sth->execute or die $dbh->errstr;
50	dpavlin	78	}
51			$self->{_sth} = $sth;
52			}
53
54			return $self->{_sth};
55			}
56
57			=head2 next
58
59			while ( my $row = $sql->next ) {
60			print $row->now;
61			}
62
63			=cut
64
65			sub next {
66			my $self = shift;
67			my $row = $self->sth->fetchrow_hashref;
68			return unless defined $row;
69	dpavlin	162	return A3C::SQL::row->new( $row, $self->encoding );
70	dpavlin	78	}
71
72			=head2 count
73
74			print $sql->count;
75
76			=cut
77
78			sub count {
79			my $self = shift;
80			return $self->sth->rows;
81			}
82
83	dpavlin	159	=head1 HELPERS
84
85			This helpers are accessor to L<DBI>
86
87			=head2 _column_names
88
89			my @columns = $sql->_column_names;
90
91			=cut
92
93			sub _column_names {
94			my $self = shift;
95			return @{ $self->sth->{NAME} };
96			}
97
98	dpavlin	78	package A3C::SQL::row;
99
100			use Encode qw/decode/;
101			use Data::Dump qw/dump/;
102	dpavlin	159	use base qw/Jifty::Object/;
103	dpavlin	78
104			our $AUTOLOAD;
105
106			sub new {
107			my $that = shift;
108			my $class = ref($that) \|\| $that;
109			my $self = shift;
110			bless $self, $class;
111	dpavlin	162	$self->{__encoding} = shift \|\| 'UTF-8';
112	dpavlin	78	return $self;
113			}
114
115			sub AUTOLOAD {
116			my $self = shift;
117			my $type = ref($self) or die "$self is not an object";
118			my $name = $AUTOLOAD;
119			$name =~ s/.*://;
120	dpavlin	159	Jifty->log->error("SQL: $name doesn't exist") unless defined($self->{$name});
121	dpavlin	162	return decode( $self->{__encoding}, $self->{$name} );
122	dpavlin	78	}
123
124	dpavlin	82	sub DESTROY {}
125
126	dpavlin	78	1;