svn commit: r1448032 - in /openmeetings/trunk/singlewebapp/src/org/apache/openmeetings: data/user/dao/StateDao.java persistence/beans/user/State.java test/user/TestStateToLower.java

[sebawagner]

Author: sebawagner
Date: Wed Feb 20 08:18:34 2013
New Revision: 1448032

URL: http://svn.apache.org/r1448032
Log:
Remove lower and add testcase

Added:
    
openmeetings/trunk/singlewebapp/src/org/apache/openmeetings/test/user/TestStateToLower.java
Modified:
    
openmeetings/trunk/singlewebapp/src/org/apache/openmeetings/data/user/dao/StateDao.java
    
openmeetings/trunk/singlewebapp/src/org/apache/openmeetings/persistence/beans/user/State.java

Modified: 
openmeetings/trunk/singlewebapp/src/org/apache/openmeetings/data/user/dao/StateDao.java
URL: 
http://svn.apache.org/viewvc/openmeetings/trunk/singlewebapp/src/org/apache/openmeetings/data/user/dao/StateDao.java?rev=1448032&r1=1448031&r2=1448032&view=diff
==============================================================================
--- 
openmeetings/trunk/singlewebapp/src/org/apache/openmeetings/data/user/dao/StateDao.java
 (original)
+++ 
openmeetings/trunk/singlewebapp/src/org/apache/openmeetings/data/user/dao/StateDao.java
 Wed Feb 20 08:18:34 2013
@@ -124,7 +124,7 @@ public class StateDao {
                                return ll.get(0);
                        }
                } catch (Exception ex2) {
-                       log.error("getStateById", ex2);
+                       log.error("getStateByName", ex2);
                }
                return null;
        }

Modified: 
openmeetings/trunk/singlewebapp/src/org/apache/openmeetings/persistence/beans/user/State.java
URL: 
http://svn.apache.org/viewvc/openmeetings/trunk/singlewebapp/src/org/apache/openmeetings/persistence/beans/user/State.java?rev=1448032&r1=1448031&r2=1448032&view=diff
==============================================================================
--- 
openmeetings/trunk/singlewebapp/src/org/apache/openmeetings/persistence/beans/user/State.java
 (original)
+++ 
openmeetings/trunk/singlewebapp/src/org/apache/openmeetings/persistence/beans/user/State.java
 Wed Feb 20 08:18:34 2013
@@ -36,7 +36,7 @@ import javax.persistence.Table;
                        "where c.state_id = :state_id AND c.deleted <> 
:deleted"),
        @NamedQuery(name = "getStates", query = "select c from State as c where 
c.deleted <> :deleted"),
        @NamedQuery(name = "getStateByName", query = "select c from State as c 
" +
-                       "where lower(c.name) LIKE lower(:name) AND c.deleted <> 
:deleted")
+                       "where c.name LIKE :name AND c.deleted <> :deleted")
 })
 @Table(name = "state")
 public class State implements Serializable {

Added: 
openmeetings/trunk/singlewebapp/src/org/apache/openmeetings/test/user/TestStateToLower.java
URL: 
http://svn.apache.org/viewvc/openmeetings/trunk/singlewebapp/src/org/apache/openmeetings/test/user/TestStateToLower.java?rev=1448032&view=auto
==============================================================================
--- 
openmeetings/trunk/singlewebapp/src/org/apache/openmeetings/test/user/TestStateToLower.java
 (added)
+++ 
openmeetings/trunk/singlewebapp/src/org/apache/openmeetings/test/user/TestStateToLower.java
 Wed Feb 20 08:18:34 2013
@@ -0,0 +1,30 @@
+package org.apache.openmeetings.test.user;
+
+import static org.junit.Assert.assertTrue;
+
+import org.apache.openmeetings.data.user.dao.StateDao;
+import org.apache.openmeetings.persistence.beans.user.State;
+import org.apache.openmeetings.test.AbstractOpenmeetingsSpringTest;
+import org.junit.Test;
+import org.springframework.beans.factory.annotation.Autowired;
+
+public class TestStateToLower extends AbstractOpenmeetingsSpringTest {
+       
+       @Autowired
+       private StateDao stateDao;
+       
+       @Test
+       public void doTestQuery() {
+               
+               State state_alabania = stateDao.getStateByName("Albania");
+               
+               State state_alabania_lower = stateDao.getStateByName("albaNia");
+               
+               assertTrue(state_alabania != null);
+               assertTrue(state_alabania_lower != null);
+               assertTrue(state_alabania.getState_id().equals(3L));
+               
assertTrue(state_alabania.getState_id().equals(state_alabania_lower.getState_id()));
+               
+       }
+
+}