File: query.rb

package info (click to toggle)
ruby-mongo 2.21.3-1
  • links: PTS, VCS
  • area: main
  • in suites: sid
  • size: 14,764 kB
  • sloc: ruby: 108,806; makefile: 5; sh: 2
file content (79 lines) | stat: -rw-r--r-- 1,659 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
# frozen_string_literal: true
# rubocop:todo all

# Query for all documents in a collection

cursor = client[:restaurants].find

cursor.each do |doc|
  puts doc
end

# Query for equality on a top level field

cursor = client[:restaurants].find('borough' => 'Manhattan')

cursor.each do |doc|
  puts doc
end

# Query by a field in an embedded document

cursor = client[:restaurants].find('address.zipcode' => '10075')

cursor.each do |doc|
  puts doc
end

# Query by a field in an array

cursor = client[:restaurants].find('grades.grade' => 'B')

cursor.each do |doc|
  puts doc
end

# Query with the greater-than operator

cursor = client[:restaurants].find('grades.score' => { '$gt' => 30 })

cursor.each do |doc|
  puts doc
end

# Query with the less-than operator

cursor = client[:restaurants].find('grades.score' => { '$lt' => 10 })

cursor.each do |doc|
  puts doc
end

# Query with a logical conjuction (AND) of query conditions

cursor = client[:restaurants].find({ 'cuisine' => 'Italian',
                                     'address.zipcode' => '10075'})

cursor.each do |doc|
  puts doc
end

# Query with a logical disjunction (OR) of query conditions

cursor = client[:restaurants].find('$or' => [{ 'cuisine' => 'Italian' },
                                             { 'address.zipcode' => '10075'}
                                            ]
                                  )

cursor.each do |doc|
  puts doc
end

# Sort query results

cursor = client[:restaurants].find.sort('borough' => Mongo::Index::ASCENDING,
                                        'address.zipcode' => Mongo::Index::DESCENDING)

cursor.each do |doc|
  puts doc
end