apache-cayenne
Safety scan
A static text scan, not a guarantee. Select the badge to see what was scanned and every finding.
Check it deeper on your machine
It has changed since its scan on 11 Nov 2026.
As a Claude Code plugin, install it and then ask Claude Code:
/plugin marketplace add keithmackay/mackayi/plugin install scanskillsafety@mackayiDo a deep scan of https://github.com/apache/cayenne with scanskillsafety
Or from a terminal, clone it and run it:
git clone https://github.com/keithmackay/scanskillsafety-skill ~/.claude/skills/scanskillsafetynode ~/.claude/skills/scanskillsafety/cli.cjs --deep 'https://github.com/apache/cayenne'
It checks the exact commit: every file, its packages against OSV (api.osv.dev), how it compares with this page's scan (findsafeskills.com receives the repository's address), and, if you agree, Claude reading every file with your own Claude subscription. It never runs the code.
Badge for your README
Markdown
[](/listings/apache--cayenne)HTML
<a href="/listings/apache--cayenne"><img src="/api/listings/apache--cayenne/badge.svg" alt="findsafeskills safety rating" /></a>Install
Install instructions from the README
As written by the repo's author. findsafeskills has not verified these steps.
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
<dependencies>
<dependency>
<groupId>org.apache.cayenne</groupId>
<artifactId>cayenne</artifactId>
<version>5.0-M3</version>
</dependency>
</dependencies>Gradle
implementation 'org.apache.cayenne:cayenne:5.0-M3'
Create Cayenne Runtime
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
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
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
long count = ObjectSelect.query(Artist.class)
.where(Artist.PAINTING_ARRAY.dot(Painting.PAINTING_TITLE).like("painting%").exists())
.selectCount(context);Aggregate Functions
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
// 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);
What was scanned
The files the safety scan read, as written by the repository's author and shown as plain text. Lines with a finding are marked.
.claude-plugin/marketplace.json · Manifest · 54 lines
View this file on GitHub (read at the repository's current version: the scan did not record which commit it read)
This file has changed since it was scanned, so this is not exactly the text that was scanned, and no line is marked. The findings are listed with the safety scan above.
- {
- "name": "apache-cayenne",
- "metadata": {
- "description": "Apache Cayenne ORM Claude Code plugins"
- },
- "owner": {
- "name": "Apache Cayenne"
- },
- "plugins": [
- {
- "name": "apache-cayenne-6",
- "description": "Apache Cayenne 6.0 ORM — design DataMaps, reverse-engineer schemas, generate classes, write runtime code.",
- "author": {
- "name": "Apache Cayenne"
- },
- "source": {
- "source": "git-subdir",
- "url": "https://github.com/apache/cayenne.git",
- "path": "ai-plugin",
- "ref": "master"
- },
- "category": "development",
- "tags": [
- "java",
- "orm",
- "cayenne",
- "database"
- ]
- },
- {
- "name": "apache-cayenne-5",
- "description": "Apache Cayenne 5.0 ORM — the same skills for projects on the 5.0 release line.",
- "author": {
- "name": "Apache Cayenne"
- },
- "source": {
- "source": "git-subdir",
- "url": "https://github.com/apache/cayenne.git",
- "path": "ai-plugin",
- "ref": "STABLE-5.0"
- },
- "category": "development",
- "tags": [
- "java",
- "orm",
- "cayenne",
- "database"
- ]
- }
- ],
- "renames": {
- "apache-cayenne": "apache-cayenne-5"
- }
- }
README.md · README · 170 lines
View this file on GitHub (read at the repository's current version: the scan did not record which commit it read)
This file has changed since it was scanned, so this is not exactly the text that was scanned, and no line is marked. The findings are listed with the safety scan above.
- <!--
- Licensed to the Apache Software Foundation (ASF) under one
- or more contributor license agreements. See the NOTICE file
- distributed with this work for additional information
- regarding copyright ownership. The ASF licenses this file
- to you under the Apache License, Version 2.0 (the
- "License"); you may not use this file except in compliance
- with the License. You may obtain a copy of the License at
- https://www.apache.org/licenses/LICENSE-2.0
- Unless required by applicable law or agreed to in writing,
- software distributed under the License is distributed on an
- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
- KIND, either express or implied. See the License for the
- specific language governing permissions and limitations
- under the License.
- -->
- # Apache Cayenne
- [](https://cayenne.apache.org/download/)
- [](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-RC1</version>
- </dependency>
- </dependencies>
- ```
- Gradle
- ```gradle
- implementation 'org.apache.cayenne:cayenne:5.0-RC1'
- ```
- #### 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)
Ratings and comments
Sign in to rate this skill.
Sign inFree to use. If it’s helped, pass it on.