How does it handle CDI in Lutece?

The skill includes specific patterns for CDI lookup within the Home layer, allowing for clean dependency injection and service management within the Lutece environment.

Does this skill support modern Java features?

Yes, it specifically enforces the use of try-with-resources for the DAOUtil lifecycle to ensure proper resource management and prevent database connection leaks.

Can I use this for complex SQL queries beyond CRUD?

Yes, the skill provides naming conventions and implementation patterns for custom finders (SQL_QUERY_SELECT_BY_*) and count queries.

What is the primary purpose of the Lutece DAO skill?

It provides a standardized framework for creating and managing data access objects and static Home facades specifically for Lutece 8 applications, ensuring consistency with core framework patterns.

Why should I use this skill instead of manual DAO coding?

It ensures architectural consistency across the Lutece ecosystem by referencing core Lutece references, reducing technical debt and ensuring compatibility with Lutece 8 standards.

Lutece 8 DAO & Home Patterns

Name: Lutece 8 DAO & Home Patterns
Author: vanhemsj

byvanhemsj

•

データベース管理

Implements standardized DAO and Home layer patterns for Lutece 8 development using best practices for data persistence.

概要

This skill provides specialized guidance for developing database access layers within the Lutece 8 framework. It enforces specific architectural patterns including the DAOUtil lifecycle with try-with-resources, standardized SQL constant naming, and the implementation of static Home facades using CDI lookups. By referencing core Lutece patterns and plugin examples, it ensures consistency across entity persistence, collection handling, and interface conventions, making it essential for building robust and maintainable Lutece business modules.

主な機能

Implementation of static Home facades with CDI integration
Interface-driven DAO design patterns for clean architectural abstraction
Predefined naming conventions for SQL query constants (CRUD and custom finders)
Support for Lutece-specific collection types like ReferenceList for UI dropdowns
1 GitHub stars
Standardized DAOUtil lifecycle management using try-with-resources

ユースケース

Creating new database entities and their corresponding persistence layers in Lutece plugins
Implementing search and selection logic for UI components using ReferenceLists and custom finders
Refactoring legacy Lutece DAO code to follow Lutece 8 standards and CDI patterns

概要

主な機能

Implementation of static Home facades with CDI integration
Interface-driven DAO design patterns for clean architectural abstraction
Predefined naming conventions for SQL query constants (CRUD and custom finders)
Support for Lutece-specific collection types like ReferenceList for UI dropdowns
1 GitHub stars
Standardized DAOUtil lifecycle management using try-with-resources

ユースケース

Creating new database entities and their corresponding persistence layers in Lutece plugins
Implementing search and selection logic for UI components using ReferenceLists and custom finders
Refactoring legacy Lutece DAO code to follow Lutece 8 standards and CDI patterns