import sqlite3 as sql
from src.DreamersDiscoveries.infrastructure.services.result import Result, ResultT

class QueryDatabase:
    def __init__(self, helpers):
        self.file_path = helpers.build_database_path()

    def check_for_existing_users(self):
        try:
            with sql.connect(self.file_path) as mdb:
                cur = mdb.cursor()

                try:
                    found_users = cur.execute('SELECT * FROM users').fetchall()

                    try:
                        return ResultT.ok(found_users)
                    except Exception as e:
                        return Result.fail("Could Not Return List Of Found Users\n\n", e.__traceback__())

                except Exception as e:
                    return Result.fail("Could Not Execute Query\n\n", e.__traceback__())

        except Exception as e:
            return Result.fail("Could Not Connect To The Database\n\n", e.__traceback__())