Parsing a Ruby Array to JSON -


i have results:

puts result

that output:

allowed 20863963 1554906 denied 3607325 0 quarantined 156240  0

debug 

p results

output

[["allowed", 20863963, 1554906], ["denied", 3607325, 0], ["quarantined", 156194, 0]]

the headers are: 

status,hits,page_views

i need convert json. if results in standard csv format straight forward how 1 approach if results format looked above?

expected output similar this:

[{"status":"allowed","hits":"20863963","page_views":"1554906"},{"status":"denied","hits":"3607325","page_views":"0"},{"status":"quarantined","hits":"156240","page_views":"0"}]

solution

a = result.map{|s| {status: s[0], hits: s[1].to_i, page_views: s[2].to_i} } puts a.to_json 

output = "allowed 20863963 1554906 denied 3607325 0 quarantined 156240  0"  = output.split("\n").each_slice(3).map{|s| {status: s[0], hits: s[1].to_i, page_views: s[2].to_i} } # => [{:status=>"allowed", :hits=>20863963, :page_views=>1554906}, {:status=>"denied", :hits=>3607325, :page_views=>0}, {:status=>"quarantined", :hits=>156240, :page_views=>0}] a.to_json # => => "[{\"status\":\"allowed\",\"hits\":20863963,\"page_views\":1554906},{\"status\":\"denied\",\"hits\":3607325,\"page_views\":0},{\"status\":\"quarantined\",\"hits\":156240,\"page_views\":0}]"

Comments

Post a Comment

Popular posts from this blog

matlab - Deleting rows with specific rules -

i got 20*3 cell array , need delete rows contains "137", "2" , "n:t" origin data: 't' '' '' 'np(*)' '' '' [ 137] '' '' [ 2] '' '' 'are' 'and' 'np(fcc_a1#1)' '' '' '1:t' [ 1200] [0.7052] '' [1.2051e+03] [0.7076] '' 'are' 'and' 'np(fcc_a1#3)' '' '' '2:t' [ 1200] [0.0673] '' [1.2051e+03] [0.0671] '' 'are' 'and' 'np(m23c6)' '' '' '3:t' [ 1200] [0.227...
Read more

php - MySQLi multi_query results for later use -

i using mysqli multi_query work several select statemets @ time. know how handle results, able use them later in code. example: <?php //connection stuff $query = "select name, surname database1;"; $query.= "select car, year, type database2 carid='1';"; $query.= "select product, price database3;"; if ($mysqli->multi_query($query)) { if($result = $mysqli->store_result()) { while($row = $result->fetch_row()) { --> here? } } } ?> <html> <div id='persona'> <?php foreach() { --> print name + surname } ?> </div> <div id='cars'> <?php foreach() { --> print car + year + type } ?> </div> <div id='product'> <?php foreach() { --> print product + price } ?> </div> </html> one more thing, prepared statements not possible when using multiple_query, right? there no benefit in putting unrelated queries in 1 multi ...
Read more