A proxy server that acts as an Efiling Service Provider, connecting guided interviews to Efiling Managers on Tyler Technologies implementation of ECF 4.0
As mentioned in #93, certain tables needed to have caches created for them. With this PR, we'll now create Indexes for a few of the manually identified tables that are big (filing, filingcomponent, and optionalservice) if they don't exist.
To make sure the indexes work as well as they should, after updates to all of the tables happen on the cron job, we'll run VACUUM ANALYZE, which removes unused tuples and makes sure that the indices are performant.
While doing this work, I decided to make how we generate our SQL queries more secure: we now generate all of the strings for the SQL queries at start up (in a static block), which makes sure that there is even less of a possibility of SQL injection than before (where we were checking a static final map made at startup to see if a table is in our okay-list, and if it is, we added the string for that table to the rest of the SQL query). Now, all possible SQL queries with different tables are generated at startup
Running a db from 0 right now, as the last test that this should work.
Fixes #93.
A few useful changes in here:
VACUUM ANALYZE, which removes unused tuples and makes sure that the indices are performant.Running a db from 0 right now, as the last test that this should work.