Class: Flydata::Parser::Mysql::DatabaseSizeCheck
- Inherits:
-
Object
- Object
- Flydata::Parser::Mysql::DatabaseSizeCheck
- Includes:
- MysqlAccessible
- Defined in:
- lib/flydata/parser/mysql/dump_parser.rb
Constant Summary collapse
- SIZE_CHECK_QUERY =
<<EOT SELECT SUM(data_length) bytesize FROM information_schema.tables WHERE table_schema NOT IN ('information_schema','performance_schema','mysql') AND table_name in (%s); EOT
Instance Method Summary collapse
- #get_db_bytesize ⇒ Object
-
#initialize(de_conf) ⇒ DatabaseSizeCheck
constructor
A new instance of DatabaseSizeCheck.
Methods included from MysqlAccessible
Constructor Details
#initialize(de_conf) ⇒ DatabaseSizeCheck
Returns a new instance of DatabaseSizeCheck.
597 598 599 600 601 |
# File 'lib/flydata/parser/mysql/dump_parser.rb', line 597 def initialize(de_conf) @de_conf = de_conf @tables = de_conf['tables'].split(',') @query = SIZE_CHECK_QUERY % [@tables.collect{|t| "'#{t}'"}.join(',')] end |
Instance Method Details
#get_db_bytesize ⇒ Object
603 604 605 606 607 608 609 |
# File 'lib/flydata/parser/mysql/dump_parser.rb', line 603 def get_db_bytesize client = mysql_cli(@de_conf) result = client.query(@query) return result.first['bytesize'].to_i ensure client.close rescue nil end |