Fisheye: Tag 1.1.10.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-admin/www/apm/version-fs-scan.xql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/acs-service-contract/tcl/acs-service-contract-init.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/tcl/acs-service-contract-init.tcl,v
diff -u -r1.4 -r1.4.4.1
--- openacs-4/packages/acs-service-contract/tcl/acs-service-contract-init.tcl 16 Oct 2002 15:10:04 -0000 1.4
+++ openacs-4/packages/acs-service-contract/tcl/acs-service-contract-init.tcl 3 Dec 2003 22:19:05 -0000 1.4.4.1
@@ -9,7 +9,7 @@
acs_sc_log SCDebug "ACS_SC_PROC: checking binding exists for contract $impl_contract_name impl $impl_name"
- set binding_exists_p [db_string binding_exists_p {select acs_sc_binding__exists_p(:impl_contract_name,:impl_name)}]
+ set binding_exists_p [db_string binding_exists_p {*SQL*}]
if $binding_exists_p {
acs_sc_proc $impl_contract_name $impl_operation_name $impl_name
Index: openacs-4/packages/acs-service-contract/tcl/acs-service-contract-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/tcl/Attic/acs-service-contract-procs-oracle.xql,v
diff -u -r1.1 -r1.1.10.1
--- openacs-4/packages/acs-service-contract/tcl/acs-service-contract-procs-oracle.xql 9 Oct 2001 04:57:37 -0000 1.1
+++ openacs-4/packages/acs-service-contract/tcl/acs-service-contract-procs-oracle.xql 3 Dec 2003 22:19:05 -0000 1.1.10.1
@@ -10,6 +10,35 @@
</querytext>
</fullquery>
+<fullquery name="acs_sc_get_alias.get_alias">
+<querytext>
+ select
+ element_name,
+ acs_sc_msg_type.get_name(element_msg_type_id) as element_msg_type_name,
+ element_msg_type_isset_p,
+ element_pos
+ from acs_sc_msg_type_elements
+ where msg_type_id = :operation_outputtype_id
+ order by element_pos asc
+</querytext>
+</fullquery>
+
+
+<fullquery name="acs_sc_proc.get_operation_definition">
+<querytext>
+ select
+ operation_desc,
+ operation_iscachable_p,
+ operation_nargs,
+ operation_inputtype_id,
+ operation_outputtype_id
+ from acs_sc_operations
+ where contract_name = :contract
+ and operation_name = :operation
+</querytext>
+</fullquery>
+
+
<fullquery name="acs_sc_proc.operation_inputtype_element">
<querytext>
select
Index: openacs-4/packages/acs-service-contract/tcl/acs-service-contract-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/tcl/acs-service-contract-procs.tcl,v
diff -u -r1.19.2.1 -r1.19.2.2
--- openacs-4/packages/acs-service-contract/tcl/acs-service-contract-procs.tcl 14 Nov 2003 09:36:22 -0000 1.19.2.1
+++ openacs-4/packages/acs-service-contract/tcl/acs-service-contract-procs.tcl 3 Dec 2003 22:19:05 -0000 1.19.2.2
@@ -77,7 +77,7 @@
@author Neophytos Demetriou
} {
- return [db_string binding_exists_p {select acs_sc_binding__exists_p(:contract,:impl)}]
+ return [db_string binding_exists_p {*SQL*}]
}
@@ -107,18 +107,12 @@
} {
# LARS
set exists_p [acs_sc_binding_exists_p $contract $impl]
-
+
#set exists_p [util_memoize "acs_sc_binding_exists_p $contract $impl"]
-
+
if ![set exists_p] {return ""}
- db_0or1row get_alias {
- select impl_alias, impl_pl
- from acs_sc_impl_aliases
- where impl_contract_name = :contract
- and impl_operation_name = :operation
- and impl_name = :impl
- }
+ db_0or1row get_alias {*SQL*}
return [list $impl_alias $impl_pl]
@@ -151,50 +145,22 @@
error "ACS-SC: Cannot find alias for $proc_name"
}
- if {![db_0or1row get_operation_definition {
- select
- operation_desc,
- operation_iscachable_p,
- operation_nargs,
- operation_inputtype_id,
- operation_outputtype_id
- from acs_sc_operations
- where contract_name = :contract
- and operation_name = :operation
- }]} {
+ if {![db_0or1row get_operation_definition {*SQL*}]} {
ns_log warning "ACS-SC: operation definition not found for contract $contract operation $operation"
return 0
}
append docblock "\n<b>acs-service-contract operation. Call via acs_sc_call.</b>\n\n$operation_desc\n\n"
- db_foreach operation_inputtype_element {
- select
- element_name,
- acs_sc_msg_type__get_name(element_msg_type_id) as element_msg_type_name,
- element_msg_type_isset_p,
- element_pos
- from acs_sc_msg_type_elements
- where msg_type_id = :operation_inputtype_id
- order by element_pos asc
- } {
+ db_foreach operation_inputtype_element {*SQL*} {
lappend arguments "$element_name"
append docblock "\n@param $element_name $element_msg_type_name"
if { $element_msg_type_isset_p } {
append docblock " \[\]"
}
}
- db_foreach operation_outputtype_element {
- select
- element_name,
- acs_sc_msg_type__get_name(element_msg_type_id) as element_msg_type_name,
- element_msg_type_isset_p,
- element_pos
- from acs_sc_msg_type_elements
- where msg_type_id = :operation_outputtype_id
- order by element_pos asc
- } {
+ db_foreach operation_outputtype_element {*SQL*} {
append docblock "\n@return <b>$element_name</b> - $element_msg_type_name"
if { $element_msg_type_isset_p } {
append docblock " \[\]"
Index: openacs-4/packages/acs-subsite/www/admin/rel-segments/elements-display-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/rel-segments/Attic/elements-display-oracle.xql,v
diff -u -r1.1 -r1.1.10.1
--- openacs-4/packages/acs-subsite/www/admin/rel-segments/elements-display-oracle.xql 11 Aug 2001 21:31:03 -0000 1.1
+++ openacs-4/packages/acs-subsite/www/admin/rel-segments/elements-display-oracle.xql 3 Dec 2003 22:19:05 -0000 1.1.10.1
@@ -1,5 +1,5 @@
<?xml version="1.0"?>
-
+<!-- used in elements-display.adp ... ugh -->
<queryset>
<rdbms><type>oracle</type><version>8.1.6</version></rdbms>
Index: openacs-4/packages/acs-subsite/www/admin/rel-segments/elements-display-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/rel-segments/Attic/elements-display-postgresql.xql,v
diff -u -r1.1 -r1.1.10.1
--- openacs-4/packages/acs-subsite/www/admin/rel-segments/elements-display-postgresql.xql 11 Aug 2001 21:31:03 -0000 1.1
+++ openacs-4/packages/acs-subsite/www/admin/rel-segments/elements-display-postgresql.xql 3 Dec 2003 22:19:05 -0000 1.1.10.1
@@ -1,5 +1,5 @@
<?xml version="1.0"?>
-
+<!-- used in elements-display.adp ... ugh -->
<queryset>
<rdbms><type>postgresql</type><version>7.1</version></rdbms>
Fisheye: Tag 1.2.10.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-subsite/www/user/basic-info-update-2.xql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/acs-templating/tcl/widget-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/tcl/Attic/widget-procs-oracle.xql,v
diff -u -r1.3 -r1.3.2.1
--- openacs-4/packages/acs-templating/tcl/widget-procs-oracle.xql 12 Oct 2003 18:03:22 -0000 1.3
+++ openacs-4/packages/acs-templating/tcl/widget-procs-oracle.xql 3 Dec 2003 22:19:05 -0000 1.3.2.1
@@ -1,6 +1,8 @@
<?xml version="1.0"?>
<queryset>
+<rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
<fullquery name="template::data::transform::party_search.search_persons">
<querytext>
select (first_names || ' ' || last_name) as name, pe.person_id from persons pe, parties pa
Index: openacs-4/packages/acs-templating/tcl/widget-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/tcl/Attic/widget-procs-postgresql.xql,v
diff -u -r1.2 -r1.2.2.1
--- openacs-4/packages/acs-templating/tcl/widget-procs-postgresql.xql 10 Oct 2003 08:23:23 -0000 1.2
+++ openacs-4/packages/acs-templating/tcl/widget-procs-postgresql.xql 3 Dec 2003 22:19:05 -0000 1.2.2.1
@@ -1,5 +1,6 @@
<?xml version="1.0"?>
<queryset>
+<rdbms><type>postgresql</type><version>7.1</version></rdbms>
<fullquery name="template::data::transform::party_search.search_persons">
<querytext>
Index: openacs-4/packages/ecommerce/www/admin/orders/one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/one-postgresql.xql,v
diff -u -r1.2 -r1.2.2.1
--- openacs-4/packages/ecommerce/www/admin/orders/one-postgresql.xql 30 Nov 2002 17:31:38 -0000 1.2
+++ openacs-4/packages/ecommerce/www/admin/orders/one-postgresql.xql 3 Dec 2003 22:19:05 -0000 1.2.2.1
@@ -1,5 +1,6 @@
<?xml version="1.0"?>
<queryset>
+<rdbms><type>postgresql</type><version>7.1</version></rdbms>
<fullquery name="order_select">
<querytext>
Index: openacs-4/packages/logger/www/admin/entries-table-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/logger/www/admin/entries-table-oracle.xql,v
diff -u -r1.1 -r1.1.6.1
--- openacs-4/packages/logger/www/admin/entries-table-oracle.xql 8 May 2003 13:56:04 -0000 1.1
+++ openacs-4/packages/logger/www/admin/entries-table-oracle.xql 3 Dec 2003 22:19:05 -0000 1.1.6.1
@@ -1,6 +1,7 @@
<?xml version="1.0"?>
<queryset>
+<rdbms><type>oracle</type><version>8.1.6</version></rdbms>
<fullquery name="select_entries">
<querytext>
Index: openacs-4/packages/news-aggregator-portlet/www/news-aggregator-portlet-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator-portlet/www/news-aggregator-portlet-oracle.xql,v
diff -u -r1.2 -r1.2.2.1
--- openacs-4/packages/news-aggregator-portlet/www/news-aggregator-portlet-oracle.xql 28 Aug 2003 09:41:58 -0000 1.2
+++ openacs-4/packages/news-aggregator-portlet/www/news-aggregator-portlet-oracle.xql 3 Dec 2003 22:19:05 -0000 1.2.2.1
@@ -1,7 +1,7 @@
<?xml version="1.0"?>
<queryset>
-<rdbms><type>postgresql</type><version>7.1</version></rdbms>
+<rdbms><type>oracle</type><version>8.1.6</version></rdbms>
<fullquery name="select_items">
<querytext>
Index: openacs-4/packages/wp-slim/www/style-list-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/wp-slim/www/style-list-postgresql.xql,v
diff -u -r1.2 -r1.2.2.1
--- openacs-4/packages/wp-slim/www/style-list-postgresql.xql 28 Aug 2003 09:42:00 -0000 1.2
+++ openacs-4/packages/wp-slim/www/style-list-postgresql.xql 3 Dec 2003 22:19:06 -0000 1.2.2.1
@@ -1,6 +1,7 @@
<?xml version="1.0"?>
<queryset>
+<rdbms><type>postgresql</type><version>7.1</version></rdbms>
<fullquery name="style_select_data">
<querytext>