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
  db added checks for test plain-text password in config; documented data import/export for sqlite3 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 added password reveal function on login form; logout function redirects to prefix home not root url 3 months ago
  public extended app to provide household/dpw function; provided session expiry time display; increased dev env cookie_duration (but session still times out too early); sync'd InfoLib & Moongate save_document() methods with DPW class (using global @cols) 3 months ago
  t implemented Local::Utils dump_query function, and a package (App::DB::Result) to overload DBIx::Simple::Result, but its functions are not available to App::DBIx, possibly due to Feature::Compat::Class limitations 3 months ago
  views added password reveal function on login form; logout function redirects to prefix home not root url 3 months ago
  .dancer initial commit - login route working 5 months ago
  .gitignore 261B 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
  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 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
  config.yml 3kB changed household documents path to ~/Documents/docs-lib for backup reasons due to impending directory size (maybe Moongate to follow) 3 months ago
  cpanfile 3kB implemented Local::Utils dump_query function, and a package (App::DB::Result) to overload DBIx::Simple::Result, but its functions are not available to App::DBIx, possibly due to Feature::Compat::Class limitations 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 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/