Revize 7638be72

re #7886 Assembly validator completed (validating sql query, parameter name in select and parameter location) + displaying temp error message.
Added title for edit / add assembly forms.
Added toString method for all domains.

src/main/java/vldc/aswi/database/DatabaseInterface.java

@@ -31 +31 @@
         this.jdbcTemplate = jdbcTemplate;
     }
 
+    /**
+     * Get list of table column names from SQL query.
+     * @param sqlQuery - SQL query.
+     * @return List of table column names. If null is returned, then it means that SQL query is not valid.
+     */
+    public List<String> getNameOfColumnsFromQuery(String sqlQuery) {
+        try
+        {
+            // Try extract columns from database using SQL query.
+            return jdbcTemplate.query(
+                sqlQuery,
+                new ResultSetExtractor<List<String>>() {
+                    @Override
+                    public List<String> extractData(ResultSet resultSet) throws SQLException {
+                        List<String> tableColumnNames = new ArrayList<>();
+
+                        ResultSetMetaData resultSetMetaData = resultSet.getMetaData();
+                        int columnCount = resultSetMetaData.getColumnCount();
+
+                        // The column count starts from 1.
+                        for (int i = 1; i <= columnCount; i++ ) {
+                            String columnName = resultSetMetaData.getColumnName(i);
+                            tableColumnNames.add(columnName);
+                        }
+
+                        return tableColumnNames;
+                    }
+                }
+            );
+
+        }
+        catch (DataAccessException e)
+        {
+            // If SQL query is not valid, then JdbcTemplate returned DataAccess exception.
+            return null;
+        }
+    }
+
     /**
      * Validate given SQLQuery.
      * @param sqlQuery - Tested SQL Query.
      * @return true if SQL query is valid, false if not.
      */
     public boolean validateSQLQuery(String sqlQuery) {
+
         try
         {
+            // Try validate SQL query.
             jdbcTemplate.execute("EXPLAIN PLAN FOR " + sqlQuery);
             return true;
         }
         catch (DataAccessException e)
         {
+            // If SQL query is not valid, then JdbcTemplate returned DataAccess exception.
             return false;
         }
     }
@@ -70 +111 @@
                             tableColumnsList.add(new TableColumn(columnName));
                         }
 
+                        // Add values from row to every column.
                         while(resultSet.next()) {
                             for (int i = 1; i <= columnCount; i++) {
                                 tableColumnsList.get(i - 1).addValue(resultSet.getString(i));
@@ -78 +120 @@
 
                         Map<String, TableColumn> tableColumnMap = new HashMap<>();
 
+                        // Create map, where key is tablecolumn name.
                         for (TableColumn column : tableColumnsList) {
                             tableColumnMap.put(column.getName(), column);
                         }