Create secure SQL parameter expressions for the Army framework.
npx skills add https://github.com/PillArmy/army --skill army-sql-param
Please help me install this Agent Skill. Skill: army-sql-param Source: https://github.com/PillArmy/army/tree/main/.trae/skills/army-sql-param Command: npx skills add https://github.com/PillArmy/army --skill army-sql-param
This Skill simplifies the process of building secure SQL parameters within the Army framework, mitigating the risk of SQL injection attacks.
parameter(), param(), namedParam(), rowParam(), and namedRowParam() to handle different types of SQL query parameters.Utilize the 'army-sql-param' skill to build a SQL parameter for the user's age using 'param()'.
High-intent search queries and answers about installing and using this skill.
To prevent SQL injection in the Army framework, use secure SQL parameter expressions. This Skill provides parameter methods like param() and namedParam() to construct queries safely.
The difference lies in their query construction approach. parameter() and param() create standard SQL parameters, while namedParam() and namedRowParam() generate named parameters for complex Army framework queries.
Yes, you can use Java object types when creating secure SQL parameters. The Army framework parameter construction supports Java object types for query integration.
To integrate multiple SQL parameters, use the predefined methods like rowParam() or param(). These methods allow you to define and safely integrate several parameters into your Army framework query.
Use namedRowParam() when your SQL query requires named row parameters. It differs from standard parameter methods by supporting named structures for complex row data integration in the Army framework.
PillArmyIntegrate SQL literal expression methods into the Army Criteria API.
igbuendDetect SQL string concatenation and recommend parameterized queries.
PillArmyConstruct and execute PostgreSQL batch UPDATE statements with CTEs, JOINs, and RETURNING.
PillArmyConstruct DELETE SQL statements using the Army Criteria API method chain.