How to use json in view file

In my controller I have found all the movies like this
@budgets=Budget.find(:all).to_json

Now in the view file what i want to do is something like this

How to do this as i have to plot this data.

On Tuesday 05 May 2009, mrbless wrote:

In my controller I have found all the movies like this
@budgets=Budget.find(:all).to_json

If it’s ok to issue a separate request for the data, have a look at

One way or another, you’ll have to do the conversion to the specific
format you need yourself.

Michael

    },
    "russia": {
        label: "Russia",
        data: [[1988, 218000], [1989, 203000], [1990, 171000],

[1992, 42500], [1993, 37600], [1994, 36600], [1995, 21700], [1996,
19200], [1997, 21300], [1998, 13600], [1999, 14000], [2000, 19100],
[2001, 21300], [2002, 23600], [2003, 25100], [2004, 26100], [2005,
31100], [2006, 34700]]
}
}


Michael S.
mailto:[email protected]
http://www.schuerig.de/michael/

mrbless wrote:

In my controller I have found all the movies like this
@budgets=Budget.find(:all).to_json

Now in the view file what i want to do is something like this

What is the output if you write:

p @bugets

in the controller?

=> [#<Budget id: 1, country: “usa”, year: “2000”, amount: 15000>,
#<Budget id: 2
, country: “usa”, year: “2001”, amount: 1564>, #<Budget id: 3,
country: “usa”, y
ear: “2002”, amount: 6463>, #<Budget id: 4, country: “usa”, year:
“2003”, amount
: 150002>, #<Budget id: 5, country: “usa”, year: “2004”, amount:
5000>, #<Budget
id: 6, country: “usa”, year: “2005”, amount: 4150>, #<Budget id: 7,
country: “u
sa”, year: “2006”, amount: 100>, #<Budget id: 8, country: “germany”,
year: "2000
", amount: 1000>, #<Budget id: 9, country: “germany”, year: “2001”,
amount: 1526
4>, #<Budget id: 10, country: “germany”, year: “2002”, amount: 64633>,
#<Budget
id: 11, country: “germany”, year: “2003”, amount: 1502>, #<Budget id:
12, countr
y: “germany”, year: “2004”, amount: 500>, #<Budget id: 13, country:
“germany”, y
ear: “2005”, amount: 450>, #<Budget id: 14, country: “germany”, year:
“2006”, am
ount: 10>, #<Budget id: 15, country: “britian”, year: “2000”, amount:
150>, #<Bu
dget id: 16, country: “britian”, year: “2001”, amount: 15064>,
#<Budget id: 17,
country: “britian”, year: “2002”, amount: 663>, #<Budget id: 18,
country: “briti
an”, year: “2003”, amount: 2002>, #<Budget id: 19, country: “britian”,
year: “20
04”, amount: 50000>, #<Budget id: 20, country: “britian”, year:
“2005”, amount:
4150>, #<Budget id: 21, country: “britian”, year: “2006”, amount:
1000>]

Thank you very much.

nirvana wrote:

=> [#<Budget id: 1, country: “usa”, year: “2000”, amount: 15000>,
#<Budget id: 2
, country: “usa”, year: “2001”, amount: 1564>, #<Budget id: 3,
country: “usa”, y
ear: “2002”, amount: 6463>, #<Budget id: 4, country: “usa”, year:
“2003”, amount
: 150002>, #<Budget id: 5, country: “usa”, year: “2004”, amount:
5000>, #<Budget
id: 6, country: “usa”, year: “2005”, amount: 4150>, #<Budget id: 7,
country: “u
sa”, year: “2006”, amount: 100>, #<Budget id: 8, country: “germany”,
year: "2000
", amount: 1000>, #<Budget id: 9, country: “germany”, year: “2001”,
amount: 1526
4>, #<Budget id: 10, country: “germany”, year: “2002”, amount: 64633>,
#<Budget
id: 11, country: “germany”, year: “2003”, amount: 1502>, #<Budget id:
12, countr
y: “germany”, year: “2004”, amount: 500>, #<Budget id: 13, country:
“germany”, y
ear: “2005”, amount: 450>, #<Budget id: 14, country: “germany”, year:
“2006”, am
ount: 10>, #<Budget id: 15, country: “britian”, year: “2000”, amount:
150>, #<Bu
dget id: 16, country: “britian”, year: “2001”, amount: 15064>,
#<Budget id: 17,
country: “britian”, year: “2002”, amount: 663>, #<Budget id: 18,
country: “briti
an”, year: “2003”, amount: 2002>, #<Budget id: 19, country: “britian”,
year: “20
04”, amount: 50000>, #<Budget id: 20, country: “britian”, year:
“2005”, amount:
4150>, #<Budget id: 21, country: “britian”, year: “2006”, amount:
1000>]

require ‘pp’
#pretty printer

class Budget
attr_reader :country, :year, :amount

def initialize(c, y, a)
@country, @year, @amount = c, y, a
end
end

arr = [
Budget.new(“usa”, “1989”, 15000),
Budget.new(“usa”, “1964”, 20000),
Budget.new(“russia”, “1999”, 14000)
]

pp arr

–output:–
[#<Budget:0x8744c @amount=15000, @country=“usa”, @year=“1989”>,
#<Budget:0x873fc @amount=20000, @country=“usa”, @year=“1964”>,
#<Budget:0x873ac @amount=14000, @country=“russia”, @year=“1999”>]

hash = Hash.new {|hash, key| hash[key] = []}
#create a hash where acessing a non-existent key
#creates the key and assigns an empty array to it

arr.each do |budget|
hash[budget.country] << [budget.year.to_i, budget.amount]
end

p hash

–output:–
{“usa”=>[[1989, 15000], [1964, 20000]], “russia”=>[[1999, 14000]]}

str = “var datasets = {\n”

hash.each do |key, val|
fragment =<<ENDOFSTRING2
“#{key}”: {
label: “#{key.upcase}”,
data: #{val.inspect}
},
ENDOFSTRING2
str << fragment
end
#inspect produces the same output as p var

result = str[0…-3] + “\n}”
#gets rid comma(and newline) after last
#element, then adds the closing parenthesis

puts result

–output:–
var datasets = {
“usa”: {
label: “USA”,
data: [[1989, 15000], [1964, 20000]]
},
“russia”: {
label: “RUSSIA”,
data: [[1999, 14000]]
}
}

You’ll have to manipulate the label to get the exact format you need.

Of course, you wouldn’t put all that code in a view.