gamkers / ZOMATO-ETL-BigData-Project

1 stars 0 forks source link

TC_Mod1_2 #2

Open gamkers opened 1 year ago

gamkers commented 1 year ago

<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">

TC_Mod1_2 | Check if all the JSON files are empty | JSON Files | Zomato table will be empty, i.e., no data is loaded to the zomato table | Failed | If the JSON file is empty, the data should not be loaded into the table | Data Centric Testing -- | -- | -- | -- | -- | -- | --

gamkers commented 1 year ago

Bug Report: C_Mod1_2 - Check if All the JSON Files Are Empty

Bug Description: The check for empty JSON files in the Data Centric Testing module fails to prevent the loading of data into the Zomato table when the JSON files are empty. Consequently, the Zomato table is populated with empty data. This bug affects the integrity and accuracy of the data loading process.

Severity: Critical This bug is classified as critical because it results in the loading of empty data into the Zomato table. It compromises the integrity of the data and can lead to incorrect analysis and processing of information.

Priority: High The priority is set to high due to the critical nature of the bug. Addressing this issue promptly is crucial to prevent incorrect data loading into the Zomato table and to maintain the accuracy of subsequent data operations.

Steps to Reproduce:

Ensure the presence of JSON files for the Zomato table. Verify that the JSON files are empty (contain no data). Proceed with the data loading process into the Zomato table. Observe the status of the Zomato table after the data loading process. Expected Result: If the JSON files are empty, the data loading process should be aborted, and the Zomato table should remain empty.

Actual Result: The data loading process continues even when the JSON files are empty, resulting in the Zomato table being populated with empty data.

Additional Information:

This issue affects the C_Mod1_2 test case. The bug relates to the failure to detect and handle empty JSON files before the data loading process. The integrity and accuracy of subsequent data operations are compromised due to the loading of empty data into the Zomato table. Please provide any relevant log files, error messages, or additional context that could assist in identifying the cause of the failure.

Given the critical severity and high priority of this bug, immediate attention is required to investigate and resolve the issue. Feel free to ask for any further clarification or provide additional information if required.

ErChaitanya commented 1 year ago

Can you shared the .CSV files {Source files}, because it won't get actual data after the converting it from .JSON to .CSV.