From b88384b91e38ffeb6076409ca4554bdb6e778943 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Elan=20Ruusam=C3=A4e?= <glen@delfi.ee>
Date: Sat, 26 Apr 2014 01:21:38 +0300
Subject: [PATCH] add desktop integration

---
 desktop.patch            | 12 ++++++++++++
 oracle-sqldeveloper.spec | 18 +++++++++++++++++-
 2 files changed, 29 insertions(+), 1 deletion(-)
 create mode 100644 desktop.patch

diff --git a/desktop.patch b/desktop.patch
new file mode 100644
index 0000000..6a92aae
--- /dev/null
+++ b/desktop.patch
@@ -0,0 +1,12 @@
+--- oracle-sqldeveloper-4.0.1.14.48/sqldeveloper.desktop~	2014-04-25 23:47:57.000000000 +0300
++++ oracle-sqldeveloper-4.0.1.14.48/sqldeveloper.desktop	2014-04-26 01:11:50.603400337 +0300
+@@ -2,7 +2,8 @@
+ Encoding=UTF-8
+ Name=SQL Developer
+ Comment=Oracle SQL Developer
+-Icon=/opt/sqldeveloper/icon.png
++Icon=sqldeveloper
+ Exec=sqldeveloper
+ Terminal=false
+ Type=Application
++Categories=Database;Development;
diff --git a/oracle-sqldeveloper.spec b/oracle-sqldeveloper.spec
index 7260c59..6e84b0d 100644
--- a/oracle-sqldeveloper.spec
+++ b/oracle-sqldeveloper.spec
@@ -1,13 +1,15 @@
 Summary:	Oracle SQL Developer
 Name:		oracle-sqldeveloper
 Version:	4.0.1.14.48
-Release:	0.1
+Release:	0.2
 License:	OTN (proprietary, non-distributable)
 Group:		Applications/Databases
 Source0:	http://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-%{version}-1.noarch.rpm
 # NoSource0-md5:	8342e4369904d731af20f9020701b708
 URL:		http://www.oracle.com/technetwork/developer-tools/sql-developer/
 BuildRequires:	rpm-utils
+Patch0:		desktop.patch
+Requires:	desktop-file-utils
 BuildArch:	noarch
 BuildRoot:	%{tmpdir}/%{name}-%{version}-root-%(id -u -n)
 
@@ -38,17 +40,31 @@ rm sqldeveloper/sqldeveloper/bin/*-Darwin.conf
 rm sqldeveloper/sqldeveloper/bin/SQLDeveloperIcons.icns
 rm sqldeveloper/view-source-paths.lis
 
+%patch0 -p1
+
 %install
 rm -rf $RPM_BUILD_ROOT
 install -d $RPM_BUILD_ROOT%{_appdir}
 cp -l readme.html $RPM_BUILD_ROOT/cp-test && l=l && rm -f $RPM_BUILD_ROOT/cp-test
 cp -a$l sqldeveloper/* $RPM_BUILD_ROOT%{_appdir}
 
+install -d $RPM_BUILD_ROOT{%{_desktopdir},%{_pixmapsdir}}
+cp -p sqldeveloper.desktop $RPM_BUILD_ROOT%{_desktopdir}
+cp -p icon.png $RPM_BUILD_ROOT%{_desktopdir}/sqldeveloper.png
+
 %clean
 rm -rf $RPM_BUILD_ROOT
 
+%post
+%update_desktop_database
+
+%postun
+%update_desktop_database
+
 %files
 %defattr(644,root,root,755)
+%{_desktopdir}/sqldeveloper.desktop
+%{_desktopdir}/sqldeveloper.png
 %dir %{_appdir}
 %{_appdir}/configuration
 %{_appdir}/dataminer
-- 
2.44.0