Thanks very much, Luigi and SavioL. That should get me on the right track.
On Monday, June 1, 2015 at 6:59:30 AM UTC-4, SavioL wrote:
>
> Hi Ropel,
>
> try this function, should be the solution you are looking for.
>
> First you should create a User class with name, nameschool
> and then paste this code into functions tab and choose how javascript.
> Give a name to the function, save and run it.
>
> *1 question (using the function):*
> var gdb = orient.getGraphNoTx();
>
> gdb.command( "sql", "create property User.Name2 String");
> gdb.command( "sql", "update User set Name2='' ");
>
> should create you for every user the property name2 (to see: select from
> User)
>
> *2 question (using the function)*
>
> var gdb = orient.getGraphNoTx();
> var node = gdb.command( "sql", "SELECT FROM User");
>
> gdb.command( "sql", "create class School extends V");
> gdb.command("sql", "create class link_to_school extends E");
> gdb.command( "sql", "create property School.nameschool String");
>
> var listschool = gdb.command( "sql", "select distinct(nameschool) as
> nameschool from User");
> var name;
> for(i=0; i<listschool.length; i++) {
> name = listschool[i].getProperty("nameschool");
> gdb.command( "sql", "insert into School (nameschool)
> values('"+name+"')");
> }
>
> var rid_user;
> var school_user;
> for(i=0; i<node.length; i++) {
> rid_user = node[i].getId().toString()+"";
> school_user = node[i].getProperty("nameschool");
> gdb.command( "sql", "create edge link_to_school from " +rid_user+ " to
> (select from School where nameschool = '"+school_user+"')" );
> }
>
> It should create you for every user who has the name of the school, a link
> between user and school
> example view image above.
>
> reguards
> Luigi S.
>
>
>
> Il giorno lunedì 1 giugno 2015 02:00:47 UTC+2, [email protected] ha
> scritto:
>>
>> I imported a lot of data in a pretty messy format thinking it would be
>> easy to edit the records later. It hasn't been and I think it's because I'm
>> struggling to understand the Orient SQL syntax. I'm using oriento but raw
>> queries are fine.
>>
>>
>> General questions that I can't find answers to in the manual:
>>
>>
>> How do I copy a property from another property for all nodes? (e.g. I
>> have a property called “name” and I want to create another identical
>> property on the same node with identical data called “name2”, and repeat
>> this on every node).
>>
>>
>> I also want to create nodes from the properties of another node. (e.g.
>> I have a node “Person” which has a property “school” and I want to create a
>> node for each school and then a link from the person to the school).
>>
>>
>> Thanks for your help.
>>
>
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
