• last updated 6 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

1. Added a new Tcl procedure to the content repository's library, named

cr_write_content, which properly writes content to the connection

regardless of RDBMS and storage type. This simplified a bunch of stuff

(which explains the removed files).

2. Fixed a lot of general comments issues regarding HTML vs. Plain/Text,

attachments, etc.

3. Partially ported glossary.

    • -15
    • +0
    ./tcl/download-procs-postgresql.xql
  1. … 75 more files in changeset.
adjusted .info files to reflect OpenACS

  1. … 4 more files in changeset.
removed requirement on acs-notifications

  1. … 7 more files in changeset.
converted notification calls to acs_mail_nt calls

    • -1
    • +1
    ./www/admin/approve-or-reject-2-oracle.xql
    • -7
    • +8
    ./www/admin/approve-or-reject-2-postgresql.xql
  1. … 7 more files in changeset.
fixed to use new acs-mail notifications

    • -11
    • +8
    ./www/admin/spam-users-2-postgresql.xql
re-enabled acs-messaging snippet

Cleaned datamodel (number->numeric)

temporarily removed dependencies on acs-messaging

fixed oracle datamodel scripts

    • -12
    • +23
    ./sql/oracle/download-create.sql
fixed a bug that i caused by switching a $ to a : in a db_write_blob call

Fixed aD's incorrect use of nvl2

Fixed aD's reuse of the dimensional var which messed up the QD

    • -3
    • +4
    ./www/admin/approve-or-reject-oracle.xql
    • -3
    • +5
    ./www/admin/approve-or-reject-postgresql.xql
    • -1
    • +1
    ./www/admin/report-one-user-oracle.xql
    • -1
    • +1
    ./www/admin/report-version-downloads-oracle.xql
    • -1
    • +1
    ./www/admin/report-version-downloads.adp
    • -1
    • +1
    ./www/admin/report-version-downloads.tcl
fixed outer join bugs

    • -32
    • +43
    ./www/admin/report-version-downloads-postgresql.xql
    • -49
    • +58
    ./www/admin/repository-metadata.xql
minor cleanup

    • -14
    • +15
    ./sql/postgresql/download-drop.sql
    • -59
    • +69
    ./tcl/download-procs-postgresql.xql
added query files for ad_table calls

    • -1
    • +1
    ./www/admin/approve-or-reject-oracle.xql
    • -1
    • +1
    ./www/admin/approve-or-reject-postgresql.xql
    • -0
    • +48
    ./www/admin/report-by-ip-oracle.xql
    • -0
    • +50
    ./www/admin/report-by-ip-postgresql.xql
    • -0
    • +46
    ./www/admin/report-by-user-oracle.xql
    • -0
    • +48
    ./www/admin/report-by-user-postgresql.xql
    • -0
    • +54
    ./www/admin/report-one-ip-oracle.xql
    • -0
    • +60
    ./www/admin/report-one-ip-postgresql.xql
    • -0
    • +52
    ./www/admin/report-one-user-oracle.xql
    • -0
    • +57
    ./www/admin/report-one-user-postgresql.xql
  1. … 8 more files in changeset.
added file_size to pg datamodel, pg queries. Moved calc (size = bytes/1024) from tcl to sql

    • -1
    • +25
    ./sql/postgresql/download-create.sql
    • -23
    • +24
    ./sql/postgresql/download-drop.sql
    • -1
    • +1
    ./www/admin/approve-or-reject-postgresql.xql
Added db_map for oracle-specific partial queries.

Fixed problem caused by dimensional being used twice (renamed to

dimensional_html)

Fixed problem that had set archive_type_id to 'All' (not an integer)

aD used the var 'dimensional' in a query and then reassigned it, so when

the query dispatcher tries to acces 'dimensional', it accesses the wrong

one. renamed the second use to dimensional_html

added partial queries

Added partial queries

fixed more queries

    • -8
    • +0
    ./www/admin/repository-ae-postgresql.xql
fixed sequences. Updated functions. Improved drop script

    • -3
    • +2
    ./sql/postgresql/download-packages.sql
changed to consistent sequence names

initial porting of queries

    • -17
    • +19
    ./tcl/download-procs-postgresql.xql
    • -24
    • +51
    ./www/archive-add-2-postgresql.xql
    • -2
    • +6
    ./www/admin/approve-or-reject-2-postgresql.xql
    • -1
    • +1
    ./www/admin/approve-or-reject-postgresql.xql
    • -19
    • +23
    ./www/admin/repository-ae-postgresql.xql
    • -1
    • +1
    ./www/admin/spam-users-2-postgresql.xql
more porting to postgres

    • -0
    • +8
    ./sql/postgresql/download-packages.sql
extracted queries

    • -0
    • +90
    ./tcl/download-procs-oracle.xql
    • -0
    • +94
    ./tcl/download-procs-postgresql.xql
    • -0
    • +115
    ./tcl/download-procs.xql
    • -0
    • +17
    ./www/all-metadata.xql
    • -0
    • +48
    ./www/archive-add-2-oracle.xql
    • -0
    • +49
    ./www/archive-add-2-postgresql.xql
    • -0
    • +22
    ./www/archive-add.xql
    • -0
    • +11
    ./www/archive-version-add-2.xql
    • -0
    • +25
    ./www/archive-version-add-oracle.xql
    • -0
    • +25
    ./www/archive-version-add-postgresql.xql
    • -0
    • +22
    ./www/archive-version-add.xql
    • -0
    • +27
    ./www/download-verify-oracle.xql
    • -0
    • +27
    ./www/download-verify-postgresql.xql
    • -0
    • +26
    ./www/index-oracle.xql
    • -0
    • +26
    ./www/index-postgresql.xql
  1. … 32 more files in changeset.
updated info file and extracted queries

ported the datamodel

    • -0
    • +418
    ./sql/postgresql/download-create.sql
    • -0
    • +166
    ./sql/postgresql/download-drop.sql
    • -0
    • +255
    ./sql/postgresql/download-packages.sql

Forgot to define binary files before importing, so .gifs were messed up.

  1. … 2465 more files in changeset.
Initial revision

    • -0
    • +280
    ./sql/oracle/download-create.sql
    • -0
    • +97
    ./sql/oracle/download-drop.sql
    • -0
    • +152
    ./sql/oracle/download-packages.sql
    • -0
    • +373
    ./tcl/download-procs.tcl
    • -0
    • +52
    ./www/all-metadata.tcl
    • -0
    • +94
    ./www/archive-add-2.tcl
    • -0
    • +57
    ./www/archive-add.adp
    • -0
    • +40
    ./www/archive-add.tcl
    • -0
    • +46
    ./www/archive-version-add-2.tcl
    • -0
    • +35
    ./www/archive-version-add.adp
    • -0
    • +58
    ./www/archive-version-add.tcl
    • -0
    • +27
    ./www/download-verify.adp
    • -0
    • +51
    ./www/download-verify.tcl
  1. … 2465 more files in changeset.