import MySQLdb

conn = MySQLdb.connect(db="test", user="rnd", passwd="secretpass")
cur = conn.cursor()

cur.execute("""SELECT COUNT(name) FROM modules;""")
print "Количество модулей:", cur.fetchall()[ 0 ][ 0 ]

cur.execute(
"""SELECT COUNT(*) FROM modules WHERE lines_of_code > 1000;""")
print "Количество очень больших модулей:", cur.fetchall()[ 0 ][ 0 ]

cur.execute(
"""SELECT name, lines_of_code, size FROM modules
    WHERE lines_of_code > 1000;""")
print "Список очень больших модулей:"
for record in cur.fetchall():
  print "%-10s : %10s : %10s" % record

cur.close(); conn.close()