thinkalexandria / diesel_geometry Goto Github PK

View Code? Open in Web Editor NEW

19.0 5.0 9.0 25 KB

Add support for geometric types and functions to diesel

License: Apache License 2.0

Rust 100.00%

postgresql diesel geometry

diesel_geometry's Introduction

Support for geometric types and geometric functions for Diesel.

API Documentation latest release

diesel_geometry provides geometric types and geometric functions.

License

Licensed under either of these:

Apache License, Version 2.0, (LICENSE-APACHE or https://www.apache.org/licenses/LICENSE-2.0)
MIT license (LICENSE-MIT or https://opensource.org/licenses/MIT)

Contributing

Unless you explicitly state otherwise, any contribution you intentionally submit for inclusion in the work, as defined in the Apache-2.0 license, shall be dual-licensed as above, without any additional terms or conditions.

Testing

To run the integration tests on your machine, you need to have read and write access to a running instance of Postgres. The database is not permanently altered because all tests are wrapped in a single transaction that is rolled back.

When running cargo test set the environment variable PG_DATABASE_URL with the Postgres connection string for your database.

Example

You can start a Postgres database locally using docker with:

docker run -d --rm --name postgres -p 5432:5432 postgres:10

And then run:

PG_DATABASE_URL=postgres://postgres:postgres@localhost:5432 cargo test

diesel_geometry's People

Contributors

Stargazers

Watchers

Forkers

gabisurita archipel sd2k baitcenter happydpc farkal gearme neeryapp

diesel_geometry's Issues

Support for diesel schema generation with diesel.toml?

Diesel now uses a diesel.toml file that allows configuring the schema generation process:
http://diesel.rs/guides/configuring-diesel-cli/
It also allows adding use statements:

[print_schema]
# Add types from `diesel_full_text_search` like `tsvector`
import_types = ["diesel::sql_types::*", "diesel_full_text_search::types::*"]

Would it be possible to support diesel_geometry types with automatic schema generation this way?
Or would diesel_cli also have to be aware of the types in this crate (Point etc.) in order to generate schemas with such columns?

Serde support

Please add optional support for serde's Serialize/Deserialize traits.
Like this:

serde = { version = "1.0", features = ["derive"], optional = true }

#[cfg_attr(feature = "serde", derive(Serialize, Deserialize))]
pub struct PgPoint(pub f64, pub f64);

Thanks!

Question on supporting extensions

First, congratulations for this project! I've working for some time with diesel and postgres for radial distance computations using Point and the earthdistance module, but I hadn't time to isolate the API and publish a crate yet.

My question is if I should try to merge my work with earthdistance (or something that uses extensions, such as geom os gis) on this crate or try to publish it elsewhere using only the Point data type.

Thanks,

Add a working example

I know there are a few good examples as tests, but it would be good if they were available on the README or the first page of the docs.

The usage is pretty straightforward besides having to include the Point type on the table! macro. I had some hard time having to figure out this on the first time working with custom diesel types.

Invalid use of mem::uninitialized

Setup

Versions

Rust:
Diesel Geometry: 1.4.0
Database:
Operating System

Feature Flags

diesel_geometry:

Problem Description

attempted to leave type &diesel::pg::metadata_lookup::PgMetadataLookup uninitialized, which is invalid

What are you trying to accomplish?

What is the expected output?

What is the actual output?

https://asan.saethlin.dev/ub?crate=diesel_geometry&version=1.4.0

Are you seeing any additional errors?

Steps to reproduce

Run the test suite with AddressSanitizer and no database running.

Checklist

I have already looked over the issue tracker for similar issues.

Fixed by #9

Support for circle?

I'm looking forward to using this crate with PostGIS.
Do you have plans to support the other geometry types like circle? :)

Geography point support

I tried to use it with geography point type geography(point, 4326) not null in postgres and PgPoint in my model struct, but it's not deserializing the values correctly:

When I insert

ST_SetSRID(ST_MakePoint(13.409779,52.520645), 4326)::geography

and then print it in my Rust executable, it prints:

PgPoint(0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000007746818039357731, 0.00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000013770074297002852)