DBIx-Custom / t / common-postgresql.t /
Newer Older
76 lines | 2.604kb
added common test executing ...
Yuki Kimoto authored on 2011-08-07
1
use strict;
2
use warnings;
3

            
4
use FindBin;
5
$ENV{DBIX_CUSTOM_TEST_RUN} = 1
added run file
Yuki Kimoto authored on 2011-08-13
6
  if -f "$FindBin::Bin/run/common-postgresql.run";
added common test executing ...
Yuki Kimoto authored on 2011-08-07
7
$ENV{DBIX_CUSTOM_SKIP_MESSAGE} = 'postgresql private test';
8

            
9
use DBIx::Custom;
10
{
11
    package DBIx::Custom;
12
    no warnings 'redefine';
cleanup
Yuki Kimoto authored on 2011-08-10
13

            
test cleanup
Yuki Kimoto authored on 2011-08-10
14
    my $date_typename = 'Date';
15
    my $datetime_typename = 'Timestamp';
16

            
17
    sub date_typename { lc $date_typename }
18
    sub datetime_typename { 'timestamp without time zone' }
19

            
20
    my $date_datatype = 91;
21
    my $datetime_datatype = 11;
22

            
23
    sub date_datatype { lc $date_datatype }
24
    sub datetime_datatype { lc $datetime_datatype }
fixed SQL Server tests
Yuki Kimoto authored on 2011-08-14
25
    
26
    has datetime_suffix => '';
cleanup
Yuki Kimoto authored on 2011-08-10
27

            
test cleanup
Yuki Kimoto authored on 2011-08-10
28
    has dsn => "dbi:Pg:dbname=dbix_custom";
29
    has user  => 'dbix_custom';
30
    has password => 'dbix_custom';
update pod
Yuki Kimoto authored on 2011-08-10
31
    has exclude_table => sub {
added EXPERIMENTAL system_ta...
Yuki Kimoto authored on 2011-08-10
32

            
33
        return qr/^(
34
            pg_|column_|role_|view_|sql_
35
            |applicable_roles
36
            |check_constraints
37
            |columns
38
            |constraint_column_usage
39
            |constraint_table_usage
40
            |data_type_privileges
41
            |domain_constraints
42
            |domain_udt_usage
43
            |domains
44
            |element_types
45
            |enabled_roles
update pod
Yuki Kimoto authored on 2011-08-10
46
            |information_schema
added EXPERIMENTAL system_ta...
Yuki Kimoto authored on 2011-08-10
47
            |information_schema_catalog_name
48
            |key_column_usage
49
            |parameters
50
            |referential_constraints
51
            |routine_privileges
52
            |routines
53
            |schemata
54
            |table_constraints
55
            |table_privileges
56
            |tables
57
            |triggered_update_columns
58
            |triggers
59
            |usage_privileges
60
            |views
61
        )/x
62
    };
added common test executing ...
Yuki Kimoto authored on 2011-08-07
63
    
64
    sub create_table1 { 'create table table1 (key1 varchar(255), key2 varchar(255));' }
cleanup test
Yuki Kimoto authored on 2011-08-08
65
    sub create_table1_2 {'create table table1 (key1 varchar(255), key2 varchar(255), '
66
     . 'key3 varchar(255), key4 varchar(255), key5 varchar(255));' }
test cleanup
Yuki Kimoto authored on 2011-08-10
67
    sub create_table1_type { "create table table1 (key1 $date_typename, key2 $datetime_typename);" }
test cleanup
Yuki Kimoto authored on 2011-08-10
68
    sub create_table1_highperformance { "create table table1 (ab varchar(255), bc varchar(255), "
69
      . "ik varchar(255), hi varchar(255), ui varchar(255), pq varchar(255), dc varchar(255));" }
test cleanup
Yuki Kimoto authored on 2011-08-10
70
    sub create_table2 { 'create table table2 (key1 varchar(255), key3 varchar(255));' }
test cleranup
Yuki Kimoto authored on 2011-08-10
71
    sub create_table2_2 { "create table table2 (key1 varchar(255), key2 varchar(255), key3 varchar(255))" }
72
    sub create_table3 { "create table table3 (key1 varchar(255), key2 varchar(255), key3 varchar(255))" }
test cleanup
Yuki Kimoto authored on 2011-08-10
73
    sub create_table_reserved { 'create table "table" ("select" varchar(255), "update" varchar(255))' }
added common test executing ...
Yuki Kimoto authored on 2011-08-07
74
}
75

            
76
require "$FindBin::Bin/common.t";