#
# spec file for package sqlitebrowser
#
# Copyright (c) 2014 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
# upon. The license for this file, and modifications and additions to the
# file, is the same license as for the pristine package itself (unless the
# license for the pristine package is not an Open Source License, in which
# case the license is the MIT License). An "Open Source License" is a
# license that conforms to the Open Source Definition (Version 1.9)
# published by the Open Source Initiative.

# Please submit bugfixes or comments via http://bugs.opensuse.org/
#


Name:           sqlitebrowser
Version:        3.4.0
Release:        0
Summary:        Create, design and edit SQLite Databases
License:        GPL-3.0+ and MPL-2.0
Group:          Productivity/Office/Organizers
Url:            https://github.com/rp-/sqlitebrowser/
# https://github.com/rp-/sqlitebrowser/releases
Source0:        sqlitebrowser-sqlitebrowser-ce41627.tar.bz2
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:  libQtWebKit-devel
BuildRequires:  libqt4-devel >= 4.6
BuildRequires:  sqlite3-devel
BuildRequires:  update-desktop-files
%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
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. Controls and wizards are available for users
to:

	* Create and compact database files
	* Create, define, modify and delete tables
	* Create, define and delete indexes
	* Browse, edit, add and delete records
	* Search records
	* Import and export records as text
	* Import and export tables from/to CSV files
	* Import and export databases from/to SQL dump files
	* Issue SQL queries and inspect the results
	* Examine a log of all SQL commands issued by the application

%prep
%setup -q -n sqlitebrowser-sqlitebrowser-ce41627

%build
cmake -DCMAKE_INSTALL_PREFIX=%{_prefix} .
make %{?_smp_mflags}

%install
make DESTDIR="%{buildroot}" install
mkdir -p %{buildroot}/%{_bindir} %{buildroot}/%{_datadir}/{applications,pixmaps}
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;
StartupNotify=true
Exec=%{_bindir}/%{name}
Name=%{name}
GenericName=SQLite Database browser
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

%postun
%desktop_database_postun
%endif

%files
%defattr(-,root,root)
%doc README.md LICENSE currentrelease
%{_mandir}/man1/%{name}.1*
%{_bindir}/*
%{_datadir}/applications/*
%{_datadir}/pixmaps/*
%{_datadir}/icons/hicolor/*/apps/sqlitebrowser.png

%changelog