Saving external JSON to database (RAILS)

Question

i'm trying to save external values from BitBucket to my Rails app and then return them in view(i'm new with databases), so if somebody can help me with that, i'll really appreciate it.

I returned API call from BitBucket in my controller so its works well.. Then i create model bitbucket name:string message:text date:integer

So now i place this into bitbucket.rb model:

class Bitbucket < ActiveRecord::Base
    def saveData
        require 'bitbucket_rest_api'   
          bitbucket = BitBucket.new login:'...', password:'...'

          repo = bitbucket.repos.commits.list '...', '...'
          data = repo["values"]

            data.each do |r|
                r["author"]["user"]["display_name"]
                r["message"]
                DateTime.strptime(r["date"], '%Y-%m-%dT%H:%M:%S%z').strftime("%D %r")
            end
    end
end

This is the first call what i want to save into DB then i would like to save every new commit into database.

Thanks a lot.

Maxim Pontyushenko · Accepted Answer · 2016-04-22 18:26:51Z

2

You should name methods in Ruby like this: save_data, not saveData to anything else.
Your method should be class-method since you are not using any object inside of it.
You can create database entry with create or new, save chain.

This might help:

class Bitbucket < ActiveRecord::Base
  def self.save_data
    require 'bitbucket_rest_api'   
    bitbucket = BitBucket.new login:'...', password:'...'
    repo = bitbucket.repos.commits.list '...', '...'
    repo["values"].each do |r|
      create(
        name: r["author"]["user"]["display_name"],
        message: r["message"],
        date: DateTime.strptime(r["date"], '%Y-%m-%dT%H:%M:%S%z').strftime("%D %r")
      )
    end
  end
end

edited Apr 22, 2016 at 18:26

answered Apr 22, 2016 at 17:18

Maxim Pontyushenko

3,0532 gold badges29 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

11 Comments

liborza Over a year ago

And Controller gonna be like @commits = Bitbucket.all ? Then in view <%= @bitbucket.name %> etc.. ?

Maxim Pontyushenko Over a year ago

@LiborZahrádka @commits.name For example.

liborza Over a year ago

Yeah sorry wrong variable.. i did a mistake.. ok thanks a lot

liborza Over a year ago

bitbucket.rb:9: syntax error, unexpected tIDENTIFIER, expecting ')' message: r["message"] and bitbucket.rb:10: syntax error, unexpected ':', expecting keyword_end date: DateTime.strptime(r["date"],... bitbucket.rb:11: syntax error, unexpected ')', expecting keyword_end Im getting this error right now

Maxim Pontyushenko Over a year ago

@LiborZahrádka Updated my answer.

|

Collectives™ on Stack Overflow

Saving external JSON to database (RAILS)

1 Answer 1

11 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Related