pg.exp.php
Ce fichier contient les fonctions gerant les instructions SQL pour PostgreSQL
Table of Contents
Constants
- _DEFAULT_DB = 'spip'
Functions
- req_pg_dist() : mixed
- spip_pg_trace_query() : mixed
- spip_pg_query() : mixed
- spip_pg_query_simple() : mixed
- spip_pg_ajouter_champs_timestamp() : mixed
- spip_pg_alter() : mixed
- spip_pg_alter_change() : mixed
- spip_pg_alter_add() : mixed
- spip_pg_alter_drop() : mixed
- spip_pg_alter_modify() : mixed
- spip_pg_alter_rename() : mixed
- spip_pg_create_index() : bool
- Fonction de creation d'un INDEX
- spip_pg_explain() : mixed
- spip_pg_selectdb() : bool|string
- Sélectionne une base de données
- spip_pg_listdbs() : mixed
- spip_pg_select() : mixed
- spip_pg_from() : mixed
- spip_pg_orderby() : mixed
- spip_pg_groupby() : mixed
- spip_pg_frommysql() : mixed
- spip_pg_fromfield() : mixed
- calculer_pg_where() : mixed
- calculer_pg_expression() : mixed
- spip_pg_select_as() : mixed
- spip_pg_fetch() : mixed
- spip_pg_seek() : mixed
- spip_pg_countsel() : mixed
- spip_pg_count() : mixed
- spip_pg_free() : mixed
- spip_pg_delete() : mixed
- spip_pg_insert() : mixed
- spip_pg_insertq() : mixed
- spip_pg_insertq_multi() : mixed
- spip_pg_update() : mixed
- spip_pg_updateq() : mixed
- spip_pg_replace() : mixed
- spip_pg_replace_multi() : mixed
- spip_pg_sequence() : mixed
- spip_pg_cite() : mixed
- spip_pg_hex() : mixed
- spip_pg_quote() : mixed
- spip_pg_date_proche() : mixed
- spip_pg_in() : mixed
- spip_pg_error() : mixed
- spip_pg_errno() : mixed
- spip_pg_drop_table() : mixed
- spip_pg_drop_view() : mixed
- spip_pg_showbase() : ressource
- Retourne une ressource de la liste des tables de la base de données
- spip_pg_showtable() : mixed
- spip_pg_create() : mixed
- spip_pg_create_base() : mixed
- spip_pg_create_view() : mixed
- spip_pg_set_connect_charset() : mixed
- spip_pg_optimize() : bool|string
- Optimise une table SQL
- spip_pg_multi() : mixed
- mysql2pg_type() : mixed
- spip_versions_pg() : mixed
Constants
_DEFAULT_DB
public
mixed
_DEFAULT_DB
= 'spip'
Functions
req_pg_dist()
req_pg_dist(mixed $addr, mixed $port, mixed $login, mixed $pass[, mixed $db = '' ][, mixed $prefixe = '' ]) : mixed
Parameters
- $addr : mixed
- $port : mixed
- $login : mixed
- $pass : mixed
- $db : mixed = ''
- $prefixe : mixed = ''
spip_pg_trace_query()
spip_pg_trace_query(mixed $query[, mixed $serveur = '' ]) : mixed
Parameters
- $query : mixed
- $serveur : mixed = ''
spip_pg_query()
spip_pg_query(mixed $query[, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $query : mixed
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_query_simple()
spip_pg_query_simple(mixed $link, mixed $query) : mixed
Parameters
- $link : mixed
- $query : mixed
spip_pg_ajouter_champs_timestamp()
spip_pg_ajouter_champs_timestamp(mixed $table, mixed $couples[, mixed $desc = '' ][, mixed $serveur = '' ]) : mixed
Parameters
- $table : mixed
- $couples : mixed
- $desc : mixed = ''
- $serveur : mixed = ''
spip_pg_alter()
spip_pg_alter(mixed $query[, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $query : mixed
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_alter_change()
spip_pg_alter_change(mixed $table, mixed $arg[, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $table : mixed
- $arg : mixed
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_alter_add()
spip_pg_alter_add(mixed $table, mixed $arg[, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $table : mixed
- $arg : mixed
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_alter_drop()
spip_pg_alter_drop(mixed $table, mixed $arg[, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $table : mixed
- $arg : mixed
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_alter_modify()
spip_pg_alter_modify(mixed $table, mixed $arg[, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $table : mixed
- $arg : mixed
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_alter_rename()
spip_pg_alter_rename(mixed $table, mixed $arg[, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $table : mixed
- $arg : mixed
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_create_index()
Fonction de creation d'un INDEX
spip_pg_create_index(string $nom, string $table, mixed $champs[, string $serveur = '' ][, bool $requeter = true ]) : bool
Parameters
- $nom : string
-
: nom de l'index
- $table : string
-
: table sql de l'index
- $champs : mixed
- $serveur : string = ''
-
: nom de la connexion sql utilisee
- $requeter : bool = true
-
: true pour executer la requete ou false pour retourner le texte de la requete
Return values
bool —ou requete
spip_pg_explain()
spip_pg_explain(mixed $query[, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $query : mixed
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_selectdb()
Sélectionne une base de données
spip_pg_selectdb(string $db[, string $serveur = '' ][, bool $requeter = true ]) : bool|string
Parameters
- $db : string
-
Nom de la base à utiliser
- $serveur : string = ''
-
Nom du connecteur
- $requeter : bool = true
-
Inutilisé
Return values
bool|string —- Nom de la base en cas de succès.
- False en cas d'erreur.
spip_pg_listdbs()
spip_pg_listdbs(mixed $serveur) : mixed
Parameters
- $serveur : mixed
spip_pg_select()
spip_pg_select(mixed $select, mixed $from[, mixed $where = '' ][, mixed $groupby = [] ][, mixed $orderby = '' ][, mixed $limit = '' ][, mixed $having = '' ][, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $select : mixed
- $from : mixed
- $where : mixed = ''
- $groupby : mixed = []
- $orderby : mixed = ''
- $limit : mixed = ''
- $having : mixed = ''
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_from()
spip_pg_from(mixed $from, mixed $prefixe) : mixed
Parameters
- $from : mixed
- $prefixe : mixed
spip_pg_orderby()
spip_pg_orderby(mixed $order, mixed $select) : mixed
Parameters
- $order : mixed
- $select : mixed
spip_pg_groupby()
spip_pg_groupby(mixed $groupby, mixed $from, mixed $select) : mixed
Parameters
- $groupby : mixed
- $from : mixed
- $select : mixed
spip_pg_frommysql()
spip_pg_frommysql(mixed $arg) : mixed
Parameters
- $arg : mixed
spip_pg_fromfield()
spip_pg_fromfield(mixed $arg) : mixed
Parameters
- $arg : mixed
calculer_pg_where()
calculer_pg_where(mixed $v) : mixed
Parameters
- $v : mixed
calculer_pg_expression()
calculer_pg_expression(mixed $expression, mixed $v[, mixed $join = 'AND' ]) : mixed
Parameters
- $expression : mixed
- $v : mixed
- $join : mixed = 'AND'
spip_pg_select_as()
spip_pg_select_as(mixed $args) : mixed
Parameters
- $args : mixed
spip_pg_fetch()
spip_pg_fetch(mixed $res[, mixed $t = '' ][, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $res : mixed
- $t : mixed = ''
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_seek()
spip_pg_seek(mixed $r, mixed $row_number[, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $r : mixed
- $row_number : mixed
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_countsel()
spip_pg_countsel([mixed $from = [] ][, mixed $where = [] ][, mixed $groupby = [] ][, mixed $having = [] ][, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $from : mixed = []
- $where : mixed = []
- $groupby : mixed = []
- $having : mixed = []
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_count()
spip_pg_count(mixed $res[, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $res : mixed
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_free()
spip_pg_free(mixed $res[, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $res : mixed
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_delete()
spip_pg_delete(mixed $table[, mixed $where = '' ][, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $table : mixed
- $where : mixed = ''
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_insert()
spip_pg_insert(mixed $table, mixed $champs, mixed $valeurs[, mixed $desc = [] ][, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $table : mixed
- $champs : mixed
- $valeurs : mixed
- $desc : mixed = []
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_insertq()
spip_pg_insertq(mixed $table[, mixed $couples = [] ][, mixed $desc = [] ][, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $table : mixed
- $couples : mixed = []
- $desc : mixed = []
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_insertq_multi()
spip_pg_insertq_multi(mixed $table[, mixed $tab_couples = [] ][, mixed $desc = [] ][, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $table : mixed
- $tab_couples : mixed = []
- $desc : mixed = []
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_update()
spip_pg_update(mixed $table, mixed $couples[, mixed $where = '' ][, mixed $desc = '' ][, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $table : mixed
- $couples : mixed
- $where : mixed = ''
- $desc : mixed = ''
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_updateq()
spip_pg_updateq(mixed $table, mixed $couples[, mixed $where = '' ][, mixed $desc = [] ][, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $table : mixed
- $couples : mixed
- $where : mixed = ''
- $desc : mixed = []
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_replace()
spip_pg_replace(mixed $table, mixed $values, mixed $desc[, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $table : mixed
- $values : mixed
- $desc : mixed
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_replace_multi()
spip_pg_replace_multi(mixed $table, mixed $tab_couples[, mixed $desc = [] ][, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $table : mixed
- $tab_couples : mixed
- $desc : mixed = []
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_sequence()
spip_pg_sequence(mixed $table[, mixed $raw = false ]) : mixed
Parameters
- $table : mixed
- $raw : mixed = false
spip_pg_cite()
spip_pg_cite(mixed $v, mixed $t) : mixed
Parameters
- $v : mixed
- $t : mixed
spip_pg_hex()
spip_pg_hex(mixed $v) : mixed
Parameters
- $v : mixed
spip_pg_quote()
spip_pg_quote(mixed $v[, mixed $type = '' ]) : mixed
Parameters
- $v : mixed
- $type : mixed = ''
spip_pg_date_proche()
spip_pg_date_proche(mixed $champ, mixed $interval, mixed $unite) : mixed
Parameters
- $champ : mixed
- $interval : mixed
- $unite : mixed
spip_pg_in()
spip_pg_in(mixed $val, mixed $valeurs[, mixed $not = '' ][, mixed $serveur = '' ]) : mixed
Parameters
- $val : mixed
- $valeurs : mixed
- $not : mixed = ''
- $serveur : mixed = ''
spip_pg_error()
spip_pg_error([mixed $query = '' ][, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $query : mixed = ''
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_errno()
spip_pg_errno([mixed $serveur = '' ]) : mixed
Parameters
- $serveur : mixed = ''
spip_pg_drop_table()
spip_pg_drop_table(mixed $table[, mixed $exist = false ][, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $table : mixed
- $exist : mixed = false
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_drop_view()
spip_pg_drop_view(mixed $view[, mixed $exist = false ][, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $view : mixed
- $exist : mixed = false
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_showbase()
Retourne une ressource de la liste des tables de la base de données
spip_pg_showbase(string $match[, string $serveur = '' ][, bool $requeter = true ]) : ressource
Parameters
- $match : string
-
Filtre sur tables à récupérer
- $serveur : string = ''
-
Connecteur de la base
- $requeter : bool = true
-
true pour éxecuter la requête false pour retourner le texte de la requête.
Return values
ressource —Ressource à utiliser avec sql_fetch()
spip_pg_showtable()
spip_pg_showtable(mixed $nom_table[, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $nom_table : mixed
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_create()
spip_pg_create(mixed $nom, mixed $champs, mixed $cles[, mixed $autoinc = false ][, mixed $temporary = false ][, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $nom : mixed
- $champs : mixed
- $cles : mixed
- $autoinc : mixed = false
- $temporary : mixed = false
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_create_base()
spip_pg_create_base(mixed $nom[, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $nom : mixed
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_create_view()
spip_pg_create_view(mixed $nom, mixed $query_select[, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $nom : mixed
- $query_select : mixed
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_set_connect_charset()
spip_pg_set_connect_charset(mixed $charset[, mixed $serveur = '' ][, mixed $requeter = true ]) : mixed
Parameters
- $charset : mixed
- $serveur : mixed = ''
- $requeter : mixed = true
spip_pg_optimize()
Optimise une table SQL
spip_pg_optimize(string $table[, string $serveur = '' ][, bool $requeter = true ]) : bool|string
Parameters
- $table : string
-
nom de la table a optimiser
- $serveur : string = ''
-
nom de la connexion
- $requeter : bool = true
-
effectuer la requete ? sinon retourner son code
Return values
bool|string —true / false / requete
spip_pg_multi()
spip_pg_multi(mixed $objet, mixed $lang) : mixed
Parameters
- $objet : mixed
- $lang : mixed
mysql2pg_type()
mysql2pg_type(mixed $v) : mixed
Parameters
- $v : mixed
spip_versions_pg()
spip_versions_pg() : mixed