Commit | Line | Data |
16dc9970 |
1 | package SQL::Translator::Producer; |
2 | |
44659089 |
3 | # ------------------------------------------------------------------- |
4 | # Copyright (C) 2002-4 SQLFairy Authors |
5 | # |
6 | # This program is free software; you can redistribute it and/or |
7 | # modify it under the terms of the GNU General Public License as |
8 | # published by the Free Software Foundation; version 2. |
9 | # |
10 | # This program is distributed in the hope that it will be useful, but |
11 | # WITHOUT ANY WARRANTY; without even the implied warranty of |
12 | # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU |
13 | # General Public License for more details. |
14 | # |
15 | # You should have received a copy of the GNU General Public License |
16 | # along with this program; if not, write to the Free Software |
17 | # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA |
18 | # 02111-1307 USA |
19 | # ------------------------------------------------------------------- |
20 | |
077ebf34 |
21 | use strict; |
da06ac74 |
22 | use vars qw($VERSION); |
06baeb21 |
23 | use Scalar::Util (); |
11ad2df9 |
24 | $VERSION = '1.59'; |
16dc9970 |
25 | |
077ebf34 |
26 | sub produce { "" } |
16dc9970 |
27 | |
bc8e2aa1 |
28 | # Do not rely on this if you are not bundled with SQL::Translator. |
29 | # -- rjbs, 2008-09-30 |
30 | ## $exceptions contains an arrayref of paired values |
31 | ## Each pair contains a pattern match or string, and a value to be used as |
32 | ## the default if matched. |
33 | ## They are special per Producer, and provide support for the old 'now()' |
34 | ## default value exceptions |
35 | sub _apply_default_value { |
06baeb21 |
36 | my (undef, $field, $field_ref, $exceptions) = @_; |
37 | my $default = $field->default_value; |
38 | return if !defined $default; |
bc8e2aa1 |
39 | |
40 | if ($exceptions and ! ref $default) { |
41 | for (my $i = 0; $i < @$exceptions; $i += 2) { |
42 | my ($pat, $val) = @$exceptions[ $i, $i + 1 ]; |
43 | if (ref $pat and $default =~ $pat) { |
44 | $default = $val; |
45 | last; |
46 | } elsif (lc $default eq lc $pat) { |
47 | $default = $val; |
48 | last |
49 | } |
50 | } |
51 | } |
52 | |
06baeb21 |
53 | my $type = lc $field->data_type; |
54 | my $is_numeric_datatype = ($type =~ /^(?:(?:big|medium|small|tiny)?int(?:eger)?|decimal|double|float|num(?:ber|eric)?|real)$/); |
55 | |
bc8e2aa1 |
56 | if (ref $default) { |
57 | $$field_ref .= " DEFAULT $$default"; |
06baeb21 |
58 | } elsif ($is_numeric_datatype && Scalar::Util::looks_like_number ($default) ) { |
59 | # we need to check the data itself in addition to the datatype, for basic safety |
60 | $$field_ref .= " DEFAULT $default"; |
bc8e2aa1 |
61 | } else { |
0f4c1a5b |
62 | $$field_ref .= " DEFAULT '$default'"; |
bc8e2aa1 |
63 | } |
64 | |
65 | } |
66 | |
16dc9970 |
67 | 1; |
68 | |
49e1eb70 |
69 | # ------------------------------------------------------------------- |
16dc9970 |
70 | # A burnt child loves the fire. |
71 | # Oscar Wilde |
49e1eb70 |
72 | # ------------------------------------------------------------------- |
73 | |
74 | =pod |
16dc9970 |
75 | |
76 | =head1 NAME |
77 | |
56435d6f |
78 | SQL::Translator::Producer - describes how to write a producer |
16dc9970 |
79 | |
16dc9970 |
80 | =head1 DESCRIPTION |
81 | |
077ebf34 |
82 | Producer modules designed to be used with SQL::Translator need to |
83 | implement a single function, called B<produce>. B<produce> will be |
56435d6f |
84 | called with the SQL::Translator object from which it is expected to |
85 | retrieve the SQL::Translator::Schema object which has been populated |
86 | by the parser. It is expected to return a string. |
16dc9970 |
87 | |
0e1ec14f |
88 | =head1 METHODS |
89 | |
90 | =over 4 |
91 | |
92 | =item produce |
93 | |
94 | =item create_table($table) |
95 | |
96 | =item create_field($field) |
97 | |
98 | =item create_view($view) |
99 | |
100 | =item create_index($index) |
101 | |
102 | =item create_constraint($constraint) |
103 | |
104 | =item create_trigger($trigger) |
105 | |
106 | =item alter_field($from_field, $to_field) |
107 | |
108 | =item add_field($table, $new_field) |
109 | |
110 | =item drop_field($table, $old_field) |
111 | |
0e42fda6 |
112 | =back |
113 | |
56435d6f |
114 | =head1 AUTHORS |
16dc9970 |
115 | |
56435d6f |
116 | Darren Chamberlain E<lt>darren@cpan.orgE<gt>, |
11ad2df9 |
117 | Ken Y. Clark E<lt>kclark@cpan.orgE<gt>. |
16dc9970 |
118 | |
119 | =head1 SEE ALSO |
120 | |
56435d6f |
121 | perl(1), SQL::Translator, SQL::Translator::Schema. |
16dc9970 |
122 | |
123 | =cut |