skills.rest
PillArmy
PillArmyOFFICIAL
Explore all skills by this author →
GitHub

SQLs.singleDelete() 方法链

Construct DELETE SQL statements using the Army Criteria API method chain.

Updated Mar 3, 2026
Search Tags:#SQL#database#Army Criteria API#method chain#DELETE statement
One-click install
npx skills add https://github.com/PillArmy/army --skill sqls-singledelete
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: SQLs.singleDelete() 方法链
Source: https://github.com/PillArmy/army/tree/main/.trae/skills/SQLs-single-delete-method-chain
Command: npx skills add https://github.com/PillArmy/army --skill sqls-singledelete

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill unit helps developers understand and apply the Army Criteria API's SQLs.singleDelete() method chain for constructing full DELETE statements.

Core Features & Use Cases

  • DELETE Statement Construction: Detailed knowledge of the entire SQLs.singleDelete() method chain from start to finish, covering all stages including WITH, DELETE FROM, WHERE, and AND.
  • Source Code Reference: Based on actual source code and interface definitions from key files such as Statement.java, StandardDelete.java, StandardDeletes.java, SingleDeleteStatement.java, and StandardDeleteUnitTests.java.
  • Use Case: Useful for developers looking to manually construct and execute DELETE statements programmatically in Army framework.

Quick Start

Run the following command to understand the complete process of constructing a DELETE statement using SQLs.singleDelete():

army-skills run .trae/skills/SQLs-single-delete-method-chain/SKILL.md

Frequently Asked Questions about SQLs.singleDelete() 方法链

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I construct a DELETE statement using the Army Criteria API method chain?▼

To construct a DELETE statement in the Army framework, use the SQLs.singleDelete() method chain to sequentially build clauses including WITH, DELETE FROM, WHERE, and AND for programmatic execution.

What source code interfaces define the Army framework single delete statement?▼

The single delete statement is defined across Statement.java, StandardDelete.java, StandardDeletes.java, and SingleDeleteStatement.java, providing the interface definitions for the Army Criteria API DELETE method chain.

How do I add WHERE and AND conditions to an Army DELETE statement?▼

You append WHERE and AND conditions by chaining the corresponding methods onto the SQLs.singleDelete() builder, allowing you to filter specific rows for deletion within the Army framework.

Does the Army Criteria API support the WITH clause in DELETE statements?▼

Yes, the Army Criteria API supports the WITH clause as part of the SQLs.singleDelete() method chain, enabling you to define common table expressions before the DELETE FROM operation.

How can I test the Army Criteria API DELETE statement construction?▼

You can verify DELETE statement construction by referencing StandardDeleteUnitTests.java, which demonstrates how to test the SQLs.singleDelete() method chain against the Army framework.

When should I use SQLs.singleDelete() instead of other Army DELETE methods?▼

Use SQLs.singleDelete() when you need to manually construct and execute a single row DELETE statement programmatically, leveraging the full Army Criteria API method chain for precise control.

Related Skills

Explore More Software Engineering Skills→
PillArmyPillArmy

SQLs.singleUpdate() method chain

Explain the SQLs.singleUpdate() method chain for constructing UPDATE statements.

Official
Advanced
jhd3197jhd3197
666

db-inspect

Inspect ServerKit SQLite schemas, row counts, and run SQL queries.

Community
Intermediate
PillArmyPillArmy

SQLs-domainUpdate-method-chain

Guide constructing UPDATE SQL statements via the Army Criteria API's domainUpdate() method chain.

Official
Advanced
PillArmyPillArmy

SQLs-batch-single-delete-method-chain

Construct batch DELETE SQL statements using the SQLs.batchSingleDelete() method chain.

Official
Advanced