Initial import

5 files changed, 201 insertions, 0 deletions

diff --git a/.SRCINFO b/.SRCINFO
new file mode 100644
index 000000000000..de397ddfc192
--- /dev/null
+++ b/.SRCINFO
@@ -0,0 +1,27 @@
+pkgbase = postsqlforms
+	pkgdesc = A GUI for rapidly building forms and reports for PostgreSQL and SQLite
+	pkgver = 1.0.4
+	pkgrel = 1
+	url = http://sourceforge.org/projects/postsqlforms
+	arch = any
+	license = GPL2
+	depends = tcl>=8.6.0
+	depends = tk>=8.6.0
+	depends = sqlite-tcl>=3.7.14
+	depends = pgintcl>=3.4.0
+	optdepends = postgresql>=8.3.0: for using PostSqlForms with PostgreSQL
+	optdepends = sqlite>=3.7.14: for using PostSqlForms with SQLite
+	optdepends = a2ps: for printing plain text reports
+	optdepends = ghostscript: for converting output from a2ps to PDF using ps2pdf
+	optdepends = evince: for viewing PDF files generated by ps2pdf
+	source = http://downloads.sourceforge.net/postsqlforms/psf-1.0.4/psf-1.0.4-source.tar.gz
+	source = postsqlforms.conf
+	source = psf-launch-script
+	source = psf-postsqlforms.desktop
+	md5sums = 41b03e387ec5c70982b929a5d39d846e
+	md5sums = 6126450aaaf282dd3b68bd136405a2b9
+	md5sums = b5956be0f29904ba6e91d8a9bb2b3061
+	md5sums = 5a21aa73cf20e6a8c30b1f95e2e4fc08
+
+pkgname = postsqlforms
+
diff --git a/PKGBUILD b/PKGBUILD
new file mode 100644
index 000000000000..f12b43e4119b
--- /dev/null
+++ b/PKGBUILD
@@ -0,0 +1,108 @@
+# Maintainer: Willem Herremans <whpgf at scarlet dot be>
+pkgname=postsqlforms
+pkgver=1.0.4
+pkgrel=1
+pkgdesc="A GUI for rapidly building forms and reports for PostgreSQL and SQLite"
+arch=('any')
+url="http://sourceforge.org/projects/postsqlforms"
+license=('GPL2')
+depends=('tcl>=8.6.0' 'tk>=8.6.0' 'sqlite-tcl>=3.7.14' 'pgintcl>=3.4.0' )
+optdepends=('postgresql>=8.3.0: for using PostSqlForms with PostgreSQL'
+            'sqlite>=3.7.14: for using PostSqlForms with SQLite'
+            'a2ps: for printing plain text reports'
+            'ghostscript: for converting output from a2ps to PDF using ps2pdf'
+            'evince: for viewing PDF files generated by ps2pdf')
+source=(http://downloads.sourceforge.net/postsqlforms/psf-$pkgver/psf-$pkgver-source.tar.gz
+       postsqlforms.conf psf-launch-script psf-postsqlforms.desktop)
+md5sums=('41b03e387ec5c70982b929a5d39d846e'
+         '6126450aaaf282dd3b68bd136405a2b9'
+         'b5956be0f29904ba6e91d8a9bb2b3061'
+         '5a21aa73cf20e6a8c30b1f95e2e4fc08')
+package() {
+  cd $srcdir/psf-$pkgver-source
+# /usr/bin
+  install -d $pkgdir/usr/bin
+  install -m755 $srcdir/psf-launch-script $pkgdir/usr/bin/postsqlforms
+# /usr/share/postsqlforms  
+  install -d $pkgdir/usr/share/$pkgname
+  install -m644 config.tcl $pkgdir/usr/share/$pkgname
+  install -m644 database.tcl $pkgdir/usr/share/$pkgname
+  install -m644 forms.tcl $pkgdir/usr/share/$pkgname
+  install -m644 generic.tcl $pkgdir/usr/share/$pkgname
+  install -m644 main.tcl $pkgdir/usr/share/$pkgname
+  install -m644 misc.tcl $pkgdir/usr/share/$pkgname
+  install -m644 options.tcl $pkgdir/usr/share/$pkgname
+  install -m644 parse.tcl $pkgdir/usr/share/$pkgname
+  install -m644 postgresql.tcl $pkgdir/usr/share/$pkgname
+  install -m644 report.tcl $pkgdir/usr/share/$pkgname
+  install -m644 sqlite.tcl $pkgdir/usr/share/$pkgname
+  install -m644 sql.tcl $pkgdir/usr/share/$pkgname
+# /usr/share/doc/postsqlforms  
+  install -d $pkgdir/usr/share/doc/$pkgname
+  install -m644 CHANGE_LOG.txt $pkgdir/usr/share/doc/$pkgname
+  install -m644 README.txt $pkgdir/usr/share/doc/$pkgname
+  install -m644 doc/addressbook.png $pkgdir/usr/share/doc/$pkgname
+  install -m644 doc/arrow_down.png $pkgdir/usr/share/doc/$pkgname
+  install -m644 doc/arrow_right.png $pkgdir/usr/share/doc/$pkgname
+  install -m644 doc/customerdb.png $pkgdir/usr/share/doc/$pkgname
+  install -m644 doc/database_window.png $pkgdir/usr/share/doc/$pkgname
+  install -m644 doc/form_window.png $pkgdir/usr/share/doc/$pkgname
+  install -m644 doc/help.png $pkgdir/usr/share/doc/$pkgname
+  install -m644 doc/help-styles.css $pkgdir/usr/share/doc/$pkgname
+  install -m644 doc/index.html $pkgdir/usr/share/doc/$pkgname
+  install -m644 doc/main_window.png $pkgdir/usr/share/doc/$pkgname
+  install -m644 doc/open_form.png $pkgdir/usr/share/doc/$pkgname
+  install -m644 doc/options.png $pkgdir/usr/share/doc/$pkgname
+  install -m644 doc/print_result.png $pkgdir/usr/share/doc/$pkgname
+  install -m644 doc/psf-logo.png $pkgdir/usr/share/doc/$pkgname
+  install -m644 doc/schema.png $pkgdir/usr/share/doc/$pkgname
+  install -m644 doc/sql_window.png   $pkgdir/usr/share/doc/$pkgname
+# /usr/share/doc/en  
+  install -d $pkgdir/usr/share/doc/$pkgname/en
+  install -m644 doc/en/body.html $pkgdir/usr/share/doc/$pkgname/en
+  install -m644 doc/en/contents.html $pkgdir/usr/share/doc/$pkgname/en
+  install -m644 doc/en/index.html $pkgdir/usr/share/doc/$pkgname/en
+# /usr/share/postsqlforms/examples/postgresql
+  install -d $pkgdir/usr/share/$pkgname/examples
+  install -d $pkgdir/usr/share/$pkgname/examples/postgresql
+  install -m644 examples/postgresql/addressbook.sql $pkgdir/usr/share/$pkgname/examples/postgresql
+  install -m644 examples/postgresql/customerdb.sql $pkgdir/usr/share/$pkgname/examples/postgresql
+# /usr/share/postsqlforms/examples/sqlite
+  install -d $pkgdir/usr/share/$pkgname/examples/sqlite
+  install -m644 examples/sqlite/addressbook.sql $pkgdir/usr/share/$pkgname/examples/sqlite
+  install -m644 examples/sqlite/customerdb.sql $pkgdir/usr/share/$pkgname/examples/sqlite
+# /usr/share/postsqlforms/icons
+  install -d $pkgdir/usr/share/$pkgname/icons
+  install -m644 icons/arrow_down.xbm $pkgdir/usr/share/$pkgname/icons
+  install -m644 icons/arrow_end.xbm $pkgdir/usr/share/$pkgname/icons
+  install -m644 icons/arrow_home.xbm $pkgdir/usr/share/$pkgname/icons
+  install -m644 icons/arrow_left.xbm $pkgdir/usr/share/$pkgname/icons
+  install -m644 icons/arrow_right.xbm $pkgdir/usr/share/$pkgname/icons
+  install -m644 icons/arrow_top.xbm $pkgdir/usr/share/$pkgname/icons
+  install -m644 icons/arrow_up.xbm $pkgdir/usr/share/$pkgname/icons
+  install -m644 icons/empty_5_9.xbm $pkgdir/usr/share/$pkgname/icons
+  install -m644 icons/empty_9_5.xbm $pkgdir/usr/share/$pkgname/icons
+  install -m644 icons/expand.xbm $pkgdir/usr/share/$pkgname/icons
+  install -m644 icons/help.xbm $pkgdir/usr/share/$pkgname/icons
+  install -m644 icons/home_dir.xbm $pkgdir/usr/share/$pkgname/icons
+  install -m644 icons/psf-icon.png $pkgdir/usr/share/$pkgname/icons
+  install -m644 icons/reset.xbm $pkgdir/usr/share/$pkgname/icons
+# /usr/share/licenses/postsqlforms
+  install -d $pkgdir/usr/share/$pkgname/license
+  ln -s /usr/share/licenses/common/GPL2/license.txt $pkgdir/usr/share/$pkgname/license/gpl.txt
+# /usr/share/postsqlforms/msgs
+  install -d $pkgdir/usr/share/$pkgname/msgs
+  install -m644 msgs/ROOT.msg $pkgdir/usr/share/$pkgname/msgs
+# /usr/share/postsqlforms/postgresql
+  install -d $pkgdir/usr/share/$pkgname/postgresql
+  install -m644 postgresql/pfm_tables.sql $pkgdir/usr/share/$pkgname/postgresql
+# /usr/share/postsqlforms/sqlite
+  install -d $pkgdir/usr/share/$pkgname/sqlite
+  install -m644 sqlite/pfm_tables.sql $pkgdir/usr/share/$pkgname/sqlite
+# /etc
+  install -d $pkgdir/etc
+  install -m644 $srcdir/postsqlforms.conf $pkgdir/etc
+# /usr/share/applications
+  install -d $pkgdir/usr/share/applications
+  install -m644 $srcdir/psf-postsqlforms.desktop $pkgdir/usr/share/applications
+}
diff --git a/postsqlforms.conf b/postsqlforms.conf
new file mode 100644
index 000000000000..9a4006990675
--- /dev/null
+++ b/postsqlforms.conf
@@ -0,0 +1,52 @@
+# postsqlforms.conf
+
+# This is the configuration file of PostSqlForms on UNIX platforms.
+
+# Written by Willem Herremans.
+
+# pfm.conf is installed either in pfm's installation directory or in
+# /etc.  If main.tcl does not find it in its installation directory, it
+# looks for it in /etc.
+
+# The syntax of this file is the following:
+#
+# - Every empty line is ignored;
+#
+# - Every line starting with a "#" is a comment line;
+#
+# - Every other line should be a Tcl list (i.e. a space separated list)
+#   containg 2 items where the first item is the name of a configuration
+#   parameter and the second item its value. If a value contains spaces
+#   enclose it in { and }.
+#
+
+# docDir: the directory in which the package documentation
+#         is installed. If it is a relative pathname, it is assumed to be
+#         relative to the installation directory.
+
+docDir /usr/share/doc/postsqlforms
+
+# licenseDir: 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.
+
+licenseDir /usr/share/postsqlforms/license
+
+# 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 /usr/share/postsqlforms/examples
+
+# languagdeDir: the directory which contains the user interface
+#               strings for all languages.
+
+languageDir /usr/share/postsqlforms/msgs
+
+# defaultBrowser: the default value for the "browser" option.
+
+defaultBrowser {xdg-open %s}
+
+# defaultPrintcmd: the default value for the "printcmd" option.
+
+defaultPrintcmd {{a2ps --output=%ps --$(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) %txt} {ps2pdf -sPAPERSIZE=a4 %ps %pdf} {evince %pdf}}
diff --git a/psf-launch-script b/psf-launch-script
new file mode 100644
index 000000000000..820b82d2be33
--- /dev/null
+++ b/psf-launch-script
@@ -0,0 +1,3 @@
+#!/bin/sh
+exec /usr/bin/tclsh /usr/share/postsqlforms/main.tcl
+exit
diff --git a/psf-postsqlforms.desktop b/psf-postsqlforms.desktop
new file mode 100644
index 000000000000..6310c57a5a14
--- /dev/null
+++ b/psf-postsqlforms.desktop
@@ -0,0 +1,11 @@
+[Desktop Entry]
+Version=1.0
+Encoding=UTF-8
+Name=PostSqlForms
+Type=Application
+Exec=/usr/bin/tclsh /usr/share/postsqlforms/main.tcl
+Icon=/usr/share/postsqlforms/icons/psf-icon.png
+Terminal=false
+GenericName=PostSqlForms
+Comment=Graphical user interface for PostgreSQL and SQLite databases
+Categories=Office;Database;