Styjun

Can anything be seen from the center of the Boötes void? How dark would it be?

Why is Nikon 1.4g better when Nikon 1.8g is sharper?

Is it a good idea to use CNN to classify 1D signal?

How to tell that you are a giant?

Trademark violation for app?

Chinese Seal on silk painting - what does it mean?

Is it possible for SQL statements to execute concurrently within a single session in SQL Server?

ArcGIS Pro Python arcpy.CreatePersonalGDB_management

Why weren't discrete x86 CPUs ever used in game hardware?

How often does castling occur in grandmaster games?

Denied boarding although I have proper visa and documentation. To whom should I make a complaint?

What is the difference between globalisation and imperialism?

Time to Settle Down!

Did Krishna say in Bhagavad Gita "I am in every living being"

Why do early math courses focus on the cross sections of a cone and not on other 3D objects?

How to write the following sign?

How to write this math term? with cases it isn't working

How would a mousetrap for use in space work?

How do I use the new nonlinear finite element in Mathematica 12 for this equation?

Do wooden building fires get hotter than 600°C?

How could we fake a moon landing now?

Is a ledger board required if the side of my house is wood?

What is the topology associated with the algebras for the ultrafilter monad?

Performance gap between vector<bool> and array

Rails create or update for associated records

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I have this example code which raises a "Duplicate Expection". Instead, I want just to skip if a duplicate exists.

(1..10).each do |page|
 group.products << [id: 1, title: "Example A", id: 2, title: "Example B"]
 group.save
end

The product array is static just for this example, what matter is that it has ID's, so products exist in the database.

The problem is when I assign a product that I have already assigned in the past which raise a "Not Unique exception". In this scenario, I would just skip the association. How is that possible?

ruby-on-rails activerecord ruby-on-rails-5 rails-activerecord

share|improve this question

edited Mar 22 at 16:05

NN796

347522

asked Mar 22 at 10:10

sparklesparkle

2,720155182

add a comment | 

0

I have this example code which raises a "Duplicate Expection". Instead, I want just to skip if a duplicate exists.

(1..10).each do |page|
 group.products << [id: 1, title: "Example A", id: 2, title: "Example B"]
 group.save
end

The product array is static just for this example, what matter is that it has ID's, so products exist in the database.

The problem is when I assign a product that I have already assigned in the past which raise a "Not Unique exception". In this scenario, I would just skip the association. How is that possible?

ruby-on-rails activerecord ruby-on-rails-5 rails-activerecord

share|improve this question

edited Mar 22 at 16:05

NN796

347522

asked Mar 22 at 10:10

sparklesparkle

2,720155182

add a comment | 

I have this example code which raises a "Duplicate Expection". Instead, I want just to skip if a duplicate exists.

(1..10).each do |page|
 group.products << [id: 1, title: "Example A", id: 2, title: "Example B"]
 group.save
end

The product array is static just for this example, what matter is that it has ID's, so products exist in the database.

The problem is when I assign a product that I have already assigned in the past which raise a "Not Unique exception". In this scenario, I would just skip the association. How is that possible?

ruby-on-rails activerecord ruby-on-rails-5 rails-activerecord

share|improve this question

edited Mar 22 at 16:05

NN796

347522

asked Mar 22 at 10:10

sparklesparkle

2,720155182

(1..10).each do |page|
 group.products << [id: 1, title: "Example A", id: 2, title: "Example B"]
 group.save
end

share|improve this question

edited Mar 22 at 16:05

NN796

347522

asked Mar 22 at 10:10

sparklesparkle

2,720155182

share|improve this question

edited Mar 22 at 16:05

NN796

347522

asked Mar 22 at 10:10

sparklesparkle

2,720155182

edited Mar 22 at 16:05

NN796

347522

edited Mar 22 at 16:05

NN796

347522

asked Mar 22 at 10:10

sparklesparkle

2,720155182

asked Mar 22 at 10:10

sparklesparkle

2,720155182

2 Answers
2

active

oldest

votes

1

You could use create_with in combination with find_or_create_by:

(1..10).each do |page|
 group.products << Product.create_with(title: "Example A").find_or_create_by(id: 1)
 group.products << Product.create_with(title: "Example B").find_or_create_by(id: 2)
 group.save
end

share|improve this answer

answered Mar 22 at 13:29

s3tjans3tjan

49049

add a comment | 

0

You are assigning the same dynamic array of objects to group.products in a ten times loop which is creating duplicates. Why are you not running this without a loop? I don't think so there is a need for a loop.

share|improve this answer

edited Mar 22 at 11:01

answered Mar 22 at 10:24

NN796NN796

347522

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  OP doesn't want to skip the validation but a solution to avoid adding duplicate records
  
  – Deepak Mahakale
  Mar 22 at 10:45
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55297285%2frails-create-or-update-for-associated-records%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

You could use create_with in combination with find_or_create_by:

(1..10).each do |page|
 group.products << Product.create_with(title: "Example A").find_or_create_by(id: 1)
 group.products << Product.create_with(title: "Example B").find_or_create_by(id: 2)
 group.save
end

share|improve this answer

answered Mar 22 at 13:29

s3tjans3tjan

49049

add a comment | 

1

You could use create_with in combination with find_or_create_by:

(1..10).each do |page|
 group.products << Product.create_with(title: "Example A").find_or_create_by(id: 1)
 group.products << Product.create_with(title: "Example B").find_or_create_by(id: 2)
 group.save
end

share|improve this answer

answered Mar 22 at 13:29

s3tjans3tjan

49049

add a comment | 

You could use create_with in combination with find_or_create_by:

(1..10).each do |page|
 group.products << Product.create_with(title: "Example A").find_or_create_by(id: 1)
 group.products << Product.create_with(title: "Example B").find_or_create_by(id: 2)
 group.save
end

share|improve this answer

answered Mar 22 at 13:29

s3tjans3tjan

49049

(1..10).each do |page|
 group.products << Product.create_with(title: "Example A").find_or_create_by(id: 1)
 group.products << Product.create_with(title: "Example B").find_or_create_by(id: 2)
 group.save
end

share|improve this answer

answered Mar 22 at 13:29

s3tjans3tjan

49049

answered Mar 22 at 13:29

s3tjans3tjan

49049

answered Mar 22 at 13:29

s3tjans3tjan

49049

0

You are assigning the same dynamic array of objects to group.products in a ten times loop which is creating duplicates. Why are you not running this without a loop? I don't think so there is a need for a loop.

share|improve this answer

edited Mar 22 at 11:01

answered Mar 22 at 10:24

NN796NN796

347522

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  OP doesn't want to skip the validation but a solution to avoid adding duplicate records
  
  – Deepak Mahakale
  Mar 22 at 10:45
  

  
  
  
  

add a comment | 

0

You are assigning the same dynamic array of objects to group.products in a ten times loop which is creating duplicates. Why are you not running this without a loop? I don't think so there is a need for a loop.

share|improve this answer

edited Mar 22 at 11:01

answered Mar 22 at 10:24

NN796NN796

347522

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  OP doesn't want to skip the validation but a solution to avoid adding duplicate records
  
  – Deepak Mahakale
  Mar 22 at 10:45
  

  
  
  
  

add a comment | 

You are assigning the same dynamic array of objects to group.products in a ten times loop which is creating duplicates. Why are you not running this without a loop? I don't think so there is a need for a loop.

share|improve this answer

edited Mar 22 at 11:01

answered Mar 22 at 10:24

NN796NN796

347522

share|improve this answer

edited Mar 22 at 11:01

answered Mar 22 at 10:24

NN796NN796

347522

answered Mar 22 at 10:24

NN796NN796

347522

answered Mar 22 at 10:24

NN796NN796

347522