PostgreSQL check whether timestamp field is empty

Question

I followed these instructions to check whether a user has been soft-deleted or not when logging in. In the example below I can check for a boolean value:

Class User < ActiveRecord::Base
  def self.find_for_authentication(conditions)
    super(conditions.merge(:deleted_flag => false))
  end

I would prefer a timestamp (created_at) field. How can I check whether such a field is empty? The database throws errors for the following checks:

super(conditions.merge(:deleted_at => false)) # also tried nil, "NULL" and "IS NULL"

Thanks, didn't work, it says undefined local variable or undefined constant — migu
– migu, Commented Oct 17, 2012 at 14:59

Community · Accepted Answer · 2017-05-23 12:23:16Z

11

You can't using this solution, without modifying devise of course. Devise will send your conditions directly to the database, so no way of calling a method or using a library like squeel (that will allow something like where{created_at == nil}.

You could use the solution provided in How to "soft delete" user with Devise, but the error message will be: "You have to confirm your account before continuing."

Add this to your resource model:

  def inactive_message
    !!deleted_at ? :deleted : super
  end

And add a message to your locales:

en:
  devise:
    failure:
      deleted: "Your account was deleted."

I hope it helps!

edited May 23, 2017 at 12:23

CommunityBot

11 silver badge

answered Feb 19, 2013 at 19:42

Leonel Galán

7,1972 gold badges44 silver badges60 bronze badges

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

Collectives™ on Stack Overflow

PostgreSQL check whether timestamp field is empty

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related