|
packaging one directory
|
1 |
package DBIx::Custom::MySQL; |
| 2 |
use base 'DBIx::Custom::Basic'; |
|
| 3 | ||
| 4 |
use warnings; |
|
| 5 |
use strict; |
|
| 6 | ||
| 7 |
my $class = __PACKAGE__; |
|
| 8 | ||
| 9 |
$class->add_format( |
|
| 10 |
datetime => $class->formats->{SQL99_datetime},
|
|
| 11 |
date => $class->formats->{SQL99_date},
|
|
| 12 |
time => $class->formats->{SQL99_time},
|
|
| 13 |
); |
|
| 14 | ||
| 15 | ||
| 16 |
sub connect {
|
|
| 17 |
my $self = shift; |
|
| 18 |
|
|
| 19 |
if (!$self->data_source && (my $database = $self->database)) {
|
|
| 20 |
$self->data_source("dbi:mysql:dbname=$database");
|
|
| 21 |
} |
|
| 22 |
|
|
| 23 |
return $self->SUPER::connect; |
|
| 24 |
} |
|
| 25 | ||
| 26 |
=head1 NAME |
|
| 27 | ||
| 28 |
DBIx::Custom::MySQL - DBIx::Custom MySQL implementation |
|
| 29 | ||
| 30 |
=head1 Version |
|
| 31 | ||
| 32 |
Version 0.0102 |
|
| 33 | ||
| 34 |
=head1 Synopsys |
|
| 35 | ||
| 36 |
# New |
|
| 37 |
my $dbi = DBIx::Custom::MySQL->new(user => 'taro', $password => 'kliej&@K', |
|
| 38 |
database => 'sample_db'); |
|
| 39 |
# Insert |
|
| 40 |
$dbi->insert('books', {title => 'perl', author => 'taro'});
|
|
| 41 |
|
|
| 42 |
# Update |
|
| 43 |
# same as 'update books set (title = 'aaa', author = 'ken') where id = 5; |
|
| 44 |
$dbi->update('books', {title => 'aaa', author => 'ken'}, {id => 5});
|
|
| 45 |
|
|
| 46 |
# Delete |
|
| 47 |
$dbi->delete('books', {author => 'taro'});
|
|
| 48 |
|
|
| 49 |
# select * from books; |
|
| 50 |
$dbi->select('books');
|
|
| 51 |
|
|
| 52 |
# select * from books where ahthor = 'taro'; |
|
| 53 |
$dbi->select('books', {author => 'taro'});
|
|
| 54 | ||
| 55 |
=head1 See DBIx::Custom and DBI::Custom::Basic documentation |
|
| 56 | ||
| 57 |
This class is L<DBIx::Custom::Basic> subclass, |
|
| 58 |
and L<DBIx::Custom::Basic> is L<DBIx::Custom> subclass. |
|
| 59 | ||
| 60 |
You can use all methods of L<DBIx::Custom::Basic> and <DBIx::Custom> |
|
| 61 |
Please see L<DBIx::Custom::Basic> and <DBIx::Custom> documentation. |
|
| 62 | ||
| 63 |
=head1 Object methods |
|
| 64 | ||
| 65 |
=head2 connect |
|
| 66 | ||
| 67 |
This method override DBIx::Custom::connect |
|
| 68 |
|
|
| 69 |
If database attribute is set, automatically data source is created and connect |
|
| 70 | ||
| 71 |
=head1 Author |
|
| 72 | ||
| 73 |
Yuki Kimoto, C<< <kimoto.yuki at gmail.com> >> |
|
| 74 | ||
| 75 |
Github L<http://github.com/yuki-kimoto> |
|
| 76 | ||
| 77 |
I develope this module L<http://github.com/yuki-kimoto/DBIx-Custom> |
|
| 78 | ||
| 79 |
=head1 Copyright & license |
|
| 80 | ||
| 81 |
Copyright 2009 Yuki Kimoto, all rights reserved. |
|
| 82 | ||
| 83 |
This program is free software; you can redistribute it and/or modify it |
|
| 84 |
under the same terms as Perl itself. |
|
| 85 | ||
| 86 |