// Insert a list of documenst in database named "testdb", in a collection named "travel"
        // update the passenger krishna foodprefrence to only "Indian_NonVeg"

        public void MongoCrud_04_2_Update_Food_Preference()
        {
            #region mongoConnection

            travelCollection = new MongoClient(_runner.ConnectionString).GetDatabase("testdb").GetCollection <AirTravel>("travel");

            #endregion
            #region data preparation
            InsertTravelDetails();
            #endregion

            var filter = Builders <AirTravel> .Filter.Eq(x => x.FirstName, "Krishna");

            var foodPrefrence = new List <FoodTypes>()
            {
                FoodTypes.Indian_NonVeg
            };
            var updateOperation = Builders <AirTravel> .Update.Set(x => x.FoodPreferences, foodPrefrence);

            travelCollection.UpdateOne(filter, updateOperation);

            #region verification
            TravelOperationVerifier.VerifyUpdateFoodPrefrence(_runner.ConnectionString);
            #endregion
            #region data cleanup
            cleanUpTravelCollection();
            #endregion
        }
        // Insert a list of documenst in database named "testdb", in a collection named "travel"
        // upadte the travel date to today UTC of given booking ID "PGS1789"

        public void MongoCrud_07_2_Find_Customer_with_Booking_ID_AndUpdate_TravelDate()
        {
            #region mongoConnection

            travelCollection = new MongoClient(_runner.ConnectionString).GetDatabase("testdb").GetCollection <AirTravel>("travel");

            #endregion
            #region data preparation
            InsertTravelDetails();
            #endregion
            var beforeUpdate = travelCollection.Find(Builders <AirTravel> .Filter.Empty).ToList();
            var filter       = Builders <AirTravel> .Filter.ElemMatch(x => x.TravelHistory, his => his.BookingID == "PGS1789");

            var updateOperation = Builders <AirTravel> .Update.Set(x => x.TravelHistory.ElementAt(-1).TravelDate, DateTime.Now);

            var options = new FindOneAndUpdateOptions <AirTravel>
            {
                ReturnDocument = ReturnDocument.After
            };
            var updatedDocuemnt = travelCollection.FindOneAndUpdate(filter, updateOperation, options);

            #region verification
            TravelOperationVerifier.Verify_Travel_Date_Updated(_runner.ConnectionString);
            #endregion
            #region data cleanup
            cleanUpTravelCollection();
            #endregion
        }
Beispiel #3
0
        // Insert a list of documenst in database named "testdb", in a collection named "travel"
        // add food Prefrence "Indian_Veg" to Shubham

        public void MongoCrud_07_4_Add_Food_Preference()
        {
            #region mongoConnection

            travelCollection = new MongoClient(_runner.ConnectionString).GetDatabase("testdb").GetCollection <AirTravel>("travel");

            #endregion
            #region data preparation
            InsertTravelDetails();
            var beforeUpdate = travelCollection.Find(Builders <AirTravel> .Filter.Empty).ToList();

            #endregion

            var filter = Builders <AirTravel> .Filter.Eq(x => x.FirstName, "Shubham");

            var updateOperation = Builders <AirTravel> .Update.AddToSet(x => x.FoodPreferences, FoodTypes.Indian_Veg);

            var options = new FindOneAndUpdateOptions <AirTravel>
            {
                ReturnDocument = ReturnDocument.After,
                IsUpsert       = true
            };
            var updatedDocuemnt = travelCollection.FindOneAndUpdate(filter, updateOperation, options);


            #region verification
            TravelOperationVerifier.Verify_Add_Food_Preference(_runner.ConnectionString);
            #endregion
            #region data cleanup
            cleanUpTravelCollection();
            #endregion
        }
Beispiel #4
0
        // Insert a list of documenst in database named "testdb", in a collection named "travel"
        // find the recent second-two travlers with name starting with S order by name desc

        public void MongoCrud_10_2_Find_Second_two_Recent_Passengers_with_Name_Starting_With_S_Order_By_Name_Dsc()
        {
            #region mongoConnection

            travelCollection = new MongoClient(_runner.ConnectionString).GetDatabase("testdb").GetCollection <AirTravel>("travel");

            #endregion
            #region data preparation
            InsertTravelDetails();
            #endregion

            int pageSize   = 2;
            int pageNumber = 1;
            var filter     = Builders <AirTravel> .Filter.Regex(x => x.FirstName, BsonRegularExpression.Create(new Regex("S.*")));

            var sortDefinition = Builders <AirTravel> .Sort.Descending(x => x.FirstName);

            var result = travelCollection.Find(filter).Sort(sortDefinition)
                         .Skip(pageSize * pageNumber)
                         .Limit(pageSize).ToList();

            #region verification
            TravelOperationVerifier.Verify_Passengers_NameStarting_with_S(_runner.ConnectionString, result);
            #endregion
            #region data cleanup
            cleanUpTravelCollection();
            #endregion
        }
Beispiel #5
0
        // find a traveller with booking id "MYS34394"
        // update the details as present in "FindAndUpdatePassenger" of sirtravel test data
        // hint : use the jsection reader to read the data.
        // how to upsert
        public void MongoCrud_07_5_Update_An_AirTraveller()
        {
            #region mongoConnection

            travelCollection = new MongoClient(_runner.ConnectionString).GetDatabase("testdb").GetCollection <AirTravel>("travel");

            #endregion
            #region data preparation
            InsertTravelDetails();
            #endregion

            var airTravelPassenger = testData.GetSection("FindAndUpdatePassenger").GetObject <AirTravel>();
            var beforeUpdate       = travelCollection.Find(Builders <AirTravel> .Filter.Empty).ToList();
            var filter             = Builders <AirTravel> .Filter.ElemMatch(x => x.TravelHistory, his => his.BookingID == "MYS34394");

            var updateOperation = Builders <AirTravel> .Update.Set(x => x, airTravelPassenger);

            var updatedDocuemnt = travelCollection.UpdateOne(filter, updateOperation, new UpdateOptions
            {
                IsUpsert = true
            });


            #region verification
            TravelOperationVerifier.Verify_Add_Food_Preference(_runner.ConnectionString);
            #endregion
            #region data cleanup
            cleanUpTravelCollection();
            #endregion
        }
        // Insert a list of documenst in database named "testdb", in a collection named "travel"
        // remove all minor passengers

        public void MongoCrud_06_2_Customers_With_Age_below_18()
        {
            #region mongoConnection

            travelCollection = new MongoClient(_runner.ConnectionString).GetDatabase("testdb").GetCollection <AirTravel>("travel");

            #endregion
            #region data preparation
            InsertTravelDetails();
            #endregion

            var beforeUpdate = travelCollection.Find(Builders <AirTravel> .Filter.Empty).ToList();
            var filter       = Builders <AirTravel> .Filter.Lt(x => x.Age, 18);

            travelCollection.DeleteMany(filter);

            #region verification
            TravelOperationVerifier.Verify_No_Minor_Passenger(_runner.ConnectionString);
            #endregion
            #region data cleanup
            cleanUpTravelCollection();
            #endregion
        }