Regular Expressions 101

Sponsors
digidib · when security, quality, and reliability matter

Community Patterns

1

exe sql select

Created·2025-05-28 15:28
Flavor·Python
EXEC\s+SQL\s(?:[\r\n]\s\s)*SELECT
Submitted by Tony
1

SQLALCHEMY_DATABASE_URI parser

Created·2015-11-13 20:04
Flavor·Python
Parse SQLALCHEMY_DATABASE_URI
Submitted by jdnier
1

t-sql batch script parser

Created·2014-12-24 06:46
Flavor·Python
Splits t-sql script into separated commands. useful for executing with adocommand object
Submitted by kutsoff
1

ConnectionStringServerDatabase

Created·2016-03-07 00:33
Flavor·Python
Extract the server and database name from SQL Server connection string
Submitted by Davos
1

Capture Comments on SQL followed by SELECT

Created·2016-09-01 14:07
Flavor·Python
Shag Maister is the best
Submitted by anonymous
1

Simple RegEx for SQL Field transformation

Created·2015-10-14 15:01
Flavor·Python
no description available
Submitted by sX
0

flake8-sql False Positives

Created·2022-07-08 14:00
Updated·2022-07-08 14:07
Flavor·Python
An example false positive matching docstring for the regex used by flake8-sql (https://github.com/pgjones/flake8-sql).
Submitted by anonymous
0

gen unique sql

Created·2019-08-26 06:43
Flavor·Python
no description available
Submitted by anonymous
0

Some sql beauty

Created·2018-09-05 13:10
Flavor·Python
no description available
Submitted by anonymous

Community Library Entry

1

Regular Expression
Created·2016-03-07 00:33
Flavor·Python

r"
Data Source\s*=\s*|Server=tcp:(.*?),|;
"
Open regex in editor

Description

Extract the server and database name from SQL Server connection string

Submitted by Davos