Mrthdrb

I'm trying to update a field in the database via my database model. All tutorials online about CRUD models seem to just show how to 'CR' and not showing examples of the 'UD'. My code so far:

namespace CompanyNameAdminMenuControllerAdminhtmlHomepageBanner;

class UpdatePosition extends MagentoFrameworkAppActionAction

protected $_postFactory;
protected $_httpRequest;
protected $_postResource;

public function __construct(
 MagentoFrameworkAppActionContext $context,
 MagentoFrameworkAppRequestHttp $httpRequest,
 CompanyNameAdminMenuModelPostFactory $postFactory,
 CompanyNameAdminMenuResourceModelPost $postResource
 )

 $this->_postFactory = $postFactory;
 $this->_postResource = $postResource;
 $this->_httpRequest = $httpRequest;
 return parent::__construct($context);


public function execute()

 $post = $this->$postFactory->create();

 $post->load(2, 'slide_position')->setId(22)->save();

 //$this->getConnection()->update('admincontentbanners_homepageslider_post', ['slide_position' => $data], ["slide_id = ?" => $slideID]);

Any advise would be appreciated..

This loads the specified model , which you want update .

public function execute()
 
 $post = $this->$postFactory->create();
 $id_post_update = 19; //Example

 $postUpdate = $post->load($id_post_update);
 $postUpdate->setSlidePosition(2);
 $postUpdate->setId(22);
 $postUpdate->save();
 

Evgeniy Kapelko approach works, but deprecated from Magento 2.1(with certain version I might be mistaken).

Below infromation from class, that was used in Evgeniy Kapelko approach, confirm info about deprecation vendor/magento/framework/Model/AbstractModel.php

/**
 * Save object data
 *
 * @return $this
 * @throws Exception
 *
 * @deprecated 100.1.0 because entities must not be responsible for their own persistence.
 * Service contracts should persist entities. Use resource model "save" to implement
 * service contract persistence operations.
 */
public function save()

 $this->_getResource()->save($this);
 return $this;

How correct to work with you model?

We need to use it like described in official documentation.

It can be little bit hard at the begging, but future code will be simple and clear.

In code below, we are going to update Shop entity name.

1) Create interface for you repository, with functions getById and save

<?php

namespace VendorModuleApi;

use VendorModuleApiDataShopInterface;

/**
 * Interface SampleInterface
 *
 * @package AcademyDatabaseApiData
 */
interface ShopRepositoryInterface


 /**
 * @param VendorModuleApiDataShopInterface $shopList
 *
 * @return mixed
 */
 public function save(ShopInterface $shopList);

 /**
 * @param int $id
 *
 * @return mixed
 */
 public function getById(int $id);

2) Implement interface in you repository and define functions

<?php

namespace VendorModuleModel;


use VendorModuleApiDataShopInterface;
use VendorModuleApiShopRepositoryInterface;
use VendorModuleModelResourceModelShop as ShopResource;
use MagentoFrameworkExceptionAlreadyExistsException;

class ShopRepository implements ShopRepositoryInterface


 /**
 * @var ShopFactory
 */
 private $shopList;
 /**
 * @var Shop
 */
 private $shopListResource;

 public function __construct(
 ShopFactory $shopList,
 ShopResource $shopListResource
 ) 
 $this->shopList = $shopList;
 $this->shopListResource = $shopListResource;
 

 /**
 * @param ShopInterface $shop
 *
 * @return void
 *
 * @throws AlreadyExistsException
 * @throws Exception
 */
 public function save(ShopInterface $shop)
 
 try 
 $this->shopListResource->save($shop);
 catch (AlreadyExistsException $e) 
 //catch exception
 catch (Exception $e) 
 //catch exception
 
 

 /**
 * @param int $shopId
 *
 * @return VendorModuleModelShop
 */
 public function getById(int $shopId)
 
 $shopListModel = $this->shopList->create();
 $this->shopListResource->load($shopListModel, $shopId);

 return $shopListModel;
 

3) Add Repository and RepositoryInterface to di.xml

<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd">
 <preference for="VendorModuleApiShopRepositoryInterface"
 type="VendorModuleModelShopRepository"/>
</config>

4) Start using it (i'm using it in controller)

 /**
 * @param ShopInterfaceFactory $shopListFactory
 * @param ShopRepositoryInterface $shopListRepository
 */
 public function __construct(
 VendorModuleApiDataShopInterfaceFactory $shopListFactory,
 VendorModuleApiShopRepositoryInterface $shopListRepository
 ) 
 $this->shopListFactory = $shopListFactory;
 $this->shopListRepository = $shopListRepository;
 

 public function execute()
 
 $shopId = 1;//use needed entity ID

 /**
 * Create entity
 *
 * @var Shop $shopList
 */
 $shopList = $this->shopListFactory->create();
 $shopList->setData(['name' => 'shop name']);
 $this->shopListRepository->save($shopList);

 /**
 * Read entity
 *
 * @var Shop $shopList
 */
 $shopList = $this->shopListRepository->getById($shopId);
 $shopData = $shopList->getData();//data of entity

 /**
 * Update entity
 *
 * @var Shop $shopList
 */
 $shopList = $this->shopListRepository->getById($shopId);
 $shopList->addData(['name' => 'bdn']);
 $this->shopListRepository->save($shopList);