import time

import config
from connectors import mysql

logger = config.logger


def main() -> None:
    connection = mysql.get_mysql_connection()
    with connection.cursor() as cursor:
        now = time.time()
        sql = "SELECT * FROM accountingflat.TEMP_dig_sales_statements where release_status != 'in_content';"
        cursor.execute(sql)
        post_query = time.time()
        logger.info(f"Query time for {sql} is {post_query - now}\n")
        result = cursor.fetchall()
        if result:
            result_log_message = f"Releases not in_content: {result}"
        else:
            result_log_message = "All releases are in_content"
        logger.info(result_log_message)
    if connection.show_warnings():
        logger.warning(f"Warnings: {connection.show_warnings()}")
    connection.close()


if __name__ == "__main__":
    main()