NAME

SimpleDBI some function base DBI

support mysql

FUNCTION

new

    use SimpleDBI::mysql;
    use Encode;
    use utf8;

    my $mysql = SimpleDBI::mysql->new(
        db     => 'testdb',
        host   => '127.0.0.1',
        usr    => 'someusr',
        passwd => 'somepwd',
        #enable_utf8 => 1, 
    );

query_db

    my $data = $mysql->query_db('select * from sometable limit 2', 
    result_type => 'arrayref',  # arrayref, hashref, file

    #attr => ..., # sql query attr, 
    #bind_values => ..., # sql query bind values, 

    #hash_key => [ qw/id prov/ ],  #hashref key 

    #file => 'sometable.txt',  # file name
    #sep => ',', 
    );

    print encode( 'utf8' , $_ ), "\n" for @{ $data->[0] };

load_table

    my $test_file = 'xxx.txt';
    my $test_data = [ [qw/1 测试/], [qw/2 无聊/], ];
    $mysql->load_table(
        $test_data, # or $test_file, 
        table   => 'testtable',
        fields  => [qw/id name/],

        #db  => 'otherdb',
        #charset => 'utf8',
        #replace => 0, 

        #sep => ',', 
    );