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 switched App/DB.pm classes to blocks for clarity; added cache to prevent unnecessary db lookup on every request; tidied up & improved documentation 8 weeks ago
  lib simplified dpw summary.tt, using single info box to display results 7 weeks ago
  public new boostrap-style buttons; changed 'New Entry' button colour 8 weeks ago
  t discontinued layout, all content delivered by home.tt; adjusted test files to get record count from new 'home' request since htmx requests bypass index (home) page containing footer 8 weeks ago
  views simplified dpw summary.tt, using single info box to display results 7 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 3kB used alternative re-bless method inside DBIx query() and select() methods to provide new DBIx::Simple::Result::column() method, avoids using Module::Runtime 8 weeks ago
  config.yml 3kB moved tt 'between' method into new App::TT::Utils package; amended dpw summary filter requirement 8 weeks ago
  cpanfile 3kB commented cpanfile feature 'accelerate' for carmel install (doesn't directly support features); tidied up login.tt 8 weeks 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/ ================================================================================================ update sequences: $ git fetch && git merge ZBOX: $ sudo /etc/init.d/docslib restart $ tail -f logs/deployment.log volvox: $ docker compose restart $ dlogs -f documents_library