apm-install-procs-postgresql.xql

  • last updated 17 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Put redundant query definition into generic ones

  1. … 2 more files in changeset.
Remove usage of apm_package_version__version_name_greater in favor of apm_version_names_compare proc as their logics conflict

  1. … 2 more files in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

  1. … 7834 more files in changeset.
undo untested last minute check

  1. … 2 more files in changeset.
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

  1. … 2 more files in changeset.
.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

  1. … 22 more files in changeset.
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?)

  1. … 4 more files in changeset.
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.

  1. … 8 more files in changeset.
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. … 29 more files in changeset.
Fixed the copying of inherited and descendent parameters for extending or

embedding packages.

  1. … 3 more files in changeset.
Exposed parameter inheritance for use by the interactive APM package builder.

    • -13
    • +13
    ./apm-install-procs-postgresql.xql
  1. … 2 more files in changeset.
Preliminary version of "extend package" code, along with new package

attributes that allow the declaration of packages that are subsites.

  1. … 29 more files in changeset.
add an apm_version_sortable public function, add a test which checks the db upgrade scripts are well ordered.

  1. … 4 more files in changeset.

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. … 35 more files in changeset.
Upgrade to 4.6.2

    • -57
    • +28
    ./apm-install-procs-postgresql.xql
  1. … 30 more files in changeset.
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

  1. … 5 more files in changeset.
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.

  1. … 2 more files in changeset.
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

  1. … 2 more files in changeset.
- Missing comma in apm_package_instantiate_and_mount

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.

  1. … 2 more files in changeset.

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. … 36 more files in changeset.

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. … 23 more files in changeset.

More porting of the APM is complete! Nearly done, a bug in the datamodel

API and we need to convert from direct use of blobs to using the

content repository.

  1. … 11 more files in changeset.
changed case type to boolean

query extractor output for acs-tcl

    • -77
    • +252
    ./apm-install-procs-postgresql.xql
  1. … 41 more files in changeset.
new version of QD with better handling of absolute/relative paths

  1. … 10 more files in changeset.
query dispatcher now works with global RDBMS tags, and attempts to work on relative paths (although that's not finalized)

  1. … 3 more files in changeset.

Big 'ole update to implement multi-db aware packages. Don't try this yet,

I can't *possibly* have gotten all the right files added and removed in

one fell swoop!

    • -0
    • +97
    ./apm-install-procs-postgresql.xql
  1. … 118 more files in changeset.