OpenACS / openacs-4 / packages / acs-subsite

tcl

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 43
Last Commit: 17 Dec
Commits this week: 0
Total Lines of Code (LoC): 9,856
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 23 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Sunday 13 Feb 2022
5:46 pm

gustafn

Fixes for Oracle 19c recursive query

Oracle has a slightly differnt syntax for CTEs require arguments, keyword "recursive" is not allowed.

This fixes the following error during initial installation:

nsoracle.c:1367:OracleSelect: error in `OCIStmtExecute ()': ORA-00905: missing keyword

SQL:

with recursive !>>>!object_hierarchy as (

select object_type, supertype

from acs_object_types

where object_type = coalesce(:object_type, (select object_type

from acs_objects

where object_id = :object_id))

union all

select t.object_type, t.supertype

from acs_object_types t,

object_hierarchy s

where t.object_type = s.supertype

)

select distinct callback, callback_type as type

from subsite_callbacks

where event_type = :event_type

and object_type in (select object_type from object_hierarchy)

Options
    • -0
    • +30
    ./subsite-callback-procs-oracle.xql
    • -0
    • +30
    ./subsite-callback-procs-postgresql.xql
    • -21
    • +2
    ./subsite-callback-procs.tcl
Tuesday 28 Dec 2021
3:54 pm

antoniop

Streamline ns_set idiom

Options
    • -5
    • +2
    ./package-procs.tcl
  2. … 2 more files in changeset.
Tuesday 19 Oct 2021
10:32 am

gustafn

improve safety of SQL queries

Options
    • -5
    • +4
    ./attribute-procs.tcl
    • -2
    • +2
    ./package-procs.tcl
    • -2
    • +2
    ./subsite-procs.tcl
  4. … 2 more files in changeset.
Tuesday 14 Sep 2021
8:01 pm

gustafn

whitespace changes

Options
    • -96
    • +96
    ./package-procs-postgresql.xql
    • -2
    • +2
    ./package-procs.tcl
Monday 28 Jun 2021
10:41 am

hectorr

Make package_id explicit

Options
    • -2
    • +3
    ./test/acs-subsite-procs.tcl
Friday 25 Jun 2021
3:54 pm

hectorr

Add 'acs_subsite_rel_segment_new' test case, covering 'rel_segment::new', 'rel_segment::delete' and 'group::get_rel_segment'

Options
    • -1
    • +42
    ./test/acs-subsite-procs.tcl
1:23 pm

hectorr

Add 'acs_subsite_application_group_new' test case, covering 'application_group::new' and 'application_group::delete'

Options
    • -1
    • +31
    ./test/acs-subsite-procs.tcl
1:14 pm

hectorr

Add 'acs_subsite_rel_type_roles' test case, covering 'rel_types::create_role' and 'rel_types::create_role'

Options
    • -1
    • +37
    ./test/acs-subsite-procs.tcl
Thursday 24 Jun 2021
4:18 pm

hectorr

Add 'acs_subsite_relation_procs' test case, covering 'relation_add', 'relation_remove', 'relation::get_object_one', 'relation::get_object_two', 'relation::get_objects' and 'relation::get_id'

Options
    • -1
    • +77
    ./test/acs-subsite-procs.tcl
Thursday 11 Mar 2021
6:17 pm

hectorr

Whitespace changes

Options
    • -2
    • +1
    ./test/acs-subsite-procs.tcl
Saturday 06 Mar 2021
9:01 pm

gustafn

improve test coverage

Options
    • -2
    • +2
    ./plsql-utility-procs.tcl
    • -4
    • +4
    ./subsite-procs.tcl
    • -1
    • +16
    ./test/acs-subsite-procs.tcl
Monday 01 Mar 2021
3:59 pm

hectorr

Add 'acs_subsite_attribute_datatypes' test case, covering 'attribute::translate_datatype' and 'attribute::datatype_validator_exists_p' procs

Options
    • -1
    • +50
    ./test/acs-subsite-procs.tcl
3:15 pm

hectorr

Remove unnecessary aliases

Options
    • -12
    • +12
    ./attribute-procs.tcl
3:14 pm

hectorr

Add 'attribute::value_add' and 'attribute::value_delete' to the 'acs_subsite_attributes' test case

Options
    • -1
    • +27
    ./test/acs-subsite-procs.tcl
Saturday 27 Feb 2021
9:19 pm

gustafn

complete listing of covered procs in test cases

Options
    • -1
    • +3
    ./test/acs-subsite-procs.tcl
  2. … 14 more files in changeset.
1:29 am

hectorr

Remove leftovers

Options
    • -4
    • +1
    ./test/acs-subsite-procs.tcl
Friday 26 Feb 2021
6:13 pm

hectorr

Whitespace changes

Options
    • -7
    • +8
    ./test/acs-subsite-procs.tcl
6:12 pm

hectorr

Add new test 'acs_subsite_attributes' covering the 'attribute::add', 'attribute::exists_p' and 'attribute::delete' procs

Options
    • -1
    • +82
    ./test/acs-subsite-procs.tcl
Wednesday 17 Feb 2021
9:20 am

gustafn

prefer ns_dbquotevalue over db_quote, mark latter as deprecated

Options
    • -2
    • +2
    ./plpgsql-utility-procs.tcl
  2. … 3 more files in changeset.
Tuesday 16 Feb 2021
9:59 pm

gustafn

improve listing of test coverage

Options
    • -5
    • +12
    ./test/acs-subsite-procs.tcl
  2. … 17 more files in changeset.
Sunday 14 Feb 2021
10:05 pm

gustafn

make listing of tested procs more complete

Options
    • -3
    • +11
    ./test/acs-subsite-procs.tcl
  2. … 11 more files in changeset.
Monday 01 Feb 2021
11:58 am

gustafn

make end of options explicit

Options
    • -2
    • +2
    ./group-procs.tcl
    • -3
    • +3
    ./plsql-utility-procs.tcl
    • -3
    • +3
    ./subsite-procs.tcl
  4. … 15 more files in changeset.
Tuesday 19 Jan 2021
2:01 pm

gustafn

address issue #3456

Options
    • -10
    • +39
    ./subsite-procs.tcl
Monday 18 Jan 2021
9:13 pm

gustafn

fix typos

Options
    • -3
    • +3
    ./subsite-procs.tcl
7:10 pm

gustafn

fix for issue #3455

Options
    • -9
    • +15
    ./subsite-procs.tcl
Wednesday 28 Oct 2020
4:39 pm

hectorr

Prefer 'namespace which' over 'info commands', as it is faster (on local tests, around 2x) and returns a single value. Many thanks to Nathan Coulter.

Options
    • -2
    • +2
    ./apm-callback-procs.tcl
    • -2
    • +2
    ./attribute-procs.tcl
  3. … 57 more files in changeset.
Saturday 17 Oct 2020
6:40 pm

gustafn

prefer db_0or1row for exists-queries

Options
    • -4
    • +2
    ./group-procs.tcl
Sunday 27 Sep 2020
1:12 pm

gustafn

support passing a dict as argument to "group::update" (not only array)

Options
    • -12
    • +19
    ./group-procs.tcl
Thursday 03 Sep 2020
11:16 am

gustafn

prefer db_0or1row +"where exists" over db_string + "select case"

Options
    • -5
    • +3
    ./attribute-procs.tcl
  2. … 3 more files in changeset.
Tuesday 01 Sep 2020
7:37 pm

antoniop

Improve sql portability

Options
    • -5
    • +7
    ./attribute-procs.tcl
    • -4
    • +6
    ./group-procs.tcl
    • -6
    • +10
    ./group-type-procs.tcl
    • -3
    • +6
    ./subsite-procs.tcl
    • -12
    • +15
    ./test/acs-subsite-procs.tcl
  6. … 1 more file in changeset.