[Windows][Script] purger les images absentes

Code :
Add-Type -Path 'C:\Program Files\System.Data.SQLite\2015\bin\System.Data.SQLite.dll'

$con = New-Object -TypeName System.Data.SQLite.SQLiteConnection

$bddPath = "$($env:LOCALAPPDATA)\darktable\library.db"

Copy-Item -LiteralPath $bddPath -Destination "$($env:LOCALAPPDATA)\darktable\library.db.backForClean"

$con.ConnectionString = "Data Source=$($bddPath)"

$con.Open()

$sql = $con.CreateCommand()

$sql.CommandText = "SELECT Id,folder FROM film_rolls WHERE 1 ORDER BY id ASC;"

$adapter = New-Object -TypeName System.Data.SQLite.SQLiteDataAdapter $sql

$data = New-Object System.Data.DataSet

[void]$adapter.Fill($data)

Foreach($element in $data.tables.rows)

{

    $sql.CommandText = "SELECT id,filename FROM images WHERE film_id=$($element.Id) ORDER BY filename ASC;"

    $adapter = New-Object -TypeName System.Data.SQLite.SQLiteDataAdapter $sql

    $dataImages = New-Object System.Data.DataSet

    [void]$adapter.Fill($dataImages)

    Foreach($image in $dataImages.tables.rows)

    {

        [bool]$exists = Test-Path -LiteralPath "$($element.folder)\$($image.filename)"

        if(-Not $exists)

        {

            "$($element.folder)\$($image.filename)"

            $sql.CommandText = "DELETE FROM images WHERE id=$($image.id);"

            $sql.ExecuteNonQuery()

        }

    }

}

$sql.Dispose()

$con.Close()