Connectors of ballerina.data.sql package
connector ClientConnector (map options)
Parameters:
Parameter Name | Data Type | Description |
---|---|---|
options | map |
action batchUpdate()
The call action implementation for SQL connector.
Parameters:
Parameter Name | Data Type | Description |
---|---|---|
c | ClientConnector | Connector |
query | string | String |
parameters | Parameter[][] | Parameter array |
Return Parameters:
Return Variable | Data Type | Description |
---|---|---|
int[] | updatedCounts: Array of update counts |
action call()
The call action implementation for SQL connector.
Parameters:
Parameter Name | Data Type | Description |
---|---|---|
c | ClientConnector | Connector |
query | string | String |
parameters | Parameter[] | Parameter array |
Return Parameters:
Return Variable | Data Type | Description |
---|---|---|
datatable | Result set for the query |
action close()
The close action implementation for SQL connector.
Parameters:
Parameter Name | Data Type | Description |
---|---|---|
c | ClientConnector | Connector |
action select()
The select action implementation for SQL connector.
Parameters:
Parameter Name | Data Type | Description |
---|---|---|
c | ClientConnector | Connector |
query | string | String |
parameters | Parameter[] | Parameter array |
Return Parameters:
Return Variable | Data Type | Description |
---|---|---|
datatable | Result set for the query |
action update()
The update action implementation for SQL connector.
Parameters:
Parameter Name | Data Type | Description |
---|---|---|
c | ClientConnector | Connector |
query | string | String |
parameters | Parameter[] | Parameter array |
Return Parameters:
Return Variable | Data Type | Description |
---|---|---|
int | integer: Updated row count |
action updateWithGeneratedKeys()
The update with generated keys given columns action implementation for SQL connector.
Parameters:
Parameter Name | Data Type | Description |
---|---|---|
c | ClientConnector | Connector |
query | string | String |
parameters | Parameter[] | Parameter array |
keyColumns | string[] | String array |
Return Parameters:
Return Variable | Data Type | Description |
---|---|---|
int | rowCount: Updated row count | |
string[] | rowCount: Updated row count |
Structs of ballerina.data.sql package
struct Parameter
Fields:
Field Name | Data Type | Description |
---|---|---|
sqlType | string | |
value | any | |
direction | int | |
structuredType | string |