private String getAliasClause() { StringBuilder sb = new StringBuilder(); int i = 0; for (Map.Entry<Selector, String> entry : aliasColumns.entrySet()) { if (i != 0) { sb.append(","); } i = 1; if (!(entry.getKey() instanceof FunctionSelector)) { sb.append(Utils.toCaseSensitive(entry.getKey().getColumnName().getName())); } else if (sb.length() == 0) { i = 0; } } for (FunctionSelector selectorFunction : functions) { String functionString = getFunctionString(selectorFunction); if (i != 0) { sb.append(","); } i = 1; sb.append(functionString); } return sb.toString(); }
private String getLeftTerm(Relation relation) { String leftTerm = relation.getLeftTerm().getStringValue().substring(relation.getLeftTerm() .getStringValue().lastIndexOf('.') + 1, relation.getLeftTerm().getStringValue().length()); return leftTerm; }
private String getLuceneWhereClause(Relation relation) { String result; StringBuilder sb = new StringBuilder(); String column = relation.getLeftTerm().toString() .substring(relation.getLeftTerm().toString().lastIndexOf('.') + 1); String value = relation.getRightTerm().toSQLString(false); // Generate query for column String[] processedQuery = processLuceneQueryType(value); sb.append("{type:\""); sb.append(processedQuery[0]); sb.append("\",field:\""); sb.append(column); sb.append("\",value:\""); sb.append(processedQuery[1]); sb.append("\"},"); sb.replace(sb.length() - 1, sb.length(), ""); result = sb.toString(); return result; }
private void getStringRangeFunction(FunctionSelector function, ColumnSelector leftSelector) { if (luceneIndexExist) { luceneIndex.append(","); } List<Selector> functionSelectors = function.getFunctionColumns().getSelectorList(); String arg1 = functionSelectors.get(0).getStringValue(); String arg2 = functionSelectors.get(1).getStringValue(); String column = Utils.toCaseSensitive(leftSelector.getName().getName()); luceneIndex.append("{type:\"range\", field:").append(column).append(", " + "lower:\"").append(arg1).append("\", upper:\"").append(arg2) .append("\",include_upper: true, include_lower: true }"); luceneIndexExist = true; }
ColumnName cassandraColumnName = new ColumnName(def.getKeyspace(), def.getTable(), def.getName()); for (Map.Entry<Selector, String> entry : alias.entrySet()) { if (entry.getKey().getColumnName().getQualifiedName().equals(cassandraColumnName.getQualifiedName())) { columnMetadata = new ColumnMetadata(columnName, null, type); columnMetadata.getName().setAlias(entry.getValue()); boolean findIt = false; for (Map.Entry<Selector, String> entry : alias.entrySet()) { if (entry.getKey().getColumnName().getQualifiedName() .equals(cassandraColumnName.getQualifiedName())) { metaRow.addCell(entry.getValue(), metaCell);
@Override public String toString() { StringBuilder sb = new StringBuilder("DELETE FROM "); if (catalogInc) { sb.append(Utils.toCaseSensitive(catalog)).append("."); } sb.append(Utils.toCaseSensitive(tableName.getName())); if (!whereClauses.isEmpty()) { sb.append(" WHERE "); for (Filter filter : whereClauses) { Relation relation = filter.getRelation(); String leftTerm = relation.getLeftTerm().getStringValue().substring(relation.getLeftTerm() .getStringValue().lastIndexOf('.') + 1, relation.getLeftTerm().getStringValue().length()); sb.append(Utils.toCaseSensitive(leftTerm)).append(relation.getOperator().toString()).append (relation.getRightTerm().toString()).append(" AND "); } sb.delete(sb.lastIndexOf(" AND"), sb.length()); } return sb.toString(); }
if (entry.getKey().getColumnName().getQualifiedName().equals(cassandraColumnName.getQualifiedName())) { columnMetadata = new ColumnMetadata(columnName, null, type); columnMetadata.getName().setAlias(entry.getValue()); boolean findIt = false; for (Map.Entry<Selector, String> entry : alias.entrySet()) { if (entry.getKey().getColumnName().getQualifiedName() .equals(cassandraColumnName.getQualifiedName())) { metaRow.addCell(entry.getValue(), metaCell);
sb.append(" WITH "); for(Map.Entry<Selector,Selector> entry: properties.entrySet()) { sb.append(entry.getKey().getStringValue()).append(" = ").append(entry.getValue().toString()).append(" AND ");
String schema = map.get(new StringSelector("schema")).getStringValue(); String fieldsString = schema.substring(schema.indexOf("fields:{") + 8); String[] fields = fieldsString.split(",");
return right.toString(); case TIMEUUID: return right.getStringValue();