1 package SQL::Translator::Parser::XML::XMI::SQLFairy;
3 # -------------------------------------------------------------------
4 # $Id: SQLFairy.pm,v 1.2 2003-10-13 17:05:55 grommit Exp $
5 # -------------------------------------------------------------------
6 # Copyright (C) 2003 Mark Addison <mark.addison@itn.co.uk>,
8 # This program is free software; you can redistribute it and/or
9 # modify it under the terms of the GNU General Public License as
10 # published by the Free Software Foundation; version 2.
12 # This program is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
15 # General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with this program; if not, write to the Free Software
19 # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA
21 # -------------------------------------------------------------------
25 SQL::Translator::Parser::XML::XMI::SQLFairy - Create Schema from UML Models.
31 use vars qw[ $DEBUG $VERSION @EXPORT_OK ];
32 $VERSION = sprintf "%d.%02d", q$Revision: 1.2 $ =~ /(\d+)\.(\d+)/;
33 $DEBUG = 0 unless defined $DEBUG;
35 use base qw(Exporter);
36 @EXPORT_OK = qw(parse);
39 use SQL::Translator::Parser::XML::XMI;
40 use SQL::Translator::Utils 'debug';
42 # Globals for the subs to use, set in parse() and classes2schema()
44 # TODO Should we be giving classes2schema the schema or should they use their
45 # parse() to get it. Obj parsers maybe?
46 #our ($schema,$pargs);
47 use vars qw[ $schema $pargs ];
49 # Set the parg for the conversion sub then use the XMI parser
51 my ( $translator ) = @_;
52 local $DEBUG = $translator->debug;
53 local $pargs = $translator->parser_args;
54 #local $schema = $translator->schema;
55 $pargs->{classes2schema} = \&classes2schema;
56 $pargs->{derive_pkey} ||= "stereotype,auto,first";
57 $pargs->{auto_pkey} ||= {
65 is_auto_increment => 1,
68 return SQL::Translator::Parser::XML::XMI::parse(@_);
73 # TODO We could make the tag names a parser arg so people can use their own.
75 $TAGS{data_type} = "sqlfDataType";
76 $TAGS{size} = "sqlfSize";
77 $TAGS{is_nullable} = "sqlfIsNullable";
78 $TAGS{required} = "sqlfRequired";
79 $TAGS{is_auto_increment} = "sqlfIsAutoIncrement";
80 $TAGS{default_value} = "sqlfDefaultValue";
84 return grep {$_->{kind} ne "return"} @$params;
88 my ($tag, $things) = @_;
90 return $_->{_map_taggedValues}{$tag}{dataValue}
91 if exists $_->{_map_taggedValues}{$tag}{dataValue};
98 local $schema = shift;
102 # Create tablles from Classes and collect their associations
105 foreach my $class (@$classes) {
107 debug "Adding class: $class->{name}";
108 my $table = $schema->add_table( name => $class->{name} )
109 or die "Schema Error: ".$schema->error;
111 # Only collect the associations for classes that are tables. Use a hash
112 # so we only get them once
113 $associations{$_->{"xmi.id"}} = $_
114 foreach map $_->{association}, @{$class->{associationEnds}};
117 # Fields from Class attributes
120 push @flds, attr2field($_) for @{$class->{attributes}};
121 # TODO Filter this e.g no abstract attr or stereotype check
123 my $extra = delete $_->{extra};
124 my $field = $table->add_field( %$_ ) or die $schema->error;
125 $field->extra(%$extra) if $extra;
129 add_pkey($class,$table);
133 # Relationships from Associations
135 foreach my $assoc (values %associations) {
136 my @end = @{$assoc->{associationEnds}};
138 $end[0]->{multiplicity}{rangeUpper} == 1
139 && $end[1]->{multiplicity}{rangeUpper} == 1
142 warn "Sorry, 1:1 associations not yet implimented for xmi.id=".$assoc->{"xmi.id"}."\n";
145 $end[0]->{multiplicity}{rangeUpper} == 1
146 || $end[1]->{multiplicity}{rangeUpper} == 1
154 warn "Sorry, n:m associations not yet implimented for xmi.id=".$assoc->{"xmi.id"}."\n";
161 # Take an attribute and return the field data for it
164 my $dataType = $attr->{dataType};
166 my %data = ( name => $attr->{name} );
169 = _resolve_tag($TAGS{data_type},[$attr,$dataType])
170 || $dataType->{name};
172 $data{size} = _resolve_tag($TAGS{size},[$attr,$dataType]);
175 = _resolve_tag($TAGS{default_value},[$attr,$dataType])
176 || $attr->{initialValue};
178 my $is_nullable = _resolve_tag($TAGS{is_nullable},[$attr,$dataType]);
179 my $required = _resolve_tag($TAGS{required},[$attr,$dataType]);
181 = defined $is_nullable ? $is_nullable
182 : ( defined $required ? ($required ? 0 : 1) : undef);
184 $data{is_auto_increment}
185 = $attr->{_map_taggedValues}{$TAGS{is_auto_increment}}{dataValue}
186 || $dataType->{_map_taggedValues}{$TAGS{is_auto_increment}}{dataValue}
193 foreach ( keys %{$attr->{_map_taggedValues}} ) {$tagnames{$_}++; }
194 delete @tagnames{@TAGS{qw/data_type size default_value is_nullable required is_auto_increment/}}; # Remove the tags we have already done
196 my $val = $attr->{_map_taggedValues}{$_}{dataValue};
200 $data{extra} = \%extra;
205 # Add a pkey to a table for the class
207 my ($class,$table) = @_;
210 foreach ( split(",", $pargs->{derive_pkey}) ) {
211 if ( $_ eq "stereotype" ) {
212 @pkeys = map $_->{name},
213 grep($_->{stereotype} eq "PK", @{$class->{attributes}});
215 elsif( $_ eq "first" ) {
216 @pkeys = $class->{attributes}[0]{name} unless @pkeys;
218 elsif( $_ eq "auto" ) {
219 if ( my %data = %{$pargs->{auto_pkey}} ) {
220 $data{name} = $data{name}->($class,$table);
221 my $field = $table->add_field(%data) or die $table->error;
222 @pkeys = $field->name;
228 $table->add_constraint(
229 type => "PRIMARY KEY",
231 ) or die $table->error;
234 # Maps a 1:M association into the schema
237 my @ends = @{$assoc->{associationEnds}};
238 my ($end1) = grep $_->{multiplicity}{rangeUpper} == 1, @ends;
239 my $endm = $end1->{otherEnd};
240 my $table1 = $schema->get_table($end1->{participant}{name});
241 my $tablem = $schema->get_table($endm->{participant}{name});
244 # Export 1end pkey to many end
246 my $con = $table1->primary_key;
247 my @flds = $con->fields;
249 my $fld = $table1->get_field($_);
251 $data{$_} = $fld->$_()
252 foreach (qw/name size data_type default_value is_nullable/);
253 $data{extra} = { $fld->extra }; # Copy extra hash
254 $data{is_unique} = 0; # FKey on many join so not unique
255 $data{is_nullable} = $end1->{multiplicity}{rangeLower} == 0 ? 1 : 0;
256 # 0:m - allow nulluable on fkey
257 # 1:m - dont allow nullable
259 $tablem->add_field(%data) or die $tablem->error;
260 # Export the pkey if full composite (ie identity) relationship
261 $tablem->primary_key($_) if $end1->{aggregation} eq "composite";
265 # Add fkey constraint to many end
267 $tablem->add_constraint(
268 type => "FOREIGN_KEY",
270 reference_table => $table1->{name},
271 reference_fields => [@flds],
272 ) or die $schema->error;
275 1; #---------------------------------------------------------------------------
284 use SQL::Translator::Parser::XML::XMI;
286 my $translator = SQL::Translator->new(
287 from => 'XML-XMI-SQLFairy',
289 filename => 'schema.xmi',
292 print $obj->translate;
296 Converts Class diagrams to Schema trying to use standard UML features as much
297 as possible, with the minimum use of extension mechanisms (tagged values and
298 stereotypes) for the database details. The idea is to treat the object model
299 like a logical database model and map that to a physical model (the sql). Also
300 tries to make this mapping as configurable as possible and support all the
301 schema features of SQLFairy.
305 Classes, all of them! (TODO More control over which tables to do.)
309 The attributes of the class will be converted to fields of the same name.
313 Database datatypes are modeled using tagged values; sqlfDataType,
314 sqlfSize, sqlfIsNullable and sqlfIsAutoIncrement added to the attribute.
315 The default value is the UML initial value of the attribute or can be overridden
316 using a sqlfDefaultValue tagged value if you want to have a different default
317 in the database then the object uses.
319 For more advanced datatype modeling you can use UML data types by adding the
320 tagged values to the UML data types in your model and then giving your
321 attributes those datatypes. Any tagged values set on attributes will override
322 any they get from their datatype. This allows you to use UML datatypes like
323 domains. If no sqlfDataType is given then the name of the UMLDataType is used.
327 If no attribute is marked explicity on the Class as a pkey then one is added.
328 The default is an INT(10) auto number named after the class with ID on the end.
329 For many cases this is enough as you don't normally need to model pkeys
330 explicitly in your object models as its a database thing.
332 The pkey created can be controlled by setting the C<auto_pkey> parser arg to a
333 hash ref describing the field. The name key is a sub that gets given a ref to
334 the class (from the xmi) and the table it has been mapped to, and should return the pkey name. e.g. the defualt looks like;
344 is_auto_increment => 1,
347 NB You need to return a unique name for the key if it will be used to build
348 relationships as it will be exported to other tables (see Relationships).
350 You can also set them explicitly by marking attributes with a <<PK>> stereotype.
351 Add to multiple attribs to make multi column keys. Usefull when your object
352 contains an attribute that makes a good candidate for a pkey, e.g. email.
356 Modeled using UML associations. Currently only handles 0:m and 1:m joins. That
357 is associations where one ends multiplicty is '1' or '0..1' and the other end's
358 multplicity is more than 1 e.g '*', '0..*', '1..*', '0..3', '4..42' etc.
360 The pkey field from the 1 end is added to the table for the class at the many
361 end as a foreign key with is_unique and auto number turned off.
363 If the 1 end is multiplicity '0..1' (ie a 0:m join) then the the fkey is made
364 nullable, if its multiplicity '1' (1:m) then its made not nullable.
366 If the association is a composition then the created fkey is made part of the
367 many ends pkey. ie It exports the pkey to create an identity join.
371 TODO An example to help make sense of the above! Probably based on the test.
383 Support for the format_X_name subs in the Translator.
389 Mark D. Addison E<lt>mark.addison@itn.co.ukE<gt>.
393 perl(1), SQL::Translator::Parser::XML::XMI