Skip to content

[SPIIP-70] SQL database utilities

Patrick Clearwater requested to merge pwc_db into master

Create a new class, GwdcDb, to manage connections to the Swinburne SQL database. This also encompasses:

  • adding extra dependencies (pyodbc, MS SQL ODBC driver, unix odbc)
  • creating three example scripts to show usage

Note that you will need to either pass the username and password to GwdcDb when connecting, or create a file called 'gwdc_db_password' in your home directory containing the password for the 'gwdc_admin' account.

Merge request reports