Morphological query Morphia mongoDB

Question

A direct-directed question, does anyone know how to make a template query using the morphine associated with the mongoDB database?

Here is what the mongo expression should look like:

Mongo: db.users.find({name:/Joe/})
SQL: SELECT * FROM users WHERE name LIKE "%Joe%"

My application for morphine looks like this:

ds.find(File.class, "filename","/test/").order("filename").asList(); : ds.find(File.class, "filename","/test/").order("filename").asList();

I have file names in my database such as test1, test, etc.

If someone can tell me if this is possible with morphine, that would be very helpful.

thanks

Answer 1

What you call a "wildcard" is actually a "Regular Expression" .

The Java class that represents regular expressions is Pattern . You can pass them to the filter method of the Morphia Query object.

 // create a regular expression which matches any string which includes "test" Pattern regexp = Pattern.compile("test"); // use this regular expression to create a query Query q = ds.createQuery(File.class).filter("filename", regexp).sort("filename"); 

Answer 2

It will also work

 DS.find(Model.class).field("filename").startsWithIgnoreCase("name").asList(); 

Answer 3

You can also:

 ds.createQuery(File.class) .criteria("filename").contains("test") .asList();