← Back to scan
File as GitHub Issue repo: zzzeek/sqlalchemy

Push this scan report to zzzeek/sqlalchemy

Click the green button below to open GitHub’s new-issue form, pre-filled with the report title, summary table, top findings, and an embedded score-card image. No authentication needed — you review on GitHub before submitting. Repobility is credited as the scanner.

Embedded score card image

This image will render at the top of the issue body. Hosted on Repobility, refreshes automatically after re-scans.

Repobility score card

Issue title

Missing import: `select` used but not imported

Curate findings to include

Pick exactly which findings appear in the issue body. By default the top 5 are included. Uncheck noise, check what matters.

Top 5 (default)
Severity Rule Title File:line
CRIT MINED107 Missing import: `select` used but not imported lib/sqlalchemy/dialects/mysql/base.py:1745
CRIT MINED107 Missing import: `select` used but not imported lib/sqlalchemy/dialects/sqlite/base.py:1511
CRIT MINED107 Missing import: `select` used but not imported lib/sqlalchemy/dialects/mssql/base.py:2118
CRIT MINED107 Missing import: `copy` used but not imported lib/sqlalchemy/testing/exclusions.py:58
CRIT MINED107 Missing import: `select` used but not imported lib/sqlalchemy/sql/compiler.py:5323
CRIT MINED107 Missing import: `select` used but not imported lib/sqlalchemy/sql/selectable.py:4816
CRIT MINED107 Missing import: `operator` used but not imported lib/sqlalchemy/orm/evaluator.py:223
CRIT MINED107 Missing import: `enum` used but not imported test/typing/plain_files/ext/asyncio/eng…:94
CRIT MINED107 Missing import: `ast` used but not imported test/typing/plain_files/ext/asyncio/asy…:35
CRIT MINED107 Missing import: `queue` used but not imported test/dialect/oracle/_oracledb_mode.py:21
CRIT generic-api-key Detected a Generic API Key, potentially exposing access to various services and sensitive… lib/sqlalchemy/orm/mapped_collection.py:321
CRIT generic-api-key Detected a Generic API Key, potentially exposing access to various services and sensitive… lib/sqlalchemy/orm/unitofwork.py:247
CRIT generic-api-key Detected a Generic API Key, potentially exposing access to various services and sensitive… examples/versioned_history/history_meta…:322
HIGH MINED001 [MINED001] Bare Except Pass: except: pass or except Exception: pass — silently swallows e… examples/dynamic_dict/dynamic_dict.py:37
HIGH MINED004 [MINED004] Weak Crypto: MD5/SHA1/DES/RC4 used for security context (not just checksums). examples/dogpile_caching/environment.py:6
HIGH MINED009 [MINED009] Floats For Money: Variable named price/amount/cost typed as float instead of D… examples/association/proxied_associatio…:52
HIGH MINED009 [MINED009] Floats For Money: Variable named price/amount/cost typed as float instead of D… examples/association/basic_association.…:52
HIGH SEC128 [SEC128] Async function without await — fire-and-forget Promise (AI mistake): Async call … examples/nested_sets/nested_sets.py:54
HIGH SEC128 [SEC128] Async function without await — fire-and-forget Promise (AI mistake): Async call … examples/dogpile_caching/caching_query.…:100
HIGH SEC128 [SEC128] Async function without await — fire-and-forget Promise (AI mistake): Async call … examples/adjacency_list/adjacency_list.…:115
HIGH MINED108 `self.update_returning` used but never assigned in __init__ test/requirements.py:559
HIGH MINED108 `self.computed_columns` used but never assigned in __init__ test/requirements.py:522
HIGH MINED108 `self.sqlite` used but never assigned in __init__ test/requirements.py:518
HIGH MINED108 `self.insert_returning` used but never assigned in __init__ test/requirements.py:518
HIGH MINED108 `self.sequences` used but never assigned in __init__ test/requirements.py:511
HIGH MINED108 `self.get_isolation_levels` used but never assigned in __init__ test/requirements.py:483
HIGH MINED108 `self.isolation_level` used but never assigned in __init__ test/requirements.py:481
HIGH MINED108 `self._running_on_windows` used but never assigned in __init__ test/requirements.py:460
HIGH MINED108 `self.sqlite_memory` used but never assigned in __init__ test/requirements.py:445
HIGH MINED108 `self.gil_enabled` used but never assigned in __init__ test/requirements.py:439
HIGH MINED108 `self.cpython` used but never assigned in __init__ test/requirements.py:439
HIGH MINED108 `self._sqlite_memory_db` used but never assigned in __init__ test/requirements.py:428
HIGH MINED108 `self.tuple_in` used but never assigned in __init__ test/requirements.py:376
HIGH MINED108 `self._sqlite_file_db` used but never assigned in __init__ test/requirements.py:311
HIGH MINED108 `self.temporary_tables` used but never assigned in __init__ test/requirements.py:307
HIGH MINED108 `self._sqlite_file_db` used but never assigned in __init__ test/requirements.py:303
HIGH MINED108 `self._mysql_expression_defaults` used but never assigned in __init__ test/requirements.py:249
HIGH MINED108 `self._mysql_80` used but never assigned in __init__ test/requirements.py:179
HIGH MINED108 `self._mysql_80` used but never assigned in __init__ test/requirements.py:167
HIGH MINED108 `self._mariadb_105` used but never assigned in __init__ test/requirements.py:97
HIGH MINED108 `self._mysql_80` used but never assigned in __init__ test/requirements.py:96
HIGH MINED108 `self._mysql_check_constraints_dont_exist` used but never assigned in __init__ test/requirements.py:54
HIGH MINED108 `self.check_constraints` used but never assigned in __init__ test/requirements.py:53
HIGH MINED108 `self._tracer` used but never assigned in __init__ tools/trace_orm_adapter.py:56
HIGH MINED108 `self._tracer` used but never assigned in __init__ tools/trace_orm_adapter.py:52
HIGH MINED106 Phantom test coverage: test_pep8 noxfile.py:361
HIGH MINED106 Phantom test coverage: test_mypy noxfile.py:342
HIGH MINED106 Phantom test coverage: test_pep484 noxfile.py:327
HIGH MINED115 Action `actions/setup-python` pinned to mutable ref `@v6` .github/workflows/run-on-pr.yaml:80
HIGH MINED115 Action `actions/checkout` pinned to mutable ref `@v6` .github/workflows/run-on-pr.yaml:77
HIGH MINED115 Action `actions/setup-python` pinned to mutable ref `@v6` .github/workflows/run-on-pr.yaml:45
HIGH MINED115 Action `actions/checkout` pinned to mutable ref `@v6` .github/workflows/run-on-pr.yaml:42
HIGH MINED115 Action `actions/setup-python` pinned to mutable ref `@v6` .github/workflows/run-test.yaml:145
HIGH MINED115 Action `actions/checkout` pinned to mutable ref `@v6` .github/workflows/run-test.yaml:142
HIGH MINED115 Action `actions/setup-python` pinned to mutable ref `@v6` .github/workflows/run-test.yaml:107
HIGH MINED115 Action `actions/checkout` pinned to mutable ref `@v6` .github/workflows/run-test.yaml:104
HIGH MINED115 Action `sqlalchemyorg/upload-release-assets` pinned to mutable ref `@sa` .github/workflows/create-wheels.yaml:122
HIGH MINED115 Action `actions/setup-python` pinned to mutable ref `@v6` .github/workflows/create-wheels.yaml:103
HIGH MINED115 Action `pypa/cibuildwheel` pinned to mutable ref `@v3.4.1` .github/workflows/create-wheels.yaml:93
HIGH MINED115 Action `actions/checkout` pinned to mutable ref `@v6` .github/workflows/create-wheels.yaml:70
HIGH MINED131 pre-commit hook `https://github.com/pycqa/flake8` pinned to mutable rev `7.3.0` .pre-commit-config.yaml:15
HIGH MINED131 pre-commit hook `https://github.com/sqlalchemyorg/zimports` pinned to mutable rev `v0.7.0` .pre-commit-config.yaml:10
HIGH MINED131 pre-commit hook `https://github.com/python/black` pinned to mutable rev `26.3.1` .pre-commit-config.yaml:6
MED SEC127 [SEC127] AI agent stub — TODO: implement / pass placeholder body: Function body left as T… examples/versioned_rows/versioned_map.py:228
MED MINED109 Mutable default argument in `inspect_formatargspec` (dict) lib/sqlalchemy/util/compat.py:187
MED MINED111 Bare except continues silently lib/sqlalchemy/engine/base.py:1961
MED MINED111 Bare except continues silently lib/sqlalchemy/engine/base.py:1796
MED MINED111 Bare except continues silently lib/sqlalchemy/engine/base.py:1506
MED MINED111 Bare except continues silently lib/sqlalchemy/engine/base.py:1234
MED MINED111 Bare except continues silently lib/sqlalchemy/engine/base.py:1211
MED MINED111 Bare except continues silently lib/sqlalchemy/engine/base.py:1199
MED MINED111 Bare except continues silently lib/sqlalchemy/engine/base.py:1164
MED MINED111 Bare except continues silently lib/sqlalchemy/engine/base.py:1121
MED MINED111 Bare except continues silently lib/sqlalchemy/engine/base.py:647
MED MINED111 Bare except continues silently lib/sqlalchemy/engine/util.py:135
MED MINED111 Bare except continues silently lib/sqlalchemy/exc.py:759
MED MINED111 Bare except continues silently test/perf/compiled_extensions/base.py:106
MED MINED111 Bare except continues silently test/perf/compiled_extensions/base.py:47
MED MINED111 Bare except continues silently test/perf/compiled_extensions/command.py:53
MED MINED111 Bare except continues silently test/perf/many_table_reflection.py:554
MED MINED111 Bare except continues silently test/perf/invalidate_stresstest.py:34
MED MINED111 Bare except continues silently test/requirements.py:1337
MED MINED111 Bare except continues silently tools/format_docs_code.py:87
MED COMP001 [COMP001] High cognitive complexity: Function `_do_orm_execute` has cognitive complexity … examples/dogpile_caching/caching_query.…:45
MED AUC001 [AUC001] No Repobility access matrix policy found: The repository uses web/API frameworks… —
MED CORE_LARGE_FILES Average file size is 937 lines (recommend <300) —
LOW COMP001 [COMP001] High cognitive complexity: Function `execute_chooser` has cognitive complexity … examples/sharding/asyncio.py:169
LOW COMP001 [COMP001] High cognitive complexity: Function `_test_dbapi_raw` has cognitive complexity … examples/performance/single_inserts.py:139
LOW AIC003 Duplicated implementation block across source files test/typing/plain_files/ext/hybrid/hybr…:14
LOW AIC003 Duplicated implementation block across source files test/typing/plain_files/dialects/postgr…:113
LOW AIC003 Duplicated implementation block across source files lib/sqlalchemy/dialects/sqlite/json.py:51
LOW AIC003 Duplicated implementation block across source files lib/sqlalchemy/dialects/sqlite/dml.py:74
LOW AIC003 Duplicated implementation block across source files lib/sqlalchemy/dialects/postgresql/psyc…:365
LOW AIC003 Duplicated implementation block across source files lib/sqlalchemy/dialects/postgresql/pg80…:85
LOW AIC003 Duplicated implementation block across source files lib/sqlalchemy/dialects/oracle/json.py:78
LOW AIC003 Duplicated implementation block across source files lib/sqlalchemy/dialects/mysql/mysqlconn…:192
LOW AIC003 Duplicated implementation block across source files lib/sqlalchemy/dialects/mysql/json.py:25
LOW AIC003 Duplicated implementation block across source files lib/sqlalchemy/dialects/mysql/asyncmy.py:101
LOW AIC003 Duplicated implementation block across source files lib/sqlalchemy/dialects/mysql/asyncmy.py:82
LOW AIC003 Duplicated implementation block across source files lib/sqlalchemy/dialects/mysql/aiomysql.…:91
LOW AIC003 Duplicated implementation block across source files lib/sqlalchemy/dialects/mssql/mssqlpyth…:84
INFO MINED064 [MINED064] Python Input Call: input() blocks for stdin. Inappropriate in services. examples/dogpile_caching/environment.py:32
INFO MINED072 [MINED072] Python Pass Only Class: class Foo: pass — stub waiting to be filled in. examples/association/proxied_associatio…:25
INFO MINED072 [MINED072] Python Pass Only Class: class Foo: pass — stub waiting to be filled in. examples/association/basic_association.…:28
INFO MINED072 [MINED072] Python Pass Only Class: class Foo: pass — stub waiting to be filled in. examples/adjacency_list/adjacency_list.…:19
INFO MINED050 [MINED050] Stub Only Function: Function declared but body is just pass, return None, rais… examples/association/proxied_associatio…:26
INFO MINED050 [MINED050] Stub Only Function: Function declared but body is just pass, return None, rais… examples/association/basic_association.…:29
INFO MINED050 [MINED050] Stub Only Function: Function declared but body is just pass, return None, rais… examples/adjacency_list/adjacency_list.…:20
Reset to top 5 108 findings available (after auto-suppression of test files + won't-fix)

Issue body (markdown)

## Code-quality scan: `zzzeek/sqlalchemy`

**Score: 75/100 (B)**  ·  150 findings  ·  scanned 2026-06-05 14:27 UTC  ·  625,624 LOC

| Severity | Count |
|---|---|
| CRITICAL | 13 |
| HIGH | 50 |
| MEDIUM | 23 |
| LOW | 15 |

📊 [Full filterable report](https://repobility.com/scan/9886b44b-ae02-4216-82f5-3fa2f88cece3/)  ·  ![scorecard](https://repobility.com/scan/9886b44b-ae02-4216-82f5-3fa2f88cece3/report.png?v=1780669659-s2)

### Top findings

1. **CRITICAL** `MINED107` — Missing import: `select` used but not imported
   `lib/sqlalchemy/dialects/mysql/base.py:1745` · ✓ Repobility
2. **CRITICAL** `MINED107` — Missing import: `select` used but not imported
   `lib/sqlalchemy/dialects/sqlite/base.py:1511` · ✓ Repobility
3. **CRITICAL** `MINED107` — Missing import: `select` used but not imported
   `lib/sqlalchemy/dialects/mssql/base.py:2118` · ✓ Repobility
4. **CRITICAL** `MINED107` — Missing import: `copy` used but not imported
   `lib/sqlalchemy/testing/exclusions.py:58` · ✓ Repobility
5. **CRITICAL** `MINED107` — Missing import: `select` used but not imported
   `lib/sqlalchemy/sql/compiler.py:5323` · ✓ Repobility

---

_Filed automatically. Close this issue if not useful — we won't refile. Full report: https://repobility.com/scan/9886b44b-ae02-4216-82f5-3fa2f88cece3/_
Already filed
This repo publishes a SECURITY.md policy and the scan contains 3 Critical/High security finding(s). Public issue filing would violate coordinated disclosure. Submit privately via the project's security reporting channel.
Megaproject â high spam risk
Could not determine 'zzzeek/sqlalchemy' star count (GitHub API rate-limited or unreachable). When in doubt about repo size, prefer opening a focused PR or a discussion rather than an issue.
Already filed
107/153 findings (70%) on this scan are already flagged as test-file, won't-fix, or suppressed. The scan is too noisy to file as a single issue. Curate down to specific actionable findings, or address the FP source first.
I read the warnings â override Cancel

The button opens GitHubâs new-issue page in a new tab. You will see the title + body pre-filled â review, edit if you want, then click GitHubâs "Submit new issue" button. Repobility never posts anything on your behalf.

For real security findings on big repos: use the project's SECURITY.md or private advisory flow instead of a public issue.