IO.popen and wait for command to finish

[Uros]

Hello,

I have this for loop thats executing

IO.popen ("mysql database+i < database.sql")

It seems that the databases don't get populated with all the data,
since it seems that one mysql loop doesn't finish as the other one
start. So it seems, bear in mind I'm no expert, just trying to
trubleshoot the problem.

When I do a manual mysq < database.sql it works.

Is there I way to make ruby wait for the command to finish, befor
continuing to loop?

br,
uros

 

[Robert Klemme]

Hello,

I have this for loop thats executing

IO.popen ("mysql database+i < database.sql")

It seems that the databases don't get populated with all the data,
since it seems that one mysql loop doesn't finish as the other one
start. So it seems, bear in mind I'm no expert, just trying to
trubleshoot the problem.

When I do a manual mysq < database.sql it works.

Is there I way to make ruby wait for the command to finish, befor
continuing to loop?

I'd just read the IO until the end. You should do that anyway because
otherwise the process my block

IO.popen ("mysql database+i < database.sql") do |io|
io.each_line {}
end

Kind regards

robert

 

[Uros]

Hello Robert,

thanks for your answer. That did the trick.

br,
uros