Translate internal codes

[waldoj]

Naked internal codes are displayed (e.g., 20 or 00). This isn't helpful. Add an internal method to convert an internal code to its textual equivalent, and call that before returning data. Preserve the internal code in responses.

[waldoj]

This isn't working, and I can't fathom why.

Subqueries just...don't work. They return nothing. I've researched it. There's no reason at all why they shouldn't be working, but they're not.

Instead of continuing to beat my head against this wall, I think it's worth trying a completely different solution. Seems to me that I should just get * from tables (only 419 rows), break that into an array, and use that as a lookup table. That can be re-generated during each weekly data update, stored as JSON, and loaded off the filesystem with each page view. If that were ever an issue, it could be dropped into Memcached or something.

[waldoj]

sqlite3 -csv -header vabusinesses.sqlite "SELECT * FROM tables" |csvtojson > tables.json

[waldoj]

There are a few improvements to make:

• create a new class for this lookup table
• when the class is instantiated, pull the data from the file
• move the lookup logic into the new class (and out of Business::fetch)
• write tests