database migration SQL splitStatements

[basejump (Josh)]

How do I do the equivalent of this in groovy migration scripts.

<sql splitStatements="false">
      DECLARE
        cursor c_newviews is
          select table_name
          from user_tables
          where table_name like 'DATABASECHANGELOG%'
          AND table_name||'_VW' not in
            (select view_name from user_views);
      BEGIN
        FOR r_newviews in c_newviews LOOP
          EXECUTE IMMEDIATE
            'CREATE VIEW ' || r_newviews.table_name || '_VW ' ||
            'AS SELECT * FROM ' || r_newviews.table_name;
        END LOOP;
      END;
    </sql>


I tried
sql(splitStatements:false, stmt)
but it still seems to be splitting them up


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

[basejump (Josh)]

ended up using
createProcedure("""
        long sql here
""")
http://www.liquibase.org/manual/create_stored_procedure
and it works fine.

On Jun 12, 2012, at 2:28 PM, Josh (basejump) wrote:

> How do I do the equivalent of this in groovy migration scripts.
>
> <sql splitStatements="false">
>      DECLARE
>        cursor c_newviews is
>          select table_name
>          from user_tables
>          where table_name like 'DATABASECHANGELOG%'
>          AND table_name||'_VW' not in
>            (select view_name from user_views);
>      BEGIN
>        FOR r_newviews in c_newviews LOOP
>          EXECUTE IMMEDIATE
>            'CREATE VIEW ' || r_newviews.table_name || '_VW ' ||
>            'AS SELECT * FROM ' || r_newviews.table_name;
>        END LOOP;
>      END;
>    </sql>
>
>
> I tried
> sql(splitStatements:false, stmt)
> but it still seems to be splitting them up
>

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email