Method test_basic_crud

benchmarks/test_sqlalchemy.py:117–158

Test basic CRUD operations

(self)

            return False
    
    def test_basic_crud(self):
        """Test basic CRUD operations"""
        session = self.Session()
        try:
            # CREATE
            user = User(
                username="john_doe",
                email="john@example.com",
                full_name="John Doe",
                age=30,
                balance=Decimal('1000.50'),
                birth_date=date(1993, 5, 15),
                bio="Software developer",
                metadata_json={"interests": ["coding", "gaming"]}
            )
            session.add(user)
            session.commit()
            
            # READ
            retrieved = session.query(User).filter_by(username="john_doe").first()
            assert retrieved is not None
            assert retrieved.email == "john@example.com"
            assert retrieved.balance == Decimal('1000.50')
            
            # UPDATE
            retrieved.age = 31
            retrieved.metadata_json = {"interests": ["coding", "gaming", "reading"]}
            session.commit()
            
            updated = session.query(User).filter_by(id=retrieved.id).first()
            assert updated.age == 31
            assert len(updated.metadata_json["interests"]) == 3
            
            # DELETE
            session.delete(updated)
            session.commit()
            
            deleted = session.query(User).filter_by(username="john_doe").first()
            assert deleted is None
            
        finally:
            session.close()
    
    def test_relationships(self):
        """Test relationship operations"""