<?php
/* $Id$ */ /* generated file, do not modify */
namespace MCMS\Service;

(defined('MCMS') && (basename(__FILE__) != basename($_SERVER['PHP_SELF']))) or die('ACCESS DENIED');

use MCMS\System;

/**
 * @ignore
 */
abstract class ContentSvcBase extends \Mammut\StrictObject {
	/**
	 * Stores/updates a 'Content' entry.
	 *
	 * Update is done if no row matching row for the following fields is found: id
	 *
	 * @return \MCMS\Model\Content the stored entry 
	 */
	public static function storeContent(\MCMS\Model\Content $c) {
		$db = System::getInstance()->getDB();
		
		$db->isTransactionSupported() and $db->startTransaction();
		$keyfields = ['id' => $c->id];
		$oldSearch = $db->table('contents')->select($keyfields);
		$doUpdate = $oldSearch->getRowCount() > 0;
		$oldSearch->close();
		unset($oldSearch);
		
		// transient fields and sequence fields needs to be excluded
		$ignore = ['id'];
		
		if ($doUpdate) {
			$db->table('contents')->update($c, ['id' => $c->id], $ignore);
		}
		else {
			$db->table('contents')->insert($c, $ignore);
			$c->id = $db->getInsertId('id');
		}
		$db->isTransactionSupported() and $db->commit();
		return $c;
	}
	/**
	 * Fetches an entry
	 *
	 * @return \MCMS\Model\Content the stored entry 
	 */
	public static function getContent($id) {
		$db = System::getInstance()->getDB();
		$_class = '\\MCMS\\Model\\Content';
		
		$result = $db->table('contents')->getObject(['id' => $id], false, $_class);
		
		return $result;
	}
	/**
	 * Deletes an entry
	 */
	public static function removeInstance(\MCMS\Model\Content $c) {
		$db = System::getInstance()->getDB();
		
		$db->isTransactionSupported() and $db->startTransaction();
		
		$db->table('contents')->delete(['id' => $c->id]);
		
		$db->isTransactionSupported() and $db->commit();
	}
}