Description
First: THANK YOU for making this! It will save me a HUGE amount of time!
Question: Could my issue be that I'm using Python 3.8 with pip updated all libraries your code imports?
Should I use a specific version of Python?
ERROR REPORT:
C:\Python\Python38>reorder.py -d inventory -n public.tbl_items_to_items id id_session id_child t_part_no t_part_no_parent d_modified b_enabled -f c:\python\python38\logColReorder.txt -m
Traceback (most recent call last):
File "C:\Python\Python38\reorder.py", line 218, in
main()
File "C:\Python\Python38\lib\site-packages\click\core.py", line 829, in call
return self.main(*args, **kwargs)
File "C:\Python\Python38\lib\site-packages\click\core.py", line 782, in main
rv = self.invoke(ctx)
File "C:\Python\Python38\lib\site-packages\click\core.py", line 1066, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "C:\Python\Python38\lib\site-packages\click\core.py", line 610, in invoke
return callback(*args, **kwargs)
File "C:\Python\Python38\reorder.py", line 198, in main
cols, extras = get_columns(database, schema, table)
File "C:\Python\Python38\reorder.py", line 25, in get_columns
sql_text = get_dump_sql(database, schema, table)
File "C:\Python\Python38\reorder.py", line 15, in get_dump_sql
result = subprocess.run(
File "C:\Python\Python38\lib\subprocess.py", line 489, in run
with Popen(*popenargs, **kwargs) as process:
File "C:\Python\Python38\lib\subprocess.py", line 854, in init
self._execute_child(args, executable, preexec_fn, close_fds,
File "C:\Python\Python38\lib\subprocess.py", line 1307, in _execute_child
hp, ht, pid, tid = _winapi.CreateProcess(executable, args,
FileNotFoundError: [WinError 2] The system cannot find the file specified