Feature: Select Model without using Record-IDs

[047massi]

Is your feature request related to a problem?

Select a Model by using e.g. a Username instead of a Record ID

Describe the solution

i think it would be better to select a model by like using a username from a column instead to use a record id.

Alternative methods

I came to an idea to add something like a .where("key", "value") method to the end of driver.select(...) Example: User user = driver.select("table", User.class).where("key", "value"))

SurrealDB version

1.0.0-beta.9+20230402.5eafebd for windows on x86_64

Contact Details

No response

Is there an existing issue for this?

• [x] I have searched the existing issues

Code of Conduct

• [x] I agree to follow this project's Code of Conduct

[mnbjhu]

This is an interesting idea, although I think it's worth mentioning:

• You wouldn't be able to use the ws method for select (see: https://surrealdb.com/docs/integration/websocket/text#select)
• The select function doesn't return a builder but a result of the select, I think it would have to look something like this:

  driver.selectBuilder(...).where(...).where(...).execute()

• I think you'd have to pass the class of the element into the where function similar to select:

  ...
  .where("key", "value", String.class)
  .where("user_details", new UserDetails("john.smith@test.com", 25), UserDetails.class)

[emmanuel-keller]

With version 0.2.0, the select method now has several variants, allowing for the selection of a table. https://surrealdb.github.io/surrealdb.java/javadoc/com/surrealdb/Surreal.html#select(java.lang.Class,java.lang.String)