The spreadsheet isn't official Nintendo, but maintained by a 3rd
party developer. It is, however, considered authoritative among
3rd party developers and API maintainers as the most up to date
source of game entity data.
Not really "official" (as in from Nintendo), but considered the
most accurate authority for data according to hackers in the ACNH
community (yes, it's a thing).
This commit adds a script to add the data into the sqlite3 db.
There is still some work to not insert the abbreviation values NA
and the like, but this is mostly accurate.
The criteria for deciding what type to store was missing columns
or setting incorrectly based on the fallthrough of the else to
set TEXT.
This commit fixes the flow to better set default, to better
preserve INTEGER, and better decide based on the value.
Using the first row to determine all following is not accurate.
Additionally, the xlxs uses text abbreviations to denote meaning
within INTEGER and TEXT columns. We also need to skip values that
are empty string unless the Image link column which we know are
always string but not present in the downloaded xlxs file.
This module is meant to wrap the digest functions within the
project to allow the hashing to be changed in all places if
need, or minimally to control the interface for hashing.
Rather than import and define the same thing in various places,
or potentially import and define different hashing modules in
various places, it's defined here for continuity.
This doesn't contain any definable settings yet but will for db
connection details. For now, only the project directory is used
from the returned config object.
