Fisheye: history OpenACS/openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql

14 Jun 18

antoniop

More
1.23
on
MAIN
- -14
- +0

Put redundant query definition into generic ones

Revision ID:: 1.23
Changeset ID:: MAIN:antoniop:20180614144359
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.22
Branch points:: oacs-5-10
Tags:: oacs-5-10$BP openacs-5-10-compat openacs-5-10-0b1 openacs-5-10-0-final openacs-5-10-1-final
Head on:: MAIN

25 Sep 17

antoniop

More
1.22
on
MAIN
- -11
- +0

Remove usage of apm_package_version__version_name_greater in favor of apm_version_names_compare proc as their logics conflict

Revision ID:: 1.22
Changeset ID:: MAIN:antoniop:20170925175921
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.21

08 Aug 17

gustafn

More
1.21
on
MAIN
- -19
- +2

merged changes from the oacs-5-9 branch and resolved conflicts

Revision ID:: 1.21
Changeset ID:: MAIN:gustafn:20170807234743
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.20

07 Aug 17

gustafn

More
1.20.8.3
on
oacs-5-9
- -2
- +8

undo untested last minute check

Revision ID:: 1.20.8.3
Changeset ID:: oacs-5-9:gustafn:20170807211123
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.20.8.2
Tags:: openacs-5-9-compat openacs-5-9-1-final openacs-5-9
Head on:: oacs-5-9

07 Aug 17

Unify version comparison logics so we always use apm_version_names_compare instead of other db api as apm_package_version__version_name_greater plus handcrafted queries which also might behave slightly differently

Revision ID:: 1.20.8.2
Changeset ID:: oacs-5-9:antoniop:20170807133417
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.20.8.1

02 Jan 16

gustafn

More
1.20.8.1
on
oacs-5-9
- -11
- +0

.xql-file reform of acs-tcl (part 3)

- remove obsolete queries

ad_acs_admin_id.acs_admin_id_get

ad_db_select_widget.currency_info

ad_maybe_redirect_for_registration.sql_test_1

ad_maybe_redirect_for_registration.sql_test_2

ad_permission_p.n_privs

ad_user_class_query.sql_post_select_for_user_class

apm_file_add.apm_file_add

apm_file_remove.apm_file_remove

apm_package_install.version_exists_p

site_node::get_url_from_object_id.select_url_from_object_id

user_search

- remove obsolete files

tcl/00-database-procs-postgresql-postgresql.xql

tcl/00-database-procs-postgresql.tcl

tcl/defs-procs-oracle.xql

tcl/defs-procs-postgresql.xql

tcl/deprecated-utilities-procs.xql

tcl/request-processor-init.xql

tcl/request-processor-procs-oracle.xql

tcl/request-processor-procs-postgresql.xql

tcl/widgets-procs.xql

.xql-file reform of acs-tcl (part 3)

- remove obsolete queries

ad_acs_admin_id.acs_admin_id_get

ad_db_select_widget.currency_info

ad_maybe_redirect_for_registration.sql_test_1

ad_maybe_redirect_for_registration.sql_test_2

ad_permission_p.n_privs

ad_user_class_query.sql_post_select_for_user_class

apm_file_add.apm_file_add

apm_file_remove.apm_file_remove

apm_package_install.version_exists_p

site_node::get_url_from_object_id.select_url_from_object_id

user_search

- remove obsolete files

tcl/00-database-procs-postgresql-postgresql.xql

tcl/00-database-procs-postgresql.tcl

tcl/defs-procs-oracle.xql

tcl/defs-procs-postgresql.xql

tcl/deprecated-utilities-procs.xql

tcl/request-processor-init.xql

tcl/request-processor-procs-oracle.xql

tcl/request-processor-procs-postgresql.xql

tcl/widgets-procs.xql

Revision ID:: 1.20.8.1
Changeset ID:: oacs-5-9:gustafn:20160102112234
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.20
Tags:: openacs-5-9-1b1 openacs-5-9-1b3

31 Mar 10

donb

More
1.20
on
MAIN
- -2
- +2

Finished up PG semantics for global/instance parameters on package upgrade.

The Tcl API stuff to do this should technically be moved down into the

oracle/PG API but 1) it's a fair amount of db-specific work and 2) people

should be using the high level constructs in the first place (and why do

people explicitly register new parameters when they're registered from the

package info file on upgrade in the first place?)

Finished up PG semantics for global/instance parameters on package upgrade.

The Tcl API stuff to do this should technically be moved down into the

oracle/PG API but 1) it's a fair amount of db-specific work and 2) people

should be using the high level constructs in the first place (and why do

people explicitly register new parameters when they're registered from the

package info file on upgrade in the first place?)

Revision ID:: 1.20
Changeset ID:: MAIN:donb:20100331180859
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.19
Branch points:: oacs-5-6 oacs-5-7 oacs-5-8 oacs-5-9
Tags:: oacs-5-8$BP vg-merge-oacs-5-8-from-20141027 openacs-5-8-compat vg-merge-oacs-5-8-from-20150427 openacs-5-8-0-final openacs-5-8-1-final oacs-5-9$BP openacs-5-9-0-final oacs-5-6$BP drb-branch-5-6-20100404 drb-merge-HEAD-from-20101017 openacs-5-6-0a2 openacs-5-6-0a1 openacs-5-6-0-final openacs-5-6-0b2 openacs-5-6-0b1 openacs-5-7-0-final oacs-5-7$BP drb-merge-5-6-pre-20110731 drb-merge-5-6-pre-20101017 openacs-5-7-0b1 drb-merge-5-6-post-20110731 drb-branch-5-7-2011-05-01 drb-merge-5-6-post-20101017 openacs-5-6-0b3 drb-merge-HEAD-from-20110731 dotlrn-2-6-0-final openacs-5-9-0b1 openacs-5-9-0b2 openacs-5-7-compat openacs-5-6-compat oacs-5-8-2013_09_09_10 (+28 more)

31 Mar 10

donb

More
1.19
on
MAIN
- -1
- +1

Making global/instance changes work with Oracle

Revision ID:: 1.19
Changeset ID:: MAIN:donb:20100331012100
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.18

31 Mar 10

donb

More
1.18
on
MAIN
- -22
- +22

More code dealing with instance and global parameter semantics. I finally

have a reasonable model of inheritance and semantics implemented, not

perfect from a language-theoretic point of view, but works well without

having to rewrite every bit of parameter-handling code in acs-core.

More code dealing with instance and global parameter semantics. I finally

have a reasonable model of inheritance and semantics implemented, not

perfect from a language-theoretic point of view, but works well without

having to rewrite every bit of parameter-handling code in acs-core.

Revision ID:: 1.18
Changeset ID:: MAIN:donb:20100331004616
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.17

10 Mar 10

donb

More
1.17
on
MAIN
- -0
- +20

1. Changed trigger functions from "opaque" to "trigger" to get rid of the

warnings during initial install (only for acs-kernel, there are a lot

elsewhere!)

2. Added "embeds" for postgresql and partially for oracle.

3. Added global parameters for postgresql and partially for oracle.

(oracle will be forthcoming shortly)

1. Changed trigger functions from "opaque" to "trigger" to get rid of the

warnings during initial install (only for acs-kernel, there are a lot

elsewhere!)

2. Added "embeds" for postgresql and partially for oracle.

3. Added global parameters for postgresql and partially for oracle.

(oracle will be forthcoming shortly)

Revision ID:: 1.17
Changeset ID:: MAIN:donb:20100310004403
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.16

19 Jan 10

donb

More
1.16
on
MAIN
- -2
- +2

Fixed bug (missing ";" before "end")

Revision ID:: 1.16
Changeset ID:: MAIN:donb:20100119225425
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.15

19 Jan 10

donb

More
1.15
on
MAIN
- -36
- +25

Fixed the copying of inherited and descendent parameters for extending or

embedding packages.

Fixed the copying of inherited and descendent parameters for extending or

embedding packages.

Revision ID:: 1.15
Changeset ID:: MAIN:donb:20100119223239
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.14

05 Jan 10

donb

More
1.14
on
MAIN
- -13
- +13

Exposed parameter inheritance for use by the interactive APM package builder.

Revision ID:: 1.14
Changeset ID:: MAIN:donb:20100105212601
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.13

14 Feb 09

donb

More
1.13
on
MAIN
- -16
- +19

Package extends change.

Revision ID:: 1.13
Changeset ID:: MAIN:donb:20090214223525
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.12
Branch points:: oacs-5-5
Tags:: oacs-5-5$BP openacs-5-5-0a1 openacs-5-5-0b1 drb-merge-5-5-pre-20090711 openacs-5-5-1b1 openacs-5-5-0-final drb-merge-HEAD-from-20090711 dotlrn-2-5-0a1 openacs-5-5-1a1 drb-merge-HEAD-from-20090913 openacs-5-5-compat dotlrn-2-5-0-final dotlrn-2-5-0b1 openacs-5-5-1-final drb-merge-5-5-pre-20090913 (+11 more)

02 Feb 09

donb

More
1.12
on
MAIN
- -3
- +0

Fixed typo found while testing package extension stuff for oracle.

Revision ID:: 1.12
Changeset ID:: MAIN:donb:20090202043322
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.11

25 Nov 08

donb

More
1.11
on
MAIN
- -0
- +49

Preliminary version of "extend package" code, along with new package

attributes that allow the declaration of packages that are subsites.

Preliminary version of "extend package" code, along with new package

attributes that allow the declaration of packages that are subsites.

Revision ID:: 1.11
Changeset ID:: MAIN:donb:20081125170849
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.10

12 Jul 04

jeffd

More
1.10
on
MAIN
- -0
- +7

add an apm_version_sortable public function, add a test which checks the db upgrade scripts are well ordered.

Revision ID:: 1.10
Changeset ID:: MAIN:jeffd:20040712111238
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.9
Branch points:: lors-oracle-port oacs-5-2 oacs-5-3 oacs-5-4
Tags:: oacs-5-2$BP oacs-5-3$BP jcd-merge-pre-20050224 jcd-merge-post-20050111 jcd-merge-pre-20040712 jcd-merge-pre-20040724 jcd-merge-post-20040724 jcd-merge-pre-20050111 drb-before-5-2-merge-20060603 openacs-5-2-0a1 openacs-5-2-0b1 vg-merge-dotlrn-2-2-pre-20050922 vg-merge-dotlrn-2-2-post-20050926 openacs-5-2-0b8 openacs-5-2-0b9 openacs-5-2-0b5 dotlrn-2-2-0a1 openacs-5-2-1b5 openacs-5-2-0-final openacs-5-2-1-final openacs-5-2-2-final openacs-5-2-3b1 dotlrn-2-2-0b3 dotlrn-2-2-0b2 dotlrn-2-2-0b1 openacs-5-2-compat dotlrn-2-2-1-final lors-oracle-port$BP openacs-5-2-3rc1 oacs-5-2-compat dotlrn-2-2-1b1 dotlrn-2-2-1a1 openacs-5-2-3 dotlrn-2-2-0-final drb-merge-5-3-post-20061213 drb-merge-5-3-pre-20061213 openacs-5-3-0b2 openacs-5-3-0b1 drb-merge-HEAD-from-20061213 openacs-5-3-0a1 drb-merge-HEAD-post-20061214 openacs-5-3-0-final openacs-5-3-1a1 openacs-5-3-2b1 drb-merge-HEAD-from-20070513 dotlrn-2-3-0-final openacs-5-3-1-final dotlrn-2-3-0a2 dotlrn-2-3-0a1 openacs-5-3-1b1 dotlrn-2-3-0b1 drb-merge-HEAD-from-20070923 dotlrn-2-3-1b1 openacs-5-3-2-final dotlrn-2-3-1-final openacs-5-3-compat drb-merge-5-3-pre-20070513 drb-merge-5-3-post-20070514 drb-merge-5-3-pre-20070923 oacs-5-4$BP openacs-5-4-0b1 drb-merge-5-4-pre-20080607 drb-merge-5-3-post-20070923 openacs-5-4-0-final dotlrn-2-4-0a1 openacs-5-4-1b1 drb-merge-HEAD-from-20080607 openacs-5-4-1-final dotlrn-2-4-0b1 dotlrn-2-4-0-final openacs-5-4-2-final dotlrn-2-4-1b1 openacs-5-4-2b2 openacs-5-4-2b1 openacs-5-4-3b1 dotlrn-2-4-1-final openacs-5-4-compat openacs-5-4-3-final drb-merge-5-4-post-20080607 (+75 more)

30 Sep 03

mohanp

More
1.9
on
MAIN
- -1
- +1

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)

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)

Revision ID:: 1.9
Changeset ID:: MAIN:mohanp:20030930121000
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.8
Branch points:: dotkul oacs-5-0 oacs-5-1
Tags:: oacs-5-1$BP jcd-merge-5-1-20050111 oacs-5-0$BP openacs-5-0-0-final openacs-5-0-1-final openacs-5-0-0rc2 lars-504-2-merge jcd-504-merge openacs-5-0-compat openacs-5-1-1-final dotkul$BP openacs-5-1-1a1 jcd-merge-5-1-20040517 pre-504-2-head post-504-2-head jcd-merge-5-1-20040628 openacs-5-1-2b1 jcd-merge-5-1-20040724 dotlrn-2-1-0b1 dotlrn-2-1-0a2 dotlrn-2-1-0a1 jcd-merge-5-1-20040712 openacs-5-1-2-final dotlrn-2-1-0-final openacs-5-1-3-final openacs-5-1-4-final jcd-merge-5-1-20050224 dotlrn-2-1-1-final vg-merge-dotlrn-2-1-20050922 openacs-5-1-5-final dotlrn-2-1-3-final openacs-5-1-compat dotlrn-2-1-3b2 dotlrn-2-1-3b1 jcd-merge-post-20040628 jcd-merge-post-20040517 jcd-merge-pre-20040628 jcd-merge-pre-20040517 openacs-5-0-0b1 openacs-5-0-0b4 openacs-5-0-0a1 openacs-5-0-0a3 openacs-5-0-0rc1 openacs-5-0-0a4 post-ora9i-port openacs-5-0-2-final openacs-5-0-3-final openacs-5-0-4-final openacs-5-1-0b1 openacs-5-1-0rc1 openacs-5-1-0-final (+47 more)

17 May 03

jeffd

More
1.8
on
MAIN
- -0
- +24

merge of 4.6.3b1 to HEAD

Revision ID:: 1.8
Changeset ID:: MAIN:jeffd:20030517095557
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.7
Tags:: pre-ora9i-port post-4-6-4d1-head pre-4-6-4d1-head

23 Mar 03

donb

More
1.4.2.2
on
oacs-4-6
- -0
- +23

1. Made it possible to upgrade from acs-kernel 4.6.1 to acs-kernel 4.6.2

by using the APM rather than running the upgrade script by hand from

PSQL or SQL*Plus.

2. Changed a bunch of package .info files to depend on acs-kernel 4.6.2

to force the APM to upgrade acs-kernel (and therefore the APM datamodel)

before anything else. No guarantee on this though since not all

packages properly define their dependence on the kernel, it appears.

3. Whacked the release notes to suggest people use the APM to upgrade

acs-kernel first, other package later, just for safety's sake.

4. Fixed goof-up in acs-subsite I accidently introduced.

1. Made it possible to upgrade from acs-kernel 4.6.1 to acs-kernel 4.6.2

by using the APM rather than running the upgrade script by hand from

PSQL or SQL*Plus.

2. Changed a bunch of package .info files to depend on acs-kernel 4.6.2

to force the APM to upgrade acs-kernel (and therefore the APM datamodel)

before anything else. No guarantee on this though since not all

packages properly define their dependence on the kernel, it appears.

3. Whacked the release notes to suggest people use the APM to upgrade

acs-kernel first, other package later, just for safety's sake.

4. Fixed goof-up in acs-subsite I accidently introduced.

Revision ID:: 1.4.2.2
Changeset ID:: oacs-4-6:donb:20030323015921
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.4.2.1
Branch points:: openacs-org
Tags:: oacs-4-6-3-beta2 oacs-4-6-3-beta1 oacs-4-6-4d1 oacs-4-6-2-final oacs-4-6-2-b2 oacs-4-6-2-b1 openacs-org$BP oacs-4-6-3-final (+4 more)

05 Mar 03

lars

More
1.4.2.1
on
oacs-4-6
- -46
- +28

Upgrade to 4.6.2

Revision ID:: 1.4.2.1
Changeset ID:: oacs-4-6:lars:20030305144028
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.4

25 Feb 03

peterm

More
1.7
on
MAIN
- -0
- +20

Adding the before-upgrade and after-upgrade callback types. To go along with the upgrade callbacks Lars added the excellent apm_upgrade_logic proc that lets you specify arbitrary pieces of Tcl code to be executed on upgrade from version X to version Y. The proc figures out which upgrade code chunks to source and in which order (with the same logic as with the traditional upgrade sql scripts). Making paths to sql files (create, drop, upgrade) and catalog files (I18N) be fetched directly from the filesystem rather than from the info file. The file listings in the info files and in the database are now AFAIK superfluous and have no influence on the system. Adding proc apm_watch_all_files for watching all files in a package. Bumping up version name from 4.5 to 4.7.2d

Revision ID:: 1.7
Changeset ID:: MAIN:peterm:20030225164131
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.6

29 Jan 03

peterm

More
1.6
on
MAIN
- -46
- +2

deprecating apm_package_instantiate_and_mount. Adding auto-mounting of packages to the apm_package_install proc. Removing a few inline queries that are not used.

Revision ID:: 1.6
Changeset ID:: MAIN:peterm:20030129154555
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.5

23 Jan 03

peterm

More
1.5
on
MAIN
- -0
- +6

Fixing APM dependency bug. When installing new packages, the version comparison among the packages to install would use a simple Tcl comparison rather than the version_name_greater plsql proc (i.e. version 0.1a would be considered less than 0.1d). I changed to use the plsql proc instead

Revision ID:: 1.5
Changeset ID:: MAIN:peterm:20030123112421
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.4

30 Aug 02

lars

More
1.4
on
MAIN
- -3
- +3

Fixed problem with two different queries in apm_upgrade_script_compare with the same name that caused upgrade scripts to be run in the wrong order.

Revision ID:: 1.4
Changeset ID:: MAIN:lars:20020830114846
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.3
Branch points:: oacs-4-6
Tags:: oacs-4-6-1-final oacs-4-6$BP oacs-4-6-final

10 May 01

donb

More
1.3
on
MAIN
- -1
- +3

1. Added a new attribute to the .info file which tells the bootstrap

installer whether or not a package is part of the acs-core. Only

acs-core packages are now installed during the initial bootstrap install

of the system.

2. Fixed a dupe query name problem in a couple of queryfiles. The problem

is not with the dispatcher but with the extractor, and for the moment it

is just easier to kludge the resulting queryfile than fix the extractor.

1. Added a new attribute to the .info file which tells the bootstrap

installer whether or not a package is part of the acs-core. Only

acs-core packages are now installed during the initial bootstrap install

of the system.

2. Fixed a dupe query name problem in a couple of queryfiles. The problem

is not with the dispatcher but with the extractor, and for the moment it

is just easier to kludge the resulting queryfile than fix the extractor.

Revision ID:: 1.3
Changeset ID:: MAIN:donb:20010509223225
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.2
Branch points:: oacs-4-5
Tags:: oacs-4-5-final oacs-4-5-rc-1 oacs-4-5$BP

28 Apr 01

donb

More
1.2
on
MAIN
- -1
- +1

1. Ripped out the '' vs. NULL string kludge, which was a stupid idea in the

first place (MY stupid idea, for the record).

2. More .xql file porting...

1. Ripped out the '' vs. NULL string kludge, which was a stupid idea in the

first place (MY stupid idea, for the record).

2. More .xql file porting...

Revision ID:: 1.2
Changeset ID:: MAIN:donb:20010428173530
Parents:: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 1.1

24 Apr 01

danw

More
1.1
on
MAIN
- -0
- +281

query extractor output for acs-tcl

Revision ID:: 1.1
Changeset ID:: MAIN:danw:20010424060226