Index: ossp-pkg/quos/.cvsignore RCS File: /v/ossp/cvs/ossp-pkg/quos/.cvsignore,v co -q -kk -p'1.1' '/v/ossp/cvs/ossp-pkg/quos/.cvsignore,v' | diff -u /dev/null - -L'ossp-pkg/quos/.cvsignore' 2>/dev/null --- ossp-pkg/quos/.cvsignore +++ - 2024-05-20 02:37:40.221055348 +0200 @@ -0,0 +1 @@ +openpkg.db Index: ossp-pkg/quos/Makefile RCS File: /v/ossp/cvs/ossp-pkg/quos/Makefile,v co -q -kk -p'1.1' '/v/ossp/cvs/ossp-pkg/quos/Makefile,v' | diff -u /dev/null - -L'ossp-pkg/quos/Makefile' 2>/dev/null --- ossp-pkg/quos/Makefile +++ - 2024-05-20 02:37:40.223657385 +0200 @@ -0,0 +1,36 @@ +## +## OSSP quos - Query On Steroids +## Copyright (c) 2004 Ralf S. Engelschall +## Copyright (c) 2004 The OSSP Project +## +## This file is part of OSSP quos, a Web user interface for querying +## a database which can be found at http://www.ossp.org/pkg/tool/quos/. +## +## This program is free software; you can redistribute it and/or modify +## it under the terms of the GNU General Public License as published by +## the Free Software Foundation; either version 2 of the License, or +## (at your option) any later version. +## +## This program is distributed in the hope that it will be useful, +## but WITHOUT ANY WARRANTY; without even the implied warranty of +## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU +## General Public License for more details. +## +## You should have received a copy of the GNU General Public License +## along with this program; if not, write to the Free Software +## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, +## USA, or contact Ralf S. Engelschall . +## +## Makefile: build procedure +## + +SHELL = /bin/sh + +all: + +init: + $(SHELL) ./openpkg.sh + +clean: + rm -f openpkg.db + Index: ossp-pkg/quos/README RCS File: /v/ossp/cvs/ossp-pkg/quos/README,v co -q -kk -p'1.1' '/v/ossp/cvs/ossp-pkg/quos/README,v' | diff -u /dev/null - -L'ossp-pkg/quos/README' 2>/dev/null --- ossp-pkg/quos/README +++ - 2024-05-20 02:37:40.226232472 +0200 @@ -0,0 +1,44 @@ + _ ___ ____ ____ ____ + |_|_ _ / _ \/ ___/ ___|| _ \ __ _ _ _ ___ ___ + _|_||_| | | | \___ \___ \| |_) | / _` | | | |/ _ \/ __| + |_||_|_| | |_| |___) |__) | __/ | (_| | |_| | (_) \__ \ + |_|_|_| \___/|____/____/|_| \__, |\__,_|\___/|___/ + |_| + + OSSP quos - Query On Steroids + Version 0.0.0 (XX-Oct-2004) + + ABSTRACT + + OSSP quos is a Web user interface for querying an SQL-based RDBMS. + ...FIXME... + + COPYRIGHT AND LICENSE + + Copyright (c) 2004 Ralf S. Engelschall + Copyright (c) 2004 The OSSP Project + + This file is part of OSSP quos, a Web user interface for querying + a database which can be found at http://www.ossp.org/pkg/tool/quos/. + + This program is free software; you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation; either version 2 of the License, or + (at your option) any later version. + + This program is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + General Public License for more details. + + You should have received a copy of the GNU General Public License + along with this program; if not, write to the Free Software + Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, + USA, or contact Ralf S. Engelschall . + + SEE ALSO + + o Homepage ....... http://www.ossp.org/pkg/tool/quos/ + o Sources ........ http://cvs.ossp.org/pkg/tool/quos/ + o Distribution .... ftp://ftp.ossp.org/pkg/tool/quos/ + Index: ossp-pkg/quos/TODO RCS File: /v/ossp/cvs/ossp-pkg/quos/TODO,v co -q -kk -p'1.1' '/v/ossp/cvs/ossp-pkg/quos/TODO,v' | diff -u /dev/null - -L'ossp-pkg/quos/TODO' 2>/dev/null --- ossp-pkg/quos/TODO +++ - 2024-05-20 02:37:40.228769785 +0200 @@ -0,0 +1,4 @@ + +- how to implement dynamically adjusting views based + on total number of result records?? + Index: ossp-pkg/quos/openpkg-rdf2sql.pl RCS File: /v/ossp/cvs/ossp-pkg/quos/openpkg-rdf2sql.pl,v co -q -kk -p'1.1' '/v/ossp/cvs/ossp-pkg/quos/openpkg-rdf2sql.pl,v' | diff -u /dev/null - -L'ossp-pkg/quos/openpkg-rdf2sql.pl' 2>/dev/null --- ossp-pkg/quos/openpkg-rdf2sql.pl +++ - 2024-05-20 02:37:40.231855028 +0200 @@ -0,0 +1,54 @@ +#!/usr/opkg/bin/perl +## +## OSSP quos - Query On Steroids +## Copyright (c) 2004 Ralf S. Engelschall +## Copyright (c) 2004 The OSSP Project +## +## This file is part of OSSP quos, a Web user interface for querying +## a database which can be found at http://www.ossp.org/pkg/tool/quos/. +## +## This program is free software; you can redistribute it and/or modify +## it under the terms of the GNU General Public License as published by +## the Free Software Foundation; either version 2 of the License, or +## (at your option) any later version. +## +## This program is distributed in the hope that it will be useful, +## but WITHOUT ANY WARRANTY; without even the implied warranty of +## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU +## General Public License for more details. +## +## You should have received a copy of the GNU General Public License +## along with this program; if not, write to the Free Software +## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, +## USA, or contact Ralf S. Engelschall . +## +## openpkg-rdf2sql.cfg: OpenPKG XML/RDF to SQL importing tool +## + +require 5.008; +use Getopt::Long; +use XML::Parser; +use DBI; +use DBD::SQLite; + +# ...FIXME... + +__END__ + +=pod + +=head1 NAME + +B - OpenPKG XML/RDF to SQL importing tool + +=head1 SYNOPSIS + +B +[B<-v>|B<--verbose>] +...FIXME... +I + +=head1 DESCRIPTION + +=cut + Index: ossp-pkg/quos/openpkg.rdf RCS File: /v/ossp/cvs/ossp-pkg/quos/openpkg.rdf,v co -q -kk -p'1.1' '/v/ossp/cvs/ossp-pkg/quos/openpkg.rdf,v' | diff -u /dev/null - -L'ossp-pkg/quos/openpkg.rdf' 2>/dev/null --- ossp-pkg/quos/openpkg.rdf +++ - 2024-05-20 02:37:40.234875378 +0200 @@ -0,0 +1,97 @@ + + + + + a2ps + 4.13b + 2.2.0 + OpenPKG + Converter + GPL + The OpenPKG Project + Any to Postscript Conversion Tool + http://www.inf.enst.fr/~demaille/a2ps/ + Akim Demaille + + + OpenPKG + openpkg + psutils + flex + bison + + + + + OpenPKG + openpkg + psutils + + + + + ftp://ftp.enst.fr/pub/unix/a2ps/a2ps-4.13b.tar.gz + + + +a2ps is an Any to PostScript filter. It started as a Text to +PostScript converter, with pretty printing features and all the +expected features from this kind of programs. But today, it is also +able to deal with other file types (PostScript, Texinfo, compressed, +whatever...) provided you have the necessary tools. + + + + aegis + 4.19 + 2.2.0 + OpenPKG + Text + GPL + The OpenPKG Project + Software Configuration Management System + http://aegis.sourceforge.net/ + Peter Miller + + + OpenPKG + openpkg + perl + bison + groff + gcc + zlib + gettext + libiconv + uuid + curl + + + + + OpenPKG + openpkg + perl + zlib + gettext + libiconv + uuid + curl + + + + + http://aegis.sourceforge.net/aegis-4.19.tar.gz + + + +Aegis is a transaction-based software configuration management system. It +provides a framework within which a team of developers may work on many +changes to a program independently, and Aegis coordinates integrating +these changes back into the master source of the program, with as little +disruption as possible. + + + + Index: ossp-pkg/quos/openpkg.sh RCS File: /v/ossp/cvs/ossp-pkg/quos/openpkg.sh,v co -q -kk -p'1.1' '/v/ossp/cvs/ossp-pkg/quos/openpkg.sh,v' | diff -u /dev/null - -L'ossp-pkg/quos/openpkg.sh' 2>/dev/null --- ossp-pkg/quos/openpkg.sh +++ - 2024-05-20 02:37:40.237445014 +0200 @@ -0,0 +1,34 @@ +#!/bin/sh +## +## OSSP quos - Query On Steroids +## Copyright (c) 2004 Ralf S. Engelschall +## Copyright (c) 2004 The OSSP Project +## +## This file is part of OSSP quos, a Web user interface for querying +## a database which can be found at http://www.ossp.org/pkg/tool/quos/. +## +## This program is free software; you can redistribute it and/or modify +## it under the terms of the GNU General Public License as published by +## the Free Software Foundation; either version 2 of the License, or +## (at your option) any later version. +## +## This program is distributed in the hope that it will be useful, +## but WITHOUT ANY WARRANTY; without even the implied warranty of +## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU +## General Public License for more details. +## +## You should have received a copy of the GNU General Public License +## along with this program; if not, write to the Free Software +## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, +## USA, or contact Ralf S. Engelschall . +## +## quos.cfg: configuration +## + +# one-time database creation task +rm -f openpkg.db +sqlite openpkg.db /dev/null --- ossp-pkg/quos/openpkg.sql +++ - 2024-05-20 02:37:40.240001251 +0200 @@ -0,0 +1,99 @@ +-- +-- OSSP quos - Query On Steroids +-- Copyright (c) 2004 Ralf S. Engelschall +-- Copyright (c) 2004 The OSSP Project +-- +-- This file is part of OSSP quos, a Web user interface for querying +-- a database which can be found at http://www.ossp.org/pkg/tool/quos/. +-- +-- This program is free software; you can redistribute it and/or modify +-- it under the terms of the GNU General Public License as published by +-- the Free Software Foundation; either version 2 of the License, or +-- (at your option) any later version. +-- +-- This program is distributed in the hope that it will be useful, +-- but WITHOUT ANY WARRANTY; without even the implied warranty of +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU +-- General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License +-- along with this program; if not, write to the Free Software +-- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, +-- USA, or contact Ralf S. Engelschall . +-- +-- quos-openpkg.sql: OSSP quos database schema for OpenPKG XML/RDF +-- + +CREATE TABLE quos_rdf ( + rd_id BIGSERIAL UNIQUE NOT NULL PRIMARY KEY, + rd_url TEXT +); + +CREATE TABLE quos_package ( + pk_id BIGSERIAL UNIQUE NOT NULL PRIMARY KEY, + pk_name TEXT, + pk_version TEXT, + pk_release TEXT, + pk_distribution TEXT, + pk_group TEXT, + pk_license TEXT, + pk_packager TEXT, + pk_summary TEXT, + pk_url TEXT, + pk_vendor TEXT, + pk_description TEXT, + pk_rdf BIGINT UNIQUE NOT NULL + REFERENCES quos_rdf (rd_id) + MATCH FULL DEFERRABLE +); + +CREATE TABLE quos_buildprereq ( + bp_id BIGINT UNIQUE NOT NULL + REFERENCES quos_package (pk_id) + MATCH FULL DEFERRABLE + PRIMARY KEY, + bp_key TEXT, + bp_op TEXT, + bp_val TEXT, + bp_rdf BIGINT UNIQUE NOT NULL + REFERENCES quos_rdf (rd_id) + MATCH FULL DEFERRABLE +); + +CREATE TABLE quos_prereq ( + rp_id BIGINT UNIQUE NOT NULL + REFERENCES quos_package (pk_id) + MATCH FULL DEFERRABLE + PRIMARY KEY, + rp_key TEXT, + rp_op TEXT, + rp_val TEXT + rp_rdf BIGINT UNIQUE NOT NULL + REFERENCES quos_rdf (rd_id) + MATCH FULL DEFERRABLE +); + +CREATE TABLE quos_provide ( + pr_id BIGINT UNIQUE NOT NULL + REFERENCES quos_package (pk_id) + MATCH FULL DEFERRABLE + PRIMARY KEY, + pr_key TEXT, + pr_op TEXT, + pr_val TEXT + pr_rdf BIGINT UNIQUE NOT NULL + REFERENCES quos_rdf (rd_id) + MATCH FULL DEFERRABLE +); + +CREATE TABLE quos_source ( + sr_id BIGINT UNIQUE NOT NULL + REFERENCES quos_package (p_id) + MATCH FULL DEFERRABLE + PRIMARY KEY, + sr_url TEXT + sr_rdf BIGINT UNIQUE NOT NULL + REFERENCES quos_rdf (rd_id) + MATCH FULL DEFERRABLE +); + Index: ossp-pkg/quos/quos.cfg RCS File: /v/ossp/cvs/ossp-pkg/quos/quos.cfg,v co -q -kk -p'1.1' '/v/ossp/cvs/ossp-pkg/quos/quos.cfg,v' | diff -u /dev/null - -L'ossp-pkg/quos/quos.cfg' 2>/dev/null --- ossp-pkg/quos/quos.cfg +++ - 2024-05-20 02:37:40.242585047 +0200 @@ -0,0 +1,96 @@ +## +## OSSP quos - Query On Steroids +## Copyright (c) 2004 Ralf S. Engelschall +## Copyright (c) 2004 The OSSP Project +## +## This file is part of OSSP quos, a Web user interface for querying +## a database which can be found at http://www.ossp.org/pkg/tool/quos/. +## +## This program is free software; you can redistribute it and/or modify +## it under the terms of the GNU General Public License as published by +## the Free Software Foundation; either version 2 of the License, or +## (at your option) any later version. +## +## This program is distributed in the hope that it will be useful, +## but WITHOUT ANY WARRANTY; without even the implied warranty of +## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU +## General Public License for more details. +## +## You should have received a copy of the GNU General Public License +## along with this program; if not, write to the Free Software +## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, +## USA, or contact Ralf S. Engelschall . +## +## quos.cfg: configuration +## + +options { + webpage "quos.html" "%BODY%"; + database "dbi:SQLite:dbname=openpkg.db" { + fields { + field Name quos.package.pk_name; + field Version quos.package.pk_version; + field Release quos.package.pk_release; + field Distribution quos.package.pk_distribution; + field Group quos.package.pk_group; + field License quos.package.pk_license; + field Packager quos.package.pk_packager; + field Summary quos.package.pk_summary; + field URL quos.package.pk_url; + field Vendor quos.package.pk_vendor; + field Description quos.package.pk_description; + field BuildPreReq.Key quos_buildprereq.bp_key; + field BuildPreReq.Op quos_buildprereq.bp_op; + field BuildPreReq.Val quos_buildprereq.bp_val; + field PreReq.Key quos_prereq.rp_key; + field PreReq.Op quos_prereq.rp_op; + field PreReq.Val quos_prereq.rp_val; + field Provide.Key quos_provide.pr_key; + field Provide.Op quos_provide.pr_op; + field Provide.Val quos_provide.pr_val; + field Source quos_source.sr_url; + }; + relations { + key quos_package.pk_id { + quos_buildprereq.bp_id + quos_prereq.rp_id + quos_provide.pr_id + quos_source.sr_id + }; + }; + }; +}; + +queries { + group "by Group" { + query "Mail" { GROUP EQ "Mail" }; + query "News" { GROUP EQ "News" }; + }; + group "by Release" { + query "OpenPKG-2.2" { RELEASE RE "2\.2\.\d+$" }; + query "OpenPKG-CURRENT" { RELEASE RE "2\d{7}" }; + }; +}; + +views { + view "TXT: rpm -qa" q{ + [%{NAME}-%{VERSION}-%{RELEASE}\n] + }; + view "TXT: rpm -qi" q{ + Name: %-25{NAME} Source RPM: %{SOURCERPM}\n\ + Version: %-25{VERSION} Signature: %|DSAHEADER?{dsa:%{DSAHEADER:pgpsig}}:{%|RSAHEADER?{rsa:%{RSAHEADER:pgpsig}}:{%|SI + Release: %-25{RELEASE} Build Host: %{BUILDHOST}\n\ + Group: %-25{GROUP} Build System: %{ARCH}-%{OS}\n\ + Class: %-25{CLASS} Build Time: %{BUILDTIME:date}\n\ + Distrib: %-25{DISTRIBUTION} Install Time: %|INSTALLTIME?{%{INSTALLTIME:date}}:{(not installed)}|\n\ + License: %-25{LICENSE} Install Size: %{SIZE} bytes\n\ + Packager: %-25{PACKAGER} Relocations: %|PREFIXES?{[%{PREFIXES} ]}:{(not relocateable)}|\n\ + Vendor: %{VENDOR}\n\ + Summary: %{SUMMARY}\n\ + URL: %{URL}\n\ + Description:\n%{DESCRIPTION}\n\ + %|PROVIDENAME?{Provides:\n\ + [ %{PROVIDENAME} %|PROVIDEFLAGS?{%{PROVIDEFLAGS:depflags} %{PROVIDEVERSION}}:{}|\n]}:{}| + }; +}; + Index: ossp-pkg/quos/quos.cgi RCS File: /v/ossp/cvs/ossp-pkg/quos/quos.cgi,v co -q -kk -p'1.1' '/v/ossp/cvs/ossp-pkg/quos/quos.cgi,v' | diff -u /dev/null - -L'ossp-pkg/quos/quos.cgi' 2>/dev/null --- ossp-pkg/quos/quos.cgi +++ - 2024-05-20 02:37:40.245196368 +0200 @@ -0,0 +1,73 @@ +#!/usr/opkg/bin/perl +## +## OSSP quos - Query On Steroids +## Copyright (c) 2004 Ralf S. Engelschall +## Copyright (c) 2004 The OSSP Project +## +## This file is part of OSSP quos, a Web user interface for querying +## a database which can be found at http://www.ossp.org/pkg/tool/quos/. +## +## This program is free software; you can redistribute it and/or modify +## it under the terms of the GNU General Public License as published by +## the Free Software Foundation; either version 2 of the License, or +## (at your option) any later version. +## +## This program is distributed in the hope that it will be useful, +## but WITHOUT ANY WARRANTY; without even the implied warranty of +## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU +## General Public License for more details. +## +## You should have received a copy of the GNU General Public License +## along with this program; if not, write to the Free Software +## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, +## USA, or contact Ralf S. Engelschall . +## +## quos.cgi: web user interface +## + +require 5.008; +use CGI; +use String::Divert; + +# ...FIXME... + +my $html = ''; +$html .= "
"; +$html .= "..."; +$html .= "Browse"; +$html .= "..."; +$html .= "
"; +print STDOUT $html; + +__END__ + +=pod + +=head1 NAME + +B - Query On Steroids + +=head1 DESCRIPTION + +...FIXME... + +=head1 LOGICAL LAYOUT + +1. Browse + - Groups + . Hyperlinks +2. Query + - Groups + . Field (database schema) + . Operator (compare) + . Value (depends on compare) +3. View + - Selection predefined output format + - OSSP var based formatting string + - ordering + - save custom view +4. Result + - based on View + +=cut + Index: ossp-pkg/quos/quos.css RCS File: /v/ossp/cvs/ossp-pkg/quos/quos.css,v co -q -kk -p'1.1' '/v/ossp/cvs/ossp-pkg/quos/quos.css,v' | diff -u /dev/null - -L'ossp-pkg/quos/quos.css' 2>/dev/null --- ossp-pkg/quos/quos.css +++ - 2024-05-20 02:37:40.247964469 +0200 @@ -0,0 +1,35 @@ +/* +** OSSP quos - Query On Steroids +** Copyright (c) 2004 Ralf S. Engelschall +** Copyright (c) 2004 The OSSP Project +** +** This file is part of OSSP quos, a Web user interface for querying +** a database which can be found at http://www.ossp.org/pkg/tool/quos/. +** +** This program is free software; you can redistribute it and/or modify +** it under the terms of the GNU General Public License as published by +** the Free Software Foundation; either version 2 of the License, or +** (at your option) any later version. +** +** This program is distributed in the hope that it will be useful, +** but WITHOUT ANY WARRANTY; without even the implied warranty of +** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU +** General Public License for more details. +** +** You should have received a copy of the GNU General Public License +** along with this program; if not, write to the Free Software +** Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, +** USA, or contact Ralf S. Engelschall . +** +** quos.css: Cascading Style-Sheet (CSS) +*/ + +DIV.quos { + background: #f0f0f0; +} + +.quos SPAN.titlebrowse { + color: #ffffff; + background: #000000; +} + Index: ossp-pkg/quos/quos.html RCS File: /v/ossp/cvs/ossp-pkg/quos/quos.html,v co -q -kk -p'1.1' '/v/ossp/cvs/ossp-pkg/quos/quos.html,v' | diff -u /dev/null - -L'ossp-pkg/quos/quos.html' 2>/dev/null --- ossp-pkg/quos/quos.html +++ - 2024-05-20 02:37:40.250541900 +0200 @@ -0,0 +1,10 @@ + + + + + +

Quos Sample

+

+ %BODY% + +