docstr: Mapper load strategy defaults can be downgraded with
  noload('*') option, while explicit subqueryload() option
  is still honored
docstr_tok: ["Mapper","load","strategy","defaults","can","be","downgraded","with","noload","(","'","*","'",")","option",",","while","explicit","subqueryload","(",")","option","is","still","honored"]
code: def test_noload_with_subqueryload(self):
      """Mapper load strategy defaults can be downgraded with
      noload('*') option, while explicit subqueryload() option
      is still honored"""
      sess = self._downgrade_fixture()
      users = []
  
      # test noload('*') option combined with subqueryload()
      # shuts off 'addresses' load AND orders.items load: 2 sql expected
      def go():
          users[:] = (
              sess.query(self.classes.User)
              .options(sa.orm.noload("*"))
              .options(subqueryload(self.classes.User.orders))
              .order_by(self.classes.User.id)
              .all()
          )
  
      self.assert_sql_count(testing.db, go, 2)
  
      def go():
          # Verify orders have already been loaded: 0 sql
          for u, static in zip(users, self.static.user_all_result):
              assert len(u.orders) == len(static.orders)
          # Verify noload('*') prevented orders.items load
          # and set 'items' to []
          for u in users:
              for o in u.orders:
                  assert o.items == []
  
      self.assert_sql_count(testing.db, go, 0)
  
imports: import sqlalchemy
  from sqlalchemy import testing
  from sqlalchemy import util
  from sqlalchemy.orm import defaultload
  from sqlalchemy.orm import joinedload
  from sqlalchemy.orm import relationship
  from sqlalchemy.orm import subqueryload
  from sqlalchemy.testing import eq_
  from sqlalchemy.testing.assertions import expect_raises_message
  from sqlalchemy.testing.fixtures import fixture_session
  from test.orm import _fixtures
label_desc: Use image node_id 15 for calling the DefaultStrategyOptionsTest obj's underlying member method code with example usage: obj.test_noload_with_subqueryload() without return types