"""Test product physical packaging model."""

from ows_product_physical.connector.mysql import db_session
from ows_product_physical.models.product_physical_packaging import \
    ProductPhysicalPackaging


def test_physical_product_packaging(
        db_fixture, db_with_data, db_product_physical_packaging):
    """Test successful get for ProductPhysicalPackaging model."""
    with db_session() as session:
        results = session.query(ProductPhysicalPackaging).all()

        rows = [result.to_dict() for result in results]
        for idx, row in enumerate(rows):
            assert row['name'] == db_product_physical_packaging[idx]['name']