���ѧۧݧ�ӧ�� �ާ֧ߧ֧էا֧� - ���֧էѧܧ�ڧ��ӧѧ�� - /home/alphpwcp/public_html/us/alphachat/ezcomponents/Database/src/sqlabstraction/implementations/utilities_pgsql.php
���ѧ٧ѧ�
<?php /** * File containing the ezcDbUtilities class. * * @package Database * @version 1.4.7 * @copyright Copyright (C) 2005-2010 eZ Systems AS. All rights reserved. * @license http://ez.no/licenses/new_bsd New BSD License * @access private */ /** * Various database methods. * * This implementation is postgreSQL specific. * * This class inherits most of its database handling functionality from * PDO ({@link http://php.net/PDO}) -- an object-oriented database abstraction * layer that is going to become a new standard for PHP applications. * * @package Database * @todo this class must be renamed * @access private * @version 1.4.7 */ class ezcDbUtilitiesPgsql extends ezcDbUtilities { /** * Constructs a new db util using the db handler $db. * * @param ezcDbHandler $db */ public function __construct( $db ) { parent::__construct( $db ); } /** * Remove all tables from the database. */ public function cleanup() { $this->db->beginTransaction(); // drop tables $rslt = $this->db->query( "SELECT tablename FROM pg_tables WHERE schemaname = 'public' AND tablename NOT LIKE 'pg_%'" ); $rslt->setFetchMode( PDO::FETCH_NUM ); $rows = $rslt->fetchAll(); unset( $rslt ); foreach ( $rows as $row ) { $table = $row[0]; $this->db->exec( "DROP TABLE $table" ); } // drop sequences $rslt = $this->db->query( "SELECT relname FROM pg_catalog.pg_class WHERE relkind='S'" ); $rslt->setFetchMode( PDO::FETCH_NUM ); $rows = $rslt->fetchAll(); foreach ( $rows as $row ) { $seq = $row[0]; $this->db->exec( "DROP SEQUENCE $seq" ); } // FIXME: drop triggers? $this->db->commit(); } } ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.30 | ���֧ߧ֧�ѧ�ڧ� ����ѧߧڧ��: 0 |
proxy
|
phpinfo
|
���ѧ����ۧܧ�