1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
|
# This specfile is Mandrake Linux specific
#
# This requires a working Oracle installation to build with a set ORACLE_HOME
# environment. Requires at least version 8.1.7 of Oracle.
#
%define _name tora
%define _version 1.3.15
%define _release 1mdk
%define _prefix /usr
%define _qtdir /usr/lib/qt3
Summary: Toolkit for Oracle
Name: %{_name}
Version: %{_version}
Release: %{_release}
Source: %{_name}-%{_version}.tar.gz
URL: http://tora.sourceforge.net
Group: Development/Databases
Packager: Nathan Neulinger <nneul@umr.edu>
Distribution: Mandrake Linux Cooker
Copyright: GPL
BuildRoot: %{_tmppath}/tora-root
Prefix: %{_prefix}
%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 and Mandrake Menu support.
%package oracle
Summary: Oracle specific plugins for %{_name}
Group: Development/Databases
Requires: %{_name} = %{_version}
Autoreq: 0
%description oracle
Oracle specific plugins for %{_name}. This plugin will require a valid installation
of an Oracle Client of version 8.1 or later to function that can be downloaded by
a free registration from Oracle Technet from http://technet.oracle.com. NOTE: You
will require to download the entire server distribution to install the client, but
it is available as a choice in the installer.
%changelog
* Thu Feb 17 2005 Nathan Neulinger <nneul@umr.edu>
- updates for new package maintainer
%prep
%setup -q
export QTDIR="%{_qtdir}"
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:$ORACLE_HOME/lib"
CFLAGS="$RPM_OPT_FLAGS" \
CXXFLAGS="$RPM_OPT_FLAGS" \
./configure \
--prefix="%{_prefix}" \
--prefix-bin="%{_prefix}/bin" \
--prefix-lib="%{_prefix}/lib" \
--with-qt="%{_qtdir}" \
--with-kde \
--without-rpath \
--with-rpm-contents="%{_prefix}/lib"
%build
export QTDIR="%{_qtdir}"
%{__make}
%{__strip} \
plugins/*.tso \
tora
# Ugly hack to remove version from libclntsh.so, if someone knows a better way please let me know
perl -pi -e 's/libclntsh.so.\d.\d/libclntsh.so\0\0\0\0/g' plugins/tooracleconnection.tso
%install
%{__rm} -rf "${RPM_BUILD_ROOT}"
%{__mkdir_p} "${RPM_BUILD_ROOT}%{_prefix}/bin"
%{__mkdir_p} "${RPM_BUILD_ROOT}%{_prefix}/lib"
%{__make} \
ROOT="${RPM_BUILD_ROOT}" \
install
mkdir -p $RPM_BUILD_ROOT%{_menudir}
cp rpm/tora.menu $RPM_BUILD_ROOT%{_menudir}/tora
%post
%{update_menus}
%postun
%{clean_menus}
%clean
%{__rm} -rf "${RPM_BUILD_ROOT}"
%files -f rpmcommon
%defattr(-,root,root)
%doc BUGS INSTALL LICENSE.txt NEWS README TODO
%{_prefix}/bin/*
%dir %{_prefix}/lib/tora
%{_prefix}/lib/tora/*.tpl
%{_prefix}/lib/tora/*.qm
%{_prefix}/lib/tora/help
%{_menudir}/tora
%{_iconsdir}/hicolor/*/apps/tora.xpm
%{_datadir}/applnk/Development/tora.desktop
%files oracle -f rpmoracle
%defattr(-,root,root)
|