Write some Software

SUMMARY The task is to improve the application located at [login to view URL] The application basically does two things: 1. Fetches voting information from the remote server to local storage using available JSON API calls. Local storage are currently implemented as a collection of [login to view URL] archives under the 'data' folder. 2. Loads the data from local storage into memory and perfoms some calculations/plotting. THE TASK The task is to implement new local storage module '[login to view URL]'. It should mirror exisiting LoadGZ module, but use SQLite database. The public interface should be the same with the interface of the existing '[login to view URL]' module. Specifically, the following functions should be implemented: * [login to view URL](dbstring, dfrom, dto) - fetch brief information from server to local storage * [login to view URL](dbstring) - fetch detailed information using already fetched brief information from server to local storage * [login to view URL](dbstring) - read the local storage and load Deputy-Vote information into [login to view URL] in memory * [login to view URL](dbstring) - read the local storage load Deputy-Faction information into [login to view URL] in memory Internally, the local storage should be organized as a SQLite database containig the following tables with columns of appropriate types: * table Deputy(DeputyCode, Name, etc) * table Vote(VoteId, lawNumber, date, transcriptLink) * table DeputyVote(Id, DeputyCode, VoteId, Faction) - many-to-many link between votes and deputies As a result, the application should be able to 1) Fetch the data from the Server into SQLite database 2) Load the data from the database into memory 3) The result of the calculation performed by Deputy1 module (the final plot) should stay the same