예제 #1
0
파일: maatkit.py 프로젝트: yodermk/holland
 def estimate_backup_size(self):
     # PITA
     # Look all all the filtering crap in Maatkit and try to get as close 
     # as possible to how Maatkit finds tables
     # options:
     # databases,ignoredb,dbregex
     # tables,ignoretbl,tblregex
     # ignoreengine
     databases = self.config.lookup('maatkit.databases')
     ignoredb = self.config.lookup('maatkit.ignoredb')
     dbregex = self.config.lookup('maatkit.dbregex')
     tables = self.config.lookup('maatkit.tables')
     ignoretbl = self.config.lookup('maatkit.ignoretbl')
     tblregex = self.config.lookup('maatkit.tblregex')
     ignoreengine = self.config.lookup('maatkit.ignoreengine')
     
     if self.dry_run:
         if 'password' in self.my_cnf['client']:
             password = self.my_cnf['client'].pop('password')
             self.my_cnf['client']['passwd'] = password
         mysqlclient = MySQLClient(**dict(self.my_cnf['client'].items()))
     else:
         mysqlclient = MySQLClient(read_default_file=self.my_cnf.path)
     estimated_size = 0
     for db in mysqlclient.show_databases():
         for info in mysqlclient.show_table_status(db):
             tbl = info['name']
             qtbl = db + '.' + tbl
             
             if databases and db not in databases:
                 continue
             if ignoredb and db in ignoredb:
                 continue
             if dbregex and not re.search(dbregex, db):
                 continue
             if tables and (tbl not in tables or qtbl not in tables):
                 continue
             if ignoretbl and (tbl in ignoretbl or qtbl in ignoretbl):
                 continue
             if tblregex and not re.search(tblregex, qtbl):
                 continue
             if ignoreengine and info['engine'] in ignoreengine:
                 continue
                 
             estimated_size += int(info['data_length'] or 0) + \
                                 int(info['index_length'] or 0)
     return estimated_size
예제 #2
0
import load_it
from holland.lib.mysql.client import MySQLClient

client = MySQLClient(read_default_group='client')
print client.encode_as_filename('foo/bar')
print client.encode_as_filename('foo.bar')