| 1 | package DBIO::Oracle::Test::SequenceTest; | ||
| 2 | # ABSTRACT: Test result class for Oracle sequence tests | ||
| 3 | |||
| 4 | 2 | ▶ | use strict; |
|
Subroutine
BEGIN: called CC=1 SCAR=0.0
| |||
| 5 | 2 | ▶ | use warnings; |
|
Subroutine
BEGIN: called CC=1 SCAR=0.0
| |||
| 6 | |||
| 7 | 2 | our $VERSION = '0.900007'; | |
| 8 | |||
| 9 | 2 | ▶ | use base qw/DBIO::Test::BaseResult/; |
|
Subroutine
BEGIN: called CC=1 SCAR=0.0
| |||
| 10 | |||
| 11 | 2 | __PACKAGE__->table('sequence_test'); | |
| 12 | |||
| 13 | 2 | __PACKAGE__->add_columns( | |
| 14 | # A scalar-ref sequence is passed through verbatim; a plain string is quoted | ||
| 15 | # by the SQL dialect. pkid1 is pre-quoted (lowercase), pkid2 is unquoted (so | ||
| 16 | # Oracle folds it to uppercase), nonpkid relies on dialect quoting. | ||
| 17 | pkid1 => { | ||
| 18 | data_type => 'integer', | ||
| 19 | auto_nextval => 1, | ||
| 20 | sequence => \'"pkid1_seq"', | ||
| 21 | }, | ||
| 22 | pkid2 => { | ||
| 23 | data_type => 'integer', | ||
| 24 | auto_nextval => 1, | ||
| 25 | sequence => \'pkid2_seq', | ||
| 26 | }, | ||
| 27 | nonpkid => { | ||
| 28 | data_type => 'integer', | ||
| 29 | auto_nextval => 1, | ||
| 30 | sequence => 'nonpkid_seq', | ||
| 31 | }, | ||
| 32 | name => { | ||
| 33 | data_type => 'varchar', | ||
| 34 | size => 100, | ||
| 35 | is_nullable => 1, | ||
| 36 | }, | ||
| 37 | ); | ||
| 38 | |||
| 39 | 2 | __PACKAGE__->set_primary_key('pkid1', 'pkid2'); | |
| 40 | |||
| 41 | 2 | 1; | |
| 42 | |||
| 43 | __END__ | ||