| -- An exercise in Common Table Expessions. There are probably | |
| -- faster solutions.... | |
| -- Run this against Flybase and discover the exons that belong | |
| -- to more than one transcripts. | |
| -- exon_name | transcripts | |
| -- 14-3-3epsilon:1 | {14-3-3epsilon-RB,14-3-3epsilon-RD} | |
| -- 14-3-3epsilon:2 | {14-3-3epsilon-RA,14-3-3epsilon-RC} | |
| -- 14-3-3epsilon:3 | {14-3-3epsilon-RA,14-3-3epsilon-RB,14-3-3... | |
| with | |
| -- collect a bit of cvterm info |
| -- This works, starts with a feature and lists all of the features | |
| -- it's related to, deals with cycles, homology seems to be reflexive | |
| -- and symmetric. | |
| with recursive | |
| -- info about a subject/object pair | |
| pair(initial_feature, | |
| subj_feature_id, subj_name, subj_uniquename, subjterm_name, | |
| relterm_name, | |
| obj_feature_id, obj_name, obj_uniquename, objterm_name, | |
| feat_id_path, |
| -- Here's an example that takes the output of the recursive CTE | |
| -- and then decorates it with details about the features and relationships. | |
| with recursive pair(initial_feature, | |
| subj_feature_id, relationship_id, obj_feature_id, | |
| feat_id_path, | |
| cycle | |
| ) as | |
| ( | |
| select subj.feature_id, | |
| subj.feature_id, fr.feature_relationship_id, obj.feature_id, |
| allons:tmp georgewh$ diff -u -r mousex-getopt-0.35 mousex-getopt-0.35.BORKED | |
| Only in mousex-getopt-0.35: Build | |
| Only in mousex-getopt-0.35: MYMETA.json | |
| Only in mousex-getopt-0.35: MYMETA.yml | |
| Only in mousex-getopt-0.35: _build | |
| Only in mousex-getopt-0.35: blib | |
| diff -u -r mousex-getopt-0.35/t/104_override_usage.t mousex-getopt-0.35.BORKED/t/104_override_usage.t | |
| --- mousex-getopt-0.35/t/104_override_usage.t 2015-03-28 15:13:44.000000000 -0700 | |
| +++ mousex-getopt-0.35.BORKED/t/104_override_usage.t 2014-03-10 00:02:07.000000000 -0700 | |
| @@ -44,8 +44,8 @@ |
| // Drop this into init.groovy.d so that it gets executed at startup time. | |
| // One could also use this script to explicitly set a port. | |
| def inst = Jenkins.getInstance() | |
| def sshDesc = inst.getDescriptor("org.jenkinsci.main.modules.sshd.SSHD") | |
| sshDesc.setPort(-1) | |
| sshDesc.getActualPort() | |
| sshDesc.save() |
| ==> 'cmake' '/rss/spack-20161101/var/spack/stage/shiny-server-2016-11-04-iwyadliuj7yuyoxpu5dlgneaxq3ydlkv/shiny-server' '-DCMAKE_INSTALL_PREFIX:PATH=/rss/spack-20161101/opt/spack/linux-centos7-x86_64/gcc-5.4.0/shiny-server-2016-11-04-iwyadliuj7yuyoxpu5dlgneaxq3ydlkv' '-DCMAKE_BUILD_TYPE:STRING=RelWithDebInfo' '-DCMAKE_VERBOSE_MAKEFILE:BOOL=ON' '-DCMAKE_INSTALL_RPATH_USE_LINK_PATH:BOOL=FALSE' '-DCMAKE_INSTALL_RPATH:STRING=/rss/spack-20161101/opt/spack/linux-centos7-x86_64/gcc-5.4.0/shiny-server-2016-11-04-iwyadliuj7yuyoxpu5dlgneaxq3ydlkv/lib:/rss/spack-20161101/opt/spack/linux-centos7-x86_64/gcc-5.4.0/shiny-server-2016-11-04-iwyadliuj7yuyoxpu5dlgneaxq3ydlkv/lib64:/rss/spack-20161101/opt/spack/linux-centos7-x86_64/gcc-5.4.0/bzip2-1.0.6-iro5tie325lhmx2ph36nox3namcf4wqm/lib:/rss/spack-20161101/opt/spack/linux-centos7-x86_64/gcc-5.4.0/cairo-1.14.0-crpytuydkcgzatow3xfst5cc5episr5e/lib:/rss/spack-20161101/opt/spack/linux-centos7-x86_64/gcc-5.4.0/fontconfig-2.11.1-ti2zz3wpp4yflrik6p7pt5nih7ngdhip/lib:/rss/spack-20161 |
| ok regexp 0.455s | |
| ok regexp/syntax 1.000s | |
| panic: test timed out after 3m0s | |
| goroutine 22864 [running]: | |
| panic(0x5be600, 0xc42017a010) | |
| /tmp/hartzelg/spack-stage/spack-stage-ewK2oy/go/src/runtime/panic.go:500 +0x1a1 fp=0xc42010cf48 sp=0xc42010ceb8 | |
| testing.startAlarm.func1() | |
| /tmp/hartzelg/spack-stage/spack-stage-ewK2oy/go/src/testing/testing.go:918 +0x10b fp=0xc42010cfb0 sp=0xc42010cf48 | |
| runtime.goexit() |
| ok cmd/doc 0.060s | |
| ok cmd/fix 0.075s | |
| panic: test timed out after 3m0s | |
| goroutine 522 [running]: | |
| panic(0x825ac0, 0xc420201dc0) | |
| /tmp/hartzelg/spack-stage/spack-stage-wUWCi0/go/src/runtime/panic.go:500 +0x1a1 | |
| testing.startAlarm.func1() | |
| /tmp/hartzelg/spack-stage/spack-stage-wUWCi0/go/src/testing/testing.go:918 +0x10b | |
| created by time.goFunc |
Disclaimer: This piece is written anonymously. The names of a few particular companies are mentioned, but as common examples only.
This is a short write-up on things that I wish I'd known and considered before joining a private company (aka startup, aka unicorn in some cases). I'm not trying to make the case that you should never join a private company, but the power imbalance between founder and employee is extreme, and that potential candidates would
| [...] | |
| ok regexp 1.613s | |
| ok regexp/syntax 1.400s | |
| panic: test timed out after 3m0s | |
| goroutine 22922 [running]: | |
| panic(0x5bf600, 0xc4201881f0) | |
| /tmp/hartzelg/spack-stage/spack-stage-zbOwMI/go/src/runtime/panic.go:500 +0x1a1 fp=0xc42010af48 sp=0xc42010aeb8 | |
| testing.startAlarm.func1() | |
| /tmp/hartzelg/spack-stage/spack-stage-zbOwMI/go/src/testing/testing.go:918 +0x10b fp=0xc42010afb0 sp=0xc42010af48 |