Author: keith
Date: Wed Apr 23 07:12:33 2008
New Revision: 16060
Log:
Fixing more SQLs due to registry changes
Modified:
trunk/mashup/java/modules/javascriptdeployer/src/org/wso2/mashup/deployer/JSDeployer.java
Modified:
trunk/mashup/java/modules/javascriptdeployer/src/org/wso2/mashup/deployer/JSDeployer.java
==============================================================================
---
trunk/mashup/java/modules/javascriptdeployer/src/org/wso2/mashup/deployer/JSDeployer.java
(original)
+++
trunk/mashup/java/modules/javascriptdeployer/src/org/wso2/mashup/deployer/JSDeployer.java
Wed Apr 23 07:12:33 2008
@@ -1150,7 +1150,7 @@
addQuery(
systemRegistry,
MashupConstants.TOP_MASHUPS_QUERY_PATH,
- "SELECT A.PATH FROM RESOURCE A, RATINGS R WHERE " +
+ "SELECT A.PATH FROM RESOURCE A, RATING R WHERE " +
"A.AID=R.AID AND (A.MEDIA_TYPE='" +
MashupConstants.MASHUP_MEDIA_TYPE + "' OR " +
"A.MEDIA_TYPE='wso2_data_service') GROUP BY
A.PATH HAVING " +
@@ -1162,7 +1162,7 @@
addQuery(
systemRegistry,
MashupConstants.MY_TOP_MASHUPS_QUERY_PATH,
- "SELECT A.PATH FROM RESOURCE A, RATINGS R WHERE " +
+ "SELECT A.PATH FROM RESOURCE A, RATING R WHERE " +
"A.AID=R.AID AND A.CREATOR=? AND
(A.MEDIA_TYPE='" +
MashupConstants.MASHUP_MEDIA_TYPE + "' OR " +
"A.MEDIA_TYPE='wso2_data_service') GROUP BY
A.PATH HAVING " +
@@ -1196,7 +1196,7 @@
addQuery(
systemRegistry,
MashupConstants.USER_TAGS_QUERY_PATH,
- "SELECT A.PATH FROM RESOURCE A, TAGS T WHERE A.PATH=?
" +
+ "SELECT A.PATH FROM RESOURCE A, TAG T WHERE A.PATH=? "
+
"AND T.TAG_NAME=? AND T.AID=A.AID AND
T.USER_ID=? AND " +
"(A.MEDIA_TYPE='" +
MashupConstants.MASHUP_MEDIA_TYPE +
"' OR A.MEDIA_TYPE='wso2_data_service')",
@@ -1208,7 +1208,7 @@
addQuery(
systemRegistry,
MashupConstants.CUSTOM_QUERY_PATH,
- "SELECT DISTINCT A.PATH FROM RESOURCE A, TAGS T WHERE
AND " +
+ "SELECT DISTINCT A.PATH FROM RESOURCE A, TAG T WHERE
AND " +
"(A.PATH LIKE ? OR A.DESCRIPTION LIKE ? OR
(T.TAG_NAME=? AND " +
"T.AID=A.AID)) AND (A.MEDIA_TYPE='" +
MashupConstants.MASHUP_MEDIA_TYPE +
"' OR A.MEDIA_TYPE='wso2_data_service')",
@@ -1220,7 +1220,7 @@
addQuery(
systemRegistry,
MashupConstants.MY_CUSTOM_QUERY_PATH,
- "SELECT DISTINCT A.PATH FROM RESOURCE A, TAGS T WHERE
AND " +
+ "SELECT DISTINCT A.PATH FROM RESOURCE A, TAG T WHERE
AND " +
"(A.PATH LIKE ? OR A.DESCRIPTION LIKE ? OR
(T.TAG_NAME=? AND " +
"T.AID=A.AID)) AND A.CREATOR=? AND
(A.MEDIA_TYPE='" +
MashupConstants.MASHUP_MEDIA_TYPE +
@@ -1232,7 +1232,7 @@
addQuery(
systemRegistry,
MashupConstants.COMMENTS_QUERY_PATH,
- "SELECT C.CM_ID FROM COMMENTS C, RESOURCE A WHERE
C.COMMENT_TEXT " +
+ "SELECT C.CM_ID FROM COMMENT C, RESOURCE A WHERE
C.COMMENT_TEXT " +
"LIKE ? AND C.AID=A.AID AND (A.MEDIA_TYPE='" +
MashupConstants.MASHUP_MEDIA_TYPE +
"' OR A.MEDIA_TYPE='wso2_data_service')",
@@ -1243,7 +1243,7 @@
addQuery(
systemRegistry,
MashupConstants.MY_COMMENTS_QUERY_PATH,
- "SELECT C.CM_ID FROM COMMENTS C, RESOURCE A WHERE
C.COMMENT_TEXT " +
+ "SELECT C.CM_ID FROM COMMENT C, RESOURCE A WHERE
C.COMMENT_TEXT " +
"LIKE ? AND C.USER_ID=? AND C.AID=A.AID AND " +
"(A.MEDIA_TYPE='" +
MashupConstants.MASHUP_MEDIA_TYPE +
"' OR A.MEDIA_TYPE='wso2_data_service')",
@@ -1254,7 +1254,7 @@
addQuery(
systemRegistry,
MashupConstants.USERS_COMMENTS_QUERY_PATH,
- "SELECT C.CM_ID FROM COMMENTS C, RESOURCE A WHERE
C.USER_ID=? AND " +
+ "SELECT C.CM_ID FROM COMMENT C, RESOURCE A WHERE
C.USER_ID=? AND " +
"C.AID=A.AID AND AND (A.MEDIA_TYPE='" +
MashupConstants.MASHUP_MEDIA_TYPE +
"' OR A.MEDIA_TYPE='wso2_data_service')",
_______________________________________________
Mashup-dev mailing list
[email protected]
http://www.wso2.org/cgi-bin/mailman/listinfo/mashup-dev
