ChaitanyaGudimalla commented 5 months ago

Description: Implement bug detection display functionality for MySQL databases in the Differential Query Execution (DQE) tool.

Acceptance Criteria:

When executing a query for a MySQL database, the DQE tool should display any confirmed bugs associated with that database.
The bug display should provide clear and concise information about each confirmed bug, including severity and description.
Users should be able to access bug details with minimal additional steps, preferably within the same interface where the query is executed.
The bug display functionality should not significantly impact the performance of the DQE tool during query execution.
Ensure seamless integration with existing MySQL database testing workflows without requiring major adjustments or disruptions.
The bug detection display feature should be intuitive to use, allowing users to quickly understand and utilize the displayed bug information.

Effort: Estimated effort 10 hours.

ChaitanyaGudimalla commented 4 months ago

Project Name: Error Display Feature Mysqldb README File

Description

As a developer of the DQE (Database Query Execution) tool, I want to see any confirmed bugs associated with Mysql database when executing a query, So that I can be aware of potential issues and address them effectively..

Installation and Usage

First clone the project:

git clone https://github.com/UCF-CEN-5016/ACV_TRIO_RESEARCH.git

Once the project is cloned, ensure to enter the cloned project:
```
cd ACV_TRIO_RESEARCH
```
Install docker:
```
sudo apt install docker.io
```
Start docker:
```
sudo service docker start
```
Download database image:
```
docker pull mysql:8.0.30
```

Start an instance:

docker run -d --name mysql-8.0.30 -p 10001:3306 -e MYSQL_ROOT_PASSWORD=mysql-secret-password mysql:8.0.30 --default-authentication-plugin=mysql_native_password

Skipping Tests during Maven Packaging.:
```
mvn package -DskipTests
```
Enter the Target directory where jar file is located:
```
cd target
```

Execute Jar file:

java -jar dqetool-2.0.0.jar --host localhost --port 10001 --username root --password mysql-secret-password mysql

Where to See Changes

Once step 9 is executed, you can see the changes in the query output mentioning the confirmed Errors in the Database SQLite3.

Before Changes: WhatsApp Image 2024-04-19 at 8 53 19 PM

After changes made:

after_implementation_SS_Researchproj2

License

In order to clone the project, users can use this link https://github.com/UCF-CEN-5016/ACV_TRIO_RESEARCH.git.

Acknowledgements:

https://conf.researchr.org/details/icse-2023/icse-2023-artifact-evaluation/25/Testing-Database-Systems-via-Differential-Query-Execution

https://zenodo.org/records/7564685

Contact

For any queries, please contact ch257178@ucf.edu - ChaitanyaGudimalla.