Fix create_adjacent_tables.py

[griff-rees]

create_adjacent_tables.py is currently a script outside alto2txt2fixture folder. This is a meta ticket for improving that script, both for debugging and to include as a module within alto2txt2fixture to facilitate a public, installable release.

---

Fixes to be usable for lwmdb

• Fix empty newspaper fields in mitchells.Entry.json #30
• Fix gazetteer.Place.json export #6

---

Packaging/documenting

• Infrastructure to run locally
• Refactor with tests to fix create_adjacent_tables.py #19
• Continuous Integration
• Documentation (see Add create_adjacent_tables.py documentation #48)

[griff-rees]

Initial errors:

$ poetry run python -m create_adjacent_tables.py
Downloading cache/Mitchell_1846_1920.csv
Traceback (most recent call last):
  File "<frozen runpy>", line 189, in _run_module_as_main
  File "<frozen runpy>", line 112, in _get_module_details
  File "/Users/grees/code/alto2txt2fixture/create_adjacent_tables.py", line 106, in <module>
    wget.download(url=url, out=out)
  File "/Users/grees/Library/Caches/pypoetry/virtualenvs/alto2txt2fixture-GJR6xUmf-py3.11/lib/python3.11/site-packages/wget.py", line 506, in download
    (fd, tmpfile) = tempfile.mkstemp(".tmp", prefix=prefix, dir=".")
                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/homebrew/Cellar/[email protected]/3.11.4_1/Frameworks/Python.framework/Versions/3.11/lib/python3.11/tempfile.py", line 341, in mkstemp
    return _mkstemp_inner(dir, prefix, suffix, flags, output_type)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/homebrew/Cellar/[email protected]/3.11.4_1/Frameworks/Python.framework/Versions/3.11/lib/python3.11/tempfile.py", line 253, in _mkstemp_inner
    file = _os.path.join(dir, pre + name + suf)
                              ~~~~^~~~~~
TypeError: unsupported operand type(s) for +: 'PosixPath' and 'str'

[griff-rees]

Issue above reproduced with tests in 15472b5

[AoifeHughes]

Output looks sensible in current main branch output - will close once verified and documentation is updated as per original comment here

[griff-rees]

Closing now documentation shifted to separate issue #48