Execute qualquer Skill no Manus
com um clique

Execute qualquer Skill no Manus com um clique

Começar

ewa-sql-params

Estrelas3

Forks0

Atualizado27 de junho de 2026 às 00:40

Extract SQL parameters from EWA XML config (UserConfig ActionSet/SqlSet) for API documentation or analysis

Instalação

Instalar com Codex ou Claude Copie este prompt, cole no Codex, Claude ou outro assistente e deixe que ele revise a página da skill e instale para você.

Executar no Manus

Fonte

gdx1231

gdx1231/emp-script

Abrir repositório GitHub Ver repositórios do creator

Download

Executar no Manus

Ocupações relacionadasSOC

Baseado na classificação ocupacional SOC

Desenvolvedores de softwareInformática e Matemática·SOC 15-1252

SKILL.md

readonly

name	ewa-sql-params
description	Extract SQL parameters from EWA XML config (UserConfig ActionSet/SqlSet) for API documentation or analysis
source	auto-skill
extracted_at	2026-06-26T08:37:53.918Z

Extract SQL Parameters from EWA XML Configuration

EWA XML Config Structure

The EWA framework stores SQL in XML configuration files accessed via UserConfig:

EasyWebTemplate
  → Action (stored in UserActionItem, a UserXItem)
       → ActionSet (each has Type: OnPageLoad, OnFrameDelete, OnPagePost, etc.)
            → CallSet (CallType="SqlSet", CallName="OnFrameDelete SQL")
       → SqlSet (contains actual SQL statements)
            → Set (Name="OnFrameDelete SQL", SqlType="update")
                 → Sql (CDATA with SQL text containing @paramName placeholders)

Accessing SQL from UserConfig

import com.gdxsoft.easyweb.script.userConfig.UserConfig;
import com.gdxsoft.easyweb.script.userConfig.UserXItem;
import com.gdxsoft.easyweb.script.userConfig.UserXItemValue;
import com.gdxsoft.easyweb.script.userConfig.UserXItemValues;

// 1. Load config by xmlName and itemName
UserConfig uc = UserConfig.instance(xmlName, itemName, null);

// 2. Get the Action item (UserXItem, not UserXItems)
UserXItem actionItem = uc.getUserActionItem();

// 3. Access SqlSet child items
if (actionItem.testName("SqlSet")) {
    UserXItemValues sqlSets = actionItem.getItem("SqlSet");
    for (int i = 0; i < sqlSets.count(); i++) {
        UserXItemValue sqlItem = sqlSets.getItem(i);
        if (sqlItem.testName("Sql")) {
            String sql = sqlItem.getItem("Sql"); // actual SQL text
            String sqlType = sqlItem.getItem("SqlType"); // "query", "update", "procedure"
        }
    }
}

Extracting @parameter Placeholders

EWA uses @paramName syntax in SQL (replaced with JDBC ? at runtime). Extract with regex:

private static List<String> extractSqlParameters(String sql) {
    List<String> params = new ArrayList<>();
    Pattern pattern = Pattern.compile("@([A-Za-z_][A-Za-z0-9_]*)");
    Matcher matcher = pattern.matcher(sql);
    while (matcher.find()) {
        String param = matcher.group(1);
        if (!params.contains(param)) {
            params.add(param);
        }
    }
    return params;
}

Key Classes

Class	Package	Purpose
`UserConfig`	`...script.userConfig`	XML config loader; `instance(xmlName, itemName, null)`
`UserXItem`	`...script.userConfig`	Action item container; `getUserActionItem()` returns this
`UserXItemValues`	`...script.userConfig`	Collection of `UserXItemValue` (from `SetBase<T>`)
`UserXItemValue`	`...script.userConfig`	Single SQL item; `getItem("Sql")` returns SQL text
`UserXItems`	`...script.userConfig`	Collection of `UserXItem` (field definitions)

Note: UserXItem (field definitions) vs UserXItemValue (SqlSet items) — different classes with similar names.

Common Action Types

OnPageLoad — page load query
OnPagePost — form POST / insert
OnFrameDelete — DELETE operation (often soft-delete via UPDATE SET status='DEL')
OnFrameRestore — restore from soft-delete (UPDATE SET status='USED')

Mais deste repositório

mesmo repositório

restful-vs-frame

gdx1231/emp-script

EWA RESTful handler 开发/调试时，与 Frame 路径 (ServletUpload/ActionFrame) 对照确保参数映射和 SQL 执行一致性

2026-07-153

sqlite-dataconnection-test

gdx1231/emp-script

How to write DataConnection tests using SQLite — driver version, pool setup (HikariCP/Druid), path expressions, concurrency, and API patterns

2026-07-133

ewa-api

gdx1231/emp-script

Use when: 调用 EWA Servlet API、查询数据库表结构与数据、读取或修改 EWA XML 配置项、生成业务 XML（自动创建容器）、查看配置存储路径（showScriptPaths）、直接读取 XML 文件（getXmlFile）、校验 SQL 语法（validateSql）、需要脚本化执行 login/getTables/getTable/getTableData/getConfItem/previewBusinessXml/createBusinessXml/showScriptPaths/getXmlFile/validateSql。

2026-07-083

ewa-stored-procedure

gdx1231/emp-script

Use when: 通过 EWA API 查看存储过程、函数或触发器的完整定义文本。INFORMATION_SCHEMA.ROUTINES 会截断，需用 sys.sql_modules 获取完整内容。

2026-07-073

ewa-form

gdx1231/emp-script

Use when: 编写 EWA 表单前端 JS 代码、表单提交与验证、表单与列表联动、对话框中表单操作、动态字段控制、合并单元格、分组向导。按任务组织，含完整代码示例。

2026-07-033

ewa-listframe

gdx1231/emp-script

Use when: 编写 EWA ListFrame 列表前端 JS 代码、行数据操作、选中行、翻页排序、检索过滤、展开行详情、动态列、底部汇总、行内编辑。按任务组织，含完整代码示例。

2026-07-033

Extract SQL Parameters from EWA XML Configuration

EWA XML Config Structure

The EWA framework stores SQL in XML configuration files accessed via UserConfig:

EasyWebTemplate → Action (stored in UserActionItem, a UserXItem) → ActionSet (each has Type: OnPageLoad, OnFrameDelete, OnPagePost, etc.) → CallSet (CallType="SqlSet", CallName="OnFrameDelete SQL") → SqlSet (contains actual SQL statements) → Set (Name="OnFrameDelete SQL", SqlType="update") → Sql (CDATA with SQL text containing @paramName placeholders)

Accessing SQL from UserConfig

import com.gdxsoft.easyweb.script.userConfig.UserConfig; import com.gdxsoft.easyweb.script.userConfig.UserXItem; import com.gdxsoft.easyweb.script.userConfig.UserXItemValue; import com.gdxsoft.easyweb.script.userConfig.UserXItemValues; // 1. Load config by xmlName and itemName UserConfig uc = UserConfig.instance(xmlName, itemName, null); // 2. Get the Action item (UserXItem, not UserXItems) UserXItem actionItem = uc.getUserActionItem(); // 3. Access SqlSet child items if (actionItem.testName("SqlSet")) { UserXItemValues sqlSets = actionItem.getItem("SqlSet"); for (int i = 0; i < sqlSets.count(); i++) { UserXItemValue sqlItem = sqlSets.getItem(i); if (sqlItem.testName("Sql")) { String sql = sqlItem.getItem("Sql"); // actual SQL text String sqlType = sqlItem.getItem("SqlType"); // "query", "update", "procedure" } } }

Extracting @parameter Placeholders

EWA uses @paramName syntax in SQL (replaced with JDBC ? at runtime). Extract with regex:

private static List<String> extractSqlParameters(String sql) { List<String> params = new ArrayList<>(); Pattern pattern = Pattern.compile("@([A-Za-z_][A-Za-z0-9_]*)"); Matcher matcher = pattern.matcher(sql); while (matcher.find()) { String param = matcher.group(1); if (!params.contains(param)) { params.add(param); } } return params; }

Key Classes

Class

Package

Purpose

UserConfig

...script.userConfig

XML config loader; instance(xmlName, itemName, null)

UserXItem

...script.userConfig

Action item container; getUserActionItem() returns this

UserXItemValues

...script.userConfig

Collection of UserXItemValue (from SetBase<T>)

UserXItemValue

...script.userConfig

Single SQL item; getItem("Sql") returns SQL text

UserXItems

...script.userConfig

Collection of UserXItem (field definitions)

Note: UserXItem (field definitions) vs UserXItemValue (SqlSet items) — different classes with similar names.

Common Action Types

OnPageLoad — page load query

OnPagePost — form POST / insert

OnFrameDelete — DELETE operation (often soft-delete via UPDATE SET status='DEL')

OnFrameRestore — restore from soft-delete (UPDATE SET status='USED')