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
|
%global _empty_manifest_terminate_build 0
Name: python-django-postgres-fuzzycount
Version: 0.1.7
Release: 1
Summary: A Django model manager providing fast / fuzzy counts for PostgreSQL database tables.
License: UNKNOWN
URL: http://github.com/stephenmcd/django-postgres-fuzzycount
Source0: https://mirrors.nju.edu.cn/pypi/web/packages/7d/c1/93d41c0d9265094d58644b4287597e866885c9ecf021f5bc92aab26b8e64/django-postgres-fuzzycount-0.1.7.tar.gz
BuildArch: noarch
%description
Up until PostgreSQL 9.2, ``COUNT`` queries generally required scanning
every row in a database table. With millions of rows, this can become
quite slow. One work-around for this is to query statistics in
PostgreSQL for an approximate row count, which in many cases is an
acceptable trade-off.
Given a table called ``bigdata``, the following query will return an
approximate row count::
SELECT reltuples FROM pg_class WHERE relname = 'bigdata';
You can read more information about `slow COUNT queries in PostgreSQL`_
in the PostgreSQL wiki.
What ``django-postgres-fuzzycount`` provides is a way of using this
approach directly in your Django model managers. It was originally
built for displaying statistics in the `kouio RSS reader`_, a popular alternative to Google Reader, that acquired over 5 million news articles
in its database during the first week of its launch.
%package -n python3-django-postgres-fuzzycount
Summary: A Django model manager providing fast / fuzzy counts for PostgreSQL database tables.
Provides: python-django-postgres-fuzzycount
BuildRequires: python3-devel
BuildRequires: python3-setuptools
BuildRequires: python3-pip
%description -n python3-django-postgres-fuzzycount
Up until PostgreSQL 9.2, ``COUNT`` queries generally required scanning
every row in a database table. With millions of rows, this can become
quite slow. One work-around for this is to query statistics in
PostgreSQL for an approximate row count, which in many cases is an
acceptable trade-off.
Given a table called ``bigdata``, the following query will return an
approximate row count::
SELECT reltuples FROM pg_class WHERE relname = 'bigdata';
You can read more information about `slow COUNT queries in PostgreSQL`_
in the PostgreSQL wiki.
What ``django-postgres-fuzzycount`` provides is a way of using this
approach directly in your Django model managers. It was originally
built for displaying statistics in the `kouio RSS reader`_, a popular alternative to Google Reader, that acquired over 5 million news articles
in its database during the first week of its launch.
%package help
Summary: Development documents and examples for django-postgres-fuzzycount
Provides: python3-django-postgres-fuzzycount-doc
%description help
Up until PostgreSQL 9.2, ``COUNT`` queries generally required scanning
every row in a database table. With millions of rows, this can become
quite slow. One work-around for this is to query statistics in
PostgreSQL for an approximate row count, which in many cases is an
acceptable trade-off.
Given a table called ``bigdata``, the following query will return an
approximate row count::
SELECT reltuples FROM pg_class WHERE relname = 'bigdata';
You can read more information about `slow COUNT queries in PostgreSQL`_
in the PostgreSQL wiki.
What ``django-postgres-fuzzycount`` provides is a way of using this
approach directly in your Django model managers. It was originally
built for displaying statistics in the `kouio RSS reader`_, a popular alternative to Google Reader, that acquired over 5 million news articles
in its database during the first week of its launch.
%prep
%autosetup -n django-postgres-fuzzycount-0.1.7
%build
%py3_build
%install
%py3_install
install -d -m755 %{buildroot}/%{_pkgdocdir}
if [ -d doc ]; then cp -arf doc %{buildroot}/%{_pkgdocdir}; fi
if [ -d docs ]; then cp -arf docs %{buildroot}/%{_pkgdocdir}; fi
if [ -d example ]; then cp -arf example %{buildroot}/%{_pkgdocdir}; fi
if [ -d examples ]; then cp -arf examples %{buildroot}/%{_pkgdocdir}; fi
pushd %{buildroot}
if [ -d usr/lib ]; then
find usr/lib -type f -printf "/%h/%f\n" >> filelist.lst
fi
if [ -d usr/lib64 ]; then
find usr/lib64 -type f -printf "/%h/%f\n" >> filelist.lst
fi
if [ -d usr/bin ]; then
find usr/bin -type f -printf "/%h/%f\n" >> filelist.lst
fi
if [ -d usr/sbin ]; then
find usr/sbin -type f -printf "/%h/%f\n" >> filelist.lst
fi
touch doclist.lst
if [ -d usr/share/man ]; then
find usr/share/man -type f -printf "/%h/%f.gz\n" >> doclist.lst
fi
popd
mv %{buildroot}/filelist.lst .
mv %{buildroot}/doclist.lst .
%files -n python3-django-postgres-fuzzycount -f filelist.lst
%dir %{python3_sitelib}/*
%files help -f doclist.lst
%{_docdir}/*
%changelog
* Mon May 15 2023 Python_Bot <Python_Bot@openeuler.org> - 0.1.7-1
- Package Spec generated
|