DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Evgeniy has posted 3 posts at DZone. View Full User Profile

Extract Tables From Mysqldump File Using Enumerable#slice_before

03.10.2010
| 2473 views |
  • submit to reddit
        More info in my blog post <a href="http://dolzhenko.org/blog/?p=85">Exploring Latest ruby-lib Additions</a>

if ARGV.size < 1
  puts "Use like mysqldump database_name | ./#{ $PROGRAM_NAME } table_name[s]"
  exit(0)
end

# Dump for each table in standard mysqldump output is started with the line like:
#
#     -- Table structure for table `access_rights`
#
# Use +Enumerable#slice_before+ to slice the whole dump into sections per table
# and then select only sections for the tables we are interested in.

# Create regexp which will match any of the passed table names quoted with backticks
quoted_table_names = /`#{ ARGV.join("|") }`/

table_dump = STDIN.slice_before(/\A-- Table structure for table/).select do |table_section|
  table_section.first =~ quoted_table_names 
end.join

print(table_dump)