Hi,
I'm trying to get sqlacodegen working with an existing database with multiple schemas. I'm running in a clean python 3.6.10 conda environment that only contains sqlacodegen and cx_oracle.
I'm running the following command:
sqlacodegen oracle://USER:PASSWORD@ORACLE_HOST:PORT/?service_name=NAME --schema SCHEMA
It fails, with some sort of error involving a missing key.
Traceback (most recent call last):
File "/nfs/shared/miniconda3/envs/sqlacodegen/bin/sqlacodegen", line 8, in <module>
sys.exit(main())
File "/nfs/shared/miniconda3/envs/sqlacodegen/lib/python3.6/site-packages/sqlacodegen/main.py", line 52, in main
args.noinflect, args.noclasses, nocomments=args.nocomments)
File "/nfs/shared/miniconda3/envs/sqlacodegen/lib/python3.6/site-packages/sqlacodegen/codegen.py", line 424, in __init__
if isinstance(table.c[colname].type, String):
File "/nfs/shared/miniconda3/envs/sqlacodegen/lib/python3.6/site-packages/sqlalchemy/sql/base.py", line 1157, in __getitem__
return self._index[key]
KeyError: 'POTENTIAL_DUPLICATE'
This isn't very informative. Can anyone suggest a way I can start tracing what the issue is?
Thanks
James