From 2bbbda58a5e2c56be6ad88ad3a296ec1b2a833fb Mon Sep 17 00:00:00 2001 From: Ralph Amissah Date: Wed, 16 Nov 2022 13:02:42 -0500 Subject: configs housekeeping, minor --- flake.lock | 42 +++++++++++++++++++++++ flake.nix | 6 ++++ makefile | 5 ++- org/config_make.org | 22 ++++++------ org/config_misc.org | 8 ++--- org/config_nix.org | 22 +++++++++--- org/out_sqlite.org | 64 ++++++++++++++++++++--------------- shell.nix | 2 +- sundry/spine_search_cgi/.envrc-local_ | 8 ++--- sundry/spine_search_cgi/makefile | 2 +- 10 files changed, 124 insertions(+), 57 deletions(-) create mode 100644 flake.lock diff --git a/flake.lock b/flake.lock new file mode 100644 index 0000000..03fbc0c --- /dev/null +++ b/flake.lock @@ -0,0 +1,42 @@ +{ + "nodes": { + "flake-utils": { + "locked": { + "lastModified": 1667395993, + "narHash": "sha256-nuEHfE/LcWyuSWnS8t12N1wc105Qtau+/OdUAjtQ0rA=", + "owner": "numtide", + "repo": "flake-utils", + "rev": "5aed5285a952e0b949eb3ba02c12fa4fcfef535f", + "type": "github" + }, + "original": { + "owner": "numtide", + "repo": "flake-utils", + "type": "github" + } + }, + "nixpkgs": { + "locked": { + "lastModified": 1669044098, + "narHash": "sha256-VA54lmEGdtcQfE+YCtGlaMwiUMS0/K/+bz4/iPnLQ7c=", + "owner": "nixos", + "repo": "nixpkgs", + "rev": "19230cff31fd7562562dd25181579fa7087f0f89", + "type": "github" + }, + "original": { + "owner": "nixos", + "repo": "nixpkgs", + "type": "github" + } + }, + "root": { + "inputs": { + "flake-utils": "flake-utils", + "nixpkgs": "nixpkgs" + } + } + }, + "root": "root", + "version": 7 +} diff --git a/flake.nix b/flake.nix index 075ce50..5bb4716 100644 --- a/flake.nix +++ b/flake.nix @@ -75,3 +75,9 @@ packages.x86_64-linux.default = self.packages.x86_64-linux.spine; }; } + +#nix flake update +#nix flake check +#nix flake show +#nix develop +#nix build .#default --print-build-logs diff --git a/makefile b/makefile index 69d68d4..aec02fd 100644 --- a/makefile +++ b/makefile @@ -82,7 +82,7 @@ data/pod/viral_spiral.david_bollier Date := `date "+%Y%m%d"` SpineBIN := "${SpineBIN}" # './result/bin' SpineOUT := "${SpineOUT}" # '/srv/www/spine' -SpinePOD := "${SpinePOD}" # '/grotto-ra/repo/git.repo/projects/project-spine/doc-reform-markup/spine-markup-samples/markup/pod' +SpinePOD := "${SpinePOD}" # '~/grotto/repo/git.repo/projects/project-spine/doc-reform-markup/spine-markup-samples/markup/pod' SpineSearchActionLocal := 'http://localhost/spine_search' SpineSearchActionRemote := 'https://sisudoc.org/spine_search' SpineCGIform := 'spine_search' @@ -498,10 +498,9 @@ nixGitHEADtarballTar: # check test tarball nixGitHEADtarballCheck: nix flake check file://${hwd}/tarballGitHEAD/spine-${PROG_VER_DECLARED}.tar.gz; \ + nix flake lock file://${hwd}/tarballGitHEAD/spine-${PROG_VER_DECLARED}.tar.gz; \ nix flake show file://${hwd}/tarballGitHEAD/spine-${PROG_VER_DECLARED}.tar.gz; -# nix flake lock file://${hwd}/tarballGitHEAD/spine-${PROG_VER_DECLARED}.tar.gz; \ - # build test tarball nixGitHEADtarballBuild: echo "nix build file://${hwd}/tarballGitHEAD/spine-${PROG_VER_DECLARED}.tar.gz#spine --print-build-logs" diff --git a/org/config_make.org b/org/config_make.org index 42c5fb4..9f4b00b 100644 --- a/org/config_make.org +++ b/org/config_make.org @@ -296,7 +296,7 @@ postInstall: Date := `date "+%Y%m%d"` SpineBIN := "${SpineBIN}" # './result/bin' SpineOUT := "${SpineOUT}" # '/srv/www/spine' -SpinePOD := "${SpinePOD}" # '/grotto-ra/repo/git.repo/projects/project-spine/doc-reform-markup/spine-markup-samples/markup/pod' +SpinePOD := "${SpinePOD}" # '~/grotto/repo/git.repo/projects/project-spine/doc-reform-markup/spine-markup-samples/markup/pod' SpineSearchActionLocal := 'http://localhost/spine_search' SpineSearchActionRemote := 'https://sisudoc.org/spine_search' SpineCGIform := 'spine_search' @@ -1741,10 +1741,10 @@ export NIX_PATH=/nix/var/nix/profiles/per-user/root/channels/nixos # eval "$(nix print-dev-env)" # echo $NIX_BUILD_TOP export SpineVER=$(git describe --long --tags | sed 's/^[ a-z_-]\+\([0-9.]\+\)/\1/;s/\([^-]*-g\)/r\1/;s/-/./g') -export SpinePROJ=/grotto-ra/repo/git.repo/projects/project-spine/doc-reform -export SpineSRC=/grotto-ra/repo/git.repo/projects/project-spine/doc-reform/src -export SpineBIN=/grotto-ra/repo/git.repo/projects/project-spine/doc-reform/result/bin -export SpineDOC=/grotto-ra/repo/git.repo/projects/project-spine/doc-reform-markup/spine-markup-samples +export SpinePROJ=~/grotto/repo/git.repo/projects/project-spine/doc-reform +export SpineSRC=~/grotto/repo/git.repo/projects/project-spine/doc-reform/src +export SpineBIN=~/grotto/repo/git.repo/projects/project-spine/doc-reform/result/bin +export SpineDOC=~/grotto/repo/git.repo/projects/project-spine/doc-reform-markup/spine-markup-samples export SpinePOD=$SpineDOC/markup/pod export SpineOUTversioned=/srv/www/spine/$SpineVER export SpineOUT=/srv/www/spine @@ -1772,7 +1772,7 @@ fi #+BEGIN_SRC makefile SpineBIN := "${SpineBIN}" # 'result/bin' SpineOUT := "${SpineOUT}" # '/srv/www/spine' -SpinePOD := "${SpinePOD}" # '/grotto-ra/repo/git.repo/projects/project-spine/doc-reform-markup/spine-markup-samples/markup/pod' +SpinePOD := "${SpinePOD}" # '~/grotto/repo/git.repo/projects/project-spine/doc-reform-markup/spine-markup-samples/markup/pod' SpineSearchAction := 'https://sisudoc.org/spine_search' SpineCGIform := 'spine_search' SpineSQLdb := 'spine.search.db' @@ -2038,22 +2038,22 @@ ls *.tex; ls *.pdf; #+NAME: spine_proj #+BEGIN_SRC sh -/grotto-ra/repo/git.repo/projects/project-spine/doc-reform +~/grotto/repo/git.repo/projects/project-spine/doc-reform #+END_SRC #+NAME: spine_src #+BEGIN_SRC sh -/grotto-ra/repo/git.repo/projects/project-spine/doc-reform/src +~/grotto/repo/git.repo/projects/project-spine/doc-reform/src #+END_SRC #+NAME: spine_bin #+BEGIN_SRC sh -/grotto-ra/repo/git.repo/projects/project-spine/doc-reform/result/bin +~/grotto/repo/git.repo/projects/project-spine/doc-reform/result/bin #+END_SRC #+NAME: spine_doc #+BEGIN_SRC sh -/grotto-ra/repo/git.repo/projects/project-spine/doc-reform-markup/spine-markup-samples +~/grotto/repo/git.repo/projects/project-spine/doc-reform-markup/spine-markup-samples #+END_SRC #+NAME: spine_pod @@ -2159,7 +2159,7 @@ export NIX_PATH=/nix/var/nix/profiles/per-user/root/channels/nixos ## load the flake devShell # eval "$(nix print-dev-env)" # echo $NIX_BUILD_TOP -export PROJ="/grotto-ra/repo/git.repo/projects/project-spine" +export PROJ="~/grotto/repo/git.repo/projects/project-spine" export SpinePROJ=<> export SpineSRC=<> export SpineBIN=<> diff --git a/org/config_misc.org b/org/config_misc.org index e3045e4..c60d0cb 100644 --- a/org/config_misc.org +++ b/org/config_misc.org @@ -156,13 +156,13 @@ find data/sisudir/media/text -name *.ss[tm] | sort | xargs ~dr/bin/spine-ldc -q --show-config --html --output=/var/www/html ~grotto/repo/git.repo/code/project-spine/doc-reform-markup/markup_samples/markup/pod -~dr/bin/spine-ldc -q --show-config ~grotto/repo/git.repo/code/project-spine/doc-reform-markup/markup_samples/markup/pod +~dr/bin/spine-ldc -q --show-config ~/grotto/repo/git.repo/code/project-spine/doc-reform-markup/markup_samples/markup/pod -~dr/result/bin/spine --html --output=/var/www/html /grotto-ra/repo/git.repo/projects/project-spine/doc-reform-markup/markup_samples/markup/pod/* +~dr/result/bin/spine --html --output=/var/www/html ~/grotto/repo/git.repo/projects/project-spine/doc-reform-markup/markup_samples/markup/pod/* -~dr/result/bin/spine --very-verbose --sqlite-db-create --sqlite-db-filename="spine.search.db" --cgi-sqlite-search-filename="spine-search" --output=/var/www /grotto-ra/repo/git.repo/projects/project-spine/doc-reform-markup/markup_samples/markup/pod/* +~dr/result/bin/spine --very-verbose --sqlite-db-create --sqlite-db-filename="spine.search.db" --cgi-sqlite-search-filename="spine-search" --output=/var/www ~/grotto/repo/git.repo/projects/project-spine/doc-reform-markup/markup_samples/markup/pod/* -~dr/result/bin/spine --very-verbose --sqlite-update --sqlite-db-filename="spine.search.db" --cgi-sqlite-search-filename="spine-search" --output=/var/www /grotto-ra/repo/git.repo/projects/project-spine/doc-reform-markup/markup_samples/markup/pod/* +~dr/result/bin/spine --very-verbose --sqlite-update --sqlite-db-filename="spine.search.db" --cgi-sqlite-search-filename="spine-search" --output=/var/www ~/grotto/repo/git.repo/projects/project-spine/doc-reform-markup/markup_samples/markup/pod/* #+END_SRC - produces: diff --git a/org/config_nix.org b/org/config_nix.org index 4a637a4..a62990f 100644 --- a/org/config_nix.org +++ b/org/config_nix.org @@ -471,7 +471,7 @@ postInstall: - nix develop -- nix flake lock +- nix flake update - nix shell -f default.nix --print-build-logs - nix shell -c default.nix @@ -567,8 +567,20 @@ postInstall: packages.x86_64-linux.default = self.packages.x86_64-linux.spine; }; } + +#nix flake update +#nix flake check +#nix flake show +#nix develop +#nix build .#default --print-build-logs #+END_SRC +#+BEGIN_SRC nix +src = fetchTarball { + url = "file:///[path]/$(pname)-$(version).tar.gz"; + sha256 = "sha256:0000000000000000000000000000000000000000000000000000"; +}; +#+END_SRC #+HEADER: :noweb yes #+BEGIN_SRC nix { @@ -696,7 +708,7 @@ mkShell { #if [[ -f ".envrc" ]]; then # source .envrc #fi - nix flake lock --update-input nixpkgs + nix flake update echo "" echo "nix flake metadata:" nix flake metadata @@ -1402,7 +1414,7 @@ $SpineBIN/spine -v --cgi-search-form-codegen --config=$SpinePOD/.dr/config_local nix develop -nix flake lock +nix flake update #+HEADER: :tangle "../sundry/spine_search_cgi/flake.nix" #+HEADER: :noweb yes @@ -1642,7 +1654,7 @@ nixpkgs=<> #+NAME: project_path_local_project #+HEADER: :noweb yes #+BEGIN_SRC nix -/grotto-ra/repo/git.repo/projects/project-spine/doc-reform +~/grotto/repo/git.repo/projects/project-spine/doc-reform #+END_SRC #+NAME: project_path_local_src @@ -1664,7 +1676,7 @@ nixpkgs=<> #+NAME: project_path_local_doc #+BEGIN_SRC nix -/grotto-ra/repo/git.repo/projects/project-spine/doc-reform-markup/spine-markup-samples +~/grotto/repo/git.repo/projects/project-spine/doc-reform-markup/spine-markup-samples #+END_SRC #+NAME: project_path_local_out diff --git a/org/out_sqlite.org b/org/out_sqlite.org index a6c501d..3a201e7 100644 --- a/org/out_sqlite.org +++ b/org/out_sqlite.org @@ -346,35 +346,43 @@ template SQLiteTablesCreate() { return _sql_instruct; } } - if (opt_action.sqlite_db_create) { - string _db_statement; - string db_filename = (opt_action.sqliteDB_filename.length > 0) - ? opt_action.sqliteDB_filename - : (config.conf.w_srv_db_sqlite_filename.length > 0) - ? config.conf.w_srv_db_sqlite_filename - : ""; - string db_path = (opt_action.sqliteDB_path.length > 0) - ? opt_action.sqliteDB_path - : (config.conf.w_srv_db_sqlite_path.length > 0) - ? config.conf.w_srv_db_sqlite_path - : ""; - if (db_filename.length > 0 && db_path.length > 0) { - if ((opt_action.vox_gt1)) { - writeln("db name & path: ", db_path, db_filename); - } - auto pth_sqlite = spinePathsSQLite!()(db_filename, db_path); - pth_sqlite.base.mkdirRecurse; - auto db = Database(pth_sqlite.sqlite_file); - { - _db_statement ~= SQLiteTablesReCreate!()(); - } - SQLiteDbRun!()(db, _db_statement, opt_action, "TABLE RE-CREATE"); - } else { - writeln("must provide db name & output root path either on the command line or in configuration file"); - writeln("db name: ", db_filename); - writeln("db path: ", db_path); - } + <> + } +} +#+END_SRC + +**** db create + +#+NAME: sqlite_db_create +#+HEADER: :noweb yes +#+BEGIN_SRC d +if (opt_action.sqlite_db_create) { + string _db_statement; + string db_filename = (opt_action.sqliteDB_filename.length > 0) + ? opt_action.sqliteDB_filename + : (config.conf.w_srv_db_sqlite_filename.length > 0) + ? config.conf.w_srv_db_sqlite_filename + : ""; + string db_path = (opt_action.sqliteDB_path.length > 0) + ? opt_action.sqliteDB_path + : (config.conf.w_srv_db_sqlite_path.length > 0) + ? config.conf.w_srv_db_sqlite_path + : ""; + if (db_filename.length > 0 && db_path.length > 0) { + if ((opt_action.vox_gt1)) { + writeln("db name & path: ", db_path, db_filename); + } + auto pth_sqlite = spinePathsSQLite!()(db_filename, db_path); + pth_sqlite.base.mkdirRecurse; + auto db = Database(pth_sqlite.sqlite_file); + { + _db_statement ~= SQLiteTablesReCreate!()(); } + SQLiteDbRun!()(db, _db_statement, opt_action, "TABLE RE-CREATE"); + } else { + writeln("must provide db name & output root path either on the command line or in configuration file"); + writeln("db name: ", db_filename); + writeln("db path: ", db_path); } } #+END_SRC diff --git a/shell.nix b/shell.nix index 07031df..6b84544 100755 --- a/shell.nix +++ b/shell.nix @@ -50,7 +50,7 @@ mkShell { #if [[ -f ".envrc" ]]; then # source .envrc #fi - nix flake lock --update-input nixpkgs + nix flake update echo "" echo "nix flake metadata:" nix flake metadata diff --git a/sundry/spine_search_cgi/.envrc-local_ b/sundry/spine_search_cgi/.envrc-local_ index 92f4fea..7538951 100644 --- a/sundry/spine_search_cgi/.envrc-local_ +++ b/sundry/spine_search_cgi/.envrc-local_ @@ -7,10 +7,10 @@ export NIX_PATH=/nix/var/nix/profiles/per-user/root/channels/nixos # eval "$(nix print-dev-env)" # echo $NIX_BUILD_TOP export SpineVER=$(git describe --long --tags | sed 's/^[ a-z_-]\+\([0-9.]\+\)/\1/;s/\([^-]*-g\)/r\1/;s/-/./g') -export SpinePROJ=/grotto-ra/repo/git.repo/projects/project-spine/doc-reform -export SpineSRC=/grotto-ra/repo/git.repo/projects/project-spine/doc-reform/src -export SpineBIN=/grotto-ra/repo/git.repo/projects/project-spine/doc-reform/result/bin -export SpineDOC=/grotto-ra/repo/git.repo/projects/project-spine/doc-reform-markup/spine-markup-samples +export SpinePROJ=~/grotto/repo/git.repo/projects/project-spine/doc-reform +export SpineSRC=~/grotto/repo/git.repo/projects/project-spine/doc-reform/src +export SpineBIN=~/grotto/repo/git.repo/projects/project-spine/doc-reform/result/bin +export SpineDOC=~/grotto/repo/git.repo/projects/project-spine/doc-reform-markup/spine-markup-samples export SpinePOD=$SpineDOC/markup/pod #export SpineOUTversioned=/srv/www/spine/$SpineVER export SpineOUT=/srv/www/spine diff --git a/sundry/spine_search_cgi/makefile b/sundry/spine_search_cgi/makefile index 4f2747d..187166b 100644 --- a/sundry/spine_search_cgi/makefile +++ b/sundry/spine_search_cgi/makefile @@ -1,6 +1,6 @@ SpineBIN := "${SpineBIN}" # 'result/bin' SpineOUT := "${SpineOUT}" # '/srv/www/spine' -SpinePOD := "${SpinePOD}" # '/grotto-ra/repo/git.repo/projects/project-spine/doc-reform-markup/spine-markup-samples/markup/pod' +SpinePOD := "${SpinePOD}" # '~/grotto/repo/git.repo/projects/project-spine/doc-reform-markup/spine-markup-samples/markup/pod' SpineSearchAction := 'https://sisudoc.org/spine_search' SpineCGIform := 'spine_search' SpineSQLdb := 'spine.search.db' -- cgit v1.2.3