You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@empire-db.apache.org by do...@apache.org on 2018/03/10 17:07:11 UTC
empire-db git commit: EMPIREDB-272 added new selectQualfied function
to DBCommand
Repository: empire-db
Updated Branches:
refs/heads/master 1c06bd5c2 -> 805278fa4
EMPIREDB-272
added new selectQualfied function to DBCommand
Project: http://git-wip-us.apache.org/repos/asf/empire-db/repo
Commit: http://git-wip-us.apache.org/repos/asf/empire-db/commit/805278fa
Tree: http://git-wip-us.apache.org/repos/asf/empire-db/tree/805278fa
Diff: http://git-wip-us.apache.org/repos/asf/empire-db/diff/805278fa
Branch: refs/heads/master
Commit: 805278fa4e05ee3ff010d8d68c1d1c5dde6b40a4
Parents: 1c06bd5
Author: Rainer Döbele <do...@apache.org>
Authored: Sat Mar 10 18:08:03 2018 +0100
Committer: Rainer Döbele <do...@apache.org>
Committed: Sat Mar 10 18:08:03 2018 +0100
----------------------------------------------------------------------
.../java/org/apache/empire/db/DBColumn.java | 2 ++
.../java/org/apache/empire/db/DBCommand.java | 26 ++++++++++++++++++++
2 files changed, 28 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/empire-db/blob/805278fa/empire-db/src/main/java/org/apache/empire/db/DBColumn.java
----------------------------------------------------------------------
diff --git a/empire-db/src/main/java/org/apache/empire/db/DBColumn.java b/empire-db/src/main/java/org/apache/empire/db/DBColumn.java
index a359980..aae0b7e 100644
--- a/empire-db/src/main/java/org/apache/empire/db/DBColumn.java
+++ b/empire-db/src/main/java/org/apache/empire/db/DBColumn.java
@@ -370,6 +370,8 @@ public abstract class DBColumn extends DBColumnExpr
public String qualifiedAlias()
{
String rsName = getRowSet().getName();
+ if (StringUtils.isEmpty(rsName))
+ return getName();
return rsName + "_" + getName();
}
http://git-wip-us.apache.org/repos/asf/empire-db/blob/805278fa/empire-db/src/main/java/org/apache/empire/db/DBCommand.java
----------------------------------------------------------------------
diff --git a/empire-db/src/main/java/org/apache/empire/db/DBCommand.java b/empire-db/src/main/java/org/apache/empire/db/DBCommand.java
index feb13d6..14f32b3 100644
--- a/empire-db/src/main/java/org/apache/empire/db/DBCommand.java
+++ b/empire-db/src/main/java/org/apache/empire/db/DBCommand.java
@@ -319,6 +319,32 @@ public abstract class DBCommand extends DBCommandExpr
select(expr);
}
}
+
+ /**
+ * Adds a list of columns with their qualified name to the select phrase of an sql statement.
+ *
+ * @param exprs one or more columns to select
+ */
+ public void selectQualified(DBColumn... columns)
+ {
+ for (DBColumn col : columns)
+ {
+ select(col.qualified());
+ }
+ }
+
+ /**
+ * Adds a collection of columns to the select phrase of an sql statement.
+ *
+ * @param columns the column expressions to add
+ */
+ public final void selectQualified(Collection<? extends DBColumn> columns)
+ {
+ for (DBColumn col : columns)
+ {
+ select(col.qualified());
+ }
+ }
/**
* returns true if prepared statements are enabled for this database