Coverage Summary for Class: TestVertexCreation (org.umlg.sqlg.test.mod)

 package org.umlg.sqlg.test.mod;
 
 import org.apache.tinkerpop.gremlin.process.traversal.dsl.graph.GraphTraversalSource;
 import org.apache.tinkerpop.gremlin.structure.T;
 import org.apache.tinkerpop.gremlin.structure.Vertex;
 import org.junit.Assert;
 import org.junit.Assume;
 import org.junit.Test;
 import org.umlg.sqlg.structure.topology.Topology;
 import org.umlg.sqlg.test.BaseTest;
 
 import java.sql.Connection;
 import java.sql.ResultSet;
 import java.sql.SQLException;
 import java.sql.Statement;
 
 /**
  * Date: 2014/07/12
  * Time: 2:26 PM
  */
 public class TestVertexCreation extends BaseTest {
 
     @Test
     public void testAddV() {
         GraphTraversalSource g = this.sqlgGraph.traversal();
         g.addV("person").property("name", "marko").property("age", 29).as("marko").
                 addV("person").property("name", "vadas").property("age", 27).as("vadas").
                 addV("software").property("name", "lop").property("lang", "java").as("lop").
                 addV("person").property("name", "josh").property("age", 32).as("josh").
                 addV("software").property("name", "ripple").property("lang", "java").as("ripple").
                 addV("person").property("name", "peter").property("age", 35).as("peter").
                 addE("knows").from("marko").to("vadas").property("weight", 0.5d).
                 addE("knows").from("marko").to("josh").property("weight", 1.0d).
                 addE("created").from("marko").to("lop").property("weight", 0.4d).
                 addE("created").from("josh").to("ripple").property("weight", 1.0d).
                 addE("created").from("josh").to("lop").property("weight", 0.4d).
                 addE("created").from("peter").to("lop").property("weight", 0.2d)
                 .iterate();
         Assert.assertEquals(6, this.sqlgGraph.traversal().V().count().next(), 0);
         g.V().addV("animal").property("age", 0).iterate();
         Assert.assertEquals(12, this.sqlgGraph.traversal().V().count().next(), 0);
         Assert.assertEquals(6, this.sqlgGraph.traversal().V().has("animal", "age", 0).count().next(), 0);
     }
 
     @Test
     public void testCreateEmptyVertex() throws SQLException {
         sqlgGraph.addVertex();
         sqlgGraph.tx().commit();
         try (Connection conn = this.sqlgGraph.getConnection()) {
             try (Statement stmt = conn.createStatement()) {
                 StringBuilder sql = new StringBuilder("SELECT * FROM ");
                 sql.append(this.sqlgGraph.getSqlDialect().maybeWrapInQoutes(this.sqlgGraph.getSqlDialect().getPublicSchema()));
                 sql.append(".");
                 sql.append(this.sqlgGraph.getSqlDialect().maybeWrapInQoutes(Topology.VERTEX_PREFIX + "vertex"));
                 if (this.sqlgGraph.getSqlDialect().needsSemicolon()) {
                     sql.append(";");
                 }
                 ResultSet rs = stmt.executeQuery(sql.toString());
                 int countRows = 0;
                 while (rs.next()) {
                     countRows++;
                 }
                 Assert.assertEquals(1, countRows);
                 rs.close();
             }
         }
     }
 
     @Test
     public void testCreateVertexWithProperties() throws SQLException {
         Assume.assumeTrue(this.sqlgGraph.getSqlDialect().supportsFloatValues());
         sqlgGraph.addVertex(T.label, "Person",
                 "boolean1", true,
                 "short1", (short) 1,
                 "integer1", 1,
                 "long1", 1L,
                 "float1", 1F,
                 "double1", 1D,
                 "name", "marko"
         );
         sqlgGraph.addVertex(T.label, "Person",
                 "boolean1", true,
                 "short1", (short) 1,
                 "integer1", 1,
                 "long1", 1L,
                 "float1", 1F,
                 "double1", 1D,
                 "name", "marko"
         );
         sqlgGraph.tx().commit();
 
         try (Connection conn = this.sqlgGraph.getConnection()) {
             try (Statement stmt = conn.createStatement()) {
                 StringBuilder sql = new StringBuilder("SELECT * FROM ");
                 sql.append(this.sqlgGraph.getSqlDialect().maybeWrapInQoutes(this.sqlgGraph.getSqlDialect().getPublicSchema()));
                 sql.append(".");
                 sql.append(this.sqlgGraph.getSqlDialect().maybeWrapInQoutes(Topology.VERTEX_PREFIX + "Person"));
                 if (this.sqlgGraph.getSqlDialect().needsSemicolon()) {
                     sql.append(";");
                 }
                 ResultSet rs = stmt.executeQuery(sql.toString());
                 int countRows = 0;
                 boolean boolean1 = false;
                 short short1 = (short) -1;
                 int integer1 = -1;
                 long long1 = -1L;
                 float float1 = -1F;
                 double double1 = -1D;
                 String name = "";
                 while (rs.next()) {
                     boolean1 = rs.getBoolean("boolean1");
                     short1 = rs.getShort("short1");
                     integer1 = rs.getInt("integer1");
                     long1 = rs.getLong("long1");
                     float1 = rs.getFloat("float1");
                     double1 = rs.getDouble("double1");
                     name = rs.getString("name");
                     countRows++;
                 }
                 Assert.assertEquals(2, countRows);
                 Assert.assertEquals(boolean1, true);
                 Assert.assertEquals(short1, (short) 1);
                 Assert.assertEquals(integer1, 1);
                 Assert.assertEquals(long1, 1L);
                 Assert.assertEquals(float1, 1F, 0);
                 Assert.assertEquals(double1, 1D, 0);
                 Assert.assertEquals("marko", name);
                 rs.close();
             }
         }
     }
 
     @Test
     public void testAndColumns() {
         Vertex v1 = this.sqlgGraph.addVertex(T.label, "Person", "name1", "marko");
         this.sqlgGraph.tx().commit();
         Assert.assertEquals(1, this.sqlgGraph.traversal().V().count().next(), 0);
         Assert.assertEquals(v1, this.sqlgGraph.traversal().V(v1.id()).next());
         Assert.assertEquals(1, vertexTraversal(this.sqlgGraph, v1).properties().count().next(), 0);
         Vertex v2 = this.sqlgGraph.addVertex(T.label, "Person", "name2", "john");
         Assert.assertEquals(2, this.sqlgGraph.traversal().V().count().next(), 0);
         Assert.assertEquals(v2, this.sqlgGraph.traversal().V(v2.id()).next());
         Assert.assertEquals(1, vertexTraversal(this.sqlgGraph, v2).properties().count().next(), 0);
     }
 
 }