TableOfContents.md

Introduction

• Features
• Tutorial

Setup

• Setting up mapperdao
• Sbt/Maven Configuration
• Integrating with popular web frameworks
• Examples
• MapperDao test cases source code

Mapping

• Getting Started and simple mappings
• MapperDao and Ids
• CRUD operations
• Batch inserts and updates
• Natural, Surrogate and composite keys
• Auto-Generated keys
• Sequences
• Configure Selects, Deletes and Updates
• One To Many
• Many To One
• Many To Many
• One To One
• Many-To-One and One-To-Many mapping of 2 entities
• One-To-Many relationship of an entity to itself
• Embedding Entities
• Mapping Enumerations
• Mapping class hierarchies
• Option support
• Mapping relationships of simple types
• Mapping of external entities (entities not managed by mapperdao)
• Declaring keys that are not available on mappings
• Blobs, mapping binary data
• mapping sql functions
• mapping to tables on non-default schema
• Supported Data Types

Querying / Query DSL

• Simple queries and joins
• Self Join queries
• Querying & joining using aliases
• Creating queries dynamically
• Configure data retrieval for queries
• Pagination: retrieving pages of data
• Aliases when querying

Update / Delete DSL

• Updating data with the update DSL
• Deleting data with the delete DSL

Transactions

• Transactions

Caching

• Caching configuration and usage

Lazy Loading

• Lazy Loading of relationships

Creating Daos

• Creating CRUD daos
• Mixing traits that provide extra functionality

Advanced

• Cyclic dependency of entities
• Updating graphs of immutable objects
• Data sharding: On the fly changing which tables to insert/update/select
• Customize scala to database type mappings

Things to note

• Object equality, equals() and hashCode() methods
• Mock objects and Entities with recursive references to each other
• MySql notes
• Postgresql notes
• Derby notes