%define beta b1
%define svn  r68

Name: sqlitebrowser
Version: 2.0
Release: %mkrel -c %svn 3

Summary:    Design and edit database files compatible with SQLite
License:    Public Domain
Group:      Databases
Url:        http://sqlitebrowser.sourceforge.net/index.html
#Source0:    http://heanet.dl.sourceforge.net/sourceforge/sqlitebrowser/%{name}_200_%{beta}_src.tar.gz
Source0:    http://heanet.dl.sourceforge.net/sourceforge/sqlitebrowser/%{name}-%{svn}.tar.xz
Patch0:     sqlitebrowser-2.0-fix-str-fmt.patch
Patch1:     sqlitebrowser-2.0-use_system_sqlite.patch

BuildRequires: qt4-devel
BuildRequires: sqlite3-devel

%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.

%prep
%setup -q -n %{name}/%{name}/%{name}
%patch0 -p0
%patch1 -p3
chmod 644 *txt

%build
%qmake_qt4
%make

%install
install -d -m 755 %{buildroot}/%{_bindir}
cp sqlitebrowser %{buildroot}/%{_bindir}/

install -d -m 755 %{buildroot}%{_datadir}/applications/
cat >%{buildroot}%{_datadir}/applications/%{name}.desktop <<EOF
[Desktop Entry]
Name=SQLite database browser
Comment=GUI editor for SQLite databases
TryExec=sqlitebrowser
Exec=sqlitebrowser
Icon=sqlitebrowser
Terminal=false
Type=Application
Categories=Development;Database;Qt;
MimeType=application/x-sqlite3;
EOF

install -m 644 -D images/128.png %{buildroot}%{_datadir}/icons/hicolor/128x128/apps/%{name}.png


%files
%doc *.txt
%{_bindir}/sqlitebrowser
%{_datadir}/applications/%{name}.desktop
%{_datadir}/icons/hicolor/128x128/apps/%{name}.png


%changelog

* Mon Jan 21 2013 malo <malo> 2.0-0.r68.3.mga3
+ Revision: 390337
- updated RPM group

* Mon Jan 14 2013 umeabot <umeabot> 2.0-0.r68.2.mga3
+ Revision: 382566
- Mass Rebuild - https://wiki.mageia.org/en/Feature:Mageia3MassRebuild

* Mon Jan 09 2012 jquelin <jquelin> 2.0-0.r68.1.mga2
+ Revision: 193814
- update buildrequires:
- fix patch to use system sqlite
- update to svn r68 to allow cooker migration (mga#4064)

* Thu Mar 03 2011 jquelin <jquelin> 2.0-0.b1.1.mga1
+ Revision: 63246
- patch to use system sqlite
- make it build
- fix str-fmt patch
- use system sqlite lib
- mageia rebuild
- imported package sqlitebrowser