4 users Sign-in to change your status

This plugin provides support for UML diagrams designed in Dia. You need to follow the proper syntax in order to ensure that the diagram can be transformed into a propel model. The syntax is the following: columns are properties of the class the type of the property refers to the type of the column the value of the property provides the default value of the column - autoIncrement is supported indexes and keys are methods of the class the name of the function identifies the type of the key - it may be primaryKey, foreignKey or index arguments of the function represent the columns involved in the key or index for indexes and primaryKeys the arguments must not have a type for foreignKeys the second argument, representing the foreign column ,must have the foreign table name as its type. on foreignKeys the onDelete attribute may be set using the method's stereotype property You may use UML connectors to improve the visual appearance of the DB model, however the information stored in the classes are sufficient to build the propel schema. While building the DB diagram from a propel schema file you have to keep in mind that at the moment this part does only the transformation, so the created diagram will have the tables put on each other without eye candy UML connectors. In my opinion one should use this function to create a model from an existing db schema, and then use the dia diagram to modify it further. Model

• Repository
• Download package
• Browse source

The diaToPropel is a plugin to aid database visualisation. For databases designed using the Dia UML editor, it provides xsl transformations to convert the diagram into valid propel schema, and backwise.

Developers

Name	Status	Email
Gabor KORMANY	lead	moc]tod[liamg]ta[gynamrok

License

Releases for sf 1.2

Releases for sf 1.1

Releases for sf 1.0

Join this plugin team

Other releases

Release 0.2.2 - 19/08/2009

Release 0.2.1 - 23/05/2009

Release 0.1.5 - 05/05/2009

Release 0.1.4 - 05/05/2009

Release 0.1.3 - 05/05/2009

diaToPropel plugin

The diaToPropelPlugin is a helpful tool for database design.

It is a propel based symfony plugin, providing the ability to convert existing or reverse engineered propel schema files to a Dia compatible UML file. The Dia file can be used to visualize the database. The plugin also provides support to convert from a Dia file to a propel schema.

Both yml and xml format is supported.

Usage

From propel schema to Dia

• Build your Dia file from xml(s)

  $ symfony propel:propel-to-dia myModel.dia
  

• Build your Dia file from yml(s)

  $ symfony propel:propel-to-dia myModel.dia --y='true'
  

  It is enough to provide only the name of the file the extension will be added automatically.

From Dia to propel schema

• Build your schema xml(s) from Dia

  $ symfony propel:dia-to-propel myModel.dia
  $ symfony propel:dia-to-propel myModel.dia --s='true'
  

• Build your schema yml(s) from Dia

  $ symfony propel:propel-to-dia myModel.dia --y='true'
  $ symfony propel:propel-to-dia myModel.dia --y='true' --s='true'
  

  Using s(plit) will generate a [table-name]-schema.xml/yml for every table defined.

Dia syntax

• Class stereotype equals to phpName
• Columns are properties of the class
  • the type of the property refers to the type of the column
  • the value of the property provides the default value of the column - autoIncrement is supported

• Indexes and keys are methods of the class

  • the name of the function identifies the type of the key - it may be primaryKey, foreignKey, index or unique
  • arguments of the function represent the columns involved in the key or index
  • for indexes and primaryKeys the arguments must not have a type
  • for foreignKeys the second argument, representing the foreign column ,must have the foreign table name as its type.
  • on foreignKeys the onDelete attribute may be set using the method's stereotype property

  The image below shows the schema of sfGuardPlugin drawn in Dia.

Plans

• integrate with an SQL diff plugin
• add support for visualizing schema's defined in plugins