rake test:units error because not null constraint.

Hello. I have this unit test:

test "User validations" do   user = User.new   assert user.invalid?   assert user.errors[:uid].any?   assert user.errors[:name].any?   assert user.errors[:role].any? end

When I run it I have this error:

null value in column "uid" violates not-null constraint: INSERT INTO "users" ("created_at", "updated_at", "id") VALUES ('2012-11-18 19:37:39', '2012-11-18 19:37:39', 298486374). In the fixture user I've put:

one:   uid: "xxx.xxx"

Why the unit test got the error? Thank you.

Is it only that test that gives the problem or does it happen when you run any test? If it was a problem with the fixture then it will happen whatever test you run, I think.

I don't think that it is necessary to include quotes in the fixture file but I would not expect that to cause the problem.

What happens if you empty the users fixtures file?

Colin

Hello. I have this unit test:

test "User validations" do   user = User.new   assert user.invalid?   assert user.errors[:uid].any?   assert user.errors[:name].any?   assert user.errors[:role].any? end

You should probably move each of those assertions to a test of their own using contexts.

describe User do   context "Validations"     it "should have an error on blah"   end end

But you can make those kind of tests mad easy by just using should matchers then it comes down to something so simple you never forget to properly do it:

describe User do   it { should validate_presence_of(:name) } end

When I run it I have this error:

null value in column "uid" violates not-null constraint: INSERT INTO "users" ("created_at", "updated_at", "id") VALUES ('2012-11-18 19:37:39', '2012-11-18 19:37:39', 298486374). In the fixture user I've put:

one:   uid: "xxx.xxx"

If I remember right you should be doing users(:one) instead of User.new but I'm not so sure on that subject 100% because I haven't played with Fixtures since the day after I started learning Rails and discovered factory_girl.

same thing.