Forums / Extensions / SqliImport, search if attribute value already exists

SqliImport, search if attribute value already exists

Author Message

Jérémie Caulier

Tuesday 03 May 2011 12:56:03 am

I have a content type that looks like this:
myContentType
{
unique_id: integer
title: string
...
}

I retrieve data from an external data source and want to aggregate them automatically in eZ Publish content tree.

But before the import, I want to check if an other object related to "myContenType" not exists with the same unique_id value ...

What is the best way to proceed ?

Jérôme Vieilledent

Thursday 05 May 2011 6:16:45 am

Hi Jérémie

Actually, it's already implemented, native and automatic :).

If you use RemoteID, SQLIContent::create() will automatically check if a content already exists with this RemoteID. If this is the case, it will be returned. Then, when you'll publish it, the publisher will go through all the attributes and check if there has been a modification. If this is the case, a new version is created, if not the content is not modified.

You can check the doc in the "Simplified content API" part : http://svn.projects.ez.no/sqliimport/trunk/doc/README.txt

Jérémie Caulier

Saturday 07 May 2011 4:12:35 am

Thnx, it's a really nice extension !

eZ debug

Timing: Jan 18 2025 00:06:24
Script start
Timing: Jan 18 2025 00:06:24
Module start 'content'
Timing: Jan 18 2025 00:06:24
Module end 'content'
Timing: Jan 18 2025 00:06:25
Script end

Main resources:

Total runtime1.0309 sec
Peak memory usage4,096.0000 KB
Database Queries194

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0054 588.9922180.8203
Module start 'content' 0.00540.7833 769.8125523.0703
Module end 'content' 0.78870.2422 1,292.8828332.7422
Script end 1.0308  1,625.6250 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00400.3878210.0002
Check MTime0.00140.1368210.0001
Mysql Total
Database connection0.00070.063310.0007
Mysqli_queries0.937890.96961940.0048
Looping result0.00250.24141920.0000
Template Total1.003197.320.5016
Template load0.00210.203620.0010
Template processing1.001097.099320.5005
Template load and register function0.00030.025010.0003
states
state_id_array0.00120.113710.0012
state_identifier_array0.00160.157120.0008
Override
Cache load0.00180.1742380.0000
Sytem overhead
Fetch class attribute can translate value0.00170.169530.0006
Fetch class attribute name0.00170.162540.0004
XML
Image XML parsing0.00100.093930.0003
class_abstraction
Instantiating content class attribute0.00000.000940.0000
General
dbfile0.00400.3887280.0001
String conversion0.00000.000530.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

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
3content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
6content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
7content/datatype/view/ezxmltags/emphasize.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/emphasize.tplEdit templateOverride template
5content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1content/datatype/view/ezxmltags/strong.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/strong.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 25
 Number of unique templates used: 8

Time used to render debug report: 0.0001 secs