From: Ian Jackson <ijackson@chiark.greenend.org.uk>
Date: Thu, 27 Aug 2009 14:54:49 +0000 (+0100)
Subject: Instructions for deleting black dye
X-Git-Tag: 3.4~80
X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?p=ypp-sc-tools.db-live.git;a=commitdiff_plain;h=aee065d518412d2163a5c4dabd6ca9d2e00f95ad

Instructions for deleting black dye
---

diff --git a/yarrg/devel-notes b/yarrg/devel-notes
index fef5adc..f4f6066 100644
--- a/yarrg/devel-notes
+++ b/yarrg/devel-notes
@@ -1,9 +1,28 @@
+
+removing an obsolete commodity:
+
+  select * from (select * from sell union select * from buy) left outer join commods using (commodid) where commods.commodname = 'Black dye' limit 10;
+
+if that produces no output then:
+
+  begin;
+  delete from commods where commodname like 'Black dye';
+  select * from (select * from sell union select * from buy) left outer join commods using (commodid) where commods.commodname is null limit 10;
+
+and if that produces no output then:
+  commit;
+otherwise
+  rollback;
+
+=======================================
+
 ceb's example route:
   alpha,byrne,papaya,turtle,jorvik,luthien
 
 example mixed arbitrage/trade
   xi,heph
 
+========================================
 
 To remedy bug fixed in 01c14767c024ac56686dbbfcd88d9f3a0b4b1574,
 did this: