NoSQL - TP2

NoSQL - TP2
Théo LEBLANC, ESIEA TD48

1. db.Exo.find({})

2. db.Exo.find({}, {restaurant_id: 1, name: 1, borough: 1, cuisine: 1})

3. db.Exo.find({}, {restaurant_id: 1, name: 1, borough: 1, cuisine: 1, _id: 0})

4. db.Exo.find({}, {'restaurant_id': 1, 'name': 1, 'borough': 1, 'address.zipcode': 1, '_id': 0})

5. db.Exo.find({'borough': 'Bronx'})

6. db.Exo.find({'borough': 'Bronx'}).LIMIT(5)

7. db.Exo.find({'borough': 'Bronx'}).skip(5).LIMIT(5)

8. db.Exo.find({'grades.score': {$gt: 90}})

9. db.Exo.find({'grades.score': {$gt: 80, $lt: 100}})

10. db.Exo.find({'address.coord.0': {$lt: -95.754168}})

11. db.Exo.find({$and: [{"cuisine": { $ne: "American" }}, {"grades.score": { $gt: 70 }}, {"address.coord.0": { $lt: -65.754168 }}]})

12. db.Exo.find({'cuisine': {$ne: 'American'}, 'grades.score': {$gt: 70}, 'address.coord.0': {$lt: -65.754168}})

13. db.Exo.find({'cuisine': {$ne: 'American '}, 'grades.grade': 'A', 'borough': {$ne: 'Brooklyn'}}).sort({'cuisine': -1})

14. db.Exo.find({'name': /^Wil/}, {'restaurant_id': 1, 'name': 1, 'borough': 1, 'cuisine': 1, '_id': 0})

15. db.Exo.find({'name': /ces$/}, {'restaurant_id': 1, 'name': 1, 'borough': 1, 'cuisine': 1, '_id': 0})

16. db.Exo.find({'name': /Reg/}, {'restaurant_id': 1, 'name': 1, 'borough': 1, 'cuisine': 1, '_id': 0})

17. db.Exo.find({'borough': 'Bronx', '$or': [{'cuisine': 'American'}, {'cuisine': 'Chinese'}]})

18. db.Exo.find({'borough': {$in: ['Staten Island', 'Queens', 'Bronx', 'Brooklyn']}},
    {'restaurant_id': 1, 'name': 1, 'borough': 1, 'cuisine': 1, '_id': 0})

19. db.Exo.find({'borough': {$nin: ['Staten Island', 'Queens', 'Bronx', 'Brooklyn']}},
    {'restaurant_id': 1, 'name': 1, 'borough': 1, 'cuisine': 1, '_id': 0})

20. db.Exo.find({'grades.score': {$lte: 10}},
    {'restaurant_id': 1, 'name': 1, 'borough': 1, 'cuisine': 1, '_id': 0})

21. db.Exo.find({$or: [{cuisine: {$nin: ['American', 'Chinese']}},
    {name: /^Wil/}]},{'restaurant_id': 1, 'name': 1, 'borough': 1, 'cuisine': 1, '_id': 0})

22. db.Exo.find({grades: {$elemMatch: {grade: 'A', score: 11, DATE: ISODate("2014-08-11T00:00:00Z")}}},
    {'restaurant_id': 1, 'name': 1, 'grades': 1, '_id': 0})

23. db.Exo.find({"grades.1.grade": "A","grades.1.score": 9,"grades.1.date": ISODate("2014-08-11T00:00:00Z")},
    {'restaurant_id': 1, 'name': 1, 'grades': 1, '_id': 0})

24. db.Exo.find({'address.coord.1': {$gt: 42, $lte: 52}},
    {'restaurant_id': 1, 'name': 1, 'address': 1, '_id': 0})

25. db.Exo.find({}).sort({'name': 1})

26. db.Exo.find({}).sort({'name': -1})

27. db.Exo.find({}).sort({'cuisine': 1, 'borough': -1})

28. db.Exo.find({'address.street': {$exists: TRUE}})

29. db.tp2.find({ "address.coord": { $type: "double" } })

30. db.Exo.find({"grades.score": {$mod: [7, 0]}},
    {'restaurant_id': 1, 'name': 1, 'grades': 1, '_id': 0})

31. db.Exo.find({'name': /mon/},
    {'name': 1, 'borough': 1, 'address.coord': 1, 'cuisine': 1, '_id': 0})

32. db.Exo.find({'name': /^Mad/},
    {'name': 1, 'borough': 1, 'address.coord': 1, 'cuisine': 1, '_id': 0})