1. DocsLibrary.git
 RSS Git Download  Clone
  bin patched App::DBIx dump_query() method to handle INSERT statements; substitutions can be performed directly on $sql inside dump_query() without requiring separate $str variable as the function receives a copy of $sql var not a reference to it 3 months ago
  copilot-instructions.md moved download validator into App::Utils, added download validation to DPW 9 weeks ago
  db added checks for test plain-text password in config; documented data import/export for sqlite3 3 months ago
  documents reverted to earlier (uncommited) version of Log::Any function because most recently commited version was ignoring moinimum log level of tests (info), and presumably production (warnings) - note that use of Callback supposed to be deprecated in favour of Capture, but cannot make this method honour the min log-level setting 3 months ago
  environments changed how DPW model handles file upload functions for checking and setting upload directory: * moved duplicate code for checking existance of uploaded file into discrete function * initialised '_upload_dir' value as a param during file check function to avoid requierement for duplication in route and model; put rudimentary date check on sqlite3 db (still permits invalid dates); new test files 3 months ago
  lib extended edit-record function to delete existing file if new file uploaded during update submission, and new tests for file deletion 8 weeks ago
  public fixed left margin spacing of dpw filter menu 9 weeks ago
  t extended edit-record function to delete existing file if new file uploaded during update submission, and new tests for file deletion 8 weeks ago
  views extended edit-record function to delete existing file if new file uploaded during update submission, and new tests for file deletion 8 weeks ago
  .dancer initial commit - login route working 5 months ago
  .gitignore 324B extended edit-record function to delete existing file if new file uploaded during update submission, and new tests for file deletion 8 weeks ago
  Dockerfile 808B specify perl v5.34.0 in Dockerfile, as "FROM: 5.34" installs 5.34.3 which generated error loading Git directory (Can't use string ("/app/.git") as a HASH ref while "strict refs" in use at /usr/local/lib/perl5/site_perl/5.34.3/Error.pm); Model $git does not need to be a field, replaced with variable; reformatted footer 5 months ago
  Makefile.PL 801B initial commit - login route working 5 months ago
  README.txt 2kB layout tweaks; documented docker compose rebuild function 2 months ago
  config.yml 3kB moved documents_path setting to config_local.yml files to allow site-specific configuration; Moongate documents_path now defined in config_local.yml (same way DPW docs_path is defined); new test file for household based on moongate.t, most dpw.t tests now skipped as they are not htmx-aware 9 weeks ago
  cpanfile 3kB using Log::Any to facilitate model classes to forward messages to Dancer2 logger 3 months ago
  docker-compose.yml 465B replaced Starman with plackup, not required for low-use app; added restart always to docker-compose file; no longer supplying title to templates, using appname; added README file for relevant deployment info 5 months ago
  README.txt
* app is designed for perl v5.34.0 & Feature::Compat::Class, does not work on later since signatures are not handled unless perl >= 5.36 specified in 'use' * requires development_local.yml & test_local.yml in environments dir to run tests and dev server * any new function expects db name to be same as prefix * to dump query to console, set flag in development_local.yml, can be over-ridden by 'SQL_TRACE=0/1' command-line $ ln -s production.yml deployment.yml on volvox.online [Apache2] ================================================================== # /etc/apache2/websites/volvox.online.ssl # documents library (check running port map in docker-compose.yml): ProxyPass /docs-lib http://localhost:5001/docs-lib ProxyPassReverse /docs-lib http://localhost:5001/docs-lib # reconfig timezone for GB: $ dpkg-reconfigure tzdata [select 8 then 27] OR [https://stackoverflow.com/questions/44331836/apt-get-install-tzdata-noninteractive]: ARG DEBIAN_FRONTEND=noninteractive RUN apt-get update && apt-get install -y tzdata RUN unlink /etc/localtime RUN ln -s /usr/share/zoneinfo/Europe/London /etc/localtime ## to run: $ docker compose up -d ## to restart: $ docker compose [stop|start] documents_library # to rebuild: docker compose up --build --force-recreate --no-deps documents_library https://volvox.online/docs-lib on ZBOX [lighttpd] =================================================================================: $ plenv install 5.34.0 $ plenv local 5.34.0 $ plenv version # to confirm perl version $ plenv install-cpanm $ cpanm Carmel $ cpanm Plack $ carmel install $ carmel rollout $ plenv rehash # to test: $ perl -Ilocal/lib/perl5 local/bin/plackup [-E deployment] -p 5003 bin/app.psgi # for deployment, see bin/daemon-control.pl # \etc\lighttpd\conf-enabled\20-proxy.conf $HTTP["host"] =~ "docslib.zbox.local$" { server.document-root = "/home/raj/apps/DocsLibrary/public/" proxy.server = ( "" => ( ( "host" => "127.0.0.1", "port" => 5003, #"host" => "/tmp/docslib.sock", "check-local" => "disable", ) ) ) } on Windows client C:\Windows\System32\drivers\etc\hosts: 192.168.0.112 zbox.local [...] 192.168.0.112 docslib.zbox.local https://docslib.zbox.local/dpw/