sql.append(maybeWrapInQoutes(Topology.VERTEX_PREFIX + vertexLabel.getName())); sql.append(" WHERE "); if (vertexLabel.hasIDPrimaryKey()) { sql.append(maybeWrapInQoutes("ID")); } else { int count = 1; for (RecordId.ID id : ids) { if (vertexLabel.hasIDPrimaryKey()) { sql.append(id.getSequenceId()); if (count++ < ids.size()) {
sql.append(maybeWrapInQoutes(Topology.VERTEX_PREFIX + vertexLabel.getName())); sql.append(" WHERE "); if (vertexLabel.hasIDPrimaryKey()) { sql.append(maybeWrapInQoutes("ID")); } else { int count = 1; for (RecordId.ID id : ids) { if (vertexLabel.hasIDPrimaryKey()) { sql.append(id.getSequenceId()); if (count++ < ids.size()) {
@Override public Object[] getRowData() { List<Object> values = new ArrayList<>(); addValues(values); if (this.inVertexLabel.hasIDPrimaryKey()) { values.add(((RecordId) this.currentRow.getMiddle().id()).sequenceId()); } else { for (Object identifier : ((RecordId) this.currentRow.getMiddle().id()).getIdentifiers()) { values.add(identifier); } } if (this.outVertexLabel.hasIDPrimaryKey()) { values.add(((RecordId) this.currentRow.getLeft().id()).sequenceId()); } else { for (Object identifier : ((RecordId) this.currentRow.getLeft().id()).getIdentifiers()) { values.add(identifier); } } return values.toArray(); }
sql.append(maybeWrapInQoutes(Topology.EDGE_PREFIX + edgeLabel.getName())); sql.append(" WHERE "); if (vertexLabel.hasIDPrimaryKey()) { sql.append(maybeWrapInQoutes( vertexLabel.getSchema().getName() + "." + vertexLabel.getName() int count = 1; for (RecordId.ID id : ids) { if (vertexLabel.hasIDPrimaryKey()) { sql.append(id.getSequenceId()); } else {
sql.append(maybeWrapInQoutes(Topology.EDGE_PREFIX + edgeLabel.getName())); sql.append(" WHERE "); if (vertexLabel.hasIDPrimaryKey()) { sql.append(maybeWrapInQoutes( vertexLabel.getSchema().getName() + "." + vertexLabel.getName() int count = 1; for (RecordId.ID id : ids) { if (vertexLabel.hasIDPrimaryKey()) { sql.append(id.getSequenceId()); } else {
sql.append("\nWHERE\n\t"); if (vertexLabel.hasIDPrimaryKey()) { sql.append(this.sqlgGraph.getSqlDialect().maybeWrapInQoutes("ID")); sql.append(" = ?"); if (vertexLabel.hasIDPrimaryKey()) { preparedStatement.setLong(1, this.recordId.sequenceId()); } else {
sql.append("\nWHERE\n\t"); if (vertexLabel.hasIDPrimaryKey()) { sql.append(this.sqlgGraph.getSqlDialect().maybeWrapInQoutes("ID")); sql.append(" = ?"); if (vertexLabel.hasIDPrimaryKey()) { preparedStatement.setLong(1, this.recordId.sequenceId()); } else {
if (lbl != null) { ForeignKey foreignKey; if (hasIDPrimaryKey()) { foreignKey = ForeignKey.of(this.getFullName() + Topology.OUT_VERTEX_COLUMN_END); } else { if (lbl != null) { ForeignKey foreignKey; if (this.hasIDPrimaryKey()) { foreignKey = ForeignKey.of(this.getFullName() + Topology.IN_VERTEX_COLUMN_END); } else {
if (lbl != null) { ForeignKey foreignKey; if (hasIDPrimaryKey()) { foreignKey = ForeignKey.of(this.getFullName() + Topology.OUT_VERTEX_COLUMN_END); } else { if (lbl != null) { ForeignKey foreignKey; if (this.hasIDPrimaryKey()) { foreignKey = ForeignKey.of(this.getFullName() + Topology.IN_VERTEX_COLUMN_END); } else {
for (VertexLabel vertexLabel : this.uncommittedInVertexLabels) { if (!this.uncommittedRemovedInVertexLabels.contains(vertexLabel)) { if (vertexLabel.hasIDPrimaryKey()) { result.add(ForeignKey.of(vertexLabel.getFullName() + Topology.IN_VERTEX_COLUMN_END)); } else { if (vertexLabel.hasIDPrimaryKey()) { result.add(ForeignKey.of(vertexLabel.getFullName() + Topology.OUT_VERTEX_COLUMN_END)); } else {
for (VertexLabel vertexLabel : this.uncommittedInVertexLabels) { if (!this.uncommittedRemovedInVertexLabels.contains(vertexLabel)) { if (vertexLabel.hasIDPrimaryKey()) { result.add(ForeignKey.of(vertexLabel.getFullName() + Topology.IN_VERTEX_COLUMN_END)); } else { if (vertexLabel.hasIDPrimaryKey()) { result.add(ForeignKey.of(vertexLabel.getFullName() + Topology.OUT_VERTEX_COLUMN_END)); } else {
for (VertexLabel vertexLabel : this.getInVertexLabels()) { if (!this.getSchema().getTopology().isSqlWriteLockHeldByCurrentThread() || !this.uncommittedRemovedInVertexLabels.contains(vertexLabel)) { if (vertexLabel.hasIDPrimaryKey()) { result.add(ForeignKey.of(vertexLabel.getFullName() + Topology.IN_VERTEX_COLUMN_END)); } else { if (vertexLabel.hasIDPrimaryKey()) { result.add(ForeignKey.of(vertexLabel.getFullName() + Topology.OUT_VERTEX_COLUMN_END)); } else {
for (VertexLabel vertexLabel : this.getInVertexLabels()) { if (!this.getSchema().getTopology().isSqlWriteLockHeldByCurrentThread() || !this.uncommittedRemovedInVertexLabels.contains(vertexLabel)) { if (vertexLabel.hasIDPrimaryKey()) { result.add(ForeignKey.of(vertexLabel.getFullName() + Topology.IN_VERTEX_COLUMN_END)); } else { if (vertexLabel.hasIDPrimaryKey()) { result.add(ForeignKey.of(vertexLabel.getFullName() + Topology.OUT_VERTEX_COLUMN_END)); } else {
int i = addMetaData(bulkCopy, sqlgGraph); if (inVertexLabel.hasIDPrimaryKey()) { bulkCopy.addColumnMapping(i, metaEdge.getInLabel() + Topology.IN_VERTEX_COLUMN_END); this.columnMetadata.put(i++, new ColumnMetadata( if (outVertexLabel.hasIDPrimaryKey()) { bulkCopy.addColumnMapping(i, metaEdge.getOutLabel() + Topology.OUT_VERTEX_COLUMN_END); this.columnMetadata.put(i++, new ColumnMetadata(
@Override public Vertex addVertex(Object... keyValues) { if (this.tx().isInStreamingBatchMode()) { throw SqlgExceptions.invalidMode(String.format("Transaction is in %s, use streamVertex(Object ... keyValues)", this.tx().getBatchModeType().toString())); } if (this.tx().isInStreamingWithLockBatchMode()) { return internalStreamVertex(keyValues); } else { Triple<Map<String, PropertyType>, Map<String, Object>, Map<String, Object>> keyValueMapTriple = SqlgUtil.validateVertexKeysValues(this.sqlDialect, keyValues); final Pair<Map<String, Object>, Map<String, Object>> keyValueMapPair = Pair.of(keyValueMapTriple.getMiddle(), keyValueMapTriple.getRight()); final Map<String, PropertyType> columns = keyValueMapTriple.getLeft(); final String label = ElementHelper.getLabelValue(keyValues).orElse(Vertex.DEFAULT_LABEL); SchemaTable schemaTablePair = SchemaTable.from(this, label); this.tx().readWrite(); VertexLabel vertexLabel = this.getTopology().ensureVertexLabelExist(schemaTablePair.getSchema(), schemaTablePair.getTable(), columns); if (!vertexLabel.hasIDPrimaryKey()) { Preconditions.checkArgument(columns.keySet().containsAll(vertexLabel.getIdentifiers()), "identifiers must be present %s", vertexLabel.getIdentifiers()); } return new SqlgVertex(this, false, false, schemaTablePair.getSchema(), schemaTablePair.getTable(), keyValueMapPair); } }
@Override public Vertex addVertex(Object... keyValues) { if (this.tx().isInStreamingBatchMode()) { throw SqlgExceptions.invalidMode(String.format("Transaction is in %s, use streamVertex(Object ... keyValues)", this.tx().getBatchModeType().toString())); } if (this.tx().isInStreamingWithLockBatchMode()) { return internalStreamVertex(keyValues); } else { Triple<Map<String, PropertyType>, Map<String, Object>, Map<String, Object>> keyValueMapTriple = SqlgUtil.validateVertexKeysValues(this.sqlDialect, keyValues); final Pair<Map<String, Object>, Map<String, Object>> keyValueMapPair = Pair.of(keyValueMapTriple.getMiddle(), keyValueMapTriple.getRight()); final Map<String, PropertyType> columns = keyValueMapTriple.getLeft(); final String label = ElementHelper.getLabelValue(keyValues).orElse(Vertex.DEFAULT_LABEL); SchemaTable schemaTablePair = SchemaTable.from(this, label); this.tx().readWrite(); VertexLabel vertexLabel = this.getTopology().ensureVertexLabelExist(schemaTablePair.getSchema(), schemaTablePair.getTable(), columns); if (!vertexLabel.hasIDPrimaryKey()) { Preconditions.checkArgument(columns.keySet().containsAll(vertexLabel.getIdentifiers()), "identifiers must be present %s", vertexLabel.getIdentifiers()); } return new SqlgVertex(this, false, false, schemaTablePair.getSchema(), schemaTablePair.getTable(), keyValueMapPair); } }
this.getSchema().getTopology().addInForeignKeysToVertexLabel(this, edgeLabel); ForeignKey foreignKey; if (this.hasIDPrimaryKey()) { foreignKey = ForeignKey.of(this.getFullName() + Topology.IN_VERTEX_COLUMN_END); } else { if (lbl.isValid()) { ForeignKey foreignKey; if (this.hasIDPrimaryKey()) { foreignKey = ForeignKey.of(this.getFullName() + Topology.IN_VERTEX_COLUMN_END); } else {
sql.append(sqlDialect.maybeWrapInQoutes(tableName)); sql.append(" ("); if (inEdgeRole.getVertexLabel().hasIDPrimaryKey()) { sql.append(sqlDialect.maybeWrapInQoutes(inEdgeRole.getVertexLabel().getSchema().getName() + "." + inEdgeRole.getVertexLabel().getLabel() + Topology.IN_VERTEX_COLUMN_END)); } else { sql.append(sqlDialect.maybeWrapInQoutes(tableName)); sql.append(" ("); if (outEdgeRole.getVertexLabel().hasIDPrimaryKey()) { sql.append(sqlDialect.maybeWrapInQoutes(outEdgeRole.getVertexLabel().getSchema().getName() + "." + outEdgeRole.getVertexLabel().getLabel() + Topology.OUT_VERTEX_COLUMN_END)); } else {
if (vertexLabel.hasIDPrimaryKey()) { foreignKey = ForeignKey.of(vertexLabel.getFullName() + OUT_VERTEX_COLUMN_END); } else { if (vertexLabel.hasIDPrimaryKey()) { foreignKey = ForeignKey.of(vertexLabel.getFullName() + IN_VERTEX_COLUMN_END); } else {
if (vertexLabel.hasIDPrimaryKey()) { foreignKey = ForeignKey.of(vertexLabel.getFullName() + OUT_VERTEX_COLUMN_END); } else { if (vertexLabel.hasIDPrimaryKey()) { foreignKey = ForeignKey.of(vertexLabel.getFullName() + IN_VERTEX_COLUMN_END); } else {