Dev Notes

Martin
---++ Foo

---++ Issue tracking

   * Bugzilla at CWI
      * [[http://sjofar.sen.cwi.nl:8080/buglist.cgi?bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&email1=martin.bravenboer%40gmail.com&emailtype1=exact&emailassigned_to1=1&emailreporter1=1][Open bugs submitted by me]]
      * [[http://sjofar.sen.cwi.nl:8080/buglist.cgi?short_desc_type=allwordssubstr&short_desc=&long_desc_type=allwordssubstr&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&bug_status=UNCONFIRMED&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&bug_status=RESOLVED&bug_status=VERIFIED&bug_status=CLOSED&emailassigned_to1=1&emailreporter1=1&emailtype1=exact&email1=martin.bravenboer%40gmail.com&emailtype2=substring&email2=&bugidtype=include&bug_id=&changedin=&chfieldfrom=&chfieldto=Now&chfieldvalue=&cmdtype=doit&newqueryname=&order=Reuse+same+sort+as+last+time&field0-0-0=noop&type0-0-0=noop&value0-0-0=][All bugs submitted]]

---++ Debugging Tools

   * Mac:
      * strace: ktrace / kdump -f ...
      * ldd: otool -L

   * Cygwin:
      * [[http://www.cygwin.com/ml/cygwin/1998-12/msg00280.html][ldd script]] (objdump -p -j idata)

   * Linux
      * strace (-fF to follow forks)
      * [[http://valgrind.kde.org/][valgrind]]

   * Generic
      * GDB
         * gdb program
         * run args
         * backtrace (bt)
         * break fun
         * disassemble

---++ Patching

   * Making a patch:
      * diff -urN olddir newdir > patch.diff     

   * Applying a patch:
      * patch -p1 < patch.diff

---++ JIRA

Dangerous stuff, but easier to use than the advice on:

   * http://confluence.atlassian.com/display/JIRASPAM/Deleting+JIRA+comment+spam

Find modified comments with more than 3 links:
<verbatim>
select pkey, changeitem.id, changegroup.id, substring(OLDVALUE for 72)
from jiraissue, changeitem, changegroup
where
    jiraissue.id=changegroup.issueid
and changegroup.id=changeitem.groupid
and changeitem.OLDVALUE like '%http://%http://%http://%');
</verbatim>

Delete the corresponding change items:
<verbatim>
delete from changeitem where id in (
  select changeitem.id
  from jiraissue, changeitem, changegroup
  where
      jiraissue.id=changegroup.issueid
  and changegroup.id=changeitem.groupid
  and changeitem.OLDVALUE like '%http://%http://%http://%'
);
</verbatim>

Delete the corresponding change groups:
<verbatim>
delete from changegroup where id in (
  select changegroup.id
  from jiraissue, changeitem, changegroup
  where
      jiraissue.id=changegroup.issueid
  and changegroup.id=changeitem.groupid
  and changeitem.OLDVALUE like '%http://%http://%http://%'
);
</verbatim>
About Me

Research

Teaching

Software

Dev Notes
