終了済み

Convert simple oracle procedure to postgres

We want to be able to send SMS messages from a stored procedure in postgres. The procedure must of course use the correct syntax of our suppliers gateway:

The following url explains how to use our suppliers syntax from an oracle procedure:[

[url removed, login to view]][1]

This code snippet show how URL requests can be used in (untrusted) postgres procedures:

----------------------------------

CREATE OR REPLACE FUNCTION reindex_by_uid (text) RETURNS text as '

$uid = shift;

# Auth required to run PythonScript w/right role

# or, dont pass auth stuff and make PyScript proxied to role

$AUTH = "--http-user=joel --http-passwd=foo";

# Set to your server and portal name

$SERVER = "http://localhost:8080/arch";

# wget options

# -q is quiet (no status output)

# -O - is to send results to standard output

# -T 5 is to timeout after 5 seconds

$WGET = "/usr/bin/wget -q -O - -T 5";

$cmd = "$WGET $AUTH $SERVER/reindex_by_uid?uid=$uid";

# output it to psql log so the user has some idea whats going on

elog NOTICE, $cmd;

return `$cmd`;

' LANGUAGE plperlu;

----------------------------------

For more info, see <[url removed, login to view]>

Best regards,

Magnus

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Postgres

スキル: データベース管理, エンジニアリング, MySQL, PHP, ソフトウェアアーキテクチャ, ソフトウェアテスト, SQL

さらに表示: working for oracle, syntax of package in oracle, procedure and function in oracle, postgres hire a coder, package procedure oracle, package and procedure in oracle, oracle standard package, oracle for hire, oracle com, magnus software, html 5 syntax, downloads site html 5, how to copyright an idea, postgres, oracle net, oracle install, Oracle functional , oracle course, joel, arch

採用者について:
( 73件のレビュー ) Norway

プロジェクトID: #3907640

2人のフリーランサーが、このジョブに平均$128で入札しています

skunkwrks

See private message.

$191.25 USD 3日以内
(27件のレビュー)
5.3
erikgburrows

See private message.

$63.75 USD 3日以内
(0件のレビュー)
0.0