[Ruby] Unable to view collection/ db content

[Pin_Hoong_Lai]

Hi, trying to retrieve contents of a client database through Ruby’s mongo documentation, however when outputting my collections via puts db and db[:collection name], the console returns an object of the form

#<Mongo::Database:0x000000010e726190>

or

#<Mongo::Collection:0x0000000109c63b30>

and not actual explicit values and its parameters. Does anyone know how to solve this?

Thanks

[Doug_Duncan]

While this doesn’t answer your question, I noticed that the link you provided is to an older version (2.2) of the driver. Are you following along with that, are you using the most recent version’s (2.18) documentation?

[Stennie]

Hi @Pin_Hoong_Lai,

Calling puts on an object will print a stringified version of that object, as per your output.

You need to call appropriate methods like find() or aggregate() to retrieve documents:

• CRUD Operations — MongoDB Ruby Driver Manual 2.18
• Aggregation — MongoDB Ruby Driver Manual 2.18

@Pin_Hoong_Lai

not actual explicit values and its parameters

Do you perhaps mean you want to see a representation of the object and instance values? You can use inspect for that:

require 'mongo'

client = Mongo::Client.new([ '127.0.0.1:27017' ], :database => 'test')
db = client.database
puts client.inspect
puts db.inspect

Would result in output like:

#<Mongo::Client:0x580 cluster=#<Cluster topology=Single[127.0.0.1:27017] servers=[#<Server address=127.0.0.1:27017 STANDALONE pool=#<ConnectionPool size=0 (0-20) used=0 avail=0 pending=0>>]>>
#<Mongo::Database:0x600 name=test>

If those suggestions aren’t what you are looking for, please provide more details on your environment:

• version of MongoDB Ruby driver
• version of Ruby
• version of MongoDB server
• type of deployment you are connecting to
• example of the output you are hoping to see

Regards,
Stennie

[Pin_Hoong_Lai]

Thanks for the reply @Stennie.

As you mentioned, I am trying to retrieve documents within my database. However, upon calling the find function on my DB collection, I am still unable to see the relevant document output.
Below is my code snippet:

client = Mongo::Client.new('mongodb+srv://user:password@cluster.mongodb.net/test')
collection = client[:listingsAndReviews]
puts collection.find({name: "Ribeira Charming Duplex"})

The output which I was expecting to receive was this:

_id
"10006546"
listing_url
"https://www.airbnb.com/rooms/10006546"
name
"Ribeira Charming Duplex"
summary
"Fantastic duplex apartment with three bedrooms, located in the histori…"
space
"Privileged views of the Douro River and Ribeira square, our apartment …"
description
"Fantastic duplex apartment with three bedrooms, located in the histori…"

However i keep getting nil values.
The Database has been made public and hence you would be able to access it as well through mongoDB compass through the URI in my code snippet.

Thank you,
Pin Hoong

[Stennie]

Hi @Pin_Hoong_Lai,

Thank you for providing the example output to clarify that you are just aiming to print the result document.

@Pin_Hoong_Lai

puts collection.find({name: "Ribeira Charming Duplex"})

The find() method returns the results of the operation as an iterable CollectionView.

To get your desired output you need to iterate the result, for example:

# Print the first result
puts collection.find({name: "Ribeira Charming Duplex"}).first

# Print all results
collection.find({name: "Ribeira Charming Duplex"}).each do |document|
    puts document
end

For more examples please see the Ruby Driver Quick Start Tutorial.

@Pin_Hoong_Lai

The Database has been made public and hence you would be able to access it as well through mongoDB compass through the URI in my code snippet.

Please remove the open access to your cluster. If you want to provide help for reproducing an issue, a sample document and the specific versions of software used should be a great starting point.

Regards,
Stennie