generated to find out the show taking up the most space...
here's a bare sql query to show in text
select title,
sum(filesize)
from mythconverg.recorded
group by title
order by sum(filesize) desc ;
and my actual sage script:
import sys
##did not install MySQLdb into sage, only default location, so had to add
sys.path.append('/usr/lib/python2.7/site-packages/')
import MySQLdb
print "MythTV File sizes"
import _mysql
db=_mysql.connect(host="localhost",user="myuser",passwd="mypassword",
db="mythconverg")
db.query(""" select @rn:=@rn+1 rn, sum(filesize)/1024/1024 from (select @rn:=0)r, mythconverg.recorded group by title order by sum(filesize) desc""")
r=db.store_result()
scatter_plot(r.fetch_row(0))
