From: Mischa POSLAWSKY <perl@shiar.org>
Date: Mon, 25 May 2020 03:23:02 +0000 (+0200)
Subject: word edit: prio(rity level) column input
X-Git-Tag: v1.13~255
X-Git-Url: http://git.shiar.nl/sheet.git/commitdiff_plain/77eb26995a1185e50b2b275f058264857bed9cc7

word edit: prio(rity level) column input
---

diff --git a/tools/word.pg.sql b/tools/word.pg.sql
index 3c4f264..6cab79d 100644
--- a/tools/word.pg.sql
+++ b/tools/word.pg.sql
@@ -3,6 +3,7 @@ CREATE TABLE word (
 	lang       text        NOT NULL DEFAULT 'eng',
 	cat        integer              REFERENCES word (id),
 	ref        integer              REFERENCES word (id),
+	prio       smallint    NOT NULL DEFAULT '1',
 	source     text,
 	thumb      text[],
 	wptitle    text,
@@ -14,6 +15,7 @@ COMMENT ON COLUMN word.form       IS 'preferred textual representation';
 COMMENT ON COLUMN word.lang       IS 'ISO 639-3 language code';
 COMMENT ON COLUMN word.cat        IS 'hierarchical classification';
 COMMENT ON COLUMN word.ref        IS 'reference to equivalent eng translation';
+COMMENT ON COLUMN word.prio       IS 'difficulty level or importance; lower values have precedence';
 COMMENT ON COLUMN word.source     IS 'URI of downloaded image';
 COMMENT ON COLUMN word.thumb      IS 'ImageMagick convert options to create thumbnail from source image';
 COMMENT ON COLUMN word.wptitle    IS 'reference Wikipedia article';
diff --git a/writer.plp b/writer.plp
index 288891a..275909b 100644
--- a/writer.plp
+++ b/writer.plp
@@ -108,13 +108,14 @@ my $db = eval {
 } or Abort('Database error', 501, $@);
 
 my @wordcols = (
+	lang    => 'Language',
+	cat     => 'Category',
 	form    => 'Translation',
 	wptitle => 'Wikipedia',
-	ref     => 'Reference',
-	cat     => 'Category',
-	lang    => 'Language',
 	source  => 'Image URL',
 	thumb   => 'Convert options',
+	prio    => 'Level',
+	ref     => 'Reference',
 );
 my ($find) = map {{id => $_}} $fields{id} || $Request || ();
 
@@ -125,7 +126,7 @@ if ($find) {
 }
 
 if (exists $get{copy}) {
-	$row = {%{$row}{ qw(lang cat) }};
+	$row = {%{$row}{ qw(prio lang cat) }};
 }
 elsif ($ENV{REQUEST_METHOD} eq 'POST') {{
 	my $replace = $row;
@@ -187,6 +188,7 @@ elsif ($ENV{REQUEST_METHOD} eq 'POST') {{
 	}
 }}
 else {
+	$row->{prio} //= 1;
 	$row->{$_} = $get{$_} for keys %get;
 }