Can you add support for other field types for vertexes?

[afidegnum]

this didn't work out for me

CREATE (n:Person {name: 'top_node', attrib: {myclass: 'id'}})

neither a list of attributes. CREATE (n:Person {name: 'Joe', attrib: [{myclass: 'id'}]})

[pdpotter]

Can you explain in more detail what doesn't work out for you? I do get expected results with your queries:

SELECT * FROM ag_catalog.cypher('test_graph', $$CREATE (n:Person {name: 'top_node', attrib: {myclass: 'id'}}) return n$$) as (n agtype);

                                                          n                                                          
---------------------------------------------------------------------------------------------------------------------
 {"id": 844424930131970, "label": "Person", "properties": {"name": "top_node", "attrib": {"myclass": "id"}}}::vertex
(1 row)

SELECT * FROM ag_catalog.cypher('test_graph', $$CREATE (n:person {name: 'Joe', attrib: [{myclass: 'id'}]}) return n$$) as (n agtype);
                                                        n                                                         
------------------------------------------------------------------------------------------------------------------
 {"id": 844424930131971, "label": "person", "properties": {"name": "Joe", "attrib": [{"myclass": "id"}]}}::vertex
(1 row)

SELECT * FROM ag_catalog.cypher('test_graph', $$MATCH (n:person) return n.name, n.attrib$$) as (name agtype, attrib agtype);
    name    |       attrib        
------------+---------------------
 "top_node" | {"myclass": "id"}
 "Joe"      | [{"myclass": "id"}]
(2 rows)

[afidegnum]

def node_tree(parentid , element):
    if parentid:
       x = {key:value for (key,value) in element.attrib.items()}
       print(x)
    for child in element.iterchildren():
         node_tree(element, child)

x = dom_tree.getroot()
node_tree(None, x)

returns

{}
{'charset': 'UTF-8'}
{}
{}
{'class': 'menu'}
{'class': 'itm'}
{'class': 'itm'}
{'class': 'itm'}
{}
{'id': 'idone', 'class': 'classone'}
{}
{'class': 'listing'}
{'class': 'item1'}
{'class': 'item2'}
{'class': 'item3'}
{'id': 'innerone'}
{}
{'id': 'innertwo'}
{}
{'id': 'second', 'class': 'below'}
{'class': 'inner'}
{}
{}
{}

however i have a syntax error

SqlExcutionError: ("Excution ERR[can't adapt type 'dict'](SELECT * from cypher('text_test', $$ CREATE (t:node {tag: %s, %s} ) RETURN id(t) $$) as (v agtype);)", ProgrammingError("can't adapt type 'dict'"))


                                                             ^

I'm using https://github.com/rhizome-ai/apache-age-python

[pdpotter]

It's difficult to analyze your issue without a complete minimal reproducible example, but I think your issue might be more related to https://github.com/rhizome-ai/apache-age-python than to this repository.

Please provide the complete code of an example (as minimal as possible) to reproduce your issue.

[joefagan]

@afidegnum
It would be great if you submit self-contained code snippets to see your problem.
Creating code from scratch, to try to replicate what you might be doing is time consuming and we may be missing your issues as we have seen a couple of times. IE we didn't catch what the problem with your code is.

[jrgemignani]

Is this still an issue? Or, can this ticket be closed?

[afidegnum]

Sure, the ticket can be closed.