How can I get a table object's contains operator t...

# exposed

[Hullaballoonatic]

How can I get a table object's contains operator to differentiate between parameters corresponding to different fields that are both strings?

I'm currently writing out different classes for each string to accomplish this, but if there's an easier way, i'm all ears.

e.g.

operator fun contains(username: String): Boolean = UserEntity.find { self.username eq username }.count() > 0
operator fun contains(email: Email): Boolean = UserEntity.find { self.email eq email }.count() > 0

also if there's a more efficient way to write a contains function, i wouldn't be surprised in the slightest

[tapac]

count could be very slow if you dont have index or table has a lot of records.
I prefer :
select { self.email eq email }.limit(1).any()

[tapac]

Also, you can try to rewrite contains like this:

operator fun <T:String?> contains(pair : Pair<Column<T>, String>) = select { pair.first eq stringParam(pair.second)}.limit(1).any()
...
UserEntity.email to email in UserEntity