API to get the contentobject attribute id by passing content object id

Next topic

Author	Message
Neelima Amancherla	Friday 04 December 2009 6:26:06 am We are facing problems with the way eZ Publish stores files/foldername in the ezcontentobject_tree,ezcontentobject,ezbinaryfile and ezcontentobject_name tables. All the spaces in the file/folder names are getting replaced with underscores in the above mentioned tables. If we want to retrieve folder/file name and to display its original name on the eng site, its quite impossible to handle this from DB. And the original folder names are not stored in any of the above mentioned tables. Are there any inbuilt API in eZ Publish to retrieve the original file and folder names.Or is there any other alternate approach to retrieve from DB.
Łukasz Serwatka	Tuesday 08 December 2009 1:18:36 am Hi, There are few possibilities to get such data. You can start by looking on the eZContentObject class as well as on eZContentObjectAttribute class. Both reside under kernel/classes folder. Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog

Author

Message

Friday 04 December 2009 6:26:06 am

We are facing problems with the way eZ Publish stores files/foldername in the ezcontentobject_tree,ezcontentobject,ezbinaryfile and ezcontentobject_name tables.
All the spaces in the file/folder names are getting replaced with underscores in the above mentioned tables.
If we want to retrieve folder/file name and to display its original name on the eng site, its quite impossible to handle this from DB.
And the original folder names are not stored in any of the above mentioned tables.
Are there any inbuilt API in eZ Publish to retrieve the original file and folder names.Or is there any other alternate approach to retrieve from DB.

Łukasz Serwatka

Tuesday 08 December 2009 1:18:36 am

Hi,

There are few possibilities to get such data. You can start by looking on the eZContentObject class as well as on eZContentObjectAttribute class. Both reside under kernel/classes folder.

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

eZ debug

Timing:	Jan 18 2025 02:06:19
Script start
Timing:	Jan 18 2025 02:06:19
Module start 'layout'
Timing:	Jan 18 2025 02:06:19
Module start 'content'
Timing:	Jan 18 2025 02:06:20
Module end 'content'
Timing:	Jan 18 2025 02:06:20
Script end

Main resources:

Total runtime	0.8357 sec
Peak memory usage	4,096.0000 KB
Database Queries	54

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0057	589.5234	152.6875
Module start 'layout'	0.0057	0.0032	742.2109	39.5078
Module start 'content'	0.0089	0.8254	781.7188	524.8281
Module end 'content'	0.8343	0.0014	1,306.5469	8.0938
Script end	0.8357		1,314.6406

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0033	0.3925	16	0.0002
Check MTime	0.0013	0.1590	16	0.0001
Mysql Total
Database connection	0.0009	0.1068	1	0.0009
Mysqli_queries	0.7934	94.9374	54	0.0147
Looping result	0.0005	0.0561	52	0.0000
Template Total	0.8061	96.5	2	0.4031
Template load	0.0020	0.2409	2	0.0010
Template processing	0.8041	96.2180	2	0.4021
Template load and register function	0.0002	0.0200	1	0.0002
states
state_id_array	0.0008	0.0925	1	0.0008
state_identifier_array	0.0015	0.1788	2	0.0007
Override
Cache load	0.0016	0.1951	12	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0016	0.1904	2	0.0008
Fetch class attribute name	0.0017	0.2004	3	0.0006
XML
Image XML parsing	0.0007	0.0858	2	0.0004
class_abstraction
Instantiating content class attribute	0.0000	0.0009	3	0.0000
General
dbfile	0.0007	0.0863	18	0.0000
String conversion	0.0000	0.0049	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
2	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 8 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs