python-dawaco-tools

Tools to read the Dawaco database written in Python. Have a look at the tutorials folder to get started.

Install instructions

Install environment PWN employees

• Create a project folder within a OneDrive location
• Use GitHub Desktop to clone github.com/bdestombe/python-dawaco-tools to this local directory: "C:\PythonScripts\Repositories\bdestombe\python-dawaco-tools"
• VSCode > Open Folder: project folder > Command prompt
  • uv venv --python=3.13 --directory=C:\PythonScripts\Environments\dawacotools
  • C:\PythonScripts\Environments\dawacotools\.venv\Scripts\activate
  • uv pip install -e "C:\PythonScripts\Repositories\bdestombe\python-dawaco-tools"
  •  
     Ctrl 
      +  
     Shift 
      +  
     P 
      => "Python: Select Interpreter" => "Enter interpreter path..." => C:\PythonScripts\Environments\dawacotools\.venv\Scripts\python.exe

The environment is now installed in C:\PythonScripts\Environments\dawacotools\.venv\Scripts\python.exe

Install ODBC driver

We need a ODBC driver to create the connection with the SQL database.

Download version 18 for x64 platform of the ODBC driver from the microsoft website. https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server