tree-city-software/data-processing — pull request #30 by cometzorz (2012-04-29 06:42:34+00:00)
Title: Completed the three data loaders for the SQL back end.

Haven't tested these suckers yet, mainly because I lack the data to do said testing, as well as a database to send them to right now.

These jobs take a configuration file as an argument which needs to be set up as so:

username
password
database connection string

This version builds, and the SQL code should be all right, but might want to give that a once over. I know Nick has a few ideas in terms of statistics tracking that he may want to implement, so feel free to modify these how you see fit. Used parameterize sql, so, it's all prepared and should run pretty fast. buffers all of the sql queries as a batch set and runs them all at once at closing.

Furthermore, I made a modification to the FromToPair class that the BFSOutput returns. I realized that it's a key object and I wasn't sure how the framework handles keys that are not writable AND comparable, so I just made it so that it was both. Should be all good.