import pandas as pd
import sqlite3
from pathlib import Path

# Open the database read only
db_path = Path.home() / 'A9Test' / 'ttff_results.db'
db = sqlite3.connect(f'file:{db_path}?mode=ro', uri=True)
# Load all the data from the database into a pandas dataframe
queryAll = '''
SELECT *
FROM results
'''

pd.set_option('display.max_rows', None)
df = pd.read_sql_query(queryAll,db)
print(df)

db.close()

print('Done')