Dokumentace

2 AuDAO Features - Compatibility Matrix

In this chapter we would like to list all available features of the AuDAO generator. The current AuDAO version 1.2 (release 2010-02-25) contains the following features.

2.1 SQL Feature Matrix
2.2 DAO Feature Matrix

2.1 SQL Feature Matrix

AuDAO let's you to generate SQL create and drop scripts. This is useful for standard database like MySQL and Oracle. As for Google App Engine you can use only index related features.

Feature	MySQL	Oracle DB	HSQLDB	Google App Engine	Google App Engine - JDO
primary keys	yes	yes	yes	no	no
indexes	yes	yes	yes	no	no
foreign keys	yes	yes	yes	no	no
sequences	no	yes	yes	no	no
data	yes	yes	yes	no	no

2.2 DAO Feature Matrix

AuDAO let's you to generate Java DAO classes. If we say "DAO" we mean DAO and all related stuff like DTO and DAO implementation classes.

Feature	MySQL	Oracle DB	HSQLDB	Google App Engine	Google App Engine - JDO
type boolean	yes	yes	yes	yes	yes
type short	yes	yes	yes	yes	yes
type int	yes	yes	yes	yes	yes
type long	yes	yes	yes	yes	yes
type double	yes	yes	yes	yes	yes
type String	yes	yes	yes	yes	yes
type Date	yes	yes	yes	emulated	emulated
type Timestamp	yes	yes	yes	emulated	emulated
type byte[]	yes	yes	yes	yes	no
type Serializable	yes	yes	yes	yes	no
type List	no	no	no	yes	no
enumerations	yes	yes	yes	yes	yes
transient columns	yes	yes	yes	yes	yes

primary key	yes	yes	yes	yes	yes
parent key	ignored	ignored	ignored	yes	yes
ancestor key	ignored	ignored	ignored	yes	no

autoincrement pk	autoincrement	sequence	sequence	yes	yes
autoincrement not pk	no	no	no	yes	no
auto date	yes	yes	yes	yes	yes
auto timestamp	yes	yes	yes	yes	yes

method count	yes	yes	yes	yes	yes
method delete	yes	yes	yes	yes	yes
method find	yes	yes	yes	yes	yes
method insert	yes	yes	yes	yes	yes
method move	yes	yes	yes	no	no
method truncate	yes	yes	yes	no	no
method update	yes	yes	yes	yes	yes

all finder	yes	yes	yes	yes	yes
dynamic finder	SQL	SQL	SQL	GQL	JDOQL
primary key finder	yes	yes	yes	yes	yes
index finder	yes	yes	yes	yes	yes
condition finder	SQL	SQL	SQL	GQL	JDOQL
reference finder	yes	yes	yes	no	no

batch insert	emulated	emulated	emulated	yes	no

count all	yes	yes	yes	yes	yes
count dynamic	yes	yes	yes	yes	yes
count by index	yes	yes	yes	yes	yes
count by condition	yes	yes	yes	yes	yes
count by reference	yes	yes	yes	no	no

delete by primary key	yes	yes	yes	yes	yes
delete all	yes	yes	yes	max 500 rows	max 500 rows
delete dynamic	yes	yes	yes	max 500 rows	max 500 rows
delete by index	yes	yes	yes	max 500 rows	max 500 rows
delete by condition	yes	yes	yes	max 500 rows	max 500 rows

find by primary key	yes	yes	yes	yes	yes
find all	yes	yes	yes	yes	yes
find dynamic	yes	yes	yes	yes	yes
find by index	yes	yes	yes	yes	yes
find by condition	yes	yes	yes	yes	yes
find by reference	yes	yes	yes	no	no

update by primary key	yes	yes	yes	yes	yes
update column by primary key	yes	yes	yes	yes	yes

raw update by primary key	yes	yes	yes	no	no
batch update all	yes	yes	yes	no	no
batch update dynamic	yes	yes	yes	no	no
batch update by index	yes	yes	yes	no	no
batch update by condition	yes	yes	yes	no	no

Index

Online Generátor

Vyzkoušejte zadarmo náš online DAO generátor.

Vytvořte konfigurační XML soubor a získejte zadarmo vygenerované SQL skripty a Java třídy !

GQL Parser

Stáhněte si zdrojové či binární soubory GQL parseru.

Query q =
 new GqlDynamic()
  .parseQuery(
   "SELECT * FROM Ent");

Plná podpora GQL. Více...

Poslední úpravy: 2012-04-14

O aplikaci O soukromí