private static void addColumnData(ArrayList<String> columns, ArrayList<String> data, Expression expr) { if (expr instanceof ConditionAndOr) { ConditionAndOr and = (ConditionAndOr) expr; Expression left = and.getExpression(true); Expression right = and.getExpression(false); addColumnData(columns, data, left); addColumnData(columns, data, right); } else { Comparison comp = (Comparison) expr; ExpressionColumn ec = (ExpressionColumn) comp.getExpression(true); ValueExpression ev = (ValueExpression) comp.getExpression(false); String columnName = ec.getColumnName(); columns.add(columnName); if (ev == null) { data.add(null); } else { data.add(ev.getValue(null).getString()); } } }
.parseExpression(tab); String schemaName = expr.getOriginalTableAliasName(); String tableName = expr.getColumnName(); q = q.substring(idx + " WHERE ".length()); Object[][] columnData = parseKey(conn, q);
found = db.equalsIdentifiers(col, c.getColumnName()); if (found && tableAlias != null) { String ca = c.getOriginalTableAliasName(); String ta = exprCol.getSQL(); String tb = c2.getSQL(); String s2 = c2.getColumnName(); found = db.equalsIdentifiers(col, s2); if (!db.equalsIdentifiers(ta, tb)) {
column.getName()); for (int i = 0; i < columns.length; i++) { if (expr.getColumnName().equals(columns[i].getName())) { if (condition == null) { condition = new Comparison(session, Comparison.EQUAL, expr, row[i]);
sequenceName = sql; } else { sequenceName = seq.getColumnName();
SCHEMA_NAME.get(expCol), expCol.getOriginalTableAliasName(), expCol.getColumnName());
private static void addColumnData(ArrayList columns, ArrayList data, Expression expr) { if (expr instanceof ConditionAndOr) { ConditionAndOr and = (ConditionAndOr) expr; Expression left = and.getExpression(true); Expression right = and.getExpression(false); addColumnData(columns, data, left); addColumnData(columns, data, right); } else { Comparison comp = (Comparison) expr; ExpressionColumn ec = (ExpressionColumn) comp.getExpression(true); ValueExpression ev = (ValueExpression) comp.getExpression(false); String columnName = ec.getColumnName(); columns.add(columnName); if (ev == null) { data.add(null); } else { data.add(ev.getValue(null).getString()); } } }
private static void addColumnData(ArrayList<String> columns, ArrayList<String> data, Expression expr) { if (expr instanceof ConditionAndOr) { ConditionAndOr and = (ConditionAndOr) expr; Expression left = and.getExpression(true); Expression right = and.getExpression(false); addColumnData(columns, data, left); addColumnData(columns, data, right); } else { Comparison comp = (Comparison) expr; ExpressionColumn ec = (ExpressionColumn) comp.getExpression(true); ValueExpression ev = (ValueExpression) comp.getExpression(false); String columnName = ec.getColumnName(); columns.add(columnName); if (ev == null) { data.add(null); } else { data.add(ev.getValue(null).getString()); } } }
private static void addColumnData(ArrayList<String> columns, ArrayList<String> data, Expression expr) { if (expr instanceof ConditionAndOr) { ConditionAndOr and = (ConditionAndOr) expr; Expression left = and.getExpression(true); Expression right = and.getExpression(false); addColumnData(columns, data, left); addColumnData(columns, data, right); } else { Comparison comp = (Comparison) expr; ExpressionColumn ec = (ExpressionColumn) comp.getExpression(true); ValueExpression ev = (ValueExpression) comp.getExpression(false); String columnName = ec.getColumnName(); columns.add(columnName); if (ev == null) { data.add(null); } else { data.add(ev.getValue(null).getString()); } } }
ExpressionColumn expr = (ExpressionColumn) p.parseExpression(tab); String schemaName = expr.getOriginalTableAliasName(); String tableName = expr.getColumnName(); q = q.substring(idx + " WHERE ".length()); Object[][] columnData = parseKey(conn, q);
ExpressionColumn expr = (ExpressionColumn) p.parseExpression(tab); String schemaName = expr.getOriginalTableAliasName(); String tableName = expr.getColumnName(); q = q.substring(idx + " WHERE ".length()); Object[][] columnData = parseKey(conn, q);
ExpressionColumn expr = (ExpressionColumn) p.parseExpression(tab); String schemaName = expr.getOriginalAliasName(); String tableName = expr.getColumnName(); q = q.substring(idx + " WHERE ".length()); Object[][] columnData = parseKey(conn, q);
private Expression prepareUpdateCondition(Index foundIndex) { Expression condition = null; for (Column column : foundIndex.getColumns()) { ExpressionColumn expr = new ExpressionColumn(session.getDatabase(), table.getSchema().getName(), table.getName(), column.getName()); for (int i = 0; i < columns.length; i++) { if (expr.getColumnName().equals(columns[i].getName())) { if (condition == null) { condition = new Comparison(session, Comparison.EQUAL, expr, list.get(getCurrentRowNumber() - 1)[i++]); } else { condition = new ConditionAndOr(ConditionAndOr.AND, condition, new Comparison(session, Comparison.EQUAL, expr, list.get(0)[i++])); } } } } return condition; }
if (ec instanceof ExpressionColumn) { ExpressionColumn c = (ExpressionColumn) ec; found = col.equals(c.getColumnName()); if (alias != null && found) { String ca = c.getOriginalAliasName(); found = col.equals(c2.getColumnName()); if (ta == null || tb == null) { if (ta != tb) {
found = db.equalsIdentifiers(col, c.getColumnName()); if (found && tableAlias != null) { String ca = c.getOriginalTableAliasName(); String ta = exprCol.getSQL(); String tb = c2.getSQL(); String s2 = c2.getColumnName(); found = db.equalsIdentifiers(col, s2); if (!db.equalsIdentifiers(ta, tb)) {
found = db.equalsIdentifiers(col, c.getColumnName()); if (found && tableAlias != null) { String ca = c.getOriginalTableAliasName(); String ta = exprCol.getSQL(); String tb = c2.getSQL(); String s2 = c2.getColumnName(); found = db.equalsIdentifiers(col, s2); if (!db.equalsIdentifiers(ta, tb)) {
column.getName()); for (int i = 0; i < columns.length; i++) { if (expr.getColumnName().equals(columns[i].getName())) { if (condition == null) { condition = new Comparison(session, Comparison.EQUAL,
sequenceName = sql; } else { sequenceName = seq.getColumnName();
sequenceName = sql; } else { sequenceName = seq.getColumnName();
SCHEMA_NAME.get(expCol), expCol.getOriginalTableAliasName(), expCol.getColumnName());