@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); } } }
@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: "); } } }
@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; }
Table schemaTable = tableAPI.getTable(entityMetadata.getTableName()); String indexKeyName = indexNamebuilder.deleteCharAt(indexNamebuilder.length() - 1).toString(); Index index = schemaTable.getIndex(entityMetadata.getIndexProperties().get(indexKeyName).getName());
Table schemaTable = tableAPI.getTable(entityMetadata.getTableName());
Map<Key, List<TableOperation>> operations = new HashMap<Key, List<TableOperation>>(); Table schemaTable = tableAPI.getTable(joinTableName); Row row = schemaTable.createRow();
schemaTable = tableAPI.getTable(table);
Table schemaTable = tableAPI.getTable(entityMetadata.getTableName());
Table table = tableAPI.getTable(tableInfo.getTableName()); if (table == null)
Table schemaTable = tableAPI.getTable(metadata.getTableName());
Table schemaTable = tableAPI.getTable(entityMetadata.getTableName());
Table schemaTable = tableAPI.getTable(entityMetadata.getTableName());
Table myTable = tableH.getTable("myTable"); PrimaryKey key = myTable.createPrimaryKey();