Lethbridge

Documentation

* docs(database): remove prompt about faction identifers

We&39;ll stick with names. It makes de-duplication and updating simpler. ([`531403c`](https://github.com/irtnog/lethbridge/commit/531403cf856f6160089cfe3d0f3f31cd69765e61))

* docs(database): move comments to doctrings, fix grammar, and tag questionable code ([`9a8dcc0`](https://github.com/irtnog/lethbridge/commit/9a8dcc006d2bba1d5654c147597154b79fa91337))

Feature

* feat(database): model stations ([`5b87047`](https://github.com/irtnog/lethbridge/commit/5b87047b2c2552078ca9fe0b6b485112d427cca3))

* feat(database): simplify faction de-duplication at system de-serialization time ([`9b68aee`](https://github.com/irtnog/lethbridge/commit/9b68aeeb5e48a12ed15c6de1644694428a2f7475))

* feat(database): make faction allegiance and government optional

This is required by fleet carriers. ([`3b0d4dc`](https://github.com/irtnog/lethbridge/commit/3b0d4dc09e401bd088e07fe8b94de610d83958c6))

* feat(database): give PowerPlay objects a printed representation ([`223ca0e`](https://github.com/irtnog/lethbridge/commit/223ca0eaeef2705880f34c45b1eadf339012f03b))

* feat(database): implement missing System equality checks ([`53c34e7`](https://github.com/irtnog/lethbridge/commit/53c34e7d90c6fad5d76c87241cb43a821ecf178e))

Fix

* fix(database): use the Faction object&39;s representation when printing BGS states ([`19fb3f0`](https://github.com/irtnog/lethbridge/commit/19fb3f05c8e5ab39476f26419bb854b75c557611))

Test

* test(database): restructure multiple conditional statements when comparing serialized systems ([`dc10415`](https://github.com/irtnog/lethbridge/commit/dc104152b607c943e635e3922cf5a3f45ca5727c))

* test(database): re-order operations to match attribute/column order ([`bbdf6a7`](https://github.com/irtnog/lethbridge/commit/bbdf6a7352af4ced811d903943a16ca5a635d72d))

* test(database): validate PowerPlay earlier in the ORM tests ([`f27f254`](https://github.com/irtnog/lethbridge/commit/f27f254d7e5400d40ca26eafd977cd2b763fb279))

* test: remove unnecessary tests and limit smoke testing to just SQLite ([`3dcfb6c`](https://github.com/irtnog/lethbridge/commit/3dcfb6cd48a8bfb0dfb5b70261ca23fdd2b74088))

* test: wrap long lines in database mockup ([`81c52d8`](https://github.com/irtnog/lethbridge/commit/81c52d83ee8b3ad332a444e90296bd9c2d9466df))

Unknown

* release: cut the v0.0.4 release ([`dc83556`](https://github.com/irtnog/lethbridge/commit/dc8355657221db46662800559d52379ffad0372d))

Documentation

* docs(database): correct a grammatical error ([`587468e`](https://github.com/irtnog/lethbridge/commit/587468e5fc5a6ccf21d0fea547f1aa2114c14c5f))

Feature

* feat(database): model PowerPlay ([`070b223`](https://github.com/irtnog/lethbridge/commit/070b22385d36a64ec2d7b84f7613ee308a8add68))

Refactor

* refactor(database): simplify pre/post-dump/load processing ([`54bc2ce`](https://github.com/irtnog/lethbridge/commit/54bc2ceec52f3f7ff7b8182ce4045a732b93a847))

* refactor(database): list autoschema exclusions in their order of appearance in the model class ([`2d9702d`](https://github.com/irtnog/lethbridge/commit/2d9702db39fdeb306f53f3bd00d46ab2bc66162f))

Test

* test(database): import multiple, related systems at once ([`62bbf54`](https://github.com/irtnog/lethbridge/commit/62bbf5474f4e276fbe62f1a70adb78d889b592c4))

Unknown

* release: cut the v0.0.3 release ([`12d532c`](https://github.com/irtnog/lethbridge/commit/12d532c6c575185f50dfb5d2718d074fcf660d5b))

Documentation

* docs(database): remind readers that modifying dicts in loops results in an exception ([`3a247c8`](https://github.com/irtnog/lethbridge/commit/3a247c8032dd27339a18c5069f1d220ec229f950))

Feature

* feat(database): (de-)serialize faction data, matching Spansh&39;s galaxy data dump ([`6a2d8b3`](https://github.com/irtnog/lethbridge/commit/6a2d8b3c3c931e2c991486dd1cd73264292b4851))

* feat(database): pretty print BGS states ([`ecbecde`](https://github.com/irtnog/lethbridge/commit/ecbecdecdfc5e98338812378cb801f7b1fcf34f1))

* feat(database): switch to new-style (Python 3.10+, PEP 604) Union type syntax

This syntax doesn&39;t work with indirect ORM class references, so leave
that one alone.

Also note that the existing `__future__` import should make this
syntax work on Python 3.7+. ([`9bac86f`](https://github.com/irtnog/lethbridge/commit/9bac86fa2f9140670a0f06f5dd8f2acc77404984))

* feat(database): define serialization schemas for factions and BGS states ([`69e64c9`](https://github.com/irtnog/lethbridge/commit/69e64c934b85d9523cd6fb5dae8aa786cec5ef84))

* feat(database): model factions and their BGS states ([`ea70baa`](https://github.com/irtnog/lethbridge/commit/ea70baa9260276706ced2c893209e786a277b13e))

Fix

* fix(database): resize System.population as the default type mapping is too small on PostgreSQL ([`7d7634b`](https://github.com/irtnog/lethbridge/commit/7d7634b3756f95127fea50359110afc23bdf30f9))

* fix(database): sort serialized faction data, again to match Spansh ([`506cd28`](https://github.com/irtnog/lethbridge/commit/506cd28a9e831a97c023bf5b289cf181716cf617))

* fix(database): flatten faction data in BGS state dumps ([`6cb1438`](https://github.com/irtnog/lethbridge/commit/6cb14383cae278dc1d3e98c9f45050cfcc0694e9))

* fix(database): remove the ORM-managed faction name (foreign key) from BGS state dumps ([`b7b5447`](https://github.com/irtnog/lethbridge/commit/b7b54472232d5be193fad6729a8411aaff42ca5b))

* fix(database): avoid copying the output dict if not required ([`daf3693`](https://github.com/irtnog/lethbridge/commit/daf36930ed0d53aac0615e242ce25caa270c7c4c))

* fix(database): resize System.id64 as the default type mapping is too small on PostgreSQL ([`eb8f883`](https://github.com/irtnog/lethbridge/commit/eb8f8834a60a43c2dbac1d59a702b3692ef5b29c))

* fix(database): remove empty columns from the dump, matching Spansh ([`10cb937`](https://github.com/irtnog/lethbridge/commit/10cb9377f30a5c9a42d4824bfac4bfc8a9ef1711))

* fix(database): remove ORM relationship management columns from dumps ([`a2a0a6f`](https://github.com/irtnog/lethbridge/commit/a2a0a6faf7c80d8355a213017ae48d6a912ef4a1))

* fix(database): do not mutate inbound (pre-load) or outbound (post-dump) data structures

This violates the Principle of Least Astonishment. Make copies for
yourself, instead. ([`8771db7`](https://github.com/irtnog/lethbridge/commit/8771db71d184230bd517b7e88b979e99226722da))

* fix(database): exclude foreign keys from system data dumps

Spansh represents relationships using nesting, even though it results
in duplicate copies of the relevant data (e.g., faction name,
allegiance, and government). ([`48c9d86`](https://github.com/irtnog/lethbridge/commit/48c9d860906fcf195def4ee62b85af3b05b38720))

* fix(database): model controlling factions as nullable many-to-one relationships ([`c4b0925`](https://github.com/irtnog/lethbridge/commit/c4b0925ad214cd2cc2c302ad014082004dc0d5b4))

* fix(database): make database re-initialization flag optional ([`b13535f`](https://github.com/irtnog/lethbridge/commit/b13535f3241575cc48a6902769cf0afa854fa25e))

Refactor

* refactor: format Python code using Black ([`8bd018c`](https://github.com/irtnog/lethbridge/commit/8bd018c94eed4c6510763a5e58d4ccc8291d3fca))

* refactor(database): remove unused import ([`aa14c94`](https://github.com/irtnog/lethbridge/commit/aa14c94bb9a86a3e8aecbe524c489841443620ca))

Test

* test(database): log SQL for troubleshooting purposes ([`280cea1`](https://github.com/irtnog/lethbridge/commit/280cea11317a69e0b2b33480a654c4e07b77ca3c))

* test(database): match input date/time format to Marshmallow&39;s default output ([`92389bf`](https://github.com/irtnog/lethbridge/commit/92389bf89f7dfd9026417a2567d17c0f5c165896))

* test: narrow smoke tests to deserialization with fake data ([`b564de9`](https://github.com/irtnog/lethbridge/commit/b564de9ac7680725d7332c76441d0a8fa636d5be))

* test(database): add a smoke test for the System serialization schema ([`7772a55`](https://github.com/irtnog/lethbridge/commit/7772a5538907696c3ae8381f46c67108ac593ef1))

* test(database): rename index variable to better hint at purpose ([`cf7aeed`](https://github.com/irtnog/lethbridge/commit/cf7aeedc286d15a7d7b63ffb9588b4b7c9b7f1f1))

* test: define a set of preliminary tests, currently focused on the database ([`c4e4441`](https://github.com/irtnog/lethbridge/commit/c4e4441b69601eba89b977308a276a522e8b4981))

* test(database): remove unused fixture ([`0ddfd74`](https://github.com/irtnog/lethbridge/commit/0ddfd7446575af375a3984472d101bd64a513d27))

* test: reformat test data using jq for readability ([`baa7b36`](https://github.com/irtnog/lethbridge/commit/baa7b36bc739a1ba92c431913de2f2df9bf4e723))

* test(docker): report on test coverage during the build ([`ea4cc61`](https://github.com/irtnog/lethbridge/commit/ea4cc6145b45fbf82a546aa2a6f460b2e2842d07))

* test(database): skip system data timestamp checks for now ([`953b573`](https://github.com/irtnog/lethbridge/commit/953b573ffba67a9c1299ae54fcb308c0077d30c8))

* test(database): remove unused imports ([`8cb4b8f`](https://github.com/irtnog/lethbridge/commit/8cb4b8f009f004c625e9db6f4d92b10bfcff004e))

* test(database): remove redundant database schema checks

This gets checked by the CLI tests. ([`5d96096`](https://github.com/irtnog/lethbridge/commit/5d96096191287b9cbc6d043844b7b7d25f63565c))

* test(database): use real galaxy map data to test the serialization schema ([`d0902e3`](https://github.com/irtnog/lethbridge/commit/d0902e3d8e457cb3df39327872a675eb810eb60b))

* test(database): parameterize the database URI fixture ([`8160df2`](https://github.com/irtnog/lethbridge/commit/8160df2a85bc7d0eb35a30e797e3dc9665fca8f8))

* test(database): run relationship tests in a separate session/transaction ([`b6869d9`](https://github.com/irtnog/lethbridge/commit/b6869d9cd5480b3309bae09e722769f40eb093b9))

* test(database): verify system/faction/BGS state associations ([`7b56cee`](https://github.com/irtnog/lethbridge/commit/7b56ceea3316a8f1fa7de7b1de9a4bad03256e16))

* test(database): verify integrity constraints and query results ([`43ad80c`](https://github.com/irtnog/lethbridge/commit/43ad80c967dd72cb99ad01e3826075abb3340807))

* test(database): simplify the ORM test ([`132e8e1`](https://github.com/irtnog/lethbridge/commit/132e8e12a288e271f91ab398ede2e8e1c9318b9c))

Unknown

* release: cut the v0.0.2 release ([`8dab70a`](https://github.com/irtnog/lethbridge/commit/8dab70a638b802bbeb57a939e8338df2a399f359))

Documentation

* docs(packaging): add license metadata ([`728ba8e`](https://github.com/irtnog/lethbridge/commit/728ba8eadcad7171d61180b1b6d838f8c54416a9))

* docs: correct EDDN name and link ([`19ad4e2`](https://github.com/irtnog/lethbridge/commit/19ad4e20f62866d8bad58b69121160a1b2d78cf6))

Feature

* feat: implement configuration editing via the CLI

This requires modifying a lot of stuff to replace global variables
with the
[Typer context](https://typer.tiangolo.com/tutorial/commands/context/). ([`2b9ab56`](https://github.com/irtnog/lethbridge/commit/2b9ab564d9862c94dab110b2eb8f9166964e88cd))

* feat(config): load config files into the specified ConfigParser object

This makes it possible to save just modified configuration settings. ([`2706eda`](https://github.com/irtnog/lethbridge/commit/2706eda8589f9fb9a2e47d66fec5a896012a3997))

* feat(cli): mock up the rest of the CLI ([`10d1579`](https://github.com/irtnog/lethbridge/commit/10d1579e38a2eb7f253f42a9892581d246b54e39))

* feat(cli): keep track of the overridden configuration file name

That way, the `configure` subcommand knows in which file to save
configuration changes. ([`be2d13c`](https://github.com/irtnog/lethbridge/commit/be2d13cbbb640dcc57241592730f973cd3230354))

* feat(config): move the default SQLite database to the current working directory

Whether the configuration directory exists depends on whether a
configuration setting has been changed. ([`010da9c`](https://github.com/irtnog/lethbridge/commit/010da9c72bd0e5ee4d585aede3da0139d8eac6e0))

* feat(database): add database initialization function ([`ae8f92d`](https://github.com/irtnog/lethbridge/commit/ae8f92d9cfb6373325e86e3f0e09ea55bbf98571))

* feat(cli): load the configuration file at CLI start time

This lets other tools use Lethbridge as a library and control things
like configuration themselves. ([`98aa196`](https://github.com/irtnog/lethbridge/commit/98aa19662aa7d478f84c72d27eb452da4d61fd58))

* feat(cli): show help for subcommands ([`554bc6a`](https://github.com/irtnog/lethbridge/commit/554bc6ad0733dc67d8eb00b82857207090122071))

* feat(config): simplify to a thin wrapper around configparser ([`e8952d0`](https://github.com/irtnog/lethbridge/commit/e8952d0354f04ca81025c11296f46428ec274958))

* feat(cli): automatically load subcommands from submodules ([`b66a7ea`](https://github.com/irtnog/lethbridge/commit/b66a7ea6f03550aa63b3fb6ee07d17b842855c49))

* feat(cli): allow overriding the default configuration file ([`60de019`](https://github.com/irtnog/lethbridge/commit/60de019291e2b227830e54dce88ac5e574c125a7))

* feat(cli): add copyright notice to version callback ([`ff4dc75`](https://github.com/irtnog/lethbridge/commit/ff4dc7513092e3b0b977323c98c61d2e4b709e00))

* feat(config): add an external configuration file ([`aef34aa`](https://github.com/irtnog/lethbridge/commit/aef34aafd9b5b1aaaa92e447d45b2f2a482a7edf))

* feat: configure logging ([`ef79107`](https://github.com/irtnog/lethbridge/commit/ef7910754f52f9ed406135ac0747bd9eb5469360))

* feat(database): set default values for selected columns ([`fce7810`](https://github.com/irtnog/lethbridge/commit/fce7810e3f6e758fcd972ff0a97027492301c785))

* feat(database): map the system&39;s coordinates to separate x/y/z columns ([`ef52871`](https://github.com/irtnog/lethbridge/commit/ef52871012ff39c16bec5ab2e53af813061341e5))

* feat(database): begin defining the data model ([`d999300`](https://github.com/irtnog/lethbridge/commit/d999300a0602a129f1469077cf4c928c4aeeb92d))

* feat: initial commit ([`c9d17bd`](https://github.com/irtnog/lethbridge/commit/c9d17bd94b3592d5cd7909df153510c5dfba02ba))

Refactor

* refactor(cli): switch to modern (Python 3.6+) annotated arguments ([`a902918`](https://github.com/irtnog/lethbridge/commit/a90291814d98fed4c5fd65ef3d761e3df8e509e6))

* refactor(config): pull defaults out into dedicated constants

This makes referring to (and testing against) the defaults easier. ([`3a5cd11`](https://github.com/irtnog/lethbridge/commit/3a5cd115d8643526c177615a0ea785dd3205d011))

* refactor: sort imports ([`318eb79`](https://github.com/irtnog/lethbridge/commit/318eb7934614b97ca7b99bdb0c9529409cb7708b))

* refactor(config): simplify configuration file handling

Configuration file creation, etc., is only necessary when actually
saving changed settings. This will be driven by the user interface.

If the configuration file doesn&39;t exist, silently skip it. Only throw
an error at load time if the file exists but cannot be read for
whatever reason, on the assumption that if the configuration file
exists, it is supposed to be readable. ([`1a1b96b`](https://github.com/irtnog/lethbridge/commit/1a1b96bae7fea4f86e7ccd840b1da86d56319d4c))

* refactor(cli): use typer.secho for all application-level (not library) user comms ([`3aeba07`](https://github.com/irtnog/lethbridge/commit/3aeba07060bbbb1a19ec58634c6916a5a61061b6))

* refactor(lethbridge): initialize logging at CLI start time

This lets other tools use Lethbridge as a library and control things
like logging themselves. ([`808a85b`](https://github.com/irtnog/lethbridge/commit/808a85b05fc555796dc659ef0615cc6b8b4c18fc))

* refactor(cli): rename variables to make their puposes clearer ([`a37427d`](https://github.com/irtnog/lethbridge/commit/a37427d493b97ceb944a6a6d59554c1f1c62be1f))

* refactor(cli): modularize now to support subcommands later ([`a8628e5`](https://github.com/irtnog/lethbridge/commit/a8628e53c30774b0503e77d20acbd62f78c6a6cc))

* refactor(cli): add missing list item separator ([`02446ce`](https://github.com/irtnog/lethbridge/commit/02446ce87b181d28a68712c8f0966674c5c575cf))

* refactor(__main__): switch to relative imports ([`7735fb4`](https://github.com/irtnog/lethbridge/commit/7735fb4bf611b572373890ca444aee2baa4b1d74))

* refactor(__init__): determine app name at runtime based on package name ([`bbcaf30`](https://github.com/irtnog/lethbridge/commit/bbcaf30a35fd242412bad91af15df62131fec871))

* refactor(database): remove extraneous abstract class definition ([`ef4af5b`](https://github.com/irtnog/lethbridge/commit/ef4af5b0aeb0df9ef2406bbfb2f7aae263dbb4cf))

Test

* test: install code coverage reporting plugin ([`ecf839b`](https://github.com/irtnog/lethbridge/commit/ecf839bdc8f28d3aaf35bbb39cb40e33656d57b7))

* test(database): convert engine test fixtures to database URIs

The planned interface expects URIs, not already running engines. ([`2abdf44`](https://github.com/irtnog/lethbridge/commit/2abdf44a1e7591782ed11fba1ad9cc7726ce87a6))

* test(database): install and test a cffi variant of psycopg2 ([`5387e50`](https://github.com/irtnog/lethbridge/commit/5387e50981b3b0f7afad7fd4b0fb38889b195d46))

* test(database): add a PostgreSQL database test fixture

This enables database module testing against both PostgreSQL and
SQLite databases. The container build stage installs PostgreSQL and
performs the Python package install and test processes as an
unprivileged user, which are all required by pytest-postgresql. ([`37eb313`](https://github.com/irtnog/lethbridge/commit/37eb31384670326d58480b8e114ce261842d40b1))

* test(database): parametrize the database engine ([`0ca0f32`](https://github.com/irtnog/lethbridge/commit/0ca0f32be1e9007e4b97b96212266565987f1699))

* test: break down and sort imports ([`86a1aa9`](https://github.com/irtnog/lethbridge/commit/86a1aa9ab14e5beda639ec53206c59dcd306817a))

* test(cli): pair test filename with the corresponding module ([`0d4bfe5`](https://github.com/irtnog/lethbridge/commit/0d4bfe5caf30f2b8b1ead8a4e7088386933b2623))