return $infos;
}
+
+ /**
+ * Handle sequence on PostgreSQL
+ *
+ * When inserting a value on a field with a sequence,
+ * this one is not incremented.
+ * This happens when installing system values (for status, titles, ...)
+ *
+ * @see https://bugs.galette.eu/issues/1158
+ * @see https://bugs.galette.eu/issues/1374
+ *
+ * @param sting $table Table name
+ * @param intger $expected Expected value
+ *
+ * @return void
+ */
+ public function handleSequence($table, $expected)
+ {
+ if ($this->isPostgres()) {
+ //check for Postgres sequence
+ //see https://bugs.galette.eu/issues/1158
+ //see https://bugs.galette.eu/issues/1374
+ $seq = $table . '_id_seq';
+
+ $select = $this->select($seq);
+ $select->columns(['last_value']);
+ $results = $this->execute($select);
+ $result = $results->current();
+ if ($result->last_value < $expected) {
+ $this->db->query(
+ 'SELECT setval(\'' . PREFIX_DB . $seq . '\', ' . $expected . ')',
+ Adapter::QUERY_MODE_EXECUTE
+ );
+ }
+ }
+ }
}
$insert->values($values);
$stmt = $this->zdb->sql->prepareStatementForSqlObject($insert);
- if ($this->zdb->isPostgres()) {
- //check for Postgres sequence
- //see https://bugs.galette.eu/issues/1158
- $expected = count(static::$defaults);
- $seq = $this->table . '_id_seq';
-
- $select = $this->zdb->select($seq);
- $select->columns(['last_value']);
- $results = $this->zdb->execute($select);
- $result = $results->current();
- if ($result->last_value < $expected) {
- $this->zdb->db->query(
- 'SELECT setval(\'' . PREFIX_DB . $seq . '\', ' . $expected . ')',
- Adapter::QUERY_MODE_EXECUTE
- );
- }
- }
+ $this->zdb->handleSequence(
+ $this->table,
+ count(static::$defaults)
+ );
$fnames = array_keys($values);
foreach ($class::$defaults as $d) {
--- /dev/null
+<?php
+
+/* vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4: */
+
+/**
+ * Titles tests
+ *
+ * PHP version 5
+ *
+ * Copyright © 2019 The Galette Team
+ *
+ * This file is part of Galette (http://galette.tuxfamily.org).
+ *
+ * Galette is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Galette is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with Galette. If not, see <http://www.gnu.org/licenses/>.
+ *
+ * @category Repository
+ * @package GaletteTests
+ *
+ * @author Johan Cwiklinski <johan@x-tnd.be>
+ * @copyright 2019 The Galette Team
+ * @license http://www.gnu.org/licenses/gpl-3.0.html GPL License 3.0 or (at your option) any later version
+ * @version SVN: $Id$
+ * @link http://galette.tuxfamily.org
+ * @since 2019-12-14
+ */
+
+namespace Galette\Entity\test\units;
+
+use \atoum;
+use Zend\Db\Adapter\Adapter;
+
+/**
+ * Status tests
+ *
+ * @category Entity
+ * @name Title
+ * @package GaletteTests
+ * @author Johan Cwiklinski <johan@x-tnd.be>
+ * @copyright 2019 The Galette Team
+ * @license http://www.gnu.org/licenses/gpl-3.0.html GPL License 3.0 or (at your option) any later version
+ * @link http://galette.tuxfamily.org
+ * @since 2019-12-14
+ */
+class Title extends atoum
+{
+ private $zdb;
+ private $remove = [];
+
+ /**
+ * Set up tests
+ *
+ * @param string $testMethod Calling method
+ *
+ * @return void
+ */
+ public function beforeTestMethod($testMethod)
+ {
+ $this->zdb = new \Galette\Core\Db();
+ }
+
+ /**
+ * Tear down tests
+ *
+ * @param string $testMethod Calling method
+ *
+ * @return void
+ */
+ public function afterTestMethod($testMethod)
+ {
+ $this->deleteTitle();
+ }
+
+ /**
+ * Delete status
+ *
+ * @return void
+ */
+ private function deleteTitle()
+ {
+ if (is_array($this->remove) && count($this->remove) > 0) {
+ $delete = $this->zdb->delete(\Galette\Entity\Title::TABLE);
+ $delete->where->in(\Galette\Entity\Title::PK, $this->remove);
+ $this->zdb->execute($delete);
+ }
+
+ //Clean logs
+ $this->zdb->db->query(
+ 'TRUNCATE TABLE ' . PREFIX_DB . \Galette\Core\History::TABLE,
+ \Zend\Db\Adapter\Adapter::QUERY_MODE_EXECUTE
+ );
+ }
+
+ /**
+ * Test title
+ *
+ * @return void
+ */
+ public function testTitle()
+ {
+ global $zdb;
+ $zdb = $this->zdb;
+
+ $titles = new \Galette\Repository\Titles($this->zdb);
+ if (count($titles->getList($this->zdb)) === 0) {
+ $res = $titles->installInit($this->zdb);
+ $this->boolean($res)->isTrue();
+ }
+
+ $title = new \Galette\Entity\Title();
+
+ $title->short = 'Te.';
+ $title->long = 'Test';
+ $this->boolean($title->store($this->zdb))->isTrue();
+
+ $id = $title->id;
+ $this->remove[] = $id;
+ $title = new \Galette\Entity\Title($id); //reload
+
+ $title->long = 'Test title';
+ $this->boolean($title->store($this->zdb))->isTrue();
+ $title = new \Galette\Entity\Title($id); //reload
+
+ $this->string($title->long)->isIdenticalTo('Test title');
+
+ $title = new \Galette\Entity\Title(\Galette\Entity\Title::MR);
+ $this->exception(
+ function () use ($title) {
+ $title->remove($this->zdb);
+ }
+ )
+ ->hasMessage('You cannot delete Mr. or Mrs. titles!')
+ ->isInstanceOf('\RuntimeException');
+
+ $title = new \Galette\Entity\Title($id); //reload
+ $this->boolean(
+ $title->remove($this->zdb)
+ )->isTrue();
+ }
+}