synapsecns/sanguine

package dbcommon_test

import (
    "github.com/synapsecns/sanguine/core/dbcommon"
    "testing"
)

func TestMysqlRealEscapeString(t *testing.T) {
    // ' to \\'
    // " to \\"
    // \r to \\r
    // \n to \\n
    // \\ to \\\\
    // \x00 (null byte) to \\x00
    // \x1a (substitute character) to \\Z
    tests := []struct {
        input  string
        expect string
    }{
        {"hello", "hello"},
        {"he'llo", "he\\'llo"},
        {"he\"llo", "he\\\"llo"},
        {"he\nllo", "he\\\nllo"},
        {"he\rllo", "he\\\rllo"},
        {"hello\\world", "hello\\\\world"},
        {"he\x00llo", "he\\\x00llo"},
        {"he\x1allo", "he\\Zllo"},
    }

    for _, tt := range tests {
        result := dbcommon.MysqlRealEscapeString(tt.input)
        if result != tt.expect {
            t.Errorf("For input '%s', expected '%s' but got '%s'", tt.input, tt.expect, result)
        }
    }
}