[FEAT]: SQL Connection preflight connection

[davini-dev]

What would you like to see?

There could be a button to test before saving the database connection.

Thanks

[mainifestion1]

Here's a simple example of a SQL connection prelight feature implemented in Python:

import sqlite3
import threading

class SQLConnectionPrelight:
    def __init__(self, db_path):
        self.db_path = db_path
        self.connection = None
        self.lock = threading.Lock()

    def prelight_connection(self):
        with self.lock:
            if self.connection is None:
                self.connection = sqlite3.connect(self.db_path)
                print("Prelight connection established")

    def get_connection(self):
        with self.lock:
            if self.connection is None:
                self.prelight_connection()
            return self.connection

    def close_connection(self):
        with self.lock:
            if self.connection is not None:
                self.connection.close()
                self.connection = None
                print("Connection closed")

# Example usage
db_path = "example.db"
prelight_connection = SQLConnectionPrelight(db_path)

# Establish prelight connection
prelight_connection.prelight_connection()

# Get connection
connection = prelight_connection.get_connection()

# Use connection
cursor = connection.cursor()
cursor.execute("SELECT * FROM example_table")
results = cursor.fetchall()
print(results)

# Close connection
prelight_connection.close_connection()