@Override public <E> List<E> getColumnsById(String schemaName, String tableName, String pKeyColumnName, String columnName, Object pKeyColumnValue, Class columnJavaType) { // search using index on pkey column List<E> foreignKeys = new ArrayList<E>(); Table schemaTable = tableAPI.getTable(tableName); Index index = schemaTable.getIndex(pKeyColumnName); IndexKey indexKey = index.createIndexKey(); // StringBuilder indexNamebuilder = new StringBuilder(); NoSqlDBUtils.add(schemaTable.getField(pKeyColumnName), indexKey, pKeyColumnValue, pKeyColumnName); KunderaCoreUtils.printQuery( "Get columns by id from:" + tableName + " for column:" + columnName + " where value:" + pKeyColumnValue, showQuery); Iterator<Row> rowsIter = tableAPI.tableIterator(indexKey, null, null); while (rowsIter.hasNext()) { Row row = rowsIter.next(); FieldDef fieldMetadata = schemaTable.getField(columnName); FieldValue value = row.get(columnName); foreignKeys.add((E) NoSqlDBUtils.get(fieldMetadata, value, null)); } return foreignKeys; }
@Override public void deleteByColumn(String schemaName, String tableName, String columnName, Object columnValue) { Table schemaTable = tableAPI.getTable(tableName); List<String> primaryKeys = schemaTable.getPrimaryKey(); Object[] foundRecords = findIdsByColumn(schemaName, tableName, primaryKeys.get(0), columnName, columnValue, null); KunderaCoreUtils.printQuery("Delete columns by id from:" + tableName, showQuery); if (foundRecords != null) { for (Object key : foundRecords) { PrimaryKey primaryKey = schemaTable.createPrimaryKey(); NoSqlDBUtils.add(schemaTable.getField(primaryKeys.get(0)), primaryKey, key, primaryKeys.get(0)); KunderaCoreUtils.printQuery(" Delete for id:" + key, showQuery); tableAPI.delete(primaryKey, null, null); } } }
tableAPI.execute(batch, null);
Table myTable = tableH.getTable("myTable"); PrimaryKey key = myTable.createPrimaryKey(); TableIterator<Row> rowIter = tableH.tableIterator(key, null, null); while (rowIter.hasNext()) { Row row = rowIter.next(); tableH.tableKeysIterator(key, null, null); while (keyIter.hasNext()) { PrimaryKey key = rowIter.next();
@Override protected void validate(List<TableInfo> tableInfos) { for (TableInfo tableInfo : tableInfos) { try { if (tableAPI.getTable(tableInfo.getTableName()) == null) { logger.error("No table found for " + tableInfo.getTableName()); throw new SchemaGenerationException("No table found for " + tableInfo.getTableName()); } } catch (FaultException e) { logger.error("Error while getting table " + tableInfo.getTableName() + ". Caused By: ", e); throw new SchemaGenerationException(e, "Error while getting table " + tableInfo.getTableName() + ". Caused By: "); } } }
Table table = tableAPI.getTable(tableInfo.getTableName()); if (table == null) result = tableAPI.executeSync(statement); if (!result.isSuccessful()) result = tableAPI.executeSync(statement);
StatementResult result = tableAPI.executeSync(builder.toString()); if (!result.isSuccessful())
/** * Adds the ops. * * @param operations * the operations * @param schemaTable * the schema table * @param row * the row */ private void addOps(Map<Key, List<TableOperation>> operations, Table schemaTable, Row row) { Key key = ((TableImpl) schemaTable).createKey(row, false); TableOperation ops = tableAPI.getTableOperationFactory().createPut(row, Choice.NONE, true); if (operations.containsKey(key)) { operations.get(key).add(ops); } else { List<TableOperation> operation = new ArrayList<TableOperation>(); operation.add(ops); operations.put(key, operation); } }
/** * On persist. * * @param entityMetadata * the entity metadata * @param entity * the entity * @param id * the id * @param rlHolders * the rl holders */ @Override protected void onPersist(EntityMetadata entityMetadata, Object entity, Object id, List<RelationHolder> rlHolders) { KunderaCoreUtils.printQuery( "Persist data into " + entityMetadata.getSchema() + "." + entityMetadata.getTableName() + " for " + id, showQuery); Row row = createRow(entityMetadata, entity, id, rlHolders); // TODO:: handle case for putDate?????? tableAPI.put(row, null, null); }
Map<Key, List<TableOperation>> operations = new HashMap<Key, List<TableOperation>>(); Table schemaTable = tableAPI.getTable(joinTableName); Row row = schemaTable.createRow();
@Override public void dropSchema() { // dropping all the tables in the Oracle NoSQL store if (operation != null && operation.equalsIgnoreCase("create-drop")) { for (TableInfo tableInfo : tableInfos) { try { StatementResult result = tableAPI.executeSync("DROP TABLE IF EXISTS " + tableInfo.getTableName()); if (!result.isSuccessful()) { throw new SchemaGenerationException("Unable to DROP TABLE " + tableInfo.getTableName()); } } catch (IllegalArgumentException e) { logger.error("Invalid DROP TABLE Statement. Caused By: ", e); throw new SchemaGenerationException(e, "Invalid DROP TABLE Statement. Caused By: "); } catch (FaultException e) { logger.error("DROP TABLE Statement couldn't be executed. Caused By: ", e); throw new SchemaGenerationException(e, "Invalid DROP TABLE Statement is executed. Caused By: "); } } } }
Table schemaTable = tableAPI.getTable(entityMetadata.getTableName()); String indexKeyName = indexNamebuilder.deleteCharAt(indexNamebuilder.length() - 1).toString(); Index index = schemaTable.getIndex(entityMetadata.getIndexProperties().get(indexKeyName).getName()); Iterator<Row> rowsIter = tableAPI.tableIterator(indexKey, null, null);
schemaTable = tableAPI.getTable(table);
result = tableAPI.executeSync("DROP TABLE IF EXISTS " + tableInfo.getTableName()); if (!result.isSuccessful()) result = tableAPI.executeSync(statement); if (!result.isSuccessful())
Table schemaTable = tableAPI.getTable(entityMetadata.getTableName()); Iterator<Row> rowsIter = tableAPI.tableIterator(schemaTable.createPrimaryKey(), null, null);
Table schemaTable = tableAPI.getTable(metadata.getTableName());
Table schemaTable = tableAPI.getTable(entityMetadata.getTableName()); rowsIter = tableAPI.tableIterator(rowKey, null, null); IndexKey indexKey = index.createIndexKey(); NoSqlDBUtils.add(schemaTable.getField(colName), indexKey, colValue, colName); rowsIter = tableAPI.tableIterator(indexKey, null, null);
Table schemaTable = tableAPI.getTable(entityMetadata.getTableName()); Iterator<Row> rowsIter = tableAPI.tableIterator(rowKey, null, null);