#
# spec file for package sqlistebrowser
#
# 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.

# norootforbuild


Name:           sqlitebrowser
Summary:        Create, design and edit SQLite Databases 
Version:        2.0.2
Release:        1
License:        GPLv2
Group:          Productivity/Office/Organizers  
Url:            http://sqlitebrowser.sourceforge.net/
Vendor:         openSUSE-Education
Source0:        sqlitebrowser_200_b1a_src.tar.bz2
Patch0:         sqlitebrowser-libs.patch
%if 0%{?suse_version}
BuildRequires:  update-desktop-files
%endif
BuildRequires:  autoconf 
BuildRequires:  automake 
BuildRequires:  gcc 
BuildRequires:  gcc-c++ 
BuildRequires:  make
BuildRequires:  sqlite3-devel
BuildRequires:  libqt4-devel
BuildRequires:  libQtWebKit-devel
BuildRequires:  update-desktop-files
%if 0%{suse_version} > 1100
BuildRequires:  glib2-devel
%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 trunk/sqlitebrowser
%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}

%install
%makeinstall
mkdir -p %{buildroot}/%{_bindir} %{buildroot}/%{_datadir}/{applications,pixmaps}
install -m755 sqlitebrowser/sqlitebrowser %{buildroot}/%{_bindir}/
install -m644 sqlitebrowser/images/128.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 sqlitebrowser/*.txt
%{_bindir}/*
%{_datadir}/applications/*
%{_datadir}/pixmaps/*

%changelog