About Wub: Domains/SqlT

(Parent)

A domain to minimally implement the Sql part of MVC, where the underlying model is an SQL database. SqlT converts the resultset into an HTML sortable table (default), a CSV file, or a Sylk spreadsheet, depending on the extension of the URL (.html, .csv or .sylk, respectively.)

Constructor Options

sql

the SQL command implementing the model (with : arg-substitution from the SQL query)

tdbc

the tdbc driver to use for SQL queries

db

optional tdbc database connection

maxrows

optional maximum number of rows which will be processed.

csv

optional dict of args to tcllib's csv

report

optional dict of args to Report utility

sort

optional dict of args to jQ sortable

form

a Tcl script which will be [subst]ed for each element of the tdbc resultset, yielding an html fragment.

huddle

a Huddle descriptor for conversion to JSON

(generated by STX)