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
<script>
var datasets = {
        "usa": {
            label: "USA",
            data: [[1988, 483994], [1989, 479060], [1990, 457648],
[1991, 401949], [1992, 424705], [1993, 402375], [1994, 377867], [1995,
357382], [1996, 337946], [1997, 336185], [1998, 328611], [1999,
329421], [2000, 342172], [2001, 344932], [2002, 387303], [2003,
440813], [2004, 480451], [2005, 504638], [2006, 528692]]
        },
        "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]]
        }
}
</script>

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

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

http://github.com/mschuerig/ruby_template_handler

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

Michael

=> [#<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>]

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.

Thank you very much.