5 replies

Custom Statements

Hi I have a question

How do I do the following

execute "CREATE EXTENSION IF NOT EXISTS btree_gist;"

execute """
  ALTER TABLE appointments
  ADD CONSTRAINT overlapping_appointments
  EXCLUDE USING GIST (
    doctor_id WITH =, 
    tsrange("from", "until", '[)') WITH &&
  ) WHERE (NOT canceled);
  """
end

execute "CREATE EXTENSION IF NOT EXISTS btree_gist;"

execute """
  ALTER TABLE appointments
  ADD CONSTRAINT overlapping_appointments
  EXCLUDE USING GIST (
    doctor_id WITH =, 
    tsrange("from", "until", '[)') WITH &&
  ) WHERE (NOT canceled);
  """
end

execute "CREATE EXTENSION IF NOT EXISTS btree_gist;"

execute """
  ALTER TABLE appointments
  ADD CONSTRAINT overlapping_appointments
  EXCLUDE USING GIST (
    doctor_id WITH =, 
    tsrange("from", "until", '[)') WITH &&
  ) WHERE (NOT canceled);
  """
end

execute "CREATE EXTENSION IF NOT EXISTS btree_gist;"

execute """
  ALTER TABLE appointments
  ADD CONSTRAINT overlapping_appointments
  EXCLUDE USING GIST (
    doctor_id WITH =, 
    tsrange("from", "until", '[)') WITH &&
  ) WHERE (NOT canceled);
  """
end

I tried to check the custom statements , it seems I am missing some import perhaps Ash.DataLayer.Info

This message was copied from the ash-hq channel by user @sriky27

Custom Statements

Similar Threads

Similar Threads

Similar Threads