René's URL Explorer Experiment

Title: Improve `skip_duplicates` · Issue #388 · datajoint/datajoint-python · GitHub

Open Graph Title: Improve `skip_duplicates` · Issue #388 · datajoint/datajoint-python

X Title: Improve `skip_duplicates` · Issue #388 · datajoint/datajoint-python

Description: This is perhaps a more elegant alternative solution to that in #382 / #383. MySQL does not provide a duplicate-specific ignore. But it does have ON DUPLICATE KEY UPDATE. It can be co-opted to play the role of the ON DUPLICATE KEY IGNORE....

Open Graph Description: This is perhaps a more elegant alternative solution to that in #382 / #383. MySQL does not provide a duplicate-specific ignore. But it does have ON DUPLICATE KEY UPDATE. It can be co-opted to play ...

X Description: This is perhaps a more elegant alternative solution to that in #382 / #383. MySQL does not provide a duplicate-specific ignore. But it does have ON DUPLICATE KEY UPDATE. It can be co-opted to play ...

Opengraph URL: https://github.com/datajoint/datajoint-python/issues/388

X: @github

direct link

Domain: github.com

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Improve `skip_duplicates`","articleBody":"This is perhaps a more elegant alternative solution to that in #382 / #383.  \r\n\r\nMySQL does not provide a duplicate-specific ignore.  But it does have `ON DUPLICATE KEY UPDATE`.  It can be co-opted to play the role of the `ON DUPLICATE KEY IGNORE`.\r\n\r\nI propose to replace the logic implemented in #383 by appending `ON DUPLICATE KEY UPDATE id1 = id1`  where `id1` is the first attribute of the primary key.  This leaves the duplicate values unchanged and quietly ignores them while inserting all the good entries.\r\n\r\n","author":{"url":"https://github.com/dimitri-yatsenko","@type":"Person","name":"dimitri-yatsenko"},"datePublished":"2017-11-01T17:32:48.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/388/datajoint-python/issues/388"}

Links:

Viewport: width=device-width