Sql
Command
Select
Iface
constructor
name
add
Field
add
Math
Exp
Field
add
Table
add
Value
Field
get
Fields
get
Tables
parse
stringify
to
Query
NODE-GTK API Reference
Vda-1
Vda
SqlCommandSelectIface
Class SqlCommandSelectIface
Hierarchy
SqlCommandSelectIface
Index
Constructors
constructor
Properties
name
Methods
add
Field
add
Math
Exp
Field
add
Table
add
Value
Field
get
Fields
get
Tables
parse
stringify
to
Query
Constructors
constructor
new
Sql
Command
Select
Iface
(
)
:
SqlCommandSelectIface
Returns
SqlCommandSelectIface
Properties
Static
name
name
:
string
Methods
add
Field
add
Field
(
field
:
string
, tableRef
?:
string
, alias
?:
string
)
:
void
Parameters
field:
string
Optional
tableRef:
string
Optional
alias:
string
Returns
void
add
Math
Exp
Field
add
Math
Exp
Field
(
exp
:
string
, allias
?:
string
)
:
void
Parameters
exp:
string
Optional
allias:
string
Returns
void
add
Table
add
Table
(
name
:
string
, allias
?:
string
)
:
void
Parameters
name:
string
Optional
allias:
string
Returns
void
add
Value
Field
add
Value
Field
(
val
:
any
, allias
?:
string
)
:
void
Parameters
val:
any
Optional
allias:
string
Returns
void
get
Fields
get
Fields
(
)
:
HashModel
Returns
HashModel
get
Tables
get
Tables
(
)
:
HashModel
Returns
HashModel
parse
parse
(
sql
:
string
)
:
void
Parameters
sql:
string
Returns
void
stringify
stringify
(
)
:
string
Returns
string
to
Query
to
Query
(
name
?:
string
)
:
PreparedQuery
Parameters
Optional
name:
string
Returns
PreparedQuery
Sql
Command
Select
Iface
constructor
name
add
Field
add
Math
Exp
Field
add
Table
add
Value
Field
get
Fields
get
Tables
parse
stringify
to
Query
base64:eyJwYWdlTmF2aWdhdGlvbiI6W3siY2xhc3NOYW1lcyI6InRzZC1raW5kLWNvbnN0cnVjdG9yIHRzZC1wYXJlbnQta2luZC1jbGFzcyIsImhyZWYiOiJWZGFfMS5WZGEuU3FsQ29tbWFuZFNlbGVjdElmYWNlLmh0bWwjY29uc3RydWN0b3IiLCJuYW1lIjoiY29uc3RydWN0b3IiLCJjaGlsZHJlbiI6W10sImlzRXh0ZXJuIjpmYWxzZSwiaXNJbnRlcm4iOnRydWV9LHsiY2xhc3NOYW1lcyI6InRzZC1raW5kLXByb3BlcnR5IHRzZC1wYXJlbnQta2luZC1jbGFzcyB0c2QtaXMtc3RhdGljIiwiaHJlZiI6IlZkYV8xLlZkYS5TcWxDb21tYW5kU2VsZWN0SWZhY2UuaHRtbCNuYW1lIiwibmFtZSI6Im5hbWUiLCJjaGlsZHJlbiI6W10sImlzRXh0ZXJuIjpmYWxzZSwiaXNJbnRlcm4iOnRydWV9LHsiY2xhc3NOYW1lcyI6InRzZC1raW5kLW1ldGhvZCB0c2QtcGFyZW50LWtpbmQtY2xhc3MiLCJocmVmIjoiVmRhXzEuVmRhLlNxbENvbW1hbmRTZWxlY3RJZmFjZS5odG1sI2FkZEZpZWxkIiwibmFtZSI6ImFkZEZpZWxkIiwiY2hpbGRyZW4iOltdLCJpc0V4dGVybiI6ZmFsc2UsImlzSW50ZXJuIjp0cnVlfSx7ImNsYXNzTmFtZXMiOiJ0c2Qta2luZC1tZXRob2QgdHNkLXBhcmVudC1raW5kLWNsYXNzIiwiaHJlZiI6IlZkYV8xLlZkYS5TcWxDb21tYW5kU2VsZWN0SWZhY2UuaHRtbCNhZGRNYXRoRXhwRmllbGQiLCJuYW1lIjoiYWRkTWF0aEV4cEZpZWxkIiwiY2hpbGRyZW4iOltdLCJpc0V4dGVybiI6ZmFsc2UsImlzSW50ZXJuIjp0cnVlfSx7ImNsYXNzTmFtZXMiOiJ0c2Qta2luZC1tZXRob2QgdHNkLXBhcmVudC1raW5kLWNsYXNzIiwiaHJlZiI6IlZkYV8xLlZkYS5TcWxDb21tYW5kU2VsZWN0SWZhY2UuaHRtbCNhZGRUYWJsZSIsIm5hbWUiOiJhZGRUYWJsZSIsImNoaWxkcmVuIjpbXSwiaXNFeHRlcm4iOmZhbHNlLCJpc0ludGVybiI6dHJ1ZX0seyJjbGFzc05hbWVzIjoidHNkLWtpbmQtbWV0aG9kIHRzZC1wYXJlbnQta2luZC1jbGFzcyIsImhyZWYiOiJWZGFfMS5WZGEuU3FsQ29tbWFuZFNlbGVjdElmYWNlLmh0bWwjYWRkVmFsdWVGaWVsZCIsIm5hbWUiOiJhZGRWYWx1ZUZpZWxkIiwiY2hpbGRyZW4iOltdLCJpc0V4dGVybiI6ZmFsc2UsImlzSW50ZXJuIjp0cnVlfSx7ImNsYXNzTmFtZXMiOiJ0c2Qta2luZC1tZXRob2QgdHNkLXBhcmVudC1raW5kLWNsYXNzIiwiaHJlZiI6IlZkYV8xLlZkYS5TcWxDb21tYW5kU2VsZWN0SWZhY2UuaHRtbCNnZXRGaWVsZHMiLCJuYW1lIjoiZ2V0RmllbGRzIiwiY2hpbGRyZW4iOltdLCJpc0V4dGVybiI6ZmFsc2UsImlzSW50ZXJuIjp0cnVlfSx7ImNsYXNzTmFtZXMiOiJ0c2Qta2luZC1tZXRob2QgdHNkLXBhcmVudC1raW5kLWNsYXNzIiwiaHJlZiI6IlZkYV8xLlZkYS5TcWxDb21tYW5kU2VsZWN0SWZhY2UuaHRtbCNnZXRUYWJsZXMiLCJuYW1lIjoiZ2V0VGFibGVzIiwiY2hpbGRyZW4iOltdLCJpc0V4dGVybiI6ZmFsc2UsImlzSW50ZXJuIjp0cnVlfSx7ImNsYXNzTmFtZXMiOiJ0c2Qta2luZC1tZXRob2QgdHNkLXBhcmVudC1raW5kLWNsYXNzIiwiaHJlZiI6IlZkYV8xLlZkYS5TcWxDb21tYW5kU2VsZWN0SWZhY2UuaHRtbCNwYXJzZSIsIm5hbWUiOiJwYXJzZSIsImNoaWxkcmVuIjpbXSwiaXNFeHRlcm4iOmZhbHNlLCJpc0ludGVybiI6dHJ1ZX0seyJjbGFzc05hbWVzIjoidHNkLWtpbmQtbWV0aG9kIHRzZC1wYXJlbnQta2luZC1jbGFzcyIsImhyZWYiOiJWZGFfMS5WZGEuU3FsQ29tbWFuZFNlbGVjdElmYWNlLmh0bWwjc3RyaW5naWZ5IiwibmFtZSI6InN0cmluZ2lmeSIsImNoaWxkcmVuIjpbXSwiaXNFeHRlcm4iOmZhbHNlLCJpc0ludGVybiI6dHJ1ZX0seyJjbGFzc05hbWVzIjoidHNkLWtpbmQtbWV0aG9kIHRzZC1wYXJlbnQta2luZC1jbGFzcyIsImhyZWYiOiJWZGFfMS5WZGEuU3FsQ29tbWFuZFNlbGVjdElmYWNlLmh0bWwjdG9RdWVyeSIsIm5hbWUiOiJ0b1F1ZXJ5IiwiY2hpbGRyZW4iOltdLCJpc0V4dGVybiI6ZmFsc2UsImlzSW50ZXJuIjp0cnVlfV0sImNsYXNzTmFtZXMiOiJjdXJyZW50IHRzZC1raW5kLWNsYXNzIHRzZC1wYXJlbnQta2luZC1uYW1lc3BhY2UiLCJocmVmIjoiVmRhXzEuVmRhLlNxbENvbW1hbmRTZWxlY3RJZmFjZS5odG1sIiwibmFtZSI6IlNxbENvbW1hbmRTZWxlY3RJZmFjZSJ9