DBI::Custom::MySQL - DBI::Custom MySQL implementation

NAME

DBI::Custom::MySQL - DBI::Custom MySQL implementation

Back to Top

VERSION

Version 0.0101

Back to Top

SYNOPSIS

    # New
    my $dbi = DBI::Custom::MySQL->new(user => 'taro', $password => 'kliej&@K',
                                      database => 'sample_db');
    # Insert 
    $dbi->insert('books', {title => 'perl', author => 'taro'});
    
    # Update 
    # same as 'update books set (title = 'aaa', author = 'ken') where id = 5;
    $dbi->update('books', {title => 'aaa', author => 'ken'}, {id => 5});
    
    # Delete
    $dbi->delete('books', {author => 'taro'});
    
    # select * from books;
    $dbi->select('books');
    
    # select * from books where ahthor = 'taro'; 
    $dbi->select('books', {author => 'taro'});

Back to Top

CAUTION

This module automatically encode_utf8 or decode_utf8 If you do not want to this, you set


    $dbi->bind_filter(undef);
    $dbi->fetch_filter(undef);

Back to Top

OBJECT METHOD

connect

    This method override DBI::Custom::connect
    
    If database is set, automatically data source is created and connect

Back to Top

AUTHOR

Yuki Kimoto, <kimoto.yuki at gmail.com>

Github http://github.com/yuki-kimoto

Back to Top

COPYRIGHT & LICENSE

Copyright 2009 Yuki Kimoto, all rights reserved.

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

Back to Top

 DBI::Custom::MySQL - DBI::Custom MySQL implementation