Question: Apoc Functions

[g3rd]

How would you write:

MATCH (u:User {username: 'chad'}) 
WITH apoc.text.join([u.first_name, u.last_name], ' ') AS full_name
RETURN full_name

Thanks!

[emehrkay]

There are a few ways to do it, this is the first that came to mind:

p.WITH.func_raw('apoc.text.join', __.List(__.u.__first_name__, __.u.__last_name__), "''").alias('full_name')                                    
p.RETURN.full_name 

Or you could define the function, this is probably the best case

create_function('apoc_text_join', {'name': 'apoc.text.join'}, func_raw=True) # new release to allow for func_raw argument here

p = Pypher()
p.WITH.apoc_text_join(__.List(__.u.__first_name__, __.u.__last_name__), "''").alias('full_name')                                    

note: you must double quote the quotes that you want to appear in your resulting Cypher

[g3rd]

@emehrkay this is amazing! Thanks!