Commit | Line | Data |
5d567302 |
1 | package DBIx::Class::PK::Auto::Pg; |
2 | |
3 | use strict; |
4 | use warnings; |
5 | |
6 | use base qw/DBIx::Class/; |
7 | |
8 | __PACKAGE__->load_components(qw/PK::Auto/); |
9 | |
10 | sub last_insert_id { |
b6b65a3e |
11 | my $self = shift; |
5d567302 |
12 | $self->get_autoinc_seq unless $self->{_autoinc_seq}; |
66d9ef6b |
13 | $self->result_source->storage->dbh->last_insert_id(undef,undef,undef,undef, |
5d567302 |
14 | {sequence=>$self->{_autoinc_seq}}); |
15 | } |
16 | |
17 | sub get_autoinc_seq { |
b6b65a3e |
18 | my $self = shift; |
97cc0025 |
19 | |
20 | # return the user-defined sequence if known |
5b34b2f9 |
21 | if ($self->sequence) { |
22 | return $self->{_autoinc_seq} = $self->sequence; |
23 | } |
97cc0025 |
24 | |
47d2f099 |
25 | my @pri = $self->primary_columns; |
fe2b6875 |
26 | my $dbh = $self->result_source->storage->dbh; |
b6b65a3e |
27 | while (my $col = shift @pri) { |
28 | my $info = $dbh->column_info(undef,undef,$self->table,$col)->fetchrow_arrayref; |
29 | if (defined $info->[12] and $info->[12] =~ |
30 | /^nextval\('"?([^"']+)"?'::(?:text|regclass)\)/) |
31 | { |
32 | $self->{_autoinc_seq} = $1; |
33 | last; |
34 | } |
35 | } |
5d567302 |
36 | } |
37 | |
38 | 1; |
39 | |
40 | =head1 NAME |
41 | |
eb49d4e3 |
42 | DBIx::Class::PK::Auto::Pg - Automatic primary key class for PostgreSQL |
5d567302 |
43 | |
44 | =head1 SYNOPSIS |
45 | |
eb49d4e3 |
46 | # In your table classes |
47 | __PACKAGE__->load_components(qw/PK::Auto::Pg Core/); |
48 | __PACKAGE__->set_primary_key('id'); |
6718c5f0 |
49 | |
5d567302 |
50 | =head1 DESCRIPTION |
51 | |
eb49d4e3 |
52 | This class implements autoincrements for PostgreSQL. |
5d567302 |
53 | |
54 | =head1 AUTHORS |
55 | |
d00123a3 |
56 | Marcus Ramberg <m.ramberg@cpan.org> |
5d567302 |
57 | |
58 | =head1 LICENSE |
59 | |
60 | You may distribute this code under the same terms as Perl itself. |
61 | |
62 | =cut |