chiark
/
gitweb
/
~yarrgweb
/
ypp-sc-tools.db-test.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Normalise commodity name case (from uploads)
[ypp-sc-tools.db-test.git]
/
yarrg
/
commod-email-processor
diff --git
a/yarrg/commod-email-processor
b/yarrg/commod-email-processor
index 8acf4c105d118c38d99f49425eea89806c0a0f76..ff0880e9c876d6f14118d38c00149130de511f18 100755
(executable)
--- a/
yarrg/commod-email-processor
+++ b/
yarrg/commod-email-processor
@@
-34,6
+34,8
@@
BEGIN {
my $selfdir= $0;
$selfdir =~ s,/+[^/]*$,,;
chdir("$selfdir") or die "$selfdir $!";
my $selfdir= $0;
$selfdir =~ s,/+[^/]*$,,;
chdir("$selfdir") or die "$selfdir $!";
+
+ unshift @INC, qw(.);
}
use Commods;
}
use Commods;
@@
-195,8
+197,9
@@
sub main () {
pipethrough_run_finish($pt, 'gunzip <$deduped_tsv.gz');
# print "\n";
pipethrough_run_finish($pt, 'gunzip <$deduped_tsv.gz');
# print "\n";
- db_chkcommit();
+ db_chkcommit(
0
);
+ # Warning! Below runes are bogus. Do not use NATURAL JOIN!
# select * from ((buy natural join commods) natural join stalls) natural join islands;
# select * from ((sell natural join commods) natural join stalls) natural join islands;
# select * from ((buy natural join commods) natural join stalls) natural join islands;
# select * from ((sell natural join commods) natural join stalls) natural join islands;