Skip to main content

Remove SQL Comments

Remove SQL comments in SQL scripts

I often want to provide SQL structure dumps as context for AI assisted development. But most of the dumps tools provide SQL scripts with comments. I do not want to provide them to the AI. So, I need to strip the comments. This is the file I use:
 
#!/bin/bash

# 1. Check if an input file was provided
if [ "$#" -lt 1 ]; then
    echo "Usage: $0  [output_file.sql]"
    exit 1
fi

INPUT_FILE="$1"
OUTPUT_FILE="${2:-cleaned_$1}"

# 2. Check if input file exists
if [ ! -f "$INPUT_FILE" ]; then
    echo "Error: File '$INPUT_FILE' not found!"
    exit 1
fi

# 3. Create secure temporary files for the intermediate passes
PASS1_FILE=$(mktemp)
PASS2_FILE=$(mktemp)

# Set a trap to automatically delete the temporary files when the script finishes or is aborted
trap 'rm -f "$PASS1_FILE" "$PASS2_FILE"' EXIT

echo "Starting multi-pass SQL cleanup on '$INPUT_FILE'..."

# ==============================================================================
# PASS 1: Remove Standard Comments
# ==============================================================================
echo " -> Pass 1: Removing standard '--' comments..."
# Looks for lines starting with '--' (ignoring leading spaces) and deletes them.
sed '/^[[:space:]]*--/d' "$INPUT_FILE" > "$PASS1_FILE"

# ==============================================================================
# PASS 2: Remove Conditional Execution Comments
# ==============================================================================
echo " -> Pass 2: Removing conditional '/*! ... */' comments..."
# Looks for lines starting with '/*' (ignoring leading spaces) and deletes them.
sed '/^[[:space:]]*\/\*/d' "$PASS1_FILE" > "$PASS2_FILE"

# ==============================================================================
# PASS 3: Clean Up Empty Lines
# ==============================================================================
echo " -> Pass 3: Removing blank lines left behind..."
# Looks for lines that are entirely empty or contain only whitespace and deletes them.
sed '/^[[:space:]]*$/d' "$PASS2_FILE" > "$OUTPUT_FILE"

# ==============================================================================
# FINISH
# ==============================================================================
echo "Done! Cleaned SQL saved to: $OUTPUT_FILE"

Popular posts from this blog

Undefined global vim

Defining vim as global outside of Neovim When developing plugins for Neovim, particularly in Lua, developers often encounter the "Undefined global vim" warning. This warning can be a nuisance and disrupt the development workflow. However, there is a straightforward solution to this problem by configuring the Lua Language Server Protocol (LSP) to recognize 'vim' as a global variable. Getting "Undefined global vim" warning when developing Neovim plugin While developing Neovim plugins using Lua, the Lua language server might not recognize the 'vim' namespace by default. This leads to warnings about 'vim' being an undefined global variable. These warnings are not just annoying but can also clutter the development environment with unnecessary alerts, potentially hiding other important warnings or errors. Defining vim as global in Lua LSP configuration to get rid of the warning To resolve the "Undefined global vi...
Read more

CopilotChat GlobFile Configuration

CopilotChat GlobFile Configuration Want to feed multiple files into GitHub Copilot Chat from Neovim without listing each one manually? Let's add a tiny feature that does exactly that: a file glob that includes full file contents . In this post, we'll walk through what CopilotChat.nvim offers out of the box, why the missing piece matters, and how to implement a custom #file_glob:<pattern> function to include the contents of all files matching a glob. Using Copilot Chat with Neovim CopilotChat.nvim brings GitHub Copilot's chat right into your editing flow. No context switching, no browser hopping — just type your prompt in a Neovim buffer and let the AI help you refactor code, write tests, or explain tricky functions. You can open the chat (for example) with a command like :CopilotChat , then provide extra context using built-in functions. That “extra context” is where the magic really happens. Built-in functio...
Read more

npm run build base-href

Using NPM to specify base-href When building an Angular application, people usually use "ng" and pass arguments to that invocation. Typically, when wanting to hard code "base-href" in "index.html", one will issue: ng build --base-href='https://ngx.rktmb.org/foo' I used to build my angular apps through Bamboo or Jenkins and they have a "npm" plugin. I got the habit to build the application with "npm run build" before deploying it. But the development team once asked me to set the "--base-href='https://ngx.rktmb.org/foo'" parameter. npm run build --base-href='https://ngx.rktmb.org/foo did not set the base href in indext.html After looking for a while, I found https://github.com/angular/angular-cli/issues/13560 where it says: You need to use −− to pass arguments to npm scripts. This did the job! The command to issue is then: npm run build -- --base-href='https://ngx.rktmb.org/foo...
Read more