1<?php 2/** 3 * @author Bart Visscher <bartv@thisnet.nl> 4 * @author Morris Jobke <hey@morrisjobke.de> 5 * 6 * @copyright Copyright (c) 2018, ownCloud GmbH 7 * @license AGPL-3.0 8 * 9 * This code is free software: you can redistribute it and/or modify 10 * it under the terms of the GNU Affero General Public License, version 3, 11 * as published by the Free Software Foundation. 12 * 13 * This program is distributed in the hope that it will be useful, 14 * but WITHOUT ANY WARRANTY; without even the implied warranty of 15 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 16 * GNU Affero General Public License for more details. 17 * 18 * You should have received a copy of the GNU Affero General Public License, version 3, 19 * along with this program. If not, see <http://www.gnu.org/licenses/> 20 * 21 */ 22 23namespace OC\DB; 24 25class AdapterPgSql extends Adapter { 26 public function lastInsertId($table) { 27 return $this->conn->fetchColumn('SELECT lastval()'); 28 } 29 30 public const UNIX_TIMESTAMP_REPLACEMENT = 'cast(extract(epoch from current_timestamp) as integer)'; 31 public function fixupStatement($statement) { 32 $statement = \str_replace('`', '"', $statement); 33 $statement = \str_ireplace('UNIX_TIMESTAMP()', self::UNIX_TIMESTAMP_REPLACEMENT, $statement); 34 return $statement; 35 } 36} 37