package storage import ( "fmt" "strings" ) type MSSQLAdapter struct{} func (m MSSQLAdapter) ConvertGenericPlaceholders( query string, argsCount int, ) string { for i := 0; i <= argsCount; i++ { placeholder := m.createPlaceholder(i + 1) query = strings.Replace(query, "?", placeholder, 1) } return query } func (m MSSQLAdapter) createPlaceholder(index int) string { return fmt.Sprintf("@p%d", index) } func (m MSSQLAdapter) TableExists( executor sqlExecutor, tableName string, ) (bool, error) { var exists bool schemaName := "dbo" parts := strings.Split(tableName, ".") if len(parts) == 2 { schemaName = parts[0] tableName = parts[1] } else { tableName = parts[0] } err := executor.QueryRow(` SELECT CASE WHEN EXISTS ( SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = @p1 AND TABLE_NAME = @p2 ) THEN 1 ELSE 0 END `, schemaName, tableName).Scan(&exists) if err != nil { return false, fmt.Errorf( "unable to check if %s exists: %w", tableName, err, ) } return exists, nil } func (m MSSQLAdapter) DatabaseName(executor sqlExecutor) (string, error) { var name string err := executor.QueryRow("SELECT DB_NAME();").Scan(&name) if err != nil { return "", fmt.Errorf("unable to retrieve database name: %w", err) } return name, nil }