[OSM-dev] No new planet.osm files?

Nick Whitelegg Nick.Whitelegg at solent.ac.uk
Mon Oct 9 16:12:56 BST 2006


>I coded the reading-from-db part.

>The probably offending rows are:

>def all_nodes
>$mysql.query "..." do |rows|
>rows.each do |row|
...

>If 'rows' is an Array, and this completly reads the data into 'rows'
>before iteration starts, this is the place to change. If rows is of some
>"cursor-like" type, this should be fine.

>Can someone check this ("puts rows.class" before the rows.each...)? I 
have
>no ruby environment here at hand.. :(

I'll try this on the dev server later on, hopefully.

>However, I don't know how it should look like instead. Does someone know
>the MySQL API well enough?

I guess it must be possible in Ruby, as in PHP you would do the following:

while($row=mysql_fetch_array($result))
{
        echo "ID $row[id] Lat $row[lat] lon $row[lon]\n";
}

I don't know the ruby mysql api. But... if I can find some documentation 
easily, I'll have a go at changing it. If not it might be quicker for me 
to recode it in php....

Nick








More information about the dev mailing list