saetia · June 26, 2017 16:59 · Jun 26, 2017 · Oct 10, 2012 · Oct 10, 2012 · Oct 10, 2012
diff --git a/gistfile1.sh b/gistfile1.sh
@@ -1,3 +1,3 @@
-ruby -e "$(curl -fsSkL raw.github.com/gist/2369908/cd90a23b10d224284efe8dfdd5ccd3d3d328600c/parse.rb)" /Users/Joel/site.db.121010.dump
+ruby -e "$(curl -fsSkL https://gist.githubusercontent.com/saetia/2369908/raw/4bf9a6d36060582e69f02c314f66449971a7bb11/parse.rb)" /Users/Joel/site.db.121010.dump
 
 ruby parse.rb site.120411.dump
diff --git a/gistfile1.sh b/gistfile1.sh
@@ -1,3 +1,3 @@
-ruby -e "$(curl -fsSkL raw.github.com/gist/2369908/6fe8fdc1c20f97c431cb9326c6ccc78effb9bd7b/parse.rb)" /Users/Joel/site.db.121010.dump
+ruby -e "$(curl -fsSkL raw.github.com/gist/2369908/cd90a23b10d224284efe8dfdd5ccd3d3d328600c/parse.rb)" /Users/Joel/site.db.121010.dump
 
 ruby parse.rb site.120411.dump
diff --git a/parse.rb b/parse.rb
@@ -13,11 +13,11 @@
 	d = File.new(dumpfile, "r")
 	outfile = false
 	table = ""
-	directory = File.basename(dumpfile).gsub(/[^0-9a-z]/i, '')+'.tables'
+	directory = File.basename(dumpfile).gsub(/[^0-9a-z\.\_]/i, '')+'.tables'
 	Dir.mkdir(directory) unless File.directory?(directory)
 	while (line = d.gets)
 		if line =~ /^-- Table structure for table .(.+)./
-			table = $1.gsub(/[^0-9a-z]/i, '')
+			table = $1.gsub(/[^0-9a-z\.\_]/i, '')
 			puts("\033[32mfound\033[0m #{table}\n")
 			outfile = File.new("#{directory}/#{table}.sql", "w")
 		end

diff --git a/gistfile1.sh b/gistfile1.sh
@@ -1,3 +1,3 @@
-ruby -e "$(curl -fsSkL raw.github.com/gist/2369908/ee883b0eb427b43335ba31eb3fb9e59eaec7c2d2/parse.rb)" /Users/Joel/site.db.121010.dump
+ruby -e "$(curl -fsSkL raw.github.com/gist/2369908/6fe8fdc1c20f97c431cb9326c6ccc78effb9bd7b/parse.rb)" /Users/Joel/site.db.121010.dump
 
 ruby parse.rb site.120411.dump
diff --git a/parse.rb b/parse.rb
@@ -17,9 +17,7 @@
 	Dir.mkdir(directory) unless File.directory?(directory)
 	while (line = d.gets)
 		if line =~ /^-- Table structure for table .(.+)./
-			table = $1
-                        table.gsub(/[^0-9a-z]/i, '')!
-
+			table = $1.gsub(/[^0-9a-z]/i, '')
 			puts("\033[32mfound\033[0m #{table}\n")
 			outfile = File.new("#{directory}/#{table}.sql", "w")
 		end

diff --git a/parse.rb b/parse.rb
@@ -17,7 +17,8 @@
 	Dir.mkdir(directory) unless File.directory?(directory)
 	while (line = d.gets)
 		if line =~ /^-- Table structure for table .(.+)./
-			table = $1.gsub(/[^0-9a-z]/i, '')!
+			table = $1
+                        table.gsub(/[^0-9a-z]/i, '')!
 
 			puts("\033[32mfound\033[0m #{table}\n")
 			outfile = File.new("#{directory}/#{table}.sql", "w")

diff --git a/parse.rb b/parse.rb
@@ -17,7 +17,8 @@
 	Dir.mkdir(directory) unless File.directory?(directory)
 	while (line = d.gets)
 		if line =~ /^-- Table structure for table .(.+)./
-			table = $1.gsub(/[^0-9a-z]/i, '')
+			table = $1.gsub(/[^0-9a-z]/i, '')!
+
 			puts("\033[32mfound\033[0m #{table}\n")
 			outfile = File.new("#{directory}/#{table}.sql", "w")
 		end

diff --git a/parse.rb b/parse.rb
@@ -17,7 +17,7 @@
 	Dir.mkdir(directory) unless File.directory?(directory)
 	while (line = d.gets)
 		if line =~ /^-- Table structure for table .(.+)./
-			table = $1
+			table = $1.gsub(/[^0-9a-z]/i, '')
 			puts("\033[32mfound\033[0m #{table}\n")
 			outfile = File.new("#{directory}/#{table}.sql", "w")
 		end

diff --git a/parse.rb b/parse.rb
@@ -13,7 +13,7 @@
 	d = File.new(dumpfile, "r")
 	outfile = false
 	table = ""
-	directory = File.basename(dumpfile).gsub(/[^0-9a-z ]/i, '')+'.tables'
+	directory = File.basename(dumpfile).gsub(/[^0-9a-z]/i, '')+'.tables'
 	Dir.mkdir(directory) unless File.directory?(directory)
 	while (line = d.gets)
 		if line =~ /^-- Table structure for table .(.+)./

diff --git a/parse.rb b/parse.rb
@@ -13,7 +13,7 @@
 	d = File.new(dumpfile, "r")
 	outfile = false
 	table = ""
-	directory = File.basename(dumpfile)+'.tables'
+	directory = File.basename(dumpfile).gsub(/[^0-9a-z ]/i, '')+'.tables'
 	Dir.mkdir(directory) unless File.directory?(directory)
 	while (line = d.gets)
 		if line =~ /^-- Table structure for table .(.+)./

diff --git a/extract_tables.pl b/extract_tables.pl
@@ -1,32 +0,0 @@
-#!/usr/bin/perl -w
-use strict;
-
-my $dump_file = shift @ARGV;
-my $out_dump_file = 'stripped_dump.sql';
-
-open DUMP, "<$dump_file" or die $!;
-open OUT, ">$out_dump_file" or die $!;
-
-my @required_tables = @ARGV;
-
-my $table_dump_started = 0;
-while (<DUMP>){
-
-	if (index($_, 'CREATE TABLE') >= 0){
-
-		$table_dump_started = 0;
-		foreach my $table (@required_tables){
-
-			if (index($_, "`$table`") >= 0){
-				$table_dump_started = 1;
-				last;
-
-			}
-		}
-	}
-	print OUT
-		if $table_dump_started;
-}
-
-close OUT;
-close DUMP;

diff --git a/gistfile1.sh b/gistfile1.sh
@@ -1 +1,3 @@
-ruby parse.rb metropoliscoffee.db.120411.dump
+ruby -e "$(curl -fsSkL raw.github.com/gist/2369908/ee883b0eb427b43335ba31eb3fb9e59eaec7c2d2/parse.rb)" /Users/Joel/site.db.121010.dump
+
+ruby parse.rb site.120411.dump
diff --git a/extract_tables.pl b/extract_tables.pl
@@ -0,0 +1,32 @@
+#!/usr/bin/perl -w
+use strict;
+
+my $dump_file = shift @ARGV;
+my $out_dump_file = 'stripped_dump.sql';
+
+open DUMP, "<$dump_file" or die $!;
+open OUT, ">$out_dump_file" or die $!;
+
+my @required_tables = @ARGV;
+
+my $table_dump_started = 0;
+while (<DUMP>){
+
+	if (index($_, 'CREATE TABLE') >= 0){
+
+		$table_dump_started = 0;
+		foreach my $table (@required_tables){
+
+			if (index($_, "`$table`") >= 0){
+				$table_dump_started = 1;
+				last;
+
+			}
+		}
+	}
+	print OUT
+		if $table_dump_started;
+}
+
+close OUT;
+close DUMP;
diff --git a/parse.rb b/parse.rb
@@ -13,11 +13,13 @@
 	d = File.new(dumpfile, "r")
 	outfile = false
 	table = ""
+	directory = File.basename(dumpfile)+'.tables'
+	Dir.mkdir(directory) unless File.directory?(directory)
 	while (line = d.gets)
 		if line =~ /^-- Table structure for table .(.+)./
 			table = $1
 			puts("\033[32mfound\033[0m #{table}\n")
-			outfile = File.new("#{table}.sql", "w")
+			outfile = File.new("#{directory}/#{table}.sql", "w")
 		end
 		if table != "" && outfile
 			outfile.syswrite line

diff --git a/gistfile1.sh b/gistfile1.sh
@@ -0,0 +1 @@
+ruby parse.rb metropoliscoffee.db.120411.dump
diff --git a/parse.rb b/parse.rb
@@ -0,0 +1,26 @@
+#!/usr/bin/ruby
+
+if ARGV.length == 1
+	dumpfile = ARGV.shift
+else
+	puts("\033[31mhow to:\033[0m ruby parse.rb mysql.dump\n")
+	exit 1
+end
+
+STDOUT.sync = true
+
+if File.exist?(dumpfile)
+	d = File.new(dumpfile, "r")
+	outfile = false
+	table = ""
+	while (line = d.gets)
+		if line =~ /^-- Table structure for table .(.+)./
+			table = $1
+			puts("\033[32mfound\033[0m #{table}\n")
+			outfile = File.new("#{table}.sql", "w")
+		end
+		if table != "" && outfile
+			outfile.syswrite line
+		end
+	end
+end