home · contact · privacy
Ensure DB connections are closed even on erroneous/failing HTTP requests.
[plomtask] / plomtask / http.py
index 933662f51f1a9b78754371c2399969afa0ca75df..f368232acd33dcc268ca296e69e0d34748f6fa2a 100644 (file)
@@ -24,17 +24,51 @@ class TaskServer(HTTPServer):
         self.jinja = JinjaEnv(loader=JinjaFSLoader(TEMPLATES_DIR))
 
 
+class ParamsParser:
+    """Wrapper for validating and retrieving GET params."""
+
+    def __init__(self, params: dict[str, list[str]]) -> None:
+        self.params = params
+
+    def get_str(self, key: str, default: str = '') -> str:
+        """Retrieve string value of key from self.params."""
+        if key not in self.params or 0 == len(self.params[key]):
+            return default
+        return self.params[key][0]
+
+    def get_int_or_none(self, key: str) -> int | None:
+        """Retrieve int value of key from self.params, on empty return None."""
+        if key not in self.params or \
+                0 == len(''.join(list(self.params[key]))):
+            return None
+        val_str = self.params[key][0]
+        try:
+            return int(val_str)
+        except ValueError as e:
+            raise BadFormatException(f'Bad ?{key}= value: {val_str}') from e
+
+
 class PostvarsParser:
-    """Postvars wrapper for validating and retrieving posted form data."""
+    """Postvars wrapper for validating and retrieving form data."""
 
     def __init__(self, postvars: dict[str, list[str]]) -> None:
         self.postvars = postvars
 
     def get_str(self, key: str) -> str:
         """Retrieve string value of key from self.postvars."""
-        if key not in self.postvars:
-            raise BadFormatException(f'missing value for form field: {key}')
-        return self.postvars[key][0]
+        all_str = self.get_all_str(key)
+        if 0 == len(all_str):
+            raise BadFormatException(f'missing value for key: {key}')
+        return all_str[0]
+
+    def get_int(self, key: str) -> int:
+        """Retrieve int value of key from self.postvars."""
+        val = self.get_str(key)
+        try:
+            return int(val)
+        except ValueError as e:
+            msg = f'cannot int form field value: {val}'
+            raise BadFormatException(msg) from e
 
     def get_float(self, key: str) -> float:
         """Retrieve float value of key from self.postvars."""
@@ -45,6 +79,21 @@ class PostvarsParser:
             msg = f'cannot float form field value: {val}'
             raise BadFormatException(msg) from e
 
+    def get_all_str(self, key: str) -> list[str]:
+        """Retrieve list of string values at key from self.postvars."""
+        if key not in self.postvars:
+            return []
+        return self.postvars[key]
+
+    def get_all_int(self, key: str) -> list[int]:
+        """Retrieve list of int values at key from self.postvars."""
+        all_str = self.get_all_str(key)
+        try:
+            return [int(s) for s in all_str if len(s) > 0]
+        except ValueError as e:
+            msg = f'cannot int a form field value: {all_str}'
+            raise BadFormatException(msg) from e
+
 
 class TaskHandler(BaseHTTPRequestHandler):
     """Handles single HTTP request."""
@@ -54,50 +103,46 @@ class TaskHandler(BaseHTTPRequestHandler):
         """Handle any GET request."""
         try:
             conn, site, params = self._init_handling()
-            if 'calendar' == site:
-                start = params.get('start', [''])[0]
-                end = params.get('end', [''])[0]
-                html = self.do_GET_calendar(conn, start, end)
-            elif 'day' == site:
-                date = params.get('date', [todays_date()])[0]
-                html = self.do_GET_day(conn, date)
-            elif 'process' == site:
-                id_ = params.get('id', [None])[0]
-                try:
-                    id__ = int(id_) if id_ else None
-                except ValueError as e:
-                    raise BadFormatException(f'Bad ?id= value: {id_}') from e
-                html = self.do_GET_process(conn, id__)
-            elif 'processes' == site:
-                html = self.do_GET_processes(conn)
+            if site in {'calendar', 'day', 'process', 'processes'}:
+                html = getattr(self, f'do_GET_{site}')(conn, params)
             elif '' == site:
                 self._redirect('/day')
                 return
             else:
                 raise NotFoundException(f'Unknown page: /{site}')
-            conn.close()
             self._send_html(html)
         except HandledException as error:
             self._send_msg(error, code=error.http_code)
+        finally:
+            conn.close()
 
     def do_GET_calendar(self, conn: DatabaseConnection,
-                        start: str, end: str) -> str:
-        """Show Days."""
+                        params: ParamsParser) -> str:
+        """Show Days from ?start= to ?end=."""
+        start = params.get_str('start')
+        end = params.get_str('end')
         days = Day.all(conn, date_range=(start, end), fill_gaps=True)
         return self.server.jinja.get_template('calendar.html').render(
                 days=days, start=start, end=end)
 
-    def do_GET_day(self, conn: DatabaseConnection, date: str) -> str:
-        """Show single Day."""
+    def do_GET_day(self, conn: DatabaseConnection,
+                   params: ParamsParser) -> str:
+        """Show single Day of ?date=."""
+        date = params.get_str('date', todays_date())
         day = Day.by_date(conn, date, create=True)
         return self.server.jinja.get_template('day.html').render(day=day)
 
-    def do_GET_process(self, conn: DatabaseConnection, id_: int | None) -> str:
-        """Show process of id_."""
+    def do_GET_process(self, conn: DatabaseConnection,
+                       params: ParamsParser) -> str:
+        """Show process of ?id=."""
+        id_ = params.get_int_or_none('id')
+        process = Process.by_id(conn, id_, create=True)
         return self.server.jinja.get_template('process.html').render(
-                process=Process.by_id(conn, id_, create=True))
+                process=process, children=process.get_descendants(conn),
+                candidates=Process.all(conn))
 
-    def do_GET_processes(self, conn: DatabaseConnection) -> str:
+    def do_GET_processes(self, conn: DatabaseConnection,
+                         _: ParamsParser) -> str:
         """Show all Processes."""
         return self.server.jinja.get_template('processes.html').render(
                 processes=Process.all(conn))
@@ -108,46 +153,44 @@ class TaskHandler(BaseHTTPRequestHandler):
             conn, site, params = self._init_handling()
             length = int(self.headers['content-length'])
             postvars = parse_qs(self.rfile.read(length).decode(),
-                                keep_blank_values=True)
+                                keep_blank_values=True, strict_parsing=True)
             form_data = PostvarsParser(postvars)
-            if 'day' == site:
-                date = params.get('date', [''])[0]
-                self.do_POST_day(conn, date, form_data)
-            elif 'process' == site:
-                id_ = params.get('id', [''])[0]
-                try:
-                    id__ = int(id_) if id_ else None
-                except ValueError as e:
-                    raise BadFormatException(f'Bad ?id= value: {id_}') from e
-                self.do_POST_process(conn, id__, form_data)
-            conn.commit()
-            conn.close()
+            if site in ('day', 'process'):
+                getattr(self, f'do_POST_{site}')(conn, params, form_data)
+                conn.commit()
+            else:
+                msg = f'Page not known as POST target: /{site}'
+                raise NotFoundException(msg)
             self._redirect('/')
         except HandledException as error:
             self._send_msg(error, code=error.http_code)
+        finally:
+            conn.close()
 
-    def do_POST_day(self, conn: DatabaseConnection, date: str,
+    def do_POST_day(self, conn: DatabaseConnection, params: ParamsParser,
                     form_data: PostvarsParser) -> None:
         """Update or insert Day of date and fields defined in postvars."""
+        date = params.get_str('date')
         day = Day.by_date(conn, date, create=True)
         day.comment = form_data.get_str('comment')
         day.save(conn)
 
-    def do_POST_process(self, conn: DatabaseConnection, id_: int | None,
+    def do_POST_process(self, conn: DatabaseConnection, params: ParamsParser,
                         form_data: PostvarsParser) -> None:
-        """Update or insert Process of id_ and fields defined in postvars."""
+        """Update or insert Process of ?id= and fields defined in postvars."""
+        id_ = params.get_int_or_none('id')
         process = Process.by_id(conn, id_, create=True)
         process.title.set(form_data.get_str('title'))
         process.description.set(form_data.get_str('description'))
         process.effort.set(form_data.get_float('effort'))
+        process.child_ids = form_data.get_all_int('children')
         process.save(conn)
 
-    def _init_handling(self) -> \
-            tuple[DatabaseConnection, str, dict[str, list[str]]]:
+    def _init_handling(self) -> tuple[DatabaseConnection, str, ParamsParser]:
         conn = DatabaseConnection(self.server.db)
         parsed_url = urlparse(self.path)
         site = path_split(parsed_url.path)[1]
-        params = parse_qs(parsed_url.query)
+        params = ParamsParser(parse_qs(parsed_url.query, strict_parsing=True))
         return conn, site, params
 
     def _redirect(self, target: str) -> None: