testdb.py

import sqlite3

def create_connection(db_file):
    """ create a database connection to the SQLite database
        specified by the db_file
    :param db_file: database file
    :return: Connection object or None
    """
    conn = None
    try:
        conn = sqlite3.connect(db_file)
    except error as e:
        print(e)
 
    return conn

def select_all_tasks(conn):
    """
    Query all rows in the tasks table
    :param conn: the Connection object
    :return:
    """
    cur = conn.cursor()
    cur.execute("SELECT name, astTo FROM player WHERE astTo < 100000 ORDER BY astTo DESC LIMIT 10")
 
    rows = cur.fetchall()
 
    for row in rows:
        print(row)

def main():
    connection = create_connection("players.db")
    select_all_tasks(connection)

if __name__ == "__main__":
    main()