• last updated 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fix typos

    • -1
    • +1
    ./oracle/survey-notifications-init.sql
  1. … 28 more files in changeset.
- brace expressions

- favor tcl-compilable string comparisons

- replace deprecated "ad_get_user_id" by "ad_conn user_id"

- replace deprecated "export_url_vars" by "export_vars"

- replace deprecated "export_form_vars" by "export_vars"

- replace deprecated "philg_quote_double_quotes" "by ad_quotehtml"

- replace deprecated "ad_parameter" by "parameter::get"

- replace deprecated "ad_require_permission" by "permission::require_permission"

- use $$ quoting in postgres SQL

- use named parameters for SQL functions

- provide compatility with pg9

- fix/complete define_function_args

- bumped version number to 5.8.0

    • -151
    • +254
    ./postgresql/survey-create.sql
    • -16
    • +22
    ./postgresql/survey-notifications-drop.sql
    • -25
    • +31
    ./postgresql/survey-notifications-init.sql
  1. … 47 more files in changeset.
fixing uninstall for survey

- deinstall service contracts and notification types

- care about "drop funcion .... cascade"

    • -0
    • +50
    ./postgresql/survey-notifications-drop.sql
- adjust formatting of stored procedure to usual OpenACS guidelines

fix formatting to conform to usual OpenACS style

commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

  1. … 2274 more files in changeset.
upgrade script from prior bug fix

file upgrade-5.0.0b4-5.0.0-b5.apm was initially added on branch oacs-5-1.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.0.0b4-5.0.0-b5.apm
making it so the original respondent is listed instead of the admin

  1. … 3 more files in changeset.
merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

  1. … 598 more files in changeset.
typo in survey_responses_latest fixes bug 1147

Removed calls to useless survey-response.initial_response_id pl/sql function. Replace with speedy nvl call.

  1. … 4 more files in changeset.
Added upgrade to upgrade to changes made for Oracle 9i support

    • -0
    • +466
    ./oracle/upgrade/upgrade-0.1d-0.2d.sql
  1. … 23 more files in changeset.
Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

    • -0
    • +1
    ./oracle/survey-notifications-init.sql
  1. … 274 more files in changeset.
using named parameters in call to acs_sc_impl.new to avoid mismatch with new optional pretty name parameter

    • -3
    • +3
    ./oracle/survey-notifications-init.sql
  1. … 26 more files in changeset.
Moved function call to nvl/coalesce

added missing ;

Replace function call with nvl in survey_response.initial_user_id

Speed up survey_response__initial_user_id by turning a function call

into coalesce.

merge of 4.6.3b1 to HEAD

  1. … 17 more files in changeset.
I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

  1. … 14 more files in changeset.
forgot about all of the trigger work-arounds for data-change violation problem that no longer exists. Fixed now.

  1. … 7 more files in changeset.
Renamed primary key constraint on survey_responses from srvsimp_resp_response_id_pk to survey_resp_respose_id_pk to resolve a conflict with the constraint name in simple-survey.

Changed name of constraint from srvsimp_responses_resp_id_pk to

survey_responses_resp_id_pk. This will only cause an error if you install

simple survey and survey at the same time.

merge from oacs-4-6

    • -29
    • +38
    ./postgresql/survey-notifications-init.sql
  1. … 26 more files in changeset.
call survey-notifications-init.sql

merge fixes into 4.6 branch

    • -1
    • +1
    ./postgresql/survey-notifications-init.sql
source notifications init file

source notificiations-init.sql file

fix service contract file. unported from oracle.

    • -27
    • +37
    ./postgresql/survey-notifications-init.sql