use Test::More; use strict; use warnings; use utf8; use Encode qw/decode encode/; BEGIN { eval { require DBD::SQLite; 1 } or plan skip_all => 'DBD::SQLite required'; eval { DBD::SQLite->VERSION >= 1 } or plan skip_all => 'DBD::SQLite >= 1.00 required'; plan 'no_plan'; use_ok('DBIx::Custom'); } # Function for test name my $test; sub test { $test = shift; } # Constant varialbes for test my $CREATE_TABLE = { 0 => 'create table table1 (key1 char(255), key2 char(255));', 1 => 'create table table1 (key1 char(255), key2 char(255), key3 char(255), key4 char(255), key5 char(255));', 2 => 'create table table2 (key1 char(255), key3 char(255));' }; my $SELECT_TMPL = { 0 => 'select * from table1;' }; my $DROP_TABLE = { 0 => 'drop table table1' }; my $NEW_ARGS = { 0 => {data_source => 'dbi:SQLite:dbname=:memory:'} }; # Variables for test my $dbi; my $decoded_str; my $encoded_str; my $array; use DBIx::Custom::Basic; test 'Filter'; $dbi = DBIx::Custom::Basic->new($NEW_ARGS->{0}); ok($dbi->filters->{encode_utf8}, "$test : exists default_bind_filter"); ok($dbi->filters->{decode_utf8}, "$test : exists default_fetch_filter"); $dbi->utf8_filter_on; is($dbi->bind_filter, $dbi->filters->{encode_utf8}, 'default bind filter'); is($dbi->fetch_filter, $dbi->filters->{decode_utf8}, 'default fetch filter'); $decoded_str = 'あ'; $encoded_str = $dbi->bind_filter->($decoded_str); is($encoded_str, encode('UTF-8', $decoded_str), 'encode utf8'); is($decoded_str, $dbi->fetch_filter->('', $encoded_str), "$test : fetch_filter");