doctrine default values and relations
Posted
by Skirmantas
on Stack Overflow
See other posts from Stack Overflow
or by Skirmantas
Published on 2010-05-30T17:53:25Z
Indexed on
2010/05/30
20:02 UTC
Read the original article
Hit count: 167
doctrine
Concept: Lets say we have table Properties
with columns id
and name
(lets say with some predefined values: "Good" "Better" "Best"). Another table Users
has column property_id
with many to one relation on Properties
(property_id => id). Users
has default value on property_id
, lets say 1 which means "Good". We might have another table analogue to Users
however with default property, lets say "Better". What I need is ability to change default value for Users
or other tables in administrator's panel.
In mysql I can set default value for column like this:
ALTER TABLE <Table> CHANGE <Column> DEFAULT <NEW_DEFAULT_VALUE>
I can retrieve default value:
SELECT DEFAULT(<Column>) FROM <Table> LIMIT 1
Is it possible to achieve this concept with Doctrine?
What I actually need is such method in my table class:
class UserTable extend Doctrine_Table {
/* ... */
getDefaultProperty() {
}
setDefaultProperty($value) {
/* $value can be either integer or Doctrine_Record */
}
}
© Stack Overflow or respective owner