Name:           q-text-as-data
Version:        3.1.6
Release:        0%{?dist}.1sunshine
Summary:        Direct execution of SQL-like queries on tabular text files

License:        GPLv3
URL:            https://github.com/harelba/q
Source:         https://github.com/harelba/q/archive/refs/tags/v%{version}.tar.gz#/q-%{version}.tar.gz
Patch0:         0001-fix-warnings.patch
BuildArch:      noarch

BuildRequires:  rubygem-ronn

BuildRequires:  python3-devel
BuildRequires:  python3dist(six)
Requires:       python3


%description
q-text-as-data is a command line tool that allows direct execution of SQL-like
queries on CSVs/TSVs (and any other tabular text files).

q-text-as-data treats ordinary files as database tables, and supports all SQL
constructs, such as WHERE, GROUP BY, JOINs etc. It supports automatic column
name and column type detection, and provides full support for multiple
encodings.

%prep
%setup -qn q-%{version}
%patch -P 0 -p1

%build
ronn doc/USAGE.markdown
sed -i '1s,#!.*,#!%{__python3},' bin/q.py

%install
# NB: I am not 100% comfortable in using 'q' as the command name as
# hijacking the single-letter namespace seems a bit too much.
# Happy to be convinced otherwise
%{__install} -Dm 0755 bin/q.py ${RPM_BUILD_ROOT}%{_bindir}/q-text-as-data
%{__install} -d -m 0755 ${RPM_BUILD_ROOT}%{_mandir}/man1/
%{__install} -m 0644 doc/USAGE ${RPM_BUILD_ROOT}%{_mandir}/man1/q-text-as-data.1

%check
# Small smoketest
TMPFILE=$(mktemp)
cat > $TMPFILE <<EOF
"ID","Region","Service Name","Service Type","PublicURL","AdminURL","InternalURL"
"6b397af6a4ff4ac4b4b78cfb8d76d570","regionOne","nova","computev3","http://192.0.2.1:8774/v3","http://192.0.2.1:8774/v3","http://192.0.2.1:8774/v3"
"3c890b11cd8948e8b059ac46d77c1ce9","regionOne","keystone","identity","http://192.0.2.1:5000/v2.0","http://192.0.2.1:35357/v2.0","http://192.0.2.1:5000/v2.0"
"669015a773ba4f6191f7c71670af0eba","regionOne","ironic","baremetal","http://192.0.2.1:6385/","http://192.0.2.1:6385/","http://192.0.2.1:6385/"
"80de1938d3884f3197b6dc5525b2160e","regionOne","ceilometer","metering","http://192.0.2.1:8777/","http://192.0.2.1:8777/","http://192.0.2.1:8777/"
"50d58d82b16d4077854c4d7d6a963bff","regionOne","tuskar","management","http://192.0.2.1:8585/v2","http://192.0.2.1:8585/v2","http://192.0.2.1:8585/v2"
"1d113cd9848647eaa1b47f67af8db84b","regionOne","glance","image","http://192.0.2.1:9292/","http://192.0.2.1:9292/","http://192.0.2.1:9292/"
"735cbf3b583849c397a9eb8c3f1d0095","regionOne","neutron","network","http://192.0.2.1:9696/","http://192.0.2.1:9696/","http://192.0.2.1:9696/"
EOF
cat $TMPFILE | ./bin/q.py -d, -H "SELECT ID FROM -"
rm $TMPFILE

%files
%license doc/LICENSE
%doc %_mandir/man1/q-text-as-data.1.*
%doc README.markdown doc/AUTHORS doc/IMPLEMENTATION.markdown doc/RATIONALE.markdown doc/THANKS doc/USAGE.markdown 
%{_bindir}/q-text-as-data

%changelog
* Sun Aug 24 2025 Moritz Barsnick <moritz+rpm@barsnick.net> 3.1.6-0.1sunshine
- update to 3.1.6
- adapt to new source file name
- drop support for Python2
- add a patch for deprecations
- add new BR python3dist(six)

* Fri Jul 26 2019 Fedora Release Engineering <releng@fedoraproject.org> - 1.7.4-4
- Rebuilt for https://fedoraproject.org/wiki/Fedora_31_Mass_Rebuild

* Sat Feb 02 2019 Fedora Release Engineering <releng@fedoraproject.org> - 1.7.4-3
- Rebuilt for https://fedoraproject.org/wiki/Fedora_30_Mass_Rebuild

* Sat Jul 14 2018 Fedora Release Engineering <releng@fedoraproject.org> - 1.7.4-2
- Rebuilt for https://fedoraproject.org/wiki/Fedora_29_Mass_Rebuild

* Mon Mar 26 2018 Michele Baldessari <michele@acksyn.org> - 1.7.4-1
- New upstream

* Fri Feb 09 2018 Fedora Release Engineering <releng@fedoraproject.org> - 1.7.1-2
- Rebuilt for https://fedoraproject.org/wiki/Fedora_28_Mass_Rebuild

* Thu Dec 28 2017 Michele Baldessari <michele@acksyn.org> - 1.7.1-1
- New upstream

* Thu Jul 27 2017 Fedora Release Engineering <releng@fedoraproject.org> - 1.6.3-2
- Rebuilt for https://fedoraproject.org/wiki/Fedora_27_Mass_Rebuild

* Thu Apr 20 2017 Michele Baldessari <michele@acksyn.org> - 1.6.3-1
- New upstream release

* Fri Apr 07 2017 Michele Baldessari <michele@acksyn.org> - 1.6.2-1
- New upstream release

* Thu Apr 06 2017 Michele Baldessari <michele@acksyn.org> - 1.6.0-1
- New upstream

* Sat Feb 11 2017 Fedora Release Engineering <releng@fedoraproject.org> - 1.5.0-4
- Rebuilt for https://fedoraproject.org/wiki/Fedora_26_Mass_Rebuild

* Thu Feb 04 2016 Fedora Release Engineering <releng@fedoraproject.org> - 1.5.0-3
- Rebuilt for https://fedoraproject.org/wiki/Fedora_24_Mass_Rebuild

* Sun Jan 31 2016 Michele Baldessari <michele@acksyn.org> - 1.5.0-2
- Cleanups

* Tue Oct 13 2015 Michele Baldessari <michele@acksyn.org> - 1.5.0-1
- Initial packaging