Constraints Issues with Oracle

[cameronclaero]

Things to check first

• I have searched the existing issues and didn't find my bug already reported there

• I have checked that my bug is still present in the latest release

Sqlacodegen version

master

SQLAlchemy version

2 latest

RDBMS vendor

Oracle

What happened?

on writing out contraints, issues occured with capitals, and also spaces in regards to the column name when writing out.

Database schema for reproducing the bug

CREATE TABLE "QCTL"."COMPANIES"
( "CMP_AUTO_KEY" NUMBER NOT NULL ENABLE,
"CUR_AUTO_KEY" NUMBER,
"SVC_AUTO_KEY" NUMBER,
"TMC_AUTO_KEY" NUMBER,
"TXT_AUTO_KEY" NUMBER,
"CLC_AUTO_KEY" NUMBER,
"FPC_AUTO_KEY" NUMBER,
"COMPANY_CODE" VARCHAR2(10 BYTE) NOT NULL ENABLE,
"SITE_CODE" VARCHAR2(10 BYTE),
"ATTENTION" VARCHAR2(35 BYTE),
"ADDRESS1" VARCHAR2(35 BYTE),
"ADDRESS2" VARCHAR2(35 BYTE),
"ADDRESS3" VARCHAR2(35 BYTE),
"ALT_PHONE_NUMBER" VARCHAR2(20 BYTE),
"CITY" VARCHAR2(35 BYTE),
"COMPANY_ABBREV" VARCHAR2(12 BYTE) NOT NULL ENABLE,
"COMPANY_NAME" VARCHAR2(50 BYTE) NOT NULL ENABLE,
"CONTACT_NAME" VARCHAR2(50 BYTE),
"COUNTRY" VARCHAR2(35 BYTE),
"CURRENT_BALANCE" NUMBER,
"COMPANY_BRIDGE_DATE" DATE,
"CUSTOMER_FLAG" CHAR(1 BYTE),
"DEPARTMENT" VARCHAR2(35 BYTE),
"DISCOUNT" NUMBER,
"FAX_NUMBER" VARCHAR2(20 BYTE),
"FAX_BROADCAST_FLAG" CHAR(1 BYTE),
"INVC_DOC_STYLE" VARCHAR2(15 BYTE),
"LAST_SALE_DATE" DATE,
"MAIL_MERGE_FLAG" CHAR(1 BYTE),
"MAX_CREDIT" NUMBER,
"MISCELLANEOUS" VARCHAR2(20 BYTE),
"NOTES" CLOB DEFAULT empty_clob(),
"PHONE_NUMBER" VARCHAR2(20 BYTE),
"PHONE_STRIPPED" VARCHAR2(20 BYTE),
"PO_DOC_STYLE" VARCHAR2(15 BYTE),
"RESALE_NUMBER" VARCHAR2(20 BYTE),
"SHIP_COUNTRY" VARCHAR2(35 BYTE),
"SHIP_CITY" VARCHAR2(35 BYTE),
"SHIP_STATE" VARCHAR2(3 BYTE),
"SHIP_ADDRESS1" VARCHAR2(35 BYTE),
"SHIP_ADDRESS2" VARCHAR2(35 BYTE),
"SHIP_ADDRESS3" VARCHAR2(35 BYTE),
"SHIP_ZIP_CODE" VARCHAR2(10 BYTE),
"STATE" VARCHAR2(3 BYTE),
"SUPPLIER_ID" VARCHAR2(8 BYTE),
"VENDOR_FLAG" CHAR(1 BYTE),
"VENDOR_BRIDGE_DATE" DATE,
"YTD_SALES" NUMBER,
"ZIP_CODE" VARCHAR2(10 BYTE),
"CV_UDF_001" CHAR(1 BYTE),
"CV_UDF_002" CHAR(1 BYTE),
"CV_UDF_003" CHAR(1 BYTE),
"CV_UDF_004" CHAR(1 BYTE),
"CV_UDF_005" CHAR(1 BYTE),
"CV_UDF_006" CHAR(1 BYTE),
"CV_UDF_007" CHAR(1 BYTE),
"CV_UDF_008" CHAR(1 BYTE),
"CV_UDF_009" CHAR(1 BYTE),
"CV_UDF_010" CHAR(1 BYTE),
"CV_UDF_011" VARCHAR2(40 BYTE),
"CV_UDF_012" VARCHAR2(40 BYTE),
"CV_UDF_013" VARCHAR2(40 BYTE),
"CV_UDF_014" VARCHAR2(40 BYTE),
"CV_UDF_015" VARCHAR2(40 BYTE),
"COMPANY_NAME_UPPER" VARCHAR2(50 BYTE),
"COMPANY_CODE_UPPER" VARCHAR2(10 BYTE),
"SITE_CODE_UPPER" VARCHAR2(10 BYTE),
"TAX_ID" VARCHAR2(35 BYTE),
"VAT_NUMBER" VARCHAR2(25 BYTE),
"SEND_1099" CHAR(1 BYTE),
"GLA_AR" NUMBER,
"GLA_AP" NUMBER,
"EMAIL_ADDRESS" VARCHAR2(255 BYTE),
"IQ_ENABLE_QTY" CHAR(1 BYTE),
"IQ_ENABLE_PRICE" CHAR(1 BYTE),
"IQ_ENABLE_CONDITION" CHAR(1 BYTE),
"IQ_ENABLE_STOCK" CHAR(1 BYTE),
"IQ_ENABLE_TIMELIFE" CHAR(1 BYTE),
"IQ_ENABLE_RFQ" CHAR(1 BYTE),
"IQ_ENABLE_PO" CHAR(1 BYTE),
"SYSUR_IQ_NOTIFY_RFQ" NUMBER,
"SYSUR_IQ_NOTIFY_PO" NUMBER,
"ALLOW_ANY" VARCHAR2(10 BYTE),
"ALLOW_CQ" VARCHAR2(10 BYTE),
"ALLOW_VQ" VARCHAR2(10 BYTE),
"ALLOW_PO" VARCHAR2(10 BYTE),
"ALLOW_SO" VARCHAR2(10 BYTE),
"ALLOW_IN" VARCHAR2(10 BYTE),
"ALLOW_RO" VARCHAR2(10 BYTE),
"IQ_LOC" NUMBER,
"IQ_USER" VARCHAR2(30 BYTE),
"IQ_PASS" VARCHAR2(30 BYTE),
"IQ_RESPONSE_EMAIL" VARCHAR2(60 BYTE),
"IQ_HOSTNAME_OVERRIDE" VARCHAR2(100 BYTE),
"IQ_SEQ" NUMBER DEFAULT 1,
"IQ_CURRENCY" VARCHAR2(50 BYTE),
"AGN_AUTO_KEY" NUMBER,
"SPN_AUTO_KEY" NUMBER,
"FAX_STRIPPED" VARCHAR2(20 BYTE),
"DEFERRED_REC" CHAR(1 BYTE) DEFAULT 'F',
"SPEC_2000" CHAR(1 BYTE) DEFAULT 'F',
"CAP_RESTRICT_LEVEL" VARCHAR2(8 BYTE) DEFAULT 'NONE',
"AP_TOTAL" NUMBER(19,4) DEFAULT 0,
"IQ_VIEW_RFQ" CHAR(1 BYTE),
"IQ_VIEW_PO" CHAR(1 BYTE),
"IQ_QUOTE_TO_PO" CHAR(1 BYTE),
"CONVERTED" CHAR(1 BYTE) DEFAULT 'F',
"ILS_CODE" VARCHAR2(4 BYTE),
"CV_UDF_016" VARCHAR2(40 BYTE),
"CV_UDF_017" VARCHAR2(40 BYTE),
"CV_UDF_018" VARCHAR2(40 BYTE),
"CV_UDF_019" VARCHAR2(40 BYTE),
"CV_UDF_020" VARCHAR2(255 BYTE),
"CV_UDF_021" VARCHAR2(50 BYTE),
"CV_UDF_022" VARCHAR2(50 BYTE),
"CV_UDF_023" VARCHAR2(50 BYTE),
"CV_UDF_024" VARCHAR2(50 BYTE),
"CV_UDF_025" VARCHAR2(50 BYTE),
"CQ_WARNING" CLOB DEFAULT empty_clob(),
"SO_WARNING" CLOB DEFAULT empty_clob(),
"IN_WARNING" CLOB DEFAULT empty_clob(),
"VQ_WARNING" CLOB DEFAULT empty_clob(),
"PO_WARNING" CLOB DEFAULT empty_clob(),
"RO_WARNING" CLOB DEFAULT empty_clob(),
"WO_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_WO" VARCHAR2(10 BYTE),
"QUANTUM_ID" NUMBER,
"ALLOW_CM" VARCHAR2(10 BYTE),
"CM_WARNING" CLOB DEFAULT empty_clob(),
"TMC_VEND_OVERRIDE" NUMBER,
"EB_USERID" VARCHAR2(40 BYTE),
"DBA" CHAR(1 BYTE) DEFAULT 'F',
"CMP_PARENT" NUMBER,
"MKT_COMPANY_CODE" VARCHAR2(10 BYTE),
"MKC_AUTO_KEY" NUMBER,
"CV_UDF_053" DATE,
"DEFERRED_RO_REC" CHAR(1 BYTE),
"USE_MKT" CHAR(1 BYTE) DEFAULT 'F',
"RESTRICTED" CHAR(1 BYTE) DEFAULT 'F',
"SYSUR_AUTO_KEY" NUMBER,
"DATE_CREATED" DATE,
"PRIORITY_VENDOR" CHAR(1 BYTE) DEFAULT 'F',
"CREDIT_LIMIT" NUMBER(19,4) DEFAULT 0,
"QB_CUST_LISTID" VARCHAR2(40 BYTE),
"QB_VEND_LISTID" VARCHAR2(40 BYTE),
"SDF_CMP_001" VARCHAR2(40 BYTE),
"SDF_CMP_002" VARCHAR2(40 BYTE),
"SDF_CMP_003" VARCHAR2(40 BYTE),
"SDF_CMP_004" VARCHAR2(40 BYTE),
"SDF_CMP_005" VARCHAR2(40 BYTE),
"SDF_CMP_006" VARCHAR2(40 BYTE),
"SDF_CMP_007" VARCHAR2(40 BYTE),
"SDF_CMP_008" VARCHAR2(40 BYTE),
"SDF_CMP_009" VARCHAR2(40 BYTE),
"SDF_CMP_010" VARCHAR2(40 BYTE),
"ELC_REQUIRED" CHAR(1 BYTE) DEFAULT 'F',
"LABOR_DISCOUNT" NUMBER(19,4),
"CV_UDF_054" DATE,
"CNC_AUTO_KEY" NUMBER,
"ALLOW_WC" VARCHAR2(10 BYTE),
"WC_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_WQ" VARCHAR2(10 BYTE),
"WQ_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_WQ_BILL" VARCHAR2(10 BYTE),
"WQ_BILL_WARNING" CLOB DEFAULT empty_clob(),
"CORE_DUE_DAYS" NUMBER,
"DEPT_COMPANY" CHAR(1 BYTE) DEFAULT 'F',
"REQ_VERIFICATION" CHAR(1 BYTE) DEFAULT 'F',
"TRACK_CHANGES" CHAR(1 BYTE) DEFAULT 'F',
"GLD_AR" NUMBER,
"GLD_AP" NUMBER,
"COC_AUTO_KEY" NUMBER,
"SHIP_NAME" VARCHAR2(50 BYTE),
"DTC_AUTO_KEY" NUMBER,
"LAST_MODIFIED" DATE,
"SYSUR_MODIFIED" NUMBER,
"GLD_AP_PREPAY" NUMBER,
"GLD_AR_PREPAY" NUMBER,
"EDI_NUMBER" VARCHAR2(30 BYTE),
"EDI_SEQUENCE" NUMBER,
"LANG_CODE" VARCHAR2(2 BYTE) DEFAULT 'GB',
"ENQUEUE_MSG" CHAR(1 BYTE),
"ROUTING_NUMBER" VARCHAR2(15 BYTE),
"ACCOUNT_NUMBER" VARCHAR2(35 BYTE),
"ACH_VENDOR" VARCHAR2(1 BYTE) DEFAULT 'F',
"GLD_AP_EXPENSE" NUMBER,
"WEB_SITE" VARCHAR2(100 BYTE),
"INVOICE_EMAIL" VARCHAR2(60 BYTE),
"GLD_AP_SUSPENSE" NUMBER,
"INTERNAL_FLAG" VARCHAR2(1 BYTE) DEFAULT 'F',
"COC_OFFICE" NUMBER,
"APPROVAL_EXPIRE" DATE,
"APR_AUTO_KEY" NUMBER,
"CONVERSION_ID" NUMBER,
"DHL_DELIVERY_DUTY_PAYOR" VARCHAR2(15 BYTE) DEFAULT 'DDU',
"ALLOW_WP" VARCHAR2(10 BYTE),
"WP_WARNING" CLOB DEFAULT empty_clob(),
"VQ_APPROVED" VARCHAR2(1 BYTE) DEFAULT 'F',
"CFF_AUTO_KEY" NUMBER,
"BANK_NAME" VARCHAR2(70 BYTE),
"BANK_ADDRESS1" VARCHAR2(35 BYTE),
"BANK_ADDRESS2" VARCHAR2(35 BYTE),
"BANK_ADDRESS3" VARCHAR2(35 BYTE),
"BANK_COUNTRY_CODE" VARCHAR2(3 BYTE),
"INTERMEDIATE_BANK_NAME" VARCHAR2(35 BYTE),
"INTERMEDIATE_BANK_ADDRESS1" VARCHAR2(35 BYTE),
"INTERMEDIATE_BANK_ADDRESS2" VARCHAR2(35 BYTE),
"INTERMEDIATE_BANK_ADDDRES3" VARCHAR2(35 BYTE),
"INTERMEDIATE_BANK_COUNTRY" VARCHAR2(3 BYTE),
"INTERMEDIATE_BANK_SWIFT" VARCHAR2(11 BYTE),
"INTERMEDIATE_CLEARING_CODE" VARCHAR2(30 BYTE),
"INTERMEDIATE_CLEARING_TYPE" VARCHAR2(35 BYTE),
"SWIFT_CODE" VARCHAR2(11 BYTE),
"ALLOW_MO" VARCHAR2(10 BYTE),
"MO_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_PR" VARCHAR2(10 BYTE),
"PR_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_LC" VARCHAR2(10 BYTE),
"LC_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_AP" VARCHAR2(10 BYTE),
"AP_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_CR" VARCHAR2(10 BYTE),
"CR_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_RR" VARCHAR2(10 BYTE),
"RR_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_CKM" VARCHAR2(10 BYTE),
"CKM_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_SMB" VARCHAR2(10 BYTE),
"SMB_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_SM" VARCHAR2(10 BYTE),
"SM_WARNING" CLOB DEFAULT empty_clob(),
"ALLOW_RI" VARCHAR2(10 BYTE),
"RI_WARNING" CLOB DEFAULT empty_clob(),
"SDF_CMP_011" VARCHAR2(40 BYTE),
"SDF_CMP_012" VARCHAR2(40 BYTE),
"SDF_CMP_013" VARCHAR2(40 BYTE),
"SDF_CMP_014" VARCHAR2(40 BYTE),
"SDF_CMP_015" VARCHAR2(40 BYTE),
"SDF_CMP_016" VARCHAR2(40 BYTE),
"SDF_CMP_017" VARCHAR2(40 BYTE),
"SDF_CMP_018" VARCHAR2(40 BYTE),
"SDF_CMP_019" VARCHAR2(40 BYTE),
"SDF_CMP_020" VARCHAR2(40 BYTE),
"RECO" VARCHAR2(1 BYTE) DEFAULT 'F',
"EDD_ID" VARCHAR2(50 BYTE),
"SMA_WARNING" CLOB DEFAULT empty_clob(),
"BOX_1099" NUMBER DEFAULT 7,
"REQ_CONTRACT" VARCHAR2(1 BYTE) DEFAULT 'F',
"BANK_CHARGES_INDICATOR" NUMBER DEFAULT 0,
"PO_COST_METHOD" CHAR(1 BYTE) DEFAULT '0',
"BUC_CODE" VARCHAR2(20 BYTE),
"WO_NOTES" CLOB DEFAULT empty_clob(),
"MSG_VENDOR" CHAR(1 BYTE) DEFAULT 'F',
"AMAZON_BUCKET" VARCHAR2(256 BYTE),
"QQM_SENDER_ID" VARCHAR2(10 BYTE),
"MFG_AUTO_KEY" NUMBER,
"INTEGRATED_MANUALS" VARCHAR2(1 BYTE),
"SDF_CMP_021" VARCHAR2(40 BYTE),
"TRACKER_VISIBLE_PORTAL" VARCHAR2(1 BYTE),
"BOA_WARNING" CLOB DEFAULT empty_clob(),
"PBH_FLAG" VARCHAR2(1 BYTE),
"ALLOW_SMS" VARCHAR2(10 BYTE) DEFAULT 'Yes',
"SMS_WARNING" CLOB DEFAULT empty_clob(),
"PMA_RESTRICTED" VARCHAR2(1 BYTE) DEFAULT 'F',
"IBAN_ACCOUNT_NUMBER" VARCHAR2(35 BYTE),
"DER_RESTRICTED" VARCHAR2(1 BYTE) DEFAULT 'F',
"HISTORICAL" VARCHAR2(1 BYTE) DEFAULT 'F',
"ALLOW_CERT" VARCHAR2(10 BYTE),
"CERT_WARNING" CLOB DEFAULT empty_clob(),
"STOCK_SAFETY_PRIORITY_LEVEL" NUMBER,
"FOB" VARCHAR2(30 BYTE),
"SYSCM_AUTO_KEY" NUMBER,
"AEX_REGISTRATION_ID" VARCHAR2(10 BYTE),
"QQM_IMS_AUTO_KEY" NUMBER,
"ALLOW_RC" VARCHAR2(10 BYTE),
"RC_WARNING" CLOB DEFAULT empty_clob(),
"CMG_AUTO_KEY" NUMBER,
"EDI_AUTO_DELIVER" VARCHAR2(1 BYTE),
CONSTRAINT "VALID_RULE_21641" CHECK ( SPEC_2000 in ('F','T') ) ENABLE,
CONSTRAINT "VALID_RULE_179" CHECK ( CAP_RESTRICT_LEVEL IN ('NONE', 'WARN', 'RESTRICT') ) ENABLE,
CONSTRAINT "VALID_RULE_21640" CHECK ( DEFERRED_REC in ('F','T') ) ENABLE,
CONSTRAINT "FK_SYSR_CMP" FOREIGN KEY ("SYSUR_AUTO_KEY")
REFERENCES "QCTL"."SYS_USERS" ("SYSUR_AUTO_KEY") ENABLE,
CONSTRAINT "FK_TMC_CMP" FOREIGN KEY ("TMC_AUTO_KEY")
REFERENCES "QCTL"."TERM_CODES" ("TMC_AUTO_KEY") ENABLE,
CONSTRAINT "FK_COC_CMP_OFFICE" FOREIGN KEY ("COC_OFFICE")
REFERENCES "QCTL"."COUNTRY_CODES" ("COC_AUTO_KEY") ENABLE,
CONSTRAINT "FK_GLD_CMP_AR_PREPAY" FOREIGN KEY ("GLD_AR_PREPAY")
REFERENCES "QCTL"."GL_DISTRIBUTION" ("GLD_AUTO_KEY") ENABLE,
CONSTRAINT "FK_TMC_CMP_VEND" FOREIGN KEY ("TMC_VEND_OVERRIDE")
REFERENCES "QCTL"."TERM_CODES" ("TMC_AUTO_KEY") ENABLE,
CONSTRAINT "FK_CLC_CMP" FOREIGN KEY ("CLC_AUTO_KEY")
REFERENCES "QCTL"."CLASS_CODES" ("CLC_AUTO_KEY") ENABLE,
CONSTRAINT "FK_COC_CMP" FOREIGN KEY ("COC_AUTO_KEY")
REFERENCES "QCTL"."COUNTRY_CODES" ("COC_AUTO_KEY") ENABLE,
CONSTRAINT "FK_DTC_CMP" FOREIGN KEY ("DTC_AUTO_KEY")
REFERENCES "QCTL"."DELIVERY_TERMS" ("DTC_AUTO_KEY") ENABLE,
CONSTRAINT "FK_MKC_CMP" FOREIGN KEY ("MKC_AUTO_KEY")
REFERENCES "QCTL"."MARKUP_CODES" ("MKC_AUTO_KEY") ENABLE,
CONSTRAINT "FK_GLD_CMP_AP_SUSPENSE" FOREIGN KEY ("GLD_AP_SUSPENSE")
REFERENCES "QCTL"."GL_DISTRIBUTION" ("GLD_AUTO_KEY") ENABLE,
CONSTRAINT "FK_CUR_CMP" FOREIGN KEY ("CUR_AUTO_KEY")
REFERENCES "QCTL"."CURRENCY" ("CUR_AUTO_KEY") ENABLE,
CONSTRAINT "FK_TXT_CMP" FOREIGN KEY ("TXT_AUTO_KEY")
REFERENCES "QCTL"."TAX_TABLE" ("TXT_AUTO_KEY") ENABLE,
CONSTRAINT "FK_QQM_IMS_CMP" FOREIGN KEY ("QQM_IMS_AUTO_KEY")
REFERENCES "QCTL"."IMAGE_SERVER" ("IMS_AUTO_KEY") ENABLE,
CONSTRAINT "FK_MFG_CMP" FOREIGN KEY ("MFG_AUTO_KEY")
REFERENCES "QCTL"."MANUFACTURER" ("MFG_AUTO_KEY") ENABLE,
CONSTRAINT "FK_APR_CMP" FOREIGN KEY ("APR_AUTO_KEY")
REFERENCES "QCTL"."APPROVAL_CODES" ("APR_AUTO_KEY") ENABLE,
CONSTRAINT "FK_SYSR_CMP_PO" FOREIGN KEY ("SYSUR_IQ_NOTIFY_PO")
REFERENCES "QCTL"."SYS_USERS" ("SYSUR_AUTO_KEY") ENABLE,
CONSTRAINT "FK_FPC_CMP" FOREIGN KEY ("FPC_AUTO_KEY")
REFERENCES "QCTL"."FAX_PREFIX_CODES" ("FPC_AUTO_KEY") ENABLE,
CONSTRAINT "FK_GLD_CMP_AP_EXPENSE" FOREIGN KEY ("GLD_AP_EXPENSE")
REFERENCES "QCTL"."GL_DISTRIBUTION" ("GLD_AUTO_KEY") ENABLE,
CONSTRAINT "FK_SVC_CMP" FOREIGN KEY ("SVC_AUTO_KEY")
REFERENCES "QCTL"."SHIP_VIA_CODES" ("SVC_AUTO_KEY") ENABLE,
CONSTRAINT "FK_CMG_CMP" FOREIGN KEY ("CMG_AUTO_KEY")
REFERENCES "QCTL"."COMPANY_GROUPS" ("CMG_AUTO_KEY") ENABLE,
CONSTRAINT "FK_SYSR_CMP_RFQ" FOREIGN KEY ("SYSUR_IQ_NOTIFY_RFQ")
REFERENCES "QCTL"."SYS_USERS" ("SYSUR_AUTO_KEY") ENABLE,
CONSTRAINT "FK_GLD_CMP_AP_PREPAY" FOREIGN KEY ("GLD_AP_PREPAY")
REFERENCES "QCTL"."GL_DISTRIBUTION" ("GLD_AUTO_KEY") ENABLE,
CONSTRAINT "FK_CFF_CMP" FOREIGN KEY ("CFF_AUTO_KEY")
REFERENCES "QCTL"."CK_FILE_FORMAT_CODES" ("CFF_AUTO_KEY") ENABLE,
CONSTRAINT "FK_CMP_CMP" FOREIGN KEY ("CMP_PARENT")
REFERENCES "QCTL"."COMPANIES" ("CMP_AUTO_KEY") ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING

[cameronclaero]

Traceback (most recent call last):
File "/usr/lib64/python3.11/runpy.py", line 198, in _run_module_as_main
return _run_code(code, main_globals, None,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib64/python3.11/runpy.py", line 88, in _run_code
exec(code, run_globals)
File "/home/cameron/.vscode-server/extensions/ms-python.python-2023.16.0/pythonFiles/lib/python/debugpy/adapter/../../debugpy/launcher/../../debugpy/main.py", line 39, in
cli.main()
File "/home/cameron/.vscode-server/extensions/ms-python.python-2023.16.0/pythonFiles/lib/python/debugpy/adapter/../../debugpy/launcher/../../debugpy/../debugpy/server/cli.py", line 430, in main
run()
File "/home/cameron/.vscode-server/extensions/ms-python.python-2023.16.0/pythonFiles/lib/python/debugpy/adapter/../../debugpy/launcher/../../debugpy/../debugpy/server/cli.py", line 317, in run_module
run_module_as_main(options.target, alter_argv=True)
File "/home/cameron/.vscode-server/extensions/ms-python.python-2023.16.0/pythonFiles/lib/python/debugpy/_vendored/pydevd/_pydevd_bundle/pydevd_runpy.py", line 238, in _run_module_as_main
return _run_code(code, main_globals, None,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/cameron/.vscode-server/extensions/ms-python.python-2023.16.0/pythonFiles/lib/python/debugpy/_vendored/pydevd/_pydevd_bundle/pydevd_runpy.py", line 124, in _run_code
exec(code, run_globals)
File "/home/cameron/development/sqlacodegen/src/sqlacodegen/main.py", line 3, in
main()
File "/home/cameron/development/sqlacodegen/src/sqlacodegen/cli.py", line 92, in main
outfile.write(generator.generate())
^^^^^^^^^^^^^^^^^^^^
File "/home/cameron/development/sqlacodegen/src/sqlacodegen/generators.py", line 172, in generate
self.fix_column_types(table)
File "/home/cameron/development/sqlacodegen/src/sqlacodegen/generators.py", line 637, in fix_column_types
if isinstance(table.c[colname].type, String):
~~~~~~~^^^^^^^^^
File "/home/cameron/.local/lib/python3.11/site-packages/sqlalchemy/sql/base.py", line 1623, in getitem
return self._index[key][1]
~~~~~~~~~~~^^^^^
KeyError: ' CAP_RESTRICT_LEVEL'