abhimanyu-bitsgoa

docker run orientdb

abhimanyu-bitsgoa

This is a test GIST

abhimanyu-bitsgoa

CREATE CLASS USER EXTENDS V
CREATE CLASS PAGE EXTENDS V
CREATE CLASS COURSE EXTENDS V
CREATE CLASS VERSION EXTENDS V
CREATE CLASS CONTRIBUTE EXTENDS E
CREATE CLASS REVIEW EXTENDS E
CREATE CLASS INSIDE EXTENDS E
CREATE CLASS V_STACK EXTENDS E
CREATE CLASS P_VERSION EXTENDS E

abhimanyu-bitsgoa

CREATE VERTEX USER SET NAME="JON",J_DATE="2014-05-12"
CREATE VERTEX USER SET NAME="JOSH",J_DATE="2015-05-20"
CREATE VERTEX USER SET NAME="JACOB",J_DATE="2013-12-10"

abhimanyu-bitsgoa

CREATE VERTEX PAGE SET NAME="NEWTON LAW",C_RELIABILITY=2.0,RATING=3.4
CREATE VERTEX PAGE SET NAME="WORK AND POWER",C_RELIABILITY=2.0,RATING=3.4
CREATE VERTEX PAGE SET NAME="PSEUDO FORCE",C_RELIABILITY=2.0,RATING=3.4

abhimanyu-bitsgoa

CREATE VERTEX VERSION SET V_NO=0,P_NAME="NEWTON LAW",C_RELIABILITY=1.0,RATING=4.2
CREATE VERTEX VERSION SET V_NO=1,P_NAME="NEWTON LAW",C_RELIABILITY=1.0,RATING=4.2
CREATE VERTEX VERSION SET V_NO=1,P_NAME="WORK AND POWER",C_RELIABILITY=1.0,RATING=4.2
CREATE VERTEX VERSION SET V_NO=0,P_NAME="WORK AND POWER",C_RELIABILITY=1.0,RATING=4.2
CREATE VERTEX VERSION SET V_NO=0,P_NAME="PSEUDO FORCE",C_RELIABILITY=1.0,RATING=4.2
CREATE VERTEX VERSION SET V_NO=1,P_NAME="PSEUDO FORCE",C_RELIABILITY=1.0,RATING=4.2

abhimanyu-bitsgoa

CREATE VERTEX COURSE SET NAME="MECHANICS",C_RELIABILITY=2.0,C_VOTE=5.2

abhimanyu-bitsgoa

CREATE EDGE CONTRIBUTE FROM (SELECT FROM USER WHERE NAME="JON") TO (SELECT FROM VERSION WHERE P_NAME="NEWTON LAW")

CREATE EDGE CONTRIBUTE FROM (SELECT FROM USER WHERE NAME="JOSH") TO (SELECT FROM VERSION WHERE P_NAME="WORK AND POWER" OR (P_NAME="PSEUDO FORCE" AND V_NO=0))

CREATE EDGE CONTRIBUTE FROM (SELECT FROM USER WHERE NAME="JACOB") TO (SELECT FROM VERSION WHERE P_NAME="PSEUDO FORCE" AND V_NO=1)

abhimanyu-bitsgoa

CREATE EDGE REVIEW FROM (SELECT FROM USER WHERE NAME="JON") TO (SELECT FROM VERSION WHERE P_NAME="PSEUDO FORCE" AND V_NO=0) SET VOTE=5

CREATE EDGE REVIEW FROM (SELECT FROM USER WHERE NAME="JOSH") TO (SELECT FROM VERSION WHERE P_NAME="NEWTON LAW" AND V_NO=1) SET VOTE=8

CREATE EDGE REVIEW FROM (SELECT FROM USER WHERE NAME="JACOB") TO (SELECT FROM VERSION WHERE P_NAME="WORK AND POWER" ) SET VOTE=9

abhimanyu-bitsgoa

CREATE EDGE P_VERSION FROM (SELECT * FROM VERSION WHERE P_NAME="NEWTON LAW" AND V_NO=0) TO (SELECT * FROM VERSION WHERE P_NAME="NEWTON LAW" AND V_NO=1)

CREATE EDGE P_VERSION FROM (SELECT * FROM VERSION WHERE P_NAME="PSEUDO FORCE" AND V_NO=0) TO (SELECT * FROM VERSION WHERE P_NAME="PSEUDO FORCE" AND V_NO=1)

CREATE EDGE P_VERSION FROM (SELECT * FROM VERSION WHERE P_NAME="WORK AND POWER" AND V_NO=0) TO (SELECT * FROM VERSION WHERE P_NAME="WORK AND POWER" AND V_NO=1)