Contents

    1 Getting Started with AuDAO
    1. 1.1 Create the Source XML
      1. 1.1.1 Basic Example XML
      2. 1.1.2 Definition of Columns
      3. 1.1.3 Definition of Indexes
      4. 1.1.4 Definition of Methods
    2. 1.2 Generate SQLs and Java Sources
      1. 1.2.1 Using the Online Tool
      2. 1.2.2 AuDAO Standalone - Ant Tools
    3. 1.3 Use the Generated Java DAO
      1. 1.3.1 Compiling DAO Sources
      2. 1.3.2 Using the DAO
    2 AuDAO Features - Compatibility Matrix
    1. 2.1 SQL Feature Matrix
    2. 2.2 DAO Feature Matrix
    3 SQL Features
    1. 3.1 SQL Features
      1. 3.1.1 Primary Keys
      2. 3.1.2 Indexes
      3. 3.1.3 Foreign Keys
      4. 3.1.4 Sequences
      5. 3.1.5 Data
    4 Java DAO Features
    1. 4.1 Types
      1. 4.1.1 Type Boolean
      2. 4.1.2 Type Short
      3. 4.1.3 Type Int
      4. 4.1.4 Type Long
      5. 4.1.5 Type Double
      6. 4.1.6 Type String
      7. 4.1.7 Type Date
      8. 4.1.8 Type Timestamp
      9. 4.1.9 Type byte[]
      10. 4.1.10 Type Serializable
      11. 4.1.11 Type List
      12. 4.1.12 Enumerations
      13. 4.1.13 References
      14. 4.1.14 Transient Columns
    2. 4.2 Keys
      1. 4.2.1 Primary Keys
      2. 4.2.2 Parent Keys
      3. 4.2.3 Ancestor Keys
    3. 4.3 Default and Automatic Values
      1. 4.3.1 Autoincrement Primary Keys
      2. 4.3.2 Autoincrement Fields (not pk)
      3. 4.3.3 Automatic Date Fields
      4. 4.3.4 Automatic Timestamp Fields
    4. 4.4 Finders
      1. 4.4.1 All Finder
      2. 4.4.2 Dynamic Finder
      3. 4.4.3 Primary Key Finder
      4. 4.4.4 Index Finder
      5. 4.4.5 Condition Finder
      6. 4.4.6 Reference Finder
    5. 4.5 Methods
      1. 4.5.1 Method Count
      2. 4.5.2 Method Find
      3. 4.5.3 Method Delete
      4. 4.5.4 Method Insert
      5. 4.5.5 Method Move
      6. 4.5.6 Method Truncate
      7. 4.5.7 Method Update
    6. 4.6 Insert Methods
      1. 4.6.1 Batch Insert
    7. 4.7 Count Methods
      1. 4.7.1 Count All
      2. 4.7.2 Count By Dynamic Condition
      3. 4.7.3 Count By Index
      4. 4.7.4 Count By Condition
      5. 4.7.5 Count By Reference
    8. 4.8 Delete Methods
      1. 4.8.1 Delete By Primary Key
      2. 4.8.2 Delete All
      3. 4.8.3 Delete By Dynamic Condition
      4. 4.8.4 Delete By Index
      5. 4.8.5 Delete By Condition
    9. 4.9 Find Methods
      1. 4.9.1 Find By Primary Key
      2. 4.9.2 Find All
      3. 4.9.3 Find By Dynamic Condition
      4. 4.9.4 Find By Index
      5. 4.9.5 Find By Condition
      6. 4.9.6 Find By Reference
    10. 4.10 Update Methods
      1. 4.10.1 Update By Primary Key
      2. 4.10.2 Update Column By Primary Key
    11. 4.11 Raw or Batch Update Methods
      1. 4.11.1 Raw Update By Primary Key
      2. 4.11.2 Batch Update All
      3. 4.11.3 Update By Dynamic Condition
      4. 4.11.4 Batch Update By Index
      5. 4.11.5 Batch Update By Condition
    5 Google App Engine Specific Features
    1. 5.1 GAE Types
      1. 5.1.1 GAE Core Types
      2. 5.1.2 Lists
    2. 5.2 Storage Options
      1. 5.2.1 Do Not Store Null Values
      2. 5.2.2 Explicit Unindexed Columns
    3. 5.3 Finders and Lists
      1. 5.3.1 Finder Signature - List or Element
      2. 5.3.2 Expanded Conditions for List Properties
      3. 5.3.3 "IN" Conditions
    4. 5.4 Caches
      1. 5.4.1 L0 Cache - Entity Memory Cache
      2. 5.4.2 L1 Cache - DTO Memory Cache
      3. 5.4.3 L2 Cache - DTO MemcacheService Cache
    5. 5.5 Dynamic GQL Parser
    6. 5.6 Extended GQL Parser
      1. 5.6.1 SELECT Statement
      2. 5.6.2 INSERT Statement
      3. 5.6.3 UPDATE Statement
      4. 5.6.4 DELETE Statement
      5. 5.6.5 Soft Conditions
      6. 5.6.6 Nested Queries
      7. 5.6.7 Functions
        1. 5.6.7.1 Standard GQL Functions
        2. 5.6.7.2 Mathematic Functions
        3. 5.6.7.3 String Functions
        4. 5.6.7.4 Date Functions
        5. 5.6.7.5 Other Functions
        6. 5.6.7.6 Pseudo Functions
        7. 5.6.7.7 User Defined Functions
      8. 5.6.8 Grammar
    6 Generator Output and Tweaking
    1. 6.1 Config Element
    2. 6.2 DTO Classes
      1. 6.2.1 Serializing - serialVersionUID
      2. 6.2.2 Methods equals() and hashCode()
      3. 6.2.3 Enum Column
      4. 6.2.4 Compatible DTOs with GWT (Google Web Toolkit)
      5. 6.2.5 DTO Root Class
    3. 6.3 DAO Classes
      1. 6.3.1 Find method return type - array or list
      2. 6.3.2 Method getOrderExpr
      3. 6.3.3 DAO Root Class
    4. 6.4 DAO Implementation Classes
      1. 6.4.1 DAO Impl Root Class
      2. 6.4.2 Default DTO cache
    7 Generator Tools
    1. 7.1 Apache Ant Tools
      1. 7.1.1 Predefined High-Level Ant Targets
      2. 7.1.2 AuDAO Ant Task
    2. 7.2 Plain Java Tools
      1. 7.2.1 audao.sh (UNIX)
      2. 7.2.2 Java Main Class (Universal)
    8 Examples
Free Online Tool

Try our free online DAO generator.

Upload the configuration XML file and get the generated SQL scripts and Java classes for free !

Free GQL Parser

Download source or binary of our open-source GQL parser.

Query q =
 new GqlDynamic()
  .parseQuery(
   "SELECT * FROM Ent");
All GQL features are supported. More...