|
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 qw/connect_ok/;
|
|
Packit |
723767 |
use Test::More;
|
|
Packit |
723767 |
use Test::NoWarnings;
|
|
Packit |
723767 |
|
|
Packit |
723767 |
plan tests => (5 * 5) + (3 * 6 + 1) + (5 * 2) + 1;
|
|
Packit |
723767 |
|
|
Packit |
723767 |
for my $quote ('', qw/' " ` []/) {
|
|
Packit |
723767 |
my ($begin_quote, $end_quote) = (substr($quote, 0, 1), substr($quote, -1, 1));
|
|
Packit |
723767 |
my $dbh = connect_ok( RaiseError => 1 );
|
|
Packit |
723767 |
ok $dbh->do(
|
|
Packit |
723767 |
"create table ${begin_quote}foo${end_quote} (${begin_quote}id${end_quote} integer primary key)"
|
|
Packit |
723767 |
);
|
|
Packit |
723767 |
my $sth = $dbh->primary_key_info(undef, undef, 'foo');
|
|
Packit |
723767 |
my $pk = $sth->fetchrow_hashref;
|
|
Packit |
723767 |
ok $pk->{TABLE_NAME} eq 'foo'; # dequoted
|
|
Packit |
723767 |
ok $pk->{COLUMN_NAME} eq 'id'; # dequoted
|
|
Packit |
723767 |
|
|
Packit |
723767 |
($pk) = $dbh->primary_key(undef, undef, 'foo');
|
|
Packit |
723767 |
ok $pk eq 'id';
|
|
Packit |
723767 |
}
|
|
Packit |
723767 |
|
|
Packit |
723767 |
{
|
|
Packit |
723767 |
my $dbh = connect_ok();
|
|
Packit |
723767 |
$dbh->do("create table foo (id integer primary key)");
|
|
Packit |
723767 |
$dbh->do("attach database ':memory:' as remote");
|
|
Packit |
723767 |
$dbh->do("create table remote.bar (name text, primary key(name))");
|
|
Packit |
723767 |
$dbh->do("create temporary table baz (tmp primary key)");
|
|
Packit |
723767 |
|
|
Packit |
723767 |
{
|
|
Packit |
723767 |
my $sth = $dbh->primary_key_info(undef, undef, 'foo');
|
|
Packit |
723767 |
my @pk_info;
|
|
Packit |
723767 |
while(my $row = $sth->fetchrow_hashref) { push @pk_info, $row };
|
|
Packit |
723767 |
is @pk_info => 1, "found 1 pk in a table";
|
|
Packit |
723767 |
is $pk_info[0]{TABLE_SCHEM} => 'main', "scheme is correct";
|
|
Packit |
723767 |
is $pk_info[0]{COLUMN_NAME} => 'id', "pk name is correct";
|
|
Packit |
723767 |
}
|
|
Packit |
723767 |
|
|
Packit |
723767 |
{
|
|
Packit |
723767 |
my $sth = $dbh->primary_key_info(undef, 'main', undef);
|
|
Packit |
723767 |
my @pk_info;
|
|
Packit |
723767 |
while(my $row = $sth->fetchrow_hashref) { push @pk_info, $row };
|
|
Packit |
723767 |
is @pk_info => 1, "found 1 pk in a table";
|
|
Packit |
723767 |
is $pk_info[0]{TABLE_SCHEM} => 'main', "scheme is correct";
|
|
Packit |
723767 |
is $pk_info[0]{COLUMN_NAME} => 'id', "pk name is correct";
|
|
Packit |
723767 |
}
|
|
Packit |
723767 |
|
|
Packit |
723767 |
{
|
|
Packit |
723767 |
my $sth = $dbh->primary_key_info(undef, undef, 'bar');
|
|
Packit |
723767 |
my @pk_info;
|
|
Packit |
723767 |
while(my $row = $sth->fetchrow_hashref) { push @pk_info, $row };
|
|
Packit |
723767 |
is @pk_info => 1, "found 1 pk in an attached table";
|
|
Packit |
723767 |
is $pk_info[0]{TABLE_SCHEM} => 'remote', "scheme is correct";
|
|
Packit |
723767 |
is $pk_info[0]{COLUMN_NAME} => 'name', "pk name is correct";
|
|
Packit |
723767 |
}
|
|
Packit |
723767 |
|
|
Packit |
723767 |
{
|
|
Packit |
723767 |
my $sth = $dbh->primary_key_info(undef, 'remote', undef);
|
|
Packit |
723767 |
my @pk_info;
|
|
Packit |
723767 |
while(my $row = $sth->fetchrow_hashref) { push @pk_info, $row };
|
|
Packit |
723767 |
is @pk_info => 1, "found 1 pk in an attached table";
|
|
Packit |
723767 |
is $pk_info[0]{TABLE_SCHEM} => 'remote', "scheme is correct";
|
|
Packit |
723767 |
is $pk_info[0]{COLUMN_NAME} => 'name', "pk name is correct";
|
|
Packit |
723767 |
}
|
|
Packit |
723767 |
|
|
Packit |
723767 |
{
|
|
Packit |
723767 |
my $sth = $dbh->primary_key_info(undef, 'temp', undef);
|
|
Packit |
723767 |
my @pk_info;
|
|
Packit |
723767 |
while(my $row = $sth->fetchrow_hashref) { push @pk_info, $row };
|
|
Packit |
723767 |
is @pk_info => 1, "found 1 pk in a table";
|
|
Packit |
723767 |
is $pk_info[0]{TABLE_SCHEM} => 'temp', "scheme is correct";
|
|
Packit |
723767 |
is $pk_info[0]{COLUMN_NAME} => 'tmp', "pk name is correct";
|
|
Packit |
723767 |
}
|
|
Packit |
723767 |
|
|
Packit |
723767 |
{
|
|
Packit |
723767 |
my $sth = $dbh->primary_key_info(undef, undef, 'baz');
|
|
Packit |
723767 |
my @pk_info;
|
|
Packit |
723767 |
while(my $row = $sth->fetchrow_hashref) { push @pk_info, $row };
|
|
Packit |
723767 |
is @pk_info => 1, "found 1 pk in an attached table";
|
|
Packit |
723767 |
is $pk_info[0]{TABLE_SCHEM} => 'temp', "scheme is correct";
|
|
Packit |
723767 |
is $pk_info[0]{COLUMN_NAME} => 'tmp', "pk name is correct";
|
|
Packit |
723767 |
}
|
|
Packit |
723767 |
}
|
|
Packit |
723767 |
|
|
Packit |
723767 |
{
|
|
Packit |
723767 |
my $dbh = connect_ok();
|
|
Packit |
723767 |
$dbh->do("create table foo (id integer, text text, primary key (id))");
|
|
Packit |
723767 |
|
|
Packit |
723767 |
{
|
|
Packit |
723767 |
my $sth = $dbh->primary_key_info(undef, undef, 'foo');
|
|
Packit |
723767 |
my @pk_info;
|
|
Packit |
723767 |
while(my $row = $sth->fetchrow_hashref) { push @pk_info, $row };
|
|
Packit |
723767 |
is @pk_info => 1, "found 1 pk in a table";
|
|
Packit |
723767 |
is $pk_info[0]{TABLE_SCHEM} => 'main', "scheme is correct";
|
|
Packit |
723767 |
is $pk_info[0]{COLUMN_NAME} => 'id', "pk name is correct";
|
|
Packit |
723767 |
is $pk_info[0]{PK_NAME} => 'PRIMARY KEY', "pk name is correct";
|
|
Packit |
723767 |
}
|
|
Packit |
723767 |
}
|
|
Packit |
723767 |
|
|
Packit |
723767 |
{
|
|
Packit |
723767 |
my $dbh = connect_ok();
|
|
Packit |
723767 |
$dbh->do("create table foo (id integer, text text, constraint bar primary key (id))");
|
|
Packit |
723767 |
|
|
Packit |
723767 |
{
|
|
Packit |
723767 |
my $sth = $dbh->primary_key_info(undef, undef, 'foo');
|
|
Packit |
723767 |
my @pk_info;
|
|
Packit |
723767 |
while(my $row = $sth->fetchrow_hashref) { push @pk_info, $row };
|
|
Packit |
723767 |
is @pk_info => 1, "found 1 pk in a table";
|
|
Packit |
723767 |
is $pk_info[0]{TABLE_SCHEM} => 'main', "scheme is correct";
|
|
Packit |
723767 |
is $pk_info[0]{COLUMN_NAME} => 'id', "pk name is correct";
|
|
Packit |
723767 |
is $pk_info[0]{PK_NAME} => 'bar', "pk name is correct";
|
|
Packit |
723767 |
}
|
|
Packit |
723767 |
}
|