0

So... Is there a way to do something like this?

class Kitty {
    String name
    String nickName
    public static String getExpectedNickname(String name) {
        return name.replaceAll('Mr. ', '')
    }
    static namedQueries = {
        byKityWithPredictableNickname {
            ilike 'name', '%Kitty%'
            ilike 'nickName', Kitty.getExpectedNickname('name')
        }
    }
}

Can I reference the value of the current row's column value somehow? I thought property('name') would work, but alas, no.

EDIT:

Another example: I thought something like this would work... but it doesn't :( ...

static namedQueries = {
    whyDoesntThisReturnEverything {
        int c = Kitty.bySubQuery(id).count() //returns everything when I put "1" instead of "id"
        c == 1
    }
    bySubQuery { Long paramId ->
        eq 'id', paramId
    }
}

Instead I get some stupid illegal argument exception:

java.lang.ClassCastException@2af65a43. Stacktrace follows:
Message: java.lang.ClassCastException@2af65a43
    Line | Method
->>   -1 | invoke                                in sun.reflect.GeneratedMethodAccessor327
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
|     43 | invoke                                in sun.reflect.DelegatingMethodAccessorImpl
|    606 | invoke . . . . . . . . . . . . . . .  in java.lang.reflect.Method
|   1254 | jlrMethodInvoke                       in org.springsource.loaded.ri.ReflectiveInterceptor
|     90 | invoke . . . . . . . . . . . . . . .  in org.codehaus.groovy.reflection.CachedMethod
|     57 | getProperty                           in groovy.lang.MetaBeanProperty
...
SnoopDougg
  • 1,467
  • 2
  • 19
  • 35

1 Answers1

0

I think the only way to do this is through sqlRestriction.

//...
static namedQueries = {
    findAllKitty {
        ilike 'name', '%Kitty%'
    }

    findAllByNickNameLikeName {
        sqlRestriction "nick_name like '%' || replace(name, 'Mr. ', '') || '%' "
    }
}

//to use:
Kitty.findAllByNickNameLikeName().list()

The SQL syntax will probably change depending on the database you are using.

Victor
  • 5,043
  • 3
  • 41
  • 55
  • I'm not sure I follow... Why do you have everything ('%') or-ed twice? And won't replace return a String not a boolean? I've edited my original question with an additional example of the kind of thing I hoped would work. – SnoopDougg Oct 20 '14 at 18:22
  • According to your example you want all objects that ```nickName ilike name (- 'Mr. ')```, and this is what the namedQuery ```findAllByNickNameLikeName``` do. I just put the ```'%'``` as an example, but the following will work too: ```sqlRestriction "nick_name like replace(name, 'Mr. ', '')"``` – Victor Oct 20 '14 at 18:39