Rails conditions hash not null

Improve this question. David Robertson David Robertson 1, 3 3 gold badges 11 11 silver badges 12 12 bronze badges. Add a comment. Active Oldest Votes. Improve this answer.

I had to change it for a bunch of columns and this doesn't require specifying the column type for each column, much better! This is the better answer. In my database, I was adding a null constraint on a column with pre-existing null values.

Thanks for this. Best answer. The forth option will set the default value for those entries, where the column is null indeed. But be carefull! It can cause downtime if it's a big table. Better first to backfill those records in batches, and then add a constraint without forth option. Dan Wich Dan Wich 4, 1 1 gold badge 23 23 silver badges 22 22 bronze badges. Note that this generates an IrreversibleMigration which may not be what you want.

Mark I was talking about the answer, sorry for not being specific enough. NicNilov no dw I did think that though I just wanted to double check : — Mark. Jump to bottom. Copy link. Hi rubocop team! This looks like an expected behavior. What kind of problem is there? Hi koic Thank you for your time and answer! Ruby benchmark: user system total real constant 0. We just ran into an issue where the following was autocorrected User. Fixes rubocop and rubocop Sign up for free to join this conversation on GitHub.

Already have an account? Sign in to comment. Linked pull requests. Learn more. Asked 11 years, 1 month ago. Active 2 years, 8 months ago. Viewed k times. Using the rails 3 style how would I write the opposite of: Foo. I tried: Foo. Improve this question. You Nguyen 9, 3 3 gold badges 21 21 silver badges 49 49 bronze badges.

So the generated query is in fact what you asked for - this was not an ARel bug. Add a comment. Active Oldest Votes. The canonical way to do this with Rails 3: Foo. Improve this answer. Adam Lassek Adam Lassek Last one here isn't working for me, do we need an extra gem or plugin for this? Tim Yes, the MetaWhere gem I linked above.

I like the solution that doesn't require other gems : even if it is a bit ugly — oreoshake. But of course a general case is good to know. Building the query isn't a performance concern; what you're requesting from the database is. Show 8 more comments. It's not a bug in ARel, it's a bug in your logic. What you want here is: Foo. Ryan Bigg Ryan Bigg k 22 22 gold badges silver badges bronze badges. I'm curious what the logic is then for turning!