PillArmy
Official@pillarmy
Offers a fluent Java Criteria framework for type-safe, complex SQL generation across MySQL and PostgreSQL database environments.
Agent Skills by PillArmy
Showing 47 vetted skills indexed across 1 GitHub repositories.
PillArmybatch-domain-update-guide
Execute batch updates for domain objects with nested relationships in a database.
PillArmySQLs.subQuery() method chain
Explain the SQLs.subQuery() method chain in the Army Criteria API.
PillArmymaven-javadoc-skip
Configure maven-javadoc-plugin to skip Javadoc generation for specific modules.
PillArmymysql-single-update
Construct and execute MySQL singleUpdate statements using the Army framework.
PillArmyTypedField-complete-guide
Document TypedField methods, parameter binding, and SQL constants in Army Criteria API.
PillArmySQLs.field
Reference SQL fields using alias-based qualifications in complex queries.
PillArmySQLs.singleInsert() 方法链
Explain the SQLs.singleInsert() method chain in the Army Criteria API.
PillArmyPostgres-query-method-chain
Explain the PostgreSQL query method chain from Postgres.query() to asQuery().
PillArmymysql-values-stmt
Construct MySQL VALUES statements through a fluent API.
PillArmypostgres-subValues-method-chain
Construct PostgreSQL subqueries using the Postgres.subValues() method chain.
PillArmybatch-domain-delete-guide
Document the SQLs.batchDomainDelete() method for batch domain delete operations.
PillArmymysql-loaddata-stmt
Generate and execute MySQL LOAD DATA statements with method chains.
PillArmySQLs.scalarSubQuery() method chain
Construct subqueries using the SQLs.scalarSubQuery() method chain in the Army Criteria API.
PillArmypostgres-single-delete
Construct PostgreSQL single-table DELETE statements with CTEs, JOINs, and WHERE conditions.
PillArmyPostgres.singleUpdate() method chain
Document PostgreSQL UPDATE statement construction via the Postgres.singleUpdate() method chain.
PillArmyarmy-sql-generation
Generate MySQL and PostgreSQL SQL from Army Criteria API examples.
PillArmySQLs.literal
Integrate SQL literal expression methods into the Army Criteria API.
PillArmySQLs.query() method chain
Explain the SQLs.query() method chain for building SELECT queries in the Army SQL framework.
PillArmyarmy-spring-ai-chat-memory
Integrate Army with Spring AI for chat memory persistence.
PillArmySQLs.singleDelete() 方法链
Construct DELETE SQL statements using the Army Criteria API method chain.
PillArmyMySQLs-multiUpdate-method-chain
Build complex MySQL UPDATE statements with method chaining and joins.
PillArmyMySQLs.query() method chain
Construct complex MySQL SELECT queries using the Army Criteria API method chain.
PillArmyarmy-batch-single-update
Batch update multiple database rows using the Army SQL framework.
PillArmypostgres-declarestmt-guide
Explain the Postgres.declareStmt() method chain for PostgreSQL cursor declarations.
Frequently Asked Questions About PillArmy
FAQPage SchemaWhat specific database operations does the Army framework support?▼
The framework enables fluent construction of complex SELECT, INSERT, UPDATE, and DELETE statements. It supports advanced relational operations including CTEs, multi-table joins, scalar subqueries, and batch processing for both MySQL and PostgreSQL dialects.
Which developers benefit from using these persistence methods?▼
Java backend engineers working with Spring Boot who require type-safe, programmatic SQL generation benefit most. It is designed for developers seeking to replace raw string-based queries with a structured, fluent Criteria API for improved maintainability and security.
What are the primary dependencies for implementing this framework?▼
Implementation requires a Java environment with the Army Criteria library integrated into the project build. It is designed to work alongside Spring Boot for session management and transaction handling, utilizing standard JDBC drivers for MySQL and PostgreSQL connectivity.