mysql
Module mysql
ballerinax/mysql Ballerina library
Clients
mysql: Client
Represents a MySQL database client.
Constructor
Initialize MySQL Client.
init (string host, string? user, string? password, string? database, int port, Options? options, ConnectionPool? connectionPool)
- host string "localhost" - Hostname of the mysql server to be connected
- user string? () - If the mysql server is secured, the username to be used to connect to the mysql server
- password string? () - The password of provided username of the database
- database string? () - The name fo the database to be connected
- port int 3306 - Port number of the mysql server to be connected
- options Options? () - The Database specific JDBC client properties
- connectionPool ConnectionPool? () - The
sql:ConnectionPool
object to be used within the jdbc client. If there is no connectionPool is provided, the global connection pool will be used and it will be shared by other clients which has same properties.
query
function query(string|ParameterizedQuery sqlQuery, typedesc<record {}>? rowType) returns stream<record {}, Error>
Queries the database with the query provided by the user, and returns the result as stream.
Parameters
- sqlQuery string|ParameterizedQuery - The query which needs to be executed as
string
orParameterizedQuery
when the SQL query has params to be passed in
- rowType typedesc<record {}>? (default ()) - The
typedesc
of the record that should be returned as a result. If this is not provided the default column names of the query result set be used for the record attributes.
Return Type
execute
function execute(string|ParameterizedQuery sqlQuery) returns ExecutionResult|Error
Executes the DDL or DML sql queries provided by the user, and returns summary of the execution.
Parameters
- sqlQuery string|ParameterizedQuery - The DDL or DML query such as INSERT, DELETE, UPDATE, etc as
string
orParameterizedQuery
when the query has params to be passed in
Return Type
- ExecutionResult|Error - Summary of the sql update query as
ExecutionResult
or returnsError
if any error occurred when executing the query
batchExecute
function batchExecute(ParameterizedQuery[] sqlQueries) returns ExecutionResult[]|Error
Executes a batch of parameterized DDL or DML sql query provided by the user, and returns the summary of the execution.
Parameters
- sqlQueries ParameterizedQuery[] - The DDL or DML query such as INSERT, DELETE, UPDATE, etc as
ParameterizedQuery
with an array of values passed in
Return Type
- ExecutionResult[]|Error - Summary of the executed SQL queries as
ExecutionResult[]
which includes details such asaffectedRowCount
andlastInsertId
. If one of the commands in the batch fails, this function will returnBatchExecuteError
, however the JDBC driver may or may not continue to process the remaining commands in the batch after a failure. The summary of the executed queries in case of error can be accessed as(<sql:BatchExecuteError> result).detail()?.executionResults
.
call
function call(string|ParameterizedCallQuery sqlQuery, typedesc<record {}>[] rowTypes) returns ProcedureCallResult|Error
Executes a SQL stored procedure and returns the result as stream and execution summary.
Parameters
- sqlQuery string|ParameterizedCallQuery - The query to execute the SQL stored procedure
- rowTypes typedesc<record {}>[] (default []) - The array of
typedesc
of the records that should be returned as a result. If this is not provided the default column names of the query result set be used for the record attributes.
Return Type
- ProcedureCallResult|Error - Summary of the execution is returned in
ProcedureCallResult
orsql:Error
close
function close() returns Error?
Close the SQL client.
Return Type
- Error? - Possible error during closing the client
Constants
Records
mysql: Options
MySQL database options.
Fields
- ssl SecureSocket? - SSL Configuration to be used
- useXADatasource boolean(default false) - Boolean value to enable XADatasource
- connectTimeout decimal(default 30) - Timeout (in seconds) to be used when connecting to the mysql server
- socketTimeout decimal(default 0) - Socket timeout (in seconds) during the read/write operations with the MySQL server (0 means no socket timeout)
- serverTimezone string? - Configures the connection time zone, which is used by the
Connector/J
if the conversion between a Ballerina application and a target time zone is needed when preserving instant temporal values
mysql: SecureSocket
SSL Configuration to be used when connecting to mysql server.
Fields
- mode SSLMode(default SSL_PREFERRED) -
SSLMode
to be used during the connection
- key KeyStore? - Keystore configuration of the client certificates
- cert TrustStore? - Keystore configuration of the trust certificates
- allowPublicKeyRetrieval boolean(default false) - Boolean value to allow special handshake round-trip to get an RSA public key directly from server
Union types
mysql: SSLMode
SSLMode
SSLMode as a union of available ssl modes.
Import
import ballerinax/mysql;
Metadata
Released date: about 3 years ago
Version: 0.7.0-alpha9.2
Compatibility
Platform: java11
Ballerina version: slalpha5
Pull count
Total: 58221
Current verison: 1173
Weekly downloads
Dependencies