Hi Experts,
I have written a Python script (3.8) which is going to capture Oracle SQL query from .log file ( as per report .log files are going to generate) and move the .sql to PRE.sql and POST.sql. then it will connect to Oracle DB and execute these queries and save the data to pre_data.csv and post_data.csv ( here am just providing names normally). then compare these 2 .csv files and extract the unique data from these two files to diff_data.xlsx files.
attached the script for reference. Now need help to add additional logic to below to teh attached script.
1. Add Audit columns MATCH_CASE, ROW_PRESENT, SYSTIMESTAMP to the diff_data.xlsx
2. highlight the columns where the data mismatch is there in this excel
3. capture these highlighted columns and place it in MATCH_CASE column with comma separated.
4. rename the column names with proper business names
Thanks
Amy
I have written a Python script (3.8) which is going to capture Oracle SQL query from .log file ( as per report .log files are going to generate) and move the .sql to PRE.sql and POST.sql. then it will connect to Oracle DB and execute these queries and save the data to pre_data.csv and post_data.csv ( here am just providing names normally). then compare these 2 .csv files and extract the unique data from these two files to diff_data.xlsx files.
attached the script for reference. Now need help to add additional logic to below to teh attached script.
1. Add Audit columns MATCH_CASE, ROW_PRESENT, SYSTIMESTAMP to the diff_data.xlsx
2. highlight the columns where the data mismatch is there in this excel
3. capture these highlighted columns and place it in MATCH_CASE column with comma separated.
4. rename the column names with proper business names
Thanks
Amy
buran write Mar-24-2023, 04:02 PM:
Added code in the post
Added code in the post