OpenACS / openacs-4 / packages / acs-templating

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 9
Last Commit: 28 Nov
Commits this week: 0
Total Lines of Code (LoC): 1,179
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 17 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 11 Sep
8:11 am

gustafn

merge with missing files

Options
    • -0
    • +0
    ./oracle/acs-templating-create.sql
    • -0
    • +0
    ./postgresql/acs-templating-create.sql
  3. … 1463 more files in changeset.
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -1
    • +1
    ./oracle/acs-templating-create.sql
    • -1
    • +1
    ./postgresql/acs-templating-create.sql
  3. … 8098 more files in changeset.
Sunday 26 Jun 2022
1:06 pm

gustafn

removed code factored out to the separate "captcha" package

Options
    • -2
    • +1
    ./oracle/acs-templating-create.sql
    • -12
    • +0
    ./oracle/captcha-create.sql
    • -13
    • +0
    ./oracle/upgrade/upgrade-5.10.1d0-5.10.1d1.sql
    • -2
    • +1
    ./postgresql/acs-templating-create.sql
    • -10
    • +0
    ./postgresql/captcha-create.sql
    • -13
    • +0
    ./postgresql/upgrade/upgrade-5.10.1d0-5.10.1d1.sql
  7. … 6 more files in changeset.
Thursday 17 Feb 2022
4:20 pm

gustafn

Fixes for Oracle 19c: fix data types and interval calculation

Options
    • -8
    • +6
    ./oracle/captcha-create.sql
3:17 pm

antoniop

Don't use expressions for the default value, apparently a nono in Oracle

See e.g. https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqlj30540.html#rrefsqlj30540__sqlj64478

Options
    • -2
    • +7
    ./oracle/captcha-create.sql
    • -2
    • +1
    ./oracle/upgrade/upgrade-5.10.1d0-5.10.1d1.sql
Wednesday 26 Jan 2022
5:06 pm

antoniop

A simple image captcha implementation:

a random text is converted to a distorted image, its checksum, together with the expected text are stored in a lookup table. Upon validation, the text input by the user is matched against the checksum to determine if the captcha is correct.

Plan is to use it downstream on certain publicly available contact forms.

Options
    • -1
    • +2
    ./oracle/acs-templating-create.sql
    • -0
    • +9
    ./oracle/captcha-create.sql
    • -0
    • +14
    ./oracle/upgrade/upgrade-5.10.1d0-5.10.1d1.sql
    • -1
    • +2
    ./postgresql/acs-templating-create.sql
    • -0
    • +10
    ./postgresql/captcha-create.sql
    • -0
    • +13
    ./postgresql/upgrade/upgrade-5.10.1d0-5.10.1d1.sql
  7. … 3 more files in changeset.
5:06 pm

antoniop

file captcha-create.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./oracle/captcha-create.sql
    • -0
    • +0
    ./postgresql/captcha-create.sql
5:06 pm

antoniop

file upgrade-5.10.1d0-5.10.1d1.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.10.1d0-5.10.1d1.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.1d0-5.10.1d1.sql
Saturday 30 Mar 2013
8:09 pm

gustafn

- update postgres function to modern style plpgsql definitions using dollar quoting

Options
    • -92
    • +94
    ./postgresql/template-demo-notes-sample.sql
7:04 pm

gustafn

- update postgres function to modern style plpgsql definitions, avoid backslash escaping

- add missing function_args

Options
    • -68
    • +94
    ./postgresql/template-demo-notes-create.sql
    • -6
    • +13
    ./postgresql/template-demo-notes-drop.sql
  3. … 8 more files in changeset.
Tuesday 26 Sep 2006
5:13 pm

byronl

Correction of name constraint

Options
    • -1
    • +2
    ./oracle/demo-create.sql
  2. … 5 more files in changeset.
Monday 25 Sep 2006
11:20 pm

byronl

Correction of name constraint

Options
    • -1
    • +2
    ./postgresql/demo-create.sql
Monday 13 Feb 2006
12:45 pm

jiml

fix typo in the define_function_args call for template_demo_notes__new:

if you want to use package_instantiate_object using some type <t>, then

your call to define_function_args for <t>__new needs to have the object_type

parameter defaulting to <t>

Options
    • -2
    • +2
    ./postgresql/template-demo-notes-create.sql
Friday 10 Feb 2006
3:12 am

jiml

Turn on the data model loading under oracle. (yes, BOLD move :)

Options
    • -3
    • +3
    ./oracle/demo-create.sql
12:56 am

jiml

move the sample data include to where it belongs; reformat some code

Options
    • -0
    • +1
    ./postgresql/demo-create.sql
    • -13
    • +13
    ./postgresql/template-demo-notes-create.sql
12:00 am

hughb

fix Oracle bug (procedure cannot return a value)

Options
    • -1
    • +1
    ./oracle/template-demo-notes-sample.sql
Thursday 09 Feb 2006
2:58 pm

jiml

for oracle it's sysdate, not now()... corrected those.

Options
    • -20
    • +20
    ./oracle/template-demo-notes-sample.sql
7:47 am

jiml

activate the inserting of sample data on the postgres side; it works.

Options
    • -2
    • +2
    ./postgresql/template-demo-notes-create.sql
1:28 am

hughb

fix typos

Options
    • -2
    • +2
    ./oracle/template-demo-notes-create.sql
1:25 am

jiml

fix silly typos

Options
    • -3
    • +3
    ./oracle/template-demo-notes-create.sql
12:52 am

jiml

arrange to load sample data; commented out for now

Options
    • -1
    • +3
    ./oracle/demo-create.sql
12:34 am

jiml

create listbuilder sample data for oracle

Options
    • -0
    • +302
    ./oracle/template-demo-notes-sample.sql
Monday 06 Feb 2006
4:54 pm

jiml

disabled loading the renamed notes package, as it's untested on oracle

Options
    • -1
    • +2
    ./oracle/demo-create.sql
2:06 pm

jiml

add column "color" to template_demo_notes table; add display for it in list2,

add html row for list3 to the demo/index file

Options
    • -4
    • +17
    ./oracle/template-demo-notes-create.sql
    • -12
    • +30
    ./postgresql/template-demo-notes-create.sql
    • -1
    • +1
    ./postgresql/template-demo-notes-drop.sql
    • -32
    • +39
    ./postgresql/template-demo-notes-sample.sql
  5. … 4 more files in changeset.
7:53 am

jiml

fixed problem with sample data for acs-templating demos of listbuilder

Options
    • -8
    • +10
    ./postgresql/template-demo-notes-create.sql
    • -1
    • +0
    ./postgresql/template-demo-notes-drop.sql
    • -68
    • +55
    ./postgresql/template-demo-notes-sample.sql
    • -66
    • +0
    ./postgresql/template-demo-notes-sc-create.sql
    • -18
    • +0
    ./postgresql/template-demo-notes-sc-drop.sql
Sunday 05 Feb 2006
5:38 am

jiml

sample data is not working, so disable that function (so acs-templating

can install...)

Options
    • -1
    • +1
    ./postgresql/template-demo-notes-sample.sql
4:36 am

jiml

fix typos in data model, add sample data for demo

Options
    • -3
    • +4
    ./postgresql/template-demo-notes-create.sql
    • -0
    • +314
    ./postgresql/template-demo-notes-sample.sql
    • -3
    • +3
    ./postgresql/template-demo-notes-sc-create.sql
    • -3
    • +3
    ./postgresql/template-demo-notes-sc-drop.sql
Saturday 04 Feb 2006
2:54 am

jiml

notes-like data model for templating demo page to facilitate listbuilder tut

Options
    • -0
    • +2
    ./oracle/demo-create.sql
    • -1
    • +3
    ./oracle/demo-drop.sql
    • -0
    • +150
    ./oracle/template-demo-notes-create.sql
    • -0
    • +4
    ./oracle/template-demo-notes-drop.sql
    • -0
    • +3
    ./postgresql/demo-create.sql
    • -1
    • +3
    ./postgresql/demo-drop.sql
    • -0
    • +163
    ./postgresql/template-demo-notes-create.sql
    • -0
    • +54
    ./postgresql/template-demo-notes-drop.sql
    • -0
    • +66
    ./postgresql/template-demo-notes-sc-create.sql
    • -0
    • +18
    ./postgresql/template-demo-notes-sc-drop.sql
Wednesday 20 Feb 2002
10:07 pm

bartt

Fixed the 'Simple Form' and 'Editing: several pages in one' demos.

Run demo-drop and then demo-create scripts in Postgresql to take advantage

of this fix in a running system.

Options
    • -0
    • +1
    ./postgresql/demo-create.sql
  2. … 3 more files in changeset.
Friday 27 Apr 2001
4:27 am

danw

ported templating to use standard db api

Options
    • -0
    • +12
    ./postgresql/acs-templating-create.sql
    • -0
    • +9
    ./postgresql/acs-templating-drop.sql
    • -0
    • +26
    ./postgresql/demo-create.sql
    • -0
    • +10
    ./postgresql/demo-drop.sql
  5. … 24 more files in changeset.