Changeset: c2835312c155 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c2835312c155
Added Files:
geom/sql/Tests/pg_regression/Tests/affine.sql
Modified Files:
geom/sql/Tests/pg_regression/Tests/All
Branch: geo
Log Message:
pg_regress: affine
diffs (73 lines):
diff --git a/geom/sql/Tests/pg_regression/Tests/All
b/geom/sql/Tests/pg_regression/Tests/All
--- a/geom/sql/Tests/pg_regression/Tests/All
+++ b/geom/sql/Tests/pg_regression/Tests/All
@@ -25,4 +25,8 @@
#summary #Unknown Functions: st_summary
+#affine #Unknown Functions: ST_snapToGrid, st_scale, st_rotate, st_rotatez,
st_rotatey, st_rotatex, st_transscale, box2d
+
+
+
removeTmpFiles
diff --git a/geom/sql/Tests/pg_regression/Tests/affine.sql
b/geom/sql/Tests/pg_regression/Tests/affine.sql
new file mode 100644
--- /dev/null
+++ b/geom/sql/Tests/pg_regression/Tests/affine.sql
@@ -0,0 +1,56 @@
+-- Tests for affine transformations
+-- Repeat all tests with the new function names.
+-- ST_Translate
+select 'ST_Translate', ST_asewkt(ST_Translate('POINT(0 0)', 5, 12));
+select 'ST_Translate', ST_asewkt(ST_Translate('POINT(0 0 0)', -3, -7, 3));
+
+-- ST_Scale
+select 'ST_Scale', ST_asewkt(ST_Scale('POINT(1 1)', 5, 5));
+select 'ST_Scale', ST_asewkt(ST_Scale('POINT(1 1)', 3, 2));
+select 'ST_Scale', ST_asewkt(ST_Scale('POINT(10 20 -5)', 4, 2, -8));
+
+-- ST_Rotate
+select 'ST_Rotate', ST_asewkt(ST_SnapToGrid(ST_Rotate('POINT(1 1)', pi()/2,
10.0, 20.0), 0.1));
+select 'ST_Rotate', ST_asewkt(ST_SnapToGrid(ST_Rotate('POINT(1 1)', -pi()/2,
-1.0, 2.0), 0.1));
+select 'ST_Rotate', ST_asewkt(ST_SnapToGrid(ST_Rotate('POINT(1 1)', pi()/2,
'POINT(10 10)'), 0.1));
+select 'ST_Rotate', ST_asewkt(ST_SnapToGrid(ST_Rotate('POINT(1 1)', pi()/2,
ST_Centroid('LINESTRING(0 0, 1 0)')), 0.1));
+
+-- ST_RotateZ
+select 'ST_RotateZ', ST_asewkt(ST_SnapToGrid(ST_RotateZ('POINT(1 1)', pi()),
0.1));
+select 'ST_RotateZ', ST_asewkt(ST_SnapToGrid(ST_RotateZ('POINT(1 1)', pi()/2),
0.1));
+select 'ST_RotateZ', ST_asewkt(ST_SnapToGrid(ST_RotateZ('POINT(1 1)',
pi()+pi()/2), 0.1));
+select 'ST_RotateZ', ST_asewkt(ST_SnapToGrid(ST_RotateZ('POINT(1 1)', 2*pi()),
0.1));
+
+-- ST_RotateY
+select 'ST_RotateY', ST_asewkt(ST_SnapToGrid(ST_RotateY('POINT(1 1 1)', pi()),
0.1));
+select 'ST_RotateY', ST_asewkt(ST_SnapToGrid(ST_RotateY('POINT(1 1 1)',
pi()/2), 0.1));
+select 'ST_RotateY', ST_asewkt(ST_SnapToGrid(ST_RotateY('POINT(1 1 1)',
pi()+pi()/2), 0.1));
+select 'ST_RotateY', ST_asewkt(ST_SnapToGrid(ST_RotateY('POINT(1 1 1)',
2*pi()), 0.1));
+
+-- ST_RotateX
+select 'ST_RotateX', ST_asewkt(ST_SnapToGrid(ST_RotateX('POINT(1 1 1)', pi()),
0.1));
+select 'ST_RotateX', ST_asewkt(ST_SnapToGrid(ST_RotateX('POINT(1 1 1)',
pi()/2), 0.1));
+select 'ST_RotateX', ST_asewkt(ST_SnapToGrid(ST_RotateX('POINT(1 1 1)',
pi()+pi()/2), 0.1));
+select 'ST_RotateX', ST_asewkt(ST_SnapToGrid(ST_RotateX('POINT(1 1 1)',
2*pi()), 0.1));
+
+-- ST_TransScale
+select 'ST_TransScale', ST_asewkt(ST_snapToGrid(ST_TransScale('POINT(1 1)',1,
1, 1, 1), 0.1));
+select 'ST_TransScale', ST_asewkt(ST_snapToGrid(ST_TransScale('POINT(2 2)',1,
1, 1, 1), 0.1));
+select 'ST_TransScale', ST_asewkt(ST_snapToGrid(ST_TransScale('POINT(1 1)',-1,
-1, -1, -1), 0.1));
+select 'ST_TransScale', ST_asewkt(ST_snapToGrid(ST_TransScale('POINT(1 1)',0,
1, 1, 1), 0.1));
+select 'ST_TransScale', ST_asewkt(ST_snapToGrid(ST_TransScale('POINT(1 1)',1,
0, 1, 1), 0.1));
+select 'ST_TransScale', ST_asewkt(ST_snapToGrid(ST_TransScale('POINT(1 1)',1,
1, 0, 1), 0.1));
+select 'ST_TransScale', ST_asewkt(ST_snapToGrid(ST_TransScale('POINT(1 1)',1,
1, 1, 0), 0.1));
+select 'ST_TransScale', ST_asewkt(ST_snapToGrid(ST_TransScale('POINT(1 1)',2,
1, 1, 1), 0.1));
+select 'ST_TransScale', ST_asewkt(ST_snapToGrid(ST_TransScale('POINT(1 1)',1,
2, 1, 1), 0.1));
+select 'ST_TransScale', ST_asewkt(ST_snapToGrid(ST_TransScale('POINT(1 1)',1,
1, 2, 1), 0.1));
+select 'ST_TransScale', ST_asewkt(ST_snapToGrid(ST_TransScale('POINT(1 1)',1,
1, 1, 2), 0.1));
+select 'ST_TransScale', ST_asewkt(ST_snapToGrid(ST_TransScale('POINT(1 1)',2,
3, 5, 7), 0.1));
+select 'ST_TransScale', ST_asewkt(ST_snapToGrid(ST_TransScale('POINT(1 1
1)',2, 3, 5, 7), 0.1));
+
+select 'transl_bbox', box2d(ST_Translate('LINESTRING(0 0, 1 1)', 1, 0, 0));
+select 'ST_Scale_bbox', box2d(ST_Scale('LINESTRING(1 0, 2 1)', 2, 0));
+select 'ST_Scale_bbox', box2d(ST_TransScale('LINESTRING(1 0, 2 1)', 2, 1, 1,
1));
+
+select 'ST_RotZ_bbox', box2d(ST_SnapToGrid(ST_RotateZ('LINESTRING(0 0, 1 0)',
pi()), 0.1));
+select 'ST_RotY_bbox', box2d(ST_SnapToGrid(ST_RotateY('LINESTRING(0 0, 1 0)',
pi()), 0.1));
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
