Skip to content

Instantly share code, notes, and snippets.

@dlebauer
Last active August 29, 2015 14:14
Show Gist options
  • Select an option

  • Save dlebauer/c79508afe22c4ea7e1f6 to your computer and use it in GitHub Desktop.

Select an option

Save dlebauer/c79508afe22c4ea7e1f6 to your computer and use it in GitHub Desktop.
Remove duplicate Cultivars
update cultivars set name = '64038-2n', updated_at = now() where id = 415;
update cultivars set name = '64038-4n', updated_at = now() where id = 416;
update traits set cultivar_id = 184 where cultivar_id in (196); update yields set cultivar_id = 184 where cultivar_id in (196); delete from cultivars where id in (196);
update traits set cultivar_id = 350 where cultivar_id in (345); update yields set cultivar_id = 350 where cultivar_id in (345); delete from cultivars where id in (345);
update traits set cultivar_id = 352 where cultivar_id in (441); update yields set cultivar_id = 352 where cultivar_id in (441); delete from cultivars where id in (441);
update traits set cultivar_id = 443 , updated_at = now() where cultivar_id in (340, 309, 367, 303); update yields set cultivar_id = 443 , updated_at = now() where cultivar_id in (340, 309, 367, 303); delete from cultivars where id in (340, 309, 367, 303);
update traits set cultivar_id = 293 , updated_at = now() where cultivar_id in (294); update yields set cultivar_id = 293 , updated_at = now() where cultivar_id in (294); delete from cultivars where id in (294);
update traits set cultivar_id = 414 , updated_at = now() where cultivar_id in (413); update yields set cultivar_id = 414 , updated_at = now() where cultivar_id in (413); delete from cultivars where id in (413);
update traits set cultivar_id = 110 , updated_at = now() where cultivar_id in (124); update yields set cultivar_id = 110 , updated_at = now() where cultivar_id in (124); delete from cultivars where id in (124);
update traits set cultivar_id = 111 , updated_at = now() where cultivar_id in (125); update yields set cultivar_id = 111 , updated_at = now() where cultivar_id in (125); delete from cultivars where id in (125);
update traits set cultivar_id = 126 , updated_at = now() where cultivar_id in (112); update yields set cultivar_id = 126 , updated_at = now() where cultivar_id in (112); delete from cultivars where id in (112);
update traits set cultivar_id = 163 , updated_at = now() where cultivar_id in (168); update yields set cultivar_id = 163 , updated_at = now() where cultivar_id in (168); delete from cultivars where id in (168);
update traits set cultivar_id = 99 , updated_at = now() where cultivar_id in (118, 104); update yields set cultivar_id = 99 , updated_at = now() where cultivar_id in (118, 104); delete from cultivars where id in (118, 104);
update traits set cultivar_id = 119 , updated_at = now() where cultivar_id in (100, 105); update yields set cultivar_id = 119 , updated_at = now() where cultivar_id in (100, 105); delete from cultivars where id in (100, 105);
update traits set cultivar_id = 106 , updated_at = now() where cultivar_id in (120); update yields set cultivar_id = 106 , updated_at = now() where cultivar_id in (120); delete from cultivars where id in (120);
update traits set cultivar_id = 107 , updated_at = now() where cultivar_id in (121); update yields set cultivar_id = 107 , updated_at = now() where cultivar_id in (121); delete from cultivars where id in (121);
update traits set cultivar_id = 122 , updated_at = now() where cultivar_id in (108); update yields set cultivar_id = 122 , updated_at = now() where cultivar_id in (108); delete from cultivars where id in (108);
update traits set cultivar_id = 123 , updated_at = now() where cultivar_id in (109); update yields set cultivar_id = 123 , updated_at = now() where cultivar_id in (109); delete from cultivars where id in (109);
update traits set cultivar_id = 103 , updated_at = now() where cultivar_id in (117); update yields set cultivar_id = 103 , updated_at = now() where cultivar_id in (117); delete from cultivars where id in (117);
update traits set cultivar_id = 353 , updated_at = now() where cultivar_id in (439); update yields set cultivar_id = 353 , updated_at = now() where cultivar_id in (439); delete from cultivars where id in (439);
update traits set cultivar_id = 180 , updated_at = now() where cultivar_id in (136); update yields set cultivar_id = 180 , updated_at = now() where cultivar_id in (136); delete from cultivars where id in (136);
update traits set cultivar_id = 113 , updated_at = now() where cultivar_id in (127); update yields set cultivar_id = 113 , updated_at = now() where cultivar_id in (127); delete from cultivars where id in (127);
update traits set cultivar_id = 114 , updated_at = now() where cultivar_id in (128); update yields set cultivar_id = 114 , updated_at = now() where cultivar_id in (128); delete from cultivars where id in (128);
update traits set cultivar_id = 115 , updated_at = now() where cultivar_id in (129); update yields set cultivar_id = 115 , updated_at = now() where cultivar_id in (129); delete from cultivars where id in (129);
update traits set cultivar_id = 368 , updated_at = now() where cultivar_id in (375); update yields set cultivar_id = 368 , updated_at = now() where cultivar_id in (375); delete from cultivars where id in (375);
update traits set cultivar_id = 280 , updated_at = now() where cultivar_id in (279); update yields set cultivar_id = 280 , updated_at = now() where cultivar_id in (279); delete from cultivars where id in (279);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment