OpenACS / openacs-4 / packages / survey / sql

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 5
Last Commit: 12:54
Commits this week: 0
Total Lines of Code (LoC): 916
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 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
    ./survey-create.sql
    • -27
    • +27
    ./survey-drop.sql
    • -16
    • +22
    ./survey-notifications-drop.sql
    • -25
    • +31
    ./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
    ./survey-drop.sql
    • -0
    • +50
    ./survey-notifications-drop.sql
Friday 19 Sep 2008
10:04 pm

gustafn

- adjust formatting of stored procedure to usual OpenACS guidelines

Options
    • -3
    • +3
    ./survey-create.sql
9:58 pm

gustafn

fix formatting to conform to usual OpenACS style

Options
    • -3
    • +3
    ./survey-create.sql
Thursday 12 Jun 2003
5:54 am

daveb

Moved function call to nvl/coalesce

Options
    • -6
    • +7
    ./survey-create.sql
  2. … 1 more file in changeset.
5:03 am

daveb

added missing ;

Options
    • -2
    • +2
    ./survey-create.sql
4:56 am

daveb

Speed up survey_response__initial_user_id by turning a function call

into coalesce.

Options
    • -4
    • +7
    ./survey-create.sql
Saturday 17 May 2003
2:25 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -2
    • +2
    ./survey-create.sql
  2. … 18 more files in changeset.
Sunday 02 Mar 2003
11:52 pm

donb

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 ...

Options
    • -3
    • +3
    ./survey-create.sql
  2. … 14 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
    ./survey-create.sql
  2. … 7 more files in changeset.
Saturday 30 Nov 2002
6:42 pm

jeffd

merge from oacs-4-6

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

daveb

call survey-notifications-init.sql

Options
    • -2
    • +3
    ./survey-create.sql
3:18 am

daveb

merge fixes into 4.6 branch

Options
    • -1
    • +1
    ./survey-notifications-init.sql
3:12 am

daveb

source notifications init file

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

daveb

source notificiations-init.sql file

Options
    • -1
    • +2
    ./survey-create.sql
Thursday 07 Nov 2002
5:02 am

daveb

fix service contract file. unported from oracle.

Options
    • -27
    • +37
    ./survey-notifications-init.sql
4:32 am

daveb

fix question_delete (change to remove)

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

daveb

fix abstract data type for postgresql, add blob

Options
    • -2
    • +2
    ./survey-create.sql
Monday 28 Oct 2002
3:10 am

daveb

remove "untested" comment

Options
    • -1
    • +0
    ./survey-notifications-init.sql
Saturday 26 Oct 2002
6:29 pm

daveb

clean up del/remove functions

Options
    • -9
    • +9
    ./survey-create.sql
1:29 pm

jeffd

error v_section_row used rather than v_question_row bug 1790/patch 495

Options
    • -3
    • +3
    ./survey-create.sql
Wednesday 23 Oct 2002
9:30 pm

daveb

fix postgresql data model

Options
    • -28
    • +89
    ./survey-create.sql
  2. … 2 more files in changeset.
6:16 pm

daveb

fix foreign key constraint to refer to cr_revisions instead of cr_items

Options
    • -2
    • +2
    ./survey-create.sql
5:07 am

daveb

add "blob" as choice for survey_questions.abstract_data_type check constraint

Options
    • -2
    • +2
    ./survey-create.sql
Tuesday 22 Oct 2002
9:53 pm

daveb

remove scored survey stuff from drop script, it isn't created so does not

need to be dropped.

Options
    • -10
    • +1
    ./survey-drop.sql
Monday 16 Sep 2002
3:04 am

daveb

fix postgresql create and drop scripts

Options
    • -30
    • +20
    ./survey-create.sql
    • -3
    • +3
    ./survey-drop.sql
  3. … 3 more files in changeset.
1:56 am

daveb

initial import

Options
    • -0
    • +567
    ./survey-create.sql
    • -0
    • +76
    ./survey-drop.sql
    • -0
    • +62
    ./survey-notifications-init.sql
  4. … 167 more files in changeset.