mysql test generator
Posted by Anonymous on Mon 21st Jul 2025 18:49
raw | new post
view followups (newest first): mysql test generator by Anonymous

# mysql test generator
integer line_num=0

cat <<EOF
DROP DATABASE alphabet_test4;
CREATE DATABASE alphabet_test4;
USE alphabet_test4;

CREATE TABLE file_data (
    line_number INT PRIMARY KEY,
    line_text TEXT
);
EOF

while IFS= read -r line ; do
    (( line_num++ ))
    # Escape single quotes in the line to prevent SQL injection issues
    # This is a basic escape, for more complex data, consider prepared statements
    escaped_line="${line//\'/\'\'}"

    # Insert the line number and text into the table
    printf $'INSERT INTO file_data (line_number, line_text) VALUES (%d, \'%s\');\n' line_num "$escaped_line"
done

print -u2 '#Done;\n#Verify with SELECT * FROM file_data ORDER BY line_number;\n'
# EOF.