7 srvs = ['kitchen-sink', 'sliced-bread']
10 cxns[s] = sql.connect(s, read_default_file='~/.my.cnf', cursorclass=sql.cursors.DictCursor)
11 curs[s] = cxns[s].cursor()
15 curs[s].execute('SHOW DATABASES')
16 dbs[s] = map(lambda elt: elt.values()[0], curs[s].fetchall())
17 if 'information_schema' in dbs[s]:
18 dbs[s].remove('information_schema')
21 for s in dbs.values():
26 from pprint import pprint
36 curs[s].execute('SHOW TABLE STATUS FROM `%s`' % db)
37 r = curs[s].fetchall()
39 if x['Engine'] != 'MyISAM':
41 tables.append(x['Name'])
42 stat[s][x['Name']] = x
44 keys = list(set(keys))
45 tables = list(set(tables))
50 if k in ['Check_time', 'Comment', 'Create_time', 'Update_time']:
56 vals[s] = stat[s][t].get(k, None)
57 v = list(set(vals.values()))
59 print '%s.%s[%s]: %s' % (db, t, k, str(vals))
61 print '%s.%s VERIFY' % (db, t), verified