Parent Directory
| 
Revision Log
Revision 919 - (view) (download) (as text)
| 1 : | sh002i | 798 | ################################################################################ |
| 2 : | # WeBWorK mod_perl (c) 2000-2002 WeBWorK Project | ||
| 3 : | # $Id$ | ||
| 4 : | ################################################################################ | ||
| 5 : | |||
| 6 : | package WeBWorK::DB::Utils; | ||
| 7 : | sh002i | 818 | use base qw(Exporter); |
| 8 : | sh002i | 798 | |
| 9 : | =head1 NAME | ||
| 10 : | |||
| 11 : | WeBWorK::DB::Utils - useful utilities for the database modules. | ||
| 12 : | |||
| 13 : | =cut | ||
| 14 : | |||
| 15 : | use strict; | ||
| 16 : | use warnings; | ||
| 17 : | sh002i | 919 | use Data::Dumper; |
| 18 : | sh002i | 798 | |
| 19 : | our @EXPORT = (); | ||
| 20 : | our @EXPORT_OK = qw( | ||
| 21 : | record2hash | ||
| 22 : | hash2record | ||
| 23 : | hash2string | ||
| 24 : | string2hash | ||
| 25 : | sh002i | 919 | findDefaults |
| 26 : | sh002i | 798 | ); |
| 27 : | |||
| 28 : | ################################################################################ | ||
| 29 : | # WWDBv2 record <-> WWDBv1 hash | ||
| 30 : | # not in the Record classes, since they are for legacy support | ||
| 31 : | ################################################################################ | ||
| 32 : | |||
| 33 : | sh002i | 808 | # RECORDHASH defines the correspondance between WWDBv1 hash keys and WWDBv2 |
| 34 : | # record fields. | ||
| 35 : | |||
| 36 : | sh002i | 798 | use constant RECORDHASH => { |
| 37 : | sh002i | 808 | "WeBWorK::DB::Record::User" => [ |
| 38 : | ['stfn', "first_name" ], | ||
| 39 : | ['stln', "last_name" ], | ||
| 40 : | ['stea', "email_address"], | ||
| 41 : | ['stid', "student_id" ], | ||
| 42 : | ['stst', "status" ], | ||
| 43 : | ['clsn', "section" ], | ||
| 44 : | ['clrc', "recitation" ], | ||
| 45 : | ['comt', "comment" ], | ||
| 46 : | sh002i | 798 | ], |
| 47 : | sh002i | 808 | "WeBWorK::DB::Record::UserSet" => [ |
| 48 : | ['stlg', "user_id" ], | ||
| 49 : | ['stnm', "set_id" ], | ||
| 50 : | ['shfn', "set_header" ], | ||
| 51 : | ['phfn', "problem_header"], | ||
| 52 : | ['opdt', "open_date" ], | ||
| 53 : | ['dudt', "due_date" ], | ||
| 54 : | ['andt', "answer_date" ], | ||
| 55 : | ], | ||
| 56 : | # a hash destined to be converted into a UserProblem must be converted | ||
| 57 : | # so that the hash keys, rather than containing the problem number, | ||
| 58 : | # contain the character '#'. Also, a new hash key '#' must be added | ||
| 59 : | # which contains the problem number. | ||
| 60 : | "WeBWorK::DB::Record::UserProblem" => [ | ||
| 61 : | ['stlg', "user_id" ], | ||
| 62 : | ['stnm', "set_id" ], | ||
| 63 : | ['#', "problem_id" ], | ||
| 64 : | ['pfn#', "source_file" ], | ||
| 65 : | ['pva#', "value" ], | ||
| 66 : | ['pmia#', "max_attempts" ], | ||
| 67 : | ['pse#', "problem_seed" ], | ||
| 68 : | ['pst#', "status" ], | ||
| 69 : | ['pat#', "attempted" ], | ||
| 70 : | ['pan#', "last_answer" ], | ||
| 71 : | ['pca#', "num_correct" ], | ||
| 72 : | ['pia#', "num_incorrect"], | ||
| 73 : | ], | ||
| 74 : | sh002i | 798 | # *** add tables for the rest of the record types |
| 75 : | }; | ||
| 76 : | |||
| 77 : | sub record2hash($) { | ||
| 78 : | my ($record) = @_; | ||
| 79 : | my $map = RECORDHASH->{ref $record}; | ||
| 80 : | die ref $record, ": unknown record type" unless defined $map; | ||
| 81 : | my %hash; | ||
| 82 : | for (my $i = 0; $i < @$map; $i++) { | ||
| 83 : | my ($v1, $v2) = @{$map->[$i]}; | ||
| 84 : | $hash{$v1} = $record->$v2; | ||
| 85 : | } | ||
| 86 : | return %hash; | ||
| 87 : | } | ||
| 88 : | |||
| 89 : | sub hash2record($@) { | ||
| 90 : | my ($type, %hash) = @_; | ||
| 91 : | my $map = RECORDHASH->{$type}; | ||
| 92 : | die $type, ": unknown record type" unless defined $map; | ||
| 93 : | my $record = $type->new(); | ||
| 94 : | for (my $i = 0; $i < @$map; $i++) { | ||
| 95 : | my ($v1, $v2) = @{$map->[$i]}; | ||
| 96 : | $record->$v2($hash{$v1}); | ||
| 97 : | } | ||
| 98 : | return $record; | ||
| 99 : | } | ||
| 100 : | |||
| 101 : | ################################################################################ | ||
| 102 : | # WWDBv1 hash <-> WWDBv1 string | ||
| 103 : | ################################################################################ | ||
| 104 : | |||
| 105 : | sub hash2string(@) { | ||
| 106 : | my %hash = @_; | ||
| 107 : | my $string; | ||
| 108 : | sh002i | 808 | return "" unless keys %hash; |
| 109 : | sh002i | 798 | foreach (keys %hash) { |
| 110 : | $hash{$_} = "" unless defined $hash{$_}; # promote undef to "" | ||
| 111 : | $hash{$_} =~ s/(=|&)/\\$1/g; # escape & and = | ||
| 112 : | $string .= "$_=$hash{$_}&"; | ||
| 113 : | } | ||
| 114 : | chop $string; # remove final '&' from string for old code :p | ||
| 115 : | return $string; | ||
| 116 : | } | ||
| 117 : | |||
| 118 : | sub string2hash($) { | ||
| 119 : | my $string = shift; | ||
| 120 : | return unless defined $string and $string; | ||
| 121 : | my %hash = $string =~ /(.*?)(?<!\\)=(.*?)(?:(?<!\\)&|$)/g; | ||
| 122 : | $hash{$_} =~ s/\\(&|=)/$1/g foreach keys %hash; # unescape & and = | ||
| 123 : | return %hash; | ||
| 124 : | } | ||
| 125 : | |||
| 126 : | sh002i | 919 | ################################################################################ |
| 127 : | # default generation | ||
| 128 : | ################################################################################ | ||
| 129 : | |||
| 130 : | sub findDefaults($@) { | ||
| 131 : | my ($globalClass, @Records) = @_; | ||
| 132 : | |||
| 133 : | my %fields = map { $_ => {} } $globalClass->FIELDS(); | ||
| 134 : | #delete $fields{$_} foreach $globalClass->KEYFIELDS(); | ||
| 135 : | |||
| 136 : | foreach my $Record (@Records) { | ||
| 137 : | print "RECORD IS: ", $Record->toString(), "\n"; | ||
| 138 : | foreach my $field (keys %fields) { | ||
| 139 : | my $value = $Record->$field(); | ||
| 140 : | if ($value eq "UNDEFINED") { | ||
| 141 : | die "Uh oh... value eq \"UNDEFINED\"\n"; | ||
| 142 : | } | ||
| 143 : | unless (defined $value) { | ||
| 144 : | $value = "UNDEFINED"; | ||
| 145 : | } | ||
| 146 : | $fields{$field}{$value}++; | ||
| 147 : | } | ||
| 148 : | } | ||
| 149 : | |||
| 150 : | warn "Frequencies: ", Dumper(\%fields); | ||
| 151 : | |||
| 152 : | my $Defaults = $globalClass->new(); | ||
| 153 : | foreach my $field (keys %fields) { | ||
| 154 : | my $maxFreq = 0; | ||
| 155 : | my $maxValue; | ||
| 156 : | foreach my $value (keys %{$fields{$field}}) { | ||
| 157 : | my $freq = $fields{$field}{$value}; | ||
| 158 : | if ($freq > $maxFreq) { | ||
| 159 : | $maxFreq = $freq; | ||
| 160 : | $maxValue = $value; | ||
| 161 : | } | ||
| 162 : | } | ||
| 163 : | undef $maxValue if $maxValue eq "UNDEFINED"; | ||
| 164 : | $Defaults->$field($maxValue); | ||
| 165 : | } | ||
| 166 : | |||
| 167 : | warn "Consensus defaults: ", Dumper($Defaults); | ||
| 168 : | |||
| 169 : | return $Defaults; | ||
| 170 : | } | ||
| 171 : | |||
| 172 : | sh002i | 798 | 1; |
| aubreyja at gmail dot com | ViewVC Help |
| Powered by ViewVC 1.0.9 |