Lethbridge

Feature

* feat(database): model a body&39;s volcanism type and reserve level

And with this commit, all of the test data appears to load correctly! ([`cf70541`](https://github.com/irtnog/lethbridge/commit/cf70541eb6969c64ee34b97190d2e2f0735d40cf))

* feat(database): model a solid body&39;s raw material abundance ([`b68384a`](https://github.com/irtnog/lethbridge/commit/b68384a1949804730ae3760396fe686458f38893))

* feat(database): model belts and rings ([`8b7bc60`](https://github.com/irtnog/lethbridge/commit/8b7bc60987a73d2993e4aad09e3aeabf105fc4b7))

* feat(database): model a body&39;s parent bodies ([`43f804a`](https://github.com/irtnog/lethbridge/commit/43f804ac89dfebbe35df5a97497788d6132a0d07))

Unknown

* release: cut the v0.1.0 release ([`4f56b9a`](https://github.com/irtnog/lethbridge/commit/4f56b9a0095bd094e8ab680399c07881976eecc1))

Documentation

* docs(database): remove code tags for Anarchy/None and powerState

The string values `Anarchy` or `None` are distict from the None value
in that the latter means the datum in question wasn&39;t available.

The powerState key probably denotes Bubble systems, but there isn&39;t a
straightforward way to model this. ([`b217347`](https://github.com/irtnog/lethbridge/commit/b21734738654c93c177a84271c5ff6adedba47b8))

Feature

* feat(database): model body scan timestamps ([`2ee0561`](https://github.com/irtnog/lethbridge/commit/2ee0561c344395d5295ec429779c262d5010ee4d))

* feat(database): model a body&39;s detailed surface scan data ([`0d62b2e`](https://github.com/irtnog/lethbridge/commit/0d62b2e1378b3892f2375432522aeda312c89b1b))

* feat(database): model a body&39;s solid composition ([`d81dec1`](https://github.com/irtnog/lethbridge/commit/d81dec148816d8309899f53c494e135a2b5d7b94))

Refactor

* refactor(database): move body composition data pre-processing into the appropriate schemas ([`3ba24c9`](https://github.com/irtnog/lethbridge/commit/3ba24c9d31df78c529dc52cfadfb61a9d599feb6))

* refactor: initialize pyscopg2cffi at app load time

Library callers should not be forced to use this package. ([`293ef5b`](https://github.com/irtnog/lethbridge/commit/293ef5b8e419267a39ba102c4bb8c041b7723abc))

Unknown

* release: cut the v0.0.9 release ([`d59359c`](https://github.com/irtnog/lethbridge/commit/d59359cf5423ba25fd92b13fd128486fb10a8e9c))

Documentation

* docs(database): answer question about station allegiance/government

Yes, that&39;s supposed to match the controlling faction, but no, it
doesn&39;t always. ([`f811b5f`](https://github.com/irtnog/lethbridge/commit/f811b5f53302e4f5b0377382da791dfbb7db1f40))

* docs(database): give body objects a description ([`0840d8a`](https://github.com/irtnog/lethbridge/commit/0840d8a3895acbc4795110adfb8765e7c7576750))

* docs(database): use similar language to the wiki when describing powers ([`e49ea28`](https://github.com/irtnog/lethbridge/commit/e49ea281f083a85b3bee764465cf1e81c426286d))

* docs(database): use similar language to the wiki when describing factions ([`2d70539`](https://github.com/irtnog/lethbridge/commit/2d70539c265934ec06c536c4a58c727ca469e684))

Feature

* feat(database): model a body&39;s atmospheric composition ([`eb08e8c`](https://github.com/irtnog/lethbridge/commit/eb08e8c7b1d5a929c4f0241e27e67a67ce261f21))

* feat(database): implement pretty printing and equivalence tests for various station services ([`bd369f7`](https://github.com/irtnog/lethbridge/commit/bd369f7ee2538e501434c2db626d072698d15772))

* feat(database): implement equivalence tests for bodies ([`6d8b2d8`](https://github.com/irtnog/lethbridge/commit/6d8b2d87528b66338311bbce57260bc4ffd502f7))

* feat(database): denote StationEconomy objects in an intermediate state ([`7398115`](https://github.com/irtnog/lethbridge/commit/739811525223caf2be1a20b9eda9edffd6303712))

* feat(database): pretty print Body ([`6f71195`](https://github.com/irtnog/lethbridge/commit/6f71195335138c8b99daa6119ea5ae5322fb72b7))

* feat(database): throw an error on unknown system fields ([`341f332`](https://github.com/irtnog/lethbridge/commit/341f33238426a172cdd9eb0f766e6dfd4abfd733))

* feat(database): model bodies ([`2815c3d`](https://github.com/irtnog/lethbridge/commit/2815c3d0b47fce74f049b4c2b1dd335ad6aafec1))

Fix

* fix(database): include the station update time in its equivalence check ([`45d7583`](https://github.com/irtnog/lethbridge/commit/45d7583f0c6d967e509f5b786da3042fae41e4e2))

* fix(database): ignore a commodity&39;s translated name or commodity ID ([`1603827`](https://github.com/irtnog/lethbridge/commit/16038273848b800cce2e60536214ca70f91b85a8))

* fix(database): work around bad market data by treating all order columns as primary keys ([`1b7e15d`](https://github.com/irtnog/lethbridge/commit/1b7e15d8500c0a64dc349cf80a56e6b9b522854c))

* fix(database): de-serialize a system&39;s factions first

Sometimes, a station&39;s data on a faction can be invalid or missing.
For example, Pettitt Metalurgic Base on 36 Ophiuchi A 1 a in the test
galaxy data claims the 36 Ophiuchi Autocracy faction is
Federation-aligned due to these journal entries:

https://edgalaxydata.space/eddn-lookup/extract.php?filename=Journal.Docked-2022-09-19.jsonl.bz2&lineno=7315

https://edgalaxydata.space/eddn-lookup/extract.php?filename=Journal.Docked-2023-01-01.jsonl.bz2&lineno=11071

While the Marshmallow documentation for the knob mentions
serialization, setting `ordered = True` and listing the schema fields
in this order appears to lead to the desired result---that the
system&39;s factions get created (and memoized) from the system&39;s
`factions` field first. Then when Marshmallow processes the system&39;s
stations and bodies, any faction references will use the cached
Faction object.

https://marshmallow.readthedocs.io/en/stable/marshmallow.schema.html#marshmallow.schema.Schema.Meta ([`f98a60f`](https://github.com/irtnog/lethbridge/commit/f98a60fa97437150da051ce441c498e77109d602))

Refactor

* refactor(database): consolidate PowerPlay classes ([`bc8a015`](https://github.com/irtnog/lethbridge/commit/bc8a0154ff9c7da20fd16d053a2cab510c5cefb3))

* refactor(database): simplify the station&39;s pretty printed representation ([`4c42b08`](https://github.com/irtnog/lethbridge/commit/4c42b0806dae3bb3547cd5ab7ae3f5b2409aed6f))

* refactor(database): order columns in the order of their corresponding class&39;s/attribute&39;s appearance ([`d32d706`](https://github.com/irtnog/lethbridge/commit/d32d706559efedd86d6051a071b662d8b1265c55))

* refactor(database): rename class to emphasize its connect to factions ([`fc3d254`](https://github.com/irtnog/lethbridge/commit/fc3d2540f4d7e9e8baea983d9e03b61c3390eff8))

* refactor(database): record a station&39;s shipyard data in a dedicated Shipyard class ([`ba80e53`](https://github.com/irtnog/lethbridge/commit/ba80e5340703b264c136e10fcef80766f24d451e))

* refactor(database): record a station&39;s outfitting data in a dedicated Outfitting class ([`ee8fc71`](https://github.com/irtnog/lethbridge/commit/ee8fc712bc99934fea6da5a0b75c07a351198f20))

* refactor(database): record a station&39;s market data in a dedicated Market class

This should make future market data updates and date comparisons
simpler. ([`7eb3ae1`](https://github.com/irtnog/lethbridge/commit/7eb3ae12eb399123db88550460104c15e754afe6))

* refactor(database): don&39;t waste time sorting the factions and powers lists

This ordering was only done to facilitate testing and is not needed
any more. ([`cc9e293`](https://github.com/irtnog/lethbridge/commit/cc9e2934a9010a2765bfa80160dee5421936107c))

* refactor(database): rename station attributes to better match Spansh ([`8f505df`](https://github.com/irtnog/lethbridge/commit/8f505dfbed078d89f50a9166641037477dd79351))

* refactor(database): rename ShipyardStock to match OutfittingStock ([`643bee1`](https://github.com/irtnog/lethbridge/commit/643bee13ca7ce40188d1c7abc882ce608c6437c4))

* refactor(database): memoize Faction objects using the Marshmallow context

This makes Faction de-duplication much simpler compared to walking the
System and nested/related objects. ([`2ed5103`](https://github.com/irtnog/lethbridge/commit/2ed5103ca509d81226941d9d8f1d5fc2aad485df))

Test

* test(database): disable SQL statement echoing

Due to the volume of log data generated by this flag, it&39;s no longer a
useful debugging aid. ([`eb70d9f`](https://github.com/irtnog/lethbridge/commit/eb70d9f72696e33445842b25041d9be5e0195af7))

Unknown

* release: cut the v0.0.8 release ([`931b988`](https://github.com/irtnog/lethbridge/commit/931b9885bda7093a1703387ffdc0d76b11eead6b))

Feature

* feat(database): model station shipyards ([`6236fe6`](https://github.com/irtnog/lethbridge/commit/6236fe67082eb5bcae67b6dad7c4be893681d56e))

Fix

* fix(docker): run the installation and testing processes from the source directory ([`b73b7b1`](https://github.com/irtnog/lethbridge/commit/b73b7b177d646b4d53620321cd9872291cdb3644))

Test

* test(database): simplify attribute access ([`e166e36`](https://github.com/irtnog/lethbridge/commit/e166e36a539060308f5d8e8f738f6b272072869a))

Unknown

* release: cut the v0.0.7 release ([`9f91a0d`](https://github.com/irtnog/lethbridge/commit/9f91a0dd52da835ddb88383ba783fdeedde90741))

Feature

* feat(database): model station outfitting ([`92842f5`](https://github.com/irtnog/lethbridge/commit/92842f5d610b8eb9d341148d4c39b6b770a05815))

Refactor

* refactor(database): remove unneeded symbol prefixes ([`ab98fb5`](https://github.com/irtnog/lethbridge/commit/ab98fb5f26032e01d85da7cdc2beae2b83a06608))

* refactor(database): simplify PowerPlay (de-)serialization ([`43ea2a3`](https://github.com/irtnog/lethbridge/commit/43ea2a3348ade7192951846b2430c5d44c0ad63a))

* refactor(database): eliminate unnecessary copying ([`f1f9625`](https://github.com/irtnog/lethbridge/commit/f1f9625607ca8480658b26609ad79bf13b277bfa))

* refactor(database): simplify prohibited commodity de-serialization ([`ea2c8ec`](https://github.com/irtnog/lethbridge/commit/ea2c8ec69b4b24662e821ba99e8d5af25f6324a8))

* refactor(database): simplify station service (de-)serialization ([`3d554a5`](https://github.com/irtnog/lethbridge/commit/3d554a5e3eee7b8393de85002cf6407ca18de04e))

* refactor(database): simplify BGS state/faction de-serialization

More importantly, move preprocessing into the appropriate Marshmallow
schemas instead of SystemSchema. ([`e3958ce`](https://github.com/irtnog/lethbridge/commit/e3958cebb95205c47f882b4c26855cb049813a1a))

Test

* test(database): revise and expand system data (de-)serialization checks ([`3abfc9a`](https://github.com/irtnog/lethbridge/commit/3abfc9a8638cbd7e54813674028038a1f26096e0))

* test(database): check date handling across all target databases ([`cb6b1fe`](https://github.com/irtnog/lethbridge/commit/cb6b1fe594346538e49cad1991de681f0fa8bdc1))

* test(database): consolidate tests and test data ([`059a446`](https://github.com/irtnog/lethbridge/commit/059a44663e72120bb7545df20146a1b809dd1ce9))

Unknown

* release: cut the v0.0.6 release ([`23927be`](https://github.com/irtnog/lethbridge/commit/23927be6a395e26e78d2f0d2915e46c7db7b9bd3))

Build

* build: re-configure flake8 to match Black style ([`6c15489`](https://github.com/irtnog/lethbridge/commit/6c15489d5fd4ca3a1facdd68525d4b78baa4a40d))

* build: check code style at commit time ([`656c807`](https://github.com/irtnog/lethbridge/commit/656c8070ad935b98ddd38617c66afe91cb3e38c6))

* build: check code style on push/pull request ([`3fe5a52`](https://github.com/irtnog/lethbridge/commit/3fe5a5229595d608ce3a027fa988eef23e21d6c6))

Documentation

* docs(database): remove extraneous whitespace from ORM class docstrings ([`f390b9f`](https://github.com/irtnog/lethbridge/commit/f390b9f065130a11c39b90d44377987eefd481e5))

Feature

* feat(database): implement printed representations and equality checks for ancillary ORM classes ([`a187e71`](https://github.com/irtnog/lethbridge/commit/a187e719ac597357b0b527a44ded0410c41972b4))

* feat(database): model station markets ([`7551c81`](https://github.com/irtnog/lethbridge/commit/7551c81ab3a0821fa07f9f199dfc379adf685cdc))

* feat(database): model station economies ([`498c35c`](https://github.com/irtnog/lethbridge/commit/498c35c915648ee657fe38e2afb65f8167a9c6a6))

* feat(database): model station services ([`1ca7de7`](https://github.com/irtnog/lethbridge/commit/1ca7de7e9c0ded14f9d7a490444b171ad80726da))

* feat(database): model station landing pads ([`8142cf6`](https://github.com/irtnog/lethbridge/commit/8142cf6a792f5894218ea73aa88b6a043d5f3bcd))

Refactor

* refactor(database): rename StationService&39;s primary key to match other ORM classes ([`8e628b7`](https://github.com/irtnog/lethbridge/commit/8e628b71d69a4588e6b957b263fa8588b2c8c497))

* refactor(database): post-process station attributes in order of their appearance ([`fc3f7b7`](https://github.com/irtnog/lethbridge/commit/fc3f7b765847eaf258d989b8590b7e494bdc80a8))

* refactor(database): remove plural from table name ([`7acb3ee`](https://github.com/irtnog/lethbridge/commit/7acb3eee6e83e51b14113dab3bba8780688fbc09))

* refactor(database): simplify empty key cleanup processes ([`6ae0486`](https://github.com/irtnog/lethbridge/commit/6ae04869ca2b63f3801a161ee94426aae701f1f7))

Unknown

* release: cut the v0.0.5 release ([`4b83491`](https://github.com/irtnog/lethbridge/commit/4b834916e364da07eff8cf5b09387ad0a275b50c))