rkolka

create table deps_saved_ddl
(
  deps_id serial primary key, 
  deps_view_schema varchar(255), 
  deps_view_name varchar(255), 
  deps_ddl_to_run text
);

create or replace function deps_save_and_drop_dependencies(p_view_schema varchar, p_view_name varchar) returns void as
$$

rkolka

<#
.SYNOPSIS
    Script to Initialize my custom powershell setup.
.DESCRIPTION
    Script uses scoop
.NOTES
    **NOTE** Will configure the Execution Policy for the "CurrentUser" to Unrestricted.

    Author: Mike Pruett
    Date: October 18th, 2018

rkolka

SELECT 
	string_agg(stmt,  E' union all\n') as union_stmt
from
(
select 
 table_schema
 , table_name	  
 , column_name 
 , format($$select %1$L || '.' || %2$L || '.' || %3$L as col, ST_GeometryType(%3$I), count(*) as arv from	%1$I.%2$I group by 	ST_GeometryType(%3$I)$$ 	  , table_schema	  , table_name	  , column_name	  ) as stmt

rkolka

> ?GeomWkt(GeomUpdateCoord(StringWktGeom('LINESTRING(1 -2, 2 3)'), 1, VectorMakeX2(5,5)))
nvarchar: LINESTRING(1 -2, 5 5)
> ?GeomWkt(GeomUpdateCoord(StringWktGeom('LINESTRING(1 -2, 2 3)'), 0, VectorMakeX2(5,5)))
nvarchar: LINESTRING(5 5, 2 3)
> ?GeomWkt(GeomUpdateCoord(StringWktGeom('MULTIPOINT ((10 40), (40 30), (20 20), (30 10))'), 0, VectorMakeX2(5,5)))
nvarchar: MULTIPOINT(5 5, 40 30, 20 20, 30 10)
> ?GeomWkt(GeomUpdateCoord(StringWktGeom('MULTIPOINT ((10 40), (40 30), (20 20), (30 10))'), 2, VectorMakeX2(5,5)))
nvarchar: MULTIPOINT(10 40, 40 30, 5 5, 30 10)
> ?GeomWkt(GeomUpdateCoord(StringWktGeom('POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))'), 2, VectorMakeX2(5,5)))
nvarchar: POLYGON((30 10, 40 40, 5 5, 10 20, 30 10))

rkolka

-- $manifold$
-- $include$ [Geom_Functions]


VALUE @p00 GEOM = p2(0,0) ; 
VALUE @p01 GEOM = p2(0,1) ; 
VALUE @p10 GEOM = p2(1,0) ; 
VALUE @p11 GEOM = p2(1,1) ; 

VALUE @p000 GEOM = p3(0,0,0) ;