Wallpaper Database - reset it?

Scripting Forums AppleScript | Mac OS X
#1

This is a difficult one… As some of you may know I’ve written a wallpaper changer using Apple Shortcuts on the Mac.

It works very well and I’m very pleased with it.

However I’ve run into a macOS issue with it which is caused by the Apple Set Wallpaper shortcut command.

What happens is that when a wallpaper is set it is added to an ‘Wallpaper Desktop Library’’ and the file itself saved in ‘/Users/myuser/Pictures/Shortcuts Desktop Pictures/’

Now I triggered my wallpaper changer every 10 minutes… So that directory contains 26,234 files, taking up over 35Gb of file space.
The macOS Settings app also tries to show them all in the ‘Your Photos’ section of the control.
If you delete those files manually is screws up the ‘Wallpaper Desktop Library’ and it sets a default wallpaper to the desktop and the desktop Wallpaper system breaks.
So the question is, is there a way to prune the photos and update that database even better a way of resetting it?
I’ve searched the web and that references deleting plist files etc. None of those solutions are current for macOS Tahoe.
Any assistance would be appreciated.

#2

I’ve had this suggested:

tell application "System Events"
    repeat with d in desktops
        -- Use a built-in wallpaper path; this one exists on every macOS install
        set picture of d to "/Library/Desktop Pictures/Solid Colors/Stone.png"
    end repeat
end tell

No ideas if itd fix it or make it worse though?