Chose skinClose

import sqlite3
from datetime import datetime

# Path to the SQLite database file
db_file = "/usr/local/openvpn_as/etc/db/log.db"

# Query to execute
query = """
    SELECT count(*) 
    FROM log 
    WHERE platform IS NOT NULL AND active = 1 AND auth = 1 
        AND date(timestamp, 'unixepoch') = date('now') 
    ORDER BY timestamp DESC 
    LIMIT 10;
"""


def execute_query(db_file, query):
    # Connect to the SQLite database
    conn = sqlite3.connect(db_file)

    try:
        # Create a cursor object
        cursor = conn.cursor()

        # Execute the query
        cursor.execute(query)

        # Fetch the result
        result = cursor.fetchone()

        return result[0] if result else None

    finally:
        # Close the database connection
        conn.close()


# Execute the query
result_count = execute_query(db_file, query)

# Print the result
print(f"Count of records: {result_count}")

if __name__ == '__main__':
    # Execute the query
    result_count = execute_query(db_file, query)
    if result_count == 0:
        import boto3

        regina_ec2_client = boto3.client('ec2', region_name='ap-southeast-1')

        # Retrieve instance status
        regina_instance_id = 'i-****'
        regina_response = regina_ec2_client.describe_instance_status(
            InstanceIds=[regina_instance_id]
        )
        regina_ec2_client.stop_instances(InstanceIds=[regina_instance_id])