/** * Returns SQLTemplate text for current selection. */ String getSQLTemplate(String key) { if (key == null) { return null; } SQLTemplateDescriptor query = getQuery(); if (query == null) { return null; } return (key.equals(DEFAULT_LABEL)) ? query.getSql() : query .getAdapterSql().get(key); }
void validateDefaultSQL(SQLTemplateDescriptor query, ValidationResult validationResult) { if (Util.isEmptyString(query.getSql())) { // see if there is at least one adapter-specific template... for (Map.Entry<String, String> entry : query.getAdapterSql().entrySet()) { if (!Util.isEmptyString(entry.getValue())) { return; } } addFailure( validationResult, query, "SQLTemplate query '%s' has no default SQL template", query.getName()); } }
if (!Util.nullSafeEquals(text, query.getSql())) { query.setSql(text); mediator.fireQueryEvent(new QueryEvent(this, query));
@Override public SQLTemplate buildQuery() { SQLTemplate template = new SQLTemplate(); if (root != null) { template.setRoot(root); } template.setName(name); template.setDataMap(dataMap); template.initWithProperties(this.getProperties()); // init SQL template.setDefaultTemplate(this.getSql()); Map<String, String> adapterSql = this.getAdapterSql(); if (adapterSql != null) { for (Map.Entry<String, String> entry : adapterSql.entrySet()) { String key = entry.getKey(); String value = entry.getValue(); if (key != null && value != null) { template.setTemplate(key, value); } } } return template; }
/** * Shows selected script in the editor. */ void displayScript() { SQLTemplateDescriptor query = getQuery(); if (query == null) { return; } String key = scripts.getSelectedValue(); if (key == null) { return; } final String text = (key.equals(DEFAULT_LABEL)) ? query.getSql() : query .getAdapterSql().get(key); for (final JCayenneTextPane textPane : panes) { if (key.equals(textPane.getName())) { textPane.setDocumentTextDirect(text); textPane.getScrollPane().setVisible(true); textPane.getPane().requestFocusInWindow(); } else { textPane.getScrollPane().setVisible(false); } } }