Skip to content

Instantly share code, notes, and snippets.

@drakmail
Created January 4, 2012 14:05
Show Gist options
  • Save drakmail/1560195 to your computer and use it in GitHub Desktop.
Save drakmail/1560195 to your computer and use it in GitHub Desktop.
#!/usr/bin/python
# VRMS for AgiliaLinux
import sqlite3
db = sqlite3.connect('/var/mpkg/packages.db')
tag = db.execute("SELECT * FROM tags WHERE tags_name='proprietary'")
tagid = list(tag)[0][0]
links = db.execute("SELECT * FROM tags_links WHERE tags_tag_id='{0}'".format(tagid))
total = list(db.execute("SELECT Count(*) FROM packages WHERE package_installed='1'"))[0][0]
prop = []
for item in links:
package = db.execute("SELECT * FROM packages WHERE package_id='{0}' AND package_installed='1'".format(item[1]))
l = list(package)
if len(l) > 0:
prop.append(l[0])
db.close()
if prop:
propn = len(prop)
print "Non-free packages installed:"
for item in prop:
print '{0}: {1}'.format(item[1], item[8] if item[8] else item[7])
print "{0} proprietary packages of {1} total packages, which is {2:.10%}".format(propn, total, propn/float(total))
else:
print "You make RMS proud!"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment