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

Name:             R-CRAN-%{packname}
Version:          2025.7.30
Release:          1%{?dist}%{?buildtag}
Summary:          An Abstracted System for Easily Working with Databases with Large Datasets

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-csutil 
BuildRequires:    R-CRAN-data.table 
BuildRequires:    R-CRAN-DBI 
BuildRequires:    R-CRAN-dplyr 
BuildRequires:    R-CRAN-fs 
BuildRequires:    R-CRAN-ggplot2 
BuildRequires:    R-CRAN-glue 
BuildRequires:    R-methods 
BuildRequires:    R-CRAN-odbc 
BuildRequires:    R-CRAN-R6 
BuildRequires:    R-CRAN-S7 
BuildRequires:    R-CRAN-stringr 
BuildRequires:    R-CRAN-uuid 
Requires:         R-CRAN-csutil 
Requires:         R-CRAN-data.table 
Requires:         R-CRAN-DBI 
Requires:         R-CRAN-dplyr 
Requires:         R-CRAN-fs 
Requires:         R-CRAN-ggplot2 
Requires:         R-CRAN-glue 
Requires:         R-methods 
Requires:         R-CRAN-odbc 
Requires:         R-CRAN-R6 
Requires:         R-CRAN-S7 
Requires:         R-CRAN-stringr 
Requires:         R-CRAN-uuid 

%description
Provides object-oriented database management tools for working with large
datasets across multiple database systems. Features include robust
connection management for SQL Server and PostgreSQL databases, advanced
table operations with bulk data loading and upsert functionality,
comprehensive data validation through customizable field type and content
validators, efficient index management, and cross-database compatibility.
Designed for high-performance data operations in surveillance systems and
large-scale data processing workflows.

%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}