Stored Procedures in Omnis Library

Hi Alan,

I would go for 4) and store the stored procedure in a text file. The advantage is, you can develop the workflow completely independently of Omnis, and ensure everything works. With regard to security, store an SHA1 checksum in your app of the file, and you only use the stored procedure if the checksum matches that of the file. Or are you bothered the customer or someone else will see the SQL in the stored procedure?

Regards

Rudolf

—–Ursprüngliche Nachricht—–
Von: omnisdev-en [mailto:omnisdev-en-bounces@lists.omnis-dev.com] Im Auftrag von Alan Grinberg
Gesendet: Freitag, 3. November 2017 16:34
An: OmnisDev List – English <omnisdev-en@lists.omnis-dev.com>
Betreff: Stored Procedures in Omnis Library

Hello all,

Using Postgres and Studio 6.

We have some complex stored procedures that we want to set up in a new PG database.
No problem doing this with PG Admin (and using Razor, too).

We want to put this code in our Omnis library so the user can trigger it when a new database is created.

The SQL is a large block of static text. (50+ lines)

What is the preferred way of storing this in the library?

3 ideas so far:
1. STA: (too cumbersome, SQL is already written)
2. Copy text to an object method as comments, then extract the leading semi-colons
3. Store the SQL in a record in the database by copy/paste (but requires our intervention)
4. Read from a text file (not secure)

Any ideas out there?

Thanks,
Alan

Sorry I missed the conference. Sounds great.

—————————————————-
Alan Grinberg
AG Systems/ZOO-INK
San Francisco, CA

www.zoo-ink.com <applewebdata://E01F3E44-AB72-4A7B-A459-57C700E4EAEF>
www.perfectfit.net
alan@perfectfit.net
—————————————————-

_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com