New implementation:

Lines 1134 to 1165 in d118d5c

    
           _single_line_comment_re = re.compile(r"--.*") 
        
           _multi_line_comment_re = re.compile(r"/\*.*?\*/", re.DOTALL) 
        
           _single_quote_re = re.compile(r"'(?:''|[^'])*'") 
        
           _double_quote_re = re.compile(r'"(?:\"\"|[^"])*"') 
        
           _named_param_re = re.compile(r":(\w+)") 
        
           @documented 
        
           def named_parameters(sql: str) -> List[str]: 
        
               """ 
        
               Given a SQL statement, return a list of named parameters that are used in the statement 
        
               e.g. for ``select * from foo where id=:id`` this would return ``["id"]`` 
        
               """ 
        
               # Remove single-line comments 
        
               sql = _single_line_comment_re.sub("", sql) 
        
               # Remove multi-line comments 
        
               sql = _multi_line_comment_re.sub("", sql) 
        
               # Remove single-quoted strings 
        
               sql = _single_quote_re.sub("", sql) 
        
               # Remove double-quoted strings 
        
               sql = _double_quote_re.sub("", sql) 
        
               # Extract parameters from what is left 
        
               return _named_param_re.findall(sql) 
        
           async def derive_named_parameters(db: "Database", sql: str) -> List[str]: 
        
               """ 
        
               This undocumented but stable method exists for backwards compatibility 
        
               with plugins that were using it before it switched to named_parameters() 
        
               """ 
        
               return named_parameters(sql)

	_single_line_comment_re = re.compile(r"--.*")
	_multi_line_comment_re = re.compile(r"/\.?\*/", re.DOTALL)
	_single_quote_re = re.compile(r"'(?:''\|[^'])*'")
	_double_quote_re = re.compile(r'"(?:\"\"\|[^"])*"')
	_named_param_re = re.compile(r":(\w+)")


	@documented
	def named_parameters(sql: str) -> List[str]:
	"""
	Given a SQL statement, return a list of named parameters that are used in the statement

	e.g. for ``select * from foo where id=:id`` this would return ``["id"]``
	"""
	# Remove single-line comments
	sql = _single_line_comment_re.sub("", sql)
	# Remove multi-line comments
	sql = _multi_line_comment_re.sub("", sql)
	# Remove single-quoted strings
	sql = _single_quote_re.sub("", sql)
	# Remove double-quoted strings
	sql = _double_quote_re.sub("", sql)
	# Extract parameters from what is left
	return _named_param_re.findall(sql)


	async def derive_named_parameters(db: "Database", sql: str) -> List[str]:
	"""
	This undocumented but stable method exists for backwards compatibility
	with plugins that were using it before it switched to named_parameters()
	"""
	return named_parameters(sql)

Uh oh!

derive_named_parameters() method that works with latest SQLite #2354

Description

Metadata

Metadata

Assignees

Labels

Projects

Milestone

Relationships

Development

Issue actions