Method save_results

actions/sql_connector.py:203–210

Save the results of successful connection attempts to a CSV file.

(self)

        return success_flag[0], self.results  # Return True and the list of successes if at least one attempt was successful

    def save_results(self):
        """
        Save the results of successful connection attempts to a CSV file.
        """
        df = pd.DataFrame(self.results, columns=['IP Address', 'User', 'Password', 'Port', 'Database'])
        df.to_csv(self.sqlfile, index=False, mode='a', header=not os.path.exists(self.sqlfile))
        logger.info(f"Saved results to {self.sqlfile}")
        self.results = []

    def remove_duplicates(self):
        """