Class ::acs::db::SQL

::acs::db::SQL[i] create ...

Generic superclass for all SQL dialects.
Defined in packages/acs-tcl/tcl/acs-db-12-procs.tcl

Class Relations

  • class: ::nx::Class[i]
  • superclass: ::nx::Object[i]
  • subclass: ::acs::db::oracle[i], ::acs::db::postgresql[i]

Methods (to be applied on instances)

  • create_db_function_interface (scripted, public)

     <instance of acs::db::SQL[i]> create_db_function_interface \
        [ -dbn dbn ] [ -match match ] [ -verbose ]

    Obtain all function definitions from the DB and turn these into callable Tcl methods like the following examples: ::acs::dc call content_type drop_type -content_type ::xowiki::FormInstance ::acs::dc call content_folder delete -folder_id $root_folder_id -cascade_p 1 In the Oracle-biased terminology such calls are defined in terms of a "package_name" and an "object_name": ::acs::dc call /package_name/ /object_name/ ?/args/?

    Switches:
    -dbn (optional)
    -match (optional, defaults to "*")
    -verbose (optional)

    Testcases:
    No testcase defined.