[RELEASE] Texture Cache Maintenance utility
(2020-03-30, 01:08)Milhouse Wrote:
(2020-03-30, 00:46)sniferx1 Wrote: After running  /texturecache.py x "where lastusetime <= '2013-03-05'" , Do I need to run any other command to remove them from local cache DB?

Yes, see the example in the first post.

[Image: qLXTCcw.png]

The x[/line] command gives you a list of matching database row ids - you now need to feed those into [inline]texturecache.py d # # # # # (where each # is one of the matched row ids).

So in your case:

IDS=$(texturecache.py x "where lastusetime <= '2019-03-05'" 2>&1 1>/dev/null | sed "s/.*: //")
[ -n "$IDS" ] && texturecache.py d $IDS

should work on Unix/Linux (for Windows you'll need to figure it out for yourself). 

@Milhouse 

Thanks again... I ran this but getting below error... kindly help as I am not an Python expert...

[email protected]:~$ IDS=$(texturecache.py x "where lastusetime <= '2020-02-31'" 2>&1 1>/dev/null | sed "s/.*: //")[ -n "$IDS" ] && texturecache.py d $IDS
-bash: -n: command not found
Reply
 
Thread Rating:
  • 17 Vote(s) - 4.76 Average


Messages In This Thread
Crash on Gotham on OS X - by desepticon - 2014-05-29, 17:57
Cleaning - by AleisterHH - 2018-05-28, 22:03
RE: Cleaning - by Milhouse - 2018-05-28, 22:16
qax genre not updated - by Just-Me_A-User - 2018-06-12, 22:06
RE: qax genre not updated - by Milhouse - 2018-06-12, 23:40
RE: [RELEASE] Texture Cache Maintenance utility - by sniferx1 - 2020-03-30, 01:35


Logout Mark Read Team Forum Stats Members Help
[RELEASE] Texture Cache Maintenance utility4.7617
This forum uses Lukasz Tkacz MyBB addons.