Upsert() should function on tables w/o a PK

[Anmol-Tuple]

Hi is there any method to remove only tables while upserting

---

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

[seanharr11]

Could you be a more specific? I'm not sure exactly what you mean...

[Anmol-Tuple]

Hi ,
when I am making drop_database=false each time the data is appending to the table thus making duplicates records

[seanharr11]

Does the table with the duplicate records have a primary key? I believe we use the primary key of the table to determine whether a row should be updated or inserted.

[nitishxp]

what if it does not contain primary keys?

[seanharr11]

There should be 2 fallback options if no primary keys are present on the table (in order):

1. We gather all FKs, and use them as a "composite primary key" to upsert() on. This will be a common case when dealing with association tables (in many-to-many relations).
2. We specify the columns that make up the "composite primary key", as a part of the config, for each table that does not have a primary key.