Auto-tools/Projects/BugHunter: Difference between revisions

A python module called datasource was used for all SQL/Database interactions (https://github.com/jeads/datasource).  Datasource provides an interface to MySQL that allows SQL to be stored in a JSON file with an associated name and host_type (master, read_only, etc...).  In order to send signals between data views portions of SQL had to be generated dynamically, this is managed by the datasource module to keep SQL munging out of the webservice and to provide a single location where all static SQL can be found (python/sisyphus/webapp/procs/bughunter.json).  This allows SQL statements to be treated as "stored procedures", all statements are assigned a name and are suitable for re-use by other scripts.