Использование Linq в PowerShell

$t1 = Import-Csv .\table_1.csv
$t2 = Import-Csv .\table_2.csv
 
$r = $t1 | Where-Object { $t2.league_guid -NotContains $_.league_guid }
 
'{0} - {1} = {2}' -f $t1.Count, $t2.Count, ($t1.Count - $t2.Count)
'records left: {0}' -f $r.Count

$array = [Linq.Enumerable]::ToArray($compare)

$m = Measure-Command {
    $coll1 = Import-Csv C:\tmp\001\table_1.csv
    $coll2 = Import-Csv C:\tmp\001\table_2.csv
    $coll3 = (Compare-Object $coll1 $coll2 | Where-Object SideIndicator -eq "<=").InputObject
    write-host $coll3.Count
}
 
$m.Microseconds

$t1 = Import-Csv .\table_1.csv
$t2 = Import-Csv .\table_2.csv
 
class ComparerCustomObject : System.Collections.Generic.IEqualityComparer[pscustomobject] {
    [bool] Equals([pscustomobject] $o1, [pscustomobject] $o2) {
        return $o1.league_guid -eq $o2.league_guid
    }
 
    [int] GetHashCode([pscustomobject] $obj) {
        if ($null -eq $obj) { return 0 } else { return $obj.league_guid.GetHashCode() }
    }
}
 
$compare = [linq.enumerable]::Except(
    [System.Collections.Generic.List[pscustomobject]] $t1,
    [System.Collections.Generic.List[pscustomobject]] $t2,
    [ComparerCustomObject]::new()
)
 
$array = [linq.enumerable]::ToArray($compare)
$array.Count

$coll1 = Import-Csv .\table_1.csv
$coll2 = Import-Csv .\table_2.csv
 
$coll3 = @()
 
$m = Measure-Command {
 
    :out
    for ($i = 0; $i -lt $coll1.Count; $i++) {
        for ($j = 0; $j -lt $coll2.Count; $j++) {
            if (
                $coll1[$i].league_guid -eq $coll2[$j].league_guid
            ) {
                continue out
            }
        }
        $coll3 += $coll1[$i]
    }
}
 
"Count       : {0}" -f $coll3.Count
"Microseconds: {0}" -f $m.Microseconds

$t1 = Import-Csv .\table_1.csv
$t2 = Import-Csv .\table_2.csv
 
class ComparerCustomObject : System.Collections.Generic.IEqualityComparer[pscustomobject] {
    [bool] Equals([pscustomobject] $o1, [pscustomobject] $o2) {
        return $o1.league_guid -eq $o2.league_guid
    }
 
    [int] GetHashCode([pscustomobject] $obj) {
        if ($null -eq $obj) { return 0 } else { return $obj.league_guid.GetHashCode() }
    }
}
 
$m = Measure-Command {
$compare = [linq.enumerable]::Except(
    [System.Collections.Generic.List[pscustomobject]] $t1,
    [System.Collections.Generic.List[pscustomobject]] $t2,
    [ComparerCustomObject]::new()
)
 
$array = [linq.enumerable]::ToArray($compare)
 
}
 
"Count       : {0}" -f $array.Count
"Microseconds: {0}" -f $m.Microseconds

$t1 = Import-Csv .\table_1.csv
$t2 = Import-Csv .\table_2.csv
 
class ComparerCustomObject : System.Collections.Generic.IEqualityComparer[pscustomobject] {
    [bool] Equals([pscustomobject] $o1, [pscustomobject] $o2) {
        return $o1.league_guid -eq $o2.league_guid
    }
 
    [int] GetHashCode([pscustomobject] $obj) {
        if ($null -eq $obj) { return 0 } else { return $obj.league_guid.GetHashCode() }
    }
}
 
$m = Measure-Command {
$compare = [linq.enumerable]::Except(
    [System.Collections.Generic.List[pscustomobject]] $t1,
    [System.Collections.Generic.List[pscustomobject]] $t2,
    [ComparerCustomObject]::new()
)
 
$array = [linq.enumerable]::ToArray($compare)
 
}
 
"Count       : {0}" -f $array.Count
"Microseconds: {0}" -f $m.TotalMicroseconds

$list1 = [Collections.ArrayList]::new()
 
1..6000 |% {$rnd=[random]::new()} {[void]$list1.add([pscustomobject]@{id=$rnd.next(1,2000000000);name="test$_";age=$rnd.next(1,100)})}
 
$list2 = $list1.clone(); [void]$list1.Add([pscustomobject]@{id=0;name="testSUPER";age=999})
 
measure-command {
 
$list1|Export-Csv -Path __list1.csv
$list2|Export-Csv -Path __list2.csv
 
@"
.sep ","
.import __list1.csv list1
.import __list2.csv list2
.headers on
.mode csv
.output __result.csv
select * from list1 except select * from list2;
"@ | sqlite3 :memory:
 
$result = import-csv __result.csv
}
 
$result