Strange duplicate-related error

57 views
Skip to first unread message

Jim B

unread,
May 10, 2021, 12:40:10 PM5/10/21
to sqlalchemy
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
Reply all
Reply to author
Forward
0 new messages