Postgre.SQL module for MTA-SA

Description

Simple module for MTA that provides Postgre.SQL client API.
I accept any support regarding the module development. Feel free to make PRs and Issues.

Installation

Information about Installation provided on the Releases page.

Functions

pg_conn function

Syntax

userdatapg_conn(stringconnection)

Description

Attempts to make connection with your Postgre.SQL server.

Parameters

string connection - connection query string.
Might look like:

• postgresql://USER:PASSWORD@IP:PORT/dbname?connect_timeout=3
• hostaddr=IP port=5432 dbname=DBNAME user=USERNAME password=PASSWORD

Return value

If the connection attempt is successfull, the function returns connection handle.
On the failure, the function returns 2 values:

• false (bool)
• Error message (string)

Example of usage

localconn,err=pg_conn("postgresql://user:123qwe@127.0.03:5432/mydb?connect_timeout=3"); if (err~=nil) thenprint(err)
return1;
end

pg_query function

Syntax

userdatapg_query(userdataconnection, stringquery)

Description

Sends query to the Postgre.SQL server with provided data. String escaping supports as well.

Parameters

userdata connection - connection handle (see pg_conn).
string query - query to send to the Postgre.SQL server.

Return value

If query was sent successfully, the function returns userdata with the query result handle.
On the failure, the function returns 2 values:

• false (bool)
• Error message (string)

Example of usage

localquery,qerr=pg_query(conn, "SELECT $1 as a, $2 as b", -67, 2)
if (query==false) theniprint(qerr)
end

pg_poll function

Syntax

tablepg_poll(userdataquery)	

Description

Gets the data from the query result handle.

Parameters

userdata query - query result handle (see pg_query).

Return value

On the success, the function returns a table.
On the failure, the function returns 1 value:

• false (bool)

Example of usage

localquery,qerr=pg_query(conn, "SELECT $1 as a, $2 as b", -67, 2)
if (query==false) theniprint(qerr)
endiprint(pg_poll(query));

pg_free function

Syntax

boolpg_free(userdataquery)

Description

Frees memory after executing the query (in case it didn't happen before).

Parameters

userdata query - query result handle (see pg_query).

Return value

If the query result handle is valid, the function returns true (bool).
Otherwise the function returns false (bool).

Example of usage

localquery,qerr=pg_query(conn, "SELECT $1 as a, $2 as b", -67, 2)
pg_free(query)

pg_exec function

Syntax

boolpg_exec(userdataconnection, stringquery)

Description

Sends query to the Postgre.SQL server, except it doesn't return any data like pg_query.

Parameters

userdata connection - connection handle (see pg_conn).
string query - query to send to the Postgre.SQL server.

Return value

If query was successfully sent, the function returns userdata with the query result handle.
On the failure, the function returns 2 values:

• false (bool)
• Error message (string)

Example of usage

localexec=pg_exec(conn, "INSERT INTO users (name, password, money) VALUES ($1,$2,$3)", "a man", "mypasswd", "13");
iprint(exec);

pg_close function

Syntax

boolpg_close(userdataconnection)

Description

Closes connection with the Posgre.SQL server.

Parameters

userdata connection - connection handle (see pg_conn).

Return value

If connection was closed successfully, the function returns true (bool).
On the failure, the function returns false (bool).

Example of usage

localconn,err=pg_conn("postgresql://user:123qwe@127.0.03:5432/mydb?connect_timeout=3");
... (somecodehere)
pg_close(conn);