OpenACS / openacs-4 / packages / survey

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 9
Last Commit: 02 May
Commits this week: 0
Total Lines of Code (LoC): 2,253
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 29 Mar 2018
7:28 pm

hectorr

Fix typos

Options
    • -1
    • +1
    ./oracle/survey-notifications-init.sql
  2. … 28 more files in changeset.
Wednesday 06 Nov 2013
8:33 am

gustafn

- 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

Options
    • -151
    • +254
    ./postgresql/survey-create.sql
    • -27
    • +27
    ./postgresql/survey-drop.sql
    • -16
    • +22
    ./postgresql/survey-notifications-drop.sql
    • -25
    • +31
    ./postgresql/survey-notifications-init.sql
  5. … 47 more files in changeset.
Saturday 20 Sep 2008
1:45 pm

gustafn

fixing uninstall for survey

- deinstall service contracts and notification types

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

Options
    • -4
    • +8
    ./postgresql/survey-drop.sql
    • -0
    • +50
    ./postgresql/survey-notifications-drop.sql
Friday 19 Sep 2008
9:58 pm

gustafn

fix formatting to conform to usual OpenACS style

Options
    • -3
    • +3
    ./postgresql/survey-create.sql
Thursday 13 Jan 2005
2:54 pm

jeffd

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

Options
    • -2
    • +4
    ./oracle/survey-package-create.sql
    • -0
    • +16
    ./oracle/upgrade/upgrade-5.0.0b4-5.0.0-b5.apm
  3. … 2274 more files in changeset.
Wednesday 01 Sep 2004
9:08 pm

tracya

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

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.0.0b4-5.0.0-b5.apm
Thursday 11 Dec 2003
10:39 pm

jeffd

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

Options
    • -1
    • +1
    ./oracle/survey-package-create.sql
  2. … 598 more files in changeset.
Friday 10 Oct 2003
4:41 pm

daveb

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

Options
    • -4
    • +3
    ./oracle/survey-package-create.sql
  2. … 4 more files in changeset.
Wednesday 08 Oct 2003
6:53 pm

mohanp

Added upgrade to upgrade to changes made for Oracle 9i support

Options
    • -0
    • +466
    ./oracle/upgrade/upgrade-0.1d-0.2d.sql
  2. … 23 more files in changeset.
Tuesday 30 Sep 2003
2:10 pm

mohanp

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)

Options
    • -0
    • +1
    ./oracle/survey-notifications-init.sql
    • -5
    • +5
    ./oracle/survey-package-create.sql
  3. … 274 more files in changeset.
Wednesday 17 Sep 2003
3:58 pm

peterm

using named parameters in call to acs_sc_impl.new to avoid mismatch with new optional pretty name parameter

Options
    • -3
    • +3
    ./oracle/survey-notifications-init.sql
  2. … 26 more files in changeset.
Thursday 12 Jun 2003
5:54 am

daveb

Moved function call to nvl/coalesce

Options
    • -3
    • +5
    ./oracle/survey-package-create.sql
    • -6
    • +7
    ./postgresql/survey-create.sql
Saturday 17 May 2003
2:25 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -1
    • +1
    ./oracle/survey-create.sql
    • -2
    • +2
    ./postgresql/survey-create.sql
  3. … 17 more files in changeset.
Sunday 23 Feb 2003
7:19 pm

danw

forgot about all of the trigger work-arounds for data-change violation problem that no longer exists. Fixed now.

Options
    • -12
    • +1
    ./postgresql/survey-create.sql
  2. … 7 more files in changeset.
Sunday 09 Feb 2003
1:38 am

daveb

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.

Options
    • -2
    • +2
    ./oracle/survey-create.sql
Saturday 30 Nov 2002
6:42 pm

jeffd

merge from oacs-4-6

Options
    • -2
    • +2
    ./postgresql/survey-create.sql
    • -10
    • +1
    ./postgresql/survey-drop.sql
    • -29
    • +38
    ./postgresql/survey-notifications-init.sql
  4. … 26 more files in changeset.
Friday 22 Nov 2002
3:12 am

daveb

source notifications init file

Options
    • -29
    • +90
    ./postgresql/survey-create.sql
2:57 am

daveb

source notificiations-init.sql file

Options
    • -1
    • +2
    ./postgresql/survey-create.sql
Thursday 31 Oct 2002
4:51 pm

daveb

fix abstract data type for postgresql, add blob

Options
    • -2
    • +2
    ./postgresql/survey-create.sql
Monday 16 Sep 2002
3:04 am

daveb

fix postgresql create and drop scripts

Options
    • -30
    • +0
    ./oracle/diff
    • -4
    • +3
    ./oracle/survey-drop.sql
    • -30
    • +20
    ./postgresql/survey-create.sql
    • -3
    • +3
    ./postgresql/survey-drop.sql
  5. … 1 more file in changeset.
1:56 am

daveb

initial import

Options
    • -0
    • +30
    ./oracle/diff
    • -0
    • +242
    ./oracle/survey-create.sql
    • -0
    • +60
    ./oracle/survey-drop.sql
    • -0
    • +62
    ./oracle/survey-notifications-init.sql
    • -0
    • +484
    ./oracle/survey-package-create.sql
    • -0
    • +4
    ./oracle/survey-package-drop.sql
    • -0
    • +567
    ./postgresql/survey-create.sql
    • -0
    • +76
    ./postgresql/survey-drop.sql
    • -0
    • +62
    ./postgresql/survey-notifications-init.sql
  10. … 161 more files in changeset.