Digi-Key Vendor Map Audit Generation ProfilingΒΆ

Raw execution profile SVG of execution profile

Execution Profile

../../../_images/digikey.profile1.svg

pstats Output

Sun May 29 19:39:18 2016    /media/ldata/code/tendril/profiling/sourcing/genvmapaudit/digikey.profile

         93245972 function calls (91375435 primitive calls) in 523.802 seconds

   Ordered by: cumulative time

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
        1    0.000    0.000  525.109  525.109 vendors.py:53(profile_vendor_genvmapaudit)
        1    0.516    0.516  525.109  525.109 map.py:107(export_vendor_map_audit)
    11157    0.085    0.000  501.452    0.045 vendors.py:655(get_vpart)
    11157    0.070    0.000  501.367    0.045 digikey.py:212(__init__)
    11157    0.061    0.000  501.297    0.045 vendors.py:490(__init__)
    11157    0.074    0.000  501.236    0.045 vendors.py:257(__init__)
    11157    0.217    0.000  501.162    0.045 vendors.py:270(_populate)
    11157    0.421    0.000  363.471    0.033 vendors.py:307(load_from_db)
    11157    0.131    0.000  362.589    0.032 vendors.py:502(_load_from_db)
    11157    0.979    0.000  333.249    0.030 vendors.py:314(_load_from_db)
    72529    0.410    0.000  311.249    0.004 query.py:2511(__iter__)
    72529    0.612    0.000  290.689    0.004 query.py:2525(_execute_and_instances)
    72866    0.234    0.000  286.575    0.004 base.py:846(execute)
    72866    0.181    0.000  286.207    0.004 elements.py:322(_execute_on_connection)
    72866    0.954    0.000  286.026    0.004 base.py:975(_execute_clauseelement)
518997/485526    0.996    0.000  273.312    0.001 attributes.py:229(__get__)
81957/48486    0.408    0.000  272.346    0.006 attributes.py:556(get)
    33769    0.230    0.000  270.679    0.008 strategies.py:477(_load_for_state)
    33471    1.334    0.000  270.099    0.008 strategies.py:550(_emit_lazyload)
    35294    0.902    0.000  261.597    0.007 query.py:2393(all)
    72866    1.575    0.000  237.332    0.003 base.py:1061(_execute_context)
    72866    0.177    0.000  219.166    0.003 default.py:449(do_execute)
    72866  218.075    0.003  218.989    0.003 {method 'execute' of 'psycopg2.extensions.cursor' objects}
67035/13137    0.375    0.000  110.565    0.008 db.py:168(inner)
       39    0.002    0.000   96.632    2.478 digikey.py:242(_get_data)
       39    0.001    0.000   95.564    2.450 www.py:412(get_soup)
       39    0.004    0.000   94.030    2.411 www.py:366(fetch)
    11196    0.208    0.000   88.564    0.008 controller.py:112(get_vpno_obj)
    37235    0.832    0.000   78.787    0.002 query.py:2451(one)
     1658   73.802    0.045   73.802    0.045 {method 'recv' of '_socket.socket' objects}
    13018    0.400    0.000   72.952    0.006 controller.py:214(get_map)
       33    0.001    0.000   56.676    1.717 www.py:318(urlopen)
    75/33    0.003    0.000   56.672    1.717 urllib2.py:386(open)
   192/87    0.001    0.000   56.665    0.651 urllib2.py:374(_call_chain)
       75    0.002    0.000   56.440    0.753 urllib2.py:414(_open)
       75    0.001    0.000   56.438    0.753 urllib2.py:1213(http_open)
       75    0.007    0.000   56.437    0.752 urllib2.py:1139(do_open)
    72533    0.216    0.000   47.244    0.001 elements.py:431(compile)
    72533    0.327    0.000   47.028    0.001 elements.py:496(_compiler)
    72533    1.300    0.000   46.701    0.001 compiler.py:329(__init__)
    72533    0.281    0.000   45.177    0.001 compiler.py:167(__init__)
72534/72533    0.183    0.000   44.897    0.001 compiler.py:212(process)
1244013/72533    3.615    0.000   44.713    0.001 visitors.py:75(_compiler_dispatch)
72530/72529    2.331    0.000   44.240    0.001 compiler.py:1503(visit_select)
    25962    0.275    0.000   43.467    0.002 db.py:111(get_session)
   369/75    0.051    0.000   37.399    0.499 socket.py:336(read)
      348    0.007    0.000   37.388    0.107 httplib.py:540(read)
       75    0.003    0.000   36.618    0.488 httplib.py:1015(getresponse)
       75    0.005    0.000   36.609    0.488 httplib.py:408(begin)
     1359    0.019    0.000   36.545    0.027 socket.py:406(readline)
       75    0.004    0.000   36.320    0.484 httplib.py:369(_read_status)
    12981    0.040    0.000   35.393    0.003 contextlib.py:15(__enter__)
    13020    0.063    0.000   33.930    0.003 controller.py:45(_get_vendor)
    13020    0.165    0.000   33.821    0.003 controller.py:93(get_vendor)
    12981    0.307    0.000   33.566    0.003 db.py:83(_get_caller)
    75/33    0.001    0.000   32.519    0.985 urllib2.py:516(http_response)
    42/21    0.001    0.000   32.519    1.549 urllib2.py:429(error)
    42/21    0.001    0.000   32.518    1.548 www.py:234(http_error_301)
    42/21    0.003    0.000   32.518    1.548 urllib2.py:575(http_error_302)
    12981    0.052    0.000   32.111    0.002 inspect.py:1053(stack)
    12981    0.482    0.000   32.045    0.002 inspect.py:1026(getouterframes)
   191065    2.076    0.000   31.501    0.000 inspect.py:988(getframeinfo)
   212410    1.673    0.000   27.392    0.000 loading.py:30(instances)
   470507    3.533    0.000   21.735    0.000 compiler.py:1275(_label_select_column)
   191065    2.584    0.000   20.667    0.000 inspect.py:518(findsource)
      911    0.006    0.000   20.102    0.022 maps.py:77(get_all_partnos)
       75    0.000    0.000   19.807    0.264 httplib.py:977(request)
       75    0.002    0.000   19.807    0.264 httplib.py:998(_send_request)
       75    0.000    0.000   19.802    0.264 httplib.py:962(endheaders)
       75    0.001    0.000   19.802    0.264 httplib.py:820(_send_output)
       75    0.002    0.000   19.800    0.264 httplib.py:793(send)
       75    0.001    0.000   19.789    0.264 httplib.py:775(connect)
       75    0.004    0.000   19.788    0.264 socket.py:537(create_connection)
    72530    1.092    0.000   19.494    0.000 query.py:2953(_compile_context)
   470504    4.346    0.000   15.817    0.000 compiler.py:581(visit_label)
     1822    0.067    0.000   15.291    0.008 controller.py:255(get_map_vpnos)
   395111    4.070    0.000   13.879    0.000 inspect.py:440(getsourcefile)
   150126    1.991    0.000   12.710    0.000 loading.py:360(_instance)
       75   11.871    0.158   11.871    0.158 {_socket.getaddrinfo}
72530/72529    1.574    0.000   11.308    0.000 compiler.py:1679(_compose_select_body)
344000/126432    0.764    0.000   10.925    0.000 operators.py:294(__eq__)
277075/172921    0.515    0.000   10.456    0.000 {operator.eq}
      911    0.006    0.000   10.051    0.011 vendors.py:101(get_upartnos)
      911    0.004    0.000   10.045    0.011 vendors.py:97(get_apartnos)
   247295    1.128    0.000    9.515    0.000 base.py:196(generate)
238035/87391    1.159    0.000    8.514    0.000 visitors.py:86(_compiler_dispatch)
   139451    0.236    0.000    8.311    0.000 elements.py:738(operate)
    12981    0.167    0.000    8.282    0.001 contextlib.py:21(__exit__)
    72528    1.554    0.000    8.262    0.000 query.py:3282(row_processor)
    65095    0.084    0.000    8.252    0.000 attributes.py:174(operate)
   598760    4.499    0.000    8.157    0.000 compiler.py:620(visit_column)
    72530    1.205    0.000    8.116    0.000 query.py:3071(_simple_statement)
      911    0.003    0.000    8.078    0.009 controller.py:265(get_amap_vpnos)
    72866    0.508    0.000    8.057    0.000 psycopg2.py:466(get_result_proxy)
    72866    2.689    0.000    7.960    0.000 default.py:515(_init_compiled)
      150    0.002    0.000    7.916    0.053 socket.py:223(meth)
       75    7.907    0.105    7.907    0.105 {method 'connect' of '_socket.socket' objects}
   150087    2.061    0.000    7.733    0.000 loading.py:478(_populate_full)
 12814709    6.539    0.000    7.675    0.000 {isinstance}
    72528    0.430    0.000    7.519    0.000 query.py:3317(setup_context)
    72866    0.350    0.000    7.286    0.000 result.py:488(__init__)
      911    0.003    0.000    7.274    0.008 controller.py:271(get_umap_vpnos)
    98566    0.543    0.000    7.207    0.000 annotation.py:93(__eq__)
    12981    0.204    0.000    7.105    0.001 session.py:756(commit)
   113409    0.526    0.000    7.010    0.000 compiler.py:904(visit_binary)
   139451    0.581    0.000    7.005    0.000 type_api.py:57(operate)
    72528    1.660    0.000    7.003    0.000 loading.py:224(_setup_entity_query)
    72866    0.554    0.000    6.936    0.000 result.py:513(_init_metadata)
    13098    0.385    0.000    6.903    0.001 session.py:389(commit)
   204046    0.871    0.000    6.680    0.000 inspect.py:472(getmodule)
    72530    0.601    0.000    6.644    0.000 <string>:1(select)
    72528    3.475    0.000    6.597    0.000 loading.py:269(_instance_processor)
    72532    3.785    0.000    6.298    0.000 result.py:189(__init__)
   113409    0.642    0.000    6.247    0.000 compiler.py:935(_generate_generic_binary)
   586176    2.271    0.000    6.236    0.000 inspect.py:398(getfile)
    72530    1.970    0.000    6.042    0.000 selectable.py:2220(__init__)
   231406    0.257    0.000    5.667    0.000 type_api.py:1009(process)
    72529    0.253    0.000    5.658    0.000 session.py:1245(query)
    72530    0.724    0.000    5.620    0.000 compiler.py:1654(_setup_select_stack)
434468/434416    1.188    0.000    5.619    0.000 langhelpers.py:744(__get__)
   231406    0.362    0.000    5.410    0.000 arrow.py:73(process_result_value)
    72529    0.155    0.000    5.404    0.000 query.py:107(__init__)
   113414    0.746    0.000    5.382    0.000 default_comparator.py:21(_boolean_compare)
    72530    0.615    0.000    5.249    0.000 query.py:112(_set_entities)
    52077    0.191    0.000    5.185    0.000 properties.py:268(operate)
   153561    0.403    0.000    5.048    0.000 api.py:17(get)
   126160    0.329    0.000    4.959    0.000 inspect.py:460(getabsfile)
   608123    1.839    0.000    4.802    0.000 interfaces.py:498(setup)
   153561    1.195    0.000    4.644    0.000 factory.py:32(get)
    72530    0.585    0.000    4.552    0.000 selectable.py:2506(_get_display_froms)
   344726    0.902    0.000    4.437    0.000 {method 'join' of 'str' objects}
    98566    0.196    0.000    4.245    0.000 <string>:1(filter)
   126226    0.693    0.000    4.130    0.000 posixpath.py:365(abspath)
    26039    0.102    0.000    3.786    0.000 compiler.py:735(visit_clauselist)
    72531    1.762    0.000    3.756    0.000 selectable.py:2479(_froms)
    72529    0.322    0.000    3.681    0.000 result.py:944(fetchall)
    14842    0.066    0.000    3.542    0.000 query.py:1511(join)
    12981    0.077    0.000    3.537    0.000 base.py:1569(commit)
    78115    0.060    0.000    3.536    0.000 compiler.py:742(<genexpr>)
    46489    0.664    0.000    3.530    0.000 mapper.py:2451(_get_state_attr_by_column)
3028461/3028460    3.000    0.000    3.489    0.000 {getattr}
    78115    0.107    0.000    3.476    0.000 compiler.py:744(<genexpr>)
    14842    0.055    0.000    3.466    0.000 <string>:1(_join)
   569071    1.701    0.000    3.452    0.000 compiler.py:1130(_truncated_identifier)
    12981    0.043    0.000    3.445    0.000 base.py:1603(_do_commit)
    12981    0.237    0.000    3.402    0.000 base.py:679(_commit_impl)
    14842    0.154    0.000    3.270    0.000 query.py:1800(_join)
    72529    0.246    0.000    3.235    0.000 query.py:2518(_connection_from_session)
    98584    0.497    0.000    3.162    0.000 compiler.py:1048(visit_bindparam)
  1755415    1.893    0.000    3.123    0.000 compiler.py:2693(quote)
    12981    0.097    0.000    3.115    0.000 default.py:422(do_commit)
    13020    0.165    0.000    3.072    0.000 query.py:1310(filter_by)
    33471    0.322    0.000    3.054    0.000 strategies.py:448(_generate_lazy_clause)
    72529    0.291    0.000    2.989    0.000 session.py:811(connection)
    12981    2.980    0.000    2.980    0.000 {method 'commit' of 'psycopg2.extensions.connection' objects}
    14842    0.208    0.000    2.870    0.000 query.py:1915(_join_left_to_right)
    26079    0.411    0.000    2.865    0.000 session.py:456(close)
   113414    0.409    0.000    2.853    0.000 default_comparator.py:269(_check_literal)
    98566    0.750    0.000    2.803    0.000 query.py:1274(filter)
   395150    0.732    0.000    2.792    0.000 genericpath.py:15(exists)
    13018    0.144    0.000    2.781    0.000 relationships.py:961(__eq__)
    72531    0.642    0.000    2.655    0.000 selectable.py:3151(_columns_plus_names)
   745744    2.412    0.000    2.413    0.000 interfaces.py:466(_get_context_loader)
    72529    0.146    0.000    2.398    0.000 session.py:884(_connection_for_bind)
   139841    1.304    0.000    2.394    0.000 instrumentation.py:311(new_instance)
    33471    0.070    0.000    2.368    0.000 strategy_options.py:781(lazyload)
    33471    0.113    0.000    2.298    0.000 <string>:1(set_relationship_strategy)
    14842    0.129    0.000    2.294    0.000 query.py:2068(_join_to_left)
    11157    0.171    0.000    2.285    0.000 terminal.py:230(next)
73933/73231    0.367    0.000    2.255    0.000 session.py:312(_connection_for_bind)
    98584    0.286    0.000    2.212    0.000 compiler.py:1117(_truncate_bindparam)
    72529    0.145    0.000    2.193    0.000 result.py:911(_fetchall_impl)
    33472    0.142    0.000    2.185    0.000 base.py:40(_generative)
    52076    0.290    0.000    2.125    0.000 elements.py:3370(_bind_param)
    14842    0.044    0.000    2.104    0.000 util.py:880(join)
    11157    0.508    0.000    2.097    0.000 bar.py:65(update)
   126259    1.324    0.000    2.091    0.000 posixpath.py:336(normpath)
   395441    2.065    0.000    2.065    0.000 {posix.stat}
    14842    0.195    0.000    2.060    0.000 util.py:779(__init__)
    72529    1.226    0.000    2.048    0.000 {method 'fetchall' of 'psycopg2.extensions.cursor' objects}
   159902    0.603    0.000    2.022    0.000 _collections.py:794(to_list)
    72530    0.701    0.000    1.992    0.000 query.py:122(_set_entity_selectables)
   217594    1.019    0.000    1.939    0.000 _collections.py:747(unique_list)
   470506    0.632    0.000    1.925    0.000 default.py:753(get_result_processor)
   153561    1.897    0.000    1.903    0.000 util.py:25(is_timestamp)
    52100    1.062    0.000    1.835    0.000 elements.py:913(__init__)
   498927    1.009    0.000    1.818    0.000 inspection.py:38(inspect)
       39    0.000    0.000    1.811    0.046 vendors.py:287(commit)
       39    0.000    0.000    1.811    0.046 vendors.py:495(_commit_to_db)
  1975555    1.180    0.000    1.804    0.000 string.py:220(lower)
    33471    0.155    0.000    1.753    0.000 strategy_options.py:190(set_relationship_strategy)
    39060    0.215    0.000    1.717    0.000 session.py:694(begin)
   515927    1.715    0.000    1.715    0.000 {method 'match' of '_sre.SRE_Pattern' objects}
   232437    0.967    0.000    1.713    0.000 base.py:36(_from_objects)
91134/65096    0.240    0.000    1.685    0.000 annotation.py:71(_compiler_dispatch)
52074/26037    0.105    0.000    1.606    0.000 operators.py:43(__and__)
    14842    0.139    0.000    1.601    0.000 selectable.py:651(__init__)
   113414    0.925    0.000    1.584    0.000 elements.py:2724(__init__)
       39    0.001    0.000    1.579    0.040 vendors.py:294(_commit_to_db)
    26039    0.078    0.000    1.535    0.000 elements.py:2758(_copy_internals)
       39    0.002    0.000    1.533    0.039 __init__.py:80(__init__)
    72866    0.391    0.000    1.528    0.000 psycopg2.py:435(create_cursor)
       39    0.000    0.000    1.521    0.039 __init__.py:206(_feed)
       39    0.000    0.000    1.520    0.039 _lxml.py:221(feed)
       39    0.238    0.006    1.517    0.039 {method 'feed' of 'lxml.etree._FeedParser' objects}
    39060    0.291    0.000    1.501    0.000 session.py:169(__init__)
    98567    0.509    0.000    1.498    0.000 elements.py:3624(apply_map)
    12981    0.167    0.000    1.480    0.000 session.py:2646(__call__)
    12981    0.083    0.000    1.479    0.000 base.py:2020(contextual_connect)
    39063    0.114    0.000    1.441    0.000 elements.py:1890(and_)
   137621    0.567    0.000    1.431    0.000 interfaces.py:507(create_row_processor)
    98495    0.410    0.000    1.412    0.000 base.py:285(__get__)
    72539    0.473    0.000    1.405    0.000 _collections.py:359(__init__)
    12981    0.071    0.000    1.405    0.000 base.py:793(close)
    72531    0.370    0.000    1.387    0.000 query.py:3159(__new__)
    13018    0.157    0.000    1.382    0.000 relationships.py:1334(_optimized_compare)
    12981    0.045    0.000    1.333    0.000 pool.py:879(close)
    39063    0.467    0.000    1.327    0.000 elements.py:1856(_construct)
    72533    0.399    0.000    1.315    0.000 compiler.py:438(_bind_processors)
   470506    0.701    0.000    1.293    0.000 type_api.py:382(_cached_result_processor)
    12981    0.056    0.000    1.288    0.000 pool.py:756(_checkin)
    14842    0.047    0.000    1.288    0.000 selectable.py:786(_match_primaries)
    12981    0.190    0.000    1.279    0.000 session.py:512(__init__)
    26037    0.074    0.000    1.272    0.000 {operator.and_}
   153561    0.600    0.000    1.271    0.000 arrow.py:118(fromdatetime)
    33471    0.106    0.000    1.261    0.000 query.py:1090(options)
   981287    0.748    0.000    1.261    0.000 inspect.py:51(ismodule)
    72866    0.393    0.000    1.247    0.000 compiler.py:455(construct_params)
    12981    0.158    0.000    1.232    0.000 pool.py:615(_finalize_fairy)
    14842    0.123    0.000    1.232    0.000 selectable.py:793(_join_condition)
    13021    0.054    0.000    1.226    0.000 visitors.py:280(cloned_traverse)
    13018    0.043    0.000    1.221    0.000 util.py:746(_orm_annotate)
   470503    0.409    0.000    1.212    0.000 result.py:497(_getter)
   111589    0.180    0.000    1.203    0.000 session.py:1970(flush)
    13018    0.046    0.000    1.179    0.000 annotation.py:106(_deep_annotate)
39063/13021    0.319    0.000    1.168    0.000 visitors.py:287(clone)
    33471    0.066    0.000    1.155    0.000 <string>:1(_options)
   235859    0.625    0.000    1.136    0.000 abc.py:128(__instancecheck__)
39054/13018    0.165    0.000    1.132    0.000 annotation.py:113(clone)
   777241    0.657    0.000    1.112    0.000 inspect.py:59(isclass)
    72866    0.186    0.000    1.105    0.000 pool.py:845(cursor)
    12981    0.152    0.000    1.095    0.000 db.py:69(_format_frame)
   968306    0.641    0.000    1.064    0.000 inspect.py:181(istraceback)
       39    0.004    0.000    1.057    0.027 controller.py:180(populate_vpart_prices)
    26037    0.051    0.000    1.041    0.000 default_comparator.py:89(_conjunction_operate)
    33471    0.380    0.000    1.037    0.000 strategy_options.py:110(_generate_path)
     3291    0.005    0.000    1.030    0.000 element.py:1165(find_all)
     3291    0.079    0.000    1.025    0.000 element.py:478(_find_all)
  1432312    1.016    0.000    1.016    0.000 {built-in method __new__ of type object at 0x919120}
   470502    0.881    0.000    1.013    0.000 strategies.py:141(setup_query)
     2876    0.006    0.000    1.009    0.000 element.py:1154(find)
  3558773    1.005    0.000    1.005    0.000 {method 'append' of 'list' objects}
    98495    0.158    0.000    1.002    0.000 base.py:108(_for_instance)
    99308    0.154    0.000    0.995    0.000 _collections.py:727(__missing__)
   247295    0.577    0.000    0.988    0.000 query.py:416(_clone)
   470504    0.367    0.000    0.966    0.000 compiler.py:2722(format_label)
   111586    0.221    0.000    0.956    0.000 elements.py:2783(self_group)
   667601    0.949    0.000    0.949    0.000 weakref.py:314(__getitem__)
    11157    0.147    0.000    0.934    0.000 attributes.py:1066(set_committed_value)
    72528    0.559    0.000    0.932    0.000 query.py:3190(setup_entity)
    12981    0.081    0.000    0.930    0.000 session.py:1031(close)
    12981    0.028    0.000    0.927    0.000 base.py:2071(_wrap_pool_connect)
    39058    0.108    0.000    0.924    0.000 elements.py:291(_annotate)
   788643    0.923    0.000    0.923    0.000 {method 'update' of 'dict' objects}
    72866    0.919    0.000    0.919    0.000 {method 'cursor' of 'psycopg2.extensions.connection' objects}
    72538    0.133    0.000    0.916    0.000 compiler.py:441(<genexpr>)
    72530    0.261    0.000    0.905    0.000 base.py:325(_is_mapped_class)
14842/14841    0.119    0.000    0.901    0.000 compiler.py:1803(visit_join)
    72530    0.817    0.000    0.900    0.000 query.py:3715(__init__)
    12981    0.041    0.000    0.899    0.000 pool.py:367(connect)
    39060    0.388    0.000    0.898    0.000 session.py:256(_take_snapshot)
   137624    0.387    0.000    0.897    0.000 operators.py:895(is_precedent)
   300954    0.289    0.000    0.875    0.000 utf_8.py:15(decode)
    24329    0.144    0.000    0.861    0.000 _lxml.py:126(start)
   395111    0.860    0.000    0.860    0.000 {imp.get_suffixes}
   620849    0.815    0.000    0.859    0.000 {hasattr}
    12981    0.108    0.000    0.858    0.000 pool.py:710(_checkout)
    13018    0.023    0.000    0.851    0.000 elements.py:1168(effective_value)
    33471    0.353    0.000    0.849    0.000 query.py:1105(_options)
    12981    0.096    0.000    0.849    0.000 session.py:1076(_close_impl)
    98495    0.264    0.000    0.845    0.000 base.py:105(_for_class)
   140139    0.838    0.000    0.840    0.000 state.py:75(__init__)
    98567    0.574    0.000    0.836    0.000 compiler.py:1149(_process_anon)
   191066    0.214    0.000    0.836    0.000 re.py:188(compile)
    13018    0.030    0.000    0.827    0.000 relationships.py:1385(_go)
    80319    0.095    0.000    0.824    0.000 element.py:1525(search)
   470505    0.702    0.000    0.817    0.000 selectable.py:3156(name_for_col)
3404220/3404219    0.813    0.000    0.813    0.000 {len}
   122640    0.295    0.000    0.808    0.000 base.py:389(_inspect_mapped_class)
    11157    0.170    0.000    0.806    0.000 terminal.py:241(writeln)
   470503    0.802    0.000    0.804    0.000 result.py:419(_getter)
   105999    0.312    0.000    0.787    0.000 path_registry.py:62(set)
   171117    0.318    0.000    0.783    0.000 compiler.py:442(<genexpr>)
   777280    0.504    0.000    0.778    0.000 inspect.py:67(ismethod)
    12981    0.107    0.000    0.766    0.000 pool.py:501(checkin)
    72827    0.750    0.000    0.753    0.000 result.py:928(process_rows)
    12981    0.130    0.000    0.731    0.000 pool.py:478(checkout)
   217830    0.355    0.000    0.716    0.000 __init__.py:1345(isEnabledFor)
   968306    0.540    0.000    0.714    0.000 inspect.py:191(isframe)
    39057    0.223    0.000    0.701    0.000 elements.py:3919(__init__)
   154157    0.453    0.000    0.674    0.000 arrow.py:49(__init__)
   777280    0.446    0.000    0.667    0.000 inspect.py:142(isfunction)
   102223    0.343    0.000    0.667    0.000 selectable.py:35(_interpret_as_from)
    65121    0.224    0.000    0.657    0.000 elements.py:3513(__new__)
    72529    0.228    0.000    0.656    0.000 session.py:1279(_autoflush)
   139802    0.358    0.000    0.656    0.000 state.py:251(_cleanup)
    24329    0.069    0.000    0.654    0.000 __init__.py:324(handle_starttag)
   145060    0.144    0.000    0.642    0.000 selectable.py:2438(<genexpr>)
  1343686    0.641    0.000    0.641    0.000 {method 'get' of 'dict' objects}
    72534    0.534    0.000    0.634    0.000 elements.py:3665(_select_iterables)
  1995314    0.631    0.000    0.631    0.000 {method 'lower' of 'str' objects}
   191066    0.498    0.000    0.622    0.000 re.py:226(_compile)
    12981    0.034    0.000    0.620    0.000 pool.py:388(_return_conn)
    22314    0.058    0.000    0.620    0.000 __init__.py:39(__getitem__)
   470503    0.609    0.000    0.609    0.000 compiler.py:271(__init__)
    85510    0.417    0.000    0.600    0.000 langhelpers.py:1033(_next)
   126337    0.454    0.000    0.600    0.000 posixpath.py:68(join)
   470506    0.451    0.000    0.596    0.000 compiler.py:1272(_add_to_result_map)
    14842    0.187    0.000    0.594    0.000 selectable.py:847(_joincond_scan_left_right)
    37693    0.077    0.000    0.594    0.000 element.py:1484(search_tag)
   777280    0.483    0.000    0.591    0.000 inspect.py:209(iscode)
   300960    0.589    0.000    0.589    0.000 {_codecs.utf_8_decode}
   645402    0.588    0.000    0.588    0.000 {method 'copy' of 'dict' objects}
    12981    0.048    0.000    0.586    0.000 pool.py:1030(_do_return_conn)
    98495    0.427    0.000    0.580    0.000 base.py:74(__init__)
      117    0.006    0.000    0.580    0.005 session.py:2021(_flush)
    72529    0.278    0.000    0.575    0.000 query.py:306(_bind_mapper)
   119001    0.159    0.000    0.546    0.000 __init__.py:1130(debug)
    12981    0.149    0.000    0.539    0.000 queue.py:87(put)
      117    0.003    0.000    0.527    0.005 unitofwork.py:351(execute)
    72529    0.454    0.000    0.513    0.000 query.py:3107(_adjust_for_single_inheritance)
   124570    0.288    0.000    0.507    0.000 session.py:2016(_is_clean)
    33471    0.058    0.000    0.492    0.000 <string>:1(params)
       39    0.000    0.000    0.483    0.012 digikey.py:357(_get_attributes_table)
    13026    0.030    0.000    0.480    0.000 <string>:1(and_)
    12981    0.166    0.000    0.469    0.000 base.py:47(__init__)
    98584    0.254    0.000    0.459    0.000 type_api.py:372(_cached_bind_processor)
   137666    0.381    0.000    0.459    0.000 base.py:89(__getattr__)
    12981    0.059    0.000    0.453    0.000 pool.py:1039(_do_get)
    98584    0.453    0.000    0.453    0.000 compiler.py:1155(bindparam_string)
   163661    0.216    0.000    0.446    0.000 elements.py:3765(_expression_literal_as_text)
    13098    0.219    0.000    0.443    0.000 session.py:358(_prepare_impl)
   324286    0.440    0.000    0.440    0.000 attr.py:226(__bool__)
    13021    0.170    0.000    0.437    0.000 elements.py:1183(_clone)
   470504    0.243    0.000    0.423    0.000 elements.py:3839(_interpret_as_column_or_from)
   533735    0.422    0.000    0.422    0.000 elements.py:3292(_get_table)
   191065    0.228    0.000    0.419    0.000 <string>:8(__new__)
    11157    0.167    0.000    0.417    0.000 __init__.py:91(eta_td)
    72866    0.289    0.000    0.415    0.000 result.py:637(_soft_close)
    33471    0.113    0.000    0.411    0.000 <string>:1(_adapt_all_clauses)
   123055    0.175    0.000    0.409    0.000 base.py:208(manager_of_class)
    74311    0.407    0.000    0.407    0.000 {method 'encode' of 'unicode' objects}
    33510    0.250    0.000    0.402    0.000 state.py:565(_commit)
   226831    0.399    0.000    0.399    0.000 elements.py:698(self_group)
    12981    0.114    0.000    0.394    0.000 queue.py:130(get)
37966/37927    0.078    0.000    0.390    0.000 element.py:1551(_matches)
    26042    0.258    0.000    0.384    0.000 elements.py:1821(_from_objects)
    73065    0.216    0.000    0.381    0.000 __init__.py:260(endData)
   311777    0.381    0.000    0.381    0.000 _weakrefset.py:70(__contains__)
      351    0.001    0.000    0.380    0.001 unitofwork.py:528(execute)
   113416    0.379    0.000    0.379    0.000 elements.py:2754(_from_objects)
      351    0.007    0.000    0.378    0.001 persistence.py:124(save_obj)
    26046    0.192    0.000    0.374    0.000 elements.py:235(_clone)
   126160    0.371    0.000    0.371    0.000 {posix.getcwd}
    24329    0.057    0.000    0.362    0.000 _lxml.py:175(end)
    22314    0.121    0.000    0.361    0.000 attributes.py:629(set_committed_value)
   217830    0.361    0.000    0.361    0.000 __init__.py:1331(getEffectiveLevel)
  1189856    0.357    0.000    0.357    0.000 {method 'add' of 'set' objects}
    11158    0.341    0.000    0.341    0.000 {method 'flush' of 'file' objects}
   173258    0.233    0.000    0.335    0.000 default.py:592(<genexpr>)
    11157    0.116    0.000    0.331    0.000 attributes.py:976(_initialize_collection)
   686592    0.325    0.000    0.325    0.000 {method 'intersection' of 'set' objects}
    33471    0.072    0.000    0.324    0.000 strategy_options.py:216(_set_path_strategy)
   528796    0.322    0.000    0.322    0.000 {method 'startswith' of 'str' objects}
   236196    0.191    0.000    0.320    0.000 elements.py:3769(_literal_as_text)
    33471    0.060    0.000    0.316    0.000 path_registry.py:250(entity_path)
    65126    0.211    0.000    0.316    0.000 elements.py:3469(__new__)
       39    0.000    0.000    0.313    0.008 digikey.py:348(_get_overview_table)
    64935    0.269    0.000    0.311    0.000 {sorted}
    46489    0.209    0.000    0.309    0.000 elements.py:2742(__bool__)
    87373    0.160    0.000    0.308    0.000 compiler.py:1788(visit_table)
    24368    0.100    0.000    0.303    0.000 element.py:745(__init__)
    73231    0.203    0.000    0.303    0.000 session.py:1142(get_bind)
      351    0.007    0.000    0.299    0.001 persistence.py:720(_emit_insert_statements)
   138891    0.206    0.000    0.298    0.000 identity.py:190(_fast_discard)
    12981    0.115    0.000    0.297    0.000 pool.py:764(_reset)
   155772    0.293    0.000    0.293    0.000 weakref.py:282(__init__)
    33471    0.146    0.000    0.289    0.000 strategy_options.py:86(_generate)
    33471    0.054    0.000    0.287    0.000 <string>:1(_with_invoke_all_eagers)
   470502    0.286    0.000    0.286    0.000 compiler.py:280(type)
   126226    0.168    0.000    0.286    0.000 posixpath.py:59(isabs)
       75    0.002    0.000    0.282    0.004 mimetools.py:24(__init__)
    33471    0.055    0.000    0.278    0.000 strategy_options.py:94(process_query)
    39058    0.178    0.000    0.277    0.000 annotation.py:45(__init__)
    26037    0.075    0.000    0.276    0.000 elements.py:1967(self_group)
       75    0.001    0.000    0.275    0.004 rfc822.py:88(__init__)
       75    0.024    0.000    0.274    0.004 httplib.py:238(readheaders)
    11157    0.272    0.000    0.272    0.000 {method 'writerow' of '_csv.writer' objects}
       39    0.003    0.000    0.265    0.007 digikey.py:266(_get_prices)
    68562    0.153    0.000    0.263    0.000 vendors.py:218(__init__)
    33471    0.101    0.000    0.256    0.000 path_registry.py:254(__getitem__)
    91150    0.116    0.000    0.253    0.000 langhelpers.py:750(_reset)
   140256    0.252    0.000    0.252    0.000 {method 'issuperset' of 'frozenset' objects}
    72530    0.251    0.000    0.251    0.000 query.py:2638(_select_args)
    11157    0.094    0.000    0.249    0.000 __init__.py:87(eta)
    25964    0.174    0.000    0.248    0.000 threading.py:146(acquire)
    33471    0.115    0.000    0.238    0.000 strategy_options.py:185(_coerce_strat)
   137621    0.236    0.000    0.236    0.000 strategies.py:615(create_row_processor)
   123109    0.234    0.000    0.234    0.000 {method 'get' of 'dictproxy' objects}
    12981    0.038    0.000    0.234    0.000 base.py:534(begin)
       39    0.002    0.000    0.233    0.006 controller.py:127(populate_vpart_detail)
       39    0.002    0.000    0.231    0.006 controller.py:153(populate_vpart_detail_eln)
    98567    0.230    0.000    0.230    0.000 {method 'split' of 'unicode' objects}
    12981    0.161    0.000    0.230    0.000 session.py:1082(expunge_all)
    11118    0.048    0.000    0.226    0.000 arrow.py:341(timestamp)
    72528    0.193    0.000    0.224    0.000 query.py:3180(__init__)
    33471    0.126    0.000    0.223    0.000 strategy_options.py:100(_process)
       78    0.006    0.000    0.222    0.003 digikey.py:312(_get_table)
   154157    0.112    0.000    0.221    0.000 util.py:37(isstr)
    72866    0.191    0.000    0.220    0.000 default.py:692(should_autocommit)
   124570    0.218    0.000    0.218    0.000 identity.py:53(check_modified)
    33471    0.174    0.000    0.216    0.000 _collections.py:805(has_intersection)
   404847    0.214    0.000    0.214    0.000 {max}
    44626    0.069    0.000    0.214    0.000 element.py:1448(_normalize_search_value)
    11032    0.090    0.000    0.212    0.000 collections.py:659(append_multiple_without_event)
    66942    0.092    0.000    0.210    0.000 _collections.py:846(flatten_iterator)
    72530    0.206    0.000    0.206    0.000 selectable.py:1695(__init__)
   126554    0.202    0.000    0.202    0.000 {method 'split' of 'str' objects}
    26038    0.038    0.000    0.201    0.000 elements.py:1825(self_group)
    85550    0.153    0.000    0.196    0.000 query.py:289(_mapper_zero)
    12981    0.061    0.000    0.195    0.000 base.py:1595(__init__)
   145056    0.195    0.000    0.195    0.000 annotation.py:90(__hash__)
    16665    0.036    0.000    0.194    0.000 schema.py:1635(get_referent)
    33471    0.115    0.000    0.194    0.000 query.py:1254(params)
   145056    0.192    0.000    0.192    0.000 query.py:3262(_get_entity_clauses)
    11157    0.080    0.000    0.189    0.000 instrumentation.py:290(initialize_collection)
    52076    0.165    0.000    0.188    0.000 type_api.py:424(coerce_compared_value)
        1    0.002    0.002    0.183    0.183 vendors.py:87(get_idents)
   191065    0.183    0.000    0.183    0.000 linecache.py:33(getlines)
   139841    0.182    0.000    0.182    0.000 identity.py:140(_add_unpresent)
    72528    0.180    0.000    0.180    0.000 path_registry.py:70(get)
        1    0.000    0.000    0.176    0.176 controller.py:287(get_vendor_idents)
    72866    0.175    0.000    0.175    0.000 {sqlalchemy.cutils._distill_params}
   113420    0.137    0.000    0.174    0.000 type_api.py:1137(to_instance)
33494/33491    0.090    0.000    0.172    0.000 path_registry.py:283(__getitem__)
    12981    0.066    0.000    0.168    0.000 weakref.py:98(__setitem__)
    68562    0.096    0.000    0.163    0.000 collections.py:1071(append)
    14842    0.130    0.000    0.161    0.000 query.py:1983(_prepare_right_side)
    34067    0.111    0.000    0.159    0.000 session.py:37(_state_session)
    16670    0.113    0.000    0.158    0.000 selectable.py:450(corresponding_column)
   150126    0.157    0.000    0.157    0.000 identity.py:145(get)
    98568    0.157    0.000    0.157    0.000 query.py:228(_adapt_clause)
    72890    0.126    0.000    0.155    0.000 _collections.py:394(__iter__)
    25964    0.126    0.000    0.151    0.000 threading.py:186(release)
    12981    0.097    0.000    0.151    0.000 default.py:419(do_rollback)
    25962    0.100    0.000    0.149    0.000 threading.py:372(notify)
   642791    0.149    0.000    0.149    0.000 {method 'update' of 'set' objects}
   140139    0.148    0.000    0.148    0.000 <string>:1(set)
    16711    0.057    0.000    0.148    0.000 __init__.py:145(_replace_cdata_list_attribute_values)
    13020    0.064    0.000    0.145    0.000 base.py:359(_entity_descriptor)
    24329    0.021    0.000    0.144    0.000 __init__.py:351(handle_endtag)
   308618    0.144    0.000    0.144    0.000 {method 'pop' of 'dict' objects}
   100948    0.144    0.000    0.144    0.000 session.py:190(_assert_active)
    33471    0.093    0.000    0.143    0.000 strategy_options.py:80(__init__)
    33471    0.087    0.000    0.143    0.000 base.py:314(_generate)
   194705    0.140    0.000    0.140    0.000 {method 'endswith' of 'str' objects}
    22317    0.138    0.000    0.138    0.000 {print}
    91150    0.111    0.000    0.136    0.000 langhelpers.py:753(reset)
    66942    0.133    0.000    0.133    0.000 interfaces.py:486(_get_strategy)
   100138    0.131    0.000    0.131    0.000 elements.py:3657(_expand_cloned)
    11157    0.099    0.000    0.130    0.000 vendors.py:409(abs_moq)
    72866    0.104    0.000    0.126    0.000 base.py:1220(_safe_close_cursor)
    33474    0.125    0.000    0.125    0.000 path_registry.py:267(__init__)
    33471    0.083    0.000    0.121    0.000 __init__.py:99(progress)
    39063    0.066    0.000    0.120    0.000 _collections.py:787(coerce_generator_arg)
    24329    0.068    0.000    0.119    0.000 __init__.py:301(_popToTag)
   111511    0.118    0.000    0.118    0.000 {method 'acquire' of 'thread.lock' objects}
    11157    0.042    0.000    0.117    0.000 helpers.py:61(clearln)
   245998    0.116    0.000    0.116    0.000 {method 'values' of 'dict' objects}
    39059    0.092    0.000    0.116    0.000 annotation.py:31(__new__)
    12981    0.096    0.000    0.114    0.000 base.py:642(_begin_impl)
   224720    0.114    0.000    0.114    0.000 {min}
    11118    0.106    0.000    0.113    0.000 {method 'utctimetuple' of 'datetime.datetime' objects}
    68562    0.094    0.000    0.110    0.000 currency.py:223(__init__)
   166127    0.079    0.000    0.109    0.000 {next}
   113408    0.109    0.000    0.109    0.000 query.py:389(_no_limit_offset)
    11157    0.042    0.000    0.108    0.000 __init__.py:44(avg)
    72827    0.107    0.000    0.108    0.000 {zip}
   470504    0.107    0.000    0.107    0.000 elements.py:3521(apply_map)
   113408    0.106    0.000    0.106    0.000 query.py:381(_no_statement_condition)
   122640    0.106    0.000    0.106    0.000 instrumentation.py:94(is_mapped)
   470508    0.100    0.000    0.100    0.000 elements.py:758(_select_iterable)
    13020    0.060    0.000    0.099    0.000 query.py:300(_joinpoint_zero)
    26042    0.068    0.000    0.098    0.000 elements.py:716(comparator)
    31523    0.042    0.000    0.097    0.000 __init__.py:290(object_was_parsed)
    68562    0.075    0.000    0.096    0.000 vendors.py:344(add_price)
    37425    0.096    0.000    0.096    0.000 {range}
    14841    0.044    0.000    0.094    0.000 selectable.py:1057(_hide_froms)
   390364    0.092    0.000    0.092    0.000 mapper.py:642(mapper)
    72528    0.091    0.000    0.091    0.000 mapper.py:1890(_with_polymorphic_mappers)
139529/139519    0.080    0.000    0.091    0.000 {setattr}
    51167    0.087    0.000    0.090    0.000 attr.py:214(__call__)
   132036    0.069    0.000    0.089    0.000 {hash}
    13018    0.077    0.000    0.086    0.000 relationships.py:1363(visit_bindparam)
    72530    0.086    0.000    0.086    0.000 base.py:1472(get_select_precolumns)
    41323    0.033    0.000    0.086    0.000 {method 'decode' of 'str' objects}
   100184    0.086    0.000    0.086    0.000 {method 'pop' of 'list' objects}
   100392    0.085    0.000    0.085    0.000 {_codecs.utf_8_encode}
14846/14844    0.061    0.000    0.085    0.000 selectable.py:1062(_from_objects)
    72866    0.084    0.000    0.084    0.000 result.py:632(_cursor_description)
    12981    0.050    0.000    0.084    0.000 base.py:116(_join)
    22316    0.081    0.000    0.081    0.000 {method 'isatty' of 'file' objects}
    25962    0.080    0.000    0.080    0.000 identity.py:14(__init__)
   473388    0.078    0.000    0.078    0.000 {id}
      117    0.003    0.000    0.077    0.001 unitofwork.py:300(_generate_actions)
   161581    0.077    0.000    0.077    0.000 mapper.py:1965(selectable)
  128/103    0.000    0.000    0.075    0.001 errors.py:254(wrapper)
    55891    0.073    0.000    0.073    0.000 element.py:188(setup)
       33    0.001    0.000    0.073    0.002 utils.py:111(movefile)
    25962    0.042    0.000    0.072    0.000 pool.py:854(__getattr__)
    13018    0.061    0.000    0.071    0.000 controller.py:57(_get_ident)
     6999    0.070    0.000    0.070    0.000 {method 'split' of '_sre.SRE_Pattern' objects}
    12981    0.057    0.000    0.070    0.000 contextlib.py:82(helper)
    31523    0.027    0.000    0.068    0.000 element.py:648(__new__)
       33    0.000    0.000    0.067    0.002 base.py:1166(_shutil_movefile)
    12981    0.067    0.000    0.067    0.000 weakref.py:267(__init__)
       33    0.001    0.000    0.067    0.002 shutil.py:265(move)
    68562    0.027    0.000    0.067    0.000 collections.py:1038(__set)
    12981    0.033    0.000    0.067    0.000 log.py:54(_should_log_debug)
    11572    0.067    0.000    0.067    0.000 instrumentation.py:302(get_impl)
    11118    0.060    0.000    0.064    0.000 calendar.py:610(timegm)
    11157    0.063    0.000    0.063    0.000 {sum}
    77886    0.063    0.000    0.063    0.000 base.py:301(connection)
   126262    0.061    0.000    0.061    0.000 posixpath.py:51(normcase)
     1170    0.008    0.000    0.061    0.000 unitofwork.py:417(execute)
       33    0.001    0.000    0.060    0.002 shutil.py:122(copy2)
    90186    0.060    0.000    0.060    0.000 {method 'items' of 'dict' objects}
    73353    0.059    0.000    0.059    0.000 _collections.py:724(__init__)
    12981    0.026    0.000    0.058    0.000 log.py:57(_should_log_info)
    12981    0.041    0.000    0.056    0.000 session.py:297(_remove_snapshot)
    24368    0.046    0.000    0.056    0.000 __init__.py:251(pushTag)
       33    0.005    0.000    0.056    0.002 shutil.py:66(copyfile)
    12981    0.055    0.000    0.055    0.000 pool.py:559(get_connection)
   111511    0.054    0.000    0.054    0.000 {method 'release' of 'thread.lock' objects}
   106001    0.054    0.000    0.054    0.000 query.py:3746(<genexpr>)
    15449    0.053    0.000    0.053    0.000 state.py:277(dict)
    33471    0.050    0.000    0.050    0.000 query.py:224(_adapt_all_clauses)
    12981    0.021    0.000    0.049    0.000 queue.py:198(_get)
   117063    0.049    0.000    0.049    0.000 selectable.py:1418(_from_objects)
    34067    0.048    0.000    0.048    0.000 weakref.py:69(__getitem__)
    77890    0.048    0.000    0.048    0.000 threading.py:63(_note)
    29610    0.047    0.000    0.047    0.000 {method 'remove' of 'list' objects}
    32729    0.022    0.000    0.046    0.000 _lxml.py:194(data)
        6    0.043    0.007    0.046    0.008 {method 'read' of '_io.TextIOWrapper' objects}
    33471    0.038    0.000    0.045    0.000 path_registry.py:77(__len__)
    89622    0.044    0.000    0.044    0.000 {method 'keys' of 'dict' objects}
    11157    0.021    0.000    0.044    0.000 __init__.py:95(percent)
    85549    0.043    0.000    0.043    0.000 query.py:286(_entity_zero)
    11157    0.043    0.000    0.043    0.000 collections.py:578(__init__)
      351    0.002    0.000    0.043    0.000 persistence.py:597(_emit_update_statements)
    14846    0.038    0.000    0.042    0.000 elements.py:269(_cloned_set)
    14840    0.031    0.000    0.042    0.000 query.py:3245(corresponds_to)
   158046    0.042    0.000    0.042    0.000 {callable}
   112816    0.038    0.000    0.042    0.000 element.py:1190(descendants)
    33886    0.042    0.000    0.042    0.000 {method 'intersection' of 'frozenset' objects}
    42626    0.041    0.000    0.041    0.000 element.py:666(__getattr__)
    52041    0.040    0.000    0.040    0.000 session.py:225(_is_transaction_boundary)
    12981    0.040    0.000    0.040    0.000 {method 'format' of 'str' objects}
      220    0.001    0.000    0.040    0.000 collections.py:701(fire_append_event)
       67    0.039    0.001    0.039    0.001 {open}
    73022    0.036    0.000    0.039    0.000 _collections.py:155(union)
      220    0.003    0.000    0.038    0.000 attributes.py:932(fire_append_event)
    14842    0.037    0.000    0.037    0.000 selectable.py:874(<lambda>)
      702    0.001    0.000    0.037    0.000 unitofwork.py:482(execute)
     3291    0.008    0.000    0.036    0.000 element.py:1421(__init__)
    72866    0.036    0.000    0.036    0.000 compiler.py:215(__str__)
    25962    0.030    0.000    0.036    0.000 threading.py:237(_is_owned)
    12981    0.025    0.000    0.036    0.000 weakref.py:262(__new__)
    68562    0.035    0.000    0.035    0.000 vendors.py:593(currency)
    72650    0.035    0.000    0.035    0.000 {method 'union' of 'set' objects}
    13098    0.028    0.000    0.034    0.000 identity.py:184(all_states)
     3217    0.034    0.000    0.034    0.000 {method 'write' of 'cStringIO.StringO' objects}
    12981    0.033    0.000    0.033    0.000 base.py:255(__init__)
    12945    0.032    0.000    0.032    0.000 weakref.py:48(remove)
   137621    0.032    0.000    0.032    0.000 interfaces.py:617(setup_query)
      415    0.003    0.000    0.032    0.000 session.py:1588(_save_or_update_state)
    26042    0.031    0.000    0.031    0.000 type_api.py:53(__init__)
    12981    0.026    0.000    0.031    0.000 queue.py:190(_full)
    12981    0.026    0.000    0.030    0.000 queue.py:194(_put)
    35212    0.030    0.000    0.030    0.000 {method 'difference_update' of 'set' objects}
    75675    0.029    0.000    0.029    0.000 {iter}
    24329    0.024    0.000    0.029    0.000 __init__.py:242(popTag)
     1117    0.003    0.000    0.029    0.000 persistence.py:1017(_connections_for_states)
    16504    0.028    0.000    0.028    0.000 {method 'popleft' of 'collections.deque' objects}
    87383    0.028    0.000    0.028    0.000 selectable.py:170(selectable)
    12981    0.027    0.000    0.027    0.000 session.py:239(_iterate_parents)
    80073    0.027    0.000    0.027    0.000 vendors.py:223(moq)
    11157    0.019    0.000    0.026    0.000 __init__.py:103(remaining)
    77892    0.026    0.000    0.026    0.000 {thread.get_ident}
    16670    0.026    0.000    0.026    0.000 base.py:590(contains_column)
      766    0.004    0.000    0.025    0.000 persistence.py:256(_organize_states_for_save)
    80213    0.025    0.000    0.025    0.000 _lxml.py:64(_getNsTag)
     3291    0.006    0.000    0.025    0.000 element.py:1609(__init__)
    32729    0.015    0.000    0.024    0.000 __init__.py:356(handle_data)
    72866    0.024    0.000    0.024    0.000 default.py:747(pre_exec)
     1050    0.003    0.000    0.024    0.000 attributes.py:222(__set__)
    72866    0.023    0.000    0.023    0.000 default.py:750(post_exec)
      415    0.011    0.000    0.023    0.000 mapper.py:2555(cascade_iterator)
  376/298    0.002    0.000    0.023    0.000 attributes.py:778(set)
    72866    0.022    0.000    0.022    0.000 {method 'close' of 'psycopg2.extensions.cursor' objects}
        1    0.000    0.000    0.021    0.021 vendors.py:81(length)
      351    0.001    0.000    0.021    0.000 unitofwork.py:557(execute)
      337    0.003    0.000    0.021    0.000 default.py:807(_setup_crud_result_proxy)
    11157    0.021    0.000    0.021    0.000 {math.ceil}
      351    0.004    0.000    0.020    0.000 persistence.py:223(delete_obj)
  376/298    0.003    0.000    0.020    0.000 attributes.py:815(fire_replace_event)
      298    0.002    0.000    0.020    0.000 state.py:296(_initialize_instance)
     2053    0.007    0.000    0.020    0.000 unitofwork.py:178(get_attribute_history)
    12981    0.020    0.000    0.020    0.000 {method 'rollback' of 'psycopg2.extensions.connection' objects}
   146108    0.020    0.000    0.020    0.000 element.py:918(__nonzero__)
    51927    0.020    0.000    0.020    0.000 {method 'setdefault' of 'dict' objects}
      220    0.002    0.000    0.020    0.000 unitofwork.py:29(append)
    12981    0.020    0.000    0.020    0.000 base.py:1532(__init__)
        1    0.000    0.000    0.019    0.019 controller.py:297(get_vendor_map_length)
    12981    0.019    0.000    0.019    0.000 pool.py:677(__init__)
      220    0.001    0.000    0.019    0.000 <string>:1(__init__)
     2866    0.008    0.000    0.019    0.000 element.py:494(<genexpr>)
    52076    0.018    0.000    0.018    0.000 langhelpers.py:825(<lambda>)
      117    0.002    0.000    0.017    0.000 dependency.py:745(process_saves)
    33471    0.017    0.000    0.017    0.000 query.py:906(_with_invoke_all_eagers)
      351    0.002    0.000    0.017    0.000 dependency.py:445(presort_saves)
      557    0.001    0.000    0.017    0.000 type_api.py:961(process)
      557    0.002    0.000    0.016    0.000 arrow.py:68(process_bind_param)
      298    0.002    0.000    0.016    0.000 base.py:633(_declarative_constructor)
        1    0.000    0.000    0.016    0.016 query.py:2697(count)
      117    0.001    0.000    0.015    0.000 unitofwork.py:375(finalize_flush_changes)
    22302    0.015    0.000    0.015    0.000 {time.time}
      702    0.005    0.000    0.015    0.000 persistence.py:1052(_sort_states)
     1128    0.003    0.000    0.015    0.000 unitofwork.py:228(register_object)
    12981    0.015    0.000    0.015    0.000 base.py:1537(_parent)
    24368    0.015    0.000    0.015    0.000 __init__.py:101(can_be_empty_element)
      234    0.002    0.000    0.015    0.000 dependency.py:541(process_saves)
        1    0.000    0.000    0.015    0.015 query.py:2484(scalar)
      117    0.004    0.000    0.014    0.000 session.py:1491(_register_newly_persistent)
    14842    0.014    0.000    0.014    0.000 query.py:2112(_reset_joinpoint)
      298    0.000    0.000    0.014    0.000 attributes.py:602(append)
    24147    0.013    0.000    0.013    0.000 {method 'append' of 'collections.deque' objects}
    12982    0.013    0.000    0.013    0.000 {sys._getframe}
    52079    0.013    0.000    0.013    0.000 elements.py:378(_copy_internals)
    12981    0.013    0.000    0.013    0.000 contextlib.py:12(__init__)
    13021    0.013    0.000    0.013    0.000 interfaces.py:362(adapter)
     2105    0.003    0.000    0.013    0.000 element.py:846(get_text)
     7618    0.013    0.000    0.013    0.000 _abcoll.py:389(keys)
      117    0.009    0.000    0.012    0.000 topological.py:55(find_cycles)
      220    0.001    0.000    0.012    0.000 attributes.py:1167(emit_backref_from_collection_append_event)
      117    0.000    0.000    0.012    0.000 session.py:1559(add)
     1568    0.006    0.000    0.012    0.000 attributes.py:687(set)
      351    0.005    0.000    0.012    0.000 dependency.py:68(per_property_flush_actions)
      376    0.003    0.000    0.012    0.000 unitofwork.py:71(set_)
      351    0.000    0.000    0.012    0.000 persistence.py:336(_organize_states_for_delete)
    13450    0.011    0.000    0.011    0.000 {method 'discard' of 'set' objects}
      596    0.005    0.000    0.011    0.000 sync.py:16(populate)
      259    0.002    0.000    0.011    0.000 default.py:1002(_process_executesingle_defaults)
      234    0.004    0.000    0.011    0.000 unitofwork.py:257(_per_mapper_flush_actions)
    11157    0.011    0.000    0.011    0.000 vendors.py:397(ident)
    12981    0.011    0.000    0.011    0.000 queue.py:186(_empty)
    14841    0.011    0.000    0.011    0.000 mapper.py:2278(common_parent)
      267    0.010    0.000    0.010    0.000 socket.py:276(close)
       33    0.000    0.000    0.010    0.000 tempfile.py:274(mkstemp)
    11196    0.010    0.000    0.010    0.000 vendors.py:351(vpno)
    11196    0.010    0.000    0.010    0.000 vendors.py:378(mpartno)
      150    0.002    0.000    0.010    0.000 httplib.py:524(close)
    24368    0.009    0.000    0.010    0.000 __init__.py:255(set_up_substitutions)
       33    0.001    0.000    0.010    0.000 tempfile.py:230(_mkstemp_inner)
       33    0.001    0.000    0.010    0.000 shutil.py:46(copyfileobj)
      167    0.010    0.000    0.010    0.000 {method 'write' of 'file' objects}
     3510    0.004    0.000    0.010    0.000 unitofwork.py:402(<genexpr>)
    13018    0.010    0.000    0.010    0.000 relationships.py:1384(_get_attr_w_warn_on_none)
      298    0.002    0.000    0.010    0.000 dependency.py:759(_synchronize)
      702    0.002    0.000    0.009    0.000 session.py:229(connection)
    11235    0.009    0.000    0.009    0.000 vendors.py:359(vqtyavail)
    14840    0.009    0.000    0.009    0.000 query.py:3241(entity_zero_or_selectable)
      649    0.006    0.000    0.009    0.000 persistence.py:362(_collect_insert_commands)
    11157    0.009    0.000    0.009    0.000 terminal.py:226(term_width)
      298    0.001    0.000    0.009    0.000 dependency.py:565(_synchronize)
      415    0.003    0.000    0.009    0.000 mapper.py:1774(_is_orphan)
    11196    0.009    0.000    0.009    0.000 vendors.py:367(manufacturer)
    33589    0.008    0.000    0.008    0.000 {method 'join' of 'unicode' objects}
      259    0.001    0.000    0.008    0.000 base.py:1877(get_insert_default)
     1527    0.001    0.000    0.008    0.000 topological.py:43(sort)
     1170    0.003    0.000    0.008    0.000 dependency.py:230(prop_has_changes)
    11714    0.008    0.000    0.008    0.000 tz.py:47(utcoffset)
       39    0.001    0.000    0.008    0.000 _lxml.py:197(doctype)
     4840    0.003    0.000    0.008    0.000 element.py:821(_all_strings)
      766    0.004    0.000    0.008    0.000 relationships.py:1504(cascade_iterator)
    14770    0.008    0.000    0.008    0.000 {method 'strip' of 'str' objects}
      298    0.002    0.000    0.007    0.000 arrow.py:425(to)
      259    0.001    0.000    0.007    0.000 default.py:962(get_insert_default)
      159    0.001    0.000    0.007    0.000 urlparse.py:137(urlparse)
     1755    0.004    0.000    0.007    0.000 unitofwork.py:399(_mappers)
     1209    0.004    0.000    0.007    0.000 rfc822.py:197(isheader)
      136    0.002    0.000    0.007    0.000 __init__.py:156(getsyspath)
    11196    0.007    0.000    0.007    0.000 vendors.py:389(vpartdesc)
      298    0.005    0.000    0.007    0.000 default.py:881(_setup_ins_pk_from_implicit_returning)
      259    0.001    0.000    0.007    0.000 default.py:948(_exec_default)
     1234    0.002    0.000    0.007    0.000 unitofwork.py:503(_elements)
      708    0.005    0.000    0.007    0.000 topological.py:16(sort_as_subsets)
       75    0.007    0.000    0.007    0.000 {method 'sendall' of '_socket.socket' objects}
      585    0.001    0.000    0.007    0.000 dependency.py:581(_pks_changed)
      298    0.001    0.000    0.006    0.000 api.py:25(utcnow)
    11235    0.006    0.000    0.006    0.000 vendors.py:512(package)
      713    0.004    0.000    0.006    0.000 mapper.py:2397(_identity_key_from_state)
    13020    0.006    0.000    0.006    0.000 interfaces.py:111(setup)
     2164    0.005    0.000    0.006    0.000 state.py:524(_modified_event)
      259    0.000    0.000    0.006    0.000 schema.py:1990(<lambda>)
      298    0.001    0.000    0.006    0.000 factory.py:206(utcnow)
    13020    0.006    0.000    0.006    0.000 interfaces.py:120(create_row_processor)
      159    0.003    0.000    0.006    0.000 urlparse.py:168(urlsplit)
      415    0.001    0.000    0.006    0.000 session.py:1842(_save_or_update_impl)
     1117    0.002    0.000    0.006    0.000 unitofwork.py:293(states_for_mapper_hierarchy)
     1209    0.004    0.000    0.006    0.000 httplib.py:224(addheader)
       78    0.001    0.000    0.006    0.000 _lxml.py:72(prepare_markup)
      585    0.002    0.000    0.005    0.000 sync.py:106(source_modified)
    12981    0.005    0.000    0.005    0.000 default.py:416(do_begin)
    11157    0.005    0.000    0.005    0.000 state.py:225(_pending_mutations)
      440    0.002    0.000    0.005    0.000 locale.py:305(atof)
       75    0.004    0.000    0.005    0.000 socket.py:185(__init__)
       39    0.000    0.000    0.005    0.000 element.py:937(__getattr__)
      298    0.002    0.000    0.005    0.000 arrow.py:76(utcnow)
       33    0.001    0.000    0.005    0.000 __init__.py:165(unsyspath)
    14842    0.005    0.000    0.005    0.000 elements.py:405(self_group)
  376/298    0.002    0.000    0.005    0.000 attributes.py:1129(emit_backref_from_scalar_set_event)
     2618    0.003    0.000    0.005    0.000 session.py:1967(_contains_state)
    11118    0.005    0.000    0.005    0.000 {method 'toordinal' of 'datetime.date' objects}
    24329    0.005    0.000    0.005    0.000 _lxml.py:166(_prefix_for_namespace)
      298    0.002    0.000    0.005    0.000 session.py:1806(_save_impl)
      298    0.001    0.000    0.005    0.000 arrow.py:78(_coerce)
     4923    0.003    0.000    0.004    0.000 _collections.py:688(<genexpr>)
      156    0.001    0.000    0.004    0.000 persistence.py:1047(<lambda>)
      337    0.004    0.000    0.004    0.000 persistence.py:959(_postfetch)
      649    0.001    0.000    0.004    0.000 attributes.py:740(get_history)
    13022    0.004    0.000    0.004    0.000 base.py:32(_clone)
       66    0.000    0.000    0.004    0.000 dammit.py:232(encodings)
     2463    0.004    0.000    0.004    0.000 _collections.py:687(__iter__)
       75    0.001    0.000    0.004    0.000 urllib2.py:1110(do_request_)
      117    0.002    0.000    0.004    0.000 state.py:611(_commit_all_states)
      416    0.004    0.000    0.004    0.000 {method 'search' of '_sre.SRE_Pattern' objects}
      596    0.001    0.000    0.004    0.000 <string>:1(<lambda>)
       75    0.001    0.000    0.004    0.000 urllib2.py:199(__init__)
      298    0.002    0.000    0.004    0.000 instrumentation.py:329(_new_state_if_none)
       33    0.002    0.000    0.004    0.000 tempfile.py:135(next)
      156    0.001    0.000    0.004    0.000 base.py:149(execution_options)
     2574    0.003    0.000    0.004    0.000 unitofwork.py:454(__new__)
      352    0.004    0.000    0.004    0.000 {method 'getvalue' of 'cStringIO.StringO' objects}
       42    0.001    0.000    0.004    0.000 urllib2.py:541(redirect_request)
       25    0.000    0.000    0.004    0.000 __init__.py:336(getinfo)
      532    0.003    0.000    0.004    0.000 attributes.py:1290(as_state)
       99    0.001    0.000    0.004    0.000 genericpath.py:38(isdir)
      234    0.001    0.000    0.003    0.000 dependency.py:495(process_deletes)
       75    0.001    0.000    0.003    0.000 httplib.py:341(__init__)
      298    0.001    0.000    0.003    0.000 result.py:999(fetchone)
       33    0.001    0.000    0.003    0.000 dammit.py:288(find_declared_encoding)
       42    0.000    0.000    0.003    0.000 urlparse.py:251(urljoin)
     1878    0.003    0.000    0.003    0.000 {cStringIO.StringIO}
      596    0.001    0.000    0.003    0.000 dependency.py:253(_verify_canload)
     3140    0.003    0.000    0.003    0.000 {method 'seek' of 'cStringIO.StringO' objects}
      220    0.000    0.000    0.003    0.000 locale.py:318(atoi)
     1823    0.003    0.000    0.003    0.000 selectable.py:857(<lambda>)
       33    0.001    0.000    0.003    0.000 shutil.py:93(copystat)
      117    0.001    0.000    0.003    0.000 aggregates.py:535(construct_aggregate_queries)
      596    0.001    0.000    0.003    0.000 state.py:165(session)
     1824    0.003    0.000    0.003    0.000 {method 'find' of 'str' objects}
      663    0.003    0.000    0.003    0.000 _collections.py:315(values)
       39    0.000    0.000    0.003    0.000 __init__.py:235(exists)
      880    0.000    0.000    0.003    0.000 locale.py:110(localeconv)
     5357    0.003    0.000    0.003    0.000 element.py:258(_last_descendant)
       75    0.002    0.000    0.003    0.000 mimetools.py:33(parsetype)
      415    0.001    0.000    0.003    0.000 instrumentation.py:354(has_parent)
      454    0.002    0.000    0.003    0.000 attributes.py:1330(from_object_attribute)
      351    0.002    0.000    0.003    0.000 persistence.py:918(_finalize_insert_update_commands)
      298    0.002    0.000    0.003    0.000 {method 'astimezone' of 'datetime.datetime' objects}
       33    0.002    0.000    0.003    0.000 www.py:257(get_actual_url)
      493    0.002    0.000    0.003    0.000 _collections.py:144(__new__)
        6    0.000    0.000    0.003    0.000 codecs.py:293(decode)
       42    0.001    0.000    0.003    0.000 rfc822.py:295(getheaders)
      150    0.001    0.000    0.003    0.000 socket.py:285(__del__)
      880    0.003    0.000    0.003    0.000 {_locale.localeconv}
      585    0.001    0.000    0.002    0.000 dependency.py:59(per_property_preprocessors)
     3007    0.002    0.000    0.002    0.000 {method 'difference' of 'set' objects}
      150    0.002    0.000    0.002    0.000 socket.py:246(__init__)
      301    0.001    0.000    0.002    0.000 attr.py:250(__call__)
       39    0.001    0.000    0.002    0.000 inspect.py:804(getargspec)
       75    0.001    0.000    0.002    0.000 socket.py:212(makefile)
      166    0.002    0.000    0.002    0.000 {method 'read' of 'file' objects}
      390    0.001    0.000    0.002    0.000 persistence.py:416(_collect_update_commands)
     1303    0.002    0.000    0.002    0.000 {method 'read' of 'cStringIO.StringO' objects}
      117    0.001    0.000    0.002    0.000 session.py:234(_begin)
      150    0.001    0.000    0.002    0.000 urllib2.py:261(get_host)
      169    0.001    0.000    0.002    0.000 path.py:20(normpath)
       39    0.001    0.000    0.002    0.000 __init__.py:216(reset)
      117    0.000    0.000    0.002    0.000 attributes.py:893(get_history)
      351    0.001    0.000    0.002    0.000 persistence.py:835(_emit_delete_statements)
       75    0.001    0.000    0.002    0.000 httplib.py:783(close)
       75    0.001    0.000    0.002    0.000 urllib.py:1006(__init__)
      298    0.001    0.000    0.002    0.000 arrow.py:335(naive)
      298    0.001    0.000    0.002    0.000 attributes.py:496(sethasparent)
      338    0.002    0.000    0.002    0.000 _collections.py:879(get)
      596    0.002    0.000    0.002    0.000 mapper.py:2284(_canload)
      136    0.001    0.000    0.002    0.000 base.py:288(validatepath)
     1053    0.001    0.000    0.002    0.000 mapper.py:2652(_memo)
       42    0.001    0.000    0.002    0.000 rfc822.py:228(getallmatchingheaders)
     4923    0.002    0.000    0.002    0.000 _collections.py:689(<genexpr>)
      585    0.001    0.000    0.002    0.000 unitofwork.py:223(register_preprocessor)
       39    0.001    0.000    0.002    0.000 _lxml.py:45(parser_for)
      234    0.001    0.000    0.002    0.000 dependency.py:708(presort_saves)
     1543    0.002    0.000    0.002    0.000 identity.py:106(contains_state)
      702    0.001    0.000    0.002    0.000 persistence.py:1044(_cached_connection_dict)
      450    0.001    0.000    0.002    0.000 rfc822.py:285(getheader)
      300    0.001    0.000    0.002    0.000 httplib.py:951(putheader)
     1284    0.002    0.000    0.002    0.000 {method 'readline' of 'cStringIO.StringO' objects}
      242    0.001    0.000    0.002    0.000 _collections.py:183(__iter__)
      117    0.001    0.000    0.002    0.000 urlparse.py:160(_splitnetloc)
      117    0.001    0.000    0.002    0.000 attributes.py:900(get_all_pending)
       78    0.001    0.000    0.002    0.000 attributes.py:1356(from_collection)
      117    0.001    0.000    0.002    0.000 session.py:1959(__iter__)
      150    0.000    0.000    0.002    0.000 urllib2.py:254(get_type)
       75    0.001    0.000    0.002    0.000 httplib.py:841(putrequest)
       75    0.001    0.000    0.002    0.000 socket.py:192(close)
       33    0.000    0.000    0.002    0.000 urllib2.py:181(request_host)
      117    0.001    0.000    0.002    0.000 session.py:1542(_register_altered)
      298    0.001    0.000    0.002    0.000 session.py:1914(_before_attach)
      702    0.001    0.000    0.002    0.000 unitofwork.py:475(__init__)
       34    0.002    0.000    0.002    0.000 {method 'close' of 'file' objects}
       33    0.001    0.000    0.001    0.000 {posix.open}
       75    0.001    0.000    0.001    0.000 urllib.py:952(__init__)
       75    0.001    0.000    0.001    0.000 mimetools.py:50(parseplist)
     1170    0.001    0.000    0.001    0.000 element.py:890(get)
      415    0.001    0.000    0.001    0.000 attributes.py:474(hasparent)
      198    0.001    0.000    0.001    0.000 random.py:271(choice)
      156    0.000    0.000    0.001    0.000 attributes.py:675(get_history)
      298    0.001    0.000    0.001    0.000 {built-in method utcnow}
      169    0.001    0.000    0.001    0.000 __init__.py:151(_decode_path)
        1    0.000    0.000    0.001    0.001 fsutils.py:353(close)
      298    0.001    0.000    0.001    0.000 schema.py:2565(__iter__)
     1284    0.001    0.000    0.001    0.000 rfc822.py:209(islast)
       39    0.000    0.000    0.001    0.000 digikey.py:391(_get_datasheet)
       39    0.001    0.000    0.001    0.000 inspect.py:744(getargs)
      298    0.001    0.000    0.001    0.000 session.py:1935(_attach)
     2351    0.001    0.000    0.001    0.000 attributes.py:1251(__bool__)
       75    0.001    0.000    0.001    0.000 urllib.py:1067(splittype)
       33    0.001    0.000    0.001    0.000 {posix.unlink}
       39    0.000    0.000    0.001    0.000 digikey.py:406(_get_vqtyavail)
       39    0.001    0.000    0.001    0.000 __init__.py:38(lookup)
      415    0.001    0.000    0.001    0.000 identity.py:109(replace)
      351    0.001    0.000    0.001    0.000 _collections.py:312(keys)
       35    0.001    0.000    0.001    0.000 {posix.rename}
      585    0.001    0.000    0.001    0.000 unitofwork.py:282(<lambda>)
        1    0.000    0.000    0.001    0.001 fsutils.py:372(_replace_current_file)
        1    0.000    0.000    0.001    0.001 fsutils.py:379(_backup_current_file)
       33    0.000    0.000    0.001    0.000 shutil.py:54(_samefile)
      649    0.001    0.000    0.001    0.000 attributes.py:752(get_all_pending)
       33    0.001    0.000    0.001    0.000 {posix.utime}
       75    0.001    0.000    0.001    0.000 httplib.py:697(__init__)
      298    0.000    0.000    0.001    0.000 result.py:896(_fetchone_impl)
       33    0.001    0.000    0.001    0.000 {posix.fdopen}
      298    0.001    0.000    0.001    0.000 mapper.py:2828(_event_on_init)
       33    0.000    0.000    0.001    0.000 tempfile.py:48(_set_cloexec)
       42    0.000    0.000    0.001    0.000 urllib.py:970(close)
      596    0.001    0.000    0.001    0.000 attr.py:261(__iter__)
        3    0.000    0.000    0.001    0.000 compiler.py:1812(visit_insert)
      298    0.001    0.000    0.001    0.000 {method 'replace' of 'datetime.datetime' objects}
       75    0.001    0.000    0.001    0.000 httplib.py:494(_check_close)
       75    0.000    0.000    0.001    0.000 urllib.py:1081(splithost)
      298    0.001    0.000    0.001    0.000 parser.py:281(parse)
       39    0.000    0.000    0.001    0.000 element.py:725(for_name_and_ids)
       75    0.000    0.000    0.001    0.000 urllib.py:1172(splittag)
      156    0.001    0.000    0.001    0.000 base.py:135(_clone)
      532    0.000    0.000    0.001    0.000 session.py:1533(<genexpr>)
        2    0.000    0.000    0.001    0.000 fsutils.py:406(_revisions)
       30    0.000    0.000    0.001    0.000 type_api.py:395(_dialect_info)
        2    0.000    0.000    0.001    0.000 glob.py:18(glob)
      156    0.001    0.000    0.001    0.000 attributes.py:1303(from_scalar_attribute)
     1284    0.001    0.000    0.001    0.000 rfc822.py:219(iscomment)
        9    0.000    0.000    0.001    0.000 glob.py:29(iglob)
      234    0.001    0.000    0.001    0.000 dependency.py:324(per_property_dependencies)
      136    0.001    0.000    0.001    0.000 __init__.py:187(getmeta)
     3279    0.001    0.000    0.001    0.000 {method 'isdisjoint' of 'set' objects}
       25    0.000    0.000    0.001    0.000 __init__.py:328(_stat)
      117    0.001    0.000    0.001    0.000 unitofwork.py:109(__init__)
      117    0.001    0.000    0.001    0.000 identity.py:163(values)
        4    0.000    0.000    0.001    0.000 crud.py:29(_get_crud_params)
        2    0.000    0.000    0.001    0.000 glob.py:66(glob1)
    55/29    0.000    0.000    0.001    0.000 langhelpers.py:813(__getattr__)
       35    0.000    0.000    0.001    0.000 compiler.py:2674(_requires_quotes)
        1    0.000    0.000    0.001    0.001 fsutils.py:399(_current_revision)
       33    0.000    0.000    0.001    0.000 posixpath.py:160(samefile)
      585    0.001    0.000    0.001    0.000 unitofwork.py:411(__init__)
     1757    0.001    0.000    0.001    0.000 {method 'tell' of 'cStringIO.StringO' objects}
        1    0.000    0.000    0.001    0.001 query.py:971(from_self)
      350    0.000    0.000    0.001    0.000 __init__.py:339(<genexpr>)
      355    0.001    0.000    0.001    0.000 _collections.py:318(items)
       25    0.001    0.000    0.001    0.000 {dir}
       75    0.000    0.000    0.001    0.000 urllib.py:1210(unquote)
      596    0.001    0.000    0.001    0.000 schema.py:2570(<genexpr>)
        6    0.000    0.000    0.001    0.000 __init__.py:218(open)
       66    0.001    0.000    0.001    0.000 {fcntl.fcntl}
     1404    0.001    0.000    0.001    0.000 mapper.py:2340(primary_base_mapper)
        4    0.000    0.000    0.001    0.000 crud.py:203(_scan_cols)
       39    0.000    0.000    0.001    0.000 digikey.py:373(_get_manufacturer)
        2    0.000    0.000    0.001    0.000 fnmatch.py:45(filter)
       33    0.001    0.000    0.001    0.000 {posix.chmod}
       39    0.000    0.000    0.001    0.000 vendors.py:423(prices)
      959    0.001    0.000    0.001    0.000 {method 'replace' of 'unicode' objects}
       84    0.000    0.000    0.001    0.000 urlparse.py:223(urlunparse)
      195    0.001    0.000    0.001    0.000 collections.py:687(__iter__)
      298    0.001    0.000    0.001    0.000 {method 'fetchone' of 'psycopg2.extensions.cursor' objects}
       75    0.001    0.000    0.001    0.000 {built-in method fromtimestamp}
      936    0.001    0.000    0.001    0.000 unitofwork.py:524(__init__)
       39    0.000    0.000    0.001    0.000 digikey.py:237(vpart_url)
      298    0.001    0.000    0.001    0.000 persistence.py:731(<lambda>)
      585    0.001    0.000    0.001    0.000 unitofwork.py:164(memo)
       21    0.000    0.000    0.001    0.000 elements.py:3322(_label)
       75    0.000    0.000    0.001    0.000 httplib.py:727(_set_hostport)
       21    0.000    0.000    0.001    0.000 elements.py:3330(_gen_label)
      351    0.001    0.000    0.001    0.000 dependency.py:797(per_property_preprocessors)
      375    0.000    0.000    0.001    0.000 httplib.py:813(_output)
      429    0.001    0.000    0.001    0.000 weakref.py:320(__setitem__)
     2105    0.001    0.000    0.001    0.000 {method 'strip' of 'unicode' objects}
       14    0.000    0.000    0.001    0.000 type_api.py:414(adapt)
       39    0.000    0.000    0.001    0.000 digikey.py:366(_get_mpartno)
      298    0.000    0.000    0.001    0.000 identity.py:39(_manage_incoming_state)
      351    0.001    0.000    0.001    0.000 attributes.py:1255(empty)
      838    0.001    0.000    0.001    0.000 mapper.py:2299(iterate_to_root)
       33    0.000    0.000    0.001    0.000 dammit.py:215(__init__)
       14    0.000    0.000    0.001    0.000 langhelpers.py:1014(constructor_copy)
      596    0.001    0.000    0.001    0.000 {method 'difference' of 'frozenset' objects}
      532    0.000    0.000    0.001    0.000 identity.py:72(__len__)
       39    0.000    0.000    0.001    0.000 state.py:502(unloaded)
        6    0.000    0.000    0.001    0.000 {_io.open}
      305    0.001    0.000    0.001    0.000 {method 'startswith' of 'unicode' objects}
       16    0.000    0.000    0.001    0.000 crud.py:257(_append_param_parameter)
      355    0.000    0.000    0.001    0.000 _collections.py:309(__iter__)
       33    0.000    0.000    0.001    0.000 tempfile.py:124(rng)
      300    0.000    0.000    0.000    0.000 urllib2.py:1168(<genexpr>)
      766    0.000    0.000    0.000    0.000 relationships.py:1731(_get_cascade)
      338    0.000    0.000    0.000    0.000 _collections.py:875(_inc_counter)
        1    0.000    0.000    0.000    0.000 sre_compile.py:493(compile)
      596    0.000    0.000    0.000    0.000 unitofwork.py:158(is_deleted)
     1248    0.000    0.000    0.000    0.000 state.py:244(_detach)
      936    0.000    0.000    0.000    0.000 unitofwork.py:553(__init__)
      105    0.000    0.000    0.000    0.000 {_warnings.warn}
       39    0.000    0.000    0.000    0.000 {method 'close' of 'lxml.etree._FeedParser' objects}
        3    0.000    0.000    0.000    0.000 strategies.py:425(_memoized_attr__simple_lazy_clause)
       18    0.000    0.000    0.000    0.000 crud.py:118(_create_bind_param)
      117    0.000    0.000    0.000    0.000 dependency.py:594(per_property_dependencies)
       39    0.000    0.000    0.000    0.000 digikey.py:424(_get_vpartdesc)
        4    0.000    0.000    0.000    0.000 mapper.py:1930(_propkey_to_col)
      183    0.000    0.000    0.000    0.000 {method 'replace' of 'str' objects}
      596    0.000    0.000    0.000    0.000 mapper.py:2334(primary_mapper)
      415    0.000    0.000    0.000    0.000 state.py:234(has_identity)
       84    0.000    0.000    0.000    0.000 urlparse.py:233(urlunsplit)
        8    0.000    0.000    0.000    0.000 mapper.py:1933(<genexpr>)
       39    0.000    0.000    0.000    0.000 digikey.py:380(_get_package)
      421    0.000    0.000    0.000    0.000 {method 'clear' of 'dict' objects}
      298    0.000    0.000    0.000    0.000 {method 'issubset' of 'frozenset' objects}
       39    0.000    0.000    0.000    0.000 urllib.py:1290(quote_plus)
      819    0.000    0.000    0.000    0.000 persistence.py:1054(<genexpr>)
      117    0.000    0.000    0.000    0.000 unitofwork.py:271(_mapper_for_dep)
      150    0.000    0.000    0.000    0.000 urllib2.py:293(add_unredirected_header)
        3    0.000    0.000    0.000    0.000 persistence.py:606(update_stmt)
     2106    0.000    0.000    0.000    0.000 {method 'remove' of 'set' objects}
       39    0.000    0.000    0.000    0.000 attributes.py:890(__copy)
        1    0.000    0.000    0.000    0.000 <string>:1(_from_selectable)
      117    0.000    0.000    0.000    0.000 session.py:1818(_update_impl)
        1    0.000    0.000    0.000    0.000 query.py:992(_from_selectable)
      5/2    0.000    0.000    0.000    0.000 selectable.py:537(columns)
      136    0.000    0.000    0.000    0.000 path.py:140(relpath)
    54/14    0.000    0.000    0.000    0.000 langhelpers.py:216(get_cls_kwargs)
      117    0.000    0.000    0.000    0.000 six.py:552(iteritems)
       39    0.000    0.000    0.000    0.000 type_api.py:1057(compare_values)
      117    0.000    0.000    0.000    0.000 urllib2.py:231(get_method)
        3    0.000    0.000    0.000    0.000 mapper.py:2605(_sorted_tables)
       39    0.000    0.000    0.000    0.000 _lxml.py:54(__init__)
      298    0.000    0.000    0.000    0.000 identity.py:94(__contains__)
      150    0.000    0.000    0.000    0.000 socket.py:292(flush)
      132    0.000    0.000    0.000    0.000 dammit.py:224(_usable)
      220    0.000    0.000    0.000    0.000 vendors.py:425(<lambda>)
        3    0.000    0.000    0.000    0.000 persistence.py:843(delete_stmt)
       75    0.000    0.000    0.000    0.000 urllib.py:1058(unwrap)
        1    0.000    0.000    0.000    0.000 compiler.py:1935(visit_update)
       39    0.000    0.000    0.000    0.000 urllib.py:1251(quote)
      649    0.000    0.000    0.000    0.000 persistence.py:180(<genexpr>)
       26    0.000    0.000    0.000    0.000 langhelpers.py:823(oneshot)
        1    0.000    0.000    0.000    0.000 query.py:3656(adapt_to_selectable)
        1    0.000    0.000    0.000    0.000 query.py:422(statement)
        1    0.000    0.000    0.000    0.000 sre_parse.py:675(parse)
       39    0.000    0.000    0.000    0.000 element.py:49(__new__)
       75    0.000    0.000    0.000    0.000 urllib.py:1043(_is_unicode)
        2    0.000    0.000    0.000    0.000 query.py:3693(setup_context)
      117    0.000    0.000    0.000    0.000 session.py:2506(_dirty_states)
        1    0.000    0.000    0.000    0.000 sre_parse.py:301(_parse_sub)
        3    0.000    0.000    0.000    0.000 query.py:3539(__init__)
        1    0.000    0.000    0.000    0.000 compiler.py:1244(visit_alias)
        1    0.000    0.000    0.000    0.000 sre_parse.py:379(_parse)
        1    0.000    0.000    0.000    0.000 visitors.py:304(replacement_traverse)
        3    0.000    0.000    0.000    0.000 ddl.py:937(sort_tables)
       71    0.000    0.000    0.000    0.000 stat.py:40(S_ISDIR)
       23    0.000    0.000    0.000    0.000 path_registry.py:289(__missing__)
      5/1    0.000    0.000    0.000    0.000 visitors.py:311(clone)
        3    0.000    0.000    0.000    0.000 ddl.py:996(sort_tables_and_constraints)
      136    0.000    0.000    0.000    0.000 base.py:235(getmeta)
       75    0.000    0.000    0.000    0.000 {built-in method fromkeys}
        6    0.000    0.000    0.000    0.000 urlparse.py:68(clear_cache)
       33    0.000    0.000    0.000    0.000 dammit.py:265(strip_byte_order_mark)
      150    0.000    0.000    0.000    0.000 urllib2.py:248(get_full_url)
      337    0.000    0.000    0.000    0.000 base.py:121(_root)
        2    0.000    0.000    0.000    0.000 selectable.py:3179(_populate_column_collection)
       46    0.000    0.000    0.000    0.000 path_registry.py:135(token)
       39    0.000    0.000    0.000    0.000 {_hashlib.openssl_md5}
       23    0.000    0.000    0.000    0.000 path_registry.py:190(__init__)
       39    0.000    0.000    0.000    0.000 type_api.py:276(compare_values)
        3    0.000    0.000    0.000    0.000 schema.py:1346(_make_proxy)
       39    0.000    0.000    0.000    0.000 collections.py:692(__len__)
       25    0.000    0.000    0.000    0.000 __init__.py:35(_os_stat)
       42    0.000    0.000    0.000    0.000 rfc822.py:439(__contains__)
        1    0.000    0.000    0.000    0.000 sre_compile.py:478(_code)
       23    0.000    0.000    0.000    0.000 elements.py:3633(_as_truncated)
        1    0.000    0.000    0.000    0.000 fsutils.py:422(_delete_old_revisions)
        1    0.000    0.000    0.000    0.000 elements.py:3125(_copy_internals)
      155    0.000    0.000    0.000    0.000 {method 'rfind' of 'str' objects}
      351    0.000    0.000    0.000    0.000 persistence.py:568(_collect_delete_commands)
      483    0.000    0.000    0.000    0.000 {method 'isspace' of 'str' objects}
       23    0.000    0.000    0.000    0.000 compiler.py:2663(quote_identifier)
       14    0.000    0.000    0.000    0.000 type_api.py:411(_gen_dialect_impl)
       39    0.000    0.000    0.000    0.000 loading.py:506(_populate_partial)
        6    0.000    0.000    0.000    0.000 locale.py:608(getpreferredencoding)
      192    0.000    0.000    0.000    0.000 urllib2.py:242(has_data)
        5    0.000    0.000    0.000    0.000 query.py:268(replace)
        1    0.000    0.000    0.000    0.000 selectable.py:3432(__init__)
      150    0.000    0.000    0.000    0.000 urllib2.py:297(has_header)
       23    0.000    0.000    0.000    0.000 path_registry.py:219(_wildcard_path_loader_key)
      108    0.000    0.000    0.000    0.000 {method 'index' of 'str' objects}
        4    0.000    0.000    0.000    0.000 mapper.py:2134(relationships)
      337    0.000    0.000    0.000    0.000 state.py:221(parents)
        1    0.000    0.000    0.000    0.000 selectable.py:1123(_populate_column_collection)
      225    0.000    0.000    0.000    0.000 {method 'group' of '_sre.SRE_Match' objects}
        5    0.000    0.000    0.000    0.000 util.py:492(replace)
      468    0.000    0.000    0.000    0.000 persistence.py:184(<genexpr>)
        1    0.000    0.000    0.000    0.000 terminal.py:221(__init__)
       14    0.000    0.000    0.000    0.000 default.py:350(type_descriptor)
      144    0.000    0.000    0.000    0.000 {method 'rstrip' of 'str' objects}
       25    0.000    0.000    0.000    0.000 {time.mktime}
        4    0.000    0.000    0.000    0.000 mapper.py:2171(_filter_properties)
      493    0.000    0.000    0.000    0.000 _collections.py:149(__init__)
       23    0.000    0.000    0.000    0.000 path_registry.py:233(_default_path_loader_key)
        1    0.000    0.000    0.000    0.000 __init__.py:1142(info)
      192    0.000    0.000    0.000    0.000 {method 'iteritems' of 'dict' objects}
        3    0.000    0.000    0.000    0.000 base.py:1507(returning_clause)
       39    0.000    0.000    0.000    0.000 result.py:536(rowcount)
        1    0.000    0.000    0.000    0.000 __init__.py:1252(_log)
      596    0.000    0.000    0.000    0.000 tz.py:50(dst)
        1    0.000    0.000    0.000    0.000 fnmatch.py:81(translate)
       18    0.000    0.000    0.000    0.000 locale.py:564(setlocale)
       25    0.000    0.000    0.000    0.000 {method 'timetuple' of 'datetime.datetime' objects}
      225    0.000    0.000    0.000    0.000 {method 'title' of 'str' objects}
      225    0.000    0.000    0.000    0.000 {method 'capitalize' of 'str' objects}
        1    0.000    0.000    0.000    0.000 _collections.py:932(lightweight_named_tuple)
       52    0.000    0.000    0.000    0.000 stat.py:52(S_ISFIFO)
      117    0.000    0.000    0.000    0.000 unitofwork.py:388(<genexpr>)
       26    0.000    0.000    0.000    0.000 base.py:575(__contains__)
       14    0.000    0.000    0.000    0.000 type_api.py:1147(adapt_type)
       66    0.000    0.000    0.000    0.000 {method 'rstrip' of 'unicode' objects}
      298    0.000    0.000    0.000    0.000 state.py:521(_instance_dict)
      125    0.000    0.000    0.000    0.000 stat.py:24(S_IFMT)
       33    0.000    0.000    0.000    0.000 {method 'sub' of '_sre.SRE_Pattern' objects}
      117    0.000    0.000    0.000    0.000 unitofwork.py:154(has_work)
       36    0.000    0.000    0.000    0.000 {method 'groupdict' of '_sre.SRE_Match' objects}
       18    0.000    0.000    0.000    0.000 {_locale.setlocale}
       21    0.000    0.000    0.000    0.000 urllib2.py:219(__getattr__)
       23    0.000    0.000    0.000    0.000 psycopg2.py:495(_escape_identifier)
        3    0.000    0.000    0.000    0.000 properties.py:244(_memoized_method___clause_element__)
       39    0.000    0.000    0.000    0.000 arrow.py:700(__eq__)
       90    0.000    0.000    0.000    0.000 {method 'lower' of 'unicode' objects}
       10    0.000    0.000    0.000    0.000 _collections.py:270(__init__)
       39    0.000    0.000    0.000    0.000 {method 'hexdigest' of '_hashlib.HASH' objects}
        2    0.000    0.000    0.000    0.000 {posix.listdir}
        3    0.000    0.000    0.000    0.000 selectable.py:1386(update)
      415    0.000    0.000    0.000    0.000 {method 'pop' of 'collections.deque' objects}
      220    0.000    0.000    0.000    0.000 collections.py:696(__bool__)
        1    0.000    0.000    0.000    0.000 sre_compile.py:359(_compile_info)
      2/1    0.000    0.000    0.000    0.000 sre_compile.py:32(_compile)
       39    0.000    0.000    0.000    0.000 _lxml.py:218(default_parser)
       45    0.000    0.000    0.000    0.000 re.py:204(escape)
        2    0.000    0.000    0.000    0.000 crud.py:358(_append_param_insert_hasdefault)
      156    0.000    0.000    0.000    0.000 default.py:401(set_connection_execution_options)
        4    0.000    0.000    0.000    0.000 mapper.py:2659(_table_to_equated)
       58    0.000    0.000    0.000    0.000 sre_parse.py:201(get)
        5    0.000    0.000    0.000    0.000 _collections.py:902(__setitem__)
       39    0.000    0.000    0.000    0.000 collections.py:602(attr)
        1    0.000    0.000    0.000    0.000 functions.py:155(_copy_internals)
      117    0.000    0.000    0.000    0.000 persistence.py:1057(<lambda>)
        3    0.000    0.000    0.000    0.000 schema.py:861(__init__)
        3    0.000    0.000    0.000    0.000 dml.py:576(__init__)
      198    0.000    0.000    0.000    0.000 {method 'random' of '_random.Random' objects}
        3    0.000    0.000    0.000    0.000 mapper.py:1993(_polymorphic_properties)
        6    0.000    0.000    0.000    0.000 dml.py:183(__init__)
        6    0.000    0.000    0.000    0.000 <string>:1(bindparam)
        4    0.000    0.000    0.000    0.000 _collections.py:291(update)
       23    0.000    0.000    0.000    0.000 elements.py:3488(_memoized_method_lower)
        2    0.000    0.000    0.000    0.000 crud.py:311(_create_prefetch_bind_param)
        4    0.000    0.000    0.000    0.000 util.py:476(_corresponding_column)
        1    0.000    0.000    0.000    0.000 attributes.py:148(_query_clause_element)
        1    0.000    0.000    0.000    0.000 functions.py:258(__call__)
        1    0.000    0.000    0.000    0.000 terminal.py:61(get_terminal_width)
        1    0.000    0.000    0.000    0.000 __init__.py:1273(handle)
        1    0.000    0.000    0.000    0.000 interfaces.py:347(_query_clause_element)
        1    0.000    0.000    0.000    0.000 terminal.py:65(get_terminal_size)
        1    0.000    0.000    0.000    0.000 terminal.py:175(__init__)
      220    0.000    0.000    0.000    0.000 currency.py:252(source_value)
        1    0.000    0.000    0.000    0.000 selectable.py:1118(is_derived_from)
       78    0.000    0.000    0.000    0.000 __init__.py:121(deprecated_argument)
        1    0.000    0.000    0.000    0.000 __init__.py:1305(callHandlers)
       75    0.000    0.000    0.000    0.000 urllib.py:1012(info)
      220    0.000    0.000    0.000    0.000 vendors.py:227(oqmultiple)
        1    0.000    0.000    0.000    0.000 functions.py:579(__init__)
        3    0.000    0.000    0.000    0.000 instrumentation.py:175(_state_constructor)
       61    0.000    0.000    0.000    0.000 sre_parse.py:182(__next)
       33    0.000    0.000    0.000    0.000 tempfile.py:262(gettempdir)
        1    0.000    0.000    0.000    0.000 selectable.py:2689(is_derived_from)
        3    0.000    0.000    0.000    0.000 selectable.py:1371(insert)
       39    0.000    0.000    0.000    0.000 element.py:922(__setitem__)
       33    0.000    0.000    0.000    0.000 {method 'lstrip' of 'unicode' objects}
        1    0.000    0.000    0.000    0.000 __init__.py:736(handle)
      117    0.000    0.000    0.000    0.000 dependency.py:727(process_deletes)
        1    0.000    0.000    0.000    0.000 helpers.py:53(__init__)
        1    0.000    0.000    0.000    0.000 functions.py:483(__init__)
       46    0.000    0.000    0.000    0.000 path_registry.py:169(__init__)
       39    0.000    0.000    0.000    0.000 persistence.py:632(<lambda>)
      220    0.000    0.000    0.000    0.000 vendors.py:231(unit_price)
       75    0.000    0.000    0.000    0.000 urllib2.py:280(has_proxy)
       34    0.000    0.000    0.000    0.000 {posix.getpid}
       26    0.000    0.000    0.000    0.000 mapper.py:1998(_iterate_polymorphic_properties)
      103    0.000    0.000    0.000    0.000 {method 'lstrip' of 'str' objects}
       75    0.000    0.000    0.000    0.000 httplib.py:747(set_debuglevel)
        1    0.000    0.000    0.000    0.000 fsutils.py:335(__init__)
        1    0.000    0.000    0.000    0.000 query.py:158(_set_select_from)
       33    0.000    0.000    0.000    0.000 tempfile.py:216(_get_candidate_names)
      117    0.000    0.000    0.000    0.000 identity.py:50(_dirty_states)
       17    0.000    0.000    0.000    0.000 compiler.py:2758(format_column)
        3    0.000    0.000    0.000    0.000 dml.py:431(__init__)
        3    0.000    0.000    0.000    0.000 mapper.py:1917(_insert_cols_as_none)
       42    0.000    0.000    0.000    0.000 urllib2.py:561(<genexpr>)
        3    0.000    0.000    0.000    0.000 selectable.py:1403(delete)
       16    0.000    0.000    0.000    0.000 elements.py:3803(_is_literal)
       33    0.000    0.000    0.000    0.000 {method 'groups' of '_sre.SRE_Match' objects}
       75    0.000    0.000    0.000    0.000 urllib2.py:1157(<genexpr>)
        1    0.000    0.000    0.000    0.000 elements.py:2822(_copy_internals)
        1    0.000    0.000    0.000    0.000 __init__.py:1239(makeRecord)
       77    0.000    0.000    0.000    0.000 {method 'extend' of 'list' objects}
       78    0.000    0.000    0.000    0.000 __init__.py:98(reset)
        1    0.000    0.000    0.000    0.000 __init__.py:839(emit)
       19    0.000    0.000    0.000    0.000 posixpath.py:180(samestat)
        1    0.000    0.000    0.000    0.000 terminal.py:118(_get_terminal_size_linux)
        1    0.000    0.000    0.000    0.000 helpers.py:71(finish)
        5    0.000    0.000    0.000    0.000 _collections.py:911(_manage_size)
        1    0.000    0.000    0.000    0.000 __init__.py:242(__init__)
        3    0.000    0.000    0.000    0.000 mapper.py:2305(self_and_descendants)
        3    0.000    0.000    0.000    0.000 dml.py:722(_extra_froms)
       39    0.000    0.000    0.000    0.000 _lxml.py:123(close)
        1    0.000    0.000    0.000    0.000 compiler.py:793(visit_function)
        1    0.000    0.000    0.000    0.000 langhelpers.py:767(oneshot)
        4    0.000    0.000    0.000    0.000 elements.py:727(__getattr__)
       33    0.000    0.000    0.000    0.000 stat.py:21(S_IMODE)
      6/4    0.000    0.000    0.000    0.000 elements.py:767(proxy_set)
        1    0.000    0.000    0.000    0.000 selectable.py:2655(locate_all_froms)
       75    0.000    0.000    0.000    0.000 urllib2.py:268(get_selector)
        3    0.000    0.000    0.000    0.000 dml.py:748(__init__)
       39    0.000    0.000    0.000    0.000 vendors.py:524(datasheet)
        3    0.000    0.000    0.000    0.000 selectable.py:577(_init_collections)
        1    0.000    0.000    0.000    0.000 {posix.remove}
        1    0.000    0.000    0.000    0.000 terminal.py:119(ioctl_GWINSZ)
        3    0.000    0.000    0.000    0.000 mapper.py:1815(iterate_properties)
        3    0.000    0.000    0.000    0.000 mapper.py:887(_path_registry)
        1    0.000    0.000    0.000    0.000 sre_compile.py:178(_compile_charset)
       14    0.000    0.000    0.000    0.000 type_api.py:226(_has_column_expression)
        2    0.000    0.000    0.000    0.000 genericpath.py:26(isfile)
        2    0.000    0.000    0.000    0.000 elements.py:3136(_from_objects)
       26    0.000    0.000    0.000    0.000 _collections.py:213(__contains__)
        5    0.000    0.000    0.000    0.000 {map}
        6    0.000    0.000    0.000    0.000 mapper.py:1920(<genexpr>)
       20    0.000    0.000    0.000    0.000 elements.py:3326(_render_label_in_columns_clause)
        6    0.000    0.000    0.000    0.000 langhelpers.py:257(inspect_func_args)
        4    0.000    0.000    0.000    0.000 mapper.py:2601(_compiled_cache)
        1    0.000    0.000    0.000    0.000 elements.py:1815(_copy_internals)
       39    0.000    0.000    0.000    0.000 vendors.py:520(datasheet)
       22    0.000    0.000    0.000    0.000 elements.py:3300(_from_objects)
       13    0.000    0.000    0.000    0.000 _collections.py:331(__setitem__)
        1    0.000    0.000    0.000    0.000 compiler.py:816(function_argspec)
       11    0.000    0.000    0.000    0.000 mapper.py:2175(<genexpr>)
        1    0.000    0.000    0.000    0.000 sre_compile.py:207(_optimize_charset)
       21    0.000    0.000    0.000    0.000 crud.py:69(<genexpr>)
        3    0.000    0.000    0.000    0.000 ddl.py:979(_skip_fn)
       42    0.000    0.000    0.000    0.000 urllib2.py:283(get_origin_req_host)
       39    0.000    0.000    0.000    0.000 vendors.py:363(vqtyavail)
       44    0.000    0.000    0.000    0.000 langhelpers.py:1022(<genexpr>)
       30    0.000    0.000    0.000    0.000 mapper.py:1936(<genexpr>)
       30    0.000    0.000    0.000    0.000 weakref.py:352(__contains__)
       39    0.000    0.000    0.000    0.000 vendors.py:516(package)
        1    0.000    0.000    0.000    0.000 __init__.py:83(__init__)
      3/2    0.000    0.000    0.000    0.000 sre_parse.py:140(getwidth)
        3    0.000    0.000    0.000    0.000 attributes.py:199(property)
        4    0.000    0.000    0.000    0.000 elements.py:3189(__init__)
       16    0.000    0.000    0.000    0.000 type_api.py:264(_has_bind_expression)
        2    0.000    0.000    0.000    0.000 {filter}
       39    0.000    0.000    0.000    0.000 default.py:797(rowcount)
        3    0.000    0.000    0.000    0.000 mapper.py:1508(_prop_set)
       20    0.000    0.000    0.000    0.000 elements.py:3315(_key_label)
        1    0.000    0.000    0.000    0.000 compiler.py:523(visit_grouping)
        3    0.000    0.000    0.000    0.000 path_registry.py:125(per_mapper)
        7    0.000    0.000    0.000    0.000 crud.py:131(_key_getters_for_crud_column)
        6    0.000    0.000    0.000    0.000 codecs.py:284(__init__)
        2    0.000    0.000    0.000    0.000 visitors.py:210(iterate)
        1    0.000    0.000    0.000    0.000 elements.py:3825(_literal_as_binds)
        3    0.000    0.000    0.000    0.000 base.py:500(add)
        6    0.000    0.000    0.000    0.000 dml.py:32(_process_colparams)
        6    0.000    0.000    0.000    0.000 schema.py:519(foreign_key_constraints)
        2    0.000    0.000    0.000    0.000 langhelpers.py:952(__getattr__)
        7    0.000    0.000    0.000    0.000 elements.py:3295(_set_table)
       14    0.000    0.000    0.000    0.000 attributes.py:74(_supports_population)
       48    0.000    0.000    0.000    0.000 sre_parse.py:138(append)
        3    0.000    0.000    0.000    0.000 mapper.py:1943(_pk_keys_by_table)
        3    0.000    0.000    0.000    0.000 base.py:454(__init__)
       39    0.000    0.000    0.000    0.000 vendors.py:374(manufacturer)
        1    0.000    0.000    0.000    0.000 __init__.py:31(__init__)
       39    0.000    0.000    0.000    0.000 vendors.py:401(pkgqty)
        3    0.000    0.000    0.000    0.000 mapper.py:2622(skip)
        2    0.000    0.000    0.000    0.000 functions.py:148(_from_objects)
        5    0.000    0.000    0.000    0.000 base.py:594(as_immutable)
       39    0.000    0.000    0.000    0.000 {method 'reverse' of 'list' objects}
        3    0.000    0.000    0.000    0.000 base.py:518(__setitem__)
        9    0.000    0.000    0.000    0.000 sre_parse.py:257(_escape)
       39    0.000    0.000    0.000    0.000 vendors.py:393(vpartdesc)
        4    0.000    0.000    0.000    0.000 _collections.py:869(__init__)
        3    0.000    0.000    0.000    0.000 compiler.py:2742(format_table)
        1    0.000    0.000    0.000    0.000 {_csv.writer}
        1    0.000    0.000    0.000    0.000 selectable.py:392(alias)
        2    0.000    0.000    0.000    0.000 compiler.py:1979(<genexpr>)
        1    0.000    0.000    0.000    0.000 elements.py:857(label)
       17    0.000    0.000    0.000    0.000 elements.py:3723(_column_as_key)
       18    0.000    0.000    0.000    0.000 mapper.py:1923(<genexpr>)
        9    0.000    0.000    0.000    0.000 langhelpers.py:785(expire_instance)
        2    0.000    0.000    0.000    0.000 elements.py:3610(__add__)
        1    0.000    0.000    0.000    0.000 <string>:1(correlate)
       12    0.000    0.000    0.000    0.000 _collections.py:177(__init__)
        1    0.000    0.000    0.000    0.000 elements.py:3049(__init__)
        3    0.000    0.000    0.000    0.000 mapper.py:2814(_event_on_first_init)
        6    0.000    0.000    0.000    0.000 glob.py:94(has_magic)
        1    0.000    0.000    0.000    0.000 util.py:34(find_join_source)
        1    0.000    0.000    0.000    0.000 selectable.py:1088(__init__)
        4    0.000    0.000    0.000    0.000 crud.py:527(_get_returning_modifiers)
       39    0.000    0.000    0.000    0.000 vendors.py:385(mpartno)
        1    0.000    0.000    0.000    0.000 elements.py:2230(literal_column)
        5    0.000    0.000    0.000    0.000 base.py:600(__init__)
        6    0.000    0.000    0.000    0.000 mapper.py:1946(<genexpr>)
        6    0.000    0.000    0.000    0.000 _collections.py:368(add)
        1    0.000    0.000    0.000    0.000 util.py:537(__init__)
        1    0.000    0.000    0.000    0.000 type_api.py:339(_type_affinity)
        2    0.000    0.000    0.000    0.000 posixpath.py:89(split)
        3    0.000    0.000    0.000    0.000 _collections.py:252(__init__)
        1    0.000    0.000    0.000    0.000 {fcntl.ioctl}
        6    0.000    0.000    0.000    0.000 sqltypes.py:92(__init__)
       12    0.000    0.000    0.000    0.000 __init__.py:220(<genexpr>)
        3    0.000    0.000    0.000    0.000 strategies.py:433(visit_bindparam)
        1    0.000    0.000    0.000    0.000 __init__.py:713(format)
       74    0.000    0.000    0.000    0.000 glob.py:77(<lambda>)
        1    0.000    0.000    0.000    0.000 query.py:3681(row_processor)
        1    0.000    0.000    0.000    0.000 compiler.py:1909(update_tables_clause)
        1    0.000    0.000    0.000    0.000 __init__.py:828(flush)
        3    0.000    0.000    0.000    0.000 {method 'extend' of 'collections.deque' objects}
        1    0.000    0.000    0.000    0.000 __init__.py:451(format)
        2    0.000    0.000    0.000    0.000 __init__.py:693(acquire)
        1    0.000    0.000    0.000    0.000 selectable.py:1658(_generate)
        3    0.000    0.000    0.000    0.000 compiler.py:2017(_key_getters_for_crud_column)
        1    0.000    0.000    0.000    0.000 type_api.py:934(bind_processor)
        1    0.000    0.000    0.000    0.000 __init__.py:1218(findCaller)
        2    0.000    0.000    0.000    0.000 attributes.py:652(_init_append_token)
        7    0.000    0.000    0.000    0.000 string.py:281(split)
        6    0.000    0.000    0.000    0.000 sre_parse.py:130(__getitem__)
        1    0.000    0.000    0.000    0.000 elements.py:1782(__init__)
        2    0.000    0.000    0.000    0.000 langhelpers.py:936(module)
       23    0.000    0.000    0.000    0.000 path_registry.py:162(__getitem__)
        1    0.000    0.000    0.000    0.000 query.py:3669(corresponds_to)
        6    0.000    0.000    0.000    0.000 dml.py:33(process_single)
        3    0.000    0.000    0.000    0.000 relationships.py:1323(property)
        3    0.000    0.000    0.000    0.000 path_registry.py:211(has_entity)
        2    0.000    0.000    0.000    0.000 selectable.py:532(_reset_exported)
        1    0.000    0.000    0.000    0.000 functions.py:244(__getattr__)
        1    0.000    0.000    0.000    0.000 <string>:1(with_labels)
        3    0.000    0.000    0.000    0.000 _collections.py:457(difference_update)
       12    0.000    0.000    0.000    0.000 schema.py:530(<genexpr>)
        1    0.000    0.000    0.000    0.000 platform.py:1326(system)
        6    0.000    0.000    0.000    0.000 codecs.py:235(__init__)
        2    0.000    0.000    0.000    0.000 __init__.py:700(release)
       47    0.000    0.000    0.000    0.000 {ord}
       23    0.000    0.000    0.000    0.000 path_registry.py:242(_loader_key)
        3    0.000    0.000    0.000    0.000 crud.py:287(_append_param_insert_pk_returning)
        1    0.000    0.000    0.000    0.000 weakref.py:284(remove)
        6    0.000    0.000    0.000    0.000 sqltypes.py:207(result_processor)
        1    0.000    0.000    0.000    0.000 schema.py:1968(is_scalar)
        1    0.000    0.000    0.000    0.000 <string>:1(enable_eagerloads)
        1    0.000    0.000    0.000    0.000 posixpath.py:104(splitext)
        1    0.000    0.000    0.000    0.000 query.py:3662(setup_entity)
        2    0.000    0.000    0.000    0.000 annotation.py:75(_constructor)
        3    0.000    0.000    0.000    0.000 _collections.py:673(__init__)
        3    0.000    0.000    0.000    0.000 schema.py:2798(referred_table)
        3    0.000    0.000    0.000    0.000 attributes.py:358(__init__)
        2    0.000    0.000    0.000    0.000 base.py:353(_is_aliased_class)
        1    0.000    0.000    0.000    0.000 util.py:464(__init__)
        9    0.000    0.000    0.000    0.000 base.py:271(_validate_dialect_kwargs)
        1    0.000    0.000    0.000    0.000 sre_compile.py:354(_simple)
        4    0.000    0.000    0.000    0.000 {thread.allocate_lock}
        3    0.000    0.000    0.000    0.000 relationships.py:1863(_use_get)
        9    0.000    0.000    0.000    0.000 sre_parse.py:195(match)
        7    0.000    0.000    0.000    0.000 sqltypes.py:175(bind_processor)
        1    0.000    0.000    0.000    0.000 attributes.py:145(__clause_element__)
        6    0.000    0.000    0.000    0.000 {_locale.nl_langinfo}
        1    0.000    0.000    0.000    0.000 attributes.py:882(_init_append_token)
        3    0.000    0.000    0.000    0.000 mapper.py:1898(_with_polymorphic_selectable)
        2    0.000    0.000    0.000    0.000 elements.py:3101(element)
        1    0.000    0.000    0.000    0.000 __init__.py:445(usesTime)
      6/4    0.000    0.000    0.000    0.000 selectable.py:745(is_derived_from)
        1    0.000    0.000    0.000    0.000 query.py:340(__all_equivs)
        1    0.000    0.000    0.000    0.000 _collections.py:115(__new__)
        1    0.000    0.000    0.000    0.000 sre_parse.py:178(__init__)
        3    0.000    0.000    0.000    0.000 path_registry.py:215(entity)
        5    0.000    0.000    0.000    0.000 crud.py:406(_append_param_update)
        1    0.000    0.000    0.000    0.000 platform.py:1189(uname)
        2    0.000    0.000    0.000    0.000 stat.py:49(S_ISREG)
        1    0.000    0.000    0.000    0.000 {_sre.compile}
        1    0.000    0.000    0.000    0.000 elements.py:2807(__init__)
        1    0.000    0.000    0.000    0.000 compiler.py:660(escape_literal_column)
        9    0.000    0.000    0.000    0.000 type_api.py:174(bind_processor)
        1    0.000    0.000    0.000    0.000 __init__.py:153(getLevelName)
        1    0.000    0.000    0.000    0.000 __init__.py:81(<lambda>)
        1    0.000    0.000    0.000    0.000 {_struct.unpack}
        1    0.000    0.000    0.000    0.000 fsutils.py:366(__getattr__)
        1    0.000    0.000    0.000    0.000 vendors.py:589(map)
        2    0.000    0.000    0.000    0.000 fsutils.py:393(_versioned_name)
        1    0.000    0.000    0.000    0.000 threading.py:967(name)
        1    0.000    0.000    0.000    0.000 compiler.py:2725(format_alias)
        2    0.000    0.000    0.000    0.000 {method 'sort' of 'list' objects}
        1    0.000    0.000    0.000    0.000 type_api.py:866(_has_bind_processor)
        1    0.000    0.000    0.000    0.000 threading.py:1152(currentThread)
        1    0.000    0.000    0.000    0.000 elements.py:3095(type)
        2    0.000    0.000    0.000    0.000 vendors.py:557(name)
        1    0.000    0.000    0.000    0.000 posixpath.py:119(basename)
        3    0.000    0.000    0.000    0.000 schema.py:67(_init_items)
        1    0.000    0.000    0.000    0.000 schema.py:1391(get_children)
        4    0.000    0.000    0.000    0.000 sre_parse.py:126(__len__)
        2    0.000    0.000    0.000    0.000 __init__.py:598(filter)
        1    0.000    0.000    0.000    0.000 schema.py:1960(is_callable)
        2    0.000    0.000    0.000    0.000 sre_compile.py:472(isstring)
        3    0.000    0.000    0.000    0.000 langhelpers.py:1225(set_creation_order)
        2    0.000    0.000    0.000    0.000 {issubclass}
        1    0.000    0.000    0.000    0.000 schema.py:1964(is_clause_element)
        1    0.000    0.000    0.000    0.000 __init__.py:311(getMessage)
        1    0.000    0.000    0.000    0.000 genericpath.py:85(_splitext)
        3    0.000    0.000    0.000    0.000 elements.py:257(_constructor)
        1    0.000    0.000    0.000    0.000 elements.py:2832(__getattr__)
        3    0.000    0.000    0.000    0.000 mapper.py:1879(_single_table_criterion)
        1    0.000    0.000    0.000    0.000 functions.py:152(get_children)
        1    0.000    0.000    0.000    0.000 {method 'disable' of '_lsprof.Profiler' objects}
        3    0.000    0.000    0.000    0.000 ddl.py:1063(<genexpr>)
        8    0.000    0.000    0.000    0.000 type_api.py:188(result_processor)
        1    0.000    0.000    0.000    0.000 query.py:294(_mapper_entities)
        1    0.000    0.000    0.000    0.000 elements.py:1818(get_children)
        2    0.000    0.000    0.000    0.000 functions.py:89(clauses)
        1    0.000    0.000    0.000    0.000 functions.py:240(__init__)
        4    0.000    0.000    0.000    0.000 sre_compile.py:24(_identityfunction)
        1    0.000    0.000    0.000    0.000 selectable.py:2960(correlate)
        1    0.000    0.000    0.000    0.000 query.py:3647(entity_zero_or_selectable)
        1    0.000    0.000    0.000    0.000 sre_parse.py:134(__setitem__)
        2    0.000    0.000    0.000    0.000 sre_parse.py:90(__init__)
        1    0.000    0.000    0.000    0.000 sre_parse.py:67(__init__)
        1    0.000    0.000    0.000    0.000 query.py:598(with_labels)
       19    0.000    0.000    0.000    0.000 selectable.py:406(is_derived_from)
        2    0.000    0.000    0.000    0.000 elements.py:391(get_children)
        2    0.000    0.000    0.000    0.000 elements.py:3122(get_children)
        1    0.000    0.000    0.000    0.000 compiler.py:1269(get_render_as_alias_suffix)
        1    0.000    0.000    0.000    0.000 compiler.py:1905(update_limit_clause)
        1    0.000    0.000    0.000    0.000 elements.py:2825(get_children)
        1    0.000    0.000    0.000    0.000 selectable.py:1156(_from_objects)
        1    0.000    0.000    0.000    0.000 query.py:572(enable_eagerloads)