CODEWITHSUNDEEP
ruby-on-railsarrayssqlitesqlite3-ruby
hack-is-art
hack-is-art

Reputation: 325

How to extract data from sqlite3 array in ruby on rails?

How can I get data from an array of the form:

[#<User id: 1, name: "John", surname: "Smith", dob: "2016-07-26", location: "Liverpool", created_at: "2016-07-26 08:50:01", updated_at: "2016-07-26 08:50:01">]

generated from sqlite3 database using this code:

<%= User.select(User.all.select { |u| u.id == 1 }) %>

Also, is there any better way to extract selected fields than everything? Whatever I tried returns some long random numbers like references.

And finally, how can I make the:

u.id == 1

to become any id given to that user in real time, like the following:

u.id == x (where x is any number)

Cheers!

Upvotes: 1

Views: 321

Answers (1)

siegy22
siegy22

Reputation: 4413

I don't know if I'm missing something but I think what you want is either find:

@user = User.find(x) # x = given id

or where (returns a set of users, not just one)

@user = User.where(id: x)

And then in your view you can use the user like this:

<%= @user.name %>

Upvotes: 1

Related Questions