Funcs
Funcs : Funcs
Deprecated - use connPing()
Deprecated - use connSyncHis()
Return plain text report on JDBC drivers installed
Query the tables defined for the database
Execute a SQL query and return the result as a grid
Execute a SQL statement and if applicable return a result
Insert a record or grid of records into the given table
(conn: Obj) => Future <admin, deprecated>
Deprecated - use connPing()
(points: Obj, span: Obj?) => Obj? <admin, deprecated>
Deprecated - use connSyncHis()
() => Str <admin>
Return plain text report on JDBC drivers installed.
(conn: Obj) => Grid <admin>
Query the tables defined for the database.
Return a grid with the name column.
Examples:
read(sqlConn).sqlTables
sqlTables(sqlConnId)
(conn: Obj, sql: Str) => Grid <admin>
Execute a SQL query and return the result as a grid. Blob columns under 10K are returned as base64.
Examples:
read(sqlConn).sqlQuery("select * from some_table")
sqlQuery(sqlConnId, "select * from some_table")
WARNING: any admin user will have full access to query the database based on the user account configured by the sqlConn.
(conn: Obj, sql: Str) => Obj? <admin>
Execute a SQL statement and if applicable return a result. If the statement produced auto-generated keys, then return an list of the keys generated, otherwise return number of rows modified.
WARNING: any admin user will have full access to update the database based on the user account configured by the sqlConn.
(data: Obj?, conn: Obj, table: Str) => Obj? <admin>
Insert a record or grid of records into the given table. If data is a dict, thena single row is inserted. If data is a grid or list of dicts, then each row is inserted. The data's column names must match the table's columns. If the data has a tag/column not found in the table then it is ignored.
WARNING: any admin user will have full access to update the database based on the user account configured by the sqlConn.