Author: keith Date: Wed Feb 11 21:56:02 2009 New Revision: 30684 URL: http://wso2.org/svn/browse/wso2?view=rev&revision=30684
Log: Fixing MASHUP-1071 Modified: branches/mashup/java/1.5/java/modules/core/src/org/wso2/mashup/RegistryInitializer.java Modified: branches/mashup/java/1.5/java/modules/core/src/org/wso2/mashup/RegistryInitializer.java URL: http://wso2.org/svn/browse/wso2/branches/mashup/java/1.5/java/modules/core/src/org/wso2/mashup/RegistryInitializer.java?rev=30684&r1=30683&r2=30684&view=diff ============================================================================== --- branches/mashup/java/1.5/java/modules/core/src/org/wso2/mashup/RegistryInitializer.java (original) +++ branches/mashup/java/1.5/java/modules/core/src/org/wso2/mashup/RegistryInitializer.java Wed Feb 11 21:56:02 2009 @@ -358,7 +358,7 @@ addQuery( systemRegistry, MashupConstants.MY_MASHUPS_QUERY_PATH, - "SELECT PATH FROM RESOURCE WHERE CREATOR=? AND " + + "SELECT PATH FROM RESOURCE WHERE UCASE(CREATOR)=UCASE(?) AND " + "(MEDIA_TYPE='" + MashupConstants.MASHUP_MEDIA_TYPE + "' OR " + "MEDIA_TYPE='wso2_data_service') ORDER BY LAST_UPDATED_TIME DESC", RegistryConstants.RESOURCES_RESULT_TYPE @@ -381,7 +381,7 @@ systemRegistry, MashupConstants.MY_TOP_MASHUPS_QUERY_PATH, "SELECT A.PATH FROM RESOURCE A, RATING R WHERE " + - "A.RID=R.RID AND A.CREATOR=? AND (A.MEDIA_TYPE='" + + "A.RID=R.RID AND UCASE(A.CREATOR)=UCASE(?) AND (A.MEDIA_TYPE='" + MashupConstants.MASHUP_MEDIA_TYPE + "' OR " + "A.MEDIA_TYPE='wso2_data_service') GROUP BY A.PATH HAVING " + "AVG(R.RATING) >= 4.0 ORDER BY AVG(R.RATING) DESC", @@ -394,8 +394,8 @@ addQuery( systemRegistry, MashupConstants.USER_TAGS_QUERY_PATH, - "SELECT A.PATH FROM RESOURCE A, TAG T WHERE A.PATH=? " + - "AND T.TAG_NAME=? AND T.RID=A.RID AND T.USER_ID=? AND " + + "SELECT A.PATH FROM RESOURCE A, TAG T WHERE UCASE(A.PATH)=UCASE(?) " + + "AND UCASE(T.TAG_NAME)=UCASE(?) AND T.RID=A.RID AND UCASE(T.USER_ID)=UCASE(?) AND " + "(A.MEDIA_TYPE='" + MashupConstants.MASHUP_MEDIA_TYPE + "' OR A.MEDIA_TYPE='wso2_data_service')", RegistryConstants.RESOURCES_RESULT_TYPE @@ -407,7 +407,7 @@ systemRegistry, MashupConstants.CUSTOM_QUERY_PATH, "SELECT DISTINCT A.PATH FROM RESOURCE A, TAG T WHERE " + - "(A.PATH LIKE ? OR A.DESCRIPTION LIKE ? OR (T.TAG_NAME=? AND " + + "(UCASE(A.PATH) LIKE UCASE(?) OR UCASE(A.DESCRIPTION) LIKE UCASE(?) OR (UCASE(T.TAG_NAME)=UCASE(?) AND " + "T.RID=A.RID)) AND (A.MEDIA_TYPE='" + MashupConstants .MASHUP_MEDIA_TYPE + "' OR A.MEDIA_TYPE='wso2_data_service')", @@ -420,8 +420,8 @@ systemRegistry, MashupConstants.MY_CUSTOM_QUERY_PATH, "SELECT DISTINCT A.PATH FROM RESOURCE A, TAG T WHERE " + - "(A.PATH LIKE ? OR A.DESCRIPTION LIKE ? OR (T.TAG_NAME=? AND " + - "T.RID=A.RID)) AND A.CREATOR=? AND (A.MEDIA_TYPE='" + + "(UCASE(A.PATH) LIKE UCASE(?) OR UCASE(A.DESCRIPTION) LIKE UCASE(?) OR (UCASE(T.TAG_NAME)=UCASE(?) AND " + + "T.RID=A.RID)) AND UCASE(A.CREATOR)=UCASE(?) AND (A.MEDIA_TYPE='" + MashupConstants.MASHUP_MEDIA_TYPE + "' OR A.MEDIA_TYPE='wso2_data_service')", RegistryConstants.RESOURCES_RESULT_TYPE @@ -431,8 +431,8 @@ addQuery( systemRegistry, MashupConstants.COMMENTS_QUERY_PATH, - "SELECT C.COMMENT_ID FROM COMMENT C, RESOURCE A WHERE C.COMMENT_TEXT " + - "LIKE ? AND C.RID=A.RID AND (A.MEDIA_TYPE='" + + "SELECT C.COMMENT_ID FROM COMMENT C, RESOURCE A WHERE UCASE(C.COMMENT_TEXT) " + + "LIKE UCASE(?) AND C.RID=A.RID AND (A.MEDIA_TYPE='" + MashupConstants.MASHUP_MEDIA_TYPE + "' OR A.MEDIA_TYPE='wso2_data_service')", RegistryConstants.COMMENTS_RESULT_TYPE @@ -442,8 +442,8 @@ addQuery( systemRegistry, MashupConstants.MY_COMMENTS_QUERY_PATH, - "SELECT C.COMMENT_ID FROM COMMENT C, RESOURCE A WHERE C.COMMENT_TEXT " + - "LIKE ? AND C.USER_ID=? AND C.RID=A.RID AND " + + "SELECT C.COMMENT_ID FROM COMMENT C, RESOURCE A WHERE UCASE(C.COMMENT_TEXT) " + + "LIKE UCASE(?) AND UCASE(C.USER_ID)=UCASE(?) AND C.RID=A.RID AND " + "(A.MEDIA_TYPE='" + MashupConstants.MASHUP_MEDIA_TYPE + "' OR A.MEDIA_TYPE='wso2_data_service')", RegistryConstants.COMMENTS_RESULT_TYPE @@ -453,7 +453,7 @@ addQuery( systemRegistry, MashupConstants.USERS_COMMENTS_QUERY_PATH, - "SELECT C.COMMENT_ID FROM COMMENT C, RESOURCE A WHERE C.USER_ID=? AND " + + "SELECT C.COMMENT_ID FROM COMMENT C, RESOURCE A WHERE UCASE(C.USER_ID)=UCASE(?) AND " + "C.RID=A.RID AND (A.MEDIA_TYPE='" + MashupConstants.MASHUP_MEDIA_TYPE + "' OR A.MEDIA_TYPE='wso2_data_service')", _______________________________________________ Mashup-dev mailing list [email protected] https://wso2.org/cgi-bin/mailman/listinfo/mashup-dev
