{"action":"created","issue":{"url":"https://api.github.com/repos/kbower/tickettest2/issues/425","repository_url":"https://api.github.com/repos/kbower/tickettest2","labels_url":"https://api.github.com/repos/kbower/tickettest2/issues/425/labels{/name}","comments_url":"https://api.github.com/repos/kbower/tickettest2/issues/425/comments","events_url":"https://api.github.com/repos/kbower/tickettest2/issues/425/events","html_url":"https://github.com/kbower/tickettest2/issues/425","id":196194321,"number":425,"title":"Future upgrade of sqlalchemy dependencies","user":{"login":"kbower","id":4621154,"avatar_url":"https://avatars.githubusercontent.com/u/4621154?v=3","gravatar_id":"","url":"https://api.github.com/users/kbower","html_url":"https://github.com/kbower","followers_url":"https://api.github.com/users/kbower/followers","following_url":"https://api.github.com/users/kbower/following{/other_user}","gists_url":"https://api.github.com/users/kbower/gists{/gist_id}","starred_url":"https://api.github.com/users/kbower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kbower/subscriptions","organizations_url":"https://api.github.com/users/kbower/orgs","repos_url":"https://api.github.com/users/kbower/repos","events_url":"https://api.github.com/users/kbower/events{/privacy}","received_events_url":"https://api.github.com/users/kbower/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"kbower","id":4621154,"avatar_url":"https://avatars.githubusercontent.com/u/4621154?v=3","gravatar_id":"","url":"https://api.github.com/users/kbower","html_url":"https://github.com/kbower","followers_url":"https://api.github.com/users/kbower/followers","following_url":"https://api.github.com/users/kbower/following{/other_user}","gists_url":"https://api.github.com/users/kbower/gists{/gist_id}","starred_url":"https://api.github.com/users/kbower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kbower/subscriptions","organizations_url":"https://api.github.com/users/kbower/orgs","repos_url":"https://api.github.com/users/kbower/repos","events_url":"https://api.github.com/users/kbower/events{/privacy}","received_events_url":"https://api.github.com/users/kbower/received_events","type":"User","site_admin":false},"assignees":[{"login":"kbower","id":4621154,"avatar_url":"https://avatars.githubusercontent.com/u/4621154?v=3","gravatar_id":"","url":"https://api.github.com/users/kbower","html_url":"https://github.com/kbower","followers_url":"https://api.github.com/users/kbower/followers","following_url":"https://api.github.com/users/kbower/following{/other_user}","gists_url":"https://api.github.com/users/kbower/gists{/gist_id}","starred_url":"https://api.github.com/users/kbower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kbower/subscriptions","organizations_url":"https://api.github.com/users/kbower/orgs","repos_url":"https://api.github.com/users/kbower/repos","events_url":"https://api.github.com/users/kbower/events{/privacy}","received_events_url":"https://api.github.com/users/kbower/received_events","type":"User","site_admin":false}],"milestone":null,"comments":2,"created_at":"2016-12-17T03:58:13Z","updated_at":"2016-12-17T03:58:14Z","closed_at":null,"body":"_Imported from trac ticket 1550.\nCreated by kbower\nOpened in trac: Mar 21, 2012, 5:16:19 PM\nLast modified in trac: Oct 27, 2016, 2:01:03 PM_\n***\nRequired in sqlalchemy before upgrade:\n * https://bitbucket.org/zzzeek/sqlalchemy/issues/2350\n   * inside flush extensions we can reference related objects like normal and get our updated values (instead of what is currently in database)\n   * [[2471]](../commit/1ee45bb46387e2036d9c671ec99fe641c586913c)\n * ~~https://bitbucket.org/zzzeek/sqlalchemy/issues/2449~~\n   * polymorphic order types\n   * [[2518]](../commit/a60b63321bead0a7e788b320436816da6097cfa7)\n * ~~https://bitbucket.org/zzzeek/sqlalchemy/issues/2480~~\n   * polymorphic order types\n   * [[2729]](../commit/f9dfb5f76671c6b8266620ded616d02d9d963b4d)\n * https://bitbucket.org/zzzeek/sqlalchemy/issues/2497\n   * credit comments when split automatically\n   * [[2737]](../commit/f1d254845971fcb7e4001907df694fefdd6547f6)\n * ~~https://bitbucket.org/zzzeek/sqlalchemy/issues/2776~~\n   * oracle 8i reconnect issue\n   * [[4335]](../commit/178c9b85c177f734a97ad86423a99da117cfaaf9)\n * ~~https://bitbucket.org/zzzeek/sqlalchemy/commits/85368d25ed158c85bd19f4a63400884ab1cda26a?at=rel_0_9~~\n   * oracle 8 (non-ansi) nested join problem, especially with joinedload of sitestocklevels\n   * [[6053]](../commit/44d7162cd246aa1de5daab15b519dcb84d6f5bbf)\n   * see also [forum notes](https://groups.google.com/forum/#!topic/sqlalchemy/vPNi4ZXkq4E)\n * ~~https://bitbucket.org/zzzeek/sqlalchemy/issue/2453/~~\n   * bug when using joined aliases (especially on column_properties) that adds table too many times to SQL\n   * [[6499]](../commit/cc11975eeac27a7707e87eb01173c7fd7759d883)\n * ~~https://bitbucket.org/zzzeek/sqlalchemy/issues/2837~~\n   * Do not log large data (BLOB, CLOB, etc.)\n   * [[7577]](../commit/492dd24748b259032e5304d9d478b708c5341d2b) and [[7699]](../commit/6557d7c68715933d63cc505f64e62dc3a10073d2)\nNot required:\n * https://bitbucket.org/zzzeek/sqlalchemy/issues/2358 (may want to check where we reference PASSIVE_NO_FETCH and PASSIVE_NO_RESULT)\n * https://bitbucket.org/zzzeek/sqlalchemy/issues/2372\n * https://bitbucket.org/zzzeek/sqlalchemy/issues/1939\n\nSee and remove [[6178]](../commit/361398e20f144055bb3726a4203daabd1f788103) when upgraded sqlalchemy includes .exists() method.\n\nSee [[6269]](../commit/87e2a61ef23d99b27d9dda75f598e37d3a18e08a) processbases.py comment and fix after sqlalchemy >= 0.8\n"},"comment":{"url":"https://api.github.com/repos/kbower/tickettest2/issues/comments/267741391","html_url":"https://github.com/kbower/tickettest2/issues/425#issuecomment-267741391","issue_url":"https://api.github.com/repos/kbower/tickettest2/issues/425","id":267741391,"user":{"login":"kbower","id":4621154,"avatar_url":"https://avatars.githubusercontent.com/u/4621154?v=3","gravatar_id":"","url":"https://api.github.com/users/kbower","html_url":"https://github.com/kbower","followers_url":"https://api.github.com/users/kbower/followers","following_url":"https://api.github.com/users/kbower/following{/other_user}","gists_url":"https://api.github.com/users/kbower/gists{/gist_id}","starred_url":"https://api.github.com/users/kbower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kbower/subscriptions","organizations_url":"https://api.github.com/users/kbower/orgs","repos_url":"https://api.github.com/users/kbower/repos","events_url":"https://api.github.com/users/kbower/events{/privacy}","received_events_url":"https://api.github.com/users/kbower/received_events","type":"User","site_admin":false},"created_at":"2016-12-17T03:58:14Z","updated_at":"2016-12-17T03:58:14Z","body":"_Trac comment by kbower on Jun 05, 2012, 5:06:21 PM:_\n\n(Changeset [[2729]](../commit/f9dfb5f76671c6b8266620ded616d02d9d963b4d))\n * SQLAlchemy patch to address polymorphic inheritance redundant subquery loads (see http://www.sqlalchemy.org/trac/ticket/2480) (also see #1550)\n   * This is needed for Credit/Debits changes\n```diff\ndiff -rU5 SQLAlchemy-0.7.602kb/lib/sqlalchemy/__init__.py SQLAlchemy-0.7.603kb/lib/sqlalchemy/__init__.py\n--- SQLAlchemy-0.7.602kb/lib/sqlalchemy/__init__.py     2012-04-04 22:29:11.000000000 -0400\n+++ SQLAlchemy-0.7.603kb/lib/sqlalchemy/__init__.py     2012-06-05 16:56:32.000000000 -0400\n@@ -115,11 +115,11 @@\n\n\n __all__ = sorted(name for name, obj in locals().items()\n                  if not (name.startswith('_') or inspect.ismodule(obj)))\n\n-__version__ = '0.7.602kb'\n+__version__ = '0.7.603kb'\n\n del inspect, sys\n\n from sqlalchemy import util as _sa_util\n _sa_util.importlater.resolve_all()\ndiff -rU5 SQLAlchemy-0.7.602kb/lib/sqlalchemy/orm/strategies.py SQLAlchemy-0.7.603kb/lib/sqlalchemy/orm/strategies.py\n--- SQLAlchemy-0.7.602kb/lib/sqlalchemy/orm/strategies.py       2012-03-21 16:44:53.000000000 -0400\n+++ SQLAlchemy-0.7.603kb/lib/sqlalchemy/orm/strategies.py       2012-06-05 17:00:20.000000000 -0400\n@@ -932,11 +932,17 @@\n\n         local_cols, remote_cols = self._local_remote_columns(self.parent_property)\n\n         q = context.attributes[('subquery', reduced_path)]\n\n-        collections = dict(\n+        # cache the loaded collections in the context\n+        # so that inheriting mappers don't re-load when they\n+        # call upon create_row_processor again\n+        if ('collections', reduced_path) in context.attributes:\n+            collections = context.attributes[('collections', reduced_path)]\n+        else:\n+            collections = context.attributes[('collections', reduced_path)] = dict(\n                     (k, [v[0] for v in v])\n                     for k, v in itertools.groupby(\n                         q,\n                         lambda x:x[1:]\n                     ))\n```   \n"}}
{"actor":{"display_login":"kbower"}}