How to replace file's content directly?

I have a sql file exported from mysql,and want to chang the charecter
set to utf-8.

sqltempfile=File.new(sqltemp,‘w+’) ### How to get rid of it?
File.open(sqlfile,‘r+’) do |file|
lines=file.gets(nil)
lines.gsub!(/TYPE=MyISAM/){|match| match=‘DEFAULT CHARACTER SET
utf8’}
sqltempfile.puts lines ### How to get rid of it?
end
sqltempfile.close ### How to get rid of it?

And the question is,how to replace the string directly without
sqltempfile?
Anyone help me?

On 16.10.2006 12:49, camenix wrote:

sqltempfile.close ### How to get rid of it?

And the question is,how to replace the string directly without
sqltempfile?
Anyone help me?

ruby -i -p -e ‘gsub! /TYPE=MyISAM/, “DEFAULT CHARACTER SET utf8”’
your_file

If you want backups, you can use “-i.bak” instead of “-i”.

robert

perlish script.Ugly,but worked.
In windows/dos , I have to use “-i.bak” instead of “-i”.
thanks.

I appreciate your help.

camenix [email protected] wrote:

end
sqltempfile.close ### How to get rid of it?

And the question is,how to replace the string directly without
sqltempfile?
Anyone help me?

ruby -i -p -e ‘gsub! /TYPE=MyISAM/, “DEFAULT CHARACTER SET utf8”’ your_file
perlish script.Ugly,but worked.

Would this be less “ugly”?

s = nil
open(myfile, ‘r’) {|f| s = f.read}
open(myfile, ‘w’) {|f| f.puts s.gsub(“TYPE=MyISAM”, “DEFAULT CHARACTER
SET utf8”)}

m.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs