2 <% include("/elements/header.html",'Map tables') %>
5 var gSafeOnload = new Array();
6 var gSafeOnsubmit = new Array();
7 window.onload = SafeOnload;
8 function SafeAddOnLoad(f) {
9 gSafeOnload[gSafeOnload.length] = f;
11 function SafeOnload() {
12 for (var i=0;i<gSafeOnload.length;i++)
15 function SafeAddOnSubmit(f) {
16 gSafeOnsubmit[gSafeOnsubmit.length] = f;
18 function SafeOnsubmit() {
19 for (var i=0;i<gSafeOnsubmit.length;i++)
24 <FORM NAME="OneTrueForm" METHOD="POST" ACTION="meta-import.cgi">
26 % #use DBIx::DBSchema;
27 % my $schema = new_native DBIx::DBSchema
28 % map { $cgi->param($_) } qw( data_source username password );
29 % foreach my $field (qw( data_source username password )) {
31 <INPUT TYPE="hidden" NAME=<% $field %> VALUE="<% $cgi->param($field) %>">
36 % tie %schema, 'Tie::DxHash';
37 % if ( $cgi->param('schema') ) {
38 % my $schema_string = $cgi->param('schema');
40 <INPUT TYPE="hidden" NAME="schema" VALUE="<%$schema_string%>">
42 % %schema = map { /^\s*(\w+)\s*=>\s*(\w+)\s*$/
43 % or die "guru meditation #420: $_";
46 % split( /\n/, $schema_string );
50 % unless ( $cgi->param('magic') ) {
53 <INPUT TYPE="hidden" NAME="magic" VALUE="process">
54 <% hashmaker('schema', [ $schema->tables ],
55 [ grep !/^h_/, dbdef->tables ], ) %>
56 <br><INPUT TYPE="submit" VALUE="done">
60 % } elsif ( $cgi->param('magic') eq 'process' ) {
63 <INPUT TYPE="hidden" NAME="magic" VALUE="process2">
67 % foreach my $table ( keys %schema ) {
69 % my @from_columns = $schema->table($table)->columns;
70 % my @fs_columns = dbdef->table($schema{$table})->columns;
74 <% hashmaker( $table.'__'.$unique{$table}++,
75 \@from_columns => \@fs_columns,
76 $table => $schema{$table}, ) %>
84 <br><INPUT TYPE="submit" VALUE="done">
88 % } elsif ( $cgi->param('magic') eq 'process2' ) {
93 % foreach my $table ( keys %schema ) {
94 % ( my $spaces = $table ) =~ s/./ /g;
95 % print "'$table' => { 'table' => '$schema{$table}',\n".
96 % #(length($table) x ' '). " 'map' => {\n";
97 % "$spaces 'map' => {\n";
98 % my %map = map { /^\s*(\w+)\s*=>\s*(\w+)\s*$/
99 % or die "guru meditation #420: $_";
102 % split( /\n/, $cgi->param($table.'__'.$unique{$table}++) );
103 % foreach ( keys %map ) {
104 % print "$spaces '$_' => '$map{$_}',\n";
106 % print "$spaces },\n";
107 % print "$spaces },\n";
113 % warn "unrecognized magic: ". $cgi->param('magic');
124 % my($name, $from, $to, $labelfrom, $labelto) = @_;
125 % my $fromsize = scalar(@$from);
126 % my $tosize = scalar(@$to);
127 % "<TABLE><TR><TH>$labelfrom</TH><TH>$labelto</TH></TR><TR><TD>".
128 % qq!<SELECT NAME="${name}_from" SIZE=$fromsize>\n!.
129 % join("\n", map { qq!<OPTION VALUE="$_">$_</OPTION>! } sort { $a cmp $b } @$from ).
131 % qq!<INPUT TYPE="button" VALUE="refill" onClick="repack_${name}_from()">!.
133 % qq!<SELECT NAME="${name}_to" SIZE=$tosize>\n!.
134 % join("\n", map { qq!<OPTION VALUE="$_">$_</OPTION>! } sort { $a cmp $b } @$to ).
136 % qq!<INPUT TYPE="button" VALUE="refill" onClick="repack_${name}_to()">!.
138 % '<TR><TD COLSPAN=2>'.
139 % qq!<INPUT TYPE="button" VALUE="map" onClick="toke_$name(this.form)">!.
140 % '</TD></TR><TR><TD COLSPAN=2>'.
141 % qq!<TEXTAREA NAME="$name" COLS=80 ROWS=8></TEXTAREA>!.
142 % '</TD></TR></TABLE>'.
144 % function toke_$name() {
145 % fromObject = document.OneTrueForm.${name}_from;
146 % for (var i=fromObject.options.length-1;i>-1;i--) {
147 % if (fromObject.options[i].selected)
148 % fromname = deleteOption_$name(fromObject,i);
150 % toObject = document.OneTrueForm.${name}_to;
151 % for (var i=toObject.options.length-1;i>-1;i--) {
152 % if (toObject.options[i].selected)
153 % toname = deleteOption_$name(toObject,i);
155 % document.OneTrueForm.$name.value = document.OneTrueForm.$name.value + fromname + ' => ' + toname + '\\n';
157 % function deleteOption_$name(object,index) {
158 % value = object.options[index].value;
159 % object.options[index] = null;
162 % function repack_${name}_from() {
163 % var object = document.OneTrueForm.${name}_from;
164 % object.options.length = 0;
166 % map { "addOption_$name(object, '$_');\n" }
167 % ( sort { $a cmp $b } @$from ) ). "
169 % function repack_${name}_to() {
170 % var object = document.OneTrueForm.${name}_to;
171 % object.options.length = 0;
173 % map { "addOption_$name(object, '$_');\n" }
174 % ( sort { $a cmp $b } @$to ) ). "
176 % function addOption_$name(object,value) {
177 % var length = object.length;
178 % object.options[length] = new Option(value, value, false, false);