File: 07-odbc.t

package info (click to toggle)
libsql-reservedwords-perl 0.7-1
  • links: PTS, VCS
  • area: main
  • in suites: lenny, squeeze, wheezy
  • size: 272 kB
  • ctags: 93
  • sloc: perl: 2,739; makefile: 43
file content (49 lines) | stat: -rw-r--r-- 1,717 bytes parent folder | download | duplicates (5)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
#!perl

use strict;
use warnings;

use Test::More;

plan tests => 22;

use_ok( 'SQL::ReservedWords::ODBC' );

my @methods = qw[
    is_reserved
    is_reserved_by_odbc3
    reserved_by
    words
];

can_ok( 'SQL::ReservedWords::ODBC', @methods );

foreach my $method ( @methods ) {
    ok ! __PACKAGE__->can($method), "$method was not exported by default";
}

ok   my @words = SQL::ReservedWords::ODBC->words,               'Got words';
cmp_ok @words, '==', 235,                                       'Got 235 words';
ok   SQL::ReservedWords::ODBC->is_reserved('user'),             'USER is reserved';
ok   SQL::ReservedWords::ODBC->is_reserved_by_odbc3('user'),    'USER is reserved by ODBC 3.0';
ok ! SQL::ReservedWords::ODBC->is_reserved('bogus'),            'BOGUS is not reserved';
ok ! SQL::ReservedWords::ODBC->is_reserved(undef),              'undef is not reserved';

is_deeply [ SQL::ReservedWords::ODBC->reserved_by('user')               ],
          [ 'ODBC 3.0'                                                  ],
          'Got right reserved by for USER';

is_deeply [ SQL::ReservedWords::ODBC->reserved_by('bogus')              ],
          [                                                             ],
          'Got right reserved by for BOGUS';


use_ok 'SQL::ReservedWords::ODBC', @methods;

foreach my $method ( @methods ) {
    cmp_ok __PACKAGE__->can($method), '==', SQL::ReservedWords::ODBC->can($method), "$method was exported";
}

ok   @words = words(),                                          'Got words';
ok   is_reserved('user'),                                       'USER is reserved';
ok   is_reserved_by_odbc3('user'),                              'USER is reserved by ODBC 3.0';