#postgresql #diesel #point #orm #sql

diesel-point

Diesel support for Point types in Postgres

2 releases

0.1.1 Feb 15, 2024
0.1.0 Feb 15, 2024

#1250 in Database interfaces

40 downloads per month

MIT/Apache

6KB
68 lines

diesel-point   Latest Version docs

Diesel support for Point types in Postgres

Example usage

In your sql schema, you have a column some_point_field Point not null. When Diesel generates the schema (using table! {}) this column will look like some_point_field -> Point. To ensure that the Point type is in scope, read this guide and add use diesel_point::sql_types::* to the import_types key in your diesel.toml file.

E.g. it will look like this:

[print_schema]
file = "src/schema.rs"

import_types = ["diesel::sql_types::*", "diesel_point::sql_types::*"]

In your ORM struct, write some_point_field: PointXy.

Now you can use this struct / table in your diesel queries.

If your table has already been created, first run diesel migration revert. Use PointXy in the ORM struct, and then run the migration again.

Example


#[derive(Insertable, Queryable, Identifiable, Serialize, PartialEq, Debug, Clone, AsChangeset)]
#[diesel(primary_key(model_id))]
#[diesel(table_name = my_table)]
pub struct Mytable{
    pub model_id: Uuid,
    pub some_point_field: PointXy,
}

Dependencies

~3MB
~62K SLoC