mydesign and query to external db from admin_site

Author Message

francesco campana

Monday 25 January 2010 6:52:32 am

Hi guys!
I'm new to ezpublish and I'm playing with it.
I found it is very powerfull and flexible,but it's a little bit hard to use and to make it fit my needs.
This is my project:
I'd like to write an extension (hopefully) to manage several users' book collection.
I should write data on an external db and of course I have to use my own design.
1st problem: the design
At the moment I installed the plain_site contents and I wrote my tpl files in ezroot/design/plain_site. But, should I make an extension for that too? I mean 1 extension for the design and the other one for functionalities?
2nd problem: the external db.
I was able to make a public site_access query an external db to fetch and to store data, by jumping from the default db to the external, but at the moment I have no idea on how to use the admin side to interact with the external db. Any advice? Maybe I have to write my own admin_page in my extension to insert books?
Thank you in advance
Any suggestion about the design of the app will be very appreciated as well!

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

eZ debug

Timing: Jan 18 2025 02:05:13
Script start
Timing: Jan 18 2025 02:05:13
Module start 'layout'
Timing: Jan 18 2025 02:05:13
Module start 'content'
Timing: Jan 18 2025 02:05:14
Module end 'content'
Timing: Jan 18 2025 02:05:14
Script end

Main resources:

Total runtime0.7772 sec
Peak memory usage4,096.0000 KB
Database Queries46

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0067 589.1641152.6406
Module start 'layout' 0.00670.0042 741.804739.4922
Module start 'content' 0.01090.7642 781.2969402.8594
Module end 'content' 0.77510.0020 1,184.15638.1250
Script end 0.7771  1,192.2813 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00320.4153160.0002
Check MTime0.00130.1712160.0001
Mysql Total
Database connection0.00080.104710.0008
Mysqli_queries0.737494.8891460.0160
Looping result0.00040.0578440.0000
Template Total0.738795.120.3694
Template load0.00220.286620.0011
Template processing0.736594.767520.3682
Template load and register function0.00010.019010.0001
states
state_id_array0.00300.384310.0030
state_identifier_array0.00140.185720.0007
Override
Cache load0.00180.2304150.0001
Sytem overhead
Fetch class attribute can translate value0.00090.112110.0009
Fetch class attribute name0.00060.072510.0006
XML
Image XML parsing0.00010.013810.0001
class_abstraction
Instantiating content class attribute0.00000.000510.0000
General
dbfile0.00070.0845100.0001
String conversion0.00000.001440.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
1content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
1content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 5
 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs