René's URL Explorer Experiment


Title: Python: Add SqlAlchemy model by mrthankyou · Pull Request #5680 · github/codeql · GitHub

Open Graph Title: Python: Add SqlAlchemy model by mrthankyou · Pull Request #5680 · github/codeql

X Title: Python: Add SqlAlchemy model by mrthankyou · Pull Request #5680 · github/codeql

Description: This PR is meant to add a module for dealing with SqlAlchemy in Python CodeQL queries. For context, this will be used in an upcoming CodeQL security query so I decided to go ahead and submit this PR to get the ball rolling.

Open Graph Description: This PR is meant to add a module for dealing with SqlAlchemy in Python CodeQL queries. For context, this will be used in an upcoming CodeQL security query so I decided to go ahead and submit this P...

X Description: This PR is meant to add a module for dealing with SqlAlchemy in Python CodeQL queries. For context, this will be used in an upcoming CodeQL security query so I decided to go ahead and submit this P...

Opengraph URL: https://github.com/github/codeql/pull/5680

X: @github

direct link

Domain: github.com

route-pattern/:user_id/:repository/pull/:id/files(.:format)
route-controllerpull_requests
route-actionfiles
fetch-noncev2:d6711b84-72c3-97f1-856a-0164e6cd7338
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idA8EE:296F05:B765D9:F7E16F:6A4D54F6
html-safe-nonceee1e6c1dd8b20cf6c1ff1bd787fcfc361f1e2aa8b423a8ed134b4509e0fef20b
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBOEVFOjI5NkYwNTpCNzY1RDk6RjdFMTZGOjZBNEQ1NEY2IiwidmlzaXRvcl9pZCI6IjUwODk5NTc2MjY3ODQ4NjM0NzgiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmac94584ed1dc5e9698551f13c48bbdcaf4991139d3670fbff18881dfebe161b6e5
hovercard-subject-tagpull_request:615659690
github-keyboard-shortcutsrepository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///pull_requests/show/files
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/github/codeql/pull/5680/files
twitter:imagehttps://avatars.githubusercontent.com/u/52643283?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/52643283?s=400&v=4
og:image:altThis PR is meant to add a module for dealing with SqlAlchemy in Python CodeQL queries. For context, this will be used in an upcoming CodeQL security query so I decided to go ahead and submit this P...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None92571a8944142227b7e19cd10918b1ddd06e5066c1ad5bc7e4769cf6140a87e6
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/github/codeql git https://github.com/github/codeql.git
octolytics-dimension-user_id9919
octolytics-dimension-user_logingithub
octolytics-dimension-repository_id143040428
octolytics-dimension-repository_nwogithub/codeql
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id143040428
octolytics-dimension-repository_network_root_nwogithub/codeql
turbo-body-classeslogged-out env-production page-responsive full-width
disable-turbotrue
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release56fc8347865a14e2ec811533d68f929cf4e0ec19
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/github/codeql/pull/5680/files#start-of-content
https://github.com/
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fgithub%2Fcodeql%2Fpull%2F5680%2Ffiles
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub Copilot appDirect agents from issue to mergehttps://github.com/features/ai/github-app
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
View all resourceshttps://github.com/resources
GitHub SponsorsFund open source developershttps://github.com/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/accelerator
GitHub Starshttps://stars.github.com
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fgithub%2Fcodeql%2Fpull%2F5680%2Ffiles
Sign up https://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fpull_requests%2Fshow%2Ffiles&source=header-repo&source_repo=github%2Fcodeql
Reloadhttps://github.com/github/codeql/pull/5680/files
Reloadhttps://github.com/github/codeql/pull/5680/files
Reloadhttps://github.com/github/codeql/pull/5680/files
Please reload this pagehttps://github.com/github/codeql/pull/5680/files
github https://github.com/github
codeqlhttps://github.com/github/codeql
Notifications https://github.com/login?return_to=%2Fgithub%2Fcodeql
Fork 2k https://github.com/login?return_to=%2Fgithub%2Fcodeql
Star 9.8k https://github.com/login?return_to=%2Fgithub%2Fcodeql
Code https://github.com/github/codeql
Issues 988 https://github.com/github/codeql/issues
Pull requests 424 https://github.com/github/codeql/pulls
Discussions https://github.com/github/codeql/discussions
Actions https://github.com/github/codeql/actions
Projects https://github.com/github/codeql/projects
Models https://github.com/github/codeql/models
Security and quality 0 https://github.com/github/codeql/security
Insights https://github.com/github/codeql/pulse
Code https://github.com/github/codeql
Issues https://github.com/github/codeql/issues
Pull requests https://github.com/github/codeql/pulls
Discussions https://github.com/github/codeql/discussions
Actions https://github.com/github/codeql/actions
Projects https://github.com/github/codeql/projects
Models https://github.com/github/codeql/models
Security and quality https://github.com/github/codeql/security
Insights https://github.com/github/codeql/pulse
Sign up for GitHub https://github.com/signup?return_to=%2Fgithub%2Fcodeql%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Fgithub%2Fcodeql%2Fissues%2Fnew%2Fchoose
RasmusWLhttps://github.com/RasmusWL
github:mainhttps://github.com/github/codeql/tree/main
mrthankyou:python-use-sqlalchemyhttps://github.com/mrthankyou/codeql/tree/python-use-sqlalchemy
Conversation 22 https://github.com/github/codeql/pull/5680
Findings https://github.com/github/codeql/pull/5680/findings
Commits 13 https://github.com/github/codeql/pull/5680/commits
Checks 0 https://github.com/github/codeql/pull/5680/checks
Files changed https://github.com/github/codeql/pull/5680/files
Please reload this pagehttps://github.com/github/codeql/pull/5680/files
Python: Add SqlAlchemy model https://github.com/github/codeql/pull/5680/files#top
Show all changes 13 commits https://github.com/github/codeql/pull/5680/files
f1e71e2 Add SqlAlchemy module mrthankyou Apr 15, 2021 https://github.com/github/codeql/pull/5680/commits/f1e71e21ed543e727f403dd7c904e31a4aba1f19
a854fb8 Add documentation and refactor code mrthankyou Apr 15, 2021 https://github.com/github/codeql/pull/5680/commits/a854fb8f8b16a2af5a548465a5e4d551f135a9ba
c5fbbc0 Refactor SqlAlchemy model mrthankyou Apr 19, 2021 https://github.com/github/codeql/pull/5680/commits/c5fbbc055179e4459dd327257fa7c827ed92f5ba
3ace495 Add tests for SqlAlchemy modeling library mrthankyou May 10, 2021 https://github.com/github/codeql/pull/5680/commits/3ace49549a94b34634dcadc8932951c7e944129e
eac1c5d Python: Fix concepts-tests for SQLAlchemy RasmusWL Jun 29, 2021 https://github.com/github/codeql/pull/5680/commits/eac1c5d10982f5c72a57e742dacb4327af0153a6
684f51a Merge branch 'main' into python-use-sqlalchemy RasmusWL Jun 29, 2021 https://github.com/github/codeql/pull/5680/commits/684f51ae5fc90cd59dca8af434a90df37eb36667
cb11239 Python: Fixup after merging main RasmusWL Jun 29, 2021 https://github.com/github/codeql/pull/5680/commits/cb112395f84c16bf8e4c1399b4190da744b7ff83
ef48734 Python: Add taint-tests for SQLAlchemy RasmusWL Jun 29, 2021 https://github.com/github/codeql/pull/5680/commits/ef48734206153930163d3da7a27f6cec9f3cd80d
a5a7f3e Python: Add taint-step for `sqlalchemy.text` RasmusWL Jun 29, 2021 https://github.com/github/codeql/pull/5680/commits/a5a7f3e38ac38ef221697e0f541caaffeda0b144
2a65917 Merge pull request #1 from RasmusWL/python-use-sqlalchemy mrthankyou Jun 29, 2021 https://github.com/github/codeql/pull/5680/commits/2a65917bb5cccbdd8a42d0448a713b51d9f64854
986f2f4 Add SQLEscape module mrthankyou Jun 29, 2021 https://github.com/github/codeql/pull/5680/commits/986f2f43028bd319ad9f6374deb9062560a14798
0be2c6b Add SQLEscapySanitizerCall class mrthankyou Jun 29, 2021 https://github.com/github/codeql/pull/5680/commits/0be2c6b7657bc1930daf5b3b86545b864dd0e8e2
9e01338 Query only vulnerable methods mrthankyou Jul 18, 2021 https://github.com/github/codeql/pull/5680/commits/9e01338500b703adf3d9084b0e9d22623ef8643c
Clear filters https://github.com/github/codeql/pull/5680/files
Please reload this pagehttps://github.com/github/codeql/pull/5680/files
Please reload this pagehttps://github.com/github/codeql/pull/5680/files
Concepts.qll https://github.com/github/codeql/pull/5680/files#diff-07631b7f3489bbd6603ecbc9149f5919406181361b1bd04a53e048f531a4986a
SqlAlchemy.qll https://github.com/github/codeql/pull/5680/files#diff-96976daafec69640263410961f501f25450caf3f14c3a0c27049a45df46ac17b
ConceptsTest.expected https://github.com/github/codeql/pull/5680/files#diff-1bb4e6013de1b86edc5a5eec0b4d38c710943c08fc2c33a2280873c6500a91bb
ConceptsTest.ql https://github.com/github/codeql/pull/5680/files#diff-7e33258dd4fdc1d909bf159ac8c95ae563461af6b15f1382dd355824529017b8
InlineTaintTest.expected https://github.com/github/codeql/pull/5680/files#diff-a26c8c1548575a4f3077ddd8e30ccc4de32aa664c5c0956b3982d19fd73359da
InlineTaintTest.ql https://github.com/github/codeql/pull/5680/files#diff-3f2480f326955602b4d4ba37740af620a74174e40b19a7923e60fac42592ee43
SqlExecution.py https://github.com/github/codeql/pull/5680/files#diff-0f85880cfbfd5adea5c38284361e885803c94951709351b6d7761a9639a8172e
taint_test.py https://github.com/github/codeql/pull/5680/files#diff-4bc0e52905aed70f6104afeceaa44a9ea90a60335a104538d2aaf40c3a8ca907
https://github.com/github/codeql/blob/main/CODEOWNERS#L19
python/ql/src/experimental/semmle/python/Concepts.qllhttps://github.com/github/codeql/pull/5680/files#diff-07631b7f3489bbd6603ecbc9149f5919406181361b1bd04a53e048f531a4986a
View file https://github.com/mrthankyou/codeql/blob/9e01338500b703adf3d9084b0e9d22623ef8643c/python/ql/src/experimental/semmle/python/Concepts.qll
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/github/codeql/pull/5680/{{ revealButtonHref }}
https://github.com/github/codeql/pull/5680/files#diff-07631b7f3489bbd6603ecbc9149f5919406181361b1bd04a53e048f531a4986a
https://github.com/github/codeql/blob/main/CODEOWNERS#L19
python/ql/src/experimental/semmle/python/frameworks/SqlAlchemy.qllhttps://github.com/github/codeql/pull/5680/files#diff-96976daafec69640263410961f501f25450caf3f14c3a0c27049a45df46ac17b
View file https://github.com/mrthankyou/codeql/blob/9e01338500b703adf3d9084b0e9d22623ef8643c/python/ql/src/experimental/semmle/python/frameworks/SqlAlchemy.qll
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/github/codeql/pull/5680/{{ revealButtonHref }}
mrthankyouhttps://github.com/mrthankyou
Jun 29, 2021https://github.com/github/codeql/pull/5680/files#r661003933
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
Please reload this pagehttps://github.com/github/codeql/pull/5680/files
RasmusWLhttps://github.com/RasmusWL
Jun 30, 2021https://github.com/github/codeql/pull/5680/files#r661723672
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
https://pypi.org/project/SQLAlchemy/#historyhttps://pypi.org/project/SQLAlchemy/#history
Please reload this pagehttps://github.com/github/codeql/pull/5680/files
mrthankyouhttps://github.com/mrthankyou
Jun 29, 2021https://github.com/github/codeql/pull/5680/files#r661003340
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
Please reload this pagehttps://github.com/github/codeql/pull/5680/files
Please reload this pagehttps://github.com/github/codeql/pull/5680/files
https://github.com/github/codeql/blob/main/CODEOWNERS#L19
python/ql/test/experimental/library-tests/frameworks/sqlalchemy/ConceptsTest.expectedhttps://github.com/github/codeql/pull/5680/files#diff-1bb4e6013de1b86edc5a5eec0b4d38c710943c08fc2c33a2280873c6500a91bb
View file https://github.com/mrthankyou/codeql/blob/9e01338500b703adf3d9084b0e9d22623ef8643c/python/ql/test/experimental/library-tests/frameworks/sqlalchemy/ConceptsTest.expected
Open in desktop https://desktop.github.com
https://github.com/github/codeql/blob/main/CODEOWNERS#L19
python/ql/test/experimental/library-tests/frameworks/sqlalchemy/ConceptsTest.qlhttps://github.com/github/codeql/pull/5680/files#diff-7e33258dd4fdc1d909bf159ac8c95ae563461af6b15f1382dd355824529017b8
View file https://github.com/mrthankyou/codeql/blob/9e01338500b703adf3d9084b0e9d22623ef8643c/python/ql/test/experimental/library-tests/frameworks/sqlalchemy/ConceptsTest.ql
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/github/codeql/pull/5680/{{ revealButtonHref }}
https://github.com/github/codeql/blob/main/CODEOWNERS#L19
python/ql/test/experimental/library-tests/frameworks/sqlalchemy/InlineTaintTest.expectedhttps://github.com/github/codeql/pull/5680/files#diff-a26c8c1548575a4f3077ddd8e30ccc4de32aa664c5c0956b3982d19fd73359da
View file https://github.com/mrthankyou/codeql/blob/9e01338500b703adf3d9084b0e9d22623ef8643c/python/ql/test/experimental/library-tests/frameworks/sqlalchemy/InlineTaintTest.expected
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/github/codeql/pull/5680/{{ revealButtonHref }}
https://github.com/github/codeql/blob/main/CODEOWNERS#L19
python/ql/test/experimental/library-tests/frameworks/sqlalchemy/InlineTaintTest.qlhttps://github.com/github/codeql/pull/5680/files#diff-3f2480f326955602b4d4ba37740af620a74174e40b19a7923e60fac42592ee43
View file https://github.com/mrthankyou/codeql/blob/9e01338500b703adf3d9084b0e9d22623ef8643c/python/ql/test/experimental/library-tests/frameworks/sqlalchemy/InlineTaintTest.ql
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/github/codeql/pull/5680/{{ revealButtonHref }}
https://github.com/github/codeql/blob/main/CODEOWNERS#L19
python/ql/test/experimental/library-tests/frameworks/sqlalchemy/SqlExecution.pyhttps://github.com/github/codeql/pull/5680/files#diff-0f85880cfbfd5adea5c38284361e885803c94951709351b6d7761a9639a8172e
View file https://github.com/mrthankyou/codeql/blob/9e01338500b703adf3d9084b0e9d22623ef8643c/python/ql/test/experimental/library-tests/frameworks/sqlalchemy/SqlExecution.py
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/github/codeql/pull/5680/{{ revealButtonHref }}
https://github.com/github/codeql/blob/main/CODEOWNERS#L19
python/ql/test/experimental/library-tests/frameworks/sqlalchemy/taint_test.pyhttps://github.com/github/codeql/pull/5680/files#diff-4bc0e52905aed70f6104afeceaa44a9ea90a60335a104538d2aaf40c3a8ca907
View file https://github.com/mrthankyou/codeql/blob/9e01338500b703adf3d9084b0e9d22623ef8643c/python/ql/test/experimental/library-tests/frameworks/sqlalchemy/taint_test.py
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/github/codeql/pull/5680/{{ revealButtonHref }}
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width

URLs of crawlers that visited me.