1: #!/usr/bin/perl
2: # The LearningOnline Network
3: # searchcat.pl "Search Catalog" batch script
4: #
5: # $Id: searchcat.pl,v 1.16 2002/03/04 05:06:18 harris41 Exp $
6: #
7: # Copyright Michigan State University Board of Trustees
8: #
9: # This file is part of the LearningOnline Network with CAPA (LON-CAPA).
10: #
11: # LON-CAPA is free software; you can redistribute it and/or modify
12: # it under the terms of the GNU General Public License as published by
13: # the Free Software Foundation; either version 2 of the License, or
14: # (at your option) any later version.
15: #
16: # LON-CAPA is distributed in the hope that it will be useful,
17: # but WITHOUT ANY WARRANTY; without even the implied warranty of
18: # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
19: # GNU General Public License for more details.
20: #
21: # You should have received a copy of the GNU General Public License
22: # along with LON-CAPA; if not, write to the Free Software
23: # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
24: #
25: # /home/httpd/html/adm/gpl.txt
26: #
27: # http://www.lon-capa.org/
28: #
29: # YEAR=2001
30: #
31: # 04/14/2001, 04/16/2001 Scott Harrison
32: #
33: ###
34:
35: # This script goes through a LON-CAPA resource
36: # directory and gathers metadata.
37: # The metadata is entered into a SQL database.
38:
39: use IO::File;
40: use HTML::TokeParser;
41: use DBI;
42:
43: my @metalist;
44: # ----------------- Code to enable 'find' subroutine listing of the .meta files
45: require "find.pl";
46: sub wanted {
47: (($dev,$ino,$mode,$nlink,$uid,$gid) = lstat($_)) &&
48: -f _ &&
49: /^.*\.meta$/ && !/^.+\.\d+\.[^\.]+\.meta$/ &&
50: push(@metalist,"$dir/$_");
51: }
52:
53: # ------------------------------------ Read httpd access.conf and get variables
54: open (CONFIG,"/etc/httpd/conf/access.conf") || die "Can't read access.conf";
55:
56: while ($configline=<CONFIG>) {
57: if ($configline =~ /PerlSetVar/) {
58: my ($dummy,$varname,$varvalue)=split(/\s+/,$configline);
59: chomp($varvalue);
60: $perlvar{$varname}=$varvalue;
61: }
62: }
63: close(CONFIG);
64:
65: # ------------------------------------- Only run if machine is a library server
66: exit unless $perlvar{'lonRole'} eq 'library';
67:
68: my $dbh;
69: # ------------------------------------- Make sure that database can be accessed
70: {
71: unless (
72: $dbh = DBI->connect("DBI:mysql:loncapa","www",$perlvar{'lonSqlAccess'},{ RaiseError =>0,PrintError=>0})
73: ) {
74: print "Cannot connect to database!\n";
75: exit;
76: }
77: }
78:
79: # ------------------------------------------------------------- get .meta files
80: opendir(RESOURCES,"$perlvar{'lonDocRoot'}/res/$perlvar{'lonDefDomain'}");
81: my @homeusers=grep
82: {&ishome("$perlvar{'lonDocRoot'}/res/$perlvar{'lonDefDomain'}/$_")}
83: grep {!/^\.\.?$/} readdir(RESOURCES);
84: closedir RESOURCES;
85: foreach my $user (@homeusers) {
86: &find("$perlvar{'lonDocRoot'}/res/$perlvar{'lonDefDomain'}/$user");
87: }
88:
89: # -- process each file to get metadata and put into search catalog SQL database
90: # Also, check to see if already there.
91: # I could just delete (without searching first), but this works for now.
92: foreach my $m (@metalist) {
93: my $ref=&metadata($m);
94: my $m2='/res/'.&declutter($m);
95: $m2=~s/\.meta$//;
96: my $q2="select * from metadata where url like binary '$m2'";
97: my $sth = $dbh->prepare($q2);
98: $sth->execute();
99: my $r1=$sth->fetchall_arrayref;
100: if (@$r1) {
101: $sth=$dbh->prepare("delete from metadata where url like binary '$m2'");
102: $sth->execute();
103: }
104: $sth=$dbh->prepare('insert into metadata values ('.
105: '"'.delete($ref->{'title'}).'"'.','.
106: '"'.delete($ref->{'author'}).'"'.','.
107: '"'.delete($ref->{'subject'}).'"'.','.
108: '"'.$m2.'"'.','.
109: '"'.delete($ref->{'keywords'}).'"'.','.
110: '"'.'current'.'"'.','.
111: '"'.delete($ref->{'notes'}).'"'.','.
112: '"'.delete($ref->{'abstract'}).'"'.','.
113: '"'.delete($ref->{'mime'}).'"'.','.
114: '"'.delete($ref->{'language'}).'"'.','.
115: '"'.sqltime(delete($ref->{'creationdate'})).'"'.','.
116: '"'.sqltime(delete($ref->{'lastrevisiondate'})).'"'.','.
117: '"'.delete($ref->{'owner'}).'"'.','.
118: '"'.delete($ref->{'copyright'}).'"'.')');
119: $sth->execute();
120: }
121:
122: # ----------------------------------------------------------- Clean up database
123: # Need to, perhaps, remove stale SQL database records.
124: # ... not yet implemented
125:
126: # --------------------------------------------------- Close database connection
127: $dbh->disconnect;
128:
129: # ---------------------------------------------------------------- Get metadata
130: # significantly altered from subroutine present in lonnet
131: sub metadata {
132: my ($uri,$what)=@_;
133: my %metacache;
134: $uri=&declutter($uri);
135: my $filename=$uri;
136: $uri=~s/\.meta$//;
137: $uri='';
138: unless ($metacache{$uri.'keys'}) {
139: unless ($filename=~/\.meta$/) { $filename.='.meta'; }
140: my $metastring=&getfile($perlvar{'lonDocRoot'}.'/res/'.$filename);
141: my $parser=HTML::TokeParser->new(\$metastring);
142: my $token;
143: while ($token=$parser->get_token) {
144: if ($token->[0] eq 'S') {
145: my $entry=$token->[1];
146: my $unikey=$entry;
147: if (defined($token->[2]->{'part'})) {
148: $unikey.='_'.$token->[2]->{'part'};
149: }
150: if (defined($token->[2]->{'name'})) {
151: $unikey.='_'.$token->[2]->{'name'};
152: }
153: if ($metacache{$uri.'keys'}) {
154: $metacache{$uri.'keys'}.=','.$unikey;
155: } else {
156: $metacache{$uri.'keys'}=$unikey;
157: }
158: map {
159: $metacache{$uri.''.$unikey.'.'.$_}=$token->[2]->{$_};
160: } @{$token->[3]};
161: unless (
162: $metacache{$uri.''.$unikey}=$parser->get_text('/'.$entry)
163: ) { $metacache{$uri.''.$unikey}=
164: $metacache{$uri.''.$unikey.'.default'};
165: }
166: }
167: }
168: }
169: return \%metacache;
170: }
171:
172: # ------------------------------------------------------------ Serves up a file
173: # returns either the contents of the file or a -1
174: sub getfile {
175: my $file=shift;
176: if (! -e $file ) { return -1; };
177: my $fh=IO::File->new($file);
178: my $a='';
179: while (<$fh>) { $a .=$_; }
180: return $a
181: }
182:
183: # ------------------------------------------------------------- Declutters URLs
184: sub declutter {
185: my $thisfn=shift;
186: $thisfn=~s/^$perlvar{'lonDocRoot'}//;
187: $thisfn=~s/^\///;
188: $thisfn=~s/^res\///;
189: return $thisfn;
190: }
191:
192: # --------------------------------------- Is this the home server of an author?
193: # (copied from lond, modification of the return value)
194: sub ishome {
195: my $author=shift;
196: $author=~s/\/home\/httpd\/html\/res\/([^\/]*)\/([^\/]*).*/$1\/$2/;
197: my ($udom,$uname)=split(/\//,$author);
198: my $proname=propath($udom,$uname);
199: if (-e $proname) {
200: return 1;
201: } else {
202: return 0;
203: }
204: }
205:
206: # -------------------------------------------- Return path to profile directory
207: # (copied from lond)
208: sub propath {
209: my ($udom,$uname)=@_;
210: $udom=~s/\W//g;
211: $uname=~s/\W//g;
212: my $subdir=$uname.'__';
213: $subdir =~ s/(.)(.)(.).*/$1\/$2\/$3/;
214: my $proname="$perlvar{'lonUsersDir'}/$udom/$subdir/$uname";
215: return $proname;
216: }
217:
218: # ---------------------------- convert 'time' format into a datetime sql format
219: sub sqltime {
220: my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) =
221: localtime(@_[0]);
222: $mon++; $year+=1900;
223: return "$year-$mon-$mday $hour:$min:$sec";
224: }
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>
![[BACK]](/icons/back.gif){kind=icon}
Return to searchcat.pl CVS log ![[TXT]](/icons/text.gif){kind=icon}
![[DIR]](/icons/dir.gif){kind=icon}
Up to [LON-CAPA] / loncom / metadata_database