python-database-sanitizer

python-database-sanitizer copied to clipboard

I saw that #29 was merged some time ago but a new tag with those changes hasn't been created. Would it be possible to tag a new release so we...

greydnls

Fixes #36 and provides a simple test case. I have also added a very simple GH action to run the test suite. Happy to remove from the PR if you...

mrmonkington

I had a dump fail on an `int` field with `-1` in it. I'm afraid I haven't put together an MRE, but it's very obvious that in https://github.com/andersinno/python-database-sanitizer/blob/master/database_sanitizer/utils/mysql.py#L67 `MIN_INT_PATTERN` doesn't...

mrmonkington

Newline characters cause rows in PostgreSQL table to be broken inadvertently.

2

This issue replaces #30. The issue is that user-inputted data that includes these newline characters: - \u2028 - \u2029 - \x85 causes the dump to think that the line is...

YPCrumble

Passwords with special characters

1

would it be possible to provide the database-config as Environment-Variables to the database-sanitizer instead of an mysql:// url ? Also, "mysqldumper" console command often also needs to be called in...

funkrusher

Getting following error while running sanitization ``` Traceback (most recent call last): File "/home/ubuntu/.local/bin/database-sanitizer", line 11, in sys.exit(main()) File "/home/ubuntu/.local/lib/python3.6/site-packages/database_sanitizer/__main__.py", line 52, in main config = Configuration.from_file(args.config) File "/home/ubuntu/.local/lib/python3.6/site-packages/database_sanitizer/config.py", line...

rohitjha941

This change - Adds new config option for `charset`, with default `utf-8` - Support charset option in `dump/mysql.py` dump reader class - Updates README accordingly

mrmonkington

Tabs in a column raise a ValueError

1

Thanks for building this repo! Currently this line splits the db lines using `line.split('\t')`: https://github.com/andersinno/python-database-sanitizer/blob/master/database_sanitizer/dump/postgres.py#L126. The issue I'm encountering is that I have columns with user input that sometimes includes...

YPCrumble

Using OSX Empty dict is being passed into the env args for subprocess.Popen. This causes the command to not be able to find mysqldump. `env` is being initialized as empty...

azin634

Phone numbers are fairly commonly stored, so a built in sanitizer for them would be useful

JoaRiski