Source code for db_viewer

import sqlite3
import pandas as pd


[docs]def read_table(table: str):
    """
    Returns the entire table given the table's name.
    :param table:
    """
    with sqlite3.connect('byte_server.db') as db:
        return pd.read_sql_query(f'SELECT * FROM {table}', db)


[docs]def tournaments():
    """
    Returns Tournaments table.
    """
    return read_table('tournament')


[docs]def teams():
    """
    Returns Teams table.
    """
    return read_table('team')


[docs]def runs():
    """
    Returns Run table.
    """
    return read_table('run')


[docs]def turns():
    """
    Returns Turns table.
    """
    return read_table('turn')


[docs]def submissions():
    """
    Returns Submissions table.
    """
    return read_table('submission')


[docs]def universities():
    """
    Returns Universities table.
    """
    return read_table('university')


[docs]def team_types():
    """
    Returns Team Types table.
    """
    return read_table('team_type')


[docs]def submission_run_infos():
    """
    Returns Run table.
    """
    return read_table('submission_run_info')