Commit | Line | Data |
8bdccca2 |
1 | package DBIx::Class::SQLMaker::OracleJoins; |
6f4ddea1 |
2 | |
f116ff4e |
3 | use warnings; |
4 | use strict; |
10cef607 |
5 | use Module::Runtime (); |
f116ff4e |
6 | |
ba12b23f |
7 | use base qw( DBIx::Class::SQLMaker::Oracle ); |
6f4ddea1 |
8 | |
10cef607 |
9 | sub _build_base_renderer_class { |
10 | Module::Runtime::use_module('DBIx::Class::SQLMaker::Renderer::OracleJoins'); |
6f4ddea1 |
11 | } |
12 | |
13 | 1; |
14 | |
15 | =pod |
16 | |
17 | =head1 NAME |
18 | |
d5dedbd6 |
19 | DBIx::Class::SQLMaker::OracleJoins - Pre-ANSI Joins-via-Where-Clause Syntax |
6f4ddea1 |
20 | |
21 | =head1 PURPOSE |
22 | |
86b23415 |
23 | This module is used with Oracle < 9.0 due to lack of support for standard |
24 | ANSI join syntax. |
6f4ddea1 |
25 | |
26 | =head1 SYNOPSIS |
27 | |
28 | Not intended for use directly; used as the sql_maker_class for schemas and components. |
29 | |
30 | =head1 DESCRIPTION |
31 | |
32 | Implements pre-ANSI joins specified in the where clause. Instead of: |
33 | |
34 | SELECT x FROM y JOIN z ON y.id = z.id |
35 | |
36 | It will write: |
37 | |
38 | SELECT x FROM y, z WHERE y.id = z.id |
39 | |
40 | It should properly support left joins, and right joins. Full outer joins are |
41 | not possible due to the fact that Oracle requires the entire query be written |
42 | to union the results of a left and right join, and by the time this module is |
43 | called to create the where query and table definition part of the sql query, |
44 | it's already too late. |
45 | |
46 | =head1 METHODS |
47 | |
48 | =over |
49 | |
f116ff4e |
50 | =item select |
6f4ddea1 |
51 | |
f116ff4e |
52 | Overrides DBIx::Class::SQLMaker's select() method, which calls _oracle_joins() |
53 | to modify the column and table list before calling next::method(). |
6f4ddea1 |
54 | |
55 | =back |
56 | |
57 | =head1 BUGS |
58 | |
f116ff4e |
59 | Does not support full outer joins (however neither really does DBIC itself) |
6f4ddea1 |
60 | |
61 | =head1 SEE ALSO |
62 | |
63 | =over |
64 | |
65 | =item L<DBIx::Class::Storage::DBI::Oracle::WhereJoins> - Storage class using this |
66 | |
d5dedbd6 |
67 | =item L<DBIx::Class::SQLMaker> - Parent module |
6f4ddea1 |
68 | |
69 | =item L<DBIx::Class> - Duh |
70 | |
71 | =back |
72 | |
73 | =head1 AUTHOR |
74 | |
75 | Justin Wheeler C<< <jwheeler@datademons.com> >> |
76 | |
77 | =head1 CONTRIBUTORS |
78 | |
79 | David Jack Olrik C<< <djo@cpan.org> >> |
80 | |
81 | =head1 LICENSE |
82 | |
83 | This module is licensed under the same terms as Perl itself. |
84 | |
85 | =cut |
86 | |