Function TestLooksLikeSQL

cmd/gosqlx/cmd/integration_test.go:121–149

TestLooksLikeSQL tests the SQL heuristic detection

(t *testing.T)

// TestLooksLikeSQL tests the SQL heuristic detection
func TestLooksLikeSQL(t *testing.T) {
	testCases := []struct {
		name     string
		input    string
		expected bool
	}{
		{"SimpleSelect", "SELECT * FROM users", true},
		{"InsertStatement", "INSERT INTO table VALUES (1, 'test')", true},
		{"UpdateStatement", "UPDATE users SET name = 'John'", true},
		{"DeleteStatement", "DELETE FROM users WHERE id = 1", true},
		{"CreateStatement", "CREATE TABLE users (id INT)", true},
		{"WithCTE", "WITH cte AS (SELECT 1) SELECT * FROM cte", true},
		{"LowercaseSelect", "select id from users", true},
		{"SQLWithSemicolon", "some random text; but has semicolon", false},
		{"PlainText", "this is just plain text", false},
		{"Filename", "myfile.sql", false},
		{"Path", "/path/to/file", false},
		{"Empty", "", false},
	}

	for _, tc := range testCases {
		t.Run(tc.name, func(t *testing.T) {
			result := looksLikeSQL(tc.input)
			if result != tc.expected {
				t.Errorf("looksLikeSQL(%q) = %v, expected %v", tc.input, result, tc.expected)
			}
		})
	}
}

// TestExpandFileArgs tests the file expansion functionality
func TestExpandFileArgs(t *testing.T) {