stackexchange-dump-to-postgres
stackexchange-dump-to-postgres copied to clipboard
Show confirmation prompt for dropping the table if and only if a table exists
This is a feature request.
The current behavior is that a confirmation prompt is shown whenever the script is used. I think that it would be less redundant if the confirmation prompt were shown if there exists a table in the specified schema.
I think that this behavior can be changed by adding a conditional that checks if a table exists in the specified schema in the following part of the code (specifically, where choice
is).
https://github.com/Networks-Learning/stackexchange-dump-to-postgres/blob/49d8358a83bb573c63c2715b122afb2fca98376c/load_into_pg.py#L391-L401
I think doing this is necessary for making the script fully scriptable since the current behavior requires the interaction of the user or some workaround for automating it.