Data model : ezuser and ezuser_settings

Previous topic

Developer

Next topic

Author	Message
Hugues Charleux	Wednesday 29 September 2010 1:30:39 am Hi all, Fetching users the other day, I was just wondering... Why are there two different tables, ezuser and ezuser_setting ? I didn't get deep into code but it looks like the ezuser_setting fields[1] are mandatory for each ezuser records. This makes the API more painfull as you have to fetch a eZUserSetting object to get those information. This make an extra SQL query to get those informations. This is not a big deal but looks strange, did I miss something ? Some historical background maybe ? [1] is_enabled \| max_login
André R.	Wednesday 29 September 2010 1:49:09 am This should be part of ezuser someday indeed, not sure why there are two myself. Probably a reason that is not valid anymore :) eZ Online Editor 5: http://projects.ez.no/ezoe \|\| eZJSCore (Ajax): http://projects.ez.no/ezjscore \|\| eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription @: http://twitter.com/andrerom
Nicolas Pastorino	Wednesday 29 September 2010 1:50:15 am That could a useful bug report, couldn't it ? -- Nicolas Pastorino Director Community - eZ Member of the Community Project Board eZ Publish Community on twitter: http://twitter.com/ezcommunity t : http://twitter.com/jeanvoye G+ : http://plus.tl/jeanvoye

Author

Message

Hugues Charleux

Wednesday 29 September 2010 1:30:39 am

Hi all,

Fetching users the other day, I was just wondering...

Why are there two different tables, ezuser and ezuser_setting ?

I didn't get deep into code but it looks like the ezuser_setting fields[1] are mandatory for each ezuser records.

This makes the API more painfull as you have to fetch a eZUserSetting object to get those information.
This make an extra SQL query to get those informations.

This is not a big deal but looks strange, did I miss something ? Some historical background maybe ?

[1] is_enabled | max_login

André R.

Wednesday 29 September 2010 1:49:09 am

This should be part of ezuser someday indeed, not sure why there are two myself. Probably a reason that is not valid anymore :)

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Nicolas Pastorino

Wednesday 29 September 2010 1:50:15 am

That could a useful bug report, couldn't it ?

--
Nicolas Pastorino
Director Community - eZ
Member of the Community Project Board

eZ Publish Community on twitter: http://twitter.com/ezcommunity

t : http://twitter.com/jeanvoye
G+ : http://plus.tl/jeanvoye