---

Class ::acs::db::nsdbi

::acs::db::nsdbi create ... \
           [ -backend backend ] \
           [ -dbn (default "") ] \
           [ -driver driver ]

Database interface based on the nsdbi driver of NaviServer

Defined in packages/acs-tcl/tcl/acs-db-00-procs.tcl

Class Relations

• class: ::nx::Class
• superclass: ::acs::db::Driver
• subclass: ::acs::db::nsdbi-postgresql

Methods (to be applied on instances)

• list (scripted, public)

   <instance of acs::db::nsdbi> list [ -dbn dbn ] [ -bind bind ] \
      [ -prepare prepare ] qn sql

  Return a Tcl list, where each element contains just the first the column values of the tuples returned by the provided SQL query.

  Switches:

  -dbn (optional)

  database identifier

  -bind (optional)

  optional bind variables for the SQL query

  -prepare (optional)

  not used for NSDBI, providing interface compatibility with NSDB

  Parameters:

  qn (required)

  name of the SQL query

  sql (required)

  SQL query

  Testcases:

  No testcase defined.

• list_of_lists (scripted, public)

   <instance of acs::db::nsdbi> list_of_lists [ -dbn dbn ] \
      [ -bind bind ] [ -prepare prepare ] qn sql

  Return a Tcl list, where each element consists of a list of the column values corresponding to the values of the tuples returned by the provided SQL query.

  Switches:

  -dbn (optional)

  database identifier

  -bind (optional)

  optional bind variables for the SQL query

  -prepare (optional)

  not used for NSDBI, providing interface compatibility with NSDB

  Parameters:

  qn (required)

  name of the SQL query

  sql (required)

  SQL query

  Testcases:

  No testcase defined.

---