com php-src: Remove example file for pgsql extension: ext/pgsql/mysql_users.php
| From: | Peter Kokot | Date: | Mon, 13 May 2019 20:14:58 +0000 |
| Subject: | com php-src: Remove example file for pgsql extension: ext/pgsql/mysql_users.php | ||
| Groups: | php.cvs | ||
| Request: | Send a blank email to php-cvs+get-106169@lists.php.net to get a copy of this message | ||
Commit: da293a8ec41871ec890663593e320436becf2e7f
Author: Peter Kokot <peterkokot@gmail.com> Mon, 13 May 2019 22:14:58 +0200
Parents: 5036c293b3cd3fa7988d950840466f7d3fa69ea6
Branches: PHP-7.4 master
Link: http://git.php.net/?p=php-src.git;a=commitdiff;h=da293a8ec41871ec890663593e320436becf2e7f
Log:
Remove example file for pgsql extension
This removes the example script in favour of the manual:
https://www.php.net/manual/en/book.pgsql.php
Patch for integrating these functions as an example has been submitted
also to PHP manual via edit.php.net.
Changed paths:
D ext/pgsql/mysql_users.php
Diff:
diff --git a/ext/pgsql/mysql_users.php b/ext/pgsql/mysql_users.php
deleted file mode 100644
index 44d4f1b..0000000
--- a/ext/pgsql/mysql_users.php
+++ /dev/null
@@ -1,82 +0,0 @@
-<?php
-/*
- * File: mysql_users.php
- * Author: Yasuo Ohgaki <yohgaki@php.net>
- *
- * This file contains example user defined functions that does
- * similar to MySQL functions. They can be implemented as module
- * functions, but there won't be many users need them.
- *
- * Requires: PostgreSQL 7.2.x
- */
-
-/*
- * mysql_list_dbs()
- *
- * This function should be needed, since PostgreSQL connection
- * binds database.
- */
-function pg_list_dbs($db)
-{
- assert(is_resource($db));
- $query = '
-SELECT
- d.datname as "Name",
- u.usename as "Owner",
- pg_encoding_to_char(d.encoding) as "Encoding"
-FROM
- pg_database d LEFT JOIN pg_user u ON d.datdba = u.usesysid
-ORDER BY 1;
-';
- return pg_query($db, $query);
-}
-
-
-/*
- * mysql_list_tables()
- */
-function pg_list_tables($db)
-{
- assert(is_resource($db));
- $query = "
-SELECT
- c.relname as \"Name\",
- CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view'
WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN
's' THEN 'special' END as \"Type\",
- u.usename as \"Owner\"
-FROM
- pg_class c LEFT JOIN pg_user u ON c.relowner = u.usesysid
-WHERE
- c.relkind IN ('r','v','S','')
- AND c.relname !~ '^pg_'
-ORDER BY 1;
-";
- return pg_query($db, $query);
-}
-
-/*
- * mysql_list_fields()
- *
- * See also pg_meta_data(). It returns field definition as array.
- */
-function pg_list_fields($db, $table)
-{
- assert(is_resource($db));
- $query = "
-SELECT
- a.attname,
- format_type(a.atttypid, a.atttypmod),
- a.attnotnull,
- a.atthasdef,
- a.attnum
-FROM
- pg_class c,
- pg_attribute a
-WHERE
- c.relname = '".$table."'
- AND a.attnum > 0 AND a.attrelid = c.oid
-ORDER BY a.attnum;
-";
- return pg_query($db, $query);
-}
-
-?>