Re: [jnosql-dev] [nosql-dev] mongodb $elemMatch jnosql query equivalent

[Otavio Santana <otaviopolianasantana@xxxxxxxxx>]

Hey Dmitry, it should be hidden.
You should inject the `MongoDBTemplate`.

Please, take a look at this sample:

https://github.com/JNOSQL/demos-se/blob/main/mongodb/src/main/java/org/jnosql/demo/se/App4.java

On Wed, May 17, 2023 at 4:58 PM Dmitry Repchevsky via nosql-dev <nosql-dev@xxxxxxxxxxx> wrote:

Hi again,

There is a problem with  DefaultMongoDBTemplate as

@Inject
MongoDBTemplate template;

injects uninitialized DefaultMongoDBTemplate.

The class is protected:
https://github.com/eclipse/jnosql-extensions/blob/1.0.0-b5/jnosql-mongodb-extension/src/main/java/org/eclipse/jnosql/mapping/mongodb/DefaultMongoDBTemplate.java

So the only way to use it - copy to my own project.

Cheers,

Dmitry

P.S. The unit test works, because it is in the same package.

On 5/13/2023 8:54 AM, Dmitry Repchevsky via nosql-dev wrote:

Great!

Thank you, I used DocumentTemplate and was thinking about Criteria extension API, but direct query is a quick and good fix.

IMHO, the search in the arrays is the basic functionality independently of any document model.

Thank you again,

Dmitry

On 5/13/2023 8:44 AM, Otavio Santana wrote:

Hey Dmitry, how are you?

You can use the Filter directly if you use the MongoDBTemplate, you can check the MongoDB readme.

@Inject
MongoDBTemplate template;
...

Bson filter = eq("name", "Poliana");
Stream<Person> stream = template.select(Person.class , filter);

On Fri, May 12, 2023 at 5:00 PM Otavio Santana <otaviopolianasantana@xxxxxxxxx> wrote:

Hey Dmitry, how are you?

I hope that you are doing well.

I've included the JNoSQL discussion because what we can do is create a MongoDB extension to work with it.

Please, let me know your thoughts.

On Thu, May 11, 2023 at 1:12 PM Dmitry Repchevsky via nosql-dev <nosql-dev@xxxxxxxxxxx> wrote:

Hello,

Is there any possibility to query elements in the array via jnosql query?

I have (an example) data like:

{ "measures": [
    { "id": "weight", "value": 80},
    { "id": "height", "value": 180}
  ]
}

The mongodb query for this would look like:
db.person.find({"measures": {"$elemMatch": {"id": "weight", "value": 180}}});

The only query I found to do in jnosql is something like:
select * from person where measures.id = "weight" and measures.value = 180

Which is wrong as it found the person object that match.
Any even hacky solution would be welcome.

Cheers,

Dmitry




_______________________________________________
nosql-dev mailing list
nosql-dev@xxxxxxxxxxx
To unsubscribe from this list, visit https://www.eclipse.org/mailman/listinfo/nosql-dev

--

Thanks a lot,

Twitter | Linkedin | Youtube

--

Thanks a lot,

Twitter | Linkedin | Youtube

_______________________________________________
nosql-dev mailing list
nosql-dev@xxxxxxxxxxx
To unsubscribe from this list, visit https://www.eclipse.org/mailman/listinfo/nosql-dev

_______________________________________________
nosql-dev mailing list
nosql-dev@xxxxxxxxxxx
To unsubscribe from this list, visit https://www.eclipse.org/mailman/listinfo/nosql-dev

--

Thanks a lot,

Twitter | Linkedin | Youtube