Stack Overflow
Stack Overflow

Questions tagged [propel]

Propel is an open-source object-relational mapping (ORM) for PHP 5. It allows you to access your database using a set of objects, providing a simple API for storing and retrieving data. There are two major versions, 1 and 2.

Propel is an open-source object-relational mapping (ORM) for PHP 5.

It allows you to access the records in your database using a set of OOP objects, providing a simple API for basic CRUD operations. To accomplish this, Propel ORM includes a generator component which uses source code generation to build PHP classes based on a data model definition written in XML (or reverse-engineered from an existing database).

Propel also includes a runtime component which manages connections, transactions, and any idiosyncratic rules that describe the workings of the RDBMS being used with Propel.

In addition to being open source, the code as implemented in a project is extendable with behaviors which alter the generated class structure and by working with the one-time generated model classes themselves which extend the base Active Record classes.

It is also an integral part of the PHP framework Symfony and was the default ORM up to and including version 1.2.

Documentation:

1161 questions
127
votes
10 answers

PHP ORMs: Doctrine vs. Propel

I'm starting a new project with symfony which is readily integrated with Doctrine and Propel, but I of course need to make a choice.... I was wondering if more experienced people out there have general pros and/or cons for going with either of these…
Tom
  • 30,090
  • 27
  • 90
  • 124
21
votes
4 answers

RedBean ORM performance

I would like to know whether Redbean ORM can be used for performance oriented scenarios like social networking web apps or no and is it stable even if thousands of data are pulled by multiple users at same time. Also I'd like to know whether Redbean…
Jaison Justus
  • 2,753
  • 8
  • 47
  • 65
20
votes
1 answer

Installing Propel behaviours with Composer

I'm currently developing on Windows with WampServer and have Composer working (with OpenSSL), with Propel installed without issue, and everything seems to work fine. However, my project now needs to make use of the Equal Nest Behaviour found here. I…
LeonardChallis
  • 7,759
  • 6
  • 45
  • 76
19
votes
6 answers

Twig instanceof for inheritance objects

I am using the following feature from propel http://www.propelorm.org/documentation/09-inheritance.html. I am also using Symfony2 and Twig I have a class structure using the above feature that looks something like this class Event {} class Birthday…
Alistair Prestidge
  • 673
  • 3
  • 9
  • 19
18
votes
2 answers

Propel: Get Raw SQL from Query object?

How do I get the raw SQL statement from a query object in Propel? I need this for debugging purposes. For example: I would like to have a function as in $rawSql = new BookQuery::create()->filterById(25)->getRawSql(); Does something like this exist?
twigmac
  • 1,772
  • 3
  • 21
  • 38
16
votes
2 answers

"User follows" with PropelORM - Three way relationship

Can someone point me in the right direction to do a "user follows" kind of thing. I have 3 tables: users, user_follows, and a posts. If I hydrate a user object, I can get an array of users id's they follow...and a post object knows which user posted…
Kyle Goslan
  • 10,748
  • 7
  • 26
  • 41
15
votes
1 answer

Propel form type model w. group_by is rendered without property display

Env: Symfony2 2.7 / Propel 1.6 I've created a choice form type like that: $builder->add('mychoice', 'model', array( 'class' => 'Foo\\Bar', 'query' => FooBarQuery::create()->filterBySomething(true), 'group_by'…
Lionel
  • 387
  • 3
  • 18
14
votes
2 answers

symfony 1.4 propel:build-all not working on Mysql 5.5

i am using Symfony 1.4.8 and Mysql 5.5 i got this error when i run symfony propel:build-all You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near…
Bhanu Krishnan
  • 3,726
  • 1
  • 20
  • 40
13
votes
1 answer

Weaknesses and forces of Doctrine 2 and Propel 1.6

I would like to know what are the forces and weaknesses of Doctrine 2 and Propel 1.6. For instance, Doctrine 2 is really user friendly but limits you if you want to go beyond conformism. Doctrine 2 documentation lack of updates ... If possible you…
Geoffrey Brier
  • 789
  • 6
  • 18
12
votes
4 answers

Storing a serialized object in MySql database

I have a big php object that I want to serialize and store in a MySql database. The table encoding is UTF-8 and the column to hold the serialized object encoding is also UTF-8. The problem is the object holds a text string containing French…
Songo
  • 5,618
  • 8
  • 58
  • 96
12
votes
3 answers

Which ORM to use with Symfony2?

I'm starting a new project with Symfony2 and I'm not really sure which ORM to choose. I've heard some bad things about Doctrine2, especially when it comes to inheritance and DQL. It seems like Propel is back from the dead, but on the other hand,…
Timothée Martin
  • 775
  • 4
  • 13
10
votes
2 answers

Propel PostgreSQL Migration unable to find adapter

I am trying to use migrations for the first time on my in-development Propel project (so I don't have to re-insert 15MB of data), but am having some difficulties. I made the changes in my schema and ran propel-gen diff. I first received an error…
Sam
  • 20,096
  • 2
  • 45
  • 71
10
votes
1 answer

PropelORM v1 multiple databases

I have few problems with setting PropelORM to work with multiple databases. I couldn't find anything useful in the documentation. Generating schemas from multiple databases I prefer to make a change to database schema first and then run $…
Lukasz Kujawa
  • 3,026
  • 1
  • 28
  • 43
9
votes
4 answers

Export MySQL Workbench data model directly to Schema YML in Propel/ Symfony

Is there any plugin that directly exports MYSQL Workbench data model directly to YML for Propel consumption?
Graviton
  • 81,782
  • 146
  • 424
  • 602
9
votes
4 answers

How to Zend Framework with Propel ORM

I'd like to integrate Propel with Zend framework. I've seen the integration of doctrine in the past but this post says it seems propel is done a bit differently. Propel has two things going for it already: the first is that Propel includes its own…
jblue
  • 4,390
  • 4
  • 46
  • 79
1
2 3
…
77 78