Re^3: DBI placeholders for spatial data

I think that the Site::Point class will benefit from an as_wkt method (or similar) returning strings that you could feed to ST_GeomFromText via placeholders like select ST_GeomFromText(?, ?).

Comment on Re^3: DBI placeholders for spatial data Select or Download Code

Replies are listed 'Best First'.
Re^4: DBI placeholders for spatial data by Bod (Parson) on Jun 30, 2021 at 20:35 UTC
I think that the `Site::Point` class will benefit from... Agreed. The `sql` method now returns just the `POINT` code instead of the complete `ST_GeomFromText` string. This allows me to do something like this: `my $point = Site::Point->new('SO 1230 4560'); $dbh->do("INSERT INTO Test SET start = ST_GeomFromText( ? , 4326)", un +def, $point->sql);` [download] As 4326 is a constant (as long as I am only dealing with this planet!) it doesn't need a placeholder.	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^4: DBI placeholders for spatial data
by Bod (Parson) on Jun 30, 2021 at 20:35 UTC

I think that the Site::Point class will benefit from...

Agreed.

The sql method now returns just the POINT code instead of the complete ST_GeomFromText string. This allows me to do something like this:

my $point = Site::Point->new('SO 1230 4560');
$dbh->do("INSERT INTO Test SET start = ST_GeomFromText( ? , 4326)", un
+def, $point->sql);
[download]

[reply]
[d/l]
[select]