preload type affinity entries so that these comparisons don't get shoved into the callcounts

1 files changed, 10 insertions, 0 deletions

diff --git a/test/aaa_profiling/test_compiler.py b/test/aaa_profiling/test_compiler.py
index b5645a241..e49a3df7f 100644
--- a/test/aaa_profiling/test_compiler.py
+++ b/test/aaa_profiling/test_compiler.py
@@ -15,6 +15,16 @@ class CompileTest(TestBase, AssertsExecutionResults):
             Column('c1', Integer, primary_key=True),
             Column('c2', String(30)))
 
+        # go through all the TypeEngine
+        # objects in use and pre-load their _type_affinity
+        # entries.
+        for t in (t1, t2):
+            for c in t.c:
+                c.type._type_affinity
+        from sqlalchemy import types
+        for t in types.type_map.values():
+            t._type_affinity
+            
     @profiling.function_call_count(69, {'2.4': 44, '3.0':77, '3.1':77})
     def test_insert(self):
         t1.insert().compile()