Accepting request 396731 from server:database

Automatic submission by obs-autosubmit

OBS-URL: https://build.opensuse.org/request/show/396731
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/sqlitebrowser?expand=0&rev=6

sqlitebrowser-3.7.0.tar.gz

@@ -1,3 +0,0 @@
-version https://git-lfs.github.com/spec/v1
-oid sha256:3093a1dcf5b3138c1adf29857d62249ab2b068e70b001869a31151763e28cc3a
-size 1509766

sqlitebrowser-3.8.0.tar.gz

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

sqlitebrowser.1

@@ -13,7 +13,7 @@ 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/".
+.IR "http://sqlitebrowser.org/".
 .SH AUTHOR
 .B sqlitebrowser
 was developed originally by Mauricio Piacentini from Tabuleiro Producoes. Icons
@@ -30,6 +30,3 @@ for the Debian project (but may be used by others).
 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,70 @@
+-------------------------------------------------------------------
+Thu May 12 08:05:33 UTC 2016 - mpluskal@suse.com
+
+- Update dependencies
+
+-------------------------------------------------------------------
+Sun Apr 10 09:55:39 UTC 2016 - mpluskal@suse.com
+
+- Drop some build dependencies
+  * autotools are not used
+- Add macros for icons
+- Add correct dependencies for post/postun macros
+- Use cmake macros
+- Drop some conditional build dependencies for unsupported releases
+- Build with qt5 where possible
+
+-------------------------------------------------------------------
+Sat Apr  9 15:32:00 UTC 2016 - mailaender@opensuse.org
+
+- update to version 3.8.0
+  * Enhancements
+    - Add proper file extension filters to all file dialogs - 6b8f57d (thanks to @MKleusberg)
+    - Improved error handling, e.g. more error messages with more detailed error descriptions - #362, #363, 1696ad1 (thanks to @schdub and @MKleusberg)
+    - Allow changing table columns even when there is a foreign key constraint on the table - #362 (thanks to @MKleusberg)
+    - When holding Ctrl and Shift while clicking on a cell with a foreign key set, the browser now jumps to the referenced record - #192 (thanks to @MKleusberg)
+    - Add option for disabling the SQL error indicators in the Execute SQL area - #302 (thanks to @MKleusberg)
+    - Add an option for setting the colours of fields with regular and binary data - #377 (thanks to @schdub)
+    - Use the name of the imported file as default suggestion for a table name during CSV import - #376 (thanks to @MKleusberg)
+    - Save filter values, sort order and column widths for all tables when switching the current table or tab; also save the settings in the project file - 748f06d (thanks to @MKleusberg)
+    - Show a small clear button inside each filter box - 944e22a (thanks to @MKleusberg)
+    - Add basic support for different 'display formats', i.e. a conversion of the contents of a column into a different format for display purposes (e.g. converting a Unix epoch into an actual date) - 7c1d237, 22e858d (thanks to @MKleusberg)
+    - Remove deleted files from list of recently opened files - #379 (thanks to @MKleusberg)
+    - Add a new option for horizontal tiling of the code and result view in the Execute SQL area - #380 (thanks to @MKleusberg)
+    - Move execution time of the SQL statement to the top of the result view in the Execute SQL area - #381 (thanks to @MKleusberg)
+    - Add 'x rows affected' information to the result view of the Execute SQL area - 82292c2 (thanks to @MKleusberg)
+    - Add built-in UTF16 and UTF16CI collation - #391 (thanks to @sebastian-philipp)
+    - Add Ctrl+R shortcut (besides F5) for the refresh table button - #388 (thanks to @MKleusberg)
+    - Add option for setting the font and font size of the text in the table browser view - #383 (thanks to @MKleusberg)
+    - Support opening of read only database files - #402 (thanks to @MKleusberg)
+    - Add option for showing the rowid column in the data browser view - #408 (thanks to @MKleusberg)
+    - Add option for showing the text in the data browser view using a different encoding - #414 (thanks to @MKleusberg)
+    - Add option for setting an escape character for the filters in the data browser - #421 (thanks to @MKleusberg)
+    - Add a small delay before applying a new filter value instead of performing an instantaneous search to improve performance on large tables - #415 (thanks to @MKleusberg)
+    - Automatically add '%...%' wildcards to a filter query - #415 (thanks to @MKleusberg)
+    - Add Delete and Alt+Delete keyboard shortcuts for setting the current cell to empty string or NULL in the data browser view - #443 (thanks to @MKleusberg)
+    - Add new option for moving the Edit cell data dialog into a dock which is locked to the main window and stays opened - #416, #440, #441 (thanks to @MKleusberg)
+    - Allow drag-&-dropping text and files on a cell in the data browser - #441 (thanks to @MKleusberg)
+    - Add keyboard shortcuts for recently opened files - #432 (thanks to @MKleusberg)
+    - Add new option for setting a SQL script which gets executed whenever any database file is opened - #451 (thanks to @MKleusberg)
+    - Allow pasting data (e.g. from a spreadsheet) directly into the data browser view - #453 (thanks to @MilosSubotic)
+  * Bug fixes
+    - Fix missing SQL log when query contains a line break, also trim the log - #337, #356 (thanks to @schdub and @MKleusberg)
+    - Also set foreign key settings when creating a new database instead of just setting them when opening a file - 212116a (thanks to @MKleusberg)
+    - Fix drawing of Unicode characters in the SQL editor where the font settings wouldn't apply as they should have - #365 (thanks to @SevenLines)
+Allow values greater than 10000 in the user_version pragma of a database - #366 (thanks to @schdub)
+    - Fix adding new a record into a table where all fields are set to a default value - #369 (thanks to @schdub)
+    - Fix resizing of the code and result view in the Execute SQL area - 6806a9b (thanks to @MKleusberg)
+    - Fix error message when changing table - #390 (thanks to @MKleusberg and @GeorgijK)
+    - Fix parsing of double backticks and double quotes used to escape a single one in create table statements - 160bc87, dce47b3 (thanks to @MKleusberg)
+    - Fix handling of tables when their name contains a backtick - #387 (thanks to @MKleusberg)
+    - Try to set a better window position when opening the Edit cell data dialog - #342, #394 (thanks to @MKleusberg)
+    - Fix possible infinite loop in the Edit cell data dialog - #444 (thanks to @manisandro)
+    - Fix bug when pressing the cancel button in the dialog you see when you're closing a database with unsaved changes - #432 (thanks to @MKleusberg)
+    - Don't allow conflicting field names in the Edit Table dialog - #460 (thanks to @MKleusberg)
+  * Translations
+    - Add translation into Traditional Chinese - #425 (thanks to @PeterDaveHello)
+
 -------------------------------------------------------------------
 Thu Aug 13 12:29:25 UTC 2015 - stephan.barth@suse.com
 

sqlitebrowser.spec

@@ -1,7 +1,7 @@
 #
 # spec file for package sqlitebrowser
 #
-# Copyright (c) 2015 SUSE LINUX GmbH, Nuernberg, Germany.
+# Copyright (c) 2016 SUSE LINUX GmbH, Nuernberg, Germany.
 #
 # All modifications and additions to the file contributed by third parties
 # remain the property of their copyright owners, unless otherwise agreed
@@ -17,40 +17,37 @@
 
 
 Name:           sqlitebrowser
-Version:        3.7.0
+Version:        3.8.0
 Release:        0
 Summary:        Create, design and edit SQLite Databases
 License:        GPL-3.0+ or MPL-2.0
 Group:          Productivity/Office/Organizers
-Url:            https://github.com/rp-/sqlitebrowser/
+Url:            http://sqlitebrowser.org/
-# https://github.com/rp-/sqlitebrowser/releases
+Source0:        https://github.com/sqlitebrowser/sqlitebrowser/archive/v%{version}.tar.gz#/%{name}-%{version}.tar.gz
-Source0:        %{name}-%{version}.tar.gz
 Source1:        sqlitebrowser.1
-%if 0%{?suse_version}
-BuildRequires:  update-desktop-files
-%endif
-BuildRequires:  autoconf
-BuildRequires:  automake
 BuildRequires:  cmake
-BuildRequires:  gcc
 BuildRequires:  gcc-c++
 BuildRequires:  hicolor-icon-theme
-BuildRequires:  sqlite3-devel
 BuildRequires:  update-desktop-files
-%if 0%{?suse_version} > 1320
+BuildRequires:  pkgconfig(sqlite3)
+Requires(post): hicolor-icon-theme
+Requires(post): update-desktop-files
+Requires(postun): hicolor-icon-theme
+Requires(postun): update-desktop-files
+BuildRoot:      %{_tmppath}/%{name}-%{version}-build
+# not on SLE-12
+%if 0%{?suse_version} != 1315 || 0%{?is_opensuse}
+BuildRequires:  antlr-devel
 BuildRequires:  libqt5-linguist-devel
 BuildRequires:  pkgconfig(Qt5Gui)
 BuildRequires:  pkgconfig(Qt5Network)
 BuildRequires:  pkgconfig(Qt5PrintSupport)
 BuildRequires:  pkgconfig(Qt5Test)
 BuildRequires:  pkgconfig(Qt5Widgets)
+BuildRequires:  pkgconfig(glib-2.0)
 %else
 BuildRequires:  libqt4-devel
 %endif
-%if 0%{?suse_version} > 1100
-BuildRequires:  pkgconfig(glib-2.0)
-%endif
-BuildRoot:      %{_tmppath}/%{name}-%{version}-build
 
 %description
 SQLite Database Browser is a freeware, public domain, open source visual tool
@@ -75,19 +72,18 @@ to:
 %setup -q
 
 %build
-export CXXFLAGS="%optflags"
+%cmake \
-cmake \
+  %if 0%{?suse_version} != 1315 || 0%{?is_opensuse}
-%if 0%{?suse_version} > 1320
+  -DUSE_QT5=true \
--DUSE_QT5=true \
+  %endif
-%endif
+  -DCMAKE_BUILD_TYPE=RelWithDebInfo
--DCMAKE_INSTALL_PREFIX=%{_prefix} .
+make %{?_smp_mflags}
-make %{?_smp_mflags} VERBOSE=1
 
 %install
-make DESTDIR="%{buildroot}" install
+%cmake_install
 mkdir -p %{buildroot}/%{_bindir} %{buildroot}/%{_datadir}/{applications,pixmaps}
-install -Dm644 %{SOURCE1} %{buildroot}/%{_mandir}/man1/%{name}.1
+install -D -m 0644 %{SOURCE1} %{buildroot}/%{_mandir}/man1/%{name}.1
-install -m644 images/%{name}.png %{buildroot}/%{_datadir}/pixmaps/%{name}.png
+install    -m 0644 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;
@@ -99,26 +95,21 @@ Terminal=false
 Type=Application
 Icon=%{name}
 EOF
-%if 0%{?suse_version}
 %suse_update_desktop_file %{name}
-%endif
 
-%clean
-rm -fr %{buildroot}
-
-%if 0%{?suse_version} > 1130
 %post
 %desktop_database_post
+%icon_theme_cache_post
 
 %postun
 %desktop_database_postun
-%endif
+%icon_theme_cache_postun
 
 %files
 %defattr(-,root,root)
 %doc README.md LICENSE currentrelease
-%{_mandir}/man1/%{name}.1*
+%{_mandir}/man1/%{name}.1%{ext_man}
-%{_bindir}/*
+%{_bindir}/%{name}
 %{_datadir}/applications/*
 %dir %{_datadir}/appdata
 %{_datadir}/appdata/%{name}.desktop.appdata.xml