Update Web-UI: use new error collection paradigm

- README.org: document how to run scripts manually
- manifest.scm: remove python-rq as a dependency
- qc_app/jobs.py: rework job launching and processing
- qc_app/parse.py: use reworked job processing
- qc_app/templates/job_progress.html: display progress correctly
- qc_app/templates/parse_results.html: display final results
- scripts/worker.py: new worker script

4 files changed, 143 insertions, 240 deletions

diff --git a/qc_app/jobs.py b/qc_app/jobs.py
index afea419..4d3dba6 100644
--- a/qc_app/jobs.py
+++ b/qc_app/jobs.py
@@ -1,82 +1,32 @@
-import jsonpickle
-import sqlite3
+import os
+import shlex
+import subprocess
+from uuid import uuid4
 
-from rq import Queue
-from rq.job import Job
 from redis import Redis
-from flask import current_app as app
 
-def enqueue_job(delayed_fn: str, *args, **kwargs):
-    """Add job to queue"""
-    with Redis.from_url(app.config["REDIS_URL"]) as rconn:
-        job = Job.create(
-            delayed_fn, args, **{
-                key: val for key, val in kwargs.items()
-                if key != "additional_jobs_meta"
-            },
-            connection = rconn,
-            timeout = "2h",
-            result_ttl = "5h",
-            failure_ttl = "5h"
-        )
+def error_filename(job_id, error_dir):
+    return f"{error_dir}/job_{job_id}.error"
 
-        queue = Queue("qcapp_queue", connection=rconn)
-        queue.enqueue_job(job)
+def launch_job(redis_conn: Redis, filepath, filetype, redisurl, error_dir):
+    """Launch a job in the background"""
+    job_id = str(uuid4())
+    command = [
+        "python3", "-m" "scripts.worker", filetype, filepath, redisurl, job_id]
+    job = {
+        "job_id": job_id, "command": shlex.join(command), "status": "pending",
+        "filename": os.path.basename(filepath), "percent": 0
+    }
+    redis_conn.hset(name=job["job_id"], mapping=job)
 
-    return job
+    if not os.path.exists(error_dir):
+        os.mkdir(error_dir)
 
-def job(job_id: str):
-    "Retrieve the job"
-    with Redis.from_url(app.config["REDIS_URL"]) as rconn:
-        queue = Queue("qcapp_queue", connection=rconn)
-        job = queue.fetch_job(job_id)
-        job.refresh()
+    with open(error_filename(job_id, error_dir), "w") as errorfile:
+        subprocess.Popen(command, stderr=errorfile)
 
     return job
 
-def create_jobs_table(dbpath: str):
-    """Create sqlite3 table to track job progress"""
-    conn = sqlite3.connect(dbpath)
-    cursor = conn.cursor()
-    cursor.execute("CREATE TABLE IF NOT EXISTS jobs(job_id TEXT, job_meta TEXT)")
-    cursor.close()
-    conn.close()
-
-def retrieve_meta(conn, job_id: str):
-    """Retrieve the job's metadata."""
-    meta = {}
-    try:
-        cursor = conn.cursor()
-        cursor.execute(
-            "SELECT * FROM jobs WHERE job_id=:job_id", {"job_id": job_id})
-        db_row = cursor.fetchone()
-        # meta = json.loads(db_row [1]) if db_row else {}
-        meta = jsonpickle.decode(db_row [1]) if db_row else {}
-    except Exception as exc:
-        cursor.close()
-        raise exc
-    finally:
-        cursor.close()
-
-    return meta
-
-def update_meta(conn, job_id: str, **meta):
-    """Update the job's metadata."""
-    try:
-        cursor = conn.cursor()
-        old_meta = retrieve_meta(conn, job_id)
-        meta = {**old_meta, **meta}
-        query = "UPDATE jobs SET job_meta = :meta WHERE job_id = :job_id"
-        if not bool(old_meta):
-            query = "INSERT INTO jobs VALUES (:job_id, :meta)"
-
-        cursor.execute(
-            query, {"job_id": job_id, "meta": jsonpickle.encode(meta)})
-        conn.commit()
-    except Exception as exc:
-        cursor.close()
-        raise exc
-    finally:
-        cursor.close()
-
-    return meta
+def job(redis_conn, job_id: str):
+    "Retrieve the job"
+    return redis_conn.hgetall(job_id)
diff --git a/qc_app/parse.py b/qc_app/parse.py
index baad9a6..d2fa030 100644
--- a/qc_app/parse.py
+++ b/qc_app/parse.py
@@ -1,10 +1,9 @@
 """File parsing module"""
 import os
-import sqlite3
 from functools import reduce
 
+import jsonpickle
 from redis import Redis
-from rq import get_current_job
 from flask import (
     request,
     url_for,
@@ -14,50 +13,13 @@ from flask import (
     current_app as app)
 
 from . import jobs
-from quality_control.errors import ParseError
+from quality_control.errors import InvalidValue
 from quality_control.parsing import (
     FileType,
-    parse_file,
-    strain_names,
-    parse_errors)
+    strain_names)
 
 parsebp = Blueprint("parse", __name__)
 
-def queued_parse(
-        filepath: str, filetype: FileType, strainsfile: str, redis_url: str,
-        dbpath: str):
-    job = get_current_job()
-    job_id = job.get_id()
-    with Redis.from_url(redis_url) as rconn:
-        dbconn = sqlite3.connect(dbpath)
-        try:
-            job_meta = jobs.update_meta(
-                dbconn, job_id, status = "in-progress", progress = 0)
-            parsed = parse_file(filepath, filetype, strain_names(strainsfile))
-            for line, curr_size in parsed:
-                job_meta = jobs.update_meta(
-                    dbconn, job_id,
-                    progress=((curr_size/job_meta["filesize"]) * 100),
-                    message = f"Parsed {curr_size} bytes")
-
-            os.remove(filepath)
-            jobs_meta = jobs.update_meta(
-                dbconn, job_id, progress = 100, status = "success",
-                message = "no errors found")
-        except ParseError as pe:
-            pe_dict = pe.args[0]
-            job_meta = jobs.update_meta(
-                dbconn, job_id, status = "parse-error", results = {
-                    "filename": os.path.basename(filepath), "filetype": filetype,
-                    "position": pe_dict["position"],
-                    "line_number": pe_dict["line_number"]
-                })
-        finally:
-            dbconn.close()
-
-def retrieve_dbpath():
-    return os.path.join(app.config["UPLOAD_FOLDER"], "jobs.db")
-
 @parsebp.route("/parse", methods=["GET"])
 def parse():
     """Trigger file parsing"""
@@ -73,6 +35,10 @@ def parse():
         flash("No filetype provided", "alert-error")
         errors = True
 
+    if filetype not in ("average", "standard-error"):
+        flash("Invalid filetype provided", "alert-error")
+        errors = True
+
     filepath = os.path.join(app.config["UPLOAD_FOLDER"], filename)
     if not os.path.exists(filepath):
         flash("Selected file does not exist (any longer)", "alert-danger")
@@ -81,144 +47,83 @@ def parse():
     if errors:
         return redirect(url_for("entry.index"))
 
-    jobs.create_jobs_table(retrieve_dbpath())
-    filetype = (
-        FileType.AVERAGE if filetype == "average" else FileType.STANDARD_ERROR)
-    job = jobs.enqueue_job(
-        "qc_app.parse.queued_parse", filepath, filetype,
-        os.path.join(os.getcwd(), "etc/strains.csv"), app.config["REDIS_URL"],
-        retrieve_dbpath())
-    try:
-        dbconn = sqlite3.connect(retrieve_dbpath())
-        jobs.update_meta(
-            dbconn, job.get_id(), filename=filename, filesize=os.stat(filepath).st_size,
-            status="enqueued", progress=0)
-    except Exception as exc:
-        import traceback
-        print(traceback.format_exc())
-        dbconn.rollback()
-    finally:
-        dbconn.close()
-
-    return redirect(url_for("parse.parse_status", job_id=job.get_id()))
+    with Redis.from_url(app.config["REDIS_URL"], decode_responses=True) as rconn:
+        job = jobs.launch_job(
+            rconn, filepath, filetype, app.config["REDIS_URL"],
+        f"{app.config['UPLOAD_FOLDER']}/job_errors")
+
+    return redirect(url_for("parse.parse_status", job_id=job["job_id"]))
 
 @parsebp.route("/status/<job_id>", methods=["GET"])
 def parse_status(job_id: str):
-    try:
-        dbconn = sqlite3.connect(retrieve_dbpath(), timeout=10)
-        job = jobs.job(job_id)
-        if job:
-            job_id = job.get_id()
-            job_meta = jobs.retrieve_meta(dbconn, job_id)
-            progress = job_meta["progress"]
-            status = job_meta["status"]
-            filename = job_meta.get("filename", "uploaded file")
-            if status == "success":
-                return redirect(url_for("parse.results", job_id=job_id))
-
-            if status == "parse-error":
+    with Redis.from_url(app.config["REDIS_URL"], decode_responses=True) as rconn:
+        job = jobs.job(rconn, job_id)
+
+    if job:
+        error_filename = jobs.error_filename(
+            job_id, f"{app.config['UPLOAD_FOLDER']}/job_errors")
+        if os.path.exists(error_filename):
+            stat = os.stat(error_filename)
+            if stat.st_size > 0:
                 return redirect(url_for("parse.fail", job_id=job_id))
 
-            return render_template(
-                "job_progress.html",
-                job_id = job_id,
-                job_status = status,
-                progress = progress,
-                message = job_meta.get("message", ""),
-                job_name = f"Parsing '{filename}'")
-
-        return render_template("no_such_job.html", job_id=job_id)
-    except sqlite3.OperationalError:
-        return redirect(url_for("parse.parse_status", job_id=job_id))
-    except Exception as exc:
-        import traceback
-        print(traceback.format_exc())
-        return exc
-    finally:
-        dbconn.close()
+        print(f"THE JOB {job}")
+        job_id = job["job_id"]
+        progress = float(job["percent"])
+        status = job["status"]
+        filename = job.get("filename", "uploaded file")
+        if status == "success":
+            return redirect(url_for("parse.results", job_id=job_id))
+
+        if status == "parse-error":
+            return redirect(url_for("parse.fail", job_id=job_id))
+
+        return render_template(
+            "job_progress.html",
+            job_id = job_id,
+            job_status = status,
+            progress = progress,
+            message = job.get("message", ""),
+            job_name = f"Parsing '{filename}'")
+
+    return render_template("no_such_job.html", job_id=job_id)
 
 @parsebp.route("/results/<job_id>", methods=["GET"])
 def results(job_id: str):
     """Show results of parsing..."""
-    job = jobs.job(job_id)
+    with Redis.from_url(app.config["REDIS_URL"], decode_responses=True) as rconn:
+        job = jobs.job(rconn, job_id)
+
     if job:
-        try:
-            dbconn = sqlite3.connect(retrieve_dbpath())
-            job_meta = jobs.retrieve_meta(dbconn, job_id)
-            filename = job_meta["filename"]
-            errors = job_meta.get("errors", [])
-            return render_template(
-                "parse_results.html",
-                errors=errors,
-                job_name = f"Parsing '{filename}'",
-                starting_line_number=job_meta.get("starting_line_number", 0))
-        except Exception as exc:
-            import traceback
-            print(traceback.format_exc())
-        finally:
-            dbconn.close()
+        filename = job["filename"]
+        errors = jsonpickle.decode(job["errors"])
+        return render_template(
+            "parse_results.html",
+            errors=errors,
+            job_name = f"Parsing '{filename}'",
+            isinvalidvalue=lambda item: isinstance(item, InvalidValue))
 
     return render_template("no_such_job.html", job_id=job_id)
 
-def queued_collect_errors(
-        filepath: str, filetype: FileType, strainsfile: str, redis_url: str,
-        dbpath: str, seek_pos: int = 0):
-    job = get_current_job()
-    job_id = job.get_id()
-    errors = []
-    count = 0
-    with Redis.from_url(redis_url) as rconn:
-        try:
-            dbconn = sqlite3.connect(dbpath)
-            job_meta = jobs.retrieve_meta(dbconn, job.get_id())
-            for error in parse_errors(
-                    filepath, filetype, strain_names(strainsfile),
-                    seek_pos):
-                count = count + 1
-                progress  = ((error["position"] / job_meta["filesize"]) * 100)
-                job_meta = jobs.update_meta(
-                    dbconn, job_id, message = f"Collected {count} errors",
-                    progress = progress)
-                errors.append(error)
-
-            job_meta = jobs.update_meta(
-                dbconn, job_id, errors = errors, progress = 100, status = "success")
-            os.remove(filepath)
-        except Exception as exc:
-            dbconn.rollback()
-        finally:
-            dbconn.close()
-
 @parsebp.route("/fail/<job_id>", methods=["GET"])
 def fail(job_id: str):
     """Handle parsing failure"""
-    try:
-        dbpath = retrieve_dbpath()
-        dbconn = sqlite3.connect(dbpath)
-        old_job = jobs.job(job_id)
-        if old_job:
-            job_id = old_job.get_id()
-            old_meta = jobs.retrieve_meta(dbconn, job_id)
-            progress = old_meta["progress"]
-            status = old_meta["status"]
-            results = old_meta["results"]
-            filename = old_meta["filename"]
-
-            new_job = jobs.enqueue_job(
-                "qc_app.parse.queued_collect_errors",
-                os.path.join(
-                    app.config["UPLOAD_FOLDER"], old_meta["filename"]),
-                results["filetype"], os.path.join(os.getcwd(), "etc/strains.csv"),
-                app.config["REDIS_URL"], dbpath, results["position"])
-            jobs.update_meta(
-                dbconn, new_job.get_id(), status =  "Collecting Errors",
-                filename = old_meta["filename"], filesize = old_meta["filesize"],
-                starting_line_number = results["line_number"],
-                progress = progress)
-            return redirect(url_for("parse.parse_status", job_id=new_job.get_id()))
-
-        return render_template("no_such_job.html", job_id=job_id)
-    except Exception as exc:
-        dbconn.rollback()
-    finally:
-        dbconn.close()
+    with Redis.from_url(app.config["REDIS_URL"], decode_responses=True) as rconn:
+        old_job = jobs.job(rconn, job_id)
+
+    if old_job:
+        error_filename = jobs.error_filename(
+            job_id, f"{app.config['UPLOAD_FOLDER']}/job_errors")
+        if os.path.exists(error_filename):
+            stat = os.stat(error_filename)
+            if stat.st_size > 0:
+                with open(error_filename) as errorfile:
+                    return errorfile.read()
+
+        # job_id = old_job["job_id"]
+        progress = old_job["progress"]
+        status = old_job["status"]
+        results = old_job["results"]
+        filename = old_job["filename"]
+
+    return render_template("no_such_job.html", job_id=job_id)
diff --git a/qc_app/templates/job_progress.html b/qc_app/templates/job_progress.html
index 26dfe6f..8a9256f 100644
--- a/qc_app/templates/job_progress.html
+++ b/qc_app/templates/job_progress.html
@@ -13,7 +13,7 @@
 <span>{{job_status}}: {{message}}</span><br />
 
 <label for="job_{{job_id}}">parsing: </label>
-<progress id="job_{{job_id}}" value="{{progress}}">{{progress}}</progress>
+<progress id="job_{{job_id}}" value="{{progress/100}}">{{progress}}</progress>
 <span>{{"%.2f" | format(progress)}}%</span>
 
 {%endblock%}
diff --git a/qc_app/templates/parse_results.html b/qc_app/templates/parse_results.html
new file mode 100644
index 0000000..a750bb5
--- /dev/null
+++ b/qc_app/templates/parse_results.html
@@ -0,0 +1,48 @@
+{%extends "base.html"%}
+
+{%block title%}Parse Results{%endblock%}
+
+{%block contents%}
+<h1 class="heading">{{job_name}}: parse results</h2>
+
+{%if errors | length == 0 %}
+<span class="alert-success">No errors found in the file</span>
+{%else %}
+<p class="alert-error">We found the following errors</p>
+
+<table class="reports-table">
+  <thead>
+    <tr>
+      <th>line number</th>
+      <th>column(s)</th>
+      <th>error</th>
+      <th>error message</th>
+    </tr>
+  </thead>
+
+  <tbody>
+    {%for error in errors%}
+    <tr>
+      <td>{{error["line"]}}</td>
+      <td>
+	{%if isinvalidvalue(error):%}
+	{{error.column}}
+	{%else: %}
+	{{error.columns}}
+	{%endif %}
+      </td>
+      <td>
+	{%if isinvalidvalue(error):%}
+	Invalid Value
+	{%else: %}
+	Duplicate Header
+	{%endif %}
+      </td>
+      <td>{{error["message"]}}</td>
+    </tr>
+    {%endfor%}
+  </tbody>
+</table>
+{%endif%}
+
+{%endblock%}