import sqlite3

def check_db():
    conn = sqlite3.connect('instance/qualilearn_v2.db')
    cursor = conn.cursor()
    cursor.execute("SELECT title, resource_url FROM vocational_content WHERE language='en'")
    rows = cursor.fetchall()
    for row in rows:
        print(f"{row[0]}: {row[1]}")
    conn.close()

if __name__ == "__main__":
    check_db()
