apache/cayenne

Última actividad de origen registrada: 30 de octubre de 2026 a las 15:48

Catálogo de SkillsMP actualizado: 2 de noviembre de 2026 a las 18:02

skills recopiladas: 8

Estrellas en GitHub: 347
Forks en GitHub: 138

Instalar con un asistente de IA

Copia este prompt en el asistente de IA que estés usando.

Follow https://skillsmp.com/skill-install/prompt.md to install Agent Skills from https://github.com/apache/cayenne.

README del repositorio

Archivo de origen del README: README.md

Leer el README original

Mostrar README completo

# Apache Cayenne [![Maven Central](https://img.shields.io/maven-central/v/org.apache.cayenne/cayenne/5.0.svg)](https://cayenne.apache.org/download/) [![Build Status](https://github.com/apache/cayenne/actions/workflows/verify-deploy-on-push.yml/badge.svg?branch=master)](https://github.com/apache/cayenne/actions/workflows/verify-deploy-on-push.yml) [Apache Cayenne](https://cayenne.apache.org) is an open source persistence framework for Java. With a wealth of unique and powerful features, Cayenne can address a wide range of persistence needs. Cayenne seamlessly binds one or more database schemas to Java objects, managing atomic commits and rollbacks, SQL generation, joins, sequences, and more. Cayenne supports database reverse engineering and generation, as well as templated class generation. All of these functions can be controlled through the GUI CayenneModeler app. An entire database schema can be mapped directly to Java objects within minutes, all from the comfort of the GUI-based CayenneModeler. Cayenne supports numerous other features, including caching, an object query syntax, relationship pre-fetching, on-demand object and relationship faulting, object inheritance, database auto-detection, and generic persistent objects. Cayenne can scale up or down to virtually any project size. ## Quick Links * [Getting Started](https://cayenne.apache.org/docs/5.0/getting-started-guide/) * [Documentation](https://cayenne.apache.org/docs/5.0/cayenne-guide/) * [Upgrading from Older Cayenne](https://github.com/apache/cayenne/blob/master/UPGRADE.md) * [Bug/Feature Tracker](https://issues.apache.org/jira/browse/CAY) ## Quick Start ### Create XML Mapping Downloaded Cayenne Modeler from https://cayenne.apache.org/download/, start it and create a Cayenne project. ### Include Cayenne in a Project Maven ```xml <dependencies> <dependency> <groupId>org.apache.cayenne</groupId> <artifactId>cayenne</artifactId> <version>5.0-M3</version> </dependency> </dependencies> ``` Gradle ```gradle implementation 'org.apache.cayenne:cayenne:5.0-M3' ``` #### Create Cayenne Runtime ```java CayenneRuntime cayenneRuntime = CayenneRuntime.of() .addConfig("cayenne-demo.xml") .defaultDataNode(CayenneDataSource .of("jdbc:mysql://localhost:3306/cayenne_demo") .userName("username") .password("password") .build()) .build(); ``` ### Create New Objects ```java ObjectContext context = cayenneRuntime.newContext(); Artist picasso = context.newObject(Artist.class); picasso.setName("Pablo Picasso"); picasso.setDateOfBirth(LocalDate.of(1881, 10, 25)); Gallery metropolitan = context.newObject(Gallery.class); metropolitan.setName("Metropolitan Museum of Art"); Painting girl = context.newObject(Painting.class); girl.setName("Girl Reading at a Table"); Painting stein = context.newObject(Painting.class); stein.setName("Gertrude Stein"); picasso.addToPaintings(girl); picasso.addToPaintings(stein); girl.setGallery(metropolitan); stein.setGallery(metropolitan); context.commitChanges(); ``` ### Queries #### Select Objects ```java List<Painting> paintings = ObjectSelect.query(Painting.class) .where(Painting.ARTIST.dot(Artist.DATE_OF_BIRTH).year().lt(1900)) .prefetch(Painting.ARTIST.joint()) .select(context); ``` #### Exists Subqueries ```java long count = ObjectSelect.query(Artist.class) .where(Artist.PAINTING_ARRAY.dot(Painting.PAINTING_TITLE).like("painting%").exists()) .selectCount(context); ``` #### Aggregate Functions ```java List<Object[]> artistAndPaintingCount = ObjectSelect .columnQuery(Artist.class, Artist.SELF, Artist.PAINTING_ARRAY.count()) .where(Artist.ARTIST_NAME.like("a%")) .having(Artist.PAINTING_ARRAY.count().lt(5L)) .orderBy(Artist.PAINTING_ARRAY.count().desc(), Artist.ARTIST_NAME.asc()) .select(context); for(Object[] next : artistAndPaintingCount) { Artist artist = (Artist)next[0]; long paintingsCount = (Long)next[1]; System.out.println(artist.getArtistName() + " has " + paintingsCount + " painting(s)"); } ``` #### Raw SQL Queries ```java // Selecting objects List<Painting> paintings = SQLSelect .query(Painting.class, "SELECT * FROM PAINTING WHERE PAINTING_TITLE LIKE #bind($title)") .param("title", "painting%") .upperColumnNames() .localCache() .limit(100) .select(context); // Selecting scalar values List<String> paintingNames = SQLSelect .scalarQuery("SELECT PAINTING_TITLE FROM PAINTING WHERE ESTIMATED_PRICE > #bind($price)", String.class) .param("price", 100000) .select(context); // Insert values int inserted = SQLExec .query("INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (#bind($id), #bind($name))") .paramsArray(55, "Picasso") .update(context); ``` ## Collaboration and Support * [Mailing lists](https://cayenne.apache.org/mailing-lists.html) * [Support](https://cayenne.apache.org/support.html) * [Contributing](https://cayenne.apache.org/how-can-i-help.html)

Cargando el README del repositorio…

Skills en este repositorio

Desarrolladores de software

1 categorías ocupacionales · 63% clasificado

skill

ocupación

descripción

actualizado

cayenne-query

sin clasificar

Use this skill whenever the user wants to write or modify a Cayenne query — fetching entities by criteria, joining, prefetching to avoid N+1, ordering, paginating, aggregating, or running raw SQL through Cayenne. Trigger on phrases like 'query for X', 'fetch…