Digi-Key Vendor Map Audit Generation ProfilingΒΆ
Raw execution profile
SVG of execution profile
Execution Profile
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)