Export MySQL tables into EZ publish classes.

Previous topic

Developer

Next topic

Author	Message
Simon Caisse	Monday 28 November 2005 5:25:25 pm Is it possible to export MySQL tables into EZ publish classes? I have MySQL tables with data that was not created by EZ that I would like to be displayed into EZ publish. I know how to create new classes in EZ but is there a way to populate these 'classes' with the data I already have on MySQL tables?
Łukasz Serwatka	Thursday 01 December 2005 12:29:45 am Hi Simon, It is possible to fetch from database and display result in templates. You have to write new fetch function, it is not so difficult and well documented example you can find here: http://ez.no/products/ez_publish_cms/documentation/development/extensions/module/module_tutorial_part_1 However if you want to present data using objects, read this topic, and it will give you some light how create objects pragmatically: http://ez.no/community/forum/install_configuration/how_to_create_ezcontentobject_programmatically You can also learn more from eZ publish book: http://ez.no/products/books/ez_publish_book Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
Simon Caisse	Thursday 01 December 2005 5:45:45 pm That's exactly what I was looking for. Thank you very much for your help. Much appreciated

Author

Message

Simon Caisse

Monday 28 November 2005 5:25:25 pm

Is it possible to export MySQL tables into EZ publish classes?

I have MySQL tables with data that was not created by EZ that I would like to be displayed into EZ publish.

I know how to create new classes in EZ but is there a way to populate these 'classes' with the data I already have on MySQL tables?

Łukasz Serwatka

Thursday 01 December 2005 12:29:45 am

Hi Simon,

It is possible to fetch from database and display result in templates. You have to write new fetch function, it is not so difficult and well documented example you can find here:

http://ez.no/products/ez_publish_cms/documentation/development/extensions/module/module_tutorial_part_1

However if you want to present data using objects, read this topic, and it will give you some light how create objects pragmatically:

http://ez.no/community/forum/install_configuration/how_to_create_ezcontentobject_programmatically

You can also learn more from eZ publish book:
http://ez.no/products/books/ez_publish_book

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

Simon Caisse

Thursday 01 December 2005 5:45:45 pm

That's exactly what I was looking for. Thank you very much for your help. Much appreciated

eZ debug

Timing:	Jan 31 2025 06:14:59
Script start
Timing:	Jan 31 2025 06:14:59
Module start 'layout'
Timing:	Jan 31 2025 06:14:59
Module start 'content'
Timing:	Jan 31 2025 06:14:59
Module end 'content'
Timing:	Jan 31 2025 06:14:59
Script end

Main resources:

Total runtime	0.0152 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0052	588.2656	151.2266
Module start 'layout'	0.0052	0.0030	739.4922	36.6797
Module start 'content'	0.0082	0.0055	776.1719	90.1875
Module end 'content'	0.0137	0.0015	866.3594	29.9922
Script end	0.0152		896.3516

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0024	15.9496	14	0.0002
Check MTime	0.0010	6.8839	14	0.0001
Mysql Total
Database connection	0.0008	5.0144	1	0.0008
Mysqli_queries	0.0024	16.1049	3	0.0008
Looping result	0.0000	0.1443	1	0.0000
Template Total	0.0010	6.9	1	0.0010
Template load	0.0008	5.5586	1	0.0008
Template processing	0.0002	1.3159	1	0.0002
Override
Cache load	0.0006	3.8286	1	0.0006
General
dbfile	0.0009	6.2032	8	0.0001
String conversion	0.0000	0.0659	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	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs