Model repositories and DB querying

Introduction

This article aims to teach developers how they can pull data from repositories by certain criteria.

For the sake of example, we will consider pulling product information and will work with \XLite\Model\Product models and their repository \XLite\Model\Repo\Product. You can work the same way with any other entities: categories, users, orders, etc.

Pulling product by ID

Repository method: find()

Code sample: 

$product = \XLite\Core\Database::getRepo('XLite\Model\Product')->find($id);

//$product now contains product object

Pulling all products

Repository method: findAll()

Code sample: 

$products = \XLite\Core\Database::getRepo('XLite\Model\Product')->findAll();

//$products now contains an array of product objects

Pulling one product by condition

Repository method: findOneBy()

Code sample:

// $condition defines what products exactly you want to pull.
// This condition defines that we need to pull all enabled products, 
// i.e. they all must have enabled field set as true.

$condition = array('enabled' => 1);

$product = \XLite\Core\Database::getRepo('XLite\Model\Product')->findOneBy($condition);

//$product now contains the very first enabled product

$product = \XLite\Core\Database::getRepo('XLite\Model\Product')->findOneBy(array('product_id' => $id));
// the same as $product = \XLite\Core\Database::getRepo('XLite\Model\Product')->find($id);

Pulling many products by condition

Repository method: findBy()

Code:

// $condition defines what products exactly you want to pull.
// This condition defines that we need to pull all enabled products, 
// i.e. they all must have enabled field set as true.

$condition = array('enabled' => 1);

$products = \XLite\Core\Database::getRepo('XLite\Model\Product')->findBy($condition);

//$products now contains array of product objects and all of these products are enabled 

Pulling products by complex condition

If you need more complex queries to the database, please learn how to use QueryBuilder object.