Description sfPropelPlugin adds support for Propel 1.3 for symfony 1.1. Homepage http://propel.phpdb.org/ Categories Model

Leads

Name	Email
Dustin Whittle	moc.tcejorp-ynofmys <<ta>> elttihw.nitsud

This is the website of the Propel PHP project. Propel is an Object-Relational Mapping (ORM) framework for PHP5. It allows you to access your database using a set of objects, providing a simple API for storing and retrieving data.

Propel allows you, the web application developer, to work with databases in the same way you work with other classes and objects in PHP.

* You don't have to worry about database connections or writing SQL -- unless you want to.
* You never have to worry about escaping data or type-casting results.
* You define your database in a simple XML format (or tell Propel to build it from an existing database) and Propel will create database initialization files for your database and will generate static classes and objects that provide an OO interface to your database. (It can generate other useful things based on the datamodel too!)
* Propel builds classes which are aware of the structure of your database so there's no performance lost to initialization or to on-the-fly database metadata queries. 

Most web application database tasks are really simple -- and with Propel they'll actually feel as simple as they are. Finally, extensibility is at the heart of Propel's design; we expect you to want to change and customize things.

Releases for sf 1.1

Copyright (c) 2004-2006 Fabien Potencier

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Ticketing

Go to the ticketing system to view opened tickets or report a bug.

Join this plugin team

Other releases

Release 1.3.0 - 28/05/2008

Installation for sf 1.1

php symfony plugin:install sfPropelPlugin --release=1.3.0 

PEAR

Download the PEAR package

Repository

Go to the repository: http://svn.symfony-project.com/plugins/sfPropelPlugin

sfPropelPlugin (Propel 1.3 for symfony 1.1)

The sfPropelPlugin is a symfony plugin that provides integration with Propel. Propel is an Object-Relational Mapping (ORM) framework. It allows you to access your database using a set of objects, providing a simple API for storing and retrieving data. The plugin provides a model layer for symfony with tasks for managing the object model and generators for creating crud/admin modules.

Propel allows you, the web application developer, to work with databases in the same way you work with other classes and objects in PHP.

* You don't have to worry about database connections or writing SQL -- unless you want to.
* You never have to worry about escaping data or type-casting results.
* You define your database in a simple XML format (or tell Propel to build it from an existing database) and Propel will create database initialization files for your database and will generate static classes and objects that provide an OO interface to your database. (It can generate other useful things based on the datamodel too!)
* Propel builds classes which are aware of the structure of your database so there's no performance lost to initialization or to on-the-fly database metadata queries.

Installation

• Install the plugin

  symfony plugin:install sfPropelPlugin

• Configure databases.yml and propel.ini

config/databases.yml (copy from sfPropelPlugin/config/databases.yml.example)

dev:
  propel:
    param:
      classname:  DebugPDO

all:
  propel:
    class:        sfPropelDatabase
    param:
      classname:  PropelPDO
      dsn:        mysql:dbname=foobar;host=localhost
      username:   foo
      password:   bar
      encoding:   utf8
      persistent: true
      pooling:    true

config/propel.ini (copy from sfPropelPlugin/config/propel.ini.example)

propel.database.driver     = mysql
propel.database.url        = mysql:dbname=foobar;host=localhost
propel.database.creole.url = ${propel.database.url}
propel.database.user       = foo
propel.database.password   = bar
propel.output.dir          = /path/to/project

• Clear you cache

  symfony cc

• Rebuild your object model

  symfony propel:build-all

• Clear you cache

  symfony cc

Documentation

• Upgrading from Propel 1.2 to 1.3
• [Propel Documentation] + http://propel.phpdb.org/trac/wiki/Users/Documentation/1.3/UserGuide User Guide
• The symfony book on: [model layer], [http://www.symfony-project.org/book/1_1/14-Generators generators], http://www.symfony-project.org/book/1_1/13-I18n-and-L10n i18n - warning: based on propel 1.2 (but most is valid)
• Propel Tutorials
• Propel API Documentation

If upgrading see:

• Transaction syntax has changed in Propel 1.3.
• Out with RecordSet, in with Statements
• Custom SQL API has changed
• new DateTime handling

TODO

• Add master/slave support for config
• Add query timing + better logging

Changelog

1.3.0-PRE

• dwhittle: initial release