Magento Developer Certification Preparation Study Group

Session Four

Andreas Mautz || @mautz_et_tong

webvisum GmbH

Was?

ORM, Database, Setup Script

Wer?

Andreas Mautz
programmiert seit 16 Jahren
macht magento seit 2008
beschäftigt sich mit Deployment-Prozessen, Entwicklungsinfrastrukturen und Wissensmanagement seit 2011
Vorbereitung Zertifizierung
Lehren und Lernen Stoff zusammenzufassen

Locationcation

brandung

Next: ???

Ablauf

Was machen wir denn heute Schönes?

Hausaufgaben besprechen
ORM
Datenbank
Setup Scripts
neue Aufgaben
Sonstiges

Hausaufgaben!

In a custom action controller, render only the contents of a single custom update handle.

Rewrite the breadcrumbs block and add a hardcoded crumb at the beginning without modifying the template. Note: Do not use the _toHtml() method to implement this customization.

Create a frontend widget with a JavaScript color picker form element and image upload functionality in the widget form. When rendering, the widget displays the image with a border of the chosen color.

ORM | Begriffserklärung

ORM (Object Relational Mapping)
model
resource model
collection model

NACH UNTEN
A “model” is used to store data, and perhaps performs some business logics against that data.
A “resource model” is used to interact with the database on behalf of the “model”. The “resource model” actually performs the CRUD operations.
A “collection model” holds from one to many “models” and knows how to tell the “resource model” to get rows in the basis of information it is given.
There’s a basic ActiveRecord-like/one-object-one-table Model, and there’s also an Entity Attribute Value (EAV) Model.
http://www.magentocommerce.com/knowledge-base/entry/magento-for-dev-part-5-magento-models-and-orm-basics

Datenbanken

database connection

Datenbanken

basic operations

$model->getData();
$model->getData('title');
$model->getOrigData();
$model->getOrigData('title');
$model->getModelId();
$model->setModelId(42);
$model->unsetModelId();
if($model->hasModelId()){...}

Datenbanken

CRUD

$model = Mage::getModel('foo/bar');
$model->load(ID);
$model->setFnord("Data String");
$model->save();
-----
$model->delete();

Datenbanken

Collections

grouped operations
filtering
sorting

Setup Scripte

sql-Datei
Versionierungsstruktur

Setup Scripte

            $installer = $this;
$installer->startSetup();
$installer->run("SQL HIER");
$installer->endSetup();

neue Hausaufgaben!

für Session 6:

Create a custom entity table for comments using a setup script.

Create a comments entity model, flat table resource model, and a matching resource collection model.

Create a data upgrade script that uses the comments model classes to populate the database.

Create a frontend form block that allows visitors to add comments to category and product pages.

Use the _beforeSave() method to automatically set the associated page and an updated_at timestamp on the comment records.

Magento Developer Certification Preparation Study Group

Session Four

Was?

Wer?

Locationcation

Ablauf

Was machen wir denn heute Schönes?

Hausaufgaben!

ORM | Begriffserklärung

Datenbanken

database connection

Datenbanken

basic operations

Datenbanken

CRUD

Datenbanken

Collections

Setup Scripte

Setup Scripte

neue Hausaufgaben!

für Session 6:

Sonstiges

Quellen && nützliche Links

Magento

Danke!