The Perl and Raku Conference 2025: Greenville, South Carolina - June 27-29 Learn more

PORTA / Jorge-0.05 / lib / Jorge / DB.pm 

            

              
1
2
3
4
5
6
7
8
—
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
—
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163

              
package Jorge::DB;
use DBI;
use Jorge::Config;
use warnings;
use strict;
=head1 NAME
Jorge::DB - Interface to Database. Currently suporting MySQL.
=head1 VERSION
Version 0.01
=cut
our $VERSION = '0.01';
my $c = new Jorge::Config;
sub new {
        my $class = shift;
        my $db = $c->get_database;
        my $struct = {
                _dbh => DBI->connect(
                                                'dbi:mysql:database=' . $db->{db} . ';host=' . $db->{host} . ';port=3306',
                                                $db->{user},
                                                $db->{password}
                                        )
        };
    my $self = bless $struct, $class;
    return $self;
}
sub get_dbh {
    my $self = shift;
    return $self->{_dbh};
}
sub execute {
    my $self     = shift;
    my $db_query = shift;
    my @params = @_;
    my $dbh = $self->get_dbh;
    my $sth = $dbh->prepare($db_query);
    if ( $sth->execute(@params) ) {
        return $sth;
    }
    else {
        print STDERR $dbh->{err};
        return 0;
    }
}
sub prepare {
    my $self  = shift;
    my $query = shift;
    my $dbh   = $self->get_dbh;
    return $dbh->prepare($query);
}
sub get_last_insert_id {
    my $self = shift;
    my $dbh  = $self->get_dbh;
    return $dbh->{'mysql_insertid'};
}
sub execute_prepared {
    my $self = shift;
    my $sth  = shift;
    my @params = @_;
    $sth->execute(@params);
    if ( $self->{_dbh}->errstr ) {
        warn '***ERROR: ' . $self->{_dbh}->errstr . ' : ' . $sth->{Statement};
    }
    return $sth;
}
sub errstr {
    my $self = shift;
    return $self->{_dbh}->errstr;
}
=head1 SYNOPSIS
It is not expected accessing to this package directly. So, move to main
Jorge docs for reference.
=head1 AUTHORS
Mondongo, C<< <mondongo at gmail.com> >> Did the important job and started 
this beauty.
Julian Porta, C<< <julian.porta at gmail.com> >> took the code and tried 
to make it harder, better, faster, stronger.
=head1 BUGS
Please report any bugs or feature requests to C<bug-jorge at rt.cpan.org>,
or through the web interface at 
 L<http://rt.cpan.org/NoAuth/ReportBug.html?Queue=Jorge>.  
I will be notified, and then you'll
automatically be notified of progress on your bug as I make changes.
=head1 SUPPORT
You can find documentation for this module with the perldoc command.
    perldoc Jorge
You can also look for information at:
=over 4
=item * Github Project Page
L<http://github.com/Porta/Jorge/tree/master>
=item * RT: CPAN's request tracker
L<http://rt.cpan.org/NoAuth/Bugs.html?Dist=Jorge>
=item * AnnoCPAN: Annotated CPAN documentation
L<http://annocpan.org/dist/Jorge>
=item * CPAN Ratings
L<http://cpanratings.perl.org/d/Jorge>
=item * Search CPAN
L<http://search.cpan.org/dist/Jorge/>
=back
=head1 ACKNOWLEDGEMENTS
Mondongo C<< <mondongo at gmail.com> >> For starting this.
=head1 COPYRIGHT & LICENSE
Copyright 2009 Julian Porta, all rights reserved.
This program is free software; you can redistribute it and/or modify it
under the same terms as Perl itself.
=cut
1;    # End of Jorge::::DB