from src import db
from sqlalchemy import Select
from src.models import ConceptTable

def find_concepts_by_grade_and_stream(grade, stream):
    stmt = Select(ConceptTable).where(
        ConceptTable.grade == grade,
        ConceptTable.stream == stream
    )
    concepts = db.session.execute(stmt).scalars().all()
    return concepts