ad_acs_require_basic_schemata (private)

 ad_acs_require_basic_schemata

Defined in packages/acs-tcl/tcl/acs-kernel-procs.tcl

This is a transitional code to ensure that the SQL schemata required for bootstrapping (i.e. before the upgrade script) are already installed.

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Source code:

    set schema_name "acs_permission"
    if {![db_string has_schema {}]} {
        set kernelSqlDir "$::acs::rootdir/packages/acs-kernel/sql/[db_driverkey {}]/upgrade"
        set files "upgrade-5.9.1d10-5.9.1d11.sql"
        foreach file $files {
            set fn $kernelSqlDir/$file
            if {[ad_file readable $fn]} {
                ns_log notice "bootstrap: upgrading SQL file $fn"
                db_source_sql_file -callback apm_dummy_callback $fn
            }
        }
    }

XQL Not present:

Generic

PostgreSQL XQL file:

<fullquery name="ad_acs_require_basic_schemata.has_schema">
    <querytext>
    SELECT exists (
       SELECT 1 FROM information_schema.schemata
       WHERE schema_name = :schema_name
    )
  </querytext>
</fullquery>

packages/acs-tcl/tcl/acs-kernel-procs-postgresql.xql

Oracle XQL file:

<fullquery name="ad_acs_require_basic_schemata.has_schema">
    <querytext>
    SELECT 1 from DUAL
  </querytext>
</fullquery>

packages/acs-tcl/tcl/acs-kernel-procs-oracle.xql