Blame t/rt_115465_column_info_with_spaces.t
|
Packit |
723767 |
#!/usr/bin/perl
|
|
Packit |
723767 |
|
|
Packit |
723767 |
use strict;
|
|
Packit |
723767 |
BEGIN {
|
|
Packit |
723767 |
$| = 1;
|
|
Packit |
723767 |
$^W = 1;
|
|
Packit |
723767 |
}
|
|
Packit |
723767 |
|
|
Packit |
723767 |
use lib "t/lib";
|
|
Packit |
723767 |
use SQLiteTest;
|
|
Packit |
723767 |
use Test::More;
|
|
Packit |
723767 |
|
|
Packit |
723767 |
plan tests => 14;
|
|
Packit |
723767 |
use Test::NoWarnings;
|
|
Packit |
723767 |
|
|
Packit |
723767 |
{
|
|
Packit |
723767 |
my $dbh = connect_ok();
|
|
Packit |
723767 |
$dbh->do('create table test ( foo varchar(10), bar varchar( 15 ), baz decimal(3,3), bat decimal(4, 4))');
|
|
Packit |
723767 |
my %info = map {
|
|
Packit |
723767 |
$_->{COLUMN_NAME} => [@$_{qw/TYPE_NAME COLUMN_SIZE DECIMAL_DIGITS/}]
|
|
Packit |
723767 |
} @{$dbh->column_info(undef, undef, 'test', '%')->fetchall_arrayref({})};
|
|
Packit |
723767 |
|
|
Packit |
723767 |
is $info{foo}[0] => 'varchar';
|
|
Packit |
723767 |
is $info{foo}[1] => '10';
|
|
Packit |
723767 |
is $info{foo}[2] => undef;
|
|
Packit |
723767 |
|
|
Packit |
723767 |
is $info{bar}[0] => 'varchar';
|
|
Packit |
723767 |
is $info{bar}[1] => '15';
|
|
Packit |
723767 |
is $info{bar}[2] => undef;
|
|
Packit |
723767 |
|
|
Packit |
723767 |
is $info{baz}[0] => 'decimal';
|
|
Packit |
723767 |
is $info{baz}[1] => 3;
|
|
Packit |
723767 |
is $info{baz}[2] => 3;
|
|
Packit |
723767 |
|
|
Packit |
723767 |
is $info{bat}[0] => 'decimal';
|
|
Packit |
723767 |
is $info{bat}[1] => 4;
|
|
Packit |
723767 |
is $info{bat}[2] => 4;
|
|
Packit |
723767 |
}
|