NAME

DBIx::Custom::Basic - DBIx::Custom basic implementation

SYNOPSYS

# New
my $dbi = DBIx::Custom::Basic->new(
    data_source => "dbi:mysql:database=books",
    user        => 'ken',
    password    => '!LFKD%$&'
);

METHODS

This class is DBIx::Custom subclass. You can use all methods of DBIx::Custom

utf8_filter_on

Encode and decode utf8 filter on

$dbi->utf8_filter_on;

This equel to

$dbi->bind_filter($dbi->filters->{encode_utf8});
$dbi->fetch_filter($dbi->filters->{decode_utf8});

FILTERS

encode_utf8

Encode internal string to UTF-8 byte stream If need, utf8::upgrade is also done.

$dbi->filters->{encode_utf8}->($value);

This filter is generally used as bind filter

$dbi->bind_filter($dbi->filters->{encode_utf8});

decode_utf8

Decode UTF-8 byte stream to internal string $dbi->filters->{decode_utf8}->($value);

This filter is generally used as fetch filter

$dbi->fetch_filter($dbi->filters->{decode_utf8});

DATE FORMATS

strptime formats is available

# format name        format
'SQL99_date'         '%Y-%m-%d',
'SQL99_datetime'     '%Y-%m-%d %H:%M:%S',
'SQL99_time'         '%H:%M:%S',
'ISO-8601_date'      '%Y-%m-%d',
'ISO-8601_datetime'  '%Y-%m-%dT%H:%M:%S',
'ISO-8601_time'      '%H:%M:%S',

You get format as the following

my $format = $dbi->formats->{$format_name};