nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to use Mysql in bitbucket pipeline to test my test cases in cloud.

Vivek_Modi

Hey Everyone !

I am new in BitBucket pipelines. My Problem is to test Database in pipelines. I am using java gradle to integrate pipeline. I searched so many things to use mysql but i cannot understand how to connect the database my pipelines and run into the cloud to check my test case . I am confusing how to use services of bitbucket. Please anyone Help me how to learn these things and implement on my assignement.

Thanks

Accepted answers

DPKJ

@Vivek_ModiWelcome to the Community!

You will need to define service to use database in your pipeline.

You will get all information here - https://confluence.atlassian.com/bitbucket/test-with-databases-in-bitbucket-pipelines-856697462.html

It also include MySQL example.

All comments

DPKJ

@Vivek_ModiWelcome to the Community!

You will need to define service to use database in your pipeline.

You will get all information here - https://confluence.atlassian.com/bitbucket/test-with-databases-in-bitbucket-pipelines-856697462.html

It also include MySQL example.

Vivek_Modi

Hello @DPKJ

Thanks for replying me. I already done this steps but how to access the database resources. I mean i need to test my database test case of CRUD functions. So how can i use all services in pipelines. Its simple like dummy local database in cloud. Sorry For inappropriate questions. Below is my pipeline File code.

Thanks

Vivek_Modi

image: openjdk:8

pipelines:
default:
- step:
name: Test only
script:
- bash PipeExample/scripts/build-projects.sh
services:
- mysql
definitions:
services:
mysql:
image: mysql:5.7
environment:
MYSQL_DATABASE: pipelines
MYSQL_ROOT_PASSWORD: root_user_password
MYSQL_USER: test_user
MYSQL_PASSWORD: test_user_password

DPKJ

@Vivek_Modi

As you have defined service and you know details of database connections, I don't think you should have any problems in next steps.

Set your connection values to use defined database
- You can also pass them to `build-projects.sh`
- Or if you have config file, set these value in it
Create some dummy data,
- you can write a simple script to do that (or load fixtures)
- you can load it from predefined sql file
Run tests.

I tried this pipeline and I think it will give you idea of using it.

image: debian:stretch

pipelines:
  pull-requests:
'*':
      - step:
script:
          - apt-get update && apt-get install -y mysql-client
          - mysql -h 127.0.0.1 -u root -ptest_user_password -e "SHOW DATABASES"
        services:
          - mysql
definitions:
services:
mysql:
image: mysql:5.7
variables:
MYSQL_DATABASE: 'pipelines'
MYSQL_ROOT_PASSWORD: 'test_user_password'

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

bitbucket

bitbucket-pipelines