self to self relationship

***remkonoteboom*** · 11-18-2019, 05:06 PM

My mistake. I did mean:

assets = server.eval("@SOBJECT(dolly3d/assets.dolly3d/assets_in_assets)", skey)

Ok, so this gives you one assets_in_assets back with code "ASSETS_IN_ASSETS00017" which is the only one you have in the database. It seems to have given you the relationship as a parent, which I believe is the first one in your schema.

Does:

assets = server.eval("@SOBJECT(dolly3d/assets.parent:dolly3d/assets_in_assets)", skey)

give you the same result?

listy · (This post was last modified: 11-18-2019, 05:11 PM by listy.)

No. It just returning me:
[{'__search_key__': 'dolly3d/assets?project=dolly3d&code=ASSETS00577',
'__search_type__': 'dolly3d/assets?project=dolly3d',
'assets_category_code': 'locations',
'code': 'ASSETS00577',
'description': '',
'id': 577,
'keywords': '',
'login': '',
'name': 'witch_house_inside',
'pipeline_code': 'dolly3d/assets',
'relative_dir': 'dolly3d/assets',
's_status': '',
'texture_drop': '',
'timestamp': '2019-10-11 20:05:58.005634'}]

I Think I should try this with Tactic 4.7. May be 4.5 have some bugs.
Or may be it is because of Assets Category. My full schema:
<?xml version="1.0" encoding="UTF-8"?>
<schema>
<search_type name="complex/assets_category" xpos="522" ypos="236"/>
<search_type name="complex/scenes" xpos="303" ypos="327"/>
<search_type name="complex/shot" xpos="303" ypos="415"/>
<search_type name="dolly3d/assets" xpos="303" ypos="236"/>
<search_type name="dolly3d/assets_in_assets" xpos="622" ypos="445"/>
<search_type name="dolly3d/assets_in_scenes" xpos="100" ypos="282"/>
<search_type name="dolly3d/texture" xpos="423" ypos="100" display="Texture"/>
<search_type name="dolly3d/texture_in_assets" xpos="102" ypos="100"/>
<connect from="complex/scenes" to="dolly3d/assets" instance_type="dolly3d/assets_in_scenes" relationship="instance"/>
<connect from="complex/shot" to="complex/scenes" relationship="code" from_col="scenes_code" to_col="code" type="hierarchy"/>
<connect from="dolly3d/assets" to="complex/assets_category" relationship="code" from_col="assets_category_code" to_col="code" type="hierarchy"/>
<connect from="dolly3d/assets" to="complex/scenes" instance_type="dolly3d/assets_in_scenes" relationship="instance"/>
<connect from="dolly3d/assets" to="dolly3d/texture" instance_type="dolly3d/texture_in_assets" relationship="instance"/>
<connect from="dolly3d/assets" to="dolly3d/assets" instance_type="dolly3d/assets_in_assets" relationship="instance"/>
<connect from="dolly3d/assets_in_assets" to="dolly3d/assets" relationship="code" from_col="parent_assets_code" to_col="code" type="many_to_many"/>
<connect from="dolly3d/assets_in_assets" to="dolly3d/assets" relationship="code" from_col="child_assets_code" to_col="code" type="many_to_many"/>
<connect from="dolly3d/assets_in_scenes" to="complex/scenes" relationship="code" type="many_to_many"/>
<connect from="dolly3d/assets_in_scenes" to="dolly3d/assets" relationship="code" from_col="assets_code" to_col="code" type="many_to_many"/>
<connect from="dolly3d/texture" to="complex/assets_category" relationship="code" from_col="assets_category_code" to_col="code" type="hierarchy"/>
<connect from="dolly3d/texture" to="dolly3d/assets" instance_type="dolly3d/texture_in_assets" relationship="instance"/>
<connect from="dolly3d/texture_in_assets" to="dolly3d/texture" relationship="code" from_col="texture_code" to_col="code" type="many_to_many"/>
<connect from="dolly3d/texture_in_assets" to="dolly3d/assets" relationship="code" from_col="assets_code" to_col="code" type="many_to_many"/>
</schema>

listy · 11-19-2019, 07:25 PM

Help Me Please ;(

***remkonoteboom*** · 11-19-2019, 09:18 PM

The return value you are getting doesn't make sense. It shouldn't return a "dolly3d/assets" list ... it should return a "dolly3d/assets_in_assets" list or at list an empty list if no results are found.

In src/pyasm/search/search.py we have the code:

2127 search.add_relationship_filters(sobjects, path=path)
2128 related_sobjects = search.get_sobjects()

If you could add in between these lines:

print("related_search: ", search.get_statement())

we can see exactly what sql is being called. That would be really helpful.

***remkonoteboom*** · 11-20-2019, 03:12 AM

I just added this to the vfx project:

<search_type name="vfx/asset_in_asset" xpos="528" ypos="187"/>
<connect from="vfx/asset_in_asset" to="vfx/asset" from_node="vfx/asset_in_asset" to_node="vfx/asset" relationship="code" from_col="parent_asset_code" to_col="code" path="parent"/>
<connect from="vfx/asset_in_asset" to="vfx/asset" from_node="vfx/asset_in_asset" to_node="vfx/asset" relationship="code" from_col="child_asset_code" to_colr="code" path="child"/>

And then wrote a quick test script:

import tacticenv

from pyasm.security import Batch

Batch(project_code="my_first_project")

from pyasm.search import Search
skey = "vfx/asset?project=my_first_project&code=ASSET00002"
asset = Search.get_by_search_key(skey)
assets = Search.eval("@SOBJECT(parent:vfx/asset_in_asset.child:vfx/asset)", asset)
for asset in assets:
print(asset.get_search_key())

This produced the correct result ... mind you this was in 4.7 using python3.

listy · 11-20-2019, 07:24 PM

Hello, Remko!
I know that You have 10 dan black belt in tactic, and expected some black magic from Tou, and there it is. Now everything working as expected, and i learned some new Schema features. Thanks a lot!
This is what i did:
<connect from="dolly3d/assets_in_assets" to="dolly3d/assets" from_node="dolly3d/assets_in_assets" to_node="dolly3d/assets" relationship="code" from_col="parent_assets_code" to_col="code" path="parent"/>
<connect from="dolly3d/assets_in_assets" to="dolly3d/assets" from_node="dolly3d/assets_in_assets" to_node="dolly3d/assets" relationship="code" from_col="child_assets_code" to_colr="code" path="child"/>

And now this returning me what i need:
server.set_project('dolly3d')
skey = ['dolly3d/assets?project=dolly3d&code=ASSETS00577']
server.eval("@SOBJECT(parent:dolly3d/assets_in_assets.child:dolly3d/assets)", search_keys=skey)

listy · 02-06-2020, 02:37 PM

Another question about related.
When i do TEL query - everything ok. But how i can do this with Search?

Trying to do this:
from pyasm.search import Search

server.set_project('testovy')

search_key = 'testovy/asset?project=testovy&code=ASSET00002'

search_type, search_code = server.split_search_key(search_key)
search = Search(search_type)
sobject = search.get_by_search_key(search_key)

related_sobjects = sobject.get_related_sobjects('testovy/asset_in_asset')

I got "Fault: <Fault 1: 'Search type [testovy/asset_in_asset?project=testovy] is not related to search_type [testovy/asset?project=testovy]'>

"

***remkonoteboom*** · 02-06-2020, 03:28 PM

This is entirely determined by the schema entry for your project. Your last example was with the project "dolly3d". this example is with "testovy". Are the schemas different for these two projects. In particular, does "testovy" have a line that conncects "asset" to "asset_in_asset"?

listy · (This post was last modified: 02-06-2020, 03:32 PM by listy.)

(02-06-2020, 03:28 PM)remkonoteboom Wrote: This is entirely determined by the schema entry for your project. Your last example was with the project "dolly3d". this example is with "testovy". Are the schemas different for these two projects. In particular, does "testovy" have a line that conncects "asset" to "asset_in_asset"?

It is the same. Schema is identical. Only names are different.

@SOBJECT(child:testovy/asset_in_asset['child_asset_code', 'ASSET00002'].parent:testovy/asset)

TEL which works fine.

Schema:
<connect from="testovy/asset" to="testovy/asset" instance_type="testovy/asset_in_asset" relationship="instance"/>
<connect from="testovy/asset_in_asset" to="testovy/asset" relationship="code" from_col="parent_asset_code" to_col="code" path="parent" type="many_to_many"/>
<connect from="testovy/asset_in_asset" to="testovy/asset" relationship="code" from_col="child_asset_code" to_col="code" path="child" type="many_to_many"/>

***remkonoteboom*** · (This post was last modified: 02-06-2020, 05:02 PM by remkonoteboom.)

I think it's because TEL is using a slightly different mechanism:

search_key = 'testovy/asset?project=testovy&code=ASSET00002'
search_type, search_code = server.split_search_key(search_key)
search = Search(search_type)
search.add_filter("code", search_code)

search2 = Search("testovy/asset_in_asset")
search2.add_relationship_search_filter(search)
related_sobjects = search2.get_sobjects()

This is more efficient because it never needs to get the first sobject. It is all done in a single SQL call.
You can see that "search" can be arbitrarily complex and it will use a subselect into the second search.

Could you see if that works? It will help me pinpoint the bug in get_related_sobjects() (which should work).