%3 ::xotcl::Object ::xotcl::Object → getExitHandler → setExitHandler → unsetExitHandler __object_configureparameter __timediff abstract ad_doc ad_forward ad_proc asHTML check class db_0or1row db_1row debug destroy_on_cleanup ds extractConfigureArg filter filtersearch forward hasclass init invar isclass ismetaclass ismixin isobject istype log method mixin mset msg parametercmd proc procsearch qn self serialize set_instance_vars_defaults unknown vwait www-show-object ::xo::db::SQL ::xo::db::SQL datatype_constraint date_trunc date_trunc_expression fix_function_args has_hstore has_ltree interval map_datatype map_function_name mk_sql_constraint_name select since_interval_condition sql_arg_info ::xo::db::SQL->::xotcl::Object ::xo::db::postgresql ::xo::db::postgresql date_trunc date_trunc_expression get_all_package_functions get_function_args has_hstore has_ltree map_datatype nextval select ::xo::db::postgresql->::xo::db::SQL ::xo::db::oracle ::xo::db::oracle datatype_constraint date_trunc date_trunc_expression limit_clause map_datatype map_function_name mk_sql_constraint_name nextval select ::xo::db::oracle->::xo::db::SQL ::xo::db::DB-postgresql ::xo::db::DB-postgresql 0or1row 1row dml foreach generate_psql get_value insert-view-operation list list_of_lists multirow prepare row_lock sets ::xo::db::DB-postgresql->::xo::db::postgresql ::xo::db::DB ::xo::db::DB ::xo::db::DB-postgresql->::xo::db::DB ::xo::db::DBI-postgresql ::xo::db::DBI-postgresql ::xo::db::DBI-postgresql->::xo::db::postgresql ::xo::db::DBI ::xo::db::DBI ::xo::db::DBI-postgresql->::xo::db::DBI ::xo::db::DB-oracle ::xo::db::DB-oracle generate_psql get_all_package_functions get_function_args sets ::xo::db::DB-oracle->::xo::db::oracle ::xo::db::DB-oracle->::xo::db::DB

Class ::xo::db::SQL

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

Defined in

Class Relations

  • class: ::xotcl::Class[i]
  • superclass: ::xotcl::Object[i]
  • subclass: ::xo::db::postgresql[i], ::xo::db::oracle[i]

Methods (to be applied on instances)

  • datatype_constraint (scripted)

     <instance of xo::db::SQL[i]> datatype_constraint

    Testcases:
    xotcl_core_tutorial_2, xotcl-core
  • date_trunc (scripted)

  • date_trunc_expression (scripted)

  • fix_function_args (scripted)

  • has_hstore (scripted)

  • has_ltree (scripted)

  • interval (scripted)

  • map_datatype (scripted)

  • map_function_name (scripted)

  • mk_sql_constraint_name (scripted)

  • select (scripted)

  • since_interval_condition (scripted)

  • sql_arg_info (scripted)

Variables

::xo::db::SQL set __default_metaclass ::xotcl::Class
::xo::db::SQL set __default_superclass ::xotcl::Object
::xo::db::SQL array set fallback_defaults {content_type__drop_type {
      DROP_CHILDREN_P f DROP_TABLE_P f DROP_OBJECTS_P f
    } content_item__new {
      RELATION_TAG null DESCRIPTION null TEXT null
      CREATION_IP null NLS_LANGUAGE null LOCALE null CONTEXT_ID null
      DATA null TITLE null ITEM_ID null
      CREATION_DATE now
      ITEM_SUBTYPE content_item
      CONTENT_TYPE content_revision
      MIME_TYPE text/plain
      IS_LIVE f
      STORAGE_TYPE lob
    } content_type__create_attribute {
      DEFAULT_VALUE null SORT_ORDER null PRETTY_PLURAL null
    } acs_object_type__create_type {
      TYPE_EXTENSION_TABLE null NAME_METHOD null
    } acs_attribute__create_attribute {
      PRETTY_PLURAL null TABLE_NAME null COLUMN_NAME null
      DEFAULT_VALUE null SORT_ORDER null DATABASE_TYPE null SIZE null
      REFERENCES null CHECK_EXPR null COLUMN_SPEC null
    }}