New command to create links starting from JOINs [moved]

[lvca]

This is Issue 46 moved from a Google Code project.
Added by 2010-06-17T17:22:00.000Z by l.garu...@gmail.com.
Please review that bug for more context and additional comments, but update this bug.
Closed (Fixed).

Original labels: Type-Enhancement, Priority-Low, v0.9.18

Original description

Most (almost all) users comes from Relational model. They have products and already made database.

Surely one fundamental feature to help migrations from the RDBMS is the convertion of JOINs (and namely foreign keys) to OrientDB LINKS.

It will be created an ad-hoc command such as:

create link from <source-class>.<source-field> to <dest-class>.<dest-field>

Example:

create link from Post.user to Post.id

It will create also the property as LINK in the schema.

After that you could use:

SELECT FROM Post WHERE Post.user.name = 'Jay'