xowiki::update_views (private)

 xowiki::update_views

Defined in packages/xowiki/tcl/xowiki-utility-procs.tcl

update all automatic views of xowiki

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

Testcases:

No testcase defined.

Source code:

    foreach object_type [::xowiki::Page object_types] {
      ::xo::db::sql::content_type refresh_view -content_type $object_type
    }

    catch {::xo::dc dml drop_live_revision_view "drop view xowiki_page_live_revision"}
    if {[db_driverkey ""] eq "postgresql"} {
      set sortkeys ", ci.tree_sortkey, ci.max_child_sortkey "
    } else {
      set sortkeys ""
    }
    ::xo::db::require view xowiki_page_live_revision  "select p.*, cr.*,ci.parent_id, ci.name, ci.locale, ci.live_revision,  ci.latest_revision, ci.publish_status, ci.content_type, ci.storage_type,  ci.storage_area_key $sortkeys  from xowiki_page p, cr_items ci, cr_revisions cr   where p.page_id = ci.live_revision  and p.page_id = cr.revision_id   and ci.publish_status <> 'production'"

XQL Not present:

Generic, PostgreSQL, Oracle