Skip to content

Instantly share code, notes, and snippets.

@zeha

zeha/nordep.sql

Last active July 7, 2016 13:49
Show Gist options
  • Save zeha/9a511c3d26e18664cb1dce0af2aa9ac2 to your computer and use it in GitHub Desktop.
Save zeha/9a511c3d26e18664cb1dce0af2aa9ac2 to your computer and use it in GitHub Desktop.
Download ZIP
pkg-ruby-extras packages with no r-dep (or r-build-dep)
Raw
nordep.sql
WITH
sidpkgs AS (
select distinct
p1.package, p1.maintainer, p1.version,
regexp_split_to_array(replace(regexp_replace(p1.depends, E'(\\([^\\)]+\\))', '', 'g'), ' ', ''), E'[,|]') as depends,
regexp_split_to_array(replace(regexp_replace(p1.recommends, E'(\\([^\\)]+\\))', '', 'g'), ' ', ''), E'[,|]') as recommends,
regexp_split_to_array(replace(regexp_replace(p1.suggests, E'(\\([^\\)]+\\))', '', 'g'), ' ', ''), E'[,|]') as suggests
from packages p1
where p1.release = 'sid'
and p1.package not like '%-dbgsym'
and p1.version = (select max(version) from packages p2 where p2.package = p1.package and p2.release = 'sid')
),
sidsrcs AS (
select distinct
p1.source, p1.maintainer, p1.version,
regexp_split_to_array(replace(regexp_replace(p1.build_depends, E'(\\([^\\)]+\\))', '', 'g'), ' ', ''), E'[,|]') as build_depends,
regexp_split_to_array(replace(regexp_replace(p1.build_depends_indep, E'(\\([^\\)]+\\))', '', 'g'), ' ', ''), E'[,|]') as build_depends_indep
from sources p1
where p1.release = 'sid'
and p1.version = (select max(version) from sources p2 where p2.source = p1.source and p2.release = 'sid')
),
ourpkgs AS (
select package, version from sidpkgs where maintainer like '%pkg-ruby-extras%'
)
select p.package, p.version
from ourpkgs p
left join sidpkgs p2 on p.package = any(p2.depends)
or p.package = any(p2.recommends)
or p.package = any(p2.suggests)
left join sidsrcs s on p.package = any(s.build_depends)
or p.package = any(s.build_depends_indep)
where p2.package is null and s.source is null;
Raw
nordep.txt
package | version
-------------------------------------+---------------------
ruby-test-after-commit | 1.0.0-1
ruby-dust | 0.1.7-2
ruby-crb-blast | 0.6.4-1
ruby-lumberjack | 1.0.9-1
ruby-simple-form | 3.2.0-1
ruby-bert | 1.1.6-1+b3
mina | 0.3.7-1
ruby-passenger-doc | 5.0.27-2
ruby-rpatricia | 1.0.1-1+b7
ruby-barby | 0.5.1-3
ruby-ferret | 0.11.8.6-2
ruby-ogginfo | 0.7.2-2
ruby-mime-types-data | 3.2015.1120-1
ruby-pango-dbg | 2.2.5-5
ruby-algebrick | 0.7.3-1
ruby-dirty-memoize | 0.0.4-1
ruby-origin | 2.2.0-1
ruby-rubytorrent | 0.3-5
homesick | 1.1.3-1
samizdat | 0.7.0-2
libraspell-ruby1.8 | 1.3-1
ruby-rails-tokeninput | 1.7.0-1
ruby-eb | 2.6-3+b6
rexical | 1.0.5-2
ruby-u2f | 0.2.1-2
ruby-rubyvis | 0.6.1+dfsg1-2
rerun | 0.11.0-1
ruby-cleanroom | 1.0.0-1
ruby-grib | 0.3.0-1
ruby-beaneater | 1.0.0-1
ruby-integration | 0.1.0-1
ruby-nokogumbo | 1.4.2+ds-1+b3
ruby-svg-graph | 1.0.5-3
ruby-sinon-rails | 1.9.0-1
ruby-cucumber-rails | 1.4.2-1
ruby-cutest | 1.2.1-2
ruby-albino | 1.3.3-5
ruby-emot | 0.0.4-1
ruby-spoon | 0.0.4-2
ruby-ferret | 0.11.8.6-2
ruby-rubymail-doc | 1.1.0-2
ruby-nokogumbo | 1.4.2+ds-1+b3
ruby-journey | 1.0.4-2
libraspell-ruby1.9.1 | 1.3-1
ruby-rails-assets-chartjs | 1.0.2-1
ruby-multibitnums-dbg | 0.1.4-2+b7
ruby-iniparse | 1.4.2-1
ruby-zoom | 0.4.1-7+b1
ruby-ferret | 0.11.8.6-2
stompserver | 0.9.9gem-3
ruby-build | 20151028-1
ruby-rmagick-doc | 2.15.4+dfsg-1
ruby-parseconfig | 1.0.2-1
ruby-minitest-stub-const | 0.4-1
ruby-cliver | 0.3.2-3
ruby-fog-azure | 0.0.2-1
ruby-aws | 2.10.2-4
ruby-gnome2-dev | 2.2.5-5
ruby-minitest-excludes | 2.0.0-1
ruby-mustermann19 | 0.4.3+git20160621-1
ruby-serialport | 1.3.1-1+b3
ruby-flot-rails | 0.0.6-2
ruby-celluloid-extras | 0.20.5-1
ruby-nfc | 3.1.1-1+b5
ruby-validatable | 1.6.7-10
ruby-xmlhash-dbg | 1.3.6-2+b2
ruby-mono-logger | 1.1.0-3
ruby-bsearch | 1.5-10
ruby-celluloid-pool | 0.20.5-1
ruby-packetfu | 1.1.11-2
ruby-gstreamer-dbg | 2.2.5-5
serverspec-runner | 0.2.4-2
ruby-htree | 0.8+dfsg-3
ruby-eb | 2.6-3+b6
ruby-kramdown-rfc2629 | 1.0.31-1
ruby-celluloid-supervision | 0.20.5-1
ruby-gsl-dbg | 1.16.0.6+dfsg1-2+b1
ruby-grape-logging | 1.3.0-1
ruby-gtk3-dbg | 2.2.5-5
mkalias | 1.0.10-2
roodi | 5.0.0-1
ruby-grit-ext | 0.8.1-2
ruby-gd | 0.8.0-7+b8
ruby-rack-flash3 | 1.0.5-1
vagrant-libvirt | 0.0.33-1
ruby-gruff | 0.6.0-1
ruby-fog-openstack | 0.1.6-2
ruby-rpatricia | 1.0.1-1+b7
ruby-gio2-dbg | 2.2.5-5
ruby-thinking-sphinx | 3.2.0-1
ruby-brass | 1.2.1-1
ruby-yell | 2.0.6-1
ruby-ice-cube | 0.12.1-1
jekyll | 3.1.6+dfsg-3
ruby-chronic-duration | 0.10.6-1
ruby-bert | 1.1.6-1+b3
vagrant-lxc | 1.2.1-2
ruby-extendmatrix | 0.3.1-3
ruby-bert | 1.1.6-1+b3
ruby-email-validator | 1.4.0-1
ruby-rspec-instafail | 1.0.0-2
adlint | 3.2.14-2
ruby-test-unit-context | 0.5.0-2
ruby-snmp | 1.2.0-1
ruby-classifier | 1.3.4-2
ruby-gtk2-dbg | 2.2.5-5
ruby-wirble | 0.1.3-5
ruby-mpi | 0.3.0-1+b5
ruby-gobject-introspection-dbg | 2.2.5-5
ruby-cri-doc | 2.7.0-2
ruby-clamp | 1.0.0-1
ruby-acts-as-tree | 2.4.0-1
ruby-peach | 0.5.1-3
ruby-gtksourceview2-dbg | 2.2.5-5
ruby-jquery-datatables-rails | 3.4.0+dfsg-1
ruby-appraiser | 0.2.0-3
camping | 2.1.580-1
ruby-clutter-gtk | 2.2.5-5
librarian-puppet | 2.2.3-1
ruby-clockwork | 1.2.0-3
compass-bootstrap-sass-plugin | 3.3.5.1-3
ruby-rugments | 1.0.0~beta8-1
haproxyctl | 1.3.0-2
ruby-factory-girl-rails | 4.4.1-2
ruby-dbf | 2.0.10-1
ruby-yaml-db | 0.3.0-1
ruby-stud | 0.0.20-1
ruby-mixlib-install | 0.7.1-1
ruby-seamless-database-pool | 1.0.17-1
ruby-gssapi | 1.2.0-1
ruby-base62 | 1.0.0-2
ruby-gtksourceview3-dbg | 2.2.5-5
ruby-swd | 1.0.1-1
ruby-state-machine | 1.2.0-2
ruby-beautify | 0.97.4-2
ruby-omniauth-remote-user | 0.1.3-1
ruby-logify | 0.2.0-1
ruby-celluloid-essentials | 0.20.5-1
trocla | 0.2.3-1
ruby-grib | 0.3.0-1
ruby-dbus | 0.11.0-1
ruby-cmdparse | 2.0.6-1
asciiart | 0.0.9-1
ruby-nokogumbo | 1.4.2+ds-1+b3
ruby-grib | 0.3.0-1
ruby-zoom | 0.4.1-7+b1
ruby-image-science | 1.2.2-1.2
ruby-json-jwt | 1.6.2-1
ruby-zip-zip | 0.3+gh-1
ruby-zoom | 0.4.1-7+b1
ruby-enumerize | 1.1.1-1
ruby-fusefs | 0.7.0-4+b7
libjs-sinon | 1.9.0-1
ruby-ftw | 0.0.44-1
ruby-levenshtein | 0.2.2-2+b7
ruby-whenever | 0.9.4-1
ruby-levenshtein | 0.2.2-2+b7
rhc | 1.38.4-2
ruby-delayed-job-active-record | 4.0.3-1
ruby-numru-misc | 0.1.2-2
ruby-text-format | 1.0.0-4
ruby-appraiser-rubocop | 1.0.1-1
ruby-rails-assets-punycode | 1.3.2-2
ruby-deprecated | 3.0.1-2
ruby-eb | 2.6-3+b6
ruby-filepath | 0.6-3
ruby-mpi | 0.3.0-1+b5
chake | 0.13-1
ruby-elasticsearch | 1.0.12-1
ruby-webkit-gtk | 2.2.5-5
libjs-punycode | 1.3.2-2
ruby-atk-dbg | 2.2.5-5
atig | 0.6.1-1
ruby-exception-notification | 4.0.1-1
hiera-eyaml | 2.1.0-1
tmuxinator | 0.8.1-1
diaspora | 0.5.5.1+debian-10
ruby-mp3tag | 1.0-12
ruby-file-tail | 1.1.0-1
ruby-httpauth | 0.2.1+gh-1
ruby-poppler-dbg | 2.2.5-5
ruby-sprite-factory | 1.7.1-2
ruby-fssm | 0.2.10-3
gitlab | 8.8.2+dfsg-5
ruby-notifier | 0.5.1-2
ruby-climate-control | 0.0.3-1
ruby-color-tools | 1.8-1
ruby-subexec | 0.2.3+gh-2
ruby-ae | 1.8.2-1
ruby-docker-api | 1.22.2-1
ruby-exif | 0.1.2-21+b7
ruby-ref | 2.0.0-1
asciidoctor-doc | 1.5.4-2
ruby-berkshelf-api-client | 2.0.2-1
ruby-serialport | 1.3.1-1+b3
nanoc-doc | 4.2.3-1
larch | 1.1.2-1
ruby-serialport | 1.3.1-1+b3
ruby-distribution | 0.7.3+dfsg-1
ruby-rspec-pending-for | 0.1.3-1
ruby-grack | 2.0.2-2
nanoc | 4.2.3-1
ruby-test-spec | 0.10.0-3
ruby-cairo-gobject-dbg | 2.2.5-5
ruby-gelf | 1.4.0-3
ruby-acts-as-list | 0.7.2-4
foremancli | 1.0-2
ruby-powerpack | 0.1.1-3
ruby-gir-ffi | 0.9.0-3
ruby-celluloid-fsm | 0.20.5-1
ruby-rails-assets-clipboard | 1.4.2-1
diaspora-installer-mysql | 0.5.9.1+debian1
ruby-rsvg2-dbg | 2.2.5-5
ruby-ruby2ruby | 2.0.7-1
ruby-mixlib-versioning | 1.1.0-1
ruby-directory-watcher | 1.5.1-2
ruby-webfinger | 1.0.2-1
ruby-odbc-dbg | 0.99995-2+b8
ruby-kakasi-ffi | 1.0.2-2
ruby-numru-units | 1.9-1
ruby-puppet-syntax | 2.0.0-1
rabbiter | 2.0.2-2
ruby-gnuplot | 2.6.2-2
ghi | 1.2.0-1
ruby-mpi | 0.3.0-1+b5
ruby-torquebox-no-op | 3.1.2-1
ruby-api-pagination | 4.2.0-1
ruby-table-print | 1.5.6-1
sup-mail | 0.22.1-1
thin1.8 | 1.3.1-5
ruby-passenger | 5.0.27-2
ruby-rails-assets-jquery-nicescroll | 3.6.6-1
ruby-romkan | 0.4.0-2
ruby-rpatricia | 1.0.1-1+b7
ruby-openstack | 2.0.2-1
ruby-metaid | 1.0-8
ruby-gyoku | 1.3.1-1
ruby-exif | 0.1.2-21+b7
ruby-stamp | 0.6.0-1
ruby-versionomy | 0.5.0-2
ruby-reek | 3.8.2-2
ruby-jeweler | 2.0.1-2
ruby-exif | 0.1.2-21+b7
ruby-capistrano-colors | 0.5.5-1
ruby-powerbar | 1.0.17-1
ruby-rails-assets-jquery-ui | 1.11.4-1
rttool | 1.0.3.0-5
ruby-gdk-pixbuf2-dbg | 2.2.5-5
ruby-packable | 1.3.8-1
ruby-cocoon | 1.2.6-2
ruby-rjb | 1.5.3-2+b2
ruby-crass | 1.0.2-2
ruby-codemirror-rails | 5.6-2
ruby-extlib | 0.9.16-1
ruby-gd | 0.8.0-7+b8
ruby-activerecord-nulldb-adapter | 0.3.2-1
ruby-spreadsheet | 1.0.0-1
ruby-memoize | 1.3.1-5
ruby-levenshtein | 0.2.2-2+b7
ruby-kpeg | 1.0.0-1
ruby-bluefeather | 0.41-4
ruby-appraiser-reek | 1.0.0-1
ruby-notify | 0.5.2-2
ruby-fusefs | 0.7.0-4+b7
ruby-ami | 2.4.0-1
ruby-validate-email | 0.1.6-1
ruby-model-tokenizer | 1.0.1-1
ruby-puppetlabs-spec-helper | 0.10.3-1
ruby-lapack-dbg | 1.7.2-1+b2
ruby-fssm | 0.2.10-3
ruby-asetus | 0.3.0-1
libraspell-ruby | 1.3-1
ruby-pundit | 1.0.1-2
ruby-escape | 0.2-5
ruby-glib2-dbg | 2.2.5-5
ruby-googlecharts | 1.6.12-1
ruby-gd | 0.8.0-7+b8
feed2imap | 1.2.5-1
ruby-minimization | 0.2.1-2
ruby-fix-trinity-output | 1.0.0-1
ruby-cssmin | 1.0.3-4
ruby-nori | 2.6.0-1
(282 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment