ygrek / sqlgg

SQL Guided (code) Generator
https://ygrek.org/p/sqlgg/
GNU General Public License v2.0
62 stars 20 forks source link

Stored procedure handling #37

Closed rgrinberg closed 8 years ago

rgrinberg commented 8 years ago

Currently a definition of a stored procedure will make the sqlgg generator error out. For example, consider the following stored proc in postgres:

CREATE OR REPLACE FUNCTION increment(i INT) RETURNS INT AS $$
BEGIN
    RETURN i + 1;
END;
$$ LANGUAGE plpgsql;

It would be good if sqlgg could skip out on definitions like this it doesn't understand.

I would be extremely good if sqlgg could generate typed bindings for stored procs.