--- pfm-1.5.4.orig/debian/docs +++ pfm-1.5.4/debian/docs @@ -0,0 +1,15 @@ +README.txt +doc/addressbook.png +doc/form_window.png +doc/query_window.png +doc/body.html +doc/help-styles.css +doc/report_window.png +doc/contents.html +doc/index.html +doc/options.png +doc/schema.png +doc/customerdb.png +doc/main_window.png +doc/print_result.png +doc/sql_window.png --- pfm-1.5.4.orig/debian/control +++ pfm-1.5.4/debian/control @@ -0,0 +1,36 @@ +Source: pfm +Section: misc +Priority: optional +Maintainer: Mark Hindley +Build-Depends: debhelper (>= 4.0.0) +Standards-Version: 3.7.2 + +Package: pfm +Architecture: all +Depends: tcl8.4, tk8.4, libpgtcl | libpgtcl1.5, postgresql-client +Suggests: postgresql +Description: PostgreSQL graphical client using Tcl/Tk + Postgres Forms (pfm) is a client application with a graphical user + interface for the PostgreSQL data base server. It enables the user: + to design forms for adding, modifying or deleting records of data + base tables; + . + - to design links (one to many relationships) from one form + to another, for navigating in the data base; + . + - to design and to generate reports based on the data in a + table or view; + . + - to edit and to execute SQL statements. + . + Postgres Forms is implemented in Tcl/Tk, but there is no need for the + user to program anything in Tcl/Tk. The user only has to use SQL for + creating tables and views and for designing forms, links and reports. + . + Postgres Forms makes no attempt to hide the underlying SQL. On the + contrary, in most cases, it shows both the SQL statements it sends to + the PostgreSQL server and the results it gets back. + . + The PostgreSQL server can be remote or local. + . + Homepage: http://pgfoundry.org/projects/pfm/ --- pfm-1.5.4.orig/debian/watch +++ pfm-1.5.4/debian/watch @@ -0,0 +1,3 @@ +version=3 + +http://pgfoundry.org/frs/?group_id=1000236 /frs/download.php/\d+/pfm-([\d\.]+)\.tar\.gz --- pfm-1.5.4.orig/debian/README.Debian +++ pfm-1.5.4/debian/README.Debian @@ -0,0 +1,8 @@ +pfm for Debian +-------------- + + The Debian version of pfm uses native Tcl/Tk and libpgtcl. + A version using tclkit and/or pginctl is also available upstream. + + + -- Mark Hindley , Fri May 5 05:34:07 2006 --- pfm-1.5.4.orig/debian/install +++ pfm-1.5.4/debian/install @@ -0,0 +1,11 @@ +pfm usr/bin +pfm.tcl usr/share/pfm +pfm.conf /etc +arrow_down*.xbm /usr/share/pfm +install_pfm.sql usr/share/pfm +help/help_*.txt /usr/share/pfm/help +examples/install_addressbook.sql /usr/share/pfm/examples +examples/install_customerdb.sql /usr/share/pfm/examples +convert_from_1.0.4.sql /usr/share/pfm +convert_from_1.1.0.sql /usr/share/pfm +convert_from_1.2.0.sql /usr/share/pfm --- pfm-1.5.4.orig/debian/copyright +++ pfm-1.5.4/debian/copyright @@ -0,0 +1,115 @@ +This package was debianized by Mark Hindley on +Thu, 7 Aug 2007 16:01:49 +0100. + +It was downloaded from http://pgfoundry.org/projects/pfm/ + +The source tarball also includes tclkit and versions of pgintcl. + +Copyright Holders: + pfm is Copyright (C) 2004-2007 Willem Herremans (GPL) + tclkit is Copyright (C) 1996-2007 Jean-Claude Wippler (X/MIT-ish) + pgintcl is Copyright (C) 1998-2006 ljb (BSD-ish) + +Licenses for the different components are reproduced below. + +pfm +=== + + Postgres Forms (pfm) is a client application for PostgreSQL. + + Copyright (C) 2004-2007 Willem Herremans + + 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., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301, + USA. + + A copy of the GNU General Public License is available as + /usr/share/common-licenses/GPL in the Debian GNU/Linux distribution + or on the World Wide Web at the GNU web site. You can also obtain it + by writing to the Free Software Foundation, Inc., 51 Franklin St, + Fifth Floor, Boston, MA 02110-1301, USA. + + A copy of the GNU General Public License can be displayed with the + menu item 'License' under 'Help'. + +tclkit +====== + + Tclkit is a combination of Tcl/Tk, IncrTcl, TclVFS, Zlib, and + Metakit. Metakit is open source, using an X/MIT-style + license. Tcl/Tk, IncrTcl, TclVFS, and Zlib have their own, BSD-ish + open source licenses. + + Copyright (c) 1996-2007 Jean-Claude Wippler + + Permission is hereby granted, free of charge, to any person obtaining + a copy of this software and associated documentation files (the + "Software"), to deal in the Software without restriction, including + without limitation the rights to use, copy, modify, merge, publish, + distribute, sublicense, and/or sell copies of the Software, and to + permit persons to whom the Software is furnished to do so, subject to + the following conditions: + + The above copyright notice and this permission notice shall be + included in all copies or substantial portions of the Software. + + THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, + EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF + MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND + NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS + BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN + ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN + CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE + SOFTWARE. + + When Tclkit is distributed as part of a commercial package, copyright + attributions and license terms for the above need to be included in the + distribution. + + A reference to the origin of Tclkit is appreciated but not required. + + Metakit is a trademark of Equi4 Software. + +pgintcl +======= + + This is the copyright notice and license for pgin.tcl. The wording is + from the Tcl and Tcllib licenses, and is essentially equivalent to + the Berkeley/BSD license. + --------------------------------------------------------------------- + This software is Copyright (c) 1998-2006 ljb + + The authors hereby grant permission to use, copy, modify, distribute, + and license this software and its documentation for any purpose, + provided that existing copyright notices are retained in all copies + and that this notice is included verbatim in any distributions. No + written agreement, license, or royalty fee is required for any of the + authorized uses. Modifications to this software may be copyrighted + by their authors and need not follow the licensing terms described + here, provided that the new terms are clearly indicated on the first + page of each file where they apply. + + IN NO EVENT SHALL THE AUTHORS OR DISTRIBUTORS BE LIABLE TO ANY PARTY + FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES + ARISING OUT OF THE USE OF THIS SOFTWARE, ITS DOCUMENTATION, OR ANY + DERIVATIVES THEREOF, EVEN IF THE AUTHORS HAVE BEEN ADVISED OF THE + POSSIBILITY OF SUCH DAMAGE. + + THE AUTHORS AND DISTRIBUTORS SPECIFICALLY DISCLAIM ANY WARRANTIES, + INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF + MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND + NON-INFRINGEMENT. THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, AND + THE AUTHORS AND DISTRIBUTORS HAVE NO OBLIGATION TO PROVIDE + MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. + --------------------------------------------------------------------- --- pfm-1.5.4.orig/debian/menu +++ pfm-1.5.4/debian/menu @@ -0,0 +1,4 @@ +?package(pfm):needs="X11" \ + section="Applications/Data Management" \ + title="Postgres Forms (pfm)" \ + command="/usr/bin/pfm" --- pfm-1.5.4.orig/debian/links +++ pfm-1.5.4/debian/links @@ -0,0 +1 @@ +usr/share/common-licenses/GPL-2 usr/share/pfm/help/gpl.txt --- pfm-1.5.4.orig/debian/dirs +++ pfm-1.5.4/debian/dirs @@ -0,0 +1 @@ +usr/bin --- pfm-1.5.4.orig/debian/compat +++ pfm-1.5.4/debian/compat @@ -0,0 +1 @@ +4 --- pfm-1.5.4.orig/debian/pfm.manpage +++ pfm-1.5.4/debian/pfm.manpage @@ -0,0 +1,48 @@ +.\" Hey, EMACS: -*- nroff -*- +.\" First parameter, NAME, should be all caps +.\" Second parameter, SECTION, should be 1-8, maybe w/ subsection +.\" other parameters are allowed: see man(7), man(1) +.TH PFM 1 "Aug 8, 2007" +.\" Please adjust this date whenever revising the manpage. +.\" +.\" Some roff macros, for reference: +.\" .nh disable hyphenation +.\" .hy enable hyphenation +.\" .ad l left justify +.\" .ad b justify to both left and right margins +.\" .nf disable filling +.\" .fi enable filling +.\" .br insert line break +.\" .sp insert n+1 empty lines +.\" for manpage-specific macros, see man(7) +.SH NAME +pfm \- Graphical PostgreSQL client using Tcl/Tk +.SH SYNOPSIS +.B pfm +.SH DESCRIPTION +This manual page documents briefly the +.B pfm +command. +.PP +.B pfm +(Postgres Forms) is a graphical PostgreSQL client. +.br +It allows the creation of forms to access data within a database. +.br +Related queries can be explored by the use of links between forms. +.SH OPTIONS +None +.SH SEE ALSO +.BR postgres (1), +.BR psql (1). +.br +The program documentation can be found at +.IR "/usr/share/doc/pfm/help.html". +.SH AUTHOR +pfm was written by Willem Herremans . +.PP +Homepage: http://pgfoundry.org/projects/pfm/ +. +.PP +This manual page was written by Mark Hindley , +for the Debian project (but may be used by others). --- pfm-1.5.4.orig/debian/rules +++ pfm-1.5.4/debian/rules @@ -0,0 +1,44 @@ +#!/usr/bin/make -f +# -*- makefile -*- + +# Uncomment this to turn on verbose mode. +#export DH_VERBOSE=1 + +build: + # Nothing to do + +clean: + dh_testdir + dh_testroot + dh_clean + +install: build + dh_testdir + dh_testroot + dh_clean -k + dh_installdirs + + +# Build architecture-independent files here. +binary-indep: build install +# Nothing to do + +# Build architecture-dependent files here. +binary-arch: build install + dh_testdir + dh_testroot + dh_installchangelogs CHANGE_LOG.txt + dh_installdocs + dh_link + dh_install + dh_installmenu + dh_installman debian/pfm.manpage + dh_compress + dh_fixperms + dh_installdeb + dh_gencontrol + dh_md5sums + dh_builddeb + +binary: binary-indep binary-arch +.PHONY: build clean binary-indep binary-arch binary install --- pfm-1.5.4.orig/debian/changelog +++ pfm-1.5.4/debian/changelog @@ -0,0 +1,79 @@ +pfm (1.5.4-1) unstable; urgency=low + + * New upstream release + + -- Mark Hindley Wed, 31 Oct 2007 09:58:17 +0000 + +pfm (1.5.3-1) unstable; urgency=low + + * New upstream release + * Add missing dependency on postgresql-client. + * Add watch file. + + -- Mark Hindley Sat, 22 Sep 2007 23:33:07 +0100 + +pfm (1.5.2-1) unstable; urgency=low + + * New upstream release + - Fixes convert_from_1.2.0.sql with postgresql 7.4 + + -- Mark Hindley Tue, 21 Aug 2007 10:31:04 +0100 + +pfm (1.5.1-3) unstable; urgency=low + + * Add tclkit and pgintcl to copyright file. + + -- Mark Hindley Tue, 21 Aug 2007 10:18:59 +0100 + +pfm (1.5.1-2) unstable; urgency=low + + * Update upstream URL. + * Move menu entry to Applications/Data Management. + * Install convert_from_1.2.0.sql. + + -- Mark Hindley Wed, 08 Aug 2007 14:05:59 +0100 + +pfm (1.5.1-1) unstable; urgency=low + + * New upstream release. + + -- Mark Hindley Tue, 07 Aug 2007 15:14:29 +0100 + +pfm (1.4.2-1) unstable; urgency=low + + * New upstream release. + + -- Mark Hindley Wed, 11 Oct 2006 11:46:24 +0100 + +pfm (1.3.0-2) unstable; urgency=low + + * Include SQL scripts to update old databases. + + -- Mark Hindley Fri, 2 Jun 2006 15:44:34 +0100 + +pfm (1.3.0-1) unstable; urgency=low + + * New upstream release + * Don't include a separate version of GPL, but link to the one in + base-files. + + -- Mark Hindley Fri, 2 Jun 2006 13:34:27 +0100 + +pfm (1.2.5-3) unstable; urgency=low + + * doc/addressbook.png was missing. Include it. + + -- Mark Hindley Sat, 20 May 2006 17:05:12 +0100 + +pfm (1.2.5-2) unstable; urgency=low + + * Add libpgtcl1.5 as explicit alternative dependency for Ubuntu. + + -- Mark Hindley Fri, 19 May 2006 16:41:08 +0100 + +pfm (1.2.5-1) unstable; urgency=low + + * Initial packaging for Debian. (closes: #365995) + + -- Mark Hindley Thu, 4 May 2006 11:01:49 +0100 + --- pfm-1.5.4.orig/pfm +++ pfm-1.5.4/pfm @@ -0,0 +1,5 @@ +#!/bin/sh +# pfm launch script, for Debian + +exec /usr/bin/tclsh /usr/share/pfm/pfm.tcl /usr/share/pfm + --- pfm-1.5.4.orig/pfm.conf +++ pfm-1.5.4/pfm.conf @@ -24,24 +24,24 @@ # is installed. If it is a relative pathname, it is assumed to be # relative to the installation directory. -docDir doc +docDir /usr/share/doc/pfm # helpDir: the directory which contains the text of the GNU licence # and the help texts for the options. If it is a relative pathname, # it is assumed to be relative to the installation directory. -helpDir help +helpDir /usr/share/pfm/help # exampleDir: the directory which contains the example databases. If # it is a relative pathname, it is assumed to be relative to the # installation directory. -exampleDir examples +exampleDir /usr/share/pfm/examples # defaultBrowser: the default value for the "browser" option. -defaultBrowser {firefox %s} +defaultBrowser {sensible-browser %s} # defaultPrintcmd: the default value for the "printcmd" option. -defaultPrintcmd {a2ps --output=- --$(portrait_or_landscape=portrait) --rows=$(nr-of-rows=1) --columns=$(nr-of-columns=1) --major=rows --chars-per-line=$(nr_of_chars_per_line=90) --center-title=$(title=Report) | gnome-gv -} +defaultPrintcmd {lpr}