Ballerina MySQL Library

The MySQL library is one of the standard library packages of the Ballerina language.

This provides the functionality required to access and manipulate data stored in a MySQL database.

For more information on the operations supported by the mysql:Client, which include the below, go to The MySQL Package.

• Pooling connections
• Querying data
• Inserting data
• Updating data
• Deleting data
• Updating data in batches
• Executing stored procedures
• Closing the client

For example demonstrations of the usage, go to Ballerina By Examples.

Issues and Projects

Issues and Projects tabs are disabled for this repository as this is part of the Ballerina Standard Library. To report bugs, request new features, start new discussions, view project boards, etc. please visit Ballerina Standard Library parent repository.

This repository only contains the source code for the package.

Building from the Source

Setting Up the Prerequisites

1. Download and install Java SE Development Kit (JDK) version 11 (from one of the following locations).

   • Oracle
   • OpenJDK

2. Download and install Docker

3. Export Github Personal access token with read package permissions as follows,

    export packageUser=<Username>
    export packagePAT=<Personal access token>
   

Building the Source

Execute the commands below to build from the source.

1. To build the library:

    ./gradlew clean build
   

2. To run the integration tests:

    ./gradlew clean test
   

3. To build the package without tests:

    ./gradlew clean build -x test
   

4. To run only specific tests:

    ./gradlew clean build -Pgroups=<Comma separated groups/test cases>
   

   Tip: The following groups of test cases are available.

   Groups	Test Cases
   connection	connection-init ssl
   pool	pool
   transaction	local-transaction xa-transaction
   execute	execute-basic execute-params
   batch-execute	batch-execute
   query	query-simple-params query-numeric-params query-complex-params
   procedures	procedures

5. To disable some specific groups during test,

    ./gradlew clean build -Pdisable-groups=<Comma separated groups/test cases>
   

6. To debug the tests:

    ./gradlew clean build -Pdebug=<port>
    ./gradlew clean test -Pdebug=<port>
   

7. To debug the package with Ballerina language:

    ./gradlew clean build -PbalJavaDebug=<port>
    ./gradlew clean test -PbalJavaDebug=<port>
   

8. Publish ZIP artifact to the local .m2 repository:

    ./gradlew clean build publishToMavenLocal
   

9. Publish the generated artifacts to the local Ballerina central repository:

    ./gradlew clean build -PpublishToLocalCentral=true
   

10. Publish the generated artifacts to the Ballerina central repository:

    ./gradlew clean build -PpublishToCentral=true
    

Contributing to Ballerina

As an open source project, Ballerina welcomes contributions from the community.

For more information, go to the contribution guidelines.

Code of Conduct

All contributors are encouraged to read the Ballerina Code of Conduct.

Useful Links

• Chat live with us via our Slack channel.
• Post all technical questions on Stack Overflow with the #ballerina tag.