Extension:AccessPostgres

MediaWiki extensions manual - list

AccessPostgres Release status: stable
Implementation	Database, Parser function
Description	Connects to a Postgres database and retrieves data with select directly into an article or to write data into the database with insert and update respectively.
Author(s)	Martina Mostert (MarMosTalk)
Last version	1.3 (2011-09-01)
MediaWiki	1.9.3 or later
License	GPL
Download	[1]
Hooks used ArticleSaveComplete EditPage::attemptSave
Check usage (experimental)

What can this extension do?

With this extension you can connect to a Postgres database and retrieve data with select directly into an article or write data into the database with insert and update respectively. You may also delete data from the database.

Usage

The following extension functions are available.

Hint: All functions that perform a select use the user registered as $egOwlApUser using the password in $egOwlApPasswordGet (see #Configuration parameters). For insert and update the wiki user is used (password $egOwlApPassword).

#apGetValue

Retrieves one single column from a table under specification of a search key. If the result consists of more than one value, the values are connected comma separated. The result is given as wikitext.

     {{#apGetValue:‹table›|‹column›|‹key›|‹key value›}}

Parameters:

table

name of the table you want to receive data from

column

name of the column containing the result

key

name of the column containing the search key

key value

value to search for

#apGetMValues

Retrieves any number of columns from a table under specification of a search key. The result is put into an array and returned as wikitext.

     {{#apGetMValues:‹table›|‹key›|‹key value›|‹column1›|...|‹columnn›}}

Parameters:

table

name of the table you want to receive data from

key

name of the column containing the search key

key value

value to search for

column₁...column_n

names of the columns you want to retrieve

#apGetTable

Retrieves any number of columns and all rows from a table. .

     {{#apGetTable:‹table›|‹column1›|...|‹columnn›}}

Parameters:

table

name of the table you want to receive data from

column₁...column_n

names of the columns you want to retrieve

#apGetLine

Retrieves any number of columns from a table under specification of a search key. .

     {{#apGetLine:‹table›|‹key›|‹key value›|‹column1›|...|‹columnn›}}

Parameters:

table

name of the table you want to receive data from

key

name of the column containing the search key

key value

value to search for

column₁...column_n

names of the columns you want to retrieve

#apCreateEntry

Inserts a new record with any number of columns and a key column into a table. If there exists already a record with the given key value an update is performed instead.

     {{#apCreateEntry:‹table›|‹key›|‹key value›|‹column1›|‹value1›|...|‹columnn›|‹valuen›}}

Parameters:

table

name of the table you want to insert data into

key

name of the column containing the search key

key value

value for the key

column₁...column_n

names of the columns you want to insert data into

value₁..‹value_n

values you want to insert into the columns

#apUpdateMValues

Updates any number of columns under specification of a search key.

     {{#apUpdateMValues:‹table›|‹key›|‹key value›|‹column1›|‹value1›|...| ‹columnn›|‹valuen›}}

Parameters:

table

name of the table you want to update

key

name of the column containing the search key

key value

value to search for

column₁...column_n

names of the columns you want to update

value₁..‹value_n

new values for the columns

#apUpdatePValue

Updates a column under specification of two search keys.

     {{#apUpdatePValue:‹table›|‹key1›|‹key value1›|‹key2›|‹key value2›|‹column›|‹value›}}

Parameters:

table

name of the table you want to update

key₁

name of the column containing the first search key

key value₁

first value to search for

key₂

name of the column containing the second search key

key value₂

second value to search for

column

name of the column you want to update

value

new value for the column

#apAddValue

Inserts a new record with two columns (index and value) into a table.

     {{#apAddValue:‹table›|‹key›|‹key value›|‹column›|‹value›}}

Parameters:

table

name of the table you want to insert data into

key

name of the column containing the search key

key value

value for the key

column

name of the column you want to insert data into

value

value you want to insert into the column

#apDeletePEntry

Deletes a record from a table under specification of a key value and another search key.

     {{#apDeletePEntry:‹table›|‹key1›|‹key value1›|‹key2›|‹key value2›}} 

Parameters:

table

name of the table you want to delete data from

key₁

name of the column containing the first search key

key value₁

first value to search for

key₂

name of the column containing the second search key

key value₂

second value to search for

Note:

i.e. you receive <tr><td>''data''</td><td>''data''</td>...</tr>. The rest of the table has to be put "around" the function call, e.g.

<table>
<th>Heading1</th>
<th>Heading2</th>
<th>Heading3</th>
{{#apGetLine:tablename|...}}
</table>

Download instructions

Download the code and unzip it into $IP/extensions/AccessPostgres. Note: $IP stands for the root directory of your MediaWiki installation, the same directory that holds LocalSettings.php.

Installation

To install this extension, add the following to LocalSettings.php:

#add configuration parameters here
#setup user rights here
require_once("$IP/extensions/AccessPostgres/AccessPostgres.php");

Configuration parameters

Insert the appropriate values for $egOwlApHost, $egOwlApDBName, $egOwlApUser, $egOwlApPassword and $egOwlApSearchPath in file $IP/extensions/AccessPostgres/AccessPostgres.phpy

* $egOwlApHost: name of the host on which Postgres is running - if left empty, a unix socket is used (localhost)
* $egOwlApDBName: name of the postgres database to connect to
* $egOwlApUser: user for select queries
* $egOwlApPassword: password for queries except select
* $egOwlApPasswordGet:  password of $egOwlApUser
* $egOwlApSearchPath: search path for the database