[DBIx-Class-Devel] [dbsrgits/dbix-class-schema-loader] this patch allows us to extract DDL for materialized views for oracle (#25)

[kd]

I'd like some guidance about if this is the correct approach, and where I should look to get the `view_definition` to ingest the fuller materialised view ddl statement for example:

```
create materialized view mv_alternatives
refresh next trunc(sysdate + 1) + 6/24
as
    select  alts.identifier,
            count(*) as alternatives
    from    (
                select distinct(identifier) from item_alternate
                union all
                select distinct(identifier) from item_replacement
            ) alts
    group by alts.identifier
```
You can view, comment on, or merge this pull request online at:

  https://github.com/dbsrgits/dbix-class-schema-loader/pull/25

-- Commit Summary --

  * this patch allows us to extract DDL for materialized views ... The deploy part of the problem is unsolved as is oracle's schedule declaration

-- File Changes --

    M lib/DBIx/Class/Schema/Loader/DBI/Oracle.pm (22)

-- Patch Links --

https://github.com/dbsrgits/dbix-class-schema-loader/pull/25.patch
https://github.com/dbsrgits/dbix-class-schema-loader/pull/25.diff

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/dbsrgits/dbix-class-schema-loader/pull/25
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class-devel/attachments/20210909/4bf714a1/attachment.html>