top of page

MongoDB Studio 3T Practice Set Using Tweets.json Dataset | Realcode4you

Install MongoDB and Studio 3T on your computer, create a new database with a name and import 'Tweets.json' (available on iLearn) as a collection. Then complete the following exercises.



Exercise

1. Insert 2 new Tweets to the collection.

2. Write a MongoDB query that returns all the Tweets.

3. Write a MongoDB query to find one of your Tweets with user’s name: "user 30".

4. Update two Tweets to have two tags called “My first tag” and “My second tag” respectively. Show two ways to do this. Do the first one using update() and do the second one using save(). Hint: for save(), you might want to query the object, store it in a variable first; then update it and save the update.

5. Write a MongoDB query to retrieve all documents from the Tweets collection where user name equals either "user 30" or "user 40".

6. Write a MongoDB query to retrieve all documents from the Tweets collection where user screen_name is "Twitter User" and user location is "Internet". (Specify AND Conditions)

7. Write a MongoDB query to retrieve all documents from the Tweets collection where user screen_name is "Twitter User" or user url is "user URL". (Specify OR Conditions)

8. Write a MongoDB query to retrieve all documents from the Tweets collection where user id is not 224499494502


Solution

1. Insert 2 new Tweets to the collection.

A 1.

Solution 1:

//Tweet 1
db.tweets.insert(
{
"created_at": "Thu Apr 06 15:24:15 +0000 2020",
"id_str": "1850006245121695744",
"text": "Have a nice day",
"user": {
"id": NumberLong(2244456599494501),
"name": "user 01",
"screen_name": "Twitter User",
"location": "Internet",
"url": "user URL",
"description": "user description"
},
"place": {
},
"entities": {
        "hashtags": [
        ],
        "urls": [{
                "url": "twt url sample",
                "unwound": {
                        "url": "url sample",
                        "title": "web page title"
                }
        }],
        "user_mentions": [
        ]
  }
})

//Tweet 2
db.tweets.insert(
{
        "created_at": "Thu Apr 06 15:24:15 +0000 2020",
        "id_str": "1850006245121695744",
        "text": "Good Morning",
        "user": {
                "id": NumberLong(2244456599494501),
                "name": "user 01",
                "screen_name": "Twitter User",
                "location": "Internet",
                "url": "user URL",
                "description": "user description"
        },
        "place": {
        },
        "entities": {
                "hashtags": [
                ],
                "urls": [{
                        "url": "twt url sample",
                        "unwound": {
                                "url": "url sample",
                                "title": "web page title"
                        }
                }],
                "user_mentions": [
                ]
        }
})

Solution 2:

db.tweets.insert(
[{
                "created_at": "Thu Apr 06 15:24:15 +0000 2020",
                "id_str": "1850006245121695744",
                "text": "Hi",
                "user": {
                        "id": 2244456599494501,
                         "name": "user 01",
                         "screen_name": "Twitter User",
                         "location": "Internet",
                         "url": "user URL",
                         "description": "user description"
                 },
                "place": {
                },
                "entities": {
                           "hashtags": [
                            ],
                           "urls": [{
                                   "url": "twt url sample",
                                   "unwound": {
                                           "url": "url sample",
                                           "title": "web page title"
                                    }
                           }],
                           "user_mentions": [
                           ]
                }
},
{
                "created_at": "Thu Apr 06 15:24:17 +0000 2020",
                "id_str": "8510006245121695744",
                "text": "Welcome",
                "user": {
                       "id": 224499494503,
                       "name": "user 03",
                       "screen_name": "Twitter User",
                       "location": "Internet",
                       "url": "user URL",
                       "description": "user description"
                 },
                 "place": {
                 },
                 "entities": {
                           "hashtags": [
                            ],
                           "urls": [{
                                "url": "twt url sample",
                                "unwound": {
                                        "url": "url sample",
                                        "title": "web page title"
                                }
                           }],
                           "user_mentions": [
                           ]
                 }
            }
]
)

2. Write a MongoDB query that returns all the Tweets.

db.Tweets.find() 

3. Write a MongoDB query to find one of your Tweets with user’s name: "user 30".

db.Tweets.findOne({"user.name":"user 30"})

4. Update two Tweets to have two tags called “My first tag” and “My second tag” respectively. Show two ways to do this. Do the first one using update() and do the second one using save(). Hint: for save(), you might want to query the object, store it in a variable first; then update it and save the update.


Solution 1 (update ()):

db.Tweets.update({"user.name":"user 30"}, {$set:{"tag":"My first tag"}}) 
db.Tweets.update({"user.name":"user 40"}, {$set:{"tag":"My second tag"}}) 

Solution 2 (save ()):

var tweet_user30 = db.Tweets.findOne({"user.name":"user 30"})
tweet_user30["tag"] = "My first tag"
db.Tweets.save(tweet_user30)
var tweet_user40 = db.Tweets.findOne({"user.name":"user 40"})
tweet_user40["tag"] = "My second tag"
db.Tweets.save(tweet_user40)

5. Write a MongoDB query to retrieve all documents from the Tweets collection where user name equals either "user 30" or "user 40".

db.Tweets.find({"user.name":{ $in: [ "user 30", "user 40" ] } })

6. Write a MongoDB query to retrieve all documents from the Tweets collection where user screen_name is "Twitter User" and user location is "Internet". (Specify AND Conditions)

db.Tweets.find({$and: [{"user.screen_name": "Twitter User"}, {"user.location":"Internet"}]})

7. Write a MongoDB query to retrieve all documents from the Tweets collection where user screen_name is "Twitter User" or user url is "user URL". (Specify OR Conditions)

db.Tweets.find({ $or: [{"user.screen_name": "Twitter User"}, {"user.url":"user URL"}]})

8. Write a MongoDB query to retrieve all documents from the Tweets collection where user id is not 224499494502.


Solution 1:

db.Tweets.find({"user.id":{$ne:224499494502}})

Solution 2:

db.Tweets.find({"user.id":{$not:{$eq:224499494502}}})

15 комментариев


yoherit725
08 мая

The Phantom Wallet extension is a secure browser-based crypto wallet for managing Solana-based assets. It offers seamless integration with decentralized applications, NFT marketplaces, and DeFi platforms. With an intuitive interface and fast transactions, Phantom ensures users can safely send, receive, and store tokens right from their browser. Phantom extension | Phantom wallet extension

Лайк

yoherit725
17 апр.

MetaMask Chrome Extension is a popular crypto wallet and gateway to blockchain apps, directly accessible in your browser. The term "MetaMask Chrome" often refers to using MetaMask on the Chrome browser. Together, they enable secure Ethereum transactions, decentralized app access, and digital identity management with ease and convenience. Metamask Chrome Extension | Metamask Chrome

Лайк

yoherit725
08 апр.

Secure your crypto with ease using Ledger . com/start for setting up your Ledger hardware wallet, and access your digital assets safely through Trezor wallet login. Both offer trusted, offline protection for managing cryptocurrencies, ensuring maximum security, privacy, and control over your funds in the evolving world of blockchain and Web3. Ledger.com/start | Trezor wallet login

Лайк

yoherit725
18 мар.

Ledger. com/start and Trezor wallet login are essential for securely setting up and accessing hardware wallets. Ledger.com/start guides users through initializing Ledger devices via Ledger Live, ensuring safe crypto management. Trezor wallet login allows secure access to Trezor Suite, enabling transactions and asset control. Both provide top-tier security, offline key storage, and protection from cyber threats. Ledger.com/start | Trezor wallet login

Лайк

yoherit725
04 мар.

The Phantom Chrome Extension is a secure, user-friendly wallet for managing Solana-based assets directly in your browser. It enables seamless transactions, NFT management, and decentralized app (dApp) interactions. With robust security, quick setup, and an intuitive interface, Phantom simplifies your crypto experience while ensuring privacy and convenience. Phantom Chrome Extension | Phantom Wallet Chrome

Лайк

REALCODE4YOU

Realcode4you is the one of the best website where you can get all computer science and mathematics related help, we are offering python project help, java project help, Machine learning project help, and other programming language help i.e., C, C++, Data Structure, PHP, ReactJs, NodeJs, React Native and also providing all databases related help.

Hire Us to get Instant help from realcode4you expert with an affordable price.

USEFUL LINKS

Discount

ADDRESS

Noida, Sector 63, India 201301

Follows Us!

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn

OUR CLIENTS BELONGS TO

  • india
  • australia
  • canada
  • hong-kong
  • ireland
  • jordan
  • malaysia
  • new-zealand
  • oman
  • qatar
  • saudi-arabia
  • singapore
  • south-africa
  • uae
  • uk
  • usa

© 2023 IT Services provided by Realcode4you.com

bottom of page