SQL/Translator/Producer/DBIx/Class/File.pm

filter: Statementstmt 66.6% 4 / 6 Branchbran n/a Conditioncond n/a MC/DCmcdc n/a Subroutinesub 100% 2 / 2 Podpod n/a totaltotal 75.0% 6 / 8 CC 1 SCAR 1.4
CC
1
Cov
67%
BEGIN
1.3
BEGIN
1.0
CRAP 1.1
« DBIx/Class/Storage/DBI/Sybase/Microsoft_SQL_Server/NoBindVars.pm ↑ Summary DBIx/Class/CDBICompat/NoObjectIndex.pm »
1 package SQL::Translator::Producer::DBIx::Class::File;
2  
3 =head1 NAME
4  
5 SQL::Translator::Producer::DBIx::Class::File - DBIx::Class file producer
6  
7 =head1 SYNOPSIS
8  
9 use SQL::Translator;
10  
11 my $t = SQL::Translator->new( parser => '...',
12 producer => 'DBIx::Class::File' );
13 print $translator->translate( $file );
14  
15 =head1 DESCRIPTION
16  
17 Creates a DBIx::Class::Schema for use with DBIx::Class
18  
19 =head1 FURTHER QUESTIONS?
20  
21 Check the list of L<additional DBIC resources|DBIx::Class/GETTING HELP/SUPPORT>.
22  
23 =head1 COPYRIGHT AND LICENSE
24  
25 This module is free software L<copyright|DBIx::Class/COPYRIGHT AND LICENSE>
26 by the L<DBIx::Class (DBIC) authors|DBIx::Class/AUTHORS>. You can
27 redistribute it and/or modify it under the same terms as the
28 L<DBIx::Class library|DBIx::Class/COPYRIGHT AND LICENSE>.
29  
30 =cut
31  
32 2 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
33 our ($VERSION, $DEBUG, $WARN);
34 $VERSION = '0.1';
35 $DEBUG = 0 unless defined $DEBUG;
36  
37 0 ▶use SQL::Translator::Schema::Constants;
Subroutine BEGIN: called CC=1 SCAR=2.6
38 use SQL::Translator::Utils qw(header_comment);
39 use Data::Dumper ();
40  
41 ## Skip all column type translation, as we want to use whatever the parser got.
42  
43 ## Translate parsers -> PK::Auto::Foo, however
44  
45 my %parser2PK = (
46 MySQL => 'PK::Auto::MySQL',
47 PostgreSQL => 'PK::Auto::Pg',
48 DB2 => 'PK::Auto::DB2',
49 Oracle => 'PK::Auto::Oracle',
50 );
51  
52 sub produce
53 {
54 my ($translator) = @_;
55 $DEBUG = $translator->debug;
56 $WARN = $translator->show_warnings;
57 my $no_comments = $translator->no_comments;
58 my $add_drop_table = $translator->add_drop_table;
59 my $schema = $translator->schema;
60 my $output = '';
61  
62 # Steal the XML producers "prefix" arg for our namespace?
63 my $dbixschema = $translator->producer_args()->{prefix} ||
64 $schema->name || 'My::Schema';
65 my $pkclass = $parser2PK{$translator->parser_type} || '';
66  
67 my %tt_vars = ();
68 $tt_vars{dbixschema} = $dbixschema;
69 $tt_vars{pkclass} = $pkclass;
70  
71 my $schemaoutput .= << "DATA";
72  
73 package ${dbixschema};
74 use base 'DBIx::Class::Schema';
75 use strict;
76 use warnings;
77 DATA
78  
79 my %tableoutput = ();
80 my %tableextras = ();
81 foreach my $table ($schema->get_tables)
82 {
83 my $tname = $table->name;
84 my $output .= qq{
85  
86 package ${dbixschema}::${tname};
87 use base 'DBIx::Class';
88 use strict;
89 use warnings;
90  
91 __PACKAGE__->load_components(qw/${pkclass} Core/);
92 __PACKAGE__->table('${tname}');
93  
94 };
95  
96 my @fields = map
97 { { $_->name => {
98 name => $_->name,
99 is_auto_increment => $_->is_auto_increment,
100 is_foreign_key => $_->is_foreign_key,
101 is_nullable => $_->is_nullable,
102 default_value => $_->default_value,
103 data_type => $_->data_type,
104 size => $_->size,
105 } }
106 } ($table->get_fields);
107  
108 $output .= "\n__PACKAGE__->add_columns(";
109 foreach my $f (@fields)
110 {
111 local $Data::Dumper::Terse = 1;
112 $output .= "\n '" . (keys %$f)[0] . "' => " ;
113 my $colinfo =
114 Data::Dumper->Dump([values %$f],
115 [''] # keys %$f]
116 );
117 chomp($colinfo);
118 $output .= $colinfo . ",";
119 }
120 $output .= "\n);\n";
121  
122 my $pk = $table->primary_key;
123 if($pk)
124 {
125 my @pk = map { $_->name } ($pk->fields);
126 $output .= "__PACKAGE__->set_primary_key(";
127 $output .= "'" . join("', '", @pk) . "');\n";
128 }
129  
130 foreach my $cont ($table->get_constraints)
131 {
132 # print Data::Dumper::Dumper($cont->type);
133 if($cont->type =~ /foreign key/i)
134 {
135 # $output .= "\n__PACKAGE__->belongs_to('" .
136 # $cont->fields->[0]->name . "', '" .
137 # "${dbixschema}::" . $cont->reference_table . "');\n";
138  
139 $tableextras{$table->name} .= "\n__PACKAGE__->belongs_to('" .
140 $cont->fields->[0]->name . "', '" .
141 "${dbixschema}::" . $cont->reference_table . "');\n";
142  
143 my $other = "\n__PACKAGE__->has_many('" .
144 "get_" . $table->name. "', '" .
145 "${dbixschema}::" . $table->name. "', '" .
146 $cont->fields->[0]->name . "');";
147 $tableextras{$cont->reference_table} .= $other;
148 }
149 }
150  
151 $tableoutput{$table->name} .= $output;
152 }
153  
154 foreach my $to (keys %tableoutput)
155 {
156 $output .= $tableoutput{$to};
157 $schemaoutput .= "\n__PACKAGE__->register_class('${to}', '${dbixschema}::${to}');\n";
158 }
159  
160 foreach my $te (keys %tableextras)
161 {
162 $output .= "\npackage ${dbixschema}::$te;\n";
163 $output .= $tableextras{$te} . "\n";
164 # $tableoutput{$te} .= $tableextras{$te} . "\n";
165 }
166  
167 # print "$output\n";
168 return "${output}\n\n${schemaoutput}\n1;\n";
169 }
« DBIx/Class/Storage/DBI/Sybase/Microsoft_SQL_Server/NoBindVars.pm ↑ Summary DBIx/Class/CDBICompat/NoObjectIndex.pm »