[Seasar-user:17670] Re: [dbflute-ignoreCase in conditionBean]使い方法

[kubo]

Hello,

https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-postgresql-example/src/test/java/com/example/dbflute/postgresql/dbflute/various/VendorCheckTest.java
For example, this test case works like this:
(PostgreSQL-8.3 on Windows XP)


ExampleDB's MEMBER table has the values:
(No record starts with lower case 's')

  Stojkovic
  Savicevic
  Stankovic
  ...

/= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
checkCB.query().setMemberName_LikeSearch("s", new
LikeSearchOption().likePrefix());
(where dflocal.member_name like 's%' escape '|')

  --> 0 hit
= = = = = = = = = =/
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
cb.query().setMemberName_LikeSearch("s", new LikeSearchOption() {
    @Override
    public ExtensionOperand getExtensionOperand() {
        return WayOfPostgreSQL.OperandOfLikeSearch.CASE_INSENSITIVE;
    }
}.likePrefix());
(where dflocal.member_name ilike 's%' escape '|')
                           ^^^^^

  --> several hits
  Stojkovic
  Savicevic
  Stankovic
  ...
= = = = = = = = = =/


On Tue, Jun 9, 2009 at 8:03 PM, kubo<[E-MAIL ADDRESS DELETED]> wrote:
> Hello,
>
> Please confirm your SQL on console log.
> Does the SQL use 'ilike'？
> (where EMPLOYEE_CODE ilike 'emp%')
>
> 2009/6/9 thomas <[E-MAIL ADDRESS DELETED]>:
>> hai,
>>
>> I upgraded my dbflute to 0.9.5.
>>
>> EmployeemasterCB empCB = employeemasterBhv.newMyConditionBean();
>>         empCB.query().setEmployeecode_LikeSearch("emp", new
>> LikeSearchOption() {
>>             @Override
>>             public ExtensionOperand getExtensionOperand() {
>>                 return WayOfPostgreSQL.OperandOfLikeSearch.CASE_INSENSITIVE;
>>             }
>>         }.likePrefix());
>>
>> if i give "emp" as search condition it retrieves only The values starts with
>> emp.
>>
>> InMy table i have the values
>>
>> emp22
>> EMP22
>> emp20
>> EMP20
>> .........
>> .........
>> ..........
>>
>> The above coding retrieves only emp22 and emp20
>> I want to retrieve EMP22 and EMP20 also.
>>
>>
>> Thanks
>> トマス
>>
>>
>>
>> 2009/6/9 thomas <[E-MAIL ADDRESS DELETED]>
>>>
>>> hai,
>>>
>>> Thanks for your helps!..
>>>
>>>
>>>
>>> On Tue, Jun 9, 2009 at 6:00 PM, kubo <[E-MAIL ADDRESS DELETED]> wrote:
>>>>
>>>> Hello,
>>>>
>>>> Sorry! I mistook your DBFlute version.
>>>> The method and class are supported since 0.9.5.
>>>> So please upgrade DBFlute to 0.9.5 if possible.
>>>>
>>>> 2009/6/9 thomas <[E-MAIL ADDRESS DELETED]>:
>>>> > hai,
>>>> >
>>>> > cb.query().setMemberName_
>>>> >>
>>>> >> LikeSearch("s", new LikeSearchOption() {
>>>> >>    @Override
>>>> >>    public ExtensionOperand getExtensionOperand() {
>>>> >>        return WayOfPostgreSQL.OperandOfLikeSearch.CASE_INSENSITIVE;
>>>> >>    }
>>>> >> }.likePrefix());
>>>> >
>>>> > import org.seasar.dbflute.dbway.ExtensionOperand;//Error
>>>> >
>>>> > there is no class in org.seasar.dbflute.dbway like ExtensionOperand
>>>> >
>>>> >
>>>> >
>>>> > 2009/6/9 kubo <[E-MAIL ADDRESS DELETED]>
>>>> >>
>>>> >> Hello,
>>>> >>
>>>> >> Please watch this test case:
>>>> >> The method is 'test_likeSearch_caseInsensitive_Tx()'.
>>>> >>
>>>> >>
>>>> >>
>>>> >> https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-postgresql-example/src/test/java/com/example/dbflute/postgresql/dbflute/various/VendorCheckTest.java
>>>> >>
>>>> >> cb.query().setMemberName_LikeSearch("s", new LikeSearchOption() {
>>>> >>    @Override
>>>> >>    public ExtensionOperand getExtensionOperand() {
>>>> >>        return WayOfPostgreSQL.OperandOfLikeSearch.CASE_INSENSITIVE;
>>>> >>    }
>>>> >> }.likePrefix());
>>>> >>
>>>> >> This code uses 'ilike' in the SQL.
>>>> >> (But this way is only available at PostgreSQL)
>>>> >>
>>>> >> If you have many many points that must be without case sensitive,
>>>> >> you should create CaseInsensitiveLikeSearchOption as your original
>>>> >> class.
>>>> >> Like this:
>>>> >>
>>>> >> public class CaseInsensitiveLikeSearchOption extends LikeSearchOption
>>>> >> {
>>>> >>    @Override
>>>> >>    public ExtensionOperand getExtensionOperand() {
>>>> >>        return WayOfPostgreSQL.OperandOfLikeSearch.CASE_INSENSITIVE;
>>>> >>    }
>>>> >> }
>>>> >>
>>>> >> 2009/6/9 thomas <[E-MAIL ADDRESS DELETED]>:
>>>> >> > Hai,
>>>> >> >
>>>> >> > I am using PostgresQL 8.3
>>>> >> >
>>>> >> >
>>>> >> >
>>>> >> >
>>>> >> > 2009/6/9 kubo <[E-MAIL ADDRESS DELETED]>
>>>> >> >>
>>>> >> >> Hello, this is jflute.
>>>> >> >>
>>>> >> >> For starters, there is one thing I want to confirm.
>>>> >> >> What kind of database do you use?
>>>> >> >> Oracle? MySQL? PostgreSQL? ...
>>>> >> >>
>>>> >> >> 2009/6/9 thomas <[E-MAIL ADDRESS DELETED]>:
>>>> >> >> > Hai,
>>>> >> >> >
>>>> >> >> > I want to retrieve data without case sensitive using condition
>>>> >> >> > Bean.
>>>> >> >> >
>>>> >> >> > dbflute version 0.9.4.1
>>>> >> >> >
>>>> >> >> > empCB.query().setEmployeecode_LikeSearch(empcodes,new
>>>> >> >> > LikeSearchOption());
>>>> >> >> >
>>>> >> >> > How to change this code to get case sensitive result?
>>>> >> >> >
>>>> >> >> > Please give steps to achieve this...
>>>> >> >> >
>>>> >> >> > Thanks in advance.
>>>> >> >> > トマス
>>>> >> >> >
>>>> >> >> >
>>>> >> >> > _______________________________________________
>>>> >> >> > Seasar-user mailing list
>>>> >> >> > [E-MAIL ADDRESS DELETED]
>>>> >> >> > https://ml.seasar.org/mailman/listinfo/seasar-user
>>>> >> >> >
>>>> >> >> >
>>>> >> >> _______________________________________________
>>>> >> >> Seasar-user mailing list
>>>> >> >> [E-MAIL ADDRESS DELETED]
>>>> >> >> https://ml.seasar.org/mailman/listinfo/seasar-user
>>>> >> >
>>>> >> >
>>>> >> > _______________________________________________
>>>> >> > Seasar-user mailing list
>>>> >> > [E-MAIL ADDRESS DELETED]
>>>> >> > https://ml.seasar.org/mailman/listinfo/seasar-user
>>>> >> >
>>>> >> >
>>>> >> _______________________________________________
>>>> >> Seasar-user mailing list
>>>> >> [E-MAIL ADDRESS DELETED]
>>>> >> https://ml.seasar.org/mailman/listinfo/seasar-user
>>>> >
>>>> >
>>>> > _______________________________________________
>>>> > Seasar-user mailing list
>>>> > [E-MAIL ADDRESS DELETED]
>>>> > https://ml.seasar.org/mailman/listinfo/seasar-user
>>>> >
>>>> >
>>>> _______________________________________________
>>>> Seasar-user mailing list
>>>> [E-MAIL ADDRESS DELETED]
>>>> https://ml.seasar.org/mailman/listinfo/seasar-user
>>>
>>
>>
>> _______________________________________________
>> Seasar-user mailing list
>> [E-MAIL ADDRESS DELETED]
>> https://ml.seasar.org/mailman/listinfo/seasar-user
>>
>>
>