Grails领域约束映射到PostgreSQL吉斯特约束

Question

我有一个PostgreSQL表

CREATE TABLE reservation_table (
    idreservation   SERIAL NOT NULL, 
    entry_datetime  TIMESTAMPTZ NOT NULL DEFAULT 'NOW', 
    start_end_dates  DATERANGE NOT NULL , 
    property_id   INT NOT NULL REFERENCES property_table, 
... 
) 

和约束，以防止2只保留了相同的属性上同日

ALTER TABLE ONLY reservation_table 
    ADD CONSTRAINT reservation_double_booking_constraint 
    EXCLUDE USING gist 
    (property_id WITH =, start_end_dates WITH &&) 
; 

我能执行我的SQL约束在我的Grails Reservation域中？

我正在考虑使用视图，以避免在常规

create view resView as 
     select idReservation, 
      lower(start_end_dates) AS startDate, 
      upper(start_end_dates) AS endDate, 
      property_id 
     from reservation_table 

Answer 1

好PostgreSQL的范围问题访问预约，但你指定的最起码的信息来解决这样的问题，因为我还没有完全理解它，我有以下建议。

如何在grails上使用拦截器之前和之后。

class Reservation { 

    Date startDate ... 

    def beforeInterceptor = { 

    //do some date validation here start data or end date 
    //for exmaple you might check that we have 
    //any start date currently existing on db 
    //by findbyStartDate or endDate 
    //then reject the reservation or saving of this model 
     println "validation error here , cancel save" 
    } 
    static constraints = { 
     //do some validation here related to ur constraint 
     startDate max: new Date() 
    } 
    } 

让我知道任何事情，如果你需要更多的帮助。 。 。