ipython-sql icon indicating copy to clipboard operation
ipython-sql copied to clipboard

added a function to censor passwords and updated HACKING.txt

Open samghelms opened this issue 7 years ago • 0 comments

I love this package, but it keeps printing out my password in cleartext when I use it with an odbc driver. For example:

input cell:

%%sql
select * from csn_survey.tblSurvey limit 3

output:

* vertica+pyodbc:///?odbc_connect=DRIVER=/opt/vertica/lib64/libverticaodbc.so;SERVER=myvertica.com;DATABASE=mydb;PORT=myport;UID=samghelms;PWD=mypassword

<table output>

This PR adds a censor_passwords function that attempts to find any password parameters in the URL string and censor them.

samghelms avatar Nov 05 '18 18:11 samghelms