Check if dates are equal and insert into database if not

Question

I need to create a new datetime record in my database but first I need to find out is there the same date already saved. The dates inside my database add 4 hours. So, when there is a date which shows it's 2pm, the same date inside database will show it's 6pm. If the dates are the same an alert windows should show.

I'm trying to do something like this but I am not completely sure am I going into right direction:

        def create
        @appointment_new = Appointment.new(:start_date => params[:start_date], 
            :end_date => params[:end_date], :doctor_id => params[:doctor_id], 
            :user_id => params[:user_id])

        @appointments = Appointment.all

        hour = appointment_new.start_date.hour
        minute = appointment_new.start_date.minute

        check = false

        @appointments.each do |appointment|
        {
                ?????????????
        }
        end

        if(check)
            {
                if @appointment.save
                    flash[:success] = "Welcome!"
                    redirect_to @user
                else
                    alert("failure!")
                end
            }
            else
                 // do something
    end

What do you think? Thanks!

Vidya · Accepted Answer · 2013-10-10 03:53:41Z

2

In your Appointment model, can start_date be a key? Then you can have this callback:

before_validation(on: :create) do
    self.start_date = start_date + 4.hours if attribute_present?("start_date")
end

Then the model will fail to save because of a duplicate key.

Not sure how your model is structured, but just a thought.

answered Oct 10, 2013 at 3:53

Vidya

30.4k7 gold badges48 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

the Tin Man Over a year ago

Or just try to save the record and trap any duplicate key exception. That'd be one hit on the database instead of a lookup followed by an insert if the lookup failed.

Collectives™ on Stack Overflow

Check if dates are equal and insert into database if not

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related