[Ngetsuite-cvs] ngetsuite resetdb.rb,NONE,1.1

[<jj...@us...>]

Update of /cvsroot/ngetsuite/ngetsuite
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv31139

Added Files:
	resetdb.rb 
Log Message:
downloader shutdown bugfix, misc bugfix


--- NEW FILE: resetdb.rb ---
#!/usr/bin/env ruby
conffile = ENV['HOME'] + File::Separator + '.ngetsuite'
require 'ngetsuite/config'
config = NgetSuite::Config.new(conffile)

require 'dbi'

sql = File.open('ngetcache.sql')
dbh = DBI.connect("DBI:Mysql:#{config['dbname']}", config['dbuser'], config['dbpass'])
cmd = ''
sql.each { |l|
	next if l =~ /^(#|\s*$)/
	if l=~/CREATE TABLE (`.*`)/
		puts "Resetting #{$1}"
		dbh.do "drop table if exists #{$1}"
	end
	cmd += l
	if l =~ /;/
		dbh.do cmd
		cmd = ''
	end
}	
dbh.disconnect if $dbh
sql.close
puts 'done'