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
GJS 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
, table_ref
?:
string
, alias
?:
string
)
:
void
Parameters
field:
string
Optional
table_ref:
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:eyJwYWdlTmF2aWdhdGlvbiI6W3siY2xhc3NOYW1lcyI6InRzZC1raW5kLWNvbnN0cnVjdG9yIHRzZC1wYXJlbnQta2luZC1jbGFzcyIsImhyZWYiOiJWZGFfMS5WZGEuU3FsQ29tbWFuZFNlbGVjdElmYWNlLmh0bWwjY29uc3RydWN0b3IiLCJuYW1lIjoiY29uc3RydWN0b3IiLCJjaGlsZHJlbiI6W10sImlzRXh0ZXJuIjpmYWxzZSwiaXNJbnRlcm4iOnRydWV9LHsiY2xhc3NOYW1lcyI6InRzZC1raW5kLXByb3BlcnR5IHRzZC1wYXJlbnQta2luZC1jbGFzcyB0c2QtaXMtc3RhdGljIiwiaHJlZiI6IlZkYV8xLlZkYS5TcWxDb21tYW5kU2VsZWN0SWZhY2UuaHRtbCNuYW1lIiwibmFtZSI6Im5hbWUiLCJjaGlsZHJlbiI6W10sImlzRXh0ZXJuIjpmYWxzZSwiaXNJbnRlcm4iOnRydWV9LHsiY2xhc3NOYW1lcyI6InRzZC1raW5kLW1ldGhvZCB0c2QtcGFyZW50LWtpbmQtY2xhc3MiLCJocmVmIjoiVmRhXzEuVmRhLlNxbENvbW1hbmRTZWxlY3RJZmFjZS5odG1sI2FkZF9maWVsZCIsIm5hbWUiOiJhZGRfZmllbGQiLCJjaGlsZHJlbiI6W10sImlzRXh0ZXJuIjpmYWxzZSwiaXNJbnRlcm4iOnRydWV9LHsiY2xhc3NOYW1lcyI6InRzZC1raW5kLW1ldGhvZCB0c2QtcGFyZW50LWtpbmQtY2xhc3MiLCJocmVmIjoiVmRhXzEuVmRhLlNxbENvbW1hbmRTZWxlY3RJZmFjZS5odG1sI2FkZF9tYXRoX2V4cF9maWVsZCIsIm5hbWUiOiJhZGRfbWF0aF9leHBfZmllbGQiLCJjaGlsZHJlbiI6W10sImlzRXh0ZXJuIjpmYWxzZSwiaXNJbnRlcm4iOnRydWV9LHsiY2xhc3NOYW1lcyI6InRzZC1raW5kLW1ldGhvZCB0c2QtcGFyZW50LWtpbmQtY2xhc3MiLCJocmVmIjoiVmRhXzEuVmRhLlNxbENvbW1hbmRTZWxlY3RJZmFjZS5odG1sI2FkZF90YWJsZSIsIm5hbWUiOiJhZGRfdGFibGUiLCJjaGlsZHJlbiI6W10sImlzRXh0ZXJuIjpmYWxzZSwiaXNJbnRlcm4iOnRydWV9LHsiY2xhc3NOYW1lcyI6InRzZC1raW5kLW1ldGhvZCB0c2QtcGFyZW50LWtpbmQtY2xhc3MiLCJocmVmIjoiVmRhXzEuVmRhLlNxbENvbW1hbmRTZWxlY3RJZmFjZS5odG1sI2FkZF92YWx1ZV9maWVsZCIsIm5hbWUiOiJhZGRfdmFsdWVfZmllbGQiLCJjaGlsZHJlbiI6W10sImlzRXh0ZXJuIjpmYWxzZSwiaXNJbnRlcm4iOnRydWV9LHsiY2xhc3NOYW1lcyI6InRzZC1raW5kLW1ldGhvZCB0c2QtcGFyZW50LWtpbmQtY2xhc3MiLCJocmVmIjoiVmRhXzEuVmRhLlNxbENvbW1hbmRTZWxlY3RJZmFjZS5odG1sI2dldF9maWVsZHMiLCJuYW1lIjoiZ2V0X2ZpZWxkcyIsImNoaWxkcmVuIjpbXSwiaXNFeHRlcm4iOmZhbHNlLCJpc0ludGVybiI6dHJ1ZX0seyJjbGFzc05hbWVzIjoidHNkLWtpbmQtbWV0aG9kIHRzZC1wYXJlbnQta2luZC1jbGFzcyIsImhyZWYiOiJWZGFfMS5WZGEuU3FsQ29tbWFuZFNlbGVjdElmYWNlLmh0bWwjZ2V0X3RhYmxlcyIsIm5hbWUiOiJnZXRfdGFibGVzIiwiY2hpbGRyZW4iOltdLCJpc0V4dGVybiI6ZmFsc2UsImlzSW50ZXJuIjp0cnVlfSx7ImNsYXNzTmFtZXMiOiJ0c2Qta2luZC1tZXRob2QgdHNkLXBhcmVudC1raW5kLWNsYXNzIiwiaHJlZiI6IlZkYV8xLlZkYS5TcWxDb21tYW5kU2VsZWN0SWZhY2UuaHRtbCNwYXJzZSIsIm5hbWUiOiJwYXJzZSIsImNoaWxkcmVuIjpbXSwiaXNFeHRlcm4iOmZhbHNlLCJpc0ludGVybiI6dHJ1ZX0seyJjbGFzc05hbWVzIjoidHNkLWtpbmQtbWV0aG9kIHRzZC1wYXJlbnQta2luZC1jbGFzcyIsImhyZWYiOiJWZGFfMS5WZGEuU3FsQ29tbWFuZFNlbGVjdElmYWNlLmh0bWwjc3RyaW5naWZ5IiwibmFtZSI6InN0cmluZ2lmeSIsImNoaWxkcmVuIjpbXSwiaXNFeHRlcm4iOmZhbHNlLCJpc0ludGVybiI6dHJ1ZX0seyJjbGFzc05hbWVzIjoidHNkLWtpbmQtbWV0aG9kIHRzZC1wYXJlbnQta2luZC1jbGFzcyIsImhyZWYiOiJWZGFfMS5WZGEuU3FsQ29tbWFuZFNlbGVjdElmYWNlLmh0bWwjdG9fcXVlcnkiLCJuYW1lIjoidG9fcXVlcnkiLCJjaGlsZHJlbiI6W10sImlzRXh0ZXJuIjpmYWxzZSwiaXNJbnRlcm4iOnRydWV9XSwiY2xhc3NOYW1lcyI6ImN1cnJlbnQgdHNkLWtpbmQtY2xhc3MgdHNkLXBhcmVudC1raW5kLW5hbWVzcGFjZSIsImhyZWYiOiJWZGFfMS5WZGEuU3FsQ29tbWFuZFNlbGVjdElmYWNlLmh0bWwiLCJuYW1lIjoiU3FsQ29tbWFuZFNlbGVjdElmYWNlIn0=