API: Actn

Filename:

Released With:
5.0.0

Current Version:
1.0.0

Status: Active

Min Lasso Tested: 8.1.0

Max Lasso Tested: 8.5.3

Related:

fwp_recordData

Module Title

tableModel_{tableName} (Config)

Description

The tableModel configuration file defines the mapping of form inputs to database fields so the fwp_recordData data type can automate the building of database query statements. These files can go in either the /site/configs/ folder or a module's /_resources/configs/ folder.

Syntax

#! dbTbl5
# filename = tblDefn_fwpuserauth.cnfg

{serverType___     mysql|mssql|pgres|oracle }
{databaseName___   name of database }
{tableName___      name of table }
{keyfield___       keyfield name }
{lockField___      lockfield name }
{tableModel___

#inputName      fieldName           dataType    validation codes
#------------   -----------------   ---------   --------------------------
# add entries in columns separated by tabs
}

There can be more than one tab between columns to keep them lined up nicely, the parser will sort all that out, just make sure there is at least one tab between columns. Trailing tabs can be left off of rows that don't need them.

Examples

#! dbTbl5
# filename = tblDefn_fwpuserauth.cnfg

{serverType___     mysql }
{databaseName___   fwpdemo }
{tableName___      fwpuserauth }
{keyfield___       rcrdNo }
{lockField___      rcrdLockID }
{tableModel___

#inputName      fieldName           dataType    validation codes
#------------   -----------------   ---------   --------------------------
m_rNo           rcrdNo              string
m_rNewDate      rcrdCreated         string
m_rNewBy        rcrdCreatedBy       string
m_rModDate      rcrdModified        string
m_rModBy        rcrdModifiedBy      string
m_rApv          rcrdApproved        string
m_rLok          rcrdLock            string
m_rLokid        rcrdLockID          string
m_rLoktm        rcrdLockTime        string
m_rLokown       rcrdLockOwnr        string

m_rSessTime     sessionTime         string
m_rSessVars     sessionVars         string
m_rSessKprs     sessionKeepers      string
m_rSessProf     sessionProfile      string


m_uNameF        userNameFirst       string      req, aspc, label=First Name
m_uNameL        userNameLast        string      req, aspc, label=Last Name
m_uOrg          userOrg             string
m_uPhone        userPhone           string      n
m_uEmail        userEmail           string      req, email
m_uPw           userPswd            string
m_uHint         userHint            string      req

m_uIns          userLogins          integer
m_uLastIn       userLastLogin       string
m_uTries        userAttempts        integer
m_uLokTime      userLockTime        string
m_uPwNew        userPswdNew         string
m_uPwDate       userPswdCreated     string
m_uPwHist       userPswdHistory     string
m_uHosts        userHosts           string

# these are inputs that are part of the model, but not part of the table
# these are usually interim form inputs used to collect pieces of what
# ultimately is inserted into a single field

i_uPhoneA       -                   -           req, n, len=3
i_uPhoneP       -                   -           req, n, len=3
i_uPhoneN       -                   -           req, n, len=3
i_uPhoneX       -                   -           n

i_up1           _                   _           
i_up2           _                   _           
}