{"action":"closed","issue":{"url":"https://api.github.com/repos/VirtualFlyBrain/VFB_neo4j/issues/32","repository_url":"https://api.github.com/repos/VirtualFlyBrain/VFB_neo4j","labels_url":"https://api.github.com/repos/VirtualFlyBrain/VFB_neo4j/issues/32/labels{/name}","comments_url":"https://api.github.com/repos/VirtualFlyBrain/VFB_neo4j/issues/32/comments","events_url":"https://api.github.com/repos/VirtualFlyBrain/VFB_neo4j/issues/32/events","html_url":"https://github.com/VirtualFlyBrain/VFB_neo4j/issues/32","id":225122294,"node_id":"MDU6SXNzdWUyMjUxMjIyOTQ=","number":32,"title":"KB2Prod","user":{"login":"dosumis","id":112839,"node_id":"MDQ6VXNlcjExMjgzOQ==","avatar_url":"https://avatars3.githubusercontent.com/u/112839?v=4","gravatar_id":"","url":"https://api.github.com/users/dosumis","html_url":"https://github.com/dosumis","followers_url":"https://api.github.com/users/dosumis/followers","following_url":"https://api.github.com/users/dosumis/following{/other_user}","gists_url":"https://api.github.com/users/dosumis/gists{/gist_id}","starred_url":"https://api.github.com/users/dosumis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dosumis/subscriptions","organizations_url":"https://api.github.com/users/dosumis/orgs","repos_url":"https://api.github.com/users/dosumis/repos","events_url":"https://api.github.com/users/dosumis/events{/privacy}","received_events_url":"https://api.github.com/users/dosumis/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2017-04-28T15:54:15Z","updated_at":"2018-06-07T15:58:19Z","closed_at":"2018-06-07T15:58:19Z","author_association":"MEMBER","body":"Most information should move between KB and Prod via OWL, but some will have to be moved directly.\r\n\r\n1. All nodes not marked as :Class or :Individual or :Property\r\n\r\n```cql\r\nMATCH (n) \r\nWHERE not('Class' IN labels(n)) \r\nAND not('Individual' IN labels(n)) \r\nAND not('Property' IN labels(n))  RETURN \r\nlabels(n) AS labels , properties(n) as properties; \r\n```\r\n\r\n=>\r\nREST QUERY JSON:\r\n\r\n```python\r\n[{'columns': ['labels', 'properties'],\r\n  'data': [{'meta': [None, None, None, None],\r\n    'row': [['data_source'],\r\n     {'dataset_link': 'http://flybase.org/reports/FBrf0221412.html',\r\n      'dataset_spec_text': 'This clone was generated by FLP-out MARCM at larval hatching. It therefore does not include embryonic born neurons.',\r\n      'name': 'Yu2013'}]},\r\n```\r\n\r\n2. All edges not marked as :Related, :INSTANCEOF, :SUBCLASSOF*\r\n\r\n\\* So far we don't have any of these in KB\r\n\r\n```cql\r\nMATCH (n)-[r]->(m) \r\nWHERE not(type(r) IN ['INSTANCEOF', 'Related']) \r\nRETURN n.IRI AS subject, type(r) AS reltype, \r\nproperties(r) AS relprops, m.IRI AS object \r\nLIMIT 3\r\n```\r\n=>\r\nREST QUERY JSON:\r\n\r\n\r\n```python\r\n[{'columns': ['subject', 'reltype', 'relprops', 'object'],\r\n  'data': [{'meta': [None, None, None, None],\r\n    'row': ['http://virtualflybrain.org/reports/VFB_00024231',\r\n     'has_source',\r\n     {'id_in_source': 'None'},\r\n     None]},\r\n   {'meta': [None, None, None, None],\r\n    'row': ['http://virtualflybrain.org/reports/VFB_00024233',\r\n     'has_source',\r\n     {'id_in_source': 'None'},\r\n     None]}]}]\r\n```\r\n\r\nWe need a standard script that unrolls these and re-rolls them for prod.\r\n\r\nIn the current scheme, channel individuals are not translated to OWL.  \r\nTBD: Is it easier to transfer these directly, or to extend the current OWL rolling scripts?  \r\n\r\nNote: New OWL gen via scala will take channels by default.\r\n\r\n"}}
{"actor":{"display_login":"dosumis"}}