model icon indicating copy to clipboard operation
model copied to clipboard

Geting error when using interval type in postgres

Open bhanuone opened this issue 7 years ago • 6 comments

I have a table(videos) with a column named duration of type interval. I am getting the following error when I try to run the app.

Hanami::Model::Error: missing attributes in ROM::Relation::Name(videos) schema: :duration

Then I followed the instructions specified here to enable interval type and added the following line in my model configuration block

Sequel.extension :pg_interval

then I got this error

LoadError: cannot load such file -- active_support/duration

So I added activesupport to my Gemfile and bundled. But rom-rb doesn't seem to recognize the type and I ended up getting the same error that occured in the beginning. How can I fix this?

bhanuone avatar May 13 '18 11:05 bhanuone

@solnic @flash-gordon how does rom deals with it?

mereghost avatar Aug 31 '18 07:08 mereghost

@bhanuone did you manage to solve this? I have hit exactly the same problem with the tstzrange type although I have loaded the pg_range extension

DangerDawson avatar May 16 '19 16:05 DangerDawson

So the only way I managed to get this to work, was to monkey patch rom-sql with the types I needed which I stole from a later version of rom-sql. If you need a hand I can post a gist?

DangerDawson avatar May 17 '19 08:05 DangerDawson

I'm sorry for your experience. =( Good news is that we are updating ROM for the next release, hopefully to ROM 5.

mereghost avatar May 22 '19 08:05 mereghost

@mereghost that is fantastic news, really looking forward to having the latest version of ROM

DangerDawson avatar May 22 '19 08:05 DangerDawson

Just some belated news: just confirming that ROM 5 will be included out of the box for the 2.0 release.

mereghost avatar Jul 05 '19 10:07 mereghost