# Path: nflpool/data/activeplayers.py
# class ActiveNFLPlayers(SqlAlchemyBase):
#     __tablename__ = "ActiveNFLPlayers"
#     primary_key = sqlalchemy.Column(
#         sqlalchemy.Integer, primary_key=True, autoincrement=True, index=True
#     )
#     season = sqlalchemy.Column(sqlalchemy.Integer)
#     team_id = sqlalchemy.Column(
#         sqlalchemy.Integer, sqlalchemy.ForeignKey("TeamInfo.team_id")
#     )
#     firstname = sqlalchemy.Column(sqlalchemy.String)
#     lastname = sqlalchemy.Column(sqlalchemy.String)
#     position = sqlalchemy.Column(sqlalchemy.String, index=True)
#     player_id = sqlalchemy.Column(
#         sqlalchemy.Integer, sqlalchemy.ForeignKey("PlayerPicks.player_id"), index=True
#     )
# 
# Path: nflpool/data/seasoninfo.py
# class SeasonInfo(SqlAlchemyBase):
#     __tablename__ = "SeasonInfo"
#     id = sqlalchemy.Column(sqlalchemy.Integer, primary_key=True, autoincrement=True)
#     current_season = sqlalchemy.Column(sqlalchemy.Integer)
#     season_start_date = sqlalchemy.Column(sqlalchemy.String)
#     home_team = sqlalchemy.Column(sqlalchemy.String)
#     away_team = sqlalchemy.Column(sqlalchemy.String)


import pytest
    import nflpool.data.secret as secret
    import requests
from nflpool.data.activeplayers import ActiveNFLPlayers
from nflpool.data.seasoninfo import SeasonInfo
    from requests.auth import HTTPBasicAuth


def test_season_row(db_session):
    season_row = db_session.query(SeasonInfo.id).first()
    print(season_row)
    # season_id = season_row.current_season
    assert season_row[0] == 1


def test_season(db_session):

# Path: nflpool/data/activeplayers.py
# class ActiveNFLPlayers(SqlAlchemyBase):
#     __tablename__ = "ActiveNFLPlayers"
#     primary_key = sqlalchemy.Column(
#         sqlalchemy.Integer, primary_key=True, autoincrement=True, index=True
#     )
#     season = sqlalchemy.Column(sqlalchemy.Integer)
#     team_id = sqlalchemy.Column(
#         sqlalchemy.Integer, sqlalchemy.ForeignKey("TeamInfo.team_id")
#     )
#     firstname = sqlalchemy.Column(sqlalchemy.String)
#     lastname = sqlalchemy.Column(sqlalchemy.String)
#     position = sqlalchemy.Column(sqlalchemy.String, index=True)
#     player_id = sqlalchemy.Column(
#         sqlalchemy.Integer, sqlalchemy.ForeignKey("PlayerPicks.player_id"), index=True
#     )
# 
# Path: nflpool/data/seasoninfo.py
# class SeasonInfo(SqlAlchemyBase):
#     __tablename__ = "SeasonInfo"
#     id = sqlalchemy.Column(sqlalchemy.Integer, primary_key=True, autoincrement=True)
#     current_season = sqlalchemy.Column(sqlalchemy.Integer)
#     season_start_date = sqlalchemy.Column(sqlalchemy.String)
#     home_team = sqlalchemy.Column(sqlalchemy.String)
#     away_team = sqlalchemy.Column(sqlalchemy.String)


# Path: tests/services/test_activeplayers.py
import pytest
    import nflpool.data.secret as secret
    import requests
from nflpool.data.activeplayers import ActiveNFLPlayers
from nflpool.data.seasoninfo import SeasonInfo
    from requests.auth import HTTPBasicAuth



def test_season_row(db_session):
    season_row = db_session.query(SeasonInfo.id).first()
    print(season_row)
    # season_id = season_row.current_season
    assert season_row[0] == 1


def test_season(db_session):

    season_row = db_session.query(SeasonInfo).filter(SeasonInfo.id == "1").first()