# # This requires a working Oracle installation to build with a set ORACLE_HOME # environment. Requires at least version 8.1.7 of Oracle. # %define _prefix /opt/kde3 Summary: Toolkit for Oracle Summary: Toolkit fuer Oracle Name: tora Version: 1.3.22 Release: 0.subik Source0: tora-1.3.22.tar.bz2 #Patch0: tora-g++4.1.patch #Patch1: tora-1.3.21.patch URL: http://tora.sourceforge.net/ Group: Development/Databases Packager: Petr Vanek #Distribution: openSUSE 10.2 (i586) License: GPL BuildRoot: %{_tmppath}/buildroot-%{name}-%{version} Prefix: %{_prefix} BuildRequires: qt3-devel-tools qscintilla-devel BuildRequires: oracle-instantclient-devel = 10.2.0.3 AutoReqProv: off Requires: oracle-instantclient-basic Requires: expat Requires: fam Requires: fontconfig Requires: freetype2 Requires: glibc Requires: libart_lgpl Requires: libgcc Requires: libidn Requires: libjpeg Requires: libpng Requires: libstdc++ Requires: pcre Requires: qt3 Requires: xorg-x11-libs Requires: zlib Requires: qscintilla Requires: kdelibs3 %description Toolkit for Oracle is a program for database developers and administrators. The features that are available so far is (As of version 1.2): * Handles multiple connections * Support Oracle, MySQL & PostgreSQL * Advanced SQL Worksheet * Explain plan * PL/SQL auto indentation * Statement statistics * Error location indication * SQL syntax highlighting * Code completion * Visualization of result * PL/SQL block parsing * Statement statistics comparison * Schema browser * Table & view editing * References & dependencies * Reverse engeneering of objects * Tab & tree based browsing * Object & data filtering * PL/SQL Editor/Debugger * Breakpoints * Watches * Line stepping * SQL Output viewing * Structure tree parsing * Server tuning * Server overview * Tuning charts * Wait state analyzer * I/O by tablespace & file * Performance indicators * Server statistics * Parameter editor (P-file editor) * Security manager * Storage manager with object & extent viewer * Session manager * Rollback manager with snapshot too old detection * SGA and long operations trace * Current session information * PL/SQL profiler * Explain plan browser * Statistics manager * DBMS alert tool * Invalid object browser * SQL Output viewer * Database/schema comparison and search * Extract schema objects to SQL script * Easily extendable * Possible to add support for new or older Oracle versions without programming. * SQL template help * Full UNICODE support * Printing of any list, text or chart This build is compiled with KDE. This build works with instantclient 10g or 10g database and MAYBE with other oracle installations. Client can be downloaded from http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html %prep %setup -q #%patch #%patch1 #autoreconf -sfi export QTDIR=/usr/lib/qt3 %configure --enable-plugin\ --prefix="%{_prefix}" \ --with-kde --with-xinerama --enable-mono\ --with-qt-libraries="$QTDIR"/%{_lib}\ --with-qt-dir="$QTDIR"\ --with-oracle-includes=/usr/include/oracle/10.2.0.3/client\ --with-oracle-libraries=/usr/%{_lib}/oracle/10.2.0.3/client/lib\ --with-instant-client --with-oci-version=10G %build %{__make} %install [ -d ${RPM_BUILD_ROOT} -a "${RPM_BUILD_ROOT}" != "/" ] && %{__rm} -rf "${RPM_BUILD_ROOT}" %{__make} DESTDIR="${RPM_BUILD_ROOT}" install-strip install -d $RPM_BUILD_ROOT%_libdir/%name install -d $RPM_BUILD_ROOT/usr/share/applications install rpm/%name.desktop $RPM_BUILD_ROOT/usr/share/applications/%name.desktop install -d $RPM_BUILD_ROOT/usr/share/pixmaps install src/icons/%name.xpm $RPM_BUILD_ROOT/usr/share/pixmaps/%name.xpm install -d $RPM_BUILD_ROOT/usr/share/info install doc/help/%name.info $RPM_BUILD_ROOT/usr/share/info/%name.info cp -r doc/help $RPM_BUILD_ROOT%_libdir/%name/ install src/templates/* $RPM_BUILD_ROOT%_libdir/%name/ %suse_update_desktop_file %name Office Database # HACK: there is something screwed in the install phase propably rm -rf $RPM_BUILD_ROOT%_libdir/help rm -r $RPM_BUILD_ROOT/opt/kde3/share/info/%name.info # Should we use chex in the production env? I don't think so... rm -r $RPM_BUILD_ROOT%_bindir/chex %clean [ -d ${RPM_BUILD_ROOT} -a "${RPM_BUILD_ROOT}" != "/" ] && %{__rm} -rf "${RPM_BUILD_ROOT}" %files %defattr(-,root,root) %_bindir/%name %attr(644,root,root) %_libdir/%name/*.tpl /usr/share/pixmaps/%name.xpm /usr/share/applications/%name.desktop /usr/share/info/%name.info.gz %doc %_libdir/%name/help/* %doc AUTHORS BUGS ChangeLog COPYING INSTALL LICENSE.txt NEWS README* TODO # TODO: translation are unfinished. But install it anyway into proper place. /opt/kde3/lib/tora_fr.qm /opt/kde3/lib/tora_it.qm /opt/kde3/lib/tora_se.qm /opt/kde3/lib/tora_toad.qm %changelog * Thu Sep 18 2007 - 1.3.22 - version bump * Fri Jan 19 2007 - 1.3.21 - removed hard wired requires versions * Wed Apr 19 2006 - <1.3.21>-<0.pm.2> - added template functions - build is now based on instant client * Sun Nov 27 2005 - 1.3.21-0.pm.4 - added helpfiles - thx to peter.roehrig@westnet.com.au * Fri Jul 1 2005 - <1.3.18>-<0.pm.0> - adjusted to new build schema - mono build required; so are not build correctly! - removed oracle subpackage * Thu Mar 17 2005 Rainer Lay 1.3.21-0.pm.4 - first packman release * Sun Dec 19 2004 Rainer Lay 1.3.14.1-0.pm.2 - added some patches * Mon Mar 10 2003 Henrik Johnson - change description of Oracle package to reflect needing an Oracle Client installation. * Mon Mar 10 2003 Henrik Johnson - added the oracle preload and a LD_LIBRARY_PATH setup to make compilation work without Oracle in your ld.so path. - also added a workaround of the whole requires problem for the Oracle package. - changed version to 1.3.10. * Mon Mar 10 2003 Henrik Johnson - added comment about fixing requires problem. * Sun Mar 9 2003 Henrik Johnson - adapted to Mandrake Linux. * Tue Dec 18 2001 Henrik Johnson - created from SuSE specfile by Pascal Bleser.