Direct DB modifications of attributes' values/sort keys

Author Message

Piotrek Karaś

Monday 17 December 2007 5:29:43 pm

Hello there,

I have a situation in which I would like to change some content attributes' values directly in the database, without calling core eZ Publish functions. I'm talking about integer-type values, easy to manage, and cache clearing is not really an issue functionally, these values will have to take effect periodically, when cache expires, for sorting purposes.

Should I expect any anomalies when I directly change <b>sort_key_int</b> and <b>data_int</b> fields values in the <b>ezcontentobject_attribute</b> table for this given attribute?

Greets,
Piotrek

--
Company: mediaSELF Sp. z o.o., http://www.mediaself.pl
eZ references: http://ez.no/partners/worldwide_partners/mediaself
eZ certified developer: http://ez.no/certification/verify/272585
eZ blog: http://ez.ryba.eu

Piotrek Karaś

Tuesday 18 December 2007 5:46:26 am

Well, decided to turn thoughts into code ;)
http://ez.no/developer/contribs/cronjobs/ez_child_node_priority_rotator
This extension directly touches issues that I asked about above.

--
Company: mediaSELF Sp. z o.o., http://www.mediaself.pl
eZ references: http://ez.no/partners/worldwide_partners/mediaself
eZ certified developer: http://ez.no/certification/verify/272585
eZ blog: http://ez.ryba.eu

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.