diff options
author | Jens Georg <mail@jensge.org> | 2019-08-18 13:58:27 +0200 |
---|---|---|
committer | Jens Georg <mail@jensge.org> | 2019-08-18 13:58:27 +0200 |
commit | cdf81f91aa7b0031580cc768ba4430c274204887 (patch) | |
tree | 19460e7ab360c412f974d04c5f3f8ad9243f70c6 | |
parent | acf52cdae2b973809b25c93e14a0a470883f3d30 (diff) | |
download | rygel-cdf81f91aa7b0031580cc768ba4430c274204887.tar.gz |
examples: have mx-info show blacklist
-rwxr-xr-x | examples/mx-info | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/examples/mx-info b/examples/mx-info index 8f31f524..99fe664b 100755 --- a/examples/mx-info +++ b/examples/mx-info @@ -66,6 +66,7 @@ SELECT b.timestamp FROM blacklist b WHERE b.uri = :uri """ BLACKLIST_TEMPLATE = 'File %(uri)s was blacklisted on %(date)s' +SHOW_BLACKLIST_QUERY = 'SELECT timestamp, uri FROM blacklist' UNBLACKLIST_QUERY = 'DELETE FROM blacklist where uri = :uri' def ensure_uri(string): @@ -79,6 +80,9 @@ parser.add_argument ('uris', metavar='URI', nargs = '+', type = ensure_uri, parser.add_argument ('-u, --unblacklist', action = 'store_true', dest = 'unblacklist', help = 'Remove uris from database\'s blacklist') +parser.add_argument ('--show-blacklist', action = 'store_true', + dest = 'show_blacklist', + help = 'Show contents of the blacklist') args = parser.parse_args () rygel_db = os.path.join (BaseDirectory.xdg_cache_home, "rygel", "media-export.db") @@ -93,10 +97,18 @@ if int(info[0]) < 16: has_blacklist = int(info[0]) >= 17 -if not has_blacklist and args.unblacklist: +if not has_blacklist and (args.unblacklist or args.show_blacklist): print ('Database version is too old for blacklists, cannot unblacklist') sys.exit (1) +if has_blacklist and args.show_blacklist: + c.execute (SHOW_BLACKLIST_QUERY) + for row in c: + t = time.gmtime(row[0]) + print (BLACKLIST_TEMPLATE % { "uri" : row[1], + "date" : time.strftime("%a, %d %b %Y %H:%M:%S +0000", t)}) + sys.exit(0) + if has_blacklist and args.unblacklist: for uri in args.uris: c.execute (UNBLACKLIST_QUERY, { 'uri' : uri }) |