New ORM Designer 3 called Skipper is available on our new site www.skipper18.com

CakePHP

Introduction

With ORM Designer you can export definition files from your visual model directly to CakePHP php files. It allows you to focus on development instead of code writing, which will save you up to 70% of your time.

You can make changes and immediately export them back to definition files. From now your visual model will always correspond to your definition files.

Thanks to ORM Designer there's no space for typos and duplicated, missing or redundant fragments in your definition files.

ORM Designer has native support for all major operating systems.

How ORM Designer supports CakePHP ORM

ORM Designer supports all features and techniques available in CakePHP ORM. No matter if you want to model a simple schema or create a large project containing several plugins. ORM Designer will help you. Below you will find a list of most useful features:


Basic model designing

To design your new model insert modules and entities and connect them with associations or inheritances. Then configure ORM Properties for each model object (entity, association...) in sophisticated ORM Property Editor.

Model navigation

Use the project tree with full-text searching ability instead of searching for specific entity (or other model object) in your diagram. This is really fast way how to explore your model.


Behaviors support

ORM Designer supports all available CakePHP ORM behaviors. Instead of writing a lot of definitions simply choose behavior from list and fill required properties. You can also configure nested behaviors, insert multiple behaviors and sort them.

Validators support

ORM Designer supports all available CakePHP ORM field validators. Instead of remembering and writing validator definitions simply choose validator from list and fill required parameters. You can also create your own validators or extend existing ones.


Associations (One to One, One to Many, Many to Many)

Defining association is really tricky so we added an extra wizard for 1:N and M:N associations to ORM Designer. It will guide you through selection of owner and inverse entity, MN entity, specifying and choosing of correct aliases, all in easy GUI way.

Indexes

Indexes are very simple feature, but ORM Designer can make them even more simple. So the application offers a editor for defining indexes to your entities.


Model Export

ORM Designer exports your model to base and derived classes. Derived class is prepared as empty template for your modifications and base class contains all required definitions.

Application Schema Export

ORM Designer can export also application schema with definitions of each object in project. Application schema is PHP class AppSchema derived from CakeSchema.


External tools

You can simply define a set of common external tools and run them directly from ORM Designer. Each external tool is defined by its executable-path, arguments and by default path.

ORM Designer customization

Although ORM Designer supports all available features of CakePHP ORM, sometimes you might need more. It's not a problem.

ORM Designer offers a great way how to extend or customize existing configurations. Define your own datatypes, custom properties, add new behaviors or change existing properties too. Check details here.


Download ORM Designer now!

You can try ORM Designer for 14-days for free without any commitment. Try ORM Designer now!

.

Detailed list of supported CakePHP ORM features

ORM Designer model properties

Object Property
Project Name, Storage path, Description
Module Name, Description, External plugin storage, Export path and format
Entity Name, Description
Field Name, Type, Size, Required, Unique, Primary key, Auto increment, Default value, Enum values, Description
Association Owner/Inverse entity, Reference fields, Owner/Inverse alias, Association Type (one-to-one, one-to-many), Parent requirement, Description
Many to Many MN Entity, Owner/Inverse Entity, Reference Fields, Owner/Inverse Alias, Description
Inheritance Base/Derived Entity, Inheritance Type, Discriminator Value/Field, Description
Index Name, Unique, Indexed Fields, Description

CakePHP model properties

Object Property
Project schema (export-file)
Module -
Entity actAs (Behaviors), useDbConfig, useTable, tablePrefix, displayField, recursive, order, data, virtualFields, alias, cacheQueries, cacheSources, findQueryType, logTransactions, table, tableToModel, transactional
Field Validators
Association conditions, fields, order, counterCache, counterScope, dependent, limit, offset, exclusive, finderQuery
Many to Many finderQuery, deleteQuery, insertQuery, limit, offset, fields, conditions

CakePHP behaviors support

  • ACL
  • Containable
  • Translate
  • Tree

CakePHP validators support

  • alphaNumeric
  • between
  • blank
  • boolean
  • cc
  • comparison
  • date
  • decimal
  • email
  • equalTo
  • extension
  • ip
  • isUnique
  • minLength
  • maxLength
  • money
  • multiple
  • inList
  • numeric
  • notEmpty
  • phone
  • postal
  • range
  • ssn
  • url
  • reg-ex
  • own-function

CakePHP datatypes support

  • boolean
  • integer
  • binary
  • date
  • time
  • timestamp
  • datetime
  • float
  • text
  • string