Spring mongo criteria querying data which are present and not present in database

Question

0.00/5 (No votes)

See more:

, +

I want to query all data which are present in my database by comparing with while loop data and if this data is available I want to update it and if not I want to insert it as a new record into the database.

The problem is I'm only getting data that is present in the database these missing I'm not able to get them from the fetched result

Any help will be much appreciated!

What I have tried:

while(result.next()) {
           Query query = new Query();
           query.addCriteria(Criteria.where("customerId").is(result.getString(1))
                .andOperator(Criteria.where("orderDate").is(result.getString(2)),
                             Criteria.where("Location").is(baseLocation)));

           var dbData = mongoTemplate.find(query, Customer.class);

           if(dbData == null || dbData.isEmpty()) {

           Customer customer = new Customer();
           customer.setCustomerId(result.getString(1));
           customer.setOrderDate(result.getString(2));
           customer.setOrderWeight(result.getString(3));
           customer.setCustomerCode(result.getString(9));
           customer.setDateAdded(LocalDateTime.now());
           customer.setCustomerLocation(baseLocation);
           customerList.add(customer);

           }else {

           for (Customer customerData: dbData) {

           if(customerData.getOrderDate().equals(result.getString(2)) == true) {
           customerData.setCustomerId(result.getString(1));
           customerData.setOrderDate(result.getString(2));
           customerData.setOrderWeight(result.getString(3));
           customerData.setCustomerCode(result.getString(9));
           customerData.setDateAdded(LocalDateTime.now());
           customerData.setCustomerLocation(baseLocation);
           customerList.add(customerData);

           }else {
           Customer customer = new Customer();
           customer.setCustomerId(result.getString(1));
           customer.setOrderDate(result.getString(2));
           customer.setWeight(result.getString(3));
           customer.setCustomerCode(result.getString(9));
           customer.setDateAdded(LocalDateTime.now());
           customer.setCustomerLocation(basename);
           customerList.add(customer);
           }

           }

           }

           }

Posted 15-Jan-23 22:06pm

Office Systems

Updated 16-Jan-23 22:42pm

Add a Solution

Comments

[no name] 16-Jan-23 4:11am

Without seeing the actual results it is impossible to guess what the problem is. Use the debugger to step through the code to see exactly what happens for each query.

Office Systems 16-Jan-23 4:34am

for (Customer customerData: dbData) {

if(customerData.getOrderDate().equals(result.getString(2)) == true) {
System.out.println("Data Present In Database");
}else {
System.out.println("Data Absent In Database");
}

It prints only "Data Present In Database"

Andre Oosthuizen 16-Jan-23 4:14am

Your question is confusing - you are saying you are only getting data that is present.... that is exactly what you want is it not? If it is not present, then add a new record - if it is, then edit the record.

Office Systems 16-Jan-23 4:22am

May be I should put it a little bit more clear @Andre Oosthuizen my concern is I want to update if the data is present within my database and Insert a new record if it does not exist, now the issue I'm facing is that data present inside database are updated correctly but these absent are not inserted and I can't even get them within the if else statement and at the debugger meaning new records are not fetched by the query

[no name] 16-Jan-23 4:42am

As I said earlier, you need to use the debugger to find out exactly what is returned by the query when the requested record does not exist. We cannot do that for you.

Office Systems 16-Jan-23 4:46am

Thanks Richard for your response can I share with you my project on github and help me to figure it out?

[no name] 16-Jan-23 4:55am

Sorry, no; if you want help then you need to provide the information that you have been asked for. We only work here on the CodeProject forums.

Office Systems 16-Jan-23 5:02am

Ok Richard let me try out and then post the question with full information thank you.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Andre Oosthuizen · Accepted Answer · 2023-01-16T22:42:00

You are adding a new client twice, at the start of your code and then again within another if else statement.

I am not familiar with the code used ?-Java/MongoDb -? but the basics is the same

How it works -
1. Search data table for client with ID 1.
2. If client exist, check if new data corresponds with table data,
3. If it does not compare, update the record with the new data,
4. If the client does not exist, add a new record to data table.

while(result.next()) {
if(dbData == null || dbData.isEmpty()) {
Customer customer = new Customer();
} else {
UPDATE RECORD HERE...
}

You then have to run a new query again if you want to see the updated or the new record.

Spring mongo criteria querying data which are present and not present in database

1 solution

Solution 1

Add your solution here

Preview 0

Spring mongo criteria querying data which are present and not present in database

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us