Reputation: 5860
I have a table which has to do with posts
schema:
id | post_id | user_id | title | content
right now all columns are set and work as intended but now i want to add a unique ID in the post_id column like 7384756291 in each new record insert into the database
how can i add this feature? i guess i can easily create a random ID but the problem is how to make sure its unique from the others before the record is inserted, otherwise create new and try again...
Upvotes: 1
Views: 148
Reputation: 43298
Just keep trying until it doesn't exist:
post_id = rand(10000000000)
while Model.exists?(:post_id => post_id)
post_id = rand(10000000000)
end
Model.create(:post_id => post_id, ...)
Upvotes: 1