Caltechlibrary Datatools Versions Save

This release features a new tool, jsonobjects2csv, which will convert JSON expressing a list of objects into a CSV file. If the objects contain complex attributes (lists and objects) those get converted into YAML (might change representation in the future).

Normalized handling of showHelp, showLicense and showVersion. Fixed man pages.

Full Changelog: https://github.com/caltechlibrary/datatools/compare/v1.2.6...v1.2.7

Fixed a regression in jsonjoin which had the wrong man page again and was as failing tests. Updated to go1.22 and updated the dependencies. Brought build process up to date with Caltech Library Digital Library Development Group practices.

Full Changelog: https://github.com/caltechlibrary/datatools/compare/v1.2.5...v1.2.6

The documentation and behavior of jsonjoin was confusing and inconsistent. This release fixes both some ambiguous code and documents the expected behavior for join JSON objects. Also corrects problem where the man page for jsonjoin returns the manual page for json2toml.

This release addresses issue #16 and normalizes JSON output to not encode HTML entities in Unicode code points notation.

This release features a change related to issue #15 for codemeta2cff command line tool. It has also be compiled with go 1.20.5.

Zip install files have been updated to reflect availability of installer.sh and for Linux/macOS (where uname is available) now reflect that preferred description of the CPU and OS.

Linux (64 bit): Intel style CPU use Linux-x86_64, ARM uses Linux-aarch64 Raspberry Pi OS uses Linx-armv7l Windows uses Windows-x86_64 (Windows running on Intel) and Windows-arm64 (for Windows on ARM) macOS uses macOS-arm64 (for the newer M1, M2 Apple CPU) and macOS-x86_64 for the older generation of Intel based Macs

Add missing csv2tab to convert a file from comma separated values to tab separated values

Fixed bug in configuration handling for setting the delimiter used by sql2csv.

This release drops the requirement for cli package to be available in favor of our idiomatic use of flag package. Also simplifies the string cli implementation, e.g. options always come before the verb. For all command line programs you can use the input/output options with "-" as the name to specify explicitly to use standard input or standard output. This was implemented in some of the command line programs but not is implemented across the board. Drop parameters like generate-markdown, generate-manpage in favor of Markdown documents and Pandoc. "examples" is no longer a support option as the man pages supply examples directly as does the "-help" option.

This release include man pages in the release zip file. These can be copied into your MANPATH appropriately.

This minor release adds sql2csv command line tool let you easily run a SQL query and render the results CSV encoded. Support SQLite3 and MySQL 8 databases. May support Postgres (as yet untested). The cli can be configured to use another character as column delimited (e.g. tab) via command line options.