Accepting request 139946 from home:deadpoint

Updated orafce to the latest git release which supports pg92 and reworked packaging to support multiple version of postgresql. There are 2 linked packages, postgresql9*-orafce, associated with this package. Please make me the maintainer.

OBS-URL: https://build.opensuse.org/request/show/139946
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/orafce?expand=0&rev=2
This commit is contained in:
Reinhard Max 2012-11-13 08:10:56 +00:00 committed by Git OBS Bridge
parent 253ccb7ffb
commit 7c03d65fc2
9 changed files with 319 additions and 12 deletions

View File

@ -1,3 +0,0 @@
version https://git-lfs.github.com/spec/v1
oid sha256:9d738784e8dcd62ea38615949a84d8da6ceefc085a01bbc1d2b60d1287d58ae1
size 110681

View File

@ -0,0 +1,3 @@
version https://git-lfs.github.com/spec/v1
oid sha256:0414d7f442fa2d4e89be32c691766cf5313befb2986d8b4e199201b2f7d7a661
size 110355

View File

@ -1,3 +1,22 @@
-------------------------------------------------------------------
Thu Nov 1 19:30:27 UTC 2012 - darin@darins.net
- updated name in template
- set proper install location
-------------------------------------------------------------------
Fri Oct 26 12:47:21 UTC 2012 - darin@darins.net
- added pre_checkin.sh to generate .spec and .changes
-------------------------------------------------------------------
Thu Oct 25 13:03:26 UTC 2012 - darin@darins.net
- updated to orafce-HEAD-36ccc5b from git repository which supports
postgresql 9.2. As there's no official release i'm calling it 5a
- created .specs to support multiple versions of PG
- removed/renamed orafce.spec
-------------------------------------------------------------------
Tue Dec 13 18:58:24 UTC 2011 - darin@darins.net

View File

@ -1,15 +1,20 @@
#
%define gitname HEAD-36ccc5b
%define pgversion ##
Name: orafce
Version: 3.0.4
Version: 3.0.5a
Release: 7
Summary: Implementation of some Oracle functions into PostgreSQL
Group: Productivity/Databases/Tools
License: BSD
URL: http://pgfoundry.org/projects/orafce/
Source0: http://pgfoundry.org/frs/download.php/2361/%{name}-%{version}.tar.gz
BuildRoot: %(mktemp -ud %{_tmppath}/%{name}-%{version}-%{release}-XXXXXX)
BuildRequires: postgresql-devel openssl-devel krb5-devel bison flex
Requires: postgresql-server
#Source0: http://pgfoundry.org/frs/download.php/2361/%{name}-%{version}.tar.gz
Source0: %{name}-%{gitname}.tar.gz
BuildRoot: %{_tmppath}/%{name}-%{version}-build
BuildRequires: postgresql%{pgversion}-devel openssl-devel krb5-devel bison flex
Requires: postgresql%{pgversion}-server
Provides: orafce
%description
The goal of this project is implementation some functions from Oracle database.
@ -18,7 +23,7 @@ now. Functionality was verified on Oracle 10g and module is useful
for production work.
%prep
%setup -q -n %{name}
%setup -q -n %{name}-%{gitname}
#sed -i 's/\r//' doc/style.css
%build
@ -34,7 +39,7 @@ rm -rf $RPM_BUILD_ROOT
%files
%defattr(-,root,root,-)
%doc COPYRIGHT.orafunc INSTALL.orafunc README.orafunc
%{_libdir}/postgresql/
%{_datadir}/postgresql/
%exclude %{_docdir}/postgresql/
%{_libdir}/postgresql%{pgversion}/
%{_datadir}/postgresql%{pgversion}/
%exclude %{_docdir}/postgresql%{pgversion}/

View File

@ -0,0 +1,90 @@
-------------------------------------------------------------------
Thu Nov 1 19:30:27 UTC 2012 - darin@darins.net
- updated name in template
- set proper install location
-------------------------------------------------------------------
Fri Oct 26 12:47:21 UTC 2012 - darin@darins.net
- added pre_checkin.sh to generate .spec and .changes
-------------------------------------------------------------------
Thu Oct 25 13:03:26 UTC 2012 - darin@darins.net
- updated to orafce-HEAD-36ccc5b from git repository which supports
postgresql 9.2. As there's no official release i'm calling it 5a
- created .specs to support multiple versions of PG
- removed/renamed orafce.spec
-------------------------------------------------------------------
Tue Dec 13 18:58:24 UTC 2011 - darin@darins.net
- Fixed non-standard Group
-------------------------------------------------------------------
Tue Dec 13 18:51:32 UTC 2011 - darin@darins.net
- added FLEX=/usr/bin/flex to make statement in %build.
See http://pgfoundry.org/forum/forum.php?set=custom&forum_id=410&style=nested&max_rows=25&submit=Change+View
-------------------------------------------------------------------
Tue Dec 13 18:34:07 UTC 2011 - darin@darins.net
- updated package to 3.0.4
-------------------------------------------------------------------
Tue Dec 13 16:28:51 UTC 2011 - darin@darins.net
- moved %changelog to .changes file
-------------------------------------------------------------------
Fri Apr 15 2011 - Darin Perusich <darin@darins.net>
- Ported to OpenSuSE
- Update to 3.0.3
-------------------------------------------------------------------
Wed Apr 28 2010 - Jean-Francois Saucier <jfsaucier@infoglobe.ca> - 3.0.1-3
- Rename back the package to orafce after discussion on devel list
-------------------------------------------------------------------
Mon Apr 19 2010 - Jean-Francois Saucier <jfsaucier@infoglobe.ca> - 3.0.1-2
- Make some cleanup as described in #251805
- Clean %%files section
- Rename the package back to postgresql-orafce to be consistent with other extensions
-------------------------------------------------------------------
Fri Oct 2 2009 - Devrim GUNDUZ <devrim@commandprompt.com> - 3.0.1-1
- Update to 3.0.1
- Remove patch0, it is in upstream now.
- Apply some 3.0 fixes to spec.
-------------------------------------------------------------------
Wed Aug 20 2008 - Devrim GUNDUZ <devrim@commandprompt.com> - 2.1.4-1
- Update to 2.1.4
-------------------------------------------------------------------
Sun Jan 20 2008 - Devrim GUNDUZ <devrim@commandprompt.com> - 2.1.3-2
- Spec file fixes, per bz review #251805
-------------------------------------------------------------------
Mon Jan 14 2008 - Devrim GUNDUZ <devrim@commandprompt.com> - 2.1.3-1
- Update to 2.1.3
-------------------------------------------------------------------
Fri Aug 10 2007 - Devrim GUNDUZ <devrim@commandprompt.com> - 2.1.1-1
- Update to 2.1.1
- Spec file cleanup
-------------------------------------------------------------------
Wed Aug 30 2006 - Devrim GUNDUZ <devrim@commandprompt.com> - 2.0.1-1
- Initial packaging

46
postgresql91-orafce.spec Normal file
View File

@ -0,0 +1,46 @@
#
%define gitname HEAD-36ccc5b
%define pgversion 91
%define realname orafce
Name: postgresql%{pgversion}-orafce
Version: 3.0.5a
Release: 7
Summary: Implementation of some Oracle functions into PostgreSQL
Group: Productivity/Databases/Tools
License: BSD
URL: http://pgfoundry.org/projects/orafce/
#Source0: http://pgfoundry.org/frs/download.php/2361/%{name}-%{version}.tar.gz
Source0: %{realname}-%{gitname}.tar.gz
BuildRoot: %{_tmppath}/%{name}-%{version}-build
BuildRequires: postgresql%{pgversion}-devel openssl-devel krb5-devel bison flex
Requires: postgresql%{pgversion}-server
Provides: orafce
%description
The goal of this project is implementation some functions from Oracle database.
Some date functions (next_day, last_day, trunc, round, ...) are implemented
now. Functionality was verified on Oracle 10g and module is useful
for production work.
%prep
%setup -q -n %{realname}-%{gitname}
#sed -i 's/\r//' doc/style.css
%build
make USE_PGXS=1 %{?_smp_mflags} FLEX=/usr/bin/flex
%install
rm -rf $RPM_BUILD_ROOT
make USE_PGXS=1 install DESTDIR=$RPM_BUILD_ROOT
%clean
rm -rf $RPM_BUILD_ROOT
%files
%defattr(-,root,root,-)
%doc COPYRIGHT.orafunc INSTALL.orafunc README.orafunc
%{_prefix}/lib/postgresql%{pgversion}/%{_lib}
%{_datadir}/postgresql%{pgversion}/
%exclude %{_docdir}/postgresql%{pgversion}/

View File

@ -0,0 +1,90 @@
-------------------------------------------------------------------
Thu Nov 1 19:30:27 UTC 2012 - darin@darins.net
- updated name in template
- set proper install location
-------------------------------------------------------------------
Fri Oct 26 12:47:21 UTC 2012 - darin@darins.net
- added pre_checkin.sh to generate .spec and .changes
-------------------------------------------------------------------
Thu Oct 25 13:03:26 UTC 2012 - darin@darins.net
- updated to orafce-HEAD-36ccc5b from git repository which supports
postgresql 9.2. As there's no official release i'm calling it 5a
- created .specs to support multiple versions of PG
- removed/renamed orafce.spec
-------------------------------------------------------------------
Tue Dec 13 18:58:24 UTC 2011 - darin@darins.net
- Fixed non-standard Group
-------------------------------------------------------------------
Tue Dec 13 18:51:32 UTC 2011 - darin@darins.net
- added FLEX=/usr/bin/flex to make statement in %build.
See http://pgfoundry.org/forum/forum.php?set=custom&forum_id=410&style=nested&max_rows=25&submit=Change+View
-------------------------------------------------------------------
Tue Dec 13 18:34:07 UTC 2011 - darin@darins.net
- updated package to 3.0.4
-------------------------------------------------------------------
Tue Dec 13 16:28:51 UTC 2011 - darin@darins.net
- moved %changelog to .changes file
-------------------------------------------------------------------
Fri Apr 15 2011 - Darin Perusich <darin@darins.net>
- Ported to OpenSuSE
- Update to 3.0.3
-------------------------------------------------------------------
Wed Apr 28 2010 - Jean-Francois Saucier <jfsaucier@infoglobe.ca> - 3.0.1-3
- Rename back the package to orafce after discussion on devel list
-------------------------------------------------------------------
Mon Apr 19 2010 - Jean-Francois Saucier <jfsaucier@infoglobe.ca> - 3.0.1-2
- Make some cleanup as described in #251805
- Clean %%files section
- Rename the package back to postgresql-orafce to be consistent with other extensions
-------------------------------------------------------------------
Fri Oct 2 2009 - Devrim GUNDUZ <devrim@commandprompt.com> - 3.0.1-1
- Update to 3.0.1
- Remove patch0, it is in upstream now.
- Apply some 3.0 fixes to spec.
-------------------------------------------------------------------
Wed Aug 20 2008 - Devrim GUNDUZ <devrim@commandprompt.com> - 2.1.4-1
- Update to 2.1.4
-------------------------------------------------------------------
Sun Jan 20 2008 - Devrim GUNDUZ <devrim@commandprompt.com> - 2.1.3-2
- Spec file fixes, per bz review #251805
-------------------------------------------------------------------
Mon Jan 14 2008 - Devrim GUNDUZ <devrim@commandprompt.com> - 2.1.3-1
- Update to 2.1.3
-------------------------------------------------------------------
Fri Aug 10 2007 - Devrim GUNDUZ <devrim@commandprompt.com> - 2.1.1-1
- Update to 2.1.1
- Spec file cleanup
-------------------------------------------------------------------
Wed Aug 30 2006 - Devrim GUNDUZ <devrim@commandprompt.com> - 2.0.1-1
- Initial packaging

46
postgresql92-orafce.spec Normal file
View File

@ -0,0 +1,46 @@
#
%define gitname HEAD-36ccc5b
%define pgversion 92
%define realname orafce
Name: postgresql%{pgversion}-orafce
Version: 3.0.5a
Release: 7
Summary: Implementation of some Oracle functions into PostgreSQL
Group: Productivity/Databases/Tools
License: BSD
URL: http://pgfoundry.org/projects/orafce/
#Source0: http://pgfoundry.org/frs/download.php/2361/%{name}-%{version}.tar.gz
Source0: %{realname}-%{gitname}.tar.gz
BuildRoot: %{_tmppath}/%{name}-%{version}-build
BuildRequires: postgresql%{pgversion}-devel openssl-devel krb5-devel bison flex
Requires: postgresql%{pgversion}-server
Provides: orafce
%description
The goal of this project is implementation some functions from Oracle database.
Some date functions (next_day, last_day, trunc, round, ...) are implemented
now. Functionality was verified on Oracle 10g and module is useful
for production work.
%prep
%setup -q -n %{realname}-%{gitname}
#sed -i 's/\r//' doc/style.css
%build
make USE_PGXS=1 %{?_smp_mflags} FLEX=/usr/bin/flex
%install
rm -rf $RPM_BUILD_ROOT
make USE_PGXS=1 install DESTDIR=$RPM_BUILD_ROOT
%clean
rm -rf $RPM_BUILD_ROOT
%files
%defattr(-,root,root,-)
%doc COPYRIGHT.orafunc INSTALL.orafunc README.orafunc
%{_prefix}/lib/postgresql%{pgversion}/%{_lib}
%{_datadir}/postgresql%{pgversion}/
%exclude %{_docdir}/postgresql%{pgversion}/

11
pre_checkin.sh Normal file
View File

@ -0,0 +1,11 @@
#!/bin/sh
#
VERS="91 92"
#
spec=orafce.spec.in
for ii in $VERS
do
sed "s/pgversion ##/pgversion $ii/" $spec > postgresql${ii}-orafce.spec
cp orafce.changes postgresql${ii}-orafce.changes
done