check unused SQLDelight queries

check_unused_queries.py

import re

# Define the file paths
sql_file_path = ""
kotlin_file_path = ""

# Read the SQLDelight file
with open(sql_file_path, 'r') as file:
    sql_file_content = file.read()

# Extract the SQL query names
sql_query_names = re.findall(r'([a-zA-Z0-9_]+):', sql_file_content)

# Read the Kotlin file
with open(kotlin_file_path, 'r') as file:
    kotlin_file_content = file.read()

# Check if each SQL query name is present in the Kotlin file
for query_name in sql_query_names:
    if query_name not in kotlin_file_content:
        print(f"The query '{query_name}' is not used in the Kotlin file.")