- update to 3.0:

+ Qt3Support was removed
  + Recent files menu added
  + Improved UI, making it more modern, replacing some dialogs etc.
  + Syntax highlighting for SQL code
  + Cleaned up the code, reducing the SLOC quite a bit
  + Added basic support for triggers and views
  + Added pragma editing
  + Added BLOB support
  + Added a new filter row for searching
  + Improved performance when opening large tables
  + Extended the SQL tab
  + Added SQLite extension support
  + Fixed a ton of bugs
  + Probably more
- removed edittableform-fix-qdebug-use.patch
- removed sqlitebrowser-libs.patch

OBS-URL: https://build.opensuse.org/package/show/server:database/sqlitebrowser?expand=0&rev=2

sqlitebrowser-libs.patch

@@ -1,12 +0,0 @@
-Index: sqlitebrowser/sqlitebrowser.pro
-===================================================================
---- trunk/sqlitebrowser/sqlitebrowser/sqlitebrowser.pro.orig
-+++ trunk/sqlitebrowser/sqlitebrowser/sqlitebrowser.pro
-@@ -2,6 +2,7 @@ QT += qt3support
- TEMPLATE = app
- LANGUAGE = C++
- INCLUDEPATH += sqlite_source/
-+LIBS += -ldl
- CONFIG += qt \
-     warn_on
- HEADERS += extendedmainform.h \

sqlitebrowser-sqlb-3.0.tar.bz2

@@ -0,0 +1,3 @@
+version https://git-lfs.github.com/spec/v1
+oid sha256:61e8420653ac8597bd21ab14ae8c315cb075b84e2a34d73bd6d54f7f5fb7ea7a
+size 301894

sqlitebrowser.1

@@ -0,0 +1,35 @@
+.\"                                      Hey, EMACS: -*- nroff -*-
+.TH SQLITEBROWSER 1 "August  4, 2007"
+.SH NAME
+sqlitebrowser \- light GUI editor for SQLite databases
+.SH SYNOPSIS
+.B sqlitebrowser
+.RI [ file ]
+.SH DESCRIPTION
+.B SQLite Database Browser
+is a visual tool used to create, design and edit database files compatible with
+SQLite. It is meant to be used for users and developers that want to create
+databases, edit and search data using a familiar spreadsheet-like interface,
+without the need to learn complicated SQL commands.
+.SH SEE ALSO
+SQLitebrowser's home page:
+.IR "http://sqlitebrowser.sourceforge.net/".
+.SH AUTHOR
+.B sqlitebrowser
+was developed originally by Mauricio Piacentini from Tabuleiro Producoes. Icons
+were contributed by Raquel Ravanini, also from Tabuleiro. Jens Miltner
+contributed the code to support SQLite 3.x databases for the 1.2 release.
+.br
+In the spirit of the original SQLite source files, the authors disclaim
+copyright to this source code. It may be used as the basis for other programs,
+public domain, open source or commercial. Do whatever you want with it.
+.PP
+This manual page was written by Fran\[,c]ois F\['e]votte <francois.fevotte@ensta.org>,
+for the Debian project (but may be used by others).
+.br
+Permission is granted to copy, distribute and/or modify this document under the
+terms of the GNU General Public License, Version 2 or any later version
+published by the Free Software Foundation.
+.br
+On Debian systems, the complete text of the GNU General Public License can be
+found in /usr/share/common-licenses/GPL.

sqlitebrowser.changes

@@ -1,3 +1,24 @@
+-------------------------------------------------------------------
+Thu Nov  7 13:20:45 UTC 2013 - lars@linux-schulserver.de
+
+- update to 3.0:
+  + Qt3Support was removed
+  + Recent files menu added
+  + Improved UI, making it more modern, replacing some dialogs etc.
+  + Syntax highlighting for SQL code
+  + Cleaned up the code, reducing the SLOC quite a bit
+  + Added basic support for triggers and views
+  + Added pragma editing
+  + Added BLOB support
+  + Added a new filter row for searching
+  + Improved performance when opening large tables
+  + Extended the SQL tab
+  + Added SQLite extension support
+  + Fixed a ton of bugs
+  + Probably more
+- removed edittableform-fix-qdebug-use.patch
+- removed sqlitebrowser-libs.patch
+
 -------------------------------------------------------------------
 Thu Sep 29 07:24:24 UTC 2011 - lars@linux-schulserver.de
 

sqlitebrowser.spec

@@ -1,5 +1,7 @@
 #
-# spec file for package sqlistebrowser
+# spec file for package sqlitebrowser
+#
+# Copyright (c) 2012 SUSE LINUX Products GmbH, Nuernberg, Germany.
 #
 # All modifications and additions to the file contributed by third parties
 # remain the property of their copyright owners, unless otherwise agreed
@@ -10,19 +12,19 @@
 # license that conforms to the Open Source Definition (Version 1.9)
 # published by the Open Source Initiative.
 
-# norootforbuild
+# Please submit bugfixes or comments via http://bugs.opensuse.org/
-
+#
 
 Name:           sqlitebrowser
-Summary:        Create, design and edit SQLite Databases 
+Version:        3.0
-Version:        2.0.2
 Release:        1
-License:        GPLv2
+License:        GPL-2.0+
+Summary:        Create, design and edit SQLite Databases
+Url:            https://github.com/rp-/sqlitebrowser/
 Group:          Productivity/Office/Organizers
-Url:            http://sqlitebrowser.sourceforge.net/
+# https://github.com/rp-/sqlitebrowser/releases
-Vendor:         openSUSE-Education
+Source0:        %{name}-sqlb-%{version}.tar.bz2
-Source0:        sqlitebrowser_200_b1a_src.tar.bz2
+Source1:        sqlitebrowser.1
-Patch0:         sqlitebrowser-libs.patch
 %if 0%{?suse_version}
 BuildRequires:  update-desktop-files
 %endif
@@ -30,13 +32,13 @@ BuildRequires:  autoconf
 BuildRequires:  automake
 BuildRequires:  gcc
 BuildRequires:  gcc-c++
+BuildRequires:  libQtWebKit-devel
+BuildRequires:  libqt4-devel
 BuildRequires:  make
 BuildRequires:  sqlite3-devel
-BuildRequires:  libqt4-devel
-BuildRequires:  libQtWebKit-devel
 BuildRequires:  update-desktop-files
-%if 0%{suse_version} > 1100
+%if 0%{?suse_version} > 1100
-BuildRequires:  glib2-devel
+BuildRequires:  pkgconfig(glib-2.0)
 %endif
 BuildRoot:      %{_tmppath}/%{name}-%{version}-build
 
@@ -59,29 +61,19 @@ to:
 	* Issue SQL queries and inspect the results
 	* Examine a log of all SQL commands issued by the application
 
-
 %prep
-%setup -q -n trunk/sqlitebrowser
+%setup -q -n %{name}-sqlb-%{version}
-%patch0 -p2
-pushd sqlitebrowser/sqlite_source/
-rm *.h
-cp %{_includedir}/sqlite3* .
-popd
-# fix documentation
-pushd sqlitebrowser/
-sed -i "s|
||" *.txt
-chmod -x *.txt
-popd
 
 %build
 qmake
-%__make %{?_smp_mflags}
+make %{?_smp_mflags}
 
 %install
-%makeinstall
+%make_install
 mkdir -p %{buildroot}/%{_bindir} %{buildroot}/%{_datadir}/{applications,pixmaps}
-install -m755 sqlitebrowser/sqlitebrowser %{buildroot}/%{_bindir}/
+install -m755 src/sqlitebrowser %{buildroot}/%{_bindir}/
-install -m644 sqlitebrowser/images/128.png %{buildroot}/%{_datadir}/pixmaps/%{name}.png
+install -Dm644 %{SOURCE1} %{buildroot}/%{_mandir}/man1/%{name}.1
+install -m644 images/%{name}.png %{buildroot}/%{_datadir}/pixmaps/%{name}.png
 cat >> %{buildroot}/%{_datadir}/applications/%{name}.desktop << EOF
 [Desktop Entry]
 Categories=Application;Network;GNOME;GTK;System;X-SuSE-ServiceConfiguration;
@@ -98,7 +90,7 @@ EOF
 %endif
 
 %clean
-rm -fr %buildroot
+rm -fr %{buildroot}
 
 %if 0%{?suse_version} > 1130
 %post
@@ -111,7 +103,8 @@ rm -fr %buildroot
 
 %files
 %defattr(-,root,root)
-%doc sqlitebrowser/*.txt
+%doc README.rst LICENSE
+%{_mandir}/man1/%{name}.1*
 %{_bindir}/*
 %{_datadir}/applications/*
 %{_datadir}/pixmaps/*

sqlitebrowser_200_b1a_src.tar.bz2

@@ -1,3 +0,0 @@
-version https://git-lfs.github.com/spec/v1
-oid sha256:775ef0204cdcb04b7914894f6ec3f3f866e7fbc9ba97a290010cac2c67b8d430
-size 1730020