CODEWITHSUNDEEP
ponyorm
thd
thd

Reputation: 2430

Pony ORM PostgreSQL Point type

Is it possible to create a data type for the geometric point type from postgres? For the point type, it is just a pair of numbers.

Upvotes: 0

Views: 273

Answers (1)

sashaaero
sashaaero

Reputation: 2888

Pony doesn't have native support for these exotic kind of types.
But you can specify sql_type like this:

b = Required(str, sql_type='point')

Which gives you SQL:

CREATE TABLE "A" (
  "id" INTEGER PRIMARY KEY AUTOINCREMENT,
  "b" POINT NOT NULL
)

I just tested it in SQLite and transaction was succesful (even SQLite doesn't support point type). But you should do your personal workaround for validating point data you are sending to database.

Upvotes: 1

Related Questions