%global __brp_check_rpaths %{nil}
%global __requires_exclude ^libmpi
%global packname  db2pq
%global packver   0.0.4
%global rlibdir   /usr/local/lib/R/library

Name:             R-CRAN-%{packname}
Version:          0.0.4
Release:          1%{?dist}%{?buildtag}
Summary:          Export Database Tables to 'Parquet'

License:          MIT + file LICENSE
URL:              https://cran.r-project.org/package=%{packname}
Source0:          %{url}&version=%{packver}#/%{packname}_%{packver}.tar.gz


BuildRequires:    R-devel >= 4.1.0
Requires:         R-core >= 4.1.0
BuildArch:        noarch
BuildRequires:    R-CRAN-arrow 
BuildRequires:    R-CRAN-DBI 
BuildRequires:    R-CRAN-keyring 
BuildRequires:    R-CRAN-RPostgres 
BuildRequires:    R-CRAN-tibble 
BuildRequires:    R-tools 
BuildRequires:    R-CRAN-wrds 
Requires:         R-CRAN-arrow 
Requires:         R-CRAN-DBI 
Requires:         R-CRAN-keyring 
Requires:         R-CRAN-RPostgres 
Requires:         R-CRAN-tibble 
Requires:         R-tools 
Requires:         R-CRAN-wrds 

%description
Tools for exporting 'PostgreSQL' tables to 'Parquet' files, with support
for chunked writes, column type overrides, and timezone-aware timestamp
handling. Includes functions for maintaining a local 'Parquet' data
library sourced from 'WRDS' (Wharton Research Data Services), with
update-checking based on table metadata, and archive management utilities
for versioning local data files. See Gow and Ding (2024) "Empirical
Research in Accounting: Tools and Methods" <doi:10.1201/9781003456230>.

%prep
%setup -q -c -n %{packname}

# fix end of executable files
find -type f -executable -exec grep -Iq . {} \; -exec sed -i -e '$a\' {} \;
# prevent binary stripping
[ -d %{packname}/src ] && find %{packname}/src -type f -exec \
  sed -i 's@/usr/bin/strip@/usr/bin/true@g' {} \; || true
[ -d %{packname}/src ] && find %{packname}/src/Make* -type f -exec \
  sed -i 's@-g0@@g' {} \; || true
# don't allow local prefix in executable scripts
find -type f -executable -exec sed -Ei 's@#!( )*/usr/local/bin@#!/usr/bin@g' {} \;

%build

%install

mkdir -p %{buildroot}%{rlibdir}
%{_bindir}/R CMD INSTALL -l %{buildroot}%{rlibdir} %{packname}
test -d %{packname}/src && (cd %{packname}/src; rm -f *.o *.so)
rm -f %{buildroot}%{rlibdir}/R.css
# remove buildroot from installed files
find %{buildroot}%{rlibdir} -type f -exec sed -i "s@%{buildroot}@@g" {} \;

%files
%{rlibdir}/%{packname}