List<Cat>all =orm().select(CAT)                .where(CAT.type.eq(CatType.INDOOR))                .join(PERSON).on(CAT.personId,PERSON.id)                .where(PERSON.emailAddress.eq(person.getEmailAddress()))                .orderBy(CAT.name,CAT.age.desc())                .list();

Getting HeliORM

The core library

  <dependency>    <groupId>com.heliorm</groupId>     <artifactId>core</artifactId>     <version>0.91</version>  </dependency>

Annotations to annotate your POJOs

  <dependency>    <groupId>com.heliorm</groupId>     <artifactId>annotation</artifactId>     <version>0.9</version>  </dependency>

The MySQL driver

  <dependency>    <groupId>com.heliorm</groupId>     <artifactId>mysql</artifactId>     <version>0.9</version>  </dependency>

Quick CRUD examples

@PojopublicclassDog {@PrimaryKey(autoIncrement =true)privateLongid;@ForeignKey(pojo =Person.class)privateLongpersonId;@Column(length =32)privateStringname;privateintage;}

Create

Dogdog =newDog();dog.setName("Fido");// The classics are the bestdog.setAge(3);dog.setPersonId(1);// code ommitted to set values in dogdog =orm.create(dog);

Read

Dogdog =orm.select(DOG)   .where(DOG.name.eq("Fido"))   .one();

Update

// assume variable dog references a Dog object is loadeddog.setName("Rex");// I've renamed a dog IRL oncedog =orm.update(dog);

Delete

// assume variable dog references a Dog object is loadedorm.delete(dog);// Rip Rex

Retrieving data as lists, streams, singletons or optionals

Retrieve a list of data

List<Dogs>dogs =orm.select(DOG).list();

Get a single object

Dogdog =orm.select(DOG)                .where(DOG.id.eq(10L)                .one();

Get an optional object

Optional<Dog>optDog =orm.select(DOG)                .where(DOG.id.eq(10L)                .optional();

Retrieve data as a stream

Stream<Dogs>dogs =orm.select(DOG).stream();

Ordering

Order by sinlge column/field in ascending order

List<Dog>alphaDogs =orm.select(DOG)   .orderBy(DOG.name)   .list();

Order by one column/field in descending order

List<Dog>dogHierarchy =orm.select(DOG)   .orderBy(DOG.age.desc())   .list();

Order by a column/field in descending order, other in ascending

List<Dog>dogHierarchy =orm.select(DOG)   .orderBy(DOG.age.desc(),DOG.name)   .list();

Joining data

@PojopublicclassPerson {@PrimaryKeyprivateLongid;@ForeignKey(pojo =Town.class)privateLongtownId;@ColumnprivateStringfirstName;@Column(nullable =true)privateStringlastName;@ColumnprivateStringemailAddress;@Column(nullable =true)privateDoubleincome;}

Select on a joined selection table

List<Dog>bobsDogs =orm.select(DOG)    .join(PERSON).on(DOG.personId,PERSON.id)    .where(PERSON.name.eq("Bob"))    .list();

Select on the result table and joined selection table

List<Dog>bobsDogs =orm.select(DOG).where(DOG.age.gt(2))    .join(PERSON).on(DOG.personId,PERSON.id)    .where(PERSON.name.eq("Bob"))    .list();